Risk of Combinations/Paths in Excel?

AgieX

New Member
Joined
Jun 28, 2021
Messages
4
Office Version
  1. 2016
In short I want to use multiple drop downs to display the risk percentage of selected data. I am new to Excel so I am not even sure if this is possible... please advise.

About the data: We rolled marbles in different obstacle courses going horizontal and vertical. We documented if the marble fell through a hole in the boxes - which would be "bad". Attached is a sample of data from the experiment. Our real lists can range from 1,000 to 10,000 rows.
All the bold columns are lists I want in the drop downs.
The first 3 digits of the ID indicate what obstacle course the marble was in 201, 202, or 203 which is why I calculated that in the 2nd column.
The 5th column tells if the marble ended in the same box.

IDID startStart BoxEnd BoxStart-End same?VerticalHorizontalFall?Good/Bad
201234201abcabcTRUEUpRightYBad
202345202cdecdeTRUEDownLeftYBad
203456203defcdeTRUEUpRightYBad
202567202ghidefFALSEDownRightNGood
201678201efgefgTRUEUpLeftNGood
203789203fghfghTRUEDownRightNGood
203900203ghighiTRUEUpRightYBad
201011201hijghiFALSEDownRightNGood
202122202ijkhijFALSEUpLeftNGood
201233201jklijkFALSEDownRightNGood
202344202klmklmTRUEUpRightYBad
203426203lmnlmnTRUEUpRightYBad
201568201mnolmnFALSEDownRightYBad
203665203nopmnoFALSEUpRightNGood

What I'm looking for:
-Part 1: A chart where people can select different drop downs and have the chart display the risk percentage of the selected data.
For example
ID start 203
Start-End Same? Yes
Vertical Up
Horizontal Right
would display 100% because 100% of the time it ended Bad.
If the user left Start-End Same? blank I'd like for the chart to not filter anything for that field. The chart should display 75%.
1624957622194.png

-Part 2: I want to use drop downs to display the Risk - so riskiest recorded path, and the least risky path. That first drop down would auto-populate data for the following 4 fields and force a calculation in the chart.
For example: I want whoever uses this chart to know the combination listed in Part 1 (above) is the riskiest path... if they rolled the marble UP and RIGHT in the same box of obstacle 203, it would be 100% bad.
 

Attachments

  • 1624957332060.png
    1624957332060.png
    44.2 KB · Views: 9

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,223,227
Messages
6,170,849
Members
452,361
Latest member
d3ad3y3

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