Traveller Excel Subsector Generator

[KenHR]

EDIT: Youshare hasn't been working for a long time. PM me or email me at krutskyATgmailDOTcom for a copy.

I have updated my Subsector Generator for Excel and placed it here for download:

http://www.youshare.com/KenHR/a28434/DisplayAdvanced

Currently 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]

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!

 

[the angle]

I'd like to take a look at it, but I can't get anything to download from YouShare. Is there some trick I'm missing?

Steve

 

[KenHR]

Argh. I have a question in to support on that.

I'll let folks know when that's sorted out. Meanwhile, I'm happy to e-mail the file to any that ask.

 

[aramis]

Just upload it to the files section of the BBS... that's what it's there for!

 

[KenHR]

The files are downloading properly now. Must be a download limit.

I should upload the files here. As its still a WIP I wasn't sure if I should yet.

 

[deniable]

You can always post it, then go back later and edit the post/replace the file. I've done it before.

 

[the angle]

Got it now.

As someone who uses Excel chiefly as a tool for analyzing statistics and probability, this level of Excel-fu astounds me.

Steve

 

[aramis]

You can always post it, then go back later and edit the post/replace the file. I've done it before.

Quoted for Truth

 

[KenHR]

Upload attempts failed.

 

[aramis]

You have to zip almost everything to upload it.

 

[KenHR]

Thanks for the tip. I'll do that!

 

[KenHR]

My home computer is having problems, so I've been unable to run my zip utility at home. In the meantime:

Updated to v0.2c. 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]

Updated to 0.2a. Note to self: macros do not update range references when you move stuff around on a worksheet.

 

[KenHR]

Was unable to log in for a long time for some reason. I had some PMs last year asking for a copy of the spreadsheet. I'll be happy to send along to anyone who is interested. PM me or e-mail me at krutskyATgmailDOTcom (replace "AT" and "DOT" with the appropriate symbols).