How to convert data from HORIZONS to an SSC-defined orbit?

Have a question about using Celestia? Check here first for FAQs and helpful advice.
Forum rules
Please help to make this forum more useful by checking the FAQs before posting! Keep it clean, keep it civil, keep it truthful, stay on topic, be responsible, share your knowledge.
Topic author
Posts: 400
Joined: 16.08.2018
Age: 13
With us: 1 year 3 months
Location: Southern California

How to convert data from HORIZONS to an SSC-defined orbit?

Post #1by SpaceFanatic64 » 09.09.2018, 15:34

I successfully generated an ephemeris from the HORIZONS Web-Interface, but when I converted the orbit to Celestia, the orbit was way too small and was inside the target it was orbiting around. Does anyone know how to successfully convert HORIZONS data to Celestia's format?
Follower of the "Celestia Origin" project
Graphics Card: ATI Radeon 3000 Graphics

gironde M
Posts: 409
Joined: 16.12.2016
Age: 67
With us: 2 years 11 months
Location: Montigny-Les-Metz, Grand Est, Lorraine, Moselle, France

Post #2by gironde » 10.09.2018, 08:09

In Horizons, you have to select the right parameters.

The output file is in ssc format.
Change the extenssion to .txt

open a blank excel spreadsheet

open the .txt file in file mode, 'txt,ssc' and retrieve ssc formatting (the fields are separated by ",".

In the generated array, you have to remove the comment lines and keep only the lines that are needed for the orbit.
The 'concatener' function retrieves the columns of each row in a new column. Each information must be separated by a 'space' for .xyz or .xyzv files.
= CONCATENER (P4; ""; S4; ""; T4; ""; U4) (french version), in English = CONCAT (P4; ""; S4; ""; T4; ""; U4)
P4 is the cell containing the date
S4 is the cell containing X
T4 is the cell containing Y
U4 is the cell containing Z

please note that there is " " which is inserted between each data.

copy the generated column for each line and paste them into a text file with the extension .xyz or xyzv.


Return to “Help Central”

Who is online