5E D&D Excel Based Character Sheet

5E D&D Excel Based Character Sheet

Thumbnail

Rating: +6
Favourites: 7

Report File

5E D&D Excel Based Character Sheet


File Information



Files   




XP Clockro4ch, Arcryex, Milokot gave XP for this post
Excel character spreadsheet for 5E D&D. Many values are auto calculating including:
*Auto calculates character level by adding together the sum of all class levels
*Auto calculates ability score bonuses for both the character and animal companion
*Auto calculates proficiency bonus, saves and skill bonuses
*Auto calculates the skill bonus for Jack-of-All-Trades if the character is a Bard of level 2 or higher
*Auto calculates passive perception and initiative bonus
*Auto calculates encumbrance based on the weight of all carried armor, weapons, equipment and coin
*Auto calculates movement speed taking into account penalties due to wearing heavy armor with low STR and using the optional encumbrance rules
*Auto calculates armor class based on armor worn and DEX bonus
*Auto calculates the Gold Piece Value of all coins carried
*Auto calculates the attack bonus of all weapon attacks
*Auto calculates spell attack bonus and save DC

=Updated 11/6/13=
Uploaded two different versions of the sheet, one where the spell page is oriented vertically and another horizontally
Expanded the spell section to better handle multiclass spell casters and warlocks

=Updated 11/3/14=
*Added fields for tracking ammo
*Expanded equipment carried and abilities/features sections to take advantage of what would otherwise be wasted space
*Added drop down lists to select damage type for each attack listed for the character and animal companion

=Updated 11/2/14 - incorporating a lot of feedback from various users of the sheet.=
*Moved the look up tables for armor type and ability scores to a second worksheet
*Reformatted the Armor Worn and Animal Companion sections to be more readable/usable
*Re-laid out the Spell Page to have vertical text to make printing all three pages easier
*Added the ability to add miscellaneous bonuses to things like passive perception and iniative
*Added the ability to add a magic bonus for a weapon
  1. Dr. Strangemonkey
    I'm a fan of it so far, how does the HP section calculate?
  2. ko6ux
    Hit points can be typed into cell V28, behind the heart-shaped graphic. Because the heart partially blocks this cell, click on the white space directly to either side of the heart to select the cell.
  3. Cabdru
    Is there anyway i can get you to make a copy of this char sheet where the spell stuff isn't sideways? or is there some way with excel to rotate this section so that its up and down in stead of side ways cause its a huge draw back for all my friends using this which is unfortunate
  4. ko6ux
    I just uploaded two different versions of the sheet: one where the spell pages are oriented vertically and another where the spell pages are horizontal.

    Printing the horizontal version may be tricky as Excel doesn't handle having different pages in the same worksheet with different landscape/portrait orientations. You should be able to print pages 1-2 using portrait orientation. Then, switch the worksheet to landscape and check the print preview and adjust the printable area as needed for the spell pages. Once you are satisfied you can print pages 3-4.

    On the vertical orientation version of the worksheet it should be possible to print all four pages at once, but of course entering the data can be a little disorienting.
  5. Cabdru
    Thank you this is exactly what I was hoping for sir, good and super fast reply and work up that's so awsome. Thank you again
  6. ko6ux
    You are very welcome. Enjoy!
  7. Athinar
    Excel will not open this file, could be a virus
  8. jay_rab
    Didnt have an issue with this file, seems nicely laid out.
  9. Thater
    This sheet is great, however it seems to automatically calculate the proficiency bonus into the attack bonus whether the character is proficient in the weapon or not. Can you add a checkbox for proficiency and just take the modifier from the ability and then add proficiency if the box is checked?

Report File

Reason










Report Comment

Reason






Report Link

Reason