Celestia Excel Content Builder

Here you find pointers to utilities that help you create addons for Celestia.
Topic author
scoopey
Posts: 10
Joined: 09.07.2012
With us: 7 years 3 months

Celestia Excel Content Builder

Post #1by scoopey » 18.07.2012, 22:21

As much reworking of my original, I've expanded by original SSC builder.
Using VBa Macros in Excel, there area total of four utilities on different sheets

SSC builder - Creates SSC files and exports them directly
I've tried to included most of the scripting keyword option but the body and orbit frames are absent.
Now features the means to add template data from each of the Solar System planets featured in Celestia so that you have a basis for creating custom worlds

STC builder - Created STC files and exports them directly
As above but this is for creating Barycenters and Star addons for Celestia

Orbital Period Calculator
A slight reworking of World Builder's Excel file.
Once the period has been calculated the data can then be sent straight to the SSC builder - No copying and pasting needed!

Astrosynthesis Star Plotter
Played with Nobos software's Astrosythesis and want to move some of your star systems to Celestia, then this is the utility for you.
Working on the basis that the central Z axis in the system is pointing at Earth, simply fill in whereabouts you would like to position this grid in Celestia (RA, Declination and Distance)
Then simply choose a star in Astrosythesis and copy the data to the appropiate boxes.
As most of the stars parameters are comparitive to Sol as opposed to proper magnitudes, the utility does all the conversions for you, including the differences between "special" spectral codes exclusive to Astrosynthesis
Once you have entered your star data it can be transfered to the STC creator to edit further by a press of a button or it can automatically transfer the data and produce an STC file without ever leaving the Excel page..perfect for bulk transfers.
NOTE THE PLOTTER CANNOT BE USED FOR MULTIPLE STAR SYSTEMS IN ASTROSYNTHESIS

http://www.mediafire.com/?2o4t7qumdbc3j29
NOTE MACRO's SHOULD BE ENABLED WITH THESE UTILITIES
AS MACROS ARE A KNOWN SOURCE FOR VIRUSES I HAVE CHECKED THE FILE THOROUGHLY BUT MAKE SURE YOU HAVE AN UP TO DATE ANTIVIRUS PROGRAM SHOULD ANYONE ELSE HAVE AMMENED OR ALTERED THE FILE IN ANY WAY. I DO NOT TAKE RESPONSIBILTY IF ANY HARM COMES TO YOUR COMPUTER FROM USING THIS UTILITY.

**Bug Fix List (updated as I find and fix bugs!)**
Locked cell prevented user changing specularity from dds to png - fixed
Specularity map statement could be created when no speuclarity setting used - fixed
Oblateness data could not beg inserted due to a protected cell I missed - fixed
User save location sent to wrong cell in STC creator caused VBa to send an error statement - fixed
Last edited by scoopey on 19.07.2012, 23:04, edited 4 times in total.

Drydareelin
Posts: 20
Joined: 04.01.2012
Age: 24
With us: 7 years 9 months
Location: England, UK

Re: Celestia Excel Content Builder

Post #2by Drydareelin » 19.07.2012, 11:49

Really good job with this!

Topic author
scoopey
Posts: 10
Joined: 09.07.2012
With us: 7 years 3 months

Re: Celestia Excel Content Builder

Post #3by scoopey » 19.07.2012, 18:31

Thanks
I noticed yours after completing the first stage...
Unearthed another bug with a protected cell that stopped the oblateness data being "injected".

If there is enough demand I might do a "Data" reversal whereby users can save data from STCs or SSC in another spreadsheet for later use..but first I got to get this thing operating with zero bugs!

Topic author
scoopey
Posts: 10
Joined: 09.07.2012
With us: 7 years 3 months

Re: Celestia Excel Content Builder Update

Post #4by scoopey » 20.07.2012, 19:04

After a lot of head scratching as I'm not that well up on Astronomy maths, I updated the Orbital period Calculator section so it will now compute ordbit times for Satellites of planets as well as planets moving around a star.
Also on this update, I removed the "months" setting from the orbital period section of the SSC creator, as months are not really a standard time measure as they vary in days (yes so do years but at least there is an SI unit for that!)
New link is here...
http://www.mediafire.com/?ynlsl8cpk1584bl


Return to “Utilities”

Who is online

Users browsing this forum: 3 guests