This excel file will generate systems based on the 1280 hexes in a sector.
The 2 yellow columns are input (the only place you input anything).
System Density: Sparse, Scattered, Standard, Dense, Very Dense (these are case sensitive)
Subsecture Maturity: Backwater, Mature, Standard, Cluster (these are case sensitive)
Also, you'll need to add support for the Analysis toolpack, go to Tools->Addins and select that option. If you dont have this selected the RANDBETWEEN function breaks and the sucker wont work.
Feel free to push F9 to recalc the entire sector.
If you really like a sector and wanna keep it, CTRL-A to select everything, CTRL-C to copy it, start up a new excel workbook and then go to the paste menu, select paste-special, and select values only (this doesn't copy the formulas).
Anyway, enjoy, just a quick sometihng I put together. If you have any comments or questions feel free to email firstname.lastname@example.org
, I'll try to respond
Originally posted by badsyntax