Advanced Probability Help

giants756

New Member
Joined
Dec 26, 2014
Messages
6
I need help creating a formula determining if the "ATTACKER" lands a Hit on the "DEFENDER". There are many factors that go into this and I can't seem to figure it out... I've uploaded an image of all the dice possibilities.

Example Scenario

ATTACKER'S DICEDEFENDER'S DICE
Yellow (D12)2Red (D12)1
Green (D8)4Purple (D8)2
Blue (D6)2Black (D6)1

Factor 1: There are multiple of each dice and each color dice has different result possibilities (Refer to image for percentages)
Factor 2: Some sides of the dice count as 1 Hit, some 2 Hits, and some 3 Hits. (And the same goes for the dice used for blocking)
Factor 3: I am comparing the number of Hits vs the number of Blocks rolled. Each Block cancels out a Hit.
Factor 4: A tie goes to the Defender because in the case all of the Hit's would be Blocked.

So the situation is (Yellow, Green, Blue used for attacker) VS (Red, Purple, Black used for defender).
I'm needing to know what th
Dice Representations.jpg
e percentage is that the ATTACKER lands at least 1 more Hit than the DEFENDER does Blocks (Basically I need to know what the chances are that the attack will hit the defender.

The attached image shows the number of sides on the dice that count for each Hit/Block. For example: the yellow dice has 1 side that counts as 3 Hits (8% chance of landing on that side).

If you need any more information let me know! I greatly appreciate any help I can get! I've been trying to figure out how to do this for a while and can't seem to wrap my head around all the possibilities.
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
EDIT (Sorry this got covered by the image): I'm needing to know the percentage that the ATTACKER lands at least 1 more Hit than the DEFENDER does Blocks (Basically I need to know what the chances are that the attack will hit the defender)
 
Upvote 0
@giants756
So are you throwing 8 Attack dice to get a total of Hits, and 4 Defence dice to get a total of Blocks?
You want the probability that Hits - Blocks > 1 ?
 
Upvote 0
@giants756
So are you throwing 8 Attack dice to get a total of Hits, and 4 Defence dice to get a total of Blocks?
You want the probability that Hits - Blocks > 1 ?
You are correct on the number of Attack and Defense dice. I want the probability the there is at least 1 more Total Hits than Blocks. That may be what you were saying but wanted to make sure. Chances that Hits > Blocks.
 
Upvote 0
@giants756 Please accept my apologies. I'm not a mathematician but fancied the challenge of taking a look at this. The upshot is that I have given it more of my limited lifespan than would appear sensible and still I cannot get my head around it. I am now both sleep deprived and deflated!:)

Sorry I haven't been able to help.
Good Luck!
 
Upvote 0
@giants756 Please accept my apologies. I'm not a mathematician but fancied the challenge of taking a look at this. The upshot is that I have given it more of my limited lifespan than would appear sensible and still I cannot get my head around it. I am now both sleep deprived and deflated!:)

Sorry I haven't been able to help.
Good Luck!
It’s ok! I really appreciate you trying to help! I’ve struggled with it for a while myself. Thanks again for giving it a shot!
 
Upvote 0
I haven't quite figured out the scenario myself. It appears the attacker throws 1 12-sided die, 1 8-sided die, and 1 6-sided die (3 dice), and the defender rolls the same. Are you looking for the total score against the total score? Or do you have to handle the dice pairwise (attacker v. defender)? And I don't quite grasp the single-hit, double-hit, triple hit twist.

In any case, just assuming total score v. total score, you can figure out the probability by the basic definition of # of successes/# of cases. I wrote a quick program that goes through every possible roll and figured out the odds, and it turns out that the attacker has about a 47% chance of hitting. This seems reasonable, since the ties go to the defender.
 
Upvote 0
I haven't quite figured out the scenario myself. It appears the attacker throws 1 12-sided die, 1 8-sided die, and 1 6-sided die (3 dice), and the defender rolls the same. Are you looking for the total score against the total score? Or do you have to handle the dice pairwise (attacker v. defender)? And I don't quite grasp the single-hit, double-hit, triple hit twist.

In any case, just assuming total score v. total score, you can figure out the probability by the basic definition of # of successes/# of cases. I wrote a quick program that goes through every possible roll and figured out the odds, and it turns out that the attacker has about a 47% chance of hitting. This seems reasonable, since the ties go to the defender.
Yes I agree that 47% is pretty accurate assumption because the purple dice has more blocking opportunities than the green does hits. To answer your question, yes I’m looking for total vs total.

I think I found something that gives me an accurate representation without being a percentage. It’s basically an Hit to Block ratio and it seems to be a good representation of what I’m wanting.
 

Attachments

  • 07880F56-E50D-49D7-BA1D-BA818B2611B6.jpeg
    07880F56-E50D-49D7-BA1D-BA818B2611B6.jpeg
    61.9 KB · Views: 9
Upvote 0
@Eric W
My understanding is that Attack has 2 x 12-sided, 4 x 8-sided and, 2 x 6-sided dice. Each dice has a 'Hit"-scoring and non-scoring sides as per @giants756 's image in post# 1
So some faces score nothing, others, 3, 2 or, 1.
Similarly, Defence has 1 x 12-sided, 2 x 8-sided and, 1 x 6-sided dice and rolls 'Blocks' that counteract attacking hits.

By my reckoning, there are 21,233,664 possible combinations from the 8 Attack dice and, 4,608 from the 4 defence dice.
The maximum possible Defensive score is 8.
The maximum possible attacking score is 16. So any attacking score of 9+ cannot be defended and guarantees at least 1 hit.
There are 65,536 ways for Attack to throw 0 ie a 0.306% probabiity.
After that.... it starts to get smelly! :)
 
Upvote 0
I see that I was a little slow in responding^^^
I was just about to see if I can get a decent probability of throwing scores 0 - 8, based on the chart below which shows the required 1,2,3's needed (any balance being 0's)
Note that combinations needing more than one 3 cannot be thrown.

Book1
NOPQRSTUVW
1Score
200
311
42112
53111123
6411111122213
7511111111211312223
86111111111121113112212333
971111111111112111131112211231222133
10811111111111111211111311112211123112222222233
119111111111111111211111131111122111123111222122221233333
Sheet2


@giants756 What is the motive behind you wanting this? How accurate do you need it? Is it worth me missing the football on TV to pursue it?
 
Upvote 0

Forum statistics

Threads
1,214,834
Messages
6,121,873
Members
449,056
Latest member
ruhulaminappu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top