Troop training speed calculation formula (excel format ~ omit {} notes). Speed in hours = (T{cell}*B{cell}/(COUNTA({array with garrison levels})+((SUM({array with garrison levels})-COUNTA({array with garrison levels}))/10))/60{convert to minutes}/60{convert to seconds} (T x B) / (G + ((L - G) / 10)) = Total seconds to train Troops

• Total Number of troops = T
• Base Training Time = B
• Total Number of Garrisons = G
• Total Number of Upgrades/Levels = L

Dragon speed calculation formula (excel format).

• 4 level 9 garrison (sum 36 levels).
• Level 5 Rookery.
• Training 1000 SSD

• (Base Training Time is 498 seconds) = sum(1000 * 498) / ((1 + (5 / 100) * (4 + [(36 - 4) / 10)]) = 65873.01 seconds, [ABOUT 18 HOURS, 18 MINUTES]

• Total Number of troops = T
• Base Training Time = B
• Total Number of Garrisons = G
• Total Number of Upgrades/Levels = L
• Level of Rookery = R (Rookery ONLY for the City)
  • For the Outposts, training time of dragons is calculated with Level of Rookery = 0

• EX. 1 conscript will take 30s while 10 conscripts will also take 30s

I've flipped the equation around a little bit to figure out different variables. One is for finding the base training time which isn't as useful. The other, is for finding the amount of troops that you can train within a set time.

Total Number of troops = T
Base Training Time = B
Total Number of Garrisons = G
Total Number of Upgrades/Levels = L
Total Seconds it takes to Train = S

((((L - G) / 10) + G) x S) / T = Base Training Time

((((L - G) / 10) + G) x S) / B = Total Number of Troops in the Time Allotted (T)

So, to solve for base training time, the letter S represents the amount of time in seconds it takes to train the troop.

To solve for the amount of troops to train in a predetermined amount of time, S represents how long you want to train for in seconds. So what I'm using this equation for most of the time, is to figure out how many troops to train if i want them to finish in 24 hours (or 86400 seconds).

This is to be used to calculate revival times in the Spectral Ruins. (T x B x 0.15) / (DP + ((L - DP) / 10)) = Total seconds to Revive Troops (# of Troops x Base Training Time x 0.15 ) / (# of Dark Portals + (Sum of DPs Upgrades - # of DPs) /10) For Example:

• 15 DP, 1 level 10 and 14 level 9s = 136 Upgrades
• Find Base Times on Troop Breakdown
• (25 LJs x 1999s x 0.15) / (15 Dark Portals + (136 Upgrades - 15 Dark Portals) / 10) =
• (7496.25) / (15 DPs + (121) / 10) =
• (7496.25) / (27.1) = 276.6seconds = 4 minutes 36 seconds