How to convert data from HORIZONS to an SSC-defined orbit?
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.
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 authorSpaceFanatic64 - Posts: 427
- Joined: 16.08.2018
- Age: 19
- With us: 6 years 5 months
- Location: Southern California
How to convert data from HORIZONS to an SSC-defined orbit?
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?
If you see that I made a dumb or nonsensical post years ago, please forgive me in advance.
-
gironde
- Posts: 854
- Joined: 16.12.2016
- Age: 72
- With us: 8 years 1 month
- Location: Montigny-Les-Metz, France
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.
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.
- Attachments
-
