Risk Matrix action efficiency.. is this possible?

Orebody

New Member
Joined
Jan 17, 2011
Messages
12
I have made a spreadsheet to calculate the effectiveness of actions put in place to control a hazard.
If Elimination is used then the action is 100% effective.
If Engineering is used then it scores only 50% and so on as Elimination is the most ideal control.
What I would also like it to do is calculate the efficiency of the control actions. For example, if a risk has a score of High 15 and is controlled using Engineering then that would be a less efficient solution than if Elimination were used. I have tried a few different ways to get this to work and put a score to it (eg. 100% or 10 for most efficient & 0% or 1 for least) but have had no success. If anyone can think of a way to make this work that would be greatly appreciated!
I hope this makes sense.

Here is the file so far:
https://spreadsheets.google.com/ccc...UHloZ3JLUi14NElJc0E&hl=en_GB&authkey=CJjWo_sE
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Forum statistics

Threads
1,217,317
Messages
6,135,833
Members
449,965
Latest member
Ckl43

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