KOC: Calculating Training Time for T1, T2, & T3 Troops

THE IMPORTANT VARIABLES ARE:
Geometry Research, Blacksmith Lvl, Marshal Knight Lvl, Number of Barracks & Sum of Lvl of all Barracks
The formula is:
Training Time in Seconds = (Troop Qty * Base Time) / (( 1 + (Geometry + Blacksmith)/10 + (Knight / 200)) * (Barracks Qty + ((Barracks Sum - Barracks Qty) / 10)))

Base time is the baseline time in seconds required to train a particular Tier of Troops To calculate how much time it would take to train a particular number of troops you can enter by adjusting numbers in the table below.  You can enter quantity of troops, your levels of Geometry etc. (You cannot change the Base Time as that is fixed)

The time will be calculated in the rows below as total time in seconds or in minutes or hours.
Copy and Paste the table below into excel.  The formulas you need are below the table, you can copy the formulas paste them in excel.

Before you paste make sure you click on cell A1.

Variables	TIER1	TIER2	TIER3
Troop Qty	1325	1000	1000
Base Time	90	480	1200
Geometry	9	9	9
Blacksmith	6	9	9
Knight Lvl	0	64	107
Barracks Qty	7	8	8
Barracks Sum	13	53	72
Total Training time in:
Seconds	6276.32	12307.69	24987.51
Minutes	104.61	205.13	416.46
Hours	1.74	3.42	6.94

In Cell B10 paste the following formula: =(B2*B3)/((1+(B4+B5)/10+(B6/200))*(B7+((B8-B7)/10)))
In Cell B11 paste the following formula: =B10/60
In Cell B12 Paste the following formula: =B11/60

When these formulas are in you can copy and paste them to columns C & D

The table below shows how long it takes to gain might for each of the three Tiers based on the might of each tier divided by the base time to train that tier

Might	4	16	24
Might/sec	0.04	0.03	0.02

Conclusion: you gain might twice as fast by training Tier 1 than Tier 3 troops