I wrote this excel spreadsheet in a few hours that basically goes through all 1280 hexes in a sector and randomly generates a UWP for any systems that exist. I know there is other stuff out there that do a better job, but nothing so quick and easy to use. It uses TNE rules, with some options from GURPS Ground Forces, MM Imperial Squadrons, and probably another source or two I'm forgetting about.
http://www.cooltexan.com/SectorGenerator.xls
(case sensitive, around 8mb)
Anyway, enjoy.... let me know if you find any bugs or have any input.... Oh, quick "how to":
The numbers above the table are usually averages, min's, max's, totals, etc....
The ONLY thing you need to edit would be in yellow, and thats the system density (Rift, Standard, Dense, Very Dense, Sparse - case sensitive) and Maturity (Backwater, Mature, Standard, Cluster - case sensitive).
Once you change those the spreadsheet updsates automatically, basically do *anything* and the entire sheet updates. If you like what you see simply CTRL-A to select everything, CTRL-C to copy, start a new workbook, then go to Edit-PasteSpecial and select Values only, then it becomes static.
Anyway, just a quick something I put together that hopefully somebody else will find a use for (I got tons of this stuff!).
Bad Syntax
http://www.cooltexan.com/SectorGenerator.xls
(case sensitive, around 8mb)
Anyway, enjoy.... let me know if you find any bugs or have any input.... Oh, quick "how to":
The numbers above the table are usually averages, min's, max's, totals, etc....
The ONLY thing you need to edit would be in yellow, and thats the system density (Rift, Standard, Dense, Very Dense, Sparse - case sensitive) and Maturity (Backwater, Mature, Standard, Cluster - case sensitive).
Once you change those the spreadsheet updsates automatically, basically do *anything* and the entire sheet updates. If you like what you see simply CTRL-A to select everything, CTRL-C to copy, start a new workbook, then go to Edit-PasteSpecial and select Values only, then it becomes static.
Anyway, just a quick something I put together that hopefully somebody else will find a use for (I got tons of this stuff!).
Bad Syntax