This is just a simple spreadsheet I made to help with troop production estimations. This will probably be most useful only to those who plan on capping NPHCs; giving them an estimated time of the earliest date they can attack. I also wouldn't be surprised if someone already made one of these. Anyhow..
First part [Blue section]
City-you can type in the name of your own cities here
Barracks-enter in the number of barracks you have in that town [Note: Should be the number of barracks that can make the certain troop, i.e. if you only have 1 level 10 barrack and are interested in the production rate of catapults, enter only 1]
Total Units-enter in the total number of units you will be making
Hours/Minutes/Seconds-enter these values
Total Hours-do not touch, I should have put this in the output section, but I didn't, oh well
Output Section-do not modify these cells
Time per barrack [in hours]-this is basically like how it is in game.
24 Hour production Rate-this value is the rate of production of the total units you entered per 24 hours [the name can be confusing once you start messing with random numbers]
Total 24 Hour production-The main purpose, how many of the certain type of troop you can make in that city
There is a grand total value at the bottom meant for all your cities
Notes: If you do not have 10 cities, just enter any number for barracks and time but keep total unit number at 0
You can also find out an estimated troop production rate by just entering 1 troop and the time it takes to make a single unit.
Second Part [Lonely Gray Space]
Just something I decided to throw in. Here you can find out estimated troop build times with any attack hero.
Attack-your hero's attack
Military science-current level in that city
Build time-time it takes to build that unit in seconds
Time in m/s-time converted to minutes and seconds. Note: This is NOT accurate, my version of excel will not let me round down on certain functions so some values are rounded up 1 second.
Credits to The Real McCoy for the formula and theevonywiki for default troop build times.