Unit Spreadsheet (Attack Calculations)

This is a collection of information from other guides into a dynamic Spreadsheet. This is a work in progress but is much better thanks to Nathan05, nIcKrOx, Uranos and Caladan. If you can find something wrong with my math please let me know.

It's pretty simple, fill in your info and your unit stats will be updated automatically. This should be especially helpful for those of you who arent sure if you can take a fort. This should help since you will know how many turns you have and how many NPC Units you can take out per turn based on your tech and attribute points.

The estimated kills portion only applies to NPC's since they can be predictably killed. It's not perfect but very close. 7966 cats in game killed 25112 infantry, the spreadsheet predicted 25385. Major kudos to whoever can find the 1% margin of error.

Version Update:
1.02
Fixed Catapult Health
Added Maximum Carry
Modified Credits
Added Hyperlink to this Form topic

This is currently formatted for Excel 2010.

Quick thing, I noticed when I typed in my speed tech as 8, putting 24% as the bonus, it made my defense tech 16% for some reason. When I then put in level 2 for defense tech, it didn't change it. I'll let you know if I find any other issues, thanks for the work, this program is really cool!

Quick thing, I noticed when I typed in my speed tech as 8, putting 24% as the bonus, it made my defense tech 16% for some reason. When I then put in level 2 for defense tech, it didn't change it. I'll let you know if I find any other issues, thanks for the work, this program is really cool!

Absolutely right, thanks!!!

I added you to credits as a debugger and made the fix.

1.01 is now the current version

Hehe replace my name with taems from his modified troop ratings guide

It works great now, thanks for the fix! (It does start at 8 speed tech though... )

Lol ppl will figure it out, Ill be more carefull next time thanks for your help!

Nice it works great. Thanks

Hi,
I like it, it looks good. But is the formula in "Your Adjusted Stats" Attack and Defense correct? Shoudn't it be 0,5% and not 1%.

Hi,
I like it, it looks good. But is the formula in "Your Adjusted Stats" Attack and Defense correct? Shoudn't it be 0,5% and not 1%.

Your right but changing it doesnt give good numbers. I just ran a test with my cats vs. fort infantry. 8968 cats killed 28760, and the spreadsheet predicted 29295 the way it is. If I cut attack in half it predicts 21822.

Not sure whats going on with that, I'll keep looking into it. Ill be making some more basic changes shortly like changing credits. If you figure something out let me know

Thanks for the credit, but I really didn't do anything lol. This sounds like a great program. I just wish I had excel to try it out.

If you are still having trouble with that 1% error, uranos may be able to help you out with that. He seems pretty good with that kinda stuff.