All CW unit evaluation spreadsheet
 

Dear folks,

This spreadsheet allows one to figure out which one is worthwhile units. I've made heavy modification to an original spreadsheet for AP. Credit to the guy who make that, can't find his name now.

In this .xls, it tells you how much Damage your stack can deal physical to your enemy units. This assume the enemy is using the games' "Average Unit". Also it shows how durable a unit is, by telling the number of average units are needed to kill your stack

If you want, you can see how the Att/Def difference between your hero and enemy hero's Def/Att can make.

If you want, you can see how morale/how much rage you have affects your battles.

There are some imperfection as I've not proof read all units, some Physical resistance/crit chance is missing. Let me know other shortcomings here in the .xls & let me fix it later.

I can't believe no one replied to this. Thank you! Very handy stuff.

Thanks ClimberL,

It's a bit difficult for me to understand the specifics of the spreadsheet, but I get the general idea. For instance, Bold being better than average agrees with what I've read in the forum and what I've experienced. I don't understand Green for user input, but the formulas are intriguing.

This was a lot of work for Physical Damage. My mind boggles at including Poison, Fire, and Magic. That's when I remember to save often and just enjoy the pretty pictures.

Your time and work are appreciated.

Thanks for this!

Great work!