Downloading an FMEA Template

FMEA Template for Excel, Download & Quick Tips

Contents

Looking for a free FMEA template that can help you conduct a failure mode and effects analysis easier and faster right inside Excel. You’re in the right place.
DFMEA Example for Ballpoint Pen

The download links are down below. However, in order to save hours of work with the FMEA templates, you should take a few minutes to go through the template guide and quick tips section below.

Each FMEA template has 2 parts: Header (light green) and columns (light blue).

FMEA Template Overview
  • Header: The upper part of the template is the header which includes general information on FMEA analysis and document and track information. These pieces of information are normally necessary for quality management systems.
  • Columns: The body of the template includes many columns. The information is listed in the columns with a hierarchy structure. You should determine the analysis hierarchy structure and apply it consistently in all FMEA form.

Each template has one or more different header items or columns depending on what is being analyzed (product, process, service, …) and the organization’s need. Let’s dive deeper into each FMEA Template.

DFMEA Template

1. Header

The DFMEA Template header includes:

DFMEA Template Header
  1. Product / Part: the object is being analyzed. This could be a system, sub-system, or component.
  2. Project (or Model): Enter the project code or model year used to distinguish the product and process being analyzed with similar
  3. Team: List of team members who are involved in the FMEA project.
  4. Responsible: Person who is responsible for preparing the FMEA document.
  5. Manager: Person who has responsible for release the FMEA document.
  6. FMEA Number: The document control number of the FMEA document. Each organization should have a consistent document numbering system used for tracking the document.
  7. Original Date: The date that the original FMEA was compiled.
  8. Revision Date: The latest revision date of FMEA.

The information in the header can be customized to what you need to organize and control your document better.

2. Body columns

The body includes the following columns:

DFMEA Template Columns
  1. Items: Item (component, part, assembly) of the product/part to be analyzed. An Item has one or many functions.
  2. Function: Functions of an item. A function has one or many requirements
  3. Requirement: Requirements of a function. A requirement has one or many potential failure modes.
  4. Failure Mode: The way that an item potentially fails to meet the requirement. A failure mode has one or many potential effects.
  5. Effects: Potential effects of the potential failure mode on the function and customers.
  6. Severity (S): a ranking number reflects the most severe potential effect of a failure mode. Severity ranks on a 1 to 10 scale, 10 is the most severe risk.
  7. Class: Special product characteristic or high-risk failure mode.
  8. Cause: The reason why failure happens. A failure mode has one or many potential causes.
  9. Prevention Control (in Control Method): Design action to prevent potential cause to occur.
  10. Occurrence (C): a ranking number reflects the possibility of occurrence of the Failure. Occurrence ranks on a 1 to 10 scale, 10 means the highest possibility of occurrence.
  11. Detection Control (in Control Method) Design action to detect the failure or the cause of the failure if it happens.
  12. Detection (D): a ranking number reflects the best detection control method. Detection ranks on a 1 to 10 scale, 10 means worst detection capability.
  13. RPN: (stands for Risk Priority Number) An indication number to evaluate the risk of the process based on Severity, Occurrence, and Detection. Depend on RPN and S, O, D indexes, the responsible team/individual has to decide corrective action needed for each failure mode.
  14. Action: Recommended action to eliminate or reduce the chance of the causes of failure mode.
  15. Responsibility: Individual person or team/department who has to complete the recommended action.
  16. Target Finish Date: The plan completion date.
  17. Actual Finish Date: The actual completion date.
  18. Severity: re-evaluate severity of failure mode after corrective action
  19. Occurrence: re-evaluate occurrence possibility after corrective action
  20. Detection: re-evaluate detection capability after corrective action
  21. RPN: re-calculate Risk Priority Number after corrective action

PFMEA Template

1. Header

The PFMEA Template header includes:

PFMEA Template Header
  1. Product/Part: name or identification number of product/part that is the output of the process being analyzed.
  2. Project (or Model): Enter the project code or model year used to distinguish the product and process being analyzed with another similar process.
  3. Team: List of team members who are involved in the FMEA project.
  4. Engineer: the responsible person for preparing the FMEA document.
  5. Manager: the responsible person for releasing the FMEA document.
  6. FMEA Number: The document control number of the FMEA document. Each organization should have a consistent document numbering system used for tracking the document.
  7. Original Date: The date that the original FMEA was compiled.
  8. Revision Date: The latest revision date of FMEA.

As DFMEA Template, you can remove or add more fields in the header depending on what you need.

2. Body Columns

The example of PFMEA Template body includes columns:

PFMEA Template Columns
  1. Process: Process step number and (or) process step name. The number and name should match with those in the process flow diagram.
  2. Function: Functions of a process. A function has one or many requirements
  3. Requirement: Requirements of a function. A requirement has one or many potential failure modes.
  4. Failure Mode: The way that the process potentially fails to meet the requirement. A failure mode has one or many potential effects.
  5. Effects: Potential effects of the potential failure mode on the function and customers.
  6. Severity (S): a ranking number reflects the most severe potential effect of a failure mode. Severity ranks on a 1 to 10 scale, 10 is the most severe risk.
  7. Class: Special product characteristic or high-risk failure mode.
  8. Cause: The reason why failure happens. A failure mode has one or many potential causes.
  9. Prevention Control (in Control Method): Action to prevent potential cause to occur.
  10. Occurrence (C): a ranking number reflects the possibility of occurrence of the Failure. Occurrence ranks on a 1 to 10 scale, 10 means the highest possibility of occurrence.
  11. Detection Control (in Control Method): Action to detect the failure or the cause of the failure if it happens.
  12. Detection (D): a ranking number reflects the best detection control method. Detection ranks on a 1 to 10 scale, 10 means worst detection capability.
  13. RPN: (stands for Risk Priority Number) An indication number to evaluate the risk of the process based on Severity, Occurrence, and Detection. Depend on RPN and S, O, D indexes, the responsible team/individual has to decide corrective action needed for each failure mode.
  14. Action: Recommended action to eliminate or reduce the chance of the causes of failure mode.
  15. Responsibility: Individual person or team/department who has to complete the recommended action.
  16. Target Finish Date: The plan completion date.
  17. Actual Finish Date: The actual completion date.
  18. Severity: re-evaluate severity of failure mode after corrective action
  19. Occurrence: re-evaluate occurrence possibility after corrective action
  20. Detection: re-evaluate detection capability after corrective action
  21. RPN: re-calculate Risk Priority Number after corrective action

Quick tips

FMEA normally look like below with a hierarchical structure. How do you handle this format quickly in Excel?

Hierarchical Structure of PFMEA

One solution is using Excel’s merging tool or cell formatting to make the item structure look like this. However, this is not a good solution if you have to do it again and again.

A quicker solution is using the FMEA templates with FMEA Analysis Free, you can insert a new item by pressing Enter.

1. Quick insert new item

Follow these steps to quickly insert a new item:

Auto Insert item for FMEA inside Excel
  1. Check the Enter To Insert option in the
  2. Select the item that you want to insert a new one below it and press Enter.

2. Delete an item

Follow these steps to quickly delete an item:

Auto delete FMEA item
  1. Select the item need to be deleted
  2. Rightclick and select Delete Item in the right-click menu

These quick tips only apply for the FMEA templates created by FMEA Analysis Add-In for Excel.

Share This Post

Share on facebook
Share on linkedin
Share on twitter
Share on email

More To Explore

DFMEA vs PFMEA
News

DFMEA vs PFMEA

DFMEA stands for Design Failure Mode and Effects Analysis and PFMEA stands for Process Failure Mode and Effects Analysis. They are both FMEA, use the

FMEA Automation Tool for Excel
Use FMEA Analysis tool to save hours of work

Download FMEA Analysis

And get the lastest news and supporting articles

An email with download link and installation instruction will be send to your email address in a minute.