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, OSR, & D&D Variants
*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, OSR, & D&D Variants
*TTRPGs General
*Pathfinder & Starfinder
EN Publishing
*Geek Talk & Media
Search forums
Chat/Discord
Menu
Log in
Register
Install the app
Install
NOW LIVE! Today's the day you meet your new best friend. You don’t have to leave Wolfy behind... In 'Pets & Sidekicks' your companions level up with you!
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: 6802867" data-attributes="member: 6788192"><p>That looks like a very fast way of updating your character to a new version, once you have the software set up. I'm not sure how many people that use my sheet and that don't already have a way of exporting will be tech-savy enough to use your solution. But I will link to it on the downloads page <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=":)" /> So thank you very much for this addition.</p><p></p><p>As for telling which fields are user input and which are calculated. This is a double sided question. My sheet has a couple of fields that are truly calculated (such as the ability modifiers, or the proficiency bonus, or the skill modifiers, etc.), but most are not calculated, merely auto-filled. The auto-filling happens when you enter a value into certain other fields (such as the class, race, and level fields), lets call them 'master' fields. Importing a value into one of these 'master' fields will set off the chain reaction of auto-filling. However, because these auto-filled fields are not fixed (i.e. you can edit the text in them), the import might differ from what is auto-filled by the formulas, as people may have changed something.</p><p></p><p>So regarding your question. If you are asking about the calculated fields that are, as I call them above, 'truly calculated', then you don't need to worry about them when importing. Their values will be replaced at the next calculation cycle (e.g. when opening the sheet). If you are, however, talking about the auto-filled fields, then I have bad news for you, because they are not easily distinguishable from the other fields. The bigger question is, however, if you even should want to exempt them from the export.</p><p></p><p><strong>Edit</strong>: I forgot to reply to the "data massaging". The only thing that the import function does other than importing the fdf file is run a script to reset some field values that change when you make something visible on the sheet that is hidden by default (such as the Adventure League DCI, or the Location column in the equipment section). All those things are minor things that should not greatly affect the sheets functionality if not reset by your script. After this resetting, the import script runs the same things that run at opening of the sheet. So saving it and subsequently opening it will achieve the same goal.</p><p></p><p></p><p>This is undoubtedly something with your friends software, and not much to do with my sheet, considering he is the only known example of that error <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" /> What it might be? I have no idea! It sounds like Acrobat thinks the field cannot accept the "+". So, just spit-balling here, maybe the field is already too full? or he is running in a language-setting that does not allow a "+"? or his keyboard is dirty and whenever he presses a "+" he presses 5 other keys, which cause an error?</p><p></p><p>Can he past a "+" into the field? Can he enter a "+" in any other fields? Does it work if he changes keyboard or updates his Acrobat Reader? Can you enter a "+" into his sheet after he edited and saved it?</p><p></p><p></p><p></p><p>The companion page is definitely something that desires some more attention. Changing it into a monster stat block as in the MM would go against the design philosophy of this sheet. If you want a copy-paste from the MM or another source, I would recommend just making a physical copy or scan of it <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>Adding an alignment is a nice idea. I have changed it so it will be there in the next version. I have also added a "Type" field.</p><p></p><p>As for features not fitting and the "Annotations" area. It was my intention that both spaces are available for whatever information you want to add to the creature. And if those spaces are not enough, the "Notes" section below it should provide ample extra room for text. The reason it is called "Annotations" is simply because I didn't want to name it like anything else on the page. "Traits" felt to me to be to similar to "Features", and "Notes" would only serve to confuse the two sections.</p><p></p><p></p><p>Welcome back Noah! Having you correct all the mistakes in the SCAG additions would be a big help. Although I would like to believe that I made no mistakes, I'm sure you will be able to find some <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f609.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=";)" title="Wink ;)" data-smilie="2"data-shortname=";)" /></p><p></p><p>I will fix the FAQ in the next version, thank you. As for the Barbarian, I have not literally copied the correction put forward by devincutler because the line-breaks were not right (too much text for one line), and it was written in the 2nd person, instead of the 1st person as the rest of the Class Features. So instead I went with:[CODE]Start/end as bonus action; add damage to melee weapon attacks that use Strength</p><p>Adv. on Strength checks/saves (not attacks); resistance to bludgeoning/piercing/slashing</p><p>Lasts 1 min, until unconscious, not attacked or taken damage since my last turn[/CODE]I'm fairly sure that my version is not grammatically correct either, but at least it fits <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f609.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=";)" title="Wink ;)" data-smilie="2"data-shortname=";)" /></p><p></p><p>As for Astromath's predicament: my Excel uses Visual Basic, a programming language with Microsoft- and Excel-specific commands. Opening the sheet in openoffice format will render the coding useless. So there is no way to use my Spell Sheet Generator in anything else than Excel, unfortunately.</p></blockquote><p></p>
[QUOTE="morepurplemorebetter, post: 6802867, member: 6788192"] That looks like a very fast way of updating your character to a new version, once you have the software set up. I'm not sure how many people that use my sheet and that don't already have a way of exporting will be tech-savy enough to use your solution. But I will link to it on the downloads page :) So thank you very much for this addition. As for telling which fields are user input and which are calculated. This is a double sided question. My sheet has a couple of fields that are truly calculated (such as the ability modifiers, or the proficiency bonus, or the skill modifiers, etc.), but most are not calculated, merely auto-filled. The auto-filling happens when you enter a value into certain other fields (such as the class, race, and level fields), lets call them 'master' fields. Importing a value into one of these 'master' fields will set off the chain reaction of auto-filling. However, because these auto-filled fields are not fixed (i.e. you can edit the text in them), the import might differ from what is auto-filled by the formulas, as people may have changed something. So regarding your question. If you are asking about the calculated fields that are, as I call them above, 'truly calculated', then you don't need to worry about them when importing. Their values will be replaced at the next calculation cycle (e.g. when opening the sheet). If you are, however, talking about the auto-filled fields, then I have bad news for you, because they are not easily distinguishable from the other fields. The bigger question is, however, if you even should want to exempt them from the export. [B]Edit[/B]: I forgot to reply to the "data massaging". The only thing that the import function does other than importing the fdf file is run a script to reset some field values that change when you make something visible on the sheet that is hidden by default (such as the Adventure League DCI, or the Location column in the equipment section). All those things are minor things that should not greatly affect the sheets functionality if not reset by your script. After this resetting, the import script runs the same things that run at opening of the sheet. So saving it and subsequently opening it will achieve the same goal. This is undoubtedly something with your friends software, and not much to do with my sheet, considering he is the only known example of that error :P What it might be? I have no idea! It sounds like Acrobat thinks the field cannot accept the "+". So, just spit-balling here, maybe the field is already too full? or he is running in a language-setting that does not allow a "+"? or his keyboard is dirty and whenever he presses a "+" he presses 5 other keys, which cause an error? Can he past a "+" into the field? Can he enter a "+" in any other fields? Does it work if he changes keyboard or updates his Acrobat Reader? Can you enter a "+" into his sheet after he edited and saved it? The companion page is definitely something that desires some more attention. Changing it into a monster stat block as in the MM would go against the design philosophy of this sheet. If you want a copy-paste from the MM or another source, I would recommend just making a physical copy or scan of it :P Adding an alignment is a nice idea. I have changed it so it will be there in the next version. I have also added a "Type" field. As for features not fitting and the "Annotations" area. It was my intention that both spaces are available for whatever information you want to add to the creature. And if those spaces are not enough, the "Notes" section below it should provide ample extra room for text. The reason it is called "Annotations" is simply because I didn't want to name it like anything else on the page. "Traits" felt to me to be to similar to "Features", and "Notes" would only serve to confuse the two sections. Welcome back Noah! Having you correct all the mistakes in the SCAG additions would be a big help. Although I would like to believe that I made no mistakes, I'm sure you will be able to find some ;) I will fix the FAQ in the next version, thank you. As for the Barbarian, I have not literally copied the correction put forward by devincutler because the line-breaks were not right (too much text for one line), and it was written in the 2nd person, instead of the 1st person as the rest of the Class Features. So instead I went with:[CODE]Start/end as bonus action; add damage to melee weapon attacks that use Strength Adv. on Strength checks/saves (not attacks); resistance to bludgeoning/piercing/slashing Lasts 1 min, until unconscious, not attacked or taken damage since my last turn[/CODE]I'm fairly sure that my version is not grammatically correct either, but at least it fits ;) As for Astromath's predicament: my Excel uses Visual Basic, a programming language with Microsoft- and Excel-specific commands. Opening the sheet in openoffice format will render the coding useless. So there is no way to use my Spell Sheet Generator in anything else than Excel, unfortunately. [/QUOTE]
Insert quotes…
Verification
Post reply
Community
General Tabletop Discussion
*Dungeons & Dragons
MPMB's D&D 5e Character Tools
Top