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:
- Click the New From Templates button.
- 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.
|DFMEA Template 1||Item, Function and Requirement are separate. Prevention Controls and Detection Controls are separate||Used 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 2||Item, Function and Requirement are separate. Prevention Controls and Detection Controls are combined||As DFMEA Template 1 but it's not necessary to separate prevention controls and detection controls.|
|DFMEA Template 3||Item and Function are separate. Prevention Controls and Detection Controls are separate||Used when one item has many functions and not necessary to determine requirements. Prevention Control and Detection Control are separate for further analysis|
|DFMEA Template 4||Item 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 5||Item 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 6||Item 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.
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 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.