FMEA Template in Excel

* 5th Edition FMEA (AIAG & VDA FMEA 1st Edition) released 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

fmea-template

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.


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.

Watch this overview video

*Video recorded using FMEA 4th Edition - format is different, but 5th Edition template functions the same*


Learn More...


Why Choose QI Macros Add-in for Excel?

affordable

Affordable

  • Only $299 USD - less with quantity discounts
  • No annual subscription fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free