Sunday, September 16, 2012

Combine Melee/Combined Ranged Attacks - a spreadsheet

Link to the Spreadsheet

When I started playing with units that had the combined melee/combine range attack ability, I was generally confused about how to configure my attacks to be the most effective.  If I want to take down a heavy, should I lump everyone into a single attack?  It turns out, no, not always.  It may even be different if you're benefiting from an extra dice for charging.  If I want to use my Long Gunners to kill as many Iron Fang Pikemen in a turn, how many should I group up?  What about against Fennblades?  Actually, the answer is different for each.

Against a single target, it's a little more straight-forward than against multiple targets.  We're just concerned about piling as much damage into one guy that typically has high armor.

For multiple targets, assuming your goal is take as many targets off of the table as you can, you also have to factor in the target's health.

The spreadsheet allows you to enter stats for the attacker and defender along with the configuration of the CRA/CMA.  I sometimes refer to that as CXA.  The results tell you how much damage to expect against a single target or how many models you're likely to kill in a single activation.  Any number of attackers can be represented, up to 10.  I'll probably need to increase that to allow for some of the unit attachments.  We also don't take into account the slightly better stats of some of the officer attachments.

To use the spreadsheet:

After clicking on the link, select 'File->Make a Copy' to copy the file to your own Google Drive.  Once there, you can make all the changes you like.

Link to the Spreadsheet


  1. Thanks for the neat spreadsheet! Just one issue: ParseCXA doesn't get copied over along with the spreadsheet for me. Any chance you could post the code as a block to CnP in?


  2. You're the second person that's reported this issue, so it's not isolated. At the same time, most people haven't been experiencing it. I've tried to track down the cause, but haven't had much luck. I think that I'm going to make an excel spreadsheet version and share that in hopes of expanding everyone's access. Thanks for the comment.

  3. This is great. One bug I found: when I use 4 dice in column H, column AA goes berzerk.

  4. I should have made a note that four dice weren't supported. I had to hard-code the probabilities, and hadn't included four dice yet. I've added it, and now 4 is the max. I still need to add five dice and up. Thanks for pointing that out.