Character Sheet

Instructions

Critical to fast play is an excellent character sheet. We’ve created and honed our own. If you’d like to use it in your game, the following strategy is recommended:

Copy the sheet to your own Google account (File → Make a copy).
Make a copy of the sheet for each player. Store each copy in a Google Drive folder you create for each player. Share each player’s folder with them so they can edit the sheet inside.
Instruct players to keep the starting tab (“ORIGINAL”) blank. Instruct them to right-click and duplicate the tab every time they need a new sheet. That way, they always have a blank to make new characters with, and all their characters are found in one file.

New in v1.4.1

Fixed psionic chance range (it was rounding fractions up when you’re supposed to drop them, and the range was wider than it should have been once you had a chance higher than 1%). To update existing sheets, change cell AC5’s value to =iferror(if(and(C5<16,C6<16,C9<16),0,(1+ROUNDDOWN(2.5*max(0,C5-16)+1.5*max(0,C6-16)+0.5*max(0,C9-16))))) and cell Z6:AC6’s value to =if(AC5=0,"no chance",if(AC5=1,"00",101-AC5 & " - 100")).

New in v1.4.0

Added

Added and modified various tables within the new Tables sheet to facilitate other changes.
Added weapons from UA which were previously missing from the weapons tables.
Expanded weapons vs AC tables to include AC types 1 and 0 from UA.
Added the Maul from the DM screen that floats around Dragonsfoot circles. We just recently learned the maul is not part of the official AD&D DM screen, but was added by a Dragonsfoot member. Nonetheless, we have added it to our sheet.
Added dropdowns to select character classes to facilitate changes that require the class name entered exactly as expected.
Added logic to automatically calculate Saving Throws in cells F30:F35 based on the classes, levels, and mods input by the user. Values default to that of a 0-level fighter when no class and level combination are provided.
Added field to display XP required to reach next level in cells AD25:AG27.
Added logic to automatically input level in Thief Skills and Turn Undead tables, cells V29 and AO29 respectively.
Added Chance to Assassinate table at AD66:AH68. Enter the victim’s level in AG67; AG68 displays the chance to succeed based on the victim’s level and the character’s highest class level in F25:F27.
Added dropdowns for spell casting classes in the spells-per-level section.
Automated # of spells per level, accounting for class level, bonus spells from Wisdom, and spell level limits from INT or WIS as appropriate.
Mini moneychanger expansion.

Changed

Moved hidden tables to separate “Tables” sheet to remove data duplication and ease future modification.

Fixed

Armor MV Restriction no longer breaks movement calculation if " is typed in the cell (AA46:AB46).
- To fix on an existing sheet: change the formula in D122:F122 to =IF(ISNUMBER(AA46), AA46, VALUE(SUBSTITUTE(AA46, """", ""))).

Known bugs

No known bugs. Found one? Share it at david@dtgay.com. Fixed one? Share that too!

Minor annoyance: Reference cells for WvAC are in reversed order. This doesn’t cause a bug, but can throw someone off when adding a new weapon to the reference tables.

Note about Google Drive

The current sheet is available on Google Docs. I typically prefer to keep records in non-proprietary software, but the sheet was born in Google Docs as a collaborative effort, and it allows players to update it in a way the DM can check at any time.

Credits

This sheet has been a collaborative effort, but special credit goes to Sax, who created virtually all of the formulas and hidden tables — undoubtedly the vast bulk of the contribution.

nubby was the champion of the v1.4.0 version.

Alternative sheet

Erik (who journals our sessions! (to be posted later)) created an alternative character sheet based on the official one, modified to suit his taste. This shows how you can take our sheet and make it your own. The downside is that you’d have to manually adopt any improvements we make.

Erik’s Sheet v1.0.0