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.
Avatar
Topic author
SpaceFanatic64
Posts: 62
Joined: 16.08.2018
Age: 13
With us: 1 month 6 days
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?
The universe has no boundaries. The further you go, the more you'll discover.

Avatar
gironde M
Posts: 234
Joined: 16.12.2016
Age: 65
With us: 1 year 9 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)
where
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.


:hi:
Attachments
Horizons.jpg


Return to “Help Central”

Who is online

Users browsing this forum: 2 guests
Bots: Majestic-12 [Bot]