Your Version 2.8 Current Version: 2.8 You are up to date
PLEASE READ ALL OF THIS!!! SCROLL DOWN FOR MAJOR UPDATES
DO NOT REQUEST EDITING RIGHTS TO THIS. I will delete the email. 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).
NOTE: If you click the link below and get an error, it's because your organization won't let you access it. Instead, log in with your personal Gmail.com account.
🔗 Make a copy here
SEE AN EXAMPLE OF A CHARACTER SHEET FILLED OUT HERE: https://goo.gl/xPidym
There are 5 sheets to this spreadsheet: this instructional sheet, the Front, the Back, the Spell Sheet, and the Linked Master Spell List, which is a list of spells that makes it easy to pull into the Spell Sheet by simply checking the Known box in the Master Spell List tab. Follow directions on each sheet.
See the tabs below to access them.
Note that you need to print each sheet separately (Front, Back, and perhaps Spells). When you print, you MUST set the print options to:
Portrait, Fit to Page, Narrow Margins
COLORS & SYMBOLS
The sheet is generally unlocked but some cells have formulas that calculate values. These cells are all highlighted in Green and should generally be left alone unless you know how to use formulas. 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.
To use the Spell Sheet effectively, first, go to the Linked Master Spell List tab. Then check the boxes in the Known column for each spell that you wish to add to your spell list. All spells checked will show up under the proper spell level in the Spell Sheet tab. You should Delete/hide or Insert more rows to accomodate more spells. Just right-click in the table and choose Insert or delete row as needed. This sheet assumes you are using standard vanilla 5E spells. If you wish to use custom spells, simply delete the formulas in the first row (column) A of each section and copy/paste the spell info from the master spell tab manually. Also, 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.
CHANGES AND UPDATES
Feel free to make your own personal changes or adjustments. Email me at [email protected] if you want to share ideas or changes.
To stay up to date with changes, please join this Google Group:
Version: 2.8 - HUGE UPDATE
● Updated README ➜ 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)
● Fixed "Deity" Spelling. Allowed for CON & other stats to be used on Spell Sheet. Thanks to L. Block for the tip!
● Fixed medium armor Dex mod in AC calculation (thanks to Ryan M for catching it).
● Added Passive Investigation to front page (suggested by Clara L.) ● 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