I got Imperium Maledictum, the new Warhammer 40K RPG the other day. It looks good overall, I'll be writing a longer and more detailed review shortly. As part of my campaign prep for an upcoming test of the system, I decided to relaunch the Tellian Sector. To make it bigger, and represent the changes as 40K moves into the 42nd millennium and the "Indomitus Era", I decided I would make an automatic sector generator.
This is based off a heavily modded and "40K-ified" version of the Stars Without Number 1e planet generator. If you know fairly basic Excel (how the INDEX and RANDBETWEEN formulas work, specifically), you can mod it fairly extensively if you don't like the probability ranges I've assigned to various categories.
To get started:
1) Create a new worksheet and copy / paste the values only from columns L through X from the generator template worksheet to that new worksheet.
2) You'll want to insert two columns at the left-hand side and copy over the counters from columns J and K on the generator template worksheet so you can keep track of the rate of incidence of each item in each category. Be sure to make this a regular paste (not values-only) so it preserves the counter formulas in K
If you delete it, the counter formula is: =COUNTIF($[column letter]$[number of first row of column]:$[column letter]$[last row of column], [column letter and row number of the entry you want it to track).
e.g. =COUNTIF($F$1:$F$121, A2) tells Excel to count everything in column F between rows 1 and 121 that matches the value in A2 (which in this table is the word "Agri-World")
All you need to do is select the bottom row of columns L through X on the generator template and drag them down until you have as many planets as you want. Nice and easy! It's Excel, so I recommend not doing more than about 10,000 at a time unless you've got a top of the line machine. Also, it's easier to handle certain later processes if you do smaller batches at once, so consider making each worksheet a subsector and then generating however many subsectors you want.
If you screw up the formula for any reason and need to rewrite it, all of the columns are basically filled with:
Where B2 and B101 are the 100 entries to the left in column B (Planet Type), and RANDBETWEEN generates a number between 1 and 100 and then grabs a corresponding row coordinate out of column B and INDEX dumps the value in that cell, e.g. "Hive World" into the formula's own cell.
Organising planets into systems:
1) Starting from the first cell under "System", look at the number (n) in it, and count down (n-1) squares, deleting the entries in columns C and D ("System" and "Star Type" respectively).
Here's a picture of what that looks like once you're done:
That's basically it.
1) Open the sheet, and copy it
2) Copy and paste the values from columns L through X. Once you've done that, delete columns A through I.
3) De-dupe the tags manually.
4) Break the planets up into systems
5) Name the systems and planets
6) Fiddle with entries until you're happy
7) Remember to save your work!
A few notes on the Tellian Sector and this generator:
I intentionally left a lot of the tags more generic rather than less so you can mod them to your own taste. Some of the tags and such also represent my own interests in the 40K setting, and I encourage you to change them if you want something different..
There's a lot of Xenos and Hereteks, comparatively low levels of Chaos, and no Necrons, Orks, Eldar, or Space Marines explicitly mentioned. I have small amounts of Eldar and Space Marines in the Tellian sector, but they're custom-placed by me rather than something I leave to a random generator.
There's also a fairly high chance of people having archaeotech levels of technology, and a lot of xeno collaborators because these are what make the Tellian sector an area of interest to the Imperium (for good or for ill).
Anyhow, enjoy! I don't care about copyright, credit, any of that stuff, so use it as you please.