Hola,
I've been trying to replicate the draft costs on my prov and using an Excel calculator I have been unable to. I am able to replicate number of soldiers drafted but not the cost. I've come across a couple issues:
Issue #1
Military page shows costs as:
Reservist - 23gc
Normal - 39gc
Aggressive - 58gc
Emergency - 86gc
Building Efficiency is 86.8%.
Armouries percentage is 17.7% (70 acres in 396 acre prov). Buildings page shows this should mean a 25.27% decrease in draft costs.
[I calculate a 25.29% discount but that can easily be attributed to BE being held in system to more decimals and rounded up to 86.8%, so I ignore that difference]
If I apply that discount (25.27%) to proper rates I get the following information:
Draft Rate Normal Cost Reduced Cost Reduction % Calculated Cost Reservist 30 23 23.33% 22.4 Normal 50 39 22% 37.365 Aggressive 75 58 22.667% 56.05 Emergency 110 86 21.81% 82.2
So none of the values seem to match to the 25.27% discount. This obviously leads to me not being able to match the draft cost value.
Issue #2
The easiest check up front to know there were issues was to take total draft costs / drafted solds. In my case, 1222 / 42 = 29.09524 (As I'm in EOWCF so 50% lower). If I double that value I get 58.190476 per troop. This obviously does not match to the expected 32 * 58 = 1218.
Basically the math just isn't adding up even just using values displayed on utopia pages.
I've noticed other anomalies while creating my full Spreadsheet with formulae (Such as being unable to match Income nor Wages values) but lets see responses on these ones first. ;)
Cheers
POiD