What I’m attempting to do is construct a spreadsheet to calculate the number of wounds and kills for a tabletop board game I play. To give everyone an idea of the situation. You have figure A shoots at figure B. In this situation you have the “percentage for figure A to Hit figure B” the percentage for figure A to Wound figure B ” the “percentage for figure B to Fail an Armor Save ”. This is all bases on a D6 die and sometimes multiple D6 rolls.
I have in my spreadsheet already been able to calculate the percentage of “The Percentage to HIT”, “Percentage To wound” and the “Percentage to Fail an Armor Save”.
Now my issue is where (in the game) the weapon used to wound on a roll of 6 on a six sided roll there is no save possible.
Example: Figure A shoots at figure B and “The Percentage to HIT” is 89%. The Percentage of figure A to wound figure B is 33%. The percentage of Figure B to “fail the Armor Save” is 17%. Now add in the case were on a roll of a 6 on six sided die there is no save possible.
In the end I’m attempting to figure how many wounds Figure B is going to suffer.
A couple of questions
Do I calculate the 1/6 chance off the percentage of figure A to wound figure B? So off the 33%. So in this example the “To wound percentage” is figured as 5+ so a 2/6 thus .3333 = 33%. In that case is it 1/2 = .5000 thus 50%.
Once I calculate the percentage of the 1/6, where in my calculations should I add that. =SUM(To_hit_% x To_Wound_% x Fail_save_%)
Do I add it to the Fail_save_percentage or the To_wound_percentage.
As you can see it is a bit of a complex question. But at the root it seems pretty simple.
Rending?
You would add it to the failed save, since the save does (auto-)fail, so the probability of a failed save per wound dice roll is 1/6 (.16) + (% to wound * % chance to fail save).
For the total wounds applied it's going to be (%chance_to_hit * (1/6+(%chance to wound * % chance to fail save)) * # of dice.