Advanced Attacking: a work in progress

There's two reasons I do well attacking. The first is a good understanding of Illy mechanics and the second is my excel calculator. I will try to share both with you. 

Here are the links to the files you will need. 

For the guide you will need a reasonably new version of MS word (one that reads xdoc) or you can't see the formulae.

For the excel calculator you will need actual MS excel, not a mac emulator or something. I provide it xlsm format and in xlsx format. I added the xlsm one because it has a fancy button to minimize troops used (a macro).

The terrain modifiers I use are in both the guide and the calculator. The modifiers are good for plains, small hills and both kinds of forests. More rare terrain like buildings, large hills and mountains I am making progress on, but are currently not accurate. The green colored modifiers I am pretty sure of (100% in the case of plains).

For a small taste of what you can do if you use the calculator correctly:

No, this is not a bug. This was first calculated using the calculator and then confirmed with the actual hit. For those who want to try it in the calculator, one of the knight commanders had 12% charge, rest was maxed on both heroism and charge, the troops had 15% bonus of course. Make sure you account for the T4 and T3 rats being switched for some reason. 

Obviously the calculator, attack guide and terrain modifiers are a work in progress. I will update this thread accordingly.

Enjoy!