Page 1 of 1

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

Posted: 09.09.2018, 15:34
by SpaceFanatic64
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?

Posted: 10.09.2018, 08:09
by gironde
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: