1
2
3
4
Instead, read the directions below.
This sheet REQUIRES you to have a Google account, preferrably gmail.com.
To make your OWN copy, use the link in the green box below or the blue Use Template button in the top right corner (if it's visible).
5
6
7
9
10
11
12
13
14
15
16
17
18
19
The β (Dot) symbol is used to indicate proficiency or Yes. Some skills include a multiplier, such as x2 or .5 - these correspond to the Expertise trait (where you add double your proficiency) and Jack of All Trades trait (where you add 1/2 your proficiency) to skills. An x means you have disadvantage on the skill - usually due to armor.
20
21
22
This sheet assumes you are using standard vanilla 5E spells. If you wish to use custom spells:
β Add them to the list at the bottom
β Check any boxes for classes that have access to that spell
β Use the slicers (filters) at the top to filter out as normal.
Also, on the Spell Sheet tab, Hide any rows that don't apply yet (like higher level spells). Click+Drag row numbers to select multiple rows. Then Right-click on a selected row and choose Hide Row.
23
24
25
26
27
28
29
30
31
β This means that all spells are stored on the sheet itself, not linked, so you can make any changes to the spell list that you want. You can add custom spells, change spell properties, etc.
β The drawback is that you have to update each character sheet, but you get flexibility to use your own spells and edits
β Also, copying / pasting from one sheet to the next should be easy.
β Added Variations to the Variations tab
β Added Clara Lee's variation - which includes Artificer spells among other things
β Added Kevin McGee's variation - which includes Wild Shape tab
32
33
β Fixed HP calculation (again) - wasn't calulating to main HP tab!
β Added Variations to the Variations tab
β Added Adam Harb's variation
β Added Nic's variation
34
35
β Fixed HP calculation on Front page for 2nd-4th classes. It was doing max hp for first die - should only get that on 1st class. - (thanks to several people)
β Fixed contitional formatting formula for encumbrance - was referencing wrong cell - (thanks to several people)
β Fixed Animal Friendship spell - incorrectly didn't list WIS save in the column (thanks to R. Furman)
β Added Variations tab with links to other versions and sheets. Email me to have yours listed.
β Tweaks (thanks to C. Ravenwood)
β Adjusted spell attack calculation to be neater
β Tweaked Other Modes of movement to be more in line with first two
β Adjusted alignment of current HP to be closer to max value
β Swapped position of Con and HP columns in CLASSES section to avoid confusion. Removed CON total in table
β Included clearer directions for using your own spell lists on the README tab (this one)
36
37
β Added calculations for coin types & total wealth for valuables+coin.
β Added a few more rows for backpack space and valuables.
β Class List (thanks to M. Waldorf and J. Hatfield)
β created pull-down list of classes with auto-calculating hp and HD.
β Modify the blue cells in the Data tab to add your own.
β Armor List (thanks to M. Waldorf and J. Hatfield)
β created pull-down list of armor and shields with auto-calculating AC and stats
β Modify the blue cells in the Data tab to add your own.
β Cleaned up some IF nested formulas with Match command and added some instructions on page 2 for special bullet list and tracking characters (thanks to M. Blank)
β Some changes for those who use the sheet actively during play (thanks to C. Dodd)
β Split HP field to help track current hp
β Added Used box in spell page to track slots used
β Added space for more movement types
38
39
β Created Google Group and link for users to join in order to receive updates to the sheet! See link in yellow, above.
β Added Version Checker on Readme to automatically notify you if your version of the sheet is out of date.
β Updated instructions on README tab
β MAJOR CHANGES to Master Spell List tab
β Added Slicers and to easily Filter spells by level, ritual, class, known, etc.
β Added Checkboxes to Master Spell List Tab, allowing you to check Spells Known (T. Fiola)
β Fixed Earth Tremor (save for 0) (C. Lee)
β Fixed Poison Spray (save for 0) and added source & page to spellsheet (H.Smith)
β MAJOR CHANGES to Spell Sheet - See Spells instructions above for details.
β Now automatically populates with Known Spells. (R. Theriault & J. Beck)
β Added prepared spells column that counts number of prepped spells. (T. Fiola & J. Beck)
β Created Named Ranges for Spell DC and Spell Attack fields for easy recall in formulas (C. Dodd) - if you create additional spell sheets, be sure to create new Named Ranges for those yourself.
β Updated Front Sheet:
β Added checkboxes for ammo and death saves (removed graphics) for digital users (A. Dietrich & C. Dodd)
β Added dropdown boxes for Hit Dice Types and auto-calculation of HP based on selection (C. Dodd)
β Shifted Downtime, HD, and Death Saves to be more flexible and easy to use for other metrics as desired.
β Merged feats, languages, special abilities and other fields to better support multi-line data. Included instructions for using ALT+Enter to create more lines in a field.
β Updated Back Sheet
β Merged magic items, misc possessions, additional class info, and misc info fields to better support multi-line data. Included instructions for using ALT+Enter to create more lines in a field.
β Corrected conditional formatting for encubrance & adjusted colors (A. Trevor)
40
41
42
43
44
45
β Added Prep spell amounts to 2nd page. (suggested by Clara L.)
β Multiclassing Spellcaters: Since the top is tailored to a specific caster stat and level, I would advise duplicating the Spell Sheet for each spellcasting class. Also, you will need to modify the formulas on the spell page to calculate your caster level correctly.
β Clarified some verbage on the README tab.
β Added Change Log to README tab. :-P
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101