Jake Cook's page

Thanks!

Quick question, what is defense used for? Some buildings add it but I can't see where it's used after that.

Additionally, in order to take Events into account for city adjustments, it would be necessary to add custom boxes for settlement statistics such as Crime, Society etc.

My to-do list currently looks like this:

1) Finish diplomacy sheet. Target Kingdom Economy bonus, modify Economy for kingdom. (Care: target kingdom's economy modified, too. Self referencing.)
2) Menagerie: loyalty bonus 1/4 of CR of most powerful creature. Drop down? Input CR?
3) Cistern? Share lot. Check current lot value.
4) Optional Rules.
4a) Deities and Holy Sites. Temple alignment. Drop downs. Where to squeeze into City sheet? Also, deity name? Nice to have.
4b) Expanding Settlement Modifiers. IF (kingdom overall/10 plus align)< settlement, then use settlement, else use kingdom overall/10 plus align)
4c) Forms of government (drop down on Overall, default to Autocracy or none. New cells on Overall sheet for ELS totals.)
4d) Settlement Sizes. Adjust current table to reflect lots/districts, not GMG population values. Also, tidy up: IF (name= blank, then settlement stats = "", else calculate)
4e) Exploration and Vassalage edicts. Pure BP cost and map admin? Low priority, if at all. No calculations that affect cities/kingdom to be automated.
5) Ad hoc settlement stat modifiers.
6) Comments/Notes. Overall. Cities?

Can you take a look at Shrines? Should that not be causing the unrest increment to lower?

Also, it would be nice if there was an open entry box for consumption. I build armies according to Ultimate Combat, not the Ucam system so it would be nice to be able to input that consumption there.

Would love to see Ultimate Rulership/Battle added.

Again, willing to donate towards this effort via paypal.

What do you mean by the DC being too high? Can you clarify?

Building stats are somewhat different because of Ultimate Rulership adjusts them. That may be what you are seeing.

It's hard to tell what has changed since you converted to Google spreadsheet.

Guys,

I have been working on an updated version of the sheet that included Ultimate Rulership and Ultimate Battle

I have redone almost the entire city portion of the sheet. I havent done much testing as yet. Feel free to beat it up.

https://dl.dropboxusercontent.com/u/5449166/Kingdom_Sheet_-_Ultimate_Campai gn_v4-2.xlsx