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.
 
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?
I appreciate all the help! I think I have what I’m looking for with this Hit to Block Ratio. I think it’s just too much to try and comprehend finding the percent chance of hitting. Definitely seems like there are a lot of possibilities to consider for a percent and I think the Ratio gives me a better perspective.
 
Upvote 0

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,637
Latest member
Ezio2866

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