Traveller Store CotI Features New Posts Mark Forums Read Register

Go Back > Citizens of the Imperium > File Library > Spreadsheets

Thread Tools Display Modes
Old June 21st, 2007, 03:08 AM
hunter hunter is offline
Ancient - Absent Friend
Join Date: Feb 2001
Location: Atlanta
Posts: 6,168
Gallery : 18
Visit hunter's Blog
hunter Citizen
Default [ANY] Sector Generator (zip)

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, I'll try to respond

Originally posted by badsyntax
Attached Files
File Type: zip (557.9 KB, 262 views)
[b]Current Projects[/b][LIST][*][url=]SciFi Gaming[/url][*][url=]The SciFi20 Project[/url][*][url=]The SciFi20 Rules Bundle[/url] [COLOR="red"][SIZE="1"][b]New![/b][/SIZE][/COLOR][*][url=]The SciFi20 Rules Bundle w/Screen[/url] [COLOR="red"][SIZE="1"][b]New![/b][/SIZE][/COLOR]
Reply With Quote

To see more of this thread, please login or register.


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

This website and its contents are copyright ©2010-2013 Far Future Enterprises. All rights reserved. Traveller is a registered trademark of Far Future Enterprises .
Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright (c) 2010-2013, Far Future Enterprises. All Rights Reserved.