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

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Watch MrExcel Video

Forum statistics

Threads
1,130,342
Messages
5,641,592
Members
417,224
Latest member
llama9207

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
Top