Fmeca Template Excel
Select the Severity column. Go to Data > Data Validation > List . Enter 1,2,3,4,5,6,7,8,9,10 . Repeat for Occurrence and Detection. This prevents manual typos.
| Column A | Column B | Column C | Column D | Column E | Column F | Column G | | --- | --- | --- | --- | --- | --- | --- | | Failure Mode | Effects on System | Criticality | Likelihood of Occurrence | Detectability | Risk Priority Number (RPN) | Recommended Actions | fmeca template excel
To be effective, your Excel spreadsheet should include the following core columns and functional sections: Process/System Step Select the Severity column
| Failure Mode | Effects on System | Criticality | Likelihood of Occurrence | Detectability | RPN | Recommended Actions | | --- | --- | --- | --- | --- | --- | --- | | Bearing failure | System downtime | 8 | 6 | 4 | 192 | Schedule regular maintenance | | Software bug | Data loss | 9 | 3 | 6 | 162 | Implement software updates | Repeat for Occurrence and Detection