|
We just did our first session of kingdom building last week. During play I noticed that there was not a line for river hexes on the kingdom tab just road. You can not just add them to the Road line as that also adds 1 stability for each 8 roads and river only adds to economy. Is it tucked away somewhere I did not notice?
I am also toying around with using Villages and Towns from a different thread. Towns and Villages . It was easy enough to add the line for rivers but where does the sheet total up Consumption?
|
| 2 people marked this as a favorite. |
oh...my...gosh!
This is the very reason I have fallen in love with Pathfinder and its creator's. The communication, the development of game aids, and the friendliness and willingness of everyone to talk and discuss. It's one of the reasons that I bought the "Book of the River Kingdoms". A big thank you to Dale for putting this on his website and helping the creator of the spreadsheet to make it better.
Thank you! Don't stop what you're doing. You folks are awesome.
also, dotting for future reference. :)
| 1 person marked this as a favorite. |
We just did our first session of kingdom building last week. During play I noticed that there was not a line for river hexes on the kingdom tab just road. You can not just add them to the Road line as that also adds 1 stability for each 8 roads and river only adds to economy. Is it tucked away somewhere I did not notice?
I am also toying around with using Villages and Towns from a different thread. Towns and Villages . It was easy enough to add the line for rivers but where does the sheet total up Consumption?
Heh, funny. My group also did their first session this past Saturday and asked the same question. I'll have to double check their sheet but I think there is an "other" or miscellaneous box to put stuff in and they were going to use that for the time being (I think they ended up with four river hexes).
Also, just wanted to say that the book has been really great with a lot of cool new content. The group I GM went a little wild that first session and did 4 hours of kingdom building covering 3 and half years of game time. I think it was the shiny newness of it and a change of pace so while I wanted to interrupt them with a troll attack, I let them literally go to town for awhile. At one point, I told them that Svetlana left Oleg, their treasurer, and he began drinking and huffing Perivash's euphoria breath. They built him a mansion, basically a rehab, at the old trading post. A couple of months later on the random events, I rolled the efficiency event where the treasurer saves money. Looks like rehab worked!
At one point, I told them that Svetlana left Oleg, their treasurer, and he began drinking and huffing Perivash's euphoria breath. They built him a mansion, basically a rehab, at the old trading post. A couple of months later on the random events, I rolled the efficiency event where the treasurer saves money. Looks like rehab worked!
I LOLed Alot!
|
Alright, I added some Wayfinder pieces and some more Book of the River Nations pieces (just fired it off to you in an email, Dale), so I'm going to include a list of additions and source (WF4 or WF5) and explanation to serve a little bit like instructions...
Overall Tab:
Added Lord Chancellor leadership position (WF5)
- There is an optional GM rule if the position is vacant. To enforce that penalty, choose "Yes" from the dropdown to the right of the "GM Optional Vacancy Penalty?" cell
- In the Lord Chancellor's "Bonus" cell, place the lowest mental ability score bonus (Int, Wis, Cha), as this affects one of the possible attribute choices
- From the Lord Chancellor's "Attribute" cell, pick which of the three options use wish to utilize for the position (the details for your choice will be displayed in the cell below)...
- If you chose to Negate the Vacancy Penalty for 2 other leadership positions, pick the two positions from the dropdown areas to the right (if there is no LC or one of the other options are chosen, these choices will do nothing)
- If you chose the Claim/Build option, the LC's lowest mental ability score (what you placed in the "Bonus" cell) will be automatically added in the details cell, showing you how many extra buildings you can construct this month.
- If you chose the Reduce Unrest option, the details will randomly pick a number between 1-3 (1d3) in the description area, indicating how much unrest you've reduced for that month. To "reroll" the result, you can use the F9 key or simply pick the option from the dropdown again (or totally ignore the number if you want to roll yourself)
Kingdom Tab
Added additional resources from Wayfinder
- Added Border Crossing (WF5)
- Added Fortress (WF5): since there was already a Fort from BotRN, I added this option as Fortress (Large) on the sheet
- Added Vineyards (WF4)
Added additional resources from Book of the River Nations
- Added Forest w/in 5 hexes of a City & Forest w/in 5 (with Camp): these should automatically figure into Consumption, but remember, they apply to a specific city and can't reduce that city's Consumption below 0 (since every map is different, you have to make sure to manually confirm that this isn't over-reducing the total, by crediting more reduction than your nearby city has consumption)
- Added Lairs
- Added Rivers
City Tabs
Added New Buildings from Wayfinder
- Added Bank (WF5)
- Added Fairgrounds (WF5)
- Added Foreign Quarter (WF4)
- Added Fortress of the Faith (WF4) - There is an area to the right for "Optional Consumption", choosing "Yes" in this dropdown adjusts your total Consumption, but grants a boon (described in the information when you click on the cell)
- Added Millpond (WF4)
- Added Monastery (WF5) - Since BotRN already supplied a smaller Monastery for Monk training, I've renamed that one "Monastery (Monk)" and named this structure "Monastery (Study)"
- Added Siege Works
- Added Training Site - There is an area to the right for "Optional Consumption", choosing "Yes" in this dropdown adjusts your total Consumption, but grants a boon (described in the information when you click on the cell)
- Added University (WF4) - There is an area to the right for "Optional Consumption", choosing "Yes" in this dropdown adjusts your total Consumption, but grants a boon (described in the information when you click on the cell)
I'm considering adding the expanded rules for Temples and Cathedrals in as well, but haven't gotten to it yet. In the meantime, please test this thing out and post feedback here for any issues you encounter.
The latest file sets:
|
|
I must extend my players thanks to Timothy for making the excel sheet and Dale for putting it on his store page. (I should have thanked Timothy the first time, sorry for the forgetfulness)
Then a question for Dale:
From Book of the River Nations
"Using Magic to Increase a Kingdom’s Statistics
Magic can be used to increase a kingdom’s statistics. A leader can wear a magic item that increases the ability score contributing to one of the office’s benefits. A spellcaster may also can cast a buff spell such as bull’s strength or owl’s wisdom on a leader once per day every day for the week the leader is in the capital. If the leader does not receive the benefit of the spell at least once everyday, the leader does not gain the bonus for that month."
One of my players noticed this piece. I had overlooked it.
Her reaction was: "Wow, I will take eagle splendour as soon as I get second level spells." (she is an oracle and the probable baroness)
My reply was: "A spell lasting 1 minute level will not work. You need to get the modifier for 8 hour at least, each day you are working as a leader in the capital."
I agree that one of the different stat enhancing items that boost the relevant score for a leader will increase his role benefits modifier, but I have doubts on the low duration spells. As far as I can see the option for the spell is not in the Paizo rules. I have missed it?
I must extend my players thanks to Timothy for making the excel sheet and Dale for putting it on his store page. (I should have thanked Timothy the first time, sorry for the forgetfulness)
Then a question for Dale:
From Book of the River Nations"Using Magic to Increase a Kingdom’s Statistics
Magic can be used to increase a kingdom’s statistics. A leader can wear a magic item that increases the ability score contributing to one of the office’s benefits. A spellcaster may also can cast a buff spell such as bull’s strength or owl’s wisdom on a leader once per day every day for the week the leader is in the capital. If the leader does not receive the benefit of the spell at least once everyday, the leader does not gain the bonus for that month."One of my players noticed this piece. I had overlooked it.
Her reaction was: "Wow, I will take eagle splendour as soon as I get second level spells." (she is an oracle and the probable baroness)
My reply was: "A spell lasting 1 minute level will not work. You need to get the modifier for 8 hour at least, each day you are working as a leader in the capital."I agree that one of the different stat enhancing items that boost the relevant score for a leader will increase his role benefits modifier, but I have doubts on the low duration spells. As far as I can see the option for the spell is not in the Paizo rules. I have missed it?
No, you didn't miss it. It was a question that was asked to be clarified for the final rules. My best answer is your the gm. If you feel that that rule does not work for your group, throw it out.
Oooh. I might have to switch to using this spreadsheet - I'm not sure which one I'm currently using, but it has all the buildings that got posted to the forums (I think it's Berhagen's) - since that's mostly a superset of the BotRN buildings, it's been working, but I had to add my own logic for forests, rivers, some of the other open area buildings, and so on, and I haven't touched castle improvements or mass combat.
For the convenience of my players, I converted the old sheet to a google doc that I shared (read-only) to them. Without the tooltips (which get lost on import) or the ability to edit, it still keeps the players from knowing what buildings do (I only tell them the actual numbers after they build one), and the rest works well. I'll do a similar conversion for this if I switch, and I'll share the link to that. It obviously won't be as clean as the excel version, but it might be more convenient for people.
Love this sheet, but I have some concerns.
It seems a few of the sums don't add up. On the Overall tab the Consumption totals don't reflect what I've put in other areas. For instance, I've put 6 in the size area on the Kingdom tab and it states only 5 in the Consumption area and I have 3 farms with apiaries yet it shows only 1 in the Consumption totals. In addition, I have 1 city but it shows no city under the totals in the overview/Consumption totals. Edicts seems to be the only sums that are correct though I haven't attempted armies yet. Also, population seems to be skewed as I have 6 hexes and 32 city blocks yet it totals the pop. at 9500 not 7600 (200/hex and per block). Finally in the city summary tab on the last page doesn't reflect my entries in the city 1 tab.
I'm using an older version of Excel so I hope that isn't the problem.
|
|
Everyone (especially Arengrey, because you caught it before I could get it updated), I realized that when I added the Wayfinder items in, I mucked up some references throughout the sheet. I think I've fixed them all and just sent a revised sheet to Dale to post. Please re-download the sheet if you are using the last version with the Wayfinder items added in. I think I caught everything, but please continue to test and look for any errors.
Sorry for any inconvenience.
Aren, I haven't messed with the army sections at all from Berhagen's original sheet, although I may start looking at them soon to see if anything needs updated from BotRN.
Everyone (especially Arengrey, because you caught it before I could get it updated), I realized that when I added the Wayfinder items in, I mucked up some references throughout the sheet. I think I've fixed them all and just sent a revised sheet to Dale to post. Please re-download the sheet if you are using the last version with the Wayfinder items added in. I think I caught everything, but please continue to test and look for any errors.
Sorry for any inconvenience.
Aren, I haven't messed with the army sections at all from Berhagen's original sheet, although I may start looking at them soon to see if anything needs updated from BotRN.
Thanks a bunch, I think all the work you guys do is truly helpful.
Here is the latest version of
And just to repost the link, here's the as well.
Just want to say thank you to Timothy Withem for updating the file.
Timothy,
I am having a problem with the latest version linked in Dale's post just above mine. The "leadership" scores don't add up correctly.
HERE is an .rtf document with a screen shot of the "overall" tab. (I hope I did that dropbox thingy correctly!)
Economy should be 12 not the 11 it is showing (ruler 3, magister 5, treasurer 2, warden 2).
Loyalty should be 9 not the 8 it is showing (councilor 3, marshal 3, spymaster 3).
If I check NO for vacancy penalty then economy is bumped up to 13, which is still wrong.
I am using Open Office instead of excel, so if that is the problem, *sigh*, then just let me know. But would hope not,
-- david
Papa.DRB
|
|
David,
It's not anything you're using. I couldn't see the screenshot you placed in dropbox (it wanted me to log-in), but I realized that I had the Warden and Marshall bonuses switched in the leadership numbers up top. Please note that if you have the optional Lord Chancellor vacancy penalty set to "Yes" at the bottom, your ruler's contribution will be cut in half (rounded down) if you don't have a Lord Chancellor or two Rulers, so it will make your above example a 10, instead of 12. Setting it to "No" will bump you back up to a 12. Your Loyalty issue should also be fixed.
I e-mailed you the file, as well as Dale to update when he gets a chance.
(Just to reiterate, Dale, I REALLY appreciate you constantly updating this thing when somebody calls me out on a mistake).
Thanks for keeping me on my toes!
Tim
One again: The latest version of
Repost:
Tim sent me the latest version of the excel file a few days ago and I've been busy and hadn't gotten up on the web as fast as I usually do. Sorry about that. But its up now.
|
|
I had been thinking about an additional building.
Windmill: (8BP; May only be built in grassland and hill hexes)
This structure can harness the power of the wind. Whether used for grinding grain, moving water, or cutting lumber, wherever the wind blows this structure has many uses. (May not be built in a city.) +1 Economy, +1 Stability, -1 Consumption when built in a farm or mine hex.
What do you think?
|
|
What am I missing about working the sheet? I am unable to have the army stats add up and apply to consumption. Anyone else have this issue?
I noticed the same thing. There are a couple of equations that are referencing the wrong cells. Just need to fix those and it will work properly. I don't remember off-hand which ones and its been a while since I fixed it myself.
CEO
|
In case somebody is making changes to this spreadsheet, I noticed that the Dump doesn't increase Loyalty by +1 like it is supposed to. I noticed in the BotRN, that Dump only adds to Stability, unlike the rules in KM #2. Was this intentional? Also, the bonuses for the Warden and the Marshall are switched around. Again, intentional?
-Lisa
|
|
| 1 person marked this as a favorite. |
The switch between the Warden and the Marshall bonuses is intentional as the roles have been switched to better reflect what where the warden and marshall roles in medieval times. It was explained in one of the different threads about BotRN.
No idea about the dump.
Diego Rossi is correct. The Marshall and Warden were intentionally switched for the above stated reason.
The Dump was intentionally changed for balance reasons. It was a 4 BP building that provided the bonus of a 6 BP building. I didn't feel that I could really justify the cost of a Mill or a Brewery for a plot of land to throw junk so we lowered the bonus to the +1 Stability. There was similar discussion on the kingdom building thread about doing similar so I made the change.
Latest version:
And to Repost:
I can host it in DropBox, if you want to send me the .ods file, although, I figure that Dale will want to host it also.
-- david
Papa.DRB
I've added many of the improvements that RuyanVe did for the OpenOffice/LibreOffice version into this. Who should I send it to to have it added to the list?
Updates
--Added PC/NPC sheet where DM can add all of the stats and can use drop downs to fill positions of office
--Added rules from the book to help DM run thru the phases
--Added Buildings sheet to show what each building does
--Fixed some of the Loy/Stab/Econ stats as they were wrong on the city sheets
--Fixed the Leadership to actually add the subsequent addition for rulers(wasn't adding subsequent only the first ability)
--Added a auto-calculate for unrest(although it is not 100% correct, need to figure out how to account for all possibilities)
Maybe I missed this somewhere, but where/how do I add more city and army tabs? My group has (finally!) made it into the 'Beyond Kingmaker' section of SoaTS and we are beginning to run out of tabs to keep up with everything.
Also, my thanks to all you guys and gals for putting in the extra effort and sharing it!
The Sheet is awesome.. unfortunatly It will not run on my tablet (Andriod, tried both, Excel & Open office version). :(
NeoFax Excel Kingdom Sheet with BotRN material HERE
-- david
Papa.DRB
Very very very cool tool, thanks for the work put into this folks -- it will save much time and energy for my campaign.
Any chance that someone is working on an android/iPhone port for this badboy?
|
|
NeoFax and Papa-DRB,
So glad to see you guys taking this thing and running further with it (and posting it). My life has been so hectic lately, I've barely had time to game and no extra to dabble further with this sheet.
Neo, I love the additions you've put in and will most likely import them into my game sheet.
You guys rock!
The latest copy of NeoFax's Excel Kingdom Sheet with BotRN material will always be HERE. The link above is no longer valid.
-- david
Papa.DRB
ps. He just sent me an updated copy and I am running out of free storage, so I will be renaming any new one to the name in this link.
|
|
The latest copy of NeoFax's Excel Kingdom Sheet with BotRN material will always be HERE. The link above is no longer valid.
-- david
Papa.DRBps. He just sent me an updated copy and I am running out of free storage, so I will be renaming any new one to the name in this link.
thnx Papa
I have just two complaints really.
One, the sheet doesn't come to the person downloading it as a blank sheet. Just means that it takes much longer to update the sheet for the first time because so much of the sheet has to be erased before personal kingdoms can be put in.
The other complaint is that the magic items are not compiled correctly, with no total tables for the minor, medium and major items. Other than that though, its an amazing spreadsheet.
In the city summary, it shows me only the minor items for the city shown in city 1. Other than that, it is a case of I need to flick through the individual cities in order to total it up by hand. Its a minor problem, but one that takes time each time that I am working on the kingdom initially to once again find the numbers.
On saying that however, I really like the addition of even more custom content of the buildings. It is a really nice spreadsheet that I think works well. It just has in my opinion a couple of minor things that might even be possible to attribute to me incorrectly doing something on the sheet
RPG Superstar Season 9 Top 16, RPG Superstar 2015 Top 32
|
Can we have the spreadsheet be in a format compatible with earlier versions of excel? I am running this on an older machine, and thus Excel 2010 files won't work for me.The file is for Excel 2007. I can try saving it as 2003, but the Optional Cathedral and Temple rules will have to go as earlier versions of Excel cannot handle the formulas and functions I used. Namely dynamic arrays.
I just downloaded the compatibiliy pack that Microsoft has, but there are several places where the program indicates there is code not compatible with my version.
The cells right next to "minor items", "medium items", and "major items," in each of the city sheets. In fact, anywhere that is supposed to show the number of magic items available.
The cell directly under the "Lord Ch. Attribute Details," cell in the overall sheet.
Besides those, I haven't found anything else that isn't backwards compatible.
I should be able to use this sheet as it is, even with the issues.
|
OK, fixed the City Summary problem for all of the info as the Magic Items were not the only things showing up. I do have a problem now though as the previous iterations just showed what the designer thought was the best Major Buildings you have in the city. What I want to do is show where you are at in the build pyramid. By this I mean Castle halves cost of Garrison, Garrison halves cost of Jail. So if you bought the Jail it would show that and the next step up in the build chain.
I think a few IF statements with a table of cell referencing the presences of those buildings withing the same city shouldn't be too hard. instead of a fixed number in the BP required build box, some nested IF loops that will check the values inside the building quantity boxes, then would output the adjusted values for their respective costs.
if(condition, true value, false value)
if(waterfront = 1), market BP = 24, market BP = 48)
I have deleted all of my campaigns info, so you can start from scratch. I would also like to know if a semi-automated way to do the phase process would be a good thing to add.
might be helpful at first, but as the kingdom grows, I don't think it'd be as much of a benefit. I'd be interested to see it in action though.
|
|
So you would want to be able to list the highest ranked building from a particular segment of the economy and its half-priced counterparts if they too are built?
I think just looking at the building sheet to see what you have in your city is a simple enough process to analyze where you are at in your build phase. I don't know if showing the escalation of buildings or their subsequent next step or included constructions would provide any benefit or additional information that one couldn't glean from a quick glance at the sheet.
I may still not have a grasp over the concept. I don't at all want to bash it or hinder your productive attitude and ambition. I think the work you've done so far is very good and there may yet be additions that would craft the product into an even better version.
I've got some KM stuff running this weekend, going thru a lot of months of build time. I'll try and evaluate the process using the sheet and see what might aid it going from a ground up perspective.
Can we have the spreadsheet be in a format compatible with earlier versions of excel? I am running this on an older machine, and thus Excel 2010 files won't work for me.
I uploaded the XLS file to Google Docs, where I edit the thing. I don't have a current version of Office for my Mac, so GDocs does the trick - and plus, I publish the document to the web through GDocs and post the link on my Obsidian Portal wiki page so my players can see their kingdom in numbers, if they want to.