Digital Excel Character Sheet


Creating a Character


5 people marked this as a favorite.

I spent all day yesterday working on this, adapting key design functionality that I liked in my PF1 sheet (which was, itself, heavily modified from a 3.5 sheet I found somewhere over a decade ago).

One of the things I really like about this sheet is that the ABCs of statgen are very clearly delineated. Once my group worked out "oh, you can treat it like a grid, only so many marks on any given line, only one mark in any cell" it was really easy to make sure you were doing it right and that translated into how I handled it on the excel sheet (with the position and fit of the area moving about constantly until it found its current home).

Layout should be very familiar to PF1 and 3.5 players with the stats at the top, along with other important values like HP, saves, and skills. Along with a large box for tracking multiple conditional modifiers.

The rest of the space on the first page being attacks (as well as armor and shield, though thinking about it, that could have gone on the second page). Page breaks carefully considered for acceptable break points when printed (and everything fits in a landscape view nicely).

Second page is then Action/Reactions, equipment, notes/buff effect tracking, and some spell information.

1st level spells and up, along with feats, money, and experience total fill the third page (exp can be tracked on the second sheet; date, description, and amount).

https://www.dropbox.com/s/5sjd2nyn5lmsi4s/blank_pf2_sheet.xls?dl=0

Sheet is protected to prevent accidental formula corruption, but there is no password. I heavily customize my sheets for each character I play, tracking where every bonus comes from by plugging in the value next to the source and referencing the cell so I always know "where'd this +2 come from?" As such, I embedded these areas on every feat, note, and item line (the "amount" field almost never refers to a quantity for me: its always remaining charges, bonus to some other value, etc. with the cost handled manually).

There will likely be changes as I sit down and start building characters with it (for example, I don't have item quality "EML" checkboxes and have to use the free-int Enhancement field meant for magical enhancement or any way to track the 'free' items for building characters above level 1, but I'm not sure how to even address those with the space available at the moment), but I'm pretty happy with it so far.


Updates:

Some cell borders fixed (some cells were missing borders entirely, others were added in light gray for printed sheets, others were adjusted so that boxed ares had clean edges).

EML item quality boxes (instead of just proficiency)

A spot for spontaneous heighten (squeezed in under spellcaster type)

Circles around spellcaster type (mainly for printing)

Some cell headers adjusted (e.g. attacks's "TRAITS" cell now named "TRAITS & NOTES", Action/Reaction "Range" -> "Action" to hold any action cost such as Reach Spell adding a Somatic casting action or Battle Medic requiring 1 action).


Signature skills are out (gave 2 cells to squeeze the "level" part of the calculation in).

Permanent items ("wealth by level") tab created. Contains Table 11-2 for reference and a place to note down what items were taken (these still need to be entered on the main sheet, but this allows for tracking).

Spell Roll and Spell DC section squeezed in next to spells per day. Ugly, but I recognized the need for it and had to put it somewhere.

Likely some other minor fixes as well.


Fixed boosts above 18.

I'd writing the formulas at one point, but somewhere in the editing process they got lost accidentally.


1 person marked this as a favorite.

Now available on Google Sheets too


Draco18s wrote:
Now available on Google Sheets too

Since I primarily use Google Sheets (easier for players to share sheets w/GM without constantly sending new versions) I'll offer my suggestions regarding this version of the sheet.

  • While nice and compact, 6pt font makes several sections difficult to read/reference during a game. This is particularly noticeable for the skills & spell sections considering players are likely to reference them a lot.
  • Unsure if Temp Ability Score & Temp Ability Modifier sections are needed in PF2, as abilities which temporarily modify your ability score are gone and now just modify relative skills/etc.
  • As you could probably tell from my sheet, I'm a fan of using checkboxes since it is easier for a player to quickly click once rather than having to select then edit a cell (especially during character creation when they have to do this many times). As such, I'd recommend checkboxes for TEML proficiencies and in the Caster type section.
  • Cantrip section looks to be a bit small considering Wizards start out knowing 10 of them.

    Having atk bonuses listing out for all three attacks in a round is neat and I kinda wish I had room to do the same on mine.


  • Charon Onozuka wrote:
    Draco18s wrote:
    Now available on Google Sheets too

    Since I primarily use Google Sheets (easier for players to share sheets w/GM without constantly sending new versions) I'll offer my suggestions regarding this version of the sheet.

  • While nice and compact, 6pt font makes several sections difficult to read/reference during a game. This is particularly noticeable for the skills & spell sections considering players are likely to reference them a lot.
  • That's likely something that's just been perpetuated from the original sheet I found 12+ years ago, heh. For me, I generally don't have a problem with it, but I've certainly tried to keep font sizes from dropping below legibility at 100% zoom.

    The only spot I'm not happy with is the 2nd page spells area (domains, spont heightening, etc).

    Quote:
  • Unsure if Temp Ability Score & Temp Ability Modifier sections are needed in PF2, as abilities which temporarily modify your ability score are gone and now just modify relative skills/etc.
  • Mostly kept them around because I haven't definitely seen one way or the other.

    Quote:
  • As you could probably tell from my sheet, I'm a fan of using checkboxes since it is easier for a player to quickly click once rather than having to select then edit a cell (especially during character creation when they have to do this many times). As such, I'd recommend checkboxes for TEML proficiencies and in the Caster type section.
  • Definitely agreed on the checkboxes, its just not something available in the version of Excel I use (2003 and don't upgrade because I hate the ribbon with a burning passion). I'd have to dig into how Google sheets handles this to even get it functional.

    Quote:
  • Cantrip section looks to be a bit small considering Wizards start out knowing 10 of them.
  • I do, technically, have some room to fit more lines in (in terms of where the page breaks are). Hadn't made a wizard yet.

    Quote:
    Having atk bonuses listing out for all three attacks in a round is neat and I kinda wish I had room to do the same on mine.

    One of those nice things left over from the 3.5 sheet that was absolutely worth keeping as I fiddled with space and sizing. ;)

    Thanks for the feedback!


    Thanks for all your work on this. Fantastic resource.


    The Once and Future Kai wrote:
    Thanks for all your work on this. Fantastic resource.

    And of course, more options for people to find something they like.

    I've always used a sheet like mine just because if something isn't working the way I need it to, I can fix it.


    I really like this, though I'm not sure 4 reactions slots are needed. I know some classes eventually get a ton of reaction options, but I think the 2 most commonly used ones would be enough, and getting rid of 8 rows would let some of the other rows be a little bigger


    ofMars wrote:
    I really like this, though I'm not sure 4 reactions slots are needed. I know some classes eventually get a ton of reaction options, but I think the 2 most commonly used ones would be enough, and getting rid of 8 rows would let some of the other rows be a little bigger

    I made them reaction because I wasn't sure and it paired nicely with 4 actions. I've ended up using 2 or 3 of them for additional actions (just copy/pasting for the formatting).


    Draco, thanks much! I look forward to checking it out.


    Updates reflecting Errata 1.3


    Finally got around to updating things, fixing a few bugs in some formulas and some other misc changes implied by updates.

    My chapter 5 character (running on rules 1.6) is built on it (and that's how I found some of the bugs).

    Community / Forums / Archive / Pathfinder / Playtests & Prerelease Discussions / Pathfinder Playtest / Player Rules / Creating a Character / Digital Excel Character Sheet All Messageboards

    Want to post a reply? Sign in.
    Recent threads in Creating a Character