Ultimate Campaign Kingdom Tracking Spreadsheet


Community Use

1 to 50 of 924 << first < prev | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next > last >>

122 people marked this as a favorite.
Pathfinder Rulebook, Starfinder Roleplaying Game Subscriber

Hey, guys. I wanted to post for anyone looking for a kingdom tracking spreadsheet that makes use of all the changes made in Ultimate Campaign. I've got a start on updating the sheet and you can download it here. I used Berhagen's wonderful sheet made for Kingmaker (later updated by Zoetrope) as a base for my sheet. I've asked Berhagen if I could update his sheet and this is posted with his permission.

My group is about to start book two of Kingmaker so, in my rush, I've had to ignore anything related to mass combat for now (as such, Defense bonuses may not be 100% accurate everwhere, although Settlements should be okay), settlements do not currently list slots for magic items, I've stripped out some of the special features (like Zoetrope's Event/Weather generators), and many of the "Optional" rules from Ultimate Campaign have yet to be implemented. Now that I have the minimum spreadsheet I'm needing for my personal campaign, I'll start working on finishing what I've started and I'll be sure to post updated versions in this thread.

For anyone interested in a (nearly) complete list of changes I've made, here is a list for you. Anything labeled as "personal preference" is merely a cosmetic change that I've made to suit my own tastes that you may or may not notice or appreciate.

List of all changes:
Ultimate Campaign Changes:
Added the Consort Leadership Role
Added the Heir Leadership Role
Added and adjusted several Buildings
Added and adjusted several Terrain Improvements
Wardens who are Vacant now only reduce Loyalty by 2 instead of by 4
Generals now apply their Vacancy Penalty to Loyalty instead of Stability
A Grand Diplomat vacancy no longer prevents Promotion Edicts
Renamed Royal Assassin to Royal Enforcer
Renamed Festivals to Holidays
Added an Income field to the Kingdom and Overall sheets. This represents the bonus BP earned from things like Mines, Quarries, and Sawmills during the income phase. Currently, this only tracks the normal bonuses from these terrain improvements and bonuses from Foundries and the like will have to be handled manually.
Adjusted the minimum and maximum settlement Base Values
Arenas no longer have an effect on Consumption penalties from Holidays
Updated list of Continuous Events and renamed Ongoing Events to Continuous Events (the latter is personal preference)
Updated the field descriptions for all Leadership Roles

Modifications:
Changed the "Armies" for consumption box to "Other" and made the field editable. This is mostly because I don't have any work done yet on the army sheets and I wanted the box to allow manual adjustments for things like Stockyards.
Redid the way the "Major Buildings" list works on the City Summary worksheet. It now lists the five most expensive buildings in each city
Tweaked the kingdom alignment fields to prevent invalid combinations like "Good Evil"
Tweaked attribute fields for Rulers and Spymasters so you can make them blank without hitting delete. It weirds me out to hit delete on things (personal preference)
Tweaked the way a few formulas work, especially in regards to vacancies and edicts (personal preference)

Formatting:
Renamed "Size" to "Population" on city sheets (personal preference)
Changed colors slightly (personal preference)
Removed the conditional formatting on the Edicts dropdowns on the Overall page so they weren't "hidden" when there was a relevant vacancy. I just didn't really like it (personal preference)

I plan to do the following as I find time to work on updating the sheet further.

To do list:
Add the (updated) magic item slots back to the settlement worksheets
Add (updated) building summaries back to the settlement worksheets
Add (updated) army and mass combat rules back into the spreadsheet
Add Settlement Modifiers to the settlement worksheets
Add the "Optional Rules" from Ultimate Campaign
Add a way to override the district count for settlements to allow for cities to spread out prematurely
Update the settlement maps to the new rules (maybe)
Update/add the Event Generator back in (maybe)
Add the Weather Generator back in (maybe)
I'll likely catch things here and there as I go back over the rules a few times that can be added/tweaked.
I'm open to suggestions for things to add/change about the sheet! Please let me know if you have any thoughts.

I'm also considering adding information from the Book of the River Nations as well as Ultimate Leadership after the bulk of the "core" rules are added/updated. I'm also working on some printable quick reference sheets that can be used as a game aid to give an easy way of sorting through the massive amount of rules for kingdom building. I'll try to post here if I make any progress on those, as well.

Download Links:
Standard Version (.xlsx)
Older versions Excel (.xls)


Pathfinder Adventure Path, Lost Omens, Rulebook, Starfinder Roleplaying Game Subscriber

Dotting for later reference.


Looks great. Looking forward to the final product!


My hero!
Thankyou, thankyou, thankyou...


Dotting


Great! Mine group will definetly use it form the next session.
I Really would like to see the final version.
Thank you Mr. Brad Turner!

Scarab Sages

Awesome! This is what I was hoping for.

Just for the record, I would love to see Ultimate Rulership included!

I will be sure to post any feedback I get from my group after we use this one for a few sessions.


Oh ho ho, thanks for the hard work on this. ^_^


Looks good at first glance. Thank you!

Liberty's Edge

very cool


Thank-you so much for this.

I noticed a small error in the consumption calculation (L32). Some references to cell T32 are subtracted rather than added.

Thanks again you're a life-saver.


Pathfinder Rulebook, Starfinder Roleplaying Game Subscriber
Netarious wrote:

Thank-you so much for this.

I noticed a small error in the consumption calculation (L32). Some references to cell T32 are subtracted rather than added.

Thanks again you're a life-saver.

Thank you for pointing this out! I hadn't actually checked that calculation which I just left from the older sheet(s). I'll get it changed! :)

The Exchange

Pathfinder Adventure Path, Lost Omens, Maps, Rulebook, Starfinder Roleplaying Game Subscriber

Dot dot dot


4 people marked this as a favorite.
Pathfinder Rulebook, Starfinder Roleplaying Game Subscriber

I've finished the next update I had in mind. The city sheets now determine and display each city's magic item slots. I'm not exactly in love with the way I've layed it out, mostly because it makes the city sheet so wide meaning it may get cut off on lower resolution displays. Honestly, though, it's the most effective way I could come up with to display the information I thought was necessary. If anyone else has suggestions on ways to tweak it, I'm happy to consider it.

Also, to fix the error Netarious pointed out, I've simply removed the effects of Food Shortages and Food Surpluses on consumption for now and simplified the Consumption calculation. Once I get the chance to do more with events in the workbook, I'll look into working these bonuses/penalties back in as appropriate.

It appears that I can't edit my original post to change the download links so I'm adding links to the new sheets below. I'll probably focus on getting armies and mass combat implemented next and post a "4.2" as soon as that's done.

Download Links (version 4.1):
Standard Version (.xlsx)
Older versions Excel (.xls)


It looks like the consumption is set to the number of city tabs you have in the document,
Can you add a check rule which will exclude the cities tab if their name is blank?

e.g CountA

Part from that small thing, looks great.

Edit:
Found an error in City overview, the waterfront and districts counter only reference to tab: city 1,

Edit2:
Found the reason for the large consumption, and it is the counting of the districts from the cities in the city overview tab.

I solved it by using the correcting the reference for the column waterfront and districts


Pathfinder Rulebook, Starfinder Roleplaying Game Subscriber

Wow... ya, that was a pretty massive error on my part guys. I'm sorry about that. Thank you, Mordam, for catching that for me! Many of the references to things on the city tabs were changed inadvertently when I added a bunch of columns to accommodate for magic item slots. I was hoping I had caught and corrected them all but it was very late last night when I finished. I've corrected the error now and simply replaced the file at the previous (4.1) link.

As for adding a check rule on the name of cities, this sounds like it could be a good idea, but it will likely take a decent chunk of time to implement thoroughly and make sure every reference to city data gets covered. I'll be sure to add it to my list!

(Seriously, thanks again Mordam!)


You're most welcome.

The check for blank name from the cities was to counter the massive consumption use, so I do not think it will be useful anymore. (Probably only lots of coding for no gain)

Could it be useful to add a list with some info about the buildings for the city map tab?
(Size/lots, preq, kingdom bonus, settlement bonus, costs, etc.)


Dot. Coming back to this when I run KM


Pathfinder Adventure Path, Lost Omens, Rulebook, Starfinder Roleplaying Game Subscriber

Minor thing that I came across which threw me off: I was converting my hardcopy kingdom sheet into the spreadsheet, and one figure kept calculating "incorrectly". It might be worth noting on the "How to Use" sheet that the "Bonus" column requires inputting the total ability score bonus, and will halve it appropriately for the leadership positions (Consort and Heir, I think) where it gets halved.


Anyway to get this to work on an iPad?

Scarab Sages RPG Superstar 2008 Top 4; Contributor; Publisher, Legendary Games

Great work! Much appreciated.

Scarab Sages

Brad,

Any chance you might consider supporting the new material in Ultimate Rulership in a future sheet?


This is very nice. Sadly the latest version does not appear to be playing nice with google spreadsheets(which is where I do pretty much everything). Something about a 400,000 cell limit... anyone knows any other decent online spread sheet programs, like to know them(or at least a way to fix w/e is wrong with this google).

Anyways, from what I have screwed with, I noticed your control DC seems to be off. While in kingmaker dc was based solely on number of hexes controlled, in ultimate campaign the dc also includes the number of settlements in each city the kingdom has.


Pathfinder Rulebook, Starfinder Roleplaying Game Subscriber
Dead Phoenix wrote:
Anyways, from what I have screwed with, I noticed your control DC seems to be off. While in kingmaker dc was based solely on number of hexes controlled, in ultimate campaign the dc also includes the number of settlements in each city the kingdom has.

You are absolutely correct! This was a change in Ultimate Campaign that I simply hadn't noticed yet, so thanks a bunch for pointing it out! It's probably not the last change that I've overlooked, either, so please feel free to let me know if you see any more :)

I've uploaded the corrected version to the previous (4.1 link).


Pathfinder Rulebook, Starfinder Roleplaying Game Subscriber

I'd like to address all the questions and comments that I have yet to respond to. Anyone else, please feel free to let me know of your suggestions or problems that you see! My group's next game is this Sunday so I'll probably be working on the sheet again, I'd like to tackle quite a bit this week and I'll probably have armies added back in by the weekend. I'm also working on a few other things before the game, including actually prepping for the game itself. As we've just started Rivers Run Red and I'm not as familiar with it as I became with Stolen Land, it will take a chunk of my time but hopefully I'll have some left for this project :)

Mordam, The Northerner wrote:

Could it be useful to add a list with some info about the buildings for the city map tab?

(Size/lots, preq, kingdom bonus, settlement bonus, costs, etc.)

I'm making some separate "quick reference" sheets that I'll be printing out and giving to my players. I'll probably post those here at some point if I can make them a little less ugly. I'm also planning to add the little tooltip things to the city sheets for each building type that shows the building's stats similar to what the Leadership Bonus fields do now and what the city sheets did in the older versions of the worksheet. Making a completely separate sheet with all this info as a simple reference tool could be useful, though, so I'm going to add it to my to do list. Thanks again, Mordam! :)

Chemlak wrote:
Minor thing that I came across which threw me off: I was converting my hardcopy kingdom sheet into the spreadsheet, and one figure kept calculating "incorrectly". It might be worth noting on the "How to Use" sheet that the "Bonus" column requires inputting the total ability score bonus, and will halve it appropriately for the leadership positions (Consort and Heir, I think) where it gets halved.

I'll be sure to add this to the instruction sheet (which I really haven't touched at all yet) and try to make it a little clearer that this is being done automatically. Thanks, Chemlak!

FunnyMan21 wrote:
Anyway to get this to work on an iPad?

Unfortunately, I'm not familiar with Apple products or what tools iPads would use to view/edit spreadsheets. I can see how useful it would be, though, so I'll be sure to add it to my to do list and see what I can find out about it. Thanks, FunnyMan21!

redcelt32 wrote:
Any chance you might consider supporting the new material in Ultimate Rulership in a future sheet?

I'd love to get the rules from Ultimate Rulership incorporated into the sheet! It's already on my to do list, but I'll probably want to wait until everything from Ultimate Campaign has been incorporated before I start on it. I also haven't picked up a copy of it yet, so I have no idea how much work this is going to be :) Thanks, redcelt32!

Dead Phoenix wrote:
This is very nice. Sadly the latest version does not appear to be playing nice with google spreadsheets(which is where I do pretty much everything). Something about a 400,000 cell limit... anyone knows any other decent online spread sheet programs, like to know them(or at least a way to fix w/e is wrong with this google).

I had the idea to test this out on Google Docs as well. Our first game using the rules was a bit painful with the spreadsheet on my laptop with no way to connect it to our friend's big screen television at the time. When I tested it on Google Docs, it seemed to be painfully slow in recalculating the sheet and I didn't really give it a thorough test to see if it was working at all or what was missing/broken. Getting this to work on Google Docs seems like it could be very, very useful, even for games that take place in person, so I'm definitely going to add this to my to do list. Thanks, Dead Phoenix!


Pathfinder Rulebook, Starfinder Roleplaying Game Subscriber

A quick question regarding Ultimate Rulership for anyone who already has the book: Are the new rules presented in the book considered Open Content? I haven't purchased it, yet, and I'd like to incorporate it in the spreadsheet eventually if it's Open Content. Otherwise, I'll probably still pick it up at some point for our home game. I'd just like to know so I could figure out where to place it in my priorities list.


The designation is stated as such:
Open Content: Subject to designation as Product Identity (see below), the only portion of this Legendary Games product designated as Open Game Content is the rules content (names of skills, etc., taken from the
Pathfinder Reference Document) as defined in the Open Game License version 1.0a Section 1(d). The front and back cover, back matter, introduction and Credits page, as well all other parts of this product including
all text not specifically designated as Open Game Content is not Open Game Content. No portion of this work other than the material designated as Open Game Content may be reproduced in any form without
written permission.
Product Identity: The following items are hereby identified as Product Identity, as defined in the Open Game License 1.0a, Seection 1(e), and are not Open Content: Legendary Games, the Legendary Games Logo,
Adventure Path Plug-In, Ultimate Rulership, as well as all trademarks, registered trademarks, proper names (including the names of each character, location, item or monster unique to this product), dialogue, plots,
storylines, locations, characters, artworks, and trade dress, but excluding any content that is Product Identity of Paizo Publishing, Inc. (Elements that have previously been designated as Open Game Content are not
included in this declaration.)


This is wonderful! Thanks for being awesome, Brad!

Oh, and I don't know if it's worth the effort, but an OpenOffice version would be great. I don't have Excel at home but I should be able to fix any problems I find when converting.

Scarab Sages RPG Superstar 2008 Top 4; Contributor; Publisher, Legendary Games

The upshot of the OGL for your purpose, Brad, is that the parts you want to input into the spreadsheet are, by definition, "rules content," which means they are Open Content. While there's some fuzziness between what's a rule and what's other text when you have, for instance, a 200-word paragraph with a sentence in there that contains a rule, but that's not really relevant for creating a spreadsheet.

IOW, fire away with the spreadsheet and the rules from Ultimate Rulership. Should be a great addition.


Pathfinder Roleplaying Game Superscriber

That is great to hear!


Pathfinder Rulebook, Starfinder Roleplaying Game Subscriber
Jason Nelson wrote:

The upshot of the OGL for your purpose, Brad, is that the parts you want to input into the spreadsheet are, by definition, "rules content," which means they are Open Content. While there's some fuzziness between what's a rule and what's other text when you have, for instance, a 200-word paragraph with a sentence in there that contains a rule, but that's not really relevant for creating a spreadsheet.

IOW, fire away with the spreadsheet and the rules from Ultimate Rulership. Should be a great addition.

Thanks for the replies, guys! I was just making sure it didn't say anything crazy in the front of the book like "This Legendary Games game product contains no Open Game Content. No portion of this work may be reproduced in any form without written permission." like so many of the "pre-Pathfinder" edition books.

I assumed Mr. Nelson and company would be the awesome type that supports and loves the OGL, though. Looks like I was right! Thanks for being awesome! :)

Niilo John Van Steinburg wrote:
Oh, and I don't know if it's worth the effort, but an OpenOffice version would be great. I don't have Excel at home but I should be able to fix any problems I find when converting.

I think an OpenOffice/LibreOffice version should be a pretty easy conversion to do. I'll look into it a bit more and do some testing to see if I can start doing this with the next update. Thanks for the suggestion, Niilo!

Scarab Sages

Brad, do you have a copy of Ultimate Rulership? If not, I will gift you a copy if you are willing to add the rules to the spreadsheet. It seems the least we can do for all your hard work...\

Post here and let me know! :)


1 person marked this as a favorite.
redcelt32 wrote:

Brad, do you have a copy of Ultimate Rulership? If not, I will gift you a copy if you are willing to add the rules to the spreadsheet. It seems the least we can do for all your hard work...\

Post here and let me know! :)

Damn Red - I wish I'd have thought of that 1st!

However - kudos to you for making the offer.
Kudos to Brad for all his fine work.
Kudos to Mr J for being a nice guy/product developer.


1 person marked this as a favorite.

...and, because you're all so jolly nice - the least I could do was go onto
the Legendary games site & purchase the product myself...
Now - all I have to do is wait my first paycheck from my new job, so that
I can afford my ever growing Visa bill...& all will be well! :)

Cheers everyone!


Pathfinder Adventure Path, Lost Omens, Rulebook, Starfinder Roleplaying Game Subscriber

While I wholeheartedly agree that Ultimate Rulership needs to be included, I would like to suggest to Brad that he finish the core Ultimate Campaign rules, and maintain that spreadsheet (in case there are further errors found), and once that's done do the Ultimate Rulership spreadsheet.

While maintaining two sheets is a little trickier than only having one, I'd hate to see the UCam sheet be ignored in favour of the expansion.


1 person marked this as a favorite.
Pathfinder Rulebook, Starfinder Roleplaying Game Subscriber
redcelt32 wrote:

Brad, do you have a copy of Ultimate Rulership? If not, I will gift you a copy if you are willing to add the rules to the spreadsheet. It seems the least we can do for all your hard work...\

Post here and let me know! :)

While I very much appreciate everyone's kind words and offers, I would feel weird accepting gifts for the spreadsheet, even if it was to help add to the sheet. It is very flattering and I appreciate the kind thoughts very much, although I'm going to have to decline the offer :) I didn't own a copy of Ultimate Rulership when you posted, however, I just purchased the PDF from the Legendary Games website just in case any of you kind, generous people were tempted to "do it anyway" :) Also:

Chemlak wrote:

While I wholeheartedly agree that Ultimate Rulership needs to be included, I would like to suggest to Brad that he finish the core Ultimate Campaign rules, and maintain that spreadsheet (in case there are further errors found), and once that's done do the Ultimate Rulership spreadsheet.

While maintaining two sheets is a little trickier than only having one, I'd hate to see the UCam sheet be ignored in favour of the expansion.

I have to say that I agree with Chemlak. I haven't had a chance to look over Ultimate Rulership, yet, but I'm definitely going to have to "finish" the Ultimate Campaign material before I can see myself getting started on incorporating the Ultimate Rulership material. I'm sorry to anyone who'd prefer a different set of priorities. Also, running Kingmaker has been pretty taxing on me as far as prep time so I haven't been able to work on the spreadsheet as much as I would like to but I should have the next update ready soon! :)


Just wanted to say I'm a huge fan of your spreadsheet!

That said, for some reason 4.1 refuses to cooperate with google drive - any idea what the problem is...? For now I'm using the 4.0 version to great effect :)


12 people marked this as a favorite.
Pathfinder Rulebook, Starfinder Roleplaying Game Subscriber

Hey guys! I've finished the next iteration of the spreadsheet! The workbook now includes enough functionality to keep track of your armies. Please take note that most of the army resources/tactics/abilities won't actually apply any of their modifiers to an army unless the effects are unconditionally active on the armies at all times. Everything else will have to be tracked manually, at least for now. Also, I don't currently have a way to make note of multiple Siege Engines within an army so the Consumption for those will have to be tracked manually, as well (although the one-time OM bonus will be calculated in). I also haven't taken the time, yet, to update the instructions sheet so let me know if you have any questions or something seems unclear. Sorry :(

Also, at the request of a few people, I'm going to start including a workbook that is compatible with Google Docs/Drive. The city sheets grew quite large and complex when I added the magic item tracking back in so the workbook is too large now for Google to convert. To fix this, I've simply removed some of the worksheets that are not currently being used and I've limited the number of city sheets included to 15 (the non-Google compatible versions still include 25 city sheets). I've also included an Open/Libre Office version of the workbook, although it's literally just a straight file conversion right now and errors are likely to exist until I get time to work on a proper conversion. At first glance, it looks like it should be working okay except that some cells have become unmerged and the worksheet protection has been removed. Let me know if you find any weirdness there and I'll try to look into it. Thanks!

Anyway, as for what's coming next, I think I'm going to focus on getting most, if not all, of the "optional" stuff from Ultimate Campaign added in (like Settlement Modifiers, Fame, etc). Let me know if you guys catch any bugs, errors, or anything else strange. I don't spend a ton of time testing these sheets so errors, large and small, are likely to crop up.

I hope you guys enjoy the new version. Thanks, again, for everyone's input!

Download Links (version 4.2):
Standard Version (.xlsx)
Older versions Excel (.xls)
Google Compatible (.xlsx)
Open/Libre Office Quick Conversion (.ods)


Brad,

I haven't started using this, but I probably will at some point.

What I do want to do however is to give an unqualified THANKYOU!

The effort you're going to for us as a community (yes, I know you're mostly
doing it for yourself, & just sharing) is amazing.

You sir ...well, words fail me actually...
Thanks!


Pathfinder Starfinder Adventure Path Subscriber

Excellent sheet, one small bug, cistern adds to population. It can share a space so this may need to be two separate options. Still aplauding the awesomeness though!


Downloaded this and did a quick test run - looks awesome so far. Will test it more thoroughly with a trial game tomorrow!

Thank you again, especially for the Google comp. file. Works like a charm!

Liberty's Edge

Thank you a lot

Dark Archive

I have created a "Large" Army of Fighters with ranged support. This should be listed as Consumption 5 (Army Consumption 1 + 4 Ranged Support for a Large Army). But consumption is automatically listed as 1 on the Army tab, and in the Overall is listed as 4. Also Moral is set by default on "0", is there a way to modify it?

Regards


Pathfinder Rulebook, Starfinder Roleplaying Game Subscriber
Psi51 wrote:
Excellent sheet, one small bug, cistern adds to population. It can share a space so this may need to be two separate options.

Huh, I hadn't really thought of that. I'll add this to my To Do list and tackle it once I get a chance to use my brain for a sec. Thanks, Psi51!

Kord_Avatar wrote:
I have created a "Large" Army of Fighters with ranged support. This should be listed as Consumption 5 (Army Consumption 1 + 4 Ranged Support for a Large Army). But consumption is automatically listed as 1 on the Army tab, and in the Overall is listed as 4. Also Moral is set by default on "0", is there a way to modify it?

Thanks for all your comments, Kord! I've had a look over the Consumption calculation for armies and it looks like I had somehow left out one of the references to the adjustments from resources/special abilities/etc. I've fixed the issue and (hopefully) army consumption should be working correctly now.

Even after the adjustment, though, I didn't get quite the same numbers you were citing, although I may not have been using all the same inputs. Here's what I came up with. The army I created was a Large army made up of CR 1 Fighters making them ACR 3 (Base CR of 1, plus 2 for Large size). Divide the ACR 3 by 2 to get the base Consumption before adjustments (3 divided by 2 is 1 when rounded down). The additional Consumption cost for the Ranged Weapons Resource is +1. However, we have to multiply the Resource Consumption increase by 2 because the army is Large size. This makes the adjusted Consumption cost for Ranged Weapons a +2. Add the base Consumption for the army (1) and the adjusted Consumption cost for the Ranged Weapons (2) for a total of 3 Consumption per week for the army.

Also, in case there was any confusion regarding the Consumption cost for armies on the "Overall" sheet, armies pay their Consumption cost weekly so the amount listed on the Overall sheet is multiplied by 4 since everything else on that sheet is calculated monthly, not weekly. To make it a little clearer, I've made a note of it directly on the Overall page.

Again, I'm pretty new to these rules myself so I'm liable to make mistakes. If you believe my calculations are still in error, that I may have overlooked something, or just that I've plugged in different numbers than you had in mind for your example, please, please let me know what I've missed. Thanks again to everyone for their input! I really, really appreciate it!

Edit: Oh, almost forgot! Thanks, again, Kord! I was debating on how to handle the Morale aspect. After your comment, I decided to go back to the way it was working on the version 3.0 sheets where it was simply user editable rather than trying to calculate different things. It was silly and I'm glad you said something so I could change it back. Thanks!

(The download links for the 4.2 files have been updated with the aforementioned quick fixes. The Google compatible file hasn't been adjusted, yet, as it takes more time for me to make the adjustments that allow it to be compatible.)


Hey Brad (& Psi51),
Don't know (haven't looked) what RAW says, but the whole cistern thing could
be construed as - you get more people living in a similar sized space...
After all, the Devs have consistantly said that population is not binding,
rather just idicative...


First, I just want to say that this is great stuff. I was truly afraid I was going to have to either stay with the older Kingmaker rules or start tracking by hand. Thank you for all the hard work.

I think I found an error: it appears that the city building: watchtower is not contributing to the overall city defense stat.

Also, I realize it is missing in UC (or at least from the prd's UC entries), but the "Brothel" building is referenced a number of times (in the discounted entry for multiple buildings):

Brothel (4 BP; must be adjacent to 1 house): A place to
pay for companionship of any sort. Economy +1, Loyalty +2;
Unrest +1.

Again, thanks for all the excellent work!

- jack

Dark Archive

Great! Just another comment: Could you incorporate the "Reserve Army" alternate rule (Ultimate Campaign) on the Army tab? Currently you are either paying the full 4 weeks, or none if army is not active. The third way is to garrison the army into a military building, and you will only pay it's consumption once per month, instead of once per week (A Yes/No/Reserve button list could do it, for example).

I see a note saying "Press F9 to update any calculations or generate a random Event". With F9 i'm only currently updating calculations, how do i exactly generate random Events? Should i press F9 in a particular tab?

Overall, great work indeed! I'm already using these for my KM Campaign =)

PD: Sawmill/w resource is incorrectly listing "Stability +1, Income +1" while it should be "Stability +2, Income +2" (although bonuses are correctly calculated, only the description is incorrect)


Pathfinder Adventure, Starfinder Adventure Path Subscriber

Awesome work!


Pathfinder Rulebook, Starfinder Roleplaying Game Subscriber

Chit Chat:
Jack Thorn wrote:
First, I just want to say that this is great stuff. I was truly afraid I was going to have to either stay with the older Kingmaker rules or start tracking by hand. Thank you for all the hard work.

Thank you and you're welcome! I was similarly terrified that I'd have to do everything by hand. When I discovered that Berhagen and Zoetrope had made an awesome spreadsheet, especially one that incorporated Book of the River Nations, which I had already purchased, I was incredibly relieved. Our group had mentioned the kingdom building rules in Ultimate Campaign which had just been released. I didn't have a copy at the time so I thought that surely the changes wouldn't be that major and I'd just use the old rules with BotRN and some house rules. When the kingdom building rules were posted to d20pfsrd.com, I couldn't help myself and had to look at them to see how they addressed the few problems many people were having with things like deposits/withdrawals and magic items. Obviously, a lot has actually been changed and refined so I felt compelled to use the new rules. Given that nobody had really started converting the spreadsheet to the UC rules and with the founding of our campaign's kingdom imminent, I pretty much HAD to just suck it up and work on the spreadsheet myself. It has really paid off for us so far. Our group has made it through 16 months in total and I think they might finally head back out into the wilderness for some more adventure soon. :)

Jack Thorn wrote:
I think I found an error: it appears that the city building: watchtower is not contributing to the overall city defense stat.

You are absolutely correct! I must have missed it somehow when I was punching all the building numbers into the tables. Thanks for catching this!

Kord_Avatar wrote:
Sawmill/w resource is incorrectly listing "Stability +1, Income +1" while it should be "Stability +2, Income +2" (although bonuses are correctly calculated, only the description is incorrect)

You are absolutely correct, as well! Thanks for catching this!

The aforementioned Watchtower and Sawmill errors have been fixed and I've uploaded a quick bugfix version to the same download location as the previously posted version 4.2 download links.

Kord_Avatar wrote:
I see a note saying "Press F9 to update any calculations or generate a random Event". With F9 i'm only currently updating calculations, how do i exactly generate random Events? Should i press F9 in a particular tab?

Sorry about that! This was left over from the pre-Ultimate Campaign version of the sheet. Zoetrope had added an Event Generator, which is what the instructions were referring to. The Event Generator hasn't been a priority for me yet, so I've removed it temporarily until I get a chance to rework everything for the Ultimate Campaign update. If you'd like, you can use the pre-Ultimate Campaign sheet to generate events. I've uploaded it for you here if you don't want to hunt for it. I hope to get the Event Generator added back in at some point, so thanks for "voting"; I'll bump it up on my list of priorities :)

Jack Thorn wrote:

Also, I realize it is missing in UC (or at least from the prd's UC entries), but the "Brothel" building is referenced a number of times (in the discounted entry for multiple buildings):

Brothel (4 BP; must be adjacent to 1 house): A place to pay for companionship of any sort. Economy +1, Loyalty +2; Unrest +1.

With the update to Ultimate Campaign, Brothels have actually been renamed to "Dance Hall", presumably to make them more PG or some such nonsense. Dance Halls have the same stats as Brothels and any references to Brothels in the UC rules (such as Theaters, the Drug Den event, etc) are essentially typos and should say Dance Hall instead. I'd look for the "official" source on this but I'm too tired right now :p

Kord_Avatar wrote:
Great! Just another comment: Could you incorporate the "Reserve Army" alternate rule (Ultimate Campaign) on the Army tab? Currently you are either paying the full 4 weeks, or none if army is not active. The third way is to garrison the army into a military building, and you will only pay it's consumption once per month, instead of once per week (A Yes/No/Reserve button list could do it, for example).

Whoa, I didn't even realize there were optional rules for armies, too >_< This is definitely on my list now but it's going to have to be a little ways down the list for now. I'm sorry :( Once I get the optional rules for the kingdom building side added in, this will probably be the next thing I tackle. Thanks for pointing this out to me!


Brad Turner wrote:
With the update to Ultimate Campaign, Brothels have actually been renamed to "Dance Hall", presumably to make them more PG or some such nonsense. Dance Halls have the same stats as Brothels and any references to Brothels in the UC rules (such as Theaters, the Drug Den event, etc) are essentially typos and should say Dance Hall instead. I'd look for the "official" source on this but I'm too tired right now :p

Thanks for the clarification. After I posted, I went back in and looked for a stand-in bldg type and suspected that the Dance Hall was a reskinned Brothel. Thanks for the confirmation!

1 to 50 of 924 << first < prev | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next > last >>
Community / Forums / Paizo / Community Use / Ultimate Campaign Kingdom Tracking Spreadsheet All Messageboards

Want to post a reply? Sign in.