Pathfinder automatic character sheet on Google Sheet

Software & Websites

Hey all,

First of all, a small bit of context. I played a LOT of PF1 using u/darthmarth28 's automated sheet system. Being a programmer myself, fiddling with Excel / Google Sheet is nothing I am afraid of, and I did a lot of editing based on his work. In the domain, we would call his version a "Master" copy and my sheet would merely be a "Fork" of his work, an hommage, an extension of what he did, if you would. I do not think that I made any achievement here, he is the one deserving the credit for the basis, I merely edited and built on what he did.

The reason for this boring introduction is simple : in his sheet, he forbade rehosting of his sheet "as one's own work" and I want to be crystal clear that, yes I worked on this sheet a lot, but this is all an extension of his own work and he is the original author that I credit through my own work.

However, when switching to PF2, my play group loved the autosheet. And sadly, he didn't work a long time on the PF2 version, probably switching to another framework or another software, I don't know, I contacted him and didn't hear back. We, however, did not feel like switching software and I made a lot of edits and modifications on the sheet. With the release of the APG, that I included in the sheet, I felt that this community might like having another option in the toolbox. Yes there is Roll20, FoundryVTT an probably many others that I did not follow on, but my group can still meet and play with a simple rudimentary Google Sheet - even while the world is in this crisis, stay safe, people, please! - and I want to enable other groups on the interwebz to do so too if they please.

So with this long introduction, that I hope clears the fact that I am NOT stealing from another man's work, I present to you the Pathfinder 2E Autosheet - a fork by Johnnyjester. Make your own copy and try it away to build your character on it!

I do not guarantee that it is bug-free and 100% functionnal and accurate, but this is also a part of the objective with this public release : more eyes on the sheet could help me find annoying bugs and get rid of them :-)

With that, I bid you all a great day and may your table never Critically Fail!

Posted Aug 18, 2020, 4:16 PM UTC

177
bichan3•

This sheet looks amazing! With the edits following the APG this will make a lot of games easier and more fun I'm sure of it! Great edits! Makes me want to do a witch!

Great job adding the familiar zone too! :)

5
Innoculi•

I love the work you did! The only thing I’m not a fan of is the color scheme... may end up changing that.

2
Norrep777•

I like the condition tracking

2
GreatGraySkwid•

Yeah, I sent u/darthmarth28 a bug report a while back and he never responded, while some of the fixes I'd sent in for the 1E sheet got integrated.

Anyway, the bug is still present in your version: the 2E Autosheet class chart for spells is short by one spell known/spells per day for every level. Currently v1.0 shows the following:

LVL1st2nd
12-
23-
332
433

...and so on, when it should be:

LVL1st2nd
13-
24-
343
444

...and so on.

2
JohnnyjesterOPGM•

Thanks for the feedback! I'll try to implement fixes on the bugs when they are found!

Speaking of that, I wonder : is your assumption made while looking at the Sorcerer's table?

Because if I look at the Cleric or the Wizard both gain 2 and max out at 3 spell / slots / day. The Sorcerer, however, gains 1 more, indeed, and the sheet should adjust it when you take the Class.

Waiting on your reply! Thanks for the feedback, much appreciated!

3
GreatGraySkwid•

...oh, shit, I thought I said that! Yeah, Sorcerer.

2
JohnnyjesterOPGM•

No problem, just wanted to be sure!

And yes, I can confirm I corrected this bug : if you build a character and select Sorcerer as the class, you will have the correct number of spells per day!

Thanks again for the feedback :)

3