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: 8441453" data-attributes="member: 6667921"><p><em><strong><span style="font-size: 12px">Disclaimer:</span></strong><span style="font-size: 12px"> I am not here to entertain discussions involving legal copyright, GSL, etc. Very few people here are qualified to give their advice (and less welcome to give their opinions) on the matter. Those who are qualified are not being solicited for said advice or opinions, either. If I am doing something wrong, or I am not in compliance with the rules of the site, I have full confidence that a moderator will inform me and take the appropriate actions necessary. </span></em></p><p><em><span style="font-size: 12px"></span></em></p><p><em><span style="font-size: 12px">(And in case it needs to be said, it is not my intent to provoke any actions or be non-compliant with the rules. Just know that anyone brings their "issues that don't actually affect them" here, I won't engage and most likely ignore. Thanks!)</span></em></p><p>[HR][/HR]</p><p>Over the last few years, I've been looking for ways to create 4e content (for myself) in a manner that was efficient and aesthetically appealing. Obviously, resources (legal or otherwise) are difficult to find thanks to the restrictions of the thrice-damned GSL. Those that do exist are either lacking, incomplete, or just unsatisfying for what I want. So, like I often do, I figure out ways to do things on my own. (Why? It's not important. I just want to!)</p><p></p><p>So here I have an example of a monster stat block from the <em>Monster Vault:</em></p><p>[ATTACH=full]145874[/ATTACH]</p><p><strong>Except I made this with Excel (2021).</strong> The stats and information match exactly (or darn-near) as they appear in the original text of the manual (page 72, for those of you playing at home). I had to learn a few tricks to get the format and spacing right, including the hanging indents for paragraphs (which are not a standard function in Excel).</p><p></p><p>But the best part is that I can turn each stat block into an image that I can copy, save, and paste. I haven't decided what I'm going to do with this awesome new power, but I have begun saving them in a single OneNote document. At some point, I may convert older (pre-MM3) monsters to the cleaner format with fixed math (and better game design), as well as update all the blocks with the latest errata.</p><p></p><p>So aside from showing off my work here, I was wondering if this might be useful to anyone else. Obviously, I can't share my personal files that contain previously published stats. (And I'm not so sure that applies to monsters with converted statblocks if they were never (technically) published.)</p><p></p><p>If anyone has ideas, feedback, questions, or suggestions, let me know.</p><p></p><p><strong>UPDATES</strong></p><p>[HR][/HR]</p><p>Uploaded zip file with the Excel (2021) version of the monster template I created, and the Asul fonts used (the fonts are available and free to use for anyone, but I thought I'd save everyone the extra trouble).</p></blockquote><p></p>
[QUOTE="Jacob Lewis, post: 8441453, member: 6667921"] [I][B][SIZE=3]Disclaimer:[/SIZE][/B][SIZE=3] I am not here to entertain discussions involving legal copyright, GSL, etc. Very few people here are qualified to give their advice (and less welcome to give their opinions) on the matter. Those who are qualified are not being solicited for said advice or opinions, either. If I am doing something wrong, or I am not in compliance with the rules of the site, I have full confidence that a moderator will inform me and take the appropriate actions necessary. (And in case it needs to be said, it is not my intent to provoke any actions or be non-compliant with the rules. Just know that anyone brings their "issues that don't actually affect them" here, I won't engage and most likely ignore. Thanks!)[/SIZE][/I] [HR][/HR] Over the last few years, I've been looking for ways to create 4e content (for myself) in a manner that was efficient and aesthetically appealing. Obviously, resources (legal or otherwise) are difficult to find thanks to the restrictions of the thrice-damned GSL. Those that do exist are either lacking, incomplete, or just unsatisfying for what I want. So, like I often do, I figure out ways to do things on my own. (Why? It's not important. I just want to!) So here I have an example of a monster stat block from the [I]Monster Vault:[/I] [ATTACH type="full" alt="dracolich-deathbringer.png"]145874[/ATTACH] [B]Except I made this with Excel (2021).[/B] The stats and information match exactly (or darn-near) as they appear in the original text of the manual (page 72, for those of you playing at home). I had to learn a few tricks to get the format and spacing right, including the hanging indents for paragraphs (which are not a standard function in Excel). But the best part is that I can turn each stat block into an image that I can copy, save, and paste. I haven't decided what I'm going to do with this awesome new power, but I have begun saving them in a single OneNote document. At some point, I may convert older (pre-MM3) monsters to the cleaner format with fixed math (and better game design), as well as update all the blocks with the latest errata. So aside from showing off my work here, I was wondering if this might be useful to anyone else. Obviously, I can't share my personal files that contain previously published stats. (And I'm not so sure that applies to monsters with converted statblocks if they were never (technically) published.) If anyone has ideas, feedback, questions, or suggestions, let me know. [B]UPDATES[/B] [HR][/HR] Uploaded zip file with the Excel (2021) version of the monster template I created, and the Asul fonts used (the fonts are available and free to use for anyone, but I thought I'd save everyone the extra trouble). [/QUOTE]
Insert quotes…
Verification
Post reply
Community
General Tabletop Discussion
*Dungeons & Dragons
D&D Older Editions
Monster stat block design using Excel (2021)
Top