D&D 5E ForgedAnvil D&D 5E Character Generator

ForgedAnvil · Mar 24, 2015

dragon3y3 said:
Looking Great! Well done. Just would like to comment that it would be nice to have a version number, say under your Anvil logo so I can keep straight which characters I have and haven't upgraded to the latest sheet.

Thanks for the feedback, updated for V1.12

MrDarkflame · Mar 24, 2015

Selecting Dragonborn is yielding #N/A for RACE, BACKGROUND, CLASS & FEATS section. All other races appear to be working correctly.

ForgedAnvil · Mar 24, 2015

designbot said:
Under Carrying Capacity on Character Sheet I, the second Encumbered should be Heavily Encumbered.

The suggested calculations for character weight are incorrect. (Understandable, because the table on pg. 121 of the PHB is pretty confusing.) The weight and height are both supposed to be affected by the same die roll, making them proportional to each other. For example, to determine the height and weight of a human, you roll 2d10. If we call the result of that roll t, the height of a human is 4'8" + t inches, and the weight of a human is 110 + (t * 2d4) pounds. This results in a range of 4'10" - 6'4" and 114 - 270 pounds. Your sheet simply suggests 110 * 2d4, which would put the normal range of humans at 220 - 880 pounds. It might also be nice to include a generator for this.

Unfortunately there is not enough space to add Heavily. Decided to go with Encumbered (as you are still encumbered) but differentiate by using the text conditions underneath.

I fully understand the height and weight calculation, but you're right it's not clear in the sheet - I'll work on a way to make this clearer in V1.12

I am avoiding the generator for height and weight as the free versions of Excel (iOS, Android, Windows 10) don't allow macros, form controls or active X controls (it's also cool to roll dice). Although currently there is the reset all macro (CTRL+SHIFT+S), this is only for Excel 2010-2013 users (and primarily used by me in development). If you download the latest file it should already be "reset" and ready to rock.

MrDarkflame · Mar 24, 2015

ForgedAnvil said:
I am avoiding the generator for height and weight as the free versions of Excel (iOS, Android, Windows 10) don't allow macros, form controls or active X controls (it's also cool to roll dice). Although currently there is the reset all macro (CTRL+SHIFT+S), this is only for Excel 2010-2013 users (and primarily used by me in development). If you download the latest file it should already be "reset" and ready to rock.

You could use =RANDBETWEEN(1,6) for 1d6 and set calculation to manual. Then make a note to press F9 when you want to roll dice. No macro/forms needed and using built-in functions that should work for free versions of Excel.

ForgedAnvil · Mar 24, 2015

MrDarkflame said:
Selecting Dragonborn is yielding #N/A for RACE, BACKGROUND, CLASS & FEATS section. All other races appear to be working correctly.

#N/A appears if Dragon Ancestry has not been selected, once it is selected (other than Select...) then #N/A no longer appears

Fixed this behaviour in V1.12

ForgedAnvil · Mar 24, 2015

MrDarkflame said:
You could use =RANDBETWEEN(1,6) for 1d6 and set calculation to manual. Then make a note to press F9 when you want to roll dice. No macro/forms needed and using built-in functions that should work for free versions of Excel.

This is challenging as once the workbook is set to manual calculation, this effects all other formula throughout the workbook.

I have implemented this:

designbot · Mar 24, 2015

ForgedAnvil said:
This is challenging as once the workbook is set to manual calculation, this effects all other formula throughout the workbook.

I have implemented this:

View attachment 67588

Clever.

designbot · Mar 26, 2015

One more: On Character Sheet III, "Spells Slots" should be "Spell Slots"

brainz80 · Mar 26, 2015

First of all great work. I have a small issue though. I play a Tiefling and though I can select 'Thaumaturgy' from the cantrip select-list, I cannot select 'Hellish Rebuke' or 'Darkness'. This is a small problem, but I decided to mention it nevertheless

Also 'Thieve's cant' should probably be automatically added to the 'Character Sheet I / Languages' -box if your character happens to be a rogue.

ForgedAnvil · Mar 27, 2015

designbot said:
One more: On Character Sheet III, "Spells Slots" should be "Spell Slots"

Thanks, corrected for V1.13

D&D 5E ForgedAnvil D&D 5E Character Generator

ForgedAnvil

Explorer

MrDarkflame

First Post

ForgedAnvil

Explorer

MrDarkflame

First Post

ForgedAnvil

Explorer

ForgedAnvil

Explorer

designbot

Explorer

designbot

Explorer

brainz80

First Post

ForgedAnvil

Explorer

Similar Threads