Training Times

[811388]

TROOP BUILD TIMES
This formula is based off the known troop build formula but does away with decimals and is helpful for long que times.

Hours : "=ROUNDDOWN((((Troop Qty*Base Time)/((1+(Geo+Boost Building)/10+(Knight/200))*(Barracks Qty+((Barracks Sum-Barracks Qty)/10))))/60)/60,0)"

Minutes : "=ROUNDDOWN(((((Troop Qty*Base Time)/((1+(Geo+Boost Building)/10+(Knight/200))*(Barracks Qty+((Barracks Sum-Barracks Qty)/10))))/60/60)-Hours)*60,0)"

Seconds: "=ROUNDUP(((((((Troop Qty*Base Time)/((1+(Geo+Boost Building)/10+(Knight/200))*(Barracks Qty+((Barracks Sum-Barracks Qty)/10))))/60/60)-Hours)*60)-Minutes)*60,0)"

Base Time
Suppy Troops 30
T1 and carts 90
T2 and wagons 480
T3 1200

Replace Boost Building with following Building level:
Use Blacksmith level: T1 Troops, Supply Troops, Supply Wagons, and Heavy Cavs
Use Stable level: Cavs and Swordsman
Use Workshop level: Supply Carts, Rams, and Cats

These specific buildings give a 10% boost to these specific troops, so you have to have them input correctly to get right times.

Troop Qty: The Amount of Troops you are planning to que.
Geo: Your Geometry research level.
Knight: The level of your knight assigned to Marshall.
Barracks Qty: The total number of barracks in your city.
Barracks Sum: The sum of all levels of every barracks
-for example: 3 Barracks, one level 9, one level 8, one level 1
-Barracks Qty: 3
-Barracks Sum: 18

P.S. This will still work if you want to calculate 1 Second Build Times as well.


Here if you want a copy and paste for the top left of an Excel Spreadsheet.
************************************************** ************
Troop Qty Base Time Geo Boost Building Knight Barracks Qty Barracks Sum
2567 =B14 10 10 212 =MAX(A17:A39) =SUM(B17:B39)

______ Hours Minutes Seconds
Training Time =ROUNDDOWN((((A2*B2)/((1+(C2+D2)/10+(E2/200))*(F2+((G2-F2)/10))))/60)/60,0) =ROUNDDOWN(((((A2*B2)/((1+(C2+D2)/10+(E2/200))*(F2+((G2-F2)/10))))/60/60)-B5)*60,0) =ROUNDUP(((((((A2*B2)/((1+(C2+D2)/10+(E2/200))*(F2+((G2-F2)/10))))/60/60)-B5)*60)-C5)*60,0)


Might====> =A2*C14

Type of Troop Base Time Might
Suppy Troops 30 0
t1 and carts 90 4
t2 and wagons 480 16
t3 1200 1200 24

Barracks City 1 lvl
1 9
2 9
3 9
4 9
5 9
6 9
7 9
8 9
9 9
10 9
11 9
12 9
13 9
14 9
15 9
16 9
17 9
18 9
19 9
20 9
21 9
22 9

************************************************** ************
DEFENSIVE UNITS BUILD TIMES
This formula is what I've found from testing, it works similarly to the troop training time formula and is accurate to the second.

Hours : "=ROUNDDOWN(((Troop Qty*Base Time)/(1+((Giant*0.1)+(Knight*0.005)))/60)/60,0)"

Minutes : "=ROUNDDOWN((((Troop Qty*Base Time)/(1+((Giant*0.1)+(Knight*0.005)))/60)/60-B5)*60,0)"

Seconds: "=ROUNDUP((((((Troop Qty*Base Time)/(1+((Giant*0.1)+(Knight*0.005)))/60)/60-B5)*60)-C5)*60,0)"

Base Time
T1 12
T2 48
T3 96

Troop Qty: The Amount of Troops you are planning to que.
Giant: Your Giant's Strength research level.
Knight: The level of your knight assigned to Foreman.

Here if you want a copy and paste for the top left of an Excel Spreadsheet.
************************************************** ************
Troop Qty Base Time Giant Knight
1000 96 10 212

______ Hours Minutes Seconds
Training Time =ROUNDDOWN(((A2*B2)/(1+((C2*0.1)+(D2*0.005)))/60)/60,0) =ROUNDDOWN((((A2*B2)/(1+((C2*0.1)+(D2*0.005)))/60)/60-B5)*60,000000000000000000000000000) =ROUNDUP((((((A2*B2)/(1+((C2*0.1)+(D2*0.005)))/60)/60-B5)*60)-C5)*60,0)


Might====> =A2*C13

Type of Troop Base Time Might
T1 12 18
T2 48 24
T3 96 30
************************************************** ************

[btgmxgh]

use this for the excel copy and paste for DEFENSIVE UNITS
************************************************** ************
Troop Qty Base Time Giant Knight
12295 96 10 212

______ Days Hours Minutes Seconds
Training Time =ROUNDDOWN(((A2*B2)/(1+((C2*0.1)+(D2*0.005)))/60)/60/24,0) =ROUNDDOWN(((((A2*B2)/(1+((C2*0.1)+(D2*0.005)))/60)/60)-B5*24),0000000000000000000000) =ROUNDDOWN((((((A2*B2)/(1+((C2*0.1)+(D2*0.005)))/60)/60)-B5*24)-C5)*60,0) =ROUNDUP((((((((A2*B2)/(1+((C2*0.1)+(D2*0.005)))/60)/60)-B5*24)-C5)*60)-D5)*60,0)


Might====> =A2*C13

Type of Troop Base Time Might
T1 12 18
T2 48 24
T3 96 30
************************************************** ************

[hvywzhroxwb]

Which building gives the boost to Ballistae?

[Guest]

Which building gives the boost to Ballistae?

Good question.. peebz?

[Guest]

Workshop

cheers