1. Built-In FMEA Template
If you are looking for an Excel FMEA template, there are DFMEA and PFMEA templates provided with FMEA Analysis Add-In. Download FMEA Analysis to use the templates.
Built-in FMEA Template for Excel
After downloading, install FMEA Analysis Add-in 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:
- Click the New Document From Template button.
- Select the right template and click on it from the drop-down menu.
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.
3. How to use your current FMEA Template with FMEA Analysis Add-in
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 Analysis allows you to set the relationships by assigning one of below roles for each column in an FMEA:
- 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.
- 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
- 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:
- In the Column Relation Manager windows, select Set Root-Column,
- A dialog appears, selects the header of Item column then click OK.
- Now we completed with setting Root Column, Column Manager updates with Item 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:
- Select Item column in the Columns Manager, click Add Child-Column.
- A dialog appears. Selects the header of Function column then click OK.
- 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.
- Select Potential Failure Mode in Columns Manager, press Add Sub Column.
- A dialog shows up, select 3 columns above and press OK.
- 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.