5E D&D Excel Based Character Sheet 1

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

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

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

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

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

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