So, my party/dm has had trouble finding a good solution for the Kingmaker 1st edition campaign. An HTML based one from years ago won't save progress without exporting the settings to a file, which you then import to otherwise share the sheet. Not perfect. Another option was using a PDF that supposedly helped put all the details in, but it was too easy to get things wrong, have people mistype and make a bad entry, and didn't have enough room for other effects.
Due to my work giving me the skills, I decided to ply some of my intermediate excel-fu and made a google sheets sharable/copiable file that I hope will help any others who are still going through Pathfinder 1e kingmaker. It should be fairly straightforward to change the buildings to match or tweak for house-rules, adaptations from pf2e, and so on.
The Link: https://docs.google.com/spreadsheets/d/1CxHGwSgAN12f6yef6KovqgFoRh7PyIAwgNb LgkKtBLA/edit?usp=sharing
How to use:
Rule of thumb: if its a light gray backfill and google sans font, it's an automatic calculation and shouldn't be changed
First, go to the Leadership tab and put in your player characters and NPCs and their core/base stats from Str-Cha. It will automatically calculate the bonus and highlight which role that character would have the best bonus for (but feel free to ignore for roleplaying). The "council" entry at the bottom is for our game where we are all sharing the 'ruler' slot and play our best stat across everyone in that spot. feel free to change that from the large function to average or just don't use it. Put in the rank of the skill associated with the position from the character (names of the usable skills per position to be added soonTM) in the appropriate column and update when it changes.
Second, use the dropdowns on the kingdom sheet to assign your edicts and leaders to their prospective roles. It will show you what the penalty is when it's empty or the bonus when it's filled automatically.
Third, Rename your CityName sheet to whatever your capital is, then rename the city "CityName" to match. It should automatically pull everything from there. Any future cities you found, copy/duplicate the city template tab, rename it to your new city name, and add that name to the list of towns/names.
Fourth, fill in the kingdom development spots accordingly along the top.
Fifth, profit! Hopefully.
The coloring for the sheet was purely based on what my group prefers, but is able to be adjusted. There's several automated or convenience things, such as changing bp consumption to bp production if you have a surplus of things (we export food in our run, just treat as 0 if you don't run that way) and changes the background from deep red to green to show profit.
I'm open to feedback if there's any suggestions or things needing fixed. Mostly wanted to help anyone who might be looking for some option we couldn't find and be that possible solution.
Weirdly revisiting the link later didn't work, so since it's after the editing window permitted, here's the updated link:
https://docs.google.com/spreadsheets/d/1CxHGwSgAN12f6yef6KovqgFoRh7PyIAwgNb LgkKtBLA/edit?usp=sharing
if there's further issues, such as such links having an expiration, I'll look into a more permanent setup or place to keep the file, perhaps as an excel file on office in a onedrive or something.
we found a great spreadsheet online that took care of all of this, just google, UCAM_Kingdom_sheet.xls
Tried searching it, both surprised and unsurprised there's a sheet someone made a decade ago for it that came as the first result, however when I tried grabbing it, it wouldn't connect/download/etc. I'll probably still give it a look if that connection error clears up, see what I can learn from it. The second result (and only other I'm spotting, given via a dropbox rather than direct download link) is a gigantic well formatted sheet, and my only qualm at first glance is that it's gigantic.
Either way, thanks for pointing it out (and leaving me wondering how we collectively failed the perception roll). at least I can say it was a fun enough mental project to try to do.
Tried searching it, both surprised and unsurprised there's a sheet someone made a decade ago for it that came as the first result, however when I tried grabbing it, it wouldn't connect/download/etc. I'll probably still give it a look if that connection error clears up, see what I can learn from it. The second result (and only other I'm spotting, given via a dropbox rather than direct download link) is a gigantic well formatted sheet, and my only qualm at first glance is that it's gigantic.
Either way, thanks for pointing it out (and leaving me wondering how we collectively failed the perception roll). at least I can say it was a fun enough mental project to try to do.
if you can never get it, MEssage me, and I can send you a copy.
I'm grateful for the help. My group has decided to stick with my simplified sheet for kingmaker because of how the information is organized, but both were really helpful, and I've forwarded the Kingdom/Army tracking sheet to my group in case we ever wish to touch on something like Wrath of the Righteous.
If nothing else, this had been a good exercise of what excel things I did know, and i am seeing other functions I may yet learn how to use for my own development. I'd still say I'm proud of realizing I could use the Indirect function to auto-reference another sheet, and it got me thinking about how to use that elsewhere.