Jan 24th 2013, 21:19:01
A few notes on using the spreadsheet linked above (I made it):
1) Convert Government, Readiness, Def. Bonus, and Weapons Tech percents into a decimal numbers when entering into the excel.
2) If he has alliance expenses, make sure you spy alliances and get their information too, or send double his defensive strength.
3) The middle results row "P.S. Pwr." stands for Planned Strike Power, and should mostly be what you use to land grab. If you look to the far right box on the "P.S. Pwr." row you will see the % of Defense the attacker sends compared to the defender. Send enough forces to make this 110% and you should have 99% success rate.
4) To error on the safe side, in case my calculations were not 100% or to account for an extra luck bonus (ontop of the 110% sent), I added another multiplier called "Chance" to the calculation which can be changed in the bottom left green box. I have mine set to 110% multiplier, which means if the rest of my calculations were correct without the Chance multiplier, then I would be sending an extra 10% (or 120% total of their defense).
There are five copies of the same calculator so you can plan out five attacks at the same time. At some point I was going to test its accuracy in the express server, but I just haven't gotten the time recently. But so far it has worked 100% for me, the only attacks I failed were my own fault for forgetting to put something into the calculator.
