TEMPLATE
FMEA:
Excel template
Download the template
Use this template to rate potential failures for each process step by severity, occurrence and detection and track every action until it is re-rated.
Excel calculates the risk priority number from S, O and D. You determine the action priority from the table in the AIAG-VDA handbook and select it from the list.
What is in the template:
Process FMEA with header for plant, process, team, date and revision
Columns from process step and failure mode to detection controls, based on the AIAG-VDA FMEA handbook
RPN from S, O and D by formula, inputs from 1 to 10 validated, high values highlighted
Rating sheet with short descriptions of levels 1 to 10 for S, O and D
Actions with owner, due date, status and new rating
Filled-in example from a fictional assembly plant, Excel file without macros
Who it is for
Who the FMEA template is for
The template is for quality and process engineers who want to assess the risks of a manufacturing process before they turn into defects at the customer. Use it for new processes, after changes or to revise an existing process FMEA.
How to work with the FMEA template
- 1
Structure the process
Enter the process steps and describe failure mode, effect and cause for each step.
- 2
Rate
Score severity, occurrence and detection from 1 to 10. Excel calculates the RPN and highlights high values.
- 3
Track actions
Define actions with owner and due date and re-rate after implementation.
What you should know about FMEA
RPN and action priority rate differently
The RPN multiplies S, O and D and weights all three equally. The action priority from the AIAG-VDA handbook puts severity first, which is why the template includes both.
Detection does not replace prevention
A better inspection lowers the detection rating, but the cause remains. Actions that lower occurrence act earlier and more reliably.
An FMEA is never finished
After a complaint, a process change or a new finding, the FMEA goes back on the table. The columns for the new rating show whether an action has reduced the risk.
Download the FMEA template
Fill in the short form and you receive the download right after.