|Submitted By: Dev Null Date: September 9, 2013, 07:23:48 PM Views: 5216|
|Summary: How to calculate the odds of killing a vehicle in a single round of shooting.|
How I calculate the effectiveness of anti-vehicle countermeasures.
I tend to throw odds around, and I've had a couple of people ask me how I come up with them. I make computers do the work. I built a spreadsheet using the techniques that GreatBigTree describes over here, and added a couple of twists of my own. Figured I'd make it available for others if they're interested. I've saved it in a fairly generic Excel format, but you ought to be able to open it with LibreOffice or one of the other free downloads. If you're at all interested in how it works, I encourage you to read through the next bit and check my maths; if you just want to plug in some numbers and look at the answers, skip down to the section titled "The Spreadsheet".
In this game, the usual way to calculate how well a thing works against another thing is to calculate the average number of wounds that it will inflict. For infantry, that's fair enough, but for vehicles it belies the number I most often care about more: what are the odds that I'll kill it.
There are a couple of basic principles I use to work out these odds:
1) Its often easier to work out the chance of _not_ doing something than it is to work out the odds of doing something. Then the odds of your thing happening is just 1.0 minus the odds of it not happening. This is especially true when you're trying to answer questions like "the odds of 3 or more hull points"; when you take a lot of shots, the "or more" covers a lot of ground, but you don't need to work those out. You just work out the odds of zero, one, or two, and subtract from 1.0. I blatantly stole this technique from a post by GreatBigTree ([6th Ed] How to Generate Statistics - Part 1: Number of Casualties Spread), so for more detail, go check that one out.
2) A simple formula for re-rolls, which is based on the above. With re-rolls you have to take into account that you only re-roll if you don't succeed, which is a trifle fiddly. Far simpler to work out the odds of failing twice, and subtracting from 1.0. So if I have a 1 in 6 chance of succeeding with each roll, and I get a re-roll, then I have a 5/6 chance of failing each roll, and a (5/6)^2 = 25/36 chance of failing twice in a row. Which means I have an 11/36 chance of succeeding on one or more of my rolls (which is all I need to succeed overall if I have a re-roll.) So if S is my odds of success with each roll, (1.0 - S) is my odds of failing with each roll, (1.0 - S)^2 is my odds of failing on both rolls, and 1.0 - (1.0 - S)^2 is my odds of success with a re-roll.
But what if I'm not sure if I'll get a re-roll? If R is the probability I'll get a re-roll, then 1.0 - R is the probability that I won't (one of the two has to happen) and my odds of success overall are:
R * (odds of success with re-roll) + (1.0 - R) * (odds of success without)
Mix in the above odds and get:
You can drop that formula in anywhere you have a probability of success (S) and a probability of a reroll (R). I use it in my spreadsheet even where the probability of a reroll is fixed (no re-roll just means R=0; twin-linked is R=1) just because it makes it easy to flip the value and - for instance - see how much good it would do to cast Prescience on a unit.
3) Combining odds. We can add up probabilities so long as they're mutually exclusive. We're working out the odds of a single weapon type killing a vehicle by working out the odds of the vehicle surviving; the odds that we get 0, 1, or 2 hull points without it exploding. Since we've worked out those three values separately for each weapon, we can work out the odds of the vehicle surviving fire from two weapons combined:
Odds of exactly 0 HP with A+B =
(Odds of exactly 0 with A) * (Odds of exactly 0 with B)
Odds of exactly 1 HP with A+B =
(Odds of exactly 1 with A) * (Odds of exactly 0 with B)
(Odds of exactly 0 with A) * (Odds of exactly 1 with B)
Odds of exactly 2 HP with A+B =
(Odds of exactly 2 with A) * (Odds of exactly 0 with B)
(Odds of exactly 1 with A) * (Odds of exactly 1 with B)
(Odds of exactly 0 with A) * (Odds of exactly 2 with B)
All of the terms are mutually exclusive, so the addition is safe. And because we've worked out all of the same values for the combo, it is possible to combine a third weapon to the mix of the first two in exactly the same way.
Dropbox - vehicle_kill7.xlsx
Put your own values into the columns with names in bold. You can override the other columns too, but you'll erase my formulas, so its better, for instance, to set your BS to 1 than to manually set % Hit to 1/6 for a Snap Shot.
and finally - the point of the whole exercise:
There is a combo row in the sheet. Combine all of the shots for all weapons with the same profile into one normal row of the sheet. Do the second weapon profile on the second row of the sheet, without leaving any space between them. Then copy the combo line onto the third row. If there is a third weapon profile, put it on the line immediately following the combo row, and then follow it with another combo row.
Lets pick a made-up example, so the Warp Lawyer Elite Hit Squad does not descend. I have a vehicle which I shall call a Space-Elf AT-AT; it comes in squadrons of up to 3. It has various weapon choices that can be chosen for each of two different weapon mounts. One weapon I shall call a Splatter Gun; it is S5, Assault 5, AP5, and has a special rule that it will cause other weapons on the vehicle to be twin-linked if it hits. One weapon I shall call Tight Pants (those Space-Elfs wear some wicked Tight Pants.) The sight of these trousers of power causes such searing pain in the viewer that they are S7, Assault 1, AP1. Lets sick a 3 AT-AT squad - each mounting one of each weapon - on a flying angelic waterfowl that, with an AV of 11 and a 5+ invul save, is so hellishly difficult to kill that it is called a HelllDuck. (3 L's, cuz its so ludicrous.) We'll throw in a third profile to demonstrate how that works; Space Elf Warp Ladybugs are a terror to behold at S6 Assault 2 AP-.
Lawyers please note that these do not in any way have the same stats as any actual GW product that I am aware of.
Copy the spreadsheet line and put in the stats for the three gun types. Shooting at a zooming flyer, so BS is 1. Number of shots is for the whole unit (so 3x the weapon). The re-roll hit % of the Tight Pants is 1.0 minus the odds of missing with all 5 shots of a Splatter Gun in a row. Copy the combo line to immediately below the first two, then copy it again after every weapon profile from the third on. Overall, my valiant AT-ATs and friends have slightly more than a 10% chance of taking out the dreaded HelllDuck. They should probably pick another target.
Rating: by 1 members.
|Dev Null||June 13, 2014, 11:38:44 AM|
Updated the sheet to work for 7th edition, and added in a column to identify the target as open-topped while I was there.
|Dev Null||January 21, 2014, 03:37:34 PM|
Added columns for "1+ HP or Destroyed" and "2+ HP or Destroyed"; not everything has 3 HP, and sometimes its wounded. Thanks for feedback to volatilegaz.
Also added a third weapon profile to my example, to make it more obvious how that works.
|Dev Null||October 25, 2013, 07:58:02 PM|
Re-worked the spreadsheet and updated the article to match. Swapped to a method closer to GBT's original method, because it solved some problems with combined arms.