You can easily add columns for "Cost of Failure" or "Safety Standards Compliance" (like ISO 26262 or AS9100).
| Column | Field | "Hot" Logic | | :--- | :--- | :--- | | A | Item / Function | Static text | | B | Failure Mode | Static text | | C | Failure Effects | Static text | | D | Severity (S) | Dropdown (1-10 via Data Validation) | | E | Causes | Static text | | F | Occurrence (O) | Dropdown (1-10) | | G | Current Controls | Static text | | H | Detection (D) | Dropdown (1-10) | | | RPN (Risk Priority) | Formula: =[@[Severity (S)]]*[@[Occurrence (O)]]*[@[Detection (D)]] | | J | Criticality Level | Formula: =IF([@RPN]>200,"CRITICAL",IF([@RPN]>100,"HIGH","MED/LOW")) | | K | Recommended Action | Static text | | L | Responsible | Static text | | M | Action Status | Dropdown (Open/Closed/Deferred) | | N | New Severity | Dropdown | | O | New Occurrence | Dropdown | | P | New Detection | Dropdown | | Q | New RPN | Formula: =[@[New Severity]]*[@[New Occurrence]]*[@[New Detection]] | | R | Risk Reduction % | Formula: =([@RPN]-[@[New RPN]])/[@RPN] | fmeca template excel hot
After actions, recompute – a dramatic risk reduction. You can easily add columns for "Cost of