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
MPMB's D&D 5e Character Tools
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="morepurplemorebetter" data-source="post: 7029647" data-attributes="member: 6788192"><p>Whoopsie, accidentally posted my previous post, instead of what I was writing:</p><p></p><p></p><p>Now here is some essential information! I thought you were talking about the Character Record Sheet PDF, and not the Excel! The Excel is mostly a legacy product at this stage and I don't really update it anymore because the Character Record Sheet can do the same stuff, only better, and has all the other things for making a character as well.</p><p></p><p>So my replies have all been related to the Character Sheet until now and are, therefore, completely wrong and don't apply to your situation <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f61b.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":P" title="Stick out tongue :P" data-smilie="7"data-shortname=":P" /></p><p></p><p>The Excel can't do what you want it to do through automation, as there wouldn't ever be enough space on the 'input' tab to select all possible spells you could theoretically have in a spellbook. Instead, you will have to manually select which spells you want to see on the "Spell Sheet" tab, and then generate the sheet again.</p><p>To do this, open the "Let's make a spell sheet!" dialogue (with the big green "Create Spell Sheet" button), and click on the orange button that reads "I want to edit which spells are on the Spell Sheet (Spellbook)".</p><p>This then opens the Spell Sheet tab with an extra column, the "Visibility Column". By removing a "x" from a line in this column, you will ensure that that line is hidden when generating the spell sheet.</p><p></p><p></p><p>If you want something that can do all the stuff the Excel can, including easier selection of what spells you have in your spellbook, and a <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile :)" data-smilie="1"data-shortname=":)" /><img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile :)" data-smilie="1"data-shortname=":)" /><img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile :)" data-smilie="1"data-shortname=":)" /><img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=":)" title="Smile :)" data-smilie="1"data-shortname=":)" />ton more, check out <a href="http://flapkan.com/mpmb/dmsguild" target="_blank">the automated PDF's over on DMs Guild</a>!</p><p></p><p>Because DMs Guild demands exclusivity, I'm not allowed to post the sheet anywhere else.</p><p></p><p>FYI I'm almost done with the next version of the PDF sheet, which I hope to have online in a couple of hours.</p></blockquote><p></p>
[QUOTE="morepurplemorebetter, post: 7029647, member: 6788192"] Whoopsie, accidentally posted my previous post, instead of what I was writing: Now here is some essential information! I thought you were talking about the Character Record Sheet PDF, and not the Excel! The Excel is mostly a legacy product at this stage and I don't really update it anymore because the Character Record Sheet can do the same stuff, only better, and has all the other things for making a character as well. So my replies have all been related to the Character Sheet until now and are, therefore, completely wrong and don't apply to your situation :P The Excel can't do what you want it to do through automation, as there wouldn't ever be enough space on the 'input' tab to select all possible spells you could theoretically have in a spellbook. Instead, you will have to manually select which spells you want to see on the "Spell Sheet" tab, and then generate the sheet again. To do this, open the "Let's make a spell sheet!" dialogue (with the big green "Create Spell Sheet" button), and click on the orange button that reads "I want to edit which spells are on the Spell Sheet (Spellbook)". This then opens the Spell Sheet tab with an extra column, the "Visibility Column". By removing a "x" from a line in this column, you will ensure that that line is hidden when generating the spell sheet. If you want something that can do all the stuff the Excel can, including easier selection of what spells you have in your spellbook, and a :):):):)ton more, check out [URL="http://flapkan.com/mpmb/dmsguild"]the automated PDF's over on DMs Guild[/URL]! Because DMs Guild demands exclusivity, I'm not allowed to post the sheet anywhere else. FYI I'm almost done with the next version of the PDF sheet, which I hope to have online in a couple of hours. [/QUOTE]
Insert quotes…
Verification
Post reply
Community
General Tabletop Discussion
*Dungeons & Dragons
MPMB's D&D 5e Character Tools
Top