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

Severity and Occurrence Evaluation Criteria are also included at the bottom of each template.

fmea template severity criteria

An Effects of Failure Example is Included as Well

fmea template severity criteria for effects of failure on stakeholders

QI Macros FMEA Template is actually a series of more than a dozen templates for all of the Process FMEA's (PFMEA) and Design FMEA's (DFMEA) defined in the AIAG FMEA 4th edition.

Complete List of the FMEA Templates in QI Macros for Excel

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

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 $279 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