Menu
News
All News
Dungeons & Dragons
Level Up: Advanced 5th Edition
Pathfinder
Starfinder
Warhammer
2d20 System
Year Zero Engine
Industry News
Reviews
Dragon Reflections
White Dwarf Reflections
Columns
Weekly Digests
Weekly News Digest
Freebies, Sales & Bundles
RPG Print News
RPG Crowdfunding News
Game Content
ENterplanetary DimENsions
Mythological Figures
Opinion
Worlds of Design
Peregrine's Nest
RPG Evolution
Other Columns
From the Freelancing Frontline
Monster ENcyclopedia
WotC/TSR Alumni Look Back
4 Hours w/RSD (Ryan Dancey)
The Road to 3E (Jonathan Tweet)
Greenwood's Realms (Ed Greenwood)
Drawmij's TSR (Jim Ward)
Community
Forums & Topics
Forum List
Latest Posts
Forum list
*Dungeons & Dragons
Level Up: Advanced 5th Edition
D&D Older Editions
*TTRPGs General
*Pathfinder & Starfinder
EN Publishing
*Geek Talk & Media
Search forums
Chat/Discord
Resources
Wiki
Pages
Latest activity
Media
New media
New comments
Search media
Downloads
Latest reviews
Search resources
EN Publishing
Store
EN5ider
Adventures in ZEITGEIST
Awfully Cheerful Engine
What's OLD is NEW
Judge Dredd & The Worlds Of 2000AD
War of the Burning Sky
Level Up: Advanced 5E
Events & Releases
Upcoming Events
Private Events
Featured Events
Socials!
EN Publishing
Twitter
BlueSky
Facebook
Instagram
EN World
BlueSky
YouTube
Facebook
Twitter
Twitch
Podcast
Features
Top 5 RPGs Compiled Charts 2004-Present
Adventure Game Industry Market Research Summary (RPGs) V1.0
Ryan Dancey: Acquiring TSR
Q&A With Gary Gygax
D&D Rules FAQs
TSR, WotC, & Paizo: A Comparative History
D&D Pronunciation Guide
Million Dollar TTRPG Kickstarters
Tabletop RPG Podcast Hall of Fame
Eric Noah's Unofficial D&D 3rd Edition News
D&D in the Mainstream
D&D & RPG History
About Morrus
Log in
Register
What's new
Search
Search
Search titles only
By:
Forums & Topics
Forum List
Latest Posts
Forum list
*Dungeons & Dragons
Level Up: Advanced 5th Edition
D&D Older Editions
*TTRPGs General
*Pathfinder & Starfinder
EN Publishing
*Geek Talk & Media
Search forums
Chat/Discord
Menu
Log in
Register
Install the app
Install
Community
General Tabletop Discussion
*Dungeons & Dragons
D&D Older Editions
Monster stat block design using Excel (2021)
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Jacob Lewis" data-source="post: 8452971" data-attributes="member: 6667921"><p>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:</p><p></p><p>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.</p><p></p><p><strong>Table: </strong>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.</p><p>[ATTACH=full]146423[/ATTACH]</p><p></p><p><strong>Fluff:</strong> 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.</p><p>[ATTACH=full]146424[/ATTACH]</p><p></p><p><strong>Statblocks: </strong>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.</p><p>[ATTACH=full]146422[/ATTACH]</p><p></p><p><strong>Extras:</strong> 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.</p><p>[ATTACH=full]146425[/ATTACH]</p><p></p><p>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.</p></blockquote><p></p>
[QUOTE="Jacob Lewis, post: 8452971, member: 6667921"] 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. [B]Table: [/B]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. [ATTACH type="full" alt="1636580019325.png"]146423[/ATTACH] [B]Fluff:[/B] 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. [ATTACH type="full" alt="1636580151964.png"]146424[/ATTACH] [B]Statblocks: [/B]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. [ATTACH type="full" alt="1636580002798.png"]146422[/ATTACH] [B]Extras:[/B] 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. [ATTACH type="full" alt="1636580350815.png"]146425[/ATTACH] 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. [/QUOTE]
Insert quotes…
Verification
Post reply
Community
General Tabletop Discussion
*Dungeons & Dragons
D&D Older Editions
Monster stat block design using Excel (2021)
Top