Recruiting spreadsheet tool

Here’s another automated database for use in recruiting mercenaries.

https://drive.google.com/file/d/0B9zRKIFi3z7tdnB4NzJFdTJVWWc/edit?usp=sharing

This should automatically:

  1. Roll the random values for recruitment costs, or for each type’s availability at a market.

  2. Adjust mercenary crop sizes for realm populations.

  3. Break down arrivals into weeks (with default rounding, since I can’t figure out how to get Excel to “round down” for the second week!)

  4. Create a small table estimating the success probability of hiring offer rolls, and (optionally) apply estimated average success rates to the numbers in the table, for situations where you don’t want to roleplay out the negotiations in full detail.

  5. Create a column for the total availability of mercenaries at that market, so you can tell if you’ve hired beyond the 50% threshold and driven up mercenary wages due to scarcity!

Instructions: Enter values in all of the cells listed below.

  • Market/Realm - Enter either the word “Market”, or the realm level (e.g. “Duchy”) for the location where you are recruiting.

  • Class/Population - For a market, enter the roman numeral that indicates its class. For a realm, enter the population in families.

  • Estimate Acceptance - If you put “Y” here, this will automatically reduce mercenary availability by a factor given by the probability of the two “success” results on the hiring offer table, relative to the “failure” results. If you put “N”, it will just give total availability, and you can divide them into unit-sized groups and conduct negotiations per the rules.

  • Reaction Modifier - Enter any Charisma (or other situational) bonus to hiring. Enter a negative number for a penalty. Values must be between -6 and +6.

  • Exotic Cost - If you want to recruit an exotic unit (subject to Judge’s approval!), enter the cost of a single unit of that type.

  • Race - Enter the appropriate race for the location (Human, Dwarven, Elven, Orc, etc), to apply a filter for unit availability restrictions.

  • You can also change the exotic subtype (Animal, Ooze, Prehistoric, etc), at the beginning of its row of the output table, to adjust the costs for exotic recruitment by the proper factor.

Note: Any time you change any input value, it re-rolls all the random cells. Unfortunately there’s no way to change input parameters without generating an entirely new re-randomized table.

Wow. This looks amazing! Thank you!