Need a FMEA Template in Excel?

QI Macros has a Ready-Made FMEA Template

Create FMEAs using QI Macros

  1. Select FMEA 4th or 5th.
  2. Click on QI Macros menu > DOE MSA - FMEA.
  3. Fill in the blanks

* 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

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.

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

fmea menu locations


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.

Haven't you waited long enough?
Start creating your FMEA Diagram in just minutes.

Download a free 30-day trial. Get the FMEA Diagram now!

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.

find tools on QI Macros menu

Learn More...


Why Choose QI Macros Add-in for Excel?

easy to use

Fast and Easy to Use

  • Works right in Excel
  • Create charts in seconds
  • Easy to customize & share charts
  • Free Training Anytime

proven and trusted

Proven and Trusted

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

affordable

Affordable

  • Only $349 USD
    Quantity Discounts Available
  • No annual subscription fees
  • Free technical support