FMEA Analysis has an auto-function to help the users quickly complete the risk evaluation through the Risk Evaluation pane. To access the Risk Evaluation pane from Excel’s ribbon, select Risk Evaluation from Task Pane group.
This is how it looks
1. Specify the risk index column
The section Index Columns of the task pane allow the users to set up the index columns in the worksheet. You can specify the risk index columns before the recommended actions (first rating) and/or after the recommended actions are taken (re-rating).
- Severity: Specify the column used for severity ranking.
- Occurrence: Specify the column used for occurrence ranking.
- Detection: Specify the column used for detection ranking.
- Risk Indicator: Specify the column used as the risk indicator column. Risk indicator can be Risk Priority Number, Critical Number, SOD,…
- Re-Severity: Specify the column used for severity ranking after the recommended actions are taken.
- Re-Occurrence: Specify the column used for occurrence ranking after the recommended actions are taken.
- Re-Detection: Specify the column used for detection ranking after the recommended actions are taken.
- Risk Indicator: Specify the column used as the risk indicator column after the recommended actions are taken.
In the built-in template, the index columns were specified and you don’t need to do it again.
2. Risk Indicator
Next, you need to specify the risk indicator number you use from the below list:
- RPN stands for Risk Priority Number. RPN formula: Severity x Detection x Occurrence.
- SOD stands for Severity – Occurrence – Detection. SOD formula: 100 x Severity.
- CN stands for Critical Number. CN formula: Severity x Occurrence.
- None means not using a number indicator, but you can use other kinds of indicators. For example, a color indicator.
Note: If you select None, you can not evaluate with Top Risks or Threshold method because those methods are quantitative methods. However, Risk Matrix method will work
3. Auto Evaluation Method
Next, you must specify how you want to evaluate the risk from the below list:
For example, due to the limitation of your resources, you only want to focus on the 5 highest risks in your FMEA and consider the next 5 risks that have lower risk levels.
Here is how to evaluate with Top Risks
- Check the Top Risks under Auto Evaluation Method section.
- On Quantity of item to be improved, input the number of items you want to improve.
- On Quantity of item to be considered, input the number of items you want to consider.
This option prioritizes the risks that need to be addressed by defined limitations. Here is how to do it:
- Select Threshold in Auto Evaluation Method
- from Acceptable if lower than, specify the limit that risk will be acceptable by your team or organization.
- from Need improvement if larger than or equal to, specify the limit that risks will need to be addressed by recommended action.
This option prioritizes the risk by a defined matrix of Severity and Occurrence.
- Select the Risk Matrix option in Auto Evaluation Method.
- In the Risk Matrix, select a cell representing the combination of Severity (horizontal axis) an Occurrence (vertical axis) you want to change.
- Select the risk level in three 3 categories: High Risk (Red), Medium Risk (Yellow) and Low Risk (Green).
- High Risk: Must be reduced or eliminated.
- Medium Risk: To be considered.
- Low risk: Acceptable risk. No action required.
OK, now you can hit the button. You have can use one or both of evaluation buttons:
- Evaluate before improvement: Evaluate before recommended actions are taken.
- Evaluate after improvement: Evaluate after recommended actions are taken.