Need a FMEA Template in Excel?
QI Macros has a Ready-Made FMEA Template
Create FMEAs using QI Macros
- Select FMEA 4th or 5th.
- Click on QI Macros menu > DOE MSA - FMEA.
- 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
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 |
---|---|---|---|
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:
- Planning and Preparation: Develop a FMEA project plan.
- Structure Analysis: Using a visual method, decide which product or process that will be analyzed.
- 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).
- Failure Analysis: What is/are the failure mode(s)? And what effects or causes these failures?
- 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.
- 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?
- 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.
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?
Fast and Easy to Use
- Works right in Excel
- Create charts in seconds
- Easy to customize & share charts
- Free Training Anytime
Proven and Trusted
- More than 100,000 users
- In More than 80 countries
- Five Star CNET Rating - Virus free
Affordable
- Only $349 USD
Quantity Discounts Available - No annual subscription fees
- Free technical support