I made this spreadsheet for one of my players having a hard time tracking her spells per day as a Wizard. It's not fancy, but I like its functionality.
How to Use
At the bottom of the page:
1) Choose Yes or No for Universalist.
2) Select your Intelligence score.
3) Select your Caster Level.
The sheet will calculate your Concentration bonus, Spell DCs, and spell slots available. You can either type in the spells you have prepared or print out the sheet and write them in manually. When you use a spell, simply check the box next to the slot. The spell slots marked with an * are for specialists only.
Note: This spreadsheet requires Excel 2007 or later. I have no idea if it's compatible with Open Office.
If you notice an error in the calculations, please let me know. I might add more functionality to this sheet if there's enough interest. It also wouldn't take too much time for me to add sheets for other spellcasters. Post here if you'd like further development, along with the features you'd like to see.
Updated to v1.10
Instructions:
1) Select your specialized school.
2) Enter your Intelligence score.
3) Enter your Caster level.
Changes:
1) Created an option to select the Wizard's Specialized School. This replaces the "Universalist?" option.
2) Clicking on a spell slot brings up a drop down menu with all spells for that level (sources: Core Rulebook, Advanced Player's Guide, Ultimate Magic, Ultimate Combat, and Inner Sea World Guide). Custom or metamagic spells can be typed in manually.
3) The drop down menu for the spell slot granted from having a Specialized school shows only the spells from the school.
Updated to version 1.11
New download link: here
Do not use prior links, as Google Docs will not let me update the old document to a new revision for some reason.
Changes:
1) Unprotected worksheet, as the protection was causing an error when choosing specialized school.
2) Fixed bug listing a number out of order when choosing Intelligence and Caster Level.