FMEA Template for Excel

We all need an FMEA template before starting an analysis. If your customers have specific requirements for FMEA forms, you may have to use their form. If they don’t you can use your templates or AIAG, VDA templates. FMEA Analysis provides many customizable FMEA templates and also can use an existing form as a template.

1. Built-In FMEA Template

After install FMEA Analysis for Excel. Open Microsoft Excel, you will see the FMEA Analysis tab inside Excel Ribbon as the picture below. Follow the steps to start using the selected template for your FMEA analysis:

Using FMEA Templates in FMEA Analysis Software

  1. Click the New From Templates button.
  2. Select the right template from the drop-down menu. There are 6 DFMEA Templates and 6 PFMEA  Templates. They are different in columns and column structure, the following table will help you to select the right template for the analysis.
NameDescriptionUsage
DFMEA Template 1Item, Function and Requirement are separate. Prevention Controls and Detection Controls are separateUsed for complex product/part. One item has many function and one function has many requirement. Need the separation of prevention control and detection control for further analysis
DFMEA Template 2Item, Function and Requirement are separate. Prevention Controls and Detection Controls are combinedAs DFMEA Template 1 but it's not necessary to separate prevention controls and detection controls.
DFMEA Template 3Item and Function are separate. Prevention Controls and Detection Controls are separateUsed when one item has many functions and not necessary to determine requirements. Prevention Control and Detection Control are separate for further analysis
DFMEA Template 4Item and Function are Separate. Preventions Controls and Detection Controls are combined.As DFMEA Template 3 but it's not necessary to separate Prevention Controls and Detection Controls.
DFMEA Template 5Item and Function are combined. Prevention Controls and Detection Controls are separate.Use for simple product/part. One item has one function. Prevention controls and detection controls are separate for further analysis
DFMEA Template 6Item and Function are combined. Prevention Controls and Detection Controls are combined.As DFMEA Template 5 but it's not necessary to separate prevention controls and detection controls.

2. Customize FMEA Template

But what if you want to add more columns to current template? Example, you want to add a Responsiblity column beside the Action column. The logic here is: aach Action item has 1 coresponding Responsibility item. So the new column should link with the Action column

Let’s do it with Column Manager.

FMEA Template New Column

3. Use your existing FMEA Template with FMEA Analysis

However, if you are working with FMEA for a while, you may have your own FMEA template from your company or your customers. So how to use your template with FMEA Analysis in order to complete your analysis faster? Just follow simple steps below to turn it on for FMEA Analysis.

3.1 Relational structure in an FMEA Template

FMEA is not a flat data table. It is a hierarchical data table that has relationships between columns. In our example below, each Item has one or many Functions; each Function has one or many Requirements; Each Requirement has one or many Potential Failure Mode;…

FMEA Relation Structure

FMEA Analysis allows you to set the relationships by assigning one of below roles for each column in an FMEA:

  1. Root column: Root column is the highest level column in column hierarchy in a relational strucutre table. There is only one root column in an FMEA (or a FMEA Analysis FMEA Analysis). Root Column has one or many Child Columns and Sub Columns.
  2. Child column: child column of a given column is the column that has many to one relationship with the given column. Child Column has one or many Child Columns and Sub Column
  3. Sub column: sub column of a master column (root column or a child column) is a column that has one to one relationship with the master column. Sub Column does not have a Child Column or Sub Column.

With above FMEA example, Item is the Root Column, its child column is Function and it has no sub column; Function column has Requirement as its child column; Requirement has Potential Failure Modes column as its child column;…

3.2 Set Root Column

OK, let’s start with the root column of the template. Follow the steps below to set Item as the root column:

  1. In the Column Relation Manager windows, select Set Root-Column,
  2. A dialog appears, selects the header of Item column then click OK.
  3. Now we completed with setting Root Column, Column Manager updates with Item column.

FMEA Template Set Root Column

3.3 Set Child Column

Each Item has one or many functions. Function column need to be set as a child column of Item column:

  1. Select Item column in the Columns Manager, click Add Child-Column.
  2. A dialog appears. Selects the header of Function column then click OK.
  3. Columns Manager updates and shows the Function column.

3.4 Set Sub Column

But Potential Effects of Failure column has relation 1-1 with Potential Failure Mode column, it need to be set as a sub column of Potential Failure Mode.

  1. Select Potential Failure Mode in Columns Manager, press Add Sub Column.
  2. A dialog shows up, select 3 columns above and press OK.
  3. Press OK, now Columns Manager updates with subs columns just added.

Do the same for the rest of the column in our FMEA form, final hierarchy in Columns Manager shown as below picture.

Like? Share it with your friends

Share on facebook
Share on twitter
Share on linkedin

Are you wasting your valuable time?

Conduct FMEA analysis faster than ever right inside Excel

Table of Contents

Download FMEA Analysis

And get the lastest news and articles

Download link and installation instruction email will be sent to your email address after pressing the Subscribe and Download button