D&D 4E Monster stat block design using Excel (2021)

Jacob Lewis

Ye Olde GM
If you're like me, you're always curious to see how someone sets things up, or you just like seeing examples for ideas and inspiration. So here is mine:

Obviously, the focus of this project is monsters. That's why I started with monster stat blocks. I just finished phase one of my own personal Monster Vault digital notebook using OneNote and Excel. My goal was to create a more personalized and complete up-to-date Monster Vault, which includes monsters updated to MM3 math and format, and all the known errata. Monsters that I won't likely ever use in my games, or redundant monster designs that aren't needed, don't make the cut. This will reduce the clutter significantly so that I'll have just the stats and monsters that I want to use.

Table: The important list serves as both a table of contents and an index for monsters broken down by level and role. It includes links to the page where each statblock can be found.
1636580019325.png


Fluff: This may seem a bit excessive (unless you're a compulsive completionist like me!). But since I had to create a buffer page just to separate the monster groups, I decided to make use of the space anyway. I will say, it is nice having the fluff on one page to read without the statblocks in the way.
1636580151964.png


Statblocks: Of course, the bulk of the file is just statblocks. As shown in this thread, I created them using a template I designed for format in Excel. Then just copy the table as an image and paste to the page. Easy peasy! I included the errata, and any monsters converted from MM1, which were a series of articles in Dungeon Magazine. I'll add more as needed, but I have plenty to get me started running again.
1636580002798.png


Extras: At some point, I may want to create my own custom monsters, or update older ones manually. So I included some handy tables and tips that might be useful in a pinch.
1636580350815.png


As always, feedback and suggestions are encouraged. Maybe someone else thought of something that I hadn't yet. And I'd love to see what anyone does for themselves.
 
Last edited:

log in or register to remove this ad

Jacob Lewis

Ye Olde GM
I thought the screenshots were going to be too large for the display, so I hid them inside the spoiler tags. But then I forgot to mention there were screenshots behind the spoiler tags and not just walls of text. I know if it were me, I probably would've skipped spoilers, too. So now you know, and I took the spoilers off anyway.
 


Jacob Lewis

Ye Olde GM
For those of you out there who want to build their own Monster Vault (or anything else for 4e) using OneNote, I have attached a starter file to the main post to help you get going. The file contains sample pages with the background headers for every page that you designate as either PHB, DMG, or MM.
1636928333289.png

1636928345955.png

1636928376487.png

I've also included a blank index page that you can populate as you build, and add links as needed.
1636928432837.png


And finally, I loaded up blank tabs set up alphabetically for you to start populating.
1636928486414.png
 



Remove ads

Top