| 1 person marked this as a favorite. |
Hey all, I've made a Google Sheets character sheet for Pathfinder, and I'd love to have some feedback / help. I know that a myriad of options exist for this, whether they are PDFs, sites like Herolab, or other spreadsheet-type character sheets, but I've always found one or two little issues that keep any given option from being perfect for me.
- I formatted this to fit on a 1920x1080 monitor with minimal/no scrolling required and some room for a text/word document to the side (you should just be able to fit the text of a Word doc with 1" margins to the side of this sheet) for notes.
- I want every possible thing to be calculated for the player (read: my dumb ass), so that bonuses / penalties are neither forgotten mid-combat, or not added correctly while building the character
- I don't like the uneditable fields in many PDFs (what if I take Improved Initiative? If I can't edit the Init field then it's wrong, but otherwise it's not auto-calculated)
- I don't want to reduce the text size (bad eyes are bad), and I don't want to make this much more dense. The spaces in between the sections allow for players to put little notes, or numbers to be used for calculations (for example, I added a little "Mage Armor" checkbox on the row below shields for a Wizard I'm playing right now).
- I wanted cells with formulae to be obvious (so the player doesn't accidentally wipe a formula) but not ugly (to preserve my soul), so I went with a light gray color
- I would love an easy condition list (i.e. I am shaken and blinded, so I check those boxes and my stats are auto-modified), but I couldn't figure out a way to do it without making every formula a nightmare to read/modify (which again, I want the player to be able to do). I also couldn't figure out a nice place to fit the ~25 conditions in Pathfinder.
Here's a view link to the sheet: ObsessiveWiz's Character Sheet
Please, feel free to jump in and discuss what you like / don't like, any bugs you find, etc, as well as ask some questions. I'll be happy to fix/update things if I agree, and talk about why I disagree if I do. Thanks for taking a look, and I hope some folks find it useful!
P.S. Yes, this was very much based on a popular auto-calculating PDF character sheet. I have used that PDF more than any other character sheet solution up until now, so this can be considered an homage :)
The HP calculation (L2-L6) needs to have the CON modifier fixed to C4; it is currently going C4, C5, C6, ... .
@Theaitetos Ah, good catch! Thanks!
@Thelith Agreed, with only the 2 miscellaneous columns I've ended up just stacking bonuses together (I've often ended up putting all permanent bonuses in 1 column and temp/situational bonuses in the other). Unfortunately, I don't really see a way to add more columns without making the skills go off the page (I already lose the right-side edge of the far-right column) or moving them to a separate sheet, which raises other questions:
- What would I put where skills are now? I don't really like the idea of a big blank chunk with nothing in it
- There's no way skills take up a whole sheet. What else goes in with them?
- As of right now there are just enough sheets that I can click around to different sheets without having to use the drop-down menu. Adding another sheet reduces the ease of moving to and from the "Description" tab.
Happy to discuss solutions to this, and thanks for the feedback!
I made a copy of the original sheet to test moving Skills to a new tab (I want to be able to revert the changes easily if they don't end up working out). Here's the test sheet