Kingdom:

Let's assume you just took control of your new virgin kingdom, with no further buildings, improvements and an empty capital. That sounds shomehow depressing, so let's do something about it! Switch to the "Kingdom" table, scroll up to the top and add your kingom start values into the yellow cells in the table header - of course, year and month start with a value of 1 (these values will not be used for calculation by the sheet, it is just for player information about the time passed). Set your buildpoints (BP), unrest and kingdom size to the values provided by your GM. By default, it is 50 BP, 0 unrest and 1 kingdom size for the Kingmaker campaign. Also add your kingdom's alignment with according bonuses to the header. The page header provides a lot of valuable information throughout the entire campaign, for example the control-DC, the buildpoints you may expect next month (minimum, maximum and average), as well as the amount of buildpoints lost by consumption (differing in net and real consumption - net consumption is the consumption you have to use to calculate the buildpoints you will acquire. Real consumption is basicly the same, but may be negative when having a lot of farms - so, real consumption shows you the farm-based buffer your kingdom may have when expanding).

So, you established the basics of your new kingdom. Great! Now, the players have to decide, which position they will take within the government. Scroll down to the "Leadership" section. Add the player names to the post they want to take over and also add the bonus attribute mod (the mod, not the attribute value!) to the kingdom value they want to push (loyality, stability or economy). Last, set the "Absent" cell to "no", since these posts are now handeled and no penalty for empty post should be applied. Empty posts, as well as posts handled by characters which are out of office for more than a month should be set to "Absent" -> "yes", so the penalty can be calculated by the sheet.

You will see by now, that many kingdom parameters are already calculated for you. Look at the graphics to the top and to the right, which show you the amount of loyality, stability and economy points already earned - and how high the chance of failing the control-DC roll will be.

That's it about setting up your kingdom. Furthermore, we should take a look at the remaining sections of the kingdom table, which are "Edicts" and "Improvements and Buildings". Via the "Edicts" section, you can set which edicts are currently applied in the kingdom, the resulting bonus and penalty is calculated automatically. Some buildings, e.g. the cathedral, reduce the penalty for certain edicts. If at least one of these buildings exists within your kingdom, set the accordant "Reduced Penalty" cell to "yes". Beneath the "Edicts" section, you will see "Improvements and Buildings", where you can keep track of the bonuses provided by your cities and kingdom improvements. While city bonuses are provided by buildings located within the cities (which will be explained later), kingdom improvements are provided by structures on the world map, e.g. aqueducts or quarries. Just enter the amount of your improvements in the respective lines and the bonuses are added up by the sheet.

The "Improvements and Buildings" section is used for another purpose: You can keep track of current events within your kingdom, like droughts or traders from foreign cultures. Just enter a descriptional text, an end date (when the event expires) and a bonus / penalty to the section. Note, that the events must be removed by hand as soon as they expire - the end date is not used by the sheet, it's just for player information.

Cities:

Your kingdom is set up, time to take care of your capital! Switch to the "City 1" Table (you may rename this table at will, Excel will rename all relations to this table automatically) and scroll up to the top. The header will show you all bonuses the city will provide to your kingdom - since there are currently no buildings yet, all bonuses will show 0 of course. First, the characters have to decide (or the GM dictates) the city's qualities. Add the city alignment, government, quality and penalty to the respective cells. Some GMs don't use these city modifiers. In that case, just leave the cells empty.

Now it's time to have a look how to construct buildings. Scroll down until you see a district view with a lot of green meadows. Noticed the yellow cells above each lot? Click on it to get a list of available buildings and select one. And that's it already! The building's image will be loaded and displayed and all kingdom- and city-related parameters, like bonuses to loyality or penalties to crime, will be calculated instantly. Of course, the BP will not be subtracted from the "Kingdom" table, which you will have to do manually - so feel free to experiment. Some buildings, like town halls or castles, take up more than 1 lot, so you have to select "town hall" or "castle" for several lots. For these large buildings, a suffix is added to the name, indicating the lot it should be used for. Buildings, which take up 2 lots, use these suffixes: L (left), R (right), U (up), D (down). Buildings with 4 lots use these suffixes: LL (lower left), LR (lower right), UL (upper left), UR (upper right).

You can also give each district an individual name, like "historic center" or "downtown", and set the distric's surroundings, e.g. water to the south and rocks to the west. Some buildings don't take up lots, since they are part of the entire district (sewer) or are part of another building (well). Scroll down below the districts section until you see a large list of buildings. Some cells of this section are marked yellow, so you may manipulate them. Add the amount of these lot-less buildings in your city to these cells, so the sheet can compute them.

Last but no least, scroll down further until you see a list for magical items. Here, you can keep track of magical items available within the city.

Army:

No kingdom will last without an army - at least not very long. Switch to the "Army" table. This one is quite self-explaining, if you are familiar with the kingdom rules, so there is not much to say here. Enter your armies and generals to the table and you are good to go!

Things you have to do manually:

- Turn order: Of course, you have to do the turn order manually (and do a lot of roleplay after all), since this is not an Excel game, its a sheet to keep track of your game!

- Add / substract buildpoints (BP): No "game logics" are within the sheet, so adding and substracting BP has to be done by the players.

- Rise / lower Unrest: The effects of unrest (penalty on all kingdom stats) are calculated by the sheet. Updating unrest has to be done by the players.

- Handling events and adding magic items: This *may* change in the future, e.g. by adding a random magic item generator, which fills up the empty magic items slots of your cities when clicking a "fill item slots" button.

- Worlmap: Hard to do a hex-map in Excel (not completely impossible though), so you have to keep track of this on paper / roll20.net, i'm very sorry about that!

"Secrets" and more:

- You can add a banner to the "Kingdom" table! Go to the "Database" table, look for the "Paths" section and add a URL to a banner of your choice.

- Add some new leadership roles to your kingdom or rework the old ones! Go to the "Database" table and look for the "Leadership Roles" section. Even though most of the cells are blue, you can edit them to change the penalties without wasting the table.

- Want to change some building or improvement parameters? Go to the "Database" table and change stuff at will! Please note, that the columns "Unrest", "BP-cost", "Efficiency" and "Discount" are not used by the sheet, they are basically just implemented for my own amusement. ;-). If you wonder, "Efficiency" calculates the amount of kingdom stats gained by the building (and generated unrest substracted), divided by its BP cost. So, the higher the efficiency, the more bang you will get for the buck!

Please, feel free to use the sheet at will. If you find any bugs (you probably will) or want some special features added, leave a comment! :-)

Sources:
Gras texture: Flickr (Creative Commons 2.0 Lizenz)

Building textures: Kingmaker Campaign / Ultimate Campaign