FMEA - Failure Mode and Effects Analysis

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

Preventing Disaster with FMEA, DFMEA, PFMEA and FMEA-MSR

When you are designing a product or a process that can affect human life, you want to anticipate all of the ways things could go wrong and affect your customer.

The automobile and airline industries do this routinely to mitigate and prevent potential problems. The tool they use is the Failure Modes and Effects Analysis (FMEA).

QI Macros add-in for Excel contains an easy-to-use FMEA Template to guide you through your analysis. You can use it to analyze a:

  • Product (car, x-ray, MRI) using a Design FMEA (DFMEA)
  • Part (car door) using a Design FMEA (DFMEA)
  • Process (part stamping process or elective surgery) using a Process FMEA (PFMEA)
  • Project identification (legal and/or technical requirements, customers' wants/needs/expectations) using a FMEA for Monitoring and System Response (FMEA-MSR)
Gary Larson's crisis clinic and fmea

Example of the QI Macros FMEA Template in Excel


Use the DFMEA or PFMEA template to analyze and prevent the effects of potential failures before they happen. Can you afford an injury or a death? Probably not. Can you afford the time and money involved in litigation? Probably not. Is it cheaper to use an FMEA worksheet and prevent potential problems? No doubt, especially when the consequences are extreme. Are you going to catch everything? No, because some things are outside of our ability to imagine them.

Watch this FMEA Overview Video

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

Learn More ...

Why Choose QI Macros for Excel?



  • 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