kenhr
Level 2 Seer
Posts: 35
|
Post by kenhr on Apr 23, 2009 21:29:41 GMT -6
I have updated my Subsector Generator for Excel and placed it here for download: www.youshare.com/KenHR/a28434/DisplayAdvancedCurrently generates a subsector (using the MongTrav "Hard Science" and "Space Opera" mods), calculates trade between any two systems on the map, generates a full set of encounter tables for any mainworld, and generates solar systems using the Scouts rules. Lots of little bugs still, but this is an ongoing project. Let me know what you think!
|
|
kenhr
Level 2 Seer
Posts: 35
|
Post by kenhr on Apr 26, 2009 7:15:27 GMT -6
Updated to 0.1c. You can now choose Classic LBB3 UWP generation or use the Mongoose Traveller Hard Science and Space Opera procedures.
Still working on a method to allow manual entry of UWPs and to freeze UWP values in place.
Also trying to get a macro-less version working...but even though I erase the macros, the computer still thinks there is VBA code in the file!
|
|
kenhr
Level 2 Seer
Posts: 35
|
Post by kenhr on May 13, 2009 10:00:07 GMT -6
Updated to v0.2. Added a manual entry tab, allowing you to enter your own UWP data or modify randomly generated data. WARNING: SAVE THE SPREADSHEET UNDER A NEW FILENAME BEFORE EXPORTING YOUR MANUAL DATA AS THIS WILL ELIMINATE THE CALCULATION FORMULAE FOR RANDOM GENERATION.
I will be adding a speculative trade module to the sheet down the road, but most modifications from here on out are going to concentrate on improving the sheet's flow and fixing stuff that's not working properly with solar system generation (this will require me to buff up on my VBasic).
If you have problems downloading, feel free to PM me if you'd like to check it out and I'll gladly e-mail a copy.
|
|
kenhr
Level 2 Seer
Posts: 35
|
Post by kenhr on May 15, 2009 8:39:50 GMT -6
Updated to 0.2a. Note to self: macros do not update range references when you move stuff around on a worksheet.
|
|