Rip the Satellite Situation Report

I recently discovered I needed the data in the "Satellite Situation Report" in a more usable form. So, I've added an option to the Main Screen Utilities menu to "Rip Sat Sit Report to CSV". This file is easily loaded into Microsoft Excel for further processing.

This screen opens:

If you have the Satellite Situation report saved on your system in the format I require, and you have set the paths to those files within Element Manager (Setup Screen - Data Files Tab) then the program suggests the on orbit and decayed report filenames. To see how to get these files and whip them into the format required by Element Manager see the Satellite Situation Report Page.

If you don't have those files entered on the Setup Screen then you can use the browse buttons to find them.

Next, click browse beside the Output file box and enter in a name for the resulting Comma Delimited text file.

Next select which file to process. You can run only the satellites in orbit, the decayed birds only or, you can create one massive spreadsheet of both.

Data Exported

	Satellite name
	Norad Catalog Number
	International Launch Designator
	Country of Origin (an abbreviation) the key is available within the Sat Sit Report
	Inclination of the Satellite
	Orbital Period (in minutes)
	Apogee (Measurement system dependant on the current settings within Element Manager)
	Perigee (same dependency)
	Radar Cross Section in Sq. Meters.
	Launch Date
	Launch Age (age of satellite from launch to your computer's system time in days)
	Decay Date
	Decay Age (age of satellite from decay to your computer's system time in days)

Notes

The size of the March 31, 2003 combined exported file is 2.49 MB.

The size of the On Orbit satellites only is 775 KB.

Example File

Here is a small example of the output (99 satellites)

satsitrpt_example.csv

last edit 27-Nov-2005
maintained by Rick von Glahn