Sarah hit the 'Calculate' button. The template utilized a Visual Basic macro to compute the Risk Priority Numbers instantly. It didn't stop there. A separate tab in the workbook—a 'Dashboard'—auto-populated a Pareto chart, highlighting the top three failure modes in red.
: Capture the project name, item/system being analyzed, date, and the core team responsible. Process/Product Step : Identify the specific function or component under review. Failure Analysis Potential Failure Mode : What could go wrong? Potential Effects : What is the impact on the customer or system? Potential Causes : Why would the failure happen? Risk Assessment (The "Criticality" Part) Severity (S) : Rank the seriousness of the effect (1-10). Occurrence (O) : Rank the likelihood of the cause happening (1-10). Detection (D) fmeca template excel hot