D&D Excel Character Sheets
Character for characters.
To manage characters for role-playing games, I’ve designed and built resilient character sheets that allow each character’s personality to come to life. From a chaotic Sorcerer, to a crafty Rogue or a zealous Cleric, these sheets allow me to nimbly track all my important abilities and game statistics in a single location.
For characters that rely on spells, I’ve further enhanced the sheets to track and manage the spells the character knows; important information and details are at my fingertips no matter what the situation calls for.
Beyond D&D Beyond.
My first character sheets date back to 2015, well before D&DBeyond, the site designed by Wizards of the Coast to manage D&D characters, was launched. My sheets start from a template I’ve become pleased with, then incorporate features that give each character a set of tools necessary for what I might from them during the course of play. I’ve also incorporated dice tracking into the sheets, to allow me to monitor the randomness of my dice over the campaign as well as individual sessions.
For instance, a sorcerer summoning small demons might need to track the activities of many small monsters; a sheet with macros custom-built to handle those spells solved this problem deftly, allowing me to manage numerous creatures without slowing down gameplay. Meanwhile, a cleric might need to pull up spell text for both an instant and an ongoing spell, meaning multiple spell subsets need to be tracked and accessed.
The most notable of these custom tools, however, would be a relational database I built using only Excel Macros and formulas. This tool pushed Excel to its limits, allowing me to track and update information on key individuals for the game, and pull up related terms whenever referencing a term in the database for information. This let me and my character puzzle things together quickly, even for events occurring in the campaign years apart from each other.
