Troll Lord Games

I've always hated typing up stat blocks, never seemed to make them fully consistent. So, I decided to work out a spreadsheet to take all of the monster stats, useful in itself, but then also include a stat block generator for it. I had started this previously, but have come back to finish it up as I am working towards my next campaign. One thing I may end up doing is a mega dungeon using my random dungeon generator I posted quite some time back, based off of the DMG tables. I want to expand upon those with Engineering Dungeons, and insert the C&C monsters in appropriate "Level" of the monsters, pulling the stat block with this. I will actually try this with some friends doing it completely on the fly. But I digress...

The attached zip file contains an XLSX file (no macros) that only has M&T in it, I have a file with all of M&T, M&ToA, CM, and OG&M, but am still working at cleaning up the file, splitting the monsters that have multiple types/sizes into multiple lines. For example, the Orc entry can have a small patrol or a Tribe, size is given for both in one entry in M&T. When you open the file it is currently set for an Orc (Tribe), you could also select just Orc to have the smaller band shown.

Oh, you will also note that the Dragons are not in here yet. They are going to require some more manual work based on the differences from the other monsters, namely the various ages of the dragons. Each dragon will appear in the list, with each of it's age categories listed in the end. Yes, that means 10 entries for each dragon, but it will be worth it in the end.

There are four tabs in the spreadsheet -

• Stat Block
  • Their is a drop down list, that is in alphabetical order that you can select a monster from
  • If you type the monster name in the box, it must be an exact match
  • There are a number of merged cells that contain the stat block, a long formula pulling from the Stat Block Calculations tab
• Monster Stats
  • This is the listing of all of the monster stats
  • They are going to be alphabetized, but organized by source book for easy reference
• DynamicSort
  • Ok, so this one is bit complex but to perform the dynamic sort -
    • First get the order, the first column will check the monster name, counting the number of instances that are less than it to generate an index value
    • The second column retrieves the monster name, utilizing the index value
    • The third line will retrieve the Monster ID utilizing the index value
  • This list is used to generate the drop down list, and is a VLOOKUP to get the Monster ID used in the Stat Block Calculations tab
  Stat Block Calculations
  • I use formulas here to extract data from the Monster Stats list, based on the selected monster on the Stat Block tab
  • It calculates HP and XP to include in the stat block
  • There are two lines that concatenate the HP and XP values to the right so only one cell for each need be in the stat block formula
  • Note I have currently capped at 30 creatures, this can be extended, but will require a bit of work on this tab, not much but some

Here is a sample output for the stat block - I use the PDF I had purchased as the source for this, and did a lot of cleanup, which is what I am still going through on the other books, most of the heavy lifting is done, it is just the tedium of splitting the monsters that have multiple entries in one as I noted above.

Anything you think should be added?

Ultimately I want to build the treasure tables as well, and include that in a second block, but that will wait until this is done.

Aergraith and nwelte have both written up a treasure generator.