Celestia Excel Content Builder
Posted: 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
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