As the “Cities & Kingdoms” Rules for the Adventure Path could require quite a bit of bookkeeping as the adventure path advances and knowing my players, I have created a Kingdom Sheet in excel, including 25 “City Sheets” with some summary sheets as well. This sheet might still need some improving but calculates all relevant numbers based on the decisions players make, events, buildings etc.

However, I am not sure about an appropriate location to post this sample to, so if people have advice on where I could put this up, I would be more than willing to share and update the file.

For the Kingdom rules, I created an excel file which does most of the calculations for you. It might be of use to some of you:

Kingmaker Kingdom Sheet

For the vacant penalties to apply you have to use "Vacant" as a character name.

For the vacant penalties to apply you have to use "Vacant" as a character name.

Poor King Vacant of Nohexland, his rule was short and unsuccessful.

Kingmaker Kingdom Sheet

Just to inform people, it is a FileFactory link.

To download/view the file you have to scroll all the way to the bottom, and just above the "Share" button you will see two image buttons, the one on the right says "DOWNLOAD NOW with FileFactory Basic."

Click on that and wait the 30 seconds or so, then when it reloads and tells you it is ready, scroll all the way to the bottom again and this time the link text on the left reads "Download with FileFactory Basic."

Click on that to download/open the file.

All other links/images with the word Download in them are ads/links to other websites.

Thanks for that explanation..... indeed it isn't optimal, but it was the only quick fileshare I found. If people have other ideas.... let me know and I will try to accomodate a more convenient way of downloading.

Looks pretty good.

One quick question though: When I start to build a city, it doesn't show up in the consumption line. Also, if I build a city which has multiple districts, how do I specify that?

I also noticed that the city base value starts at 0 rather than 200 as it should.

I simply cannot get it to work. The links keep sending me in circles. Am I missing something?

Thanks for that explanation..... indeed it isn't optimal, but it was the only quick fileshare I found. If people have other ideas.... let me know and I will try to accomodate a more convenient way of downloading.

Submit it to the Pathfinder Database!

Thanks for that explanation..... indeed it isn't optimal, but it was the only quick fileshare I found. If people have other ideas.... let me know and I will try to accomodate a more convenient way of downloading.

Rapidshare or Megaupload

"Miscellaneous" and "Vacancies" are misspelled on the sheet.

The separator line between Loyalty and Stability has + and - signs in it. I found that when I was altering the cell sizes so it would fit on my netbook screen without scrolling

Excellent resource! I'll be using this a lot, methinks. :D

I slapped this up on my Google Docs account, and set it to allow anyone to download it. Hope you don't mind. File is available here; if you want me to pull it, just lemme know and I'll yank it down ASAP.

The Kingdom page needs an entry under Resources for the +1 Econ Resources. Maybe re-name the header as "Special Resources"?

Thanks for the input!

I will put up an update later today, as it seems some stuff got broken while I reformatted the whole sheet.

An updated version has been issued. Please provide me with your comments so I can further improve the document. The link below uses Rapidshare.

Kingmaker Kingdom Sheet V1.1

Version 1.1

Corrections:
- Special Resources added to the Kingdom Sheet
- Consumption calculation for cities corrected
- Starting City Base Value included in Base Value calculation. Max Base Value set at 16000
- Corrected Miscellaneous minor spelling and formatting errors

Upgrades
- "Pop-Up" Information implemented throughout the document
- Multiple District City function incorporated
- Vacancy calculation updated to base vacancies on empty "Name" fields
- Data validation included in the City Sheet

This is awesome, thanks!

I also made mine. right now it only manage 1 city of 3 districs but everything is almost automatic :)

excel 2007 needed
only the yellow cells need to be filled-in and voilà!

link to the .rar file

screenshots pic 1 pic 2

links will work much better with the correct website :-)

Has anyone given the most recent version of the sheet a try? If people have comments for improvement, let me know and I will try to get it implemented.

Thanks for that explanation..... indeed it isn't optimal, but it was the only quick fileshare I found. If people have other ideas.... let me know and I will try to accomodate a more convenient way of downloading.

Scribd.com also works.

Has anyone given the most recent version of the sheet a try? If people have comments for improvement, let me know and I will try to get it implemented.

I did not see your update until now, good job.

edit: In the individual city tabs could you add spaces for each city's magic items. I know it's simple and most of us could do it on our own, but I am a lazy DM.

Excellent job Rob and thank you for this.

1 thing I would like to point out is that City walls don't take up a square, they are borders, so they should not add to a city's population.

Has anyone given the most recent version of the sheet a try? If people have comments for improvement, let me know and I will try to get it implemented.

I know that many other things effect unrest, but it would be nice for the unrest from the buildings to be totaled somewhere, it seems to be the only stat the buildings give that isn't in the city summary pages or at all automated on the overview, just a thought, so that when you get to 2-3 distracts, you don't need to go through everything to see what unrest you have from the buildings, and what is from other things

Rob Vermeulen wrote:

Has anyone given the most recent version of the sheet a try? If people have comments for improvement, let me know and I will try to get it implemented.

I know that many other things effect unrest, but it would be nice for the unrest from the buildings to be totaled somewhere, it seems to be the only stat the buildings give that isn't in the city summary pages or at all automated on the overview, just a thought, so that when you get to 2-3 distracts, you don't need to go through everything to see what unrest you have from the buildings, and what is from other things

The Unrest +/- from buildings is a one time effect that happens when the building is constructed.

Correct.... which is why it isn't included. I expect to provide version 1.3 of my sheet. (With minor errata and the items fields included) later today.

And here it is: Version 1.3 (it seems that I skipped posting version 1.2….)

Version 1.2

Corrections
Errata regarding Barracks, Exotic Craftsman, Gravyard, Watchtower implemented

Version 1.3

Corrections
Updated calculations as not to count walls for population.

Updates
Added cells for magic items, reformatted city sheets to accommodate changes

Kingmaker Kingdom Sheet V1.3

And here it is: Version 1.3 (it seems that I skipped posting version 1.2….)

Version 1.2

Corrections
Errata regarding Barracks, Exotic Craftsman, Gravyard, Watchtower implemented

Version 1.3

Corrections
Updated calculations as not to count walls for population.

Updates
Added cells for magic items, reformatted city sheets to accommodate changes

Kingmaker Kingdom Sheet V1.3

thanks

Oooh, this is awesome. :)
Thanks!

One thing.
Vacant penalties to economy, loyalty, stability are applied if the leadership names are empty, but the unrest increase applies if they say 'vacant'.

Oooh, this is awesome. :)

Thanks!

One thing.
Vacant penalties to economy, loyalty, stability are applied if the leadership names are empty, but the unrest increase applies if they say 'vacant'.

Good point. I have adjusted it:

Kingmaker Kingdom Sheet V1.4

This looks very nice! Has anyone tested to see if this works properly when converted to older versions of excel?

It works fine when imported into both OpenOffice's Calc and Excel 2003. Beyond that I can't say for certain.

The forumlae aren't all thatcomplicated, there's just a lot of them so cross-version and even cross-program compatibility isn't that much of an issue.

Another error I think I found.
If you put in 8 roads the economy bonus will transfer to the 'Overall' sheet, but the stability bonus will not. I guess this is because cell N12 on the 'Overall' sheet says "=Kingdom!T4" and not "=Kingdom!D8".

I've found a minor issue where the City Summary page doesn't enherit the city names from City 2 (and maybe more).

It seems I messed up the city summary page when reformatting the magic items. I will post an update hopefully later this week.

And version 1.5:

Kingmaker Sheet V1.5

And version 1.5:

Kingmaker Sheet V1.5

Someone asked for testing on this for different versions of excel.

In excel 2003, it does not support more than 7 layers of nesting for formulas. The error displayed, in those cases, is #VALUE! and appears to show up in the City Summary Tab, in the bottom field in the Major Buildings area for each summarized city.

Otherwise, it appears to work great. THANKYOUTHANKYOUTHANKYOUTHANKYOU!

Did I mention thanks?

There's an error in the formula for the Major Buildings section of the City Summary sheet. The last entry has the following code:

Some questions:

A) Any update after 1.5?
B) Anyone make the change suggested by Kvantum?
C) Did Berhagen replace Rob Vermeulen in editing the spreadsheet?

A) Any update after 1.5?

B) Anyone make the change suggested by Kvantum?
C) Did Berhagen replace Rob Vermeulen in editing the spreadsheet?

A) Not yet, I will make a larger update with the army rules somewhere in the upcoming weeks (version 2.0)

B) As this is a relatively minor update, I will incorporate it into version 2.0

C) Well: Yes and No....... as they are the same person. I just switched avatars

How do you add another city? do you just copy or is there a way to create city 2?

There should be 25 cities........ I assumed that would be enough to start with.

There should be 25 cities........ I assumed that would be enough to start with.

Yep there are now, after redownloading.

It's very nice and I plan on using it, but when I converted it to Google documents, I noticed that in the city sections on row 15 (which normally doesn't appear) Arena is written. On Google documents this makes it appear like there is a double entry when in reality line 15 does nothing. So, if you have the time, that could be removed, just to ease the formatting from excel to Google. Also, if anyone else can answer this, when I put it up on Google, it changes the color of the words to black in the cells with a black background, again easily fixed by removing the black background, but I was wondering if this could somehow be fixed to convert properly.

I believe I'll have some other suggestions for functions, once we start using it in my game, which should be this weekend. Thanks for all your work.

And version 1.5:

Kingmaker Sheet V1.5

I'm getting an odd error when naming cities: City 1's name propagates to the Kingdom Summary sheet just fine, but none of the other cities will do so.

Is it me doing something wrong, or is it an actual bug?

Thanks!

It is a known bug (wrong references), which I have fixed in my draft document..... however I am a bit busy with other stuff at the moment so the next update (including armies) will take a bit longer than anticipated.....

It is a known bug (wrong references), which I have fixed in my draft document..... however I am a bit busy with other stuff at the moment so the next update (including armies) will take a bit longer than anticipated.....

My bad - mea culpa! - the error does not appear in the 1.5 version of the document. (at least for me) I plead blindness at not reading the version number earlier!

I just started using this and its great! Thank you so much for putting this together and maintaining it for the community. I can't wait to see the army rules integrated as well.

One quick question. Perhaps I missed the pertinent errata, but if taxes are set to none, shouldn't the sheet generate a +1 loyalty bonus per the chart in AP #32?

I just started using this and its great! Thank you so much for putting this together and maintaining it for the community. I can't wait to see the army rules integrated as well.

One quick question. Perhaps I missed the pertinent errata, but if taxes are set to none, shouldn't the sheet generate a +1 loyalty bonus per the chart in AP #32?

I noticed this and fixed it my self. All you have to do is unprotect the kingdom page, you can do this from Home - Cells - Format, it's near the bottom on the drop down menu.

Then show formulas, it's at the top of the formula auditing bar in formulas.

after that click on the loyalty column of taxes and look for this "(IF(N39="None",0)" in the function bat at the top, change the 0 to a 1. hide formula's and re-protect the page and BAM your done.

Hope this helped.

I have started using the spreadsheet and I would also like to give my thanks as I believe it will prove very useful whenever we start this AP.

Allow me to add my thanks and kudos!

Btw, has anyone found a way around the #VALUE thing popping up on the city sheets? (haven't tried fixing it yet)

Hello All, I am actively working on version 2.0 of the worksheet and am likely to provide the updated version later today or later this week. If there are any major issues outstanding, please let me know and I will try to address them.

And there it is, with some delay Version 2.0!

Here is the link. Kingmaker Kingdom Sheet Version 2.0

Army sheets and and overall Army Summary Sheet have been included. Some minor corrections were made.

If you find any bugs, please post them here and I will try to correct them.