I decided to make my own troop production sheet with a few additions. Heres a screen dump of it:
For one i added some ideas that people suggested including separation of Military Science and Metal Casing.
I also added All the resource cost of the troops including the Achievement reduction buffs.
Finally an I added in the time it takes and resource cost of a certain number of troops.
It very simple to understand how to work it... Just enter hero attack, troop type from a drop down, the amount of troops you want an estimate of time on, your academy levels, achievement buffs and finally the number of barracks in each city.
If anyone is interested in it here is the link: https://docs.google.com/leaf?id=0B2Z...thkey=COzEwuwC