Celestia Excel Content Builder

[scoopey]

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

[Drydareelin]

Really good job with this!

[scoopey]

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!

[scoopey]

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