| 2 people marked this as a favorite. |
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.
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.
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!
|
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.
This is awesome, thanks!
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
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
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 implementedVersion 1.3
Corrections
Updated calculations as not to count walls for population.Updates
Added cells for magic items, reformatted city sheets to accommodate changes
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:
This looks very nice! Has anyone tested to see if this works properly when converted to older versions of excel?
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".
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:
|
And version 1.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:
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.
And version 1.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.
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.