I had been thinking about posting this topic for a while now, but didn’t know if anybody else might be interested. After listening to an episode of the Bad Dice Daily Podcast where this was covered, I thought that I might as well try it out.
Since I don’t get a chance to play many games, I thought that it might be a good idea to see how my units match up against other units in a fight. To facilitate this, I have created a spreadsheet with lots of formulas to quickly calculate how the units match up, with the amount of casualties caused and received.
I thought that it might be interesting to other people to see these calculations, and since it takes only minimal effort from me now (the common formula work has been done), I thought that I could just make it a weekly series, with the High Elf infantry units facing off against a new unit each Monday. I included in my spreadsheet the ability to account for Augment/Hex magic, but probably won’t include that here, due to the sheer quantity of variables involved and me not knowing how to display it in a good manner. A sample image with an augment follows:
Since this is the first installment, here is a list of assumptions made:
- Calculations are based on averages (e.g. If you roll 8 attacks needing a 4+ to hit, 4 will hit)
- Numbers are rounded to a whole number after each calculation (5.5 hits would result in 6)
- Full ranks of warriors are present to attack (i.e. enemy return attacks are not reduced by the amount of models killed)
- Only one round of combat is analyzed
With that being said, here is the comparison for this week.
As one can see from the calculations, any of the High Elf units going into a straight up fight with this particular Chaos Warrior setup is not the best of ideas. While the Sword Masters and White Lions break even, on average, the lower strength Phoenix Guard and Spearmen can’t punch through the armour. Either superior numbers, superior dice rolling, or some magic needs to come into this fight to help shift the fight in the elves favor.
Let me know what you think of this. In particular, these points:
- Is this interesting/useful?
- Do you see any issue with the calculations/assumptions made?
- Would it be better to use the same points value of models and account for model losses and/or break tests?
- Does the format make sense?
- Are there any match-ups that you would like to see stand off against the High Elves?