FMEA Worksheet

The Worksheet tab for an FMEA presents the analysis data in the traditional tabular format that most FMEA practitioners are familiar with. It allows you to type directly into the worksheet cells and tab through the analysis as you would in a spreadsheet application such as Microsoft Excel.

The status bar at the bottom of the tab displays the record type and the number of attachments the record has. For controls and actions, it also includes a link to the Dependency Viewer where you can see where the resource is used. Starting in Version 2019, if a control or action is used more than once, this area is highlighted as shown above.

Tip: Starting in Version 2020, if the analysis contains records with ancestry information, each record's cell contains an icon ( , or ) indicating the status of its association with the source record.

Adding or Editing Records

To add or edit records in the worksheet, you can use the commands on the FMEA ribbon, or right-click inside a cell and use the shortcut menu. The options depend on which cell is currently selected. (See FMEA Tab for a complete list.)

You can also add and edit records directly in the worksheet cells. The options vary depending on whether the cell is selected or in edit mode.

  

When a cell is selected:

When a cell is in edit mode:

Note: For projects that use the Grouped Effects and Causes FMEA structure, effects are edited in the Effect Properties Window rather than directly in the worksheet.

Reordering Columns

The project’s interface style determines which columns are displayed in the FMEA worksheet, as well as the column order. This will be the same for any user who views the analysis.

If you drag and drop a column heading into a new position while using the worksheet, the new order will be saved in the interface style if you have write access for the project. If you have read-only access, the new order will not be retained after you leave the current worksheet.

Resizing Columns

To resize a column, drag the column heading to the desired width. The preferred widths will be saved per computer/username. This will be the same for any analysis you view on this computer, but other users may have different column size preferences.

Repeating Data

To populate the gray areas in the worksheet with the relevant information from a prior row, choose File > Application Setup. On the Settings page select the Repeat data in worksheet views check box.

Inserting or Removing a Split Bar

A split bar creates two areas in the worksheet that scroll separately.