Attack calculations

Ok. I'm working on a spreadsheet that will calculate how many fort infantry you can kill.

Here is my math so far

First is this right? (Assume Parathensis are functions, I know 1 atk is 0.5%)
(Base Atk)*(TechBonus)*(Attrib)*(#ofUnit)=DamageDealt

Second is this correct?
DamageDealt/(#ofEnemy*EnemyHealthPlusArmor)=#enemykilled

I'm getting close numbers with this formula but not right. Actually I end up killing about 8% more than predicted with 5000 cats. Does size of the army introduce some modifier?

Ok. I'm working on a spreadsheet that will calculate how many fort infantry you can kill.

Here is my math so far

First is this right? (Assume Parathensis are functions, I know 1 atk is 0.5%)
(Base Atk)*(TechBonus)*(Attrib)*(#ofUnit)=DamageDealt

Second is this correct?
DamageDealt/(#ofEnemy*EnemyHealthPlusArmor)=#enemykilled

I'm getting close numbers with this formula but not right. Actually I end up killing about 8% more than predicted with 5000 cats. Does size of the army introduce some modifier?

I don't believe amt of troops effects the actual stats per kill ratio or whatever, did you include the life a troop has? (is that health?) If it is you forgot to add defense to your equation... Good luck with figuring it out

Edit: viewtopic.php?f=59&t=37&p=371#p371 you might be missing this

That did it! Thanks a bunch I'll be posting the spreadsheet sometime today. Thanks a ton, I never could have dug that up

I've taken this information and placed it a spreadsheet along with unit attack info that dynamically updates with attrib and tech. It also allows calculates estimated kills against NPC's.

I added you to the credits sheet. Thanks for all the help

uh... where is the spreadsheet? i really want to take advantage of it. Also is there an attack calculator for when u attack another player that is not an app but online?

viewtopic.php?f=59&t=10355