Home » Lean Six Sigma Templates » FMEA Template Excel

Need a FMEA Template in Excel?

QI Macros has a Ready-Made FMEA Template

---

* 5th Edition FMEA (AIAG & VDA FMEA 1st Edition) introduced in QI Macros' October 2019 release *

Use an FMEA Template to Analyze & Prevent Failures

Failure Mode and Effects Analysis (FMEA) is a methodology used to analyze and prevent the effects of potential failures before they happen. A simple FMEA Template can help you document and organize your analysis.

Example of the FMEA Template in QI Macros for Excel

QI Macros FMEA Template is actually a series of 11 templates for all of the Process FMEA's (PFMEA), Design FMEA's (DFMEA) and FMEA for Monitoring and System Response (FMEA-MSR) defined in the AIAG FMEA 5th Edition (AIAG & VDA FMEA 1st Edition) and FMEA 4th Edition.

Both template editions can be found in the DOE GageR&R FMEA drop-down menu:

---

Complete List of the FMEA Templates in QI Macros for Excel

FMEA 5th Edition (AIAG & VDA FMEA 1st Edition) Templates	DFMEA	PFMEA	FMEA-MSR
Form A: Standard DFMEA	X
Form B: Alternate DFMEA	X
View A: DFMEA Software View	X
Form C: Standard PFMEA		X
Form D: Alternate PFMEA		X
Form E: Alternate PFMEA		X
Form F: Alternate PFMEA		X
Form G: Alternate PFMEA		X
View B: PFMEA Software View		X
Form H: Standard FMEA-MSR			X
View C: FMEA-MSR Software View			X

FMEA 4th Edition - Description	DFMEA	PFMEA	Machinery FMEA
Checklist	X	X
Basic Form with minimal information (SAE J1739)	X	X
Adds requirements column	X	X
Form A with Prevention controls to left of Occurrence column	X	X
Form B with Prevention controls to left of Occurrence column	X	X
Form D with separate columns for cause/failure mode in Detection Design Controls	X	X
Form B with separate columns for Responsibility, Target Completion Date, Actions Taken and Completion date	X	X
Form B with ID, Product and Process w/in a bridged Requirements Column		X
Form D and G combined		X
Basic Form – Two columns for machinery and design controls			X
Basic Form – One columns for combined machinery and design control			X

---

Seven-Step FMEA Approach

The updated AIAG & VDA FMEA 1st Edition handbook describes a Seven-Step approach that guides design development and process, along with monitoring and FMEA system response:

1. Planning and Preparation: Develop a FMEA project plan.
2. Structure Analysis: Using a visual method, decide which product or process that will be analyzed.
3. Function Analysis: For both your Design (DFMEA) and Process (PFMEA), choose which functions will be performed, along with HOW you will evaluate their performance(s).
4. Failure Analysis: What is/are the failure mode(s)? And what effects or causes these failures?
5. Risk Analysis: Assign severity of risk, along with occurrence and detection of the cause of failure. This allows you to estimate your level of design or your process risk.
6. Optimization: Based upon your Risk Analysis from step 6, decide which aspects of your FMEA will require actions that reduce your risk. And what are those actions?
7. Results and Documentation: Document your findings! How did you reduce risk, and what were the actions taken? Create a comprehensive report that shows your findings.

---

The FMEA Diagram is one of many tools included in QI Macros add-in for Excel.

QI Macros adds a new tab to Excel's menu, making it easy to find any tool you need. If you can't locate a tool, use the find tools feature on the far right side of QI Macros menu.

Learn More...

• FMEA Example with Step by Step Instructions
• FMEA and DFMEA Overview
• Other DFSS Tools in QI Macros

---

Why Choose QI Macros Add-in for Excel?