FMEA Worksheet Table
The FMEA Worksheet table displays the failure data that has been inserted for the item selected in the FMEA Items Tree table. As described in FMEA Data Levels, you can have as many as five data levels: items, modes,
It is possible that your system administrator has granted you access to only the FMEA Worksheet records that you inserted. For more information, see User Level Filtering (Enterprise Edition Only).
Three Table Format files are available for FMEA Worksheet tables, one for each FMEA type (component, functional, and process). This allows you to customize the FMEA Worksheet table for each FMEA type independently. The fields that can be inserted in the Table Format file for a FMEA Worksheet table are limited to the fields in the Project’s FMEA Design file. The FMEA Design file determines the structure and data fields for all FMEAs in the Project. For more information, see FMEA Design Files.
By default, the fields in the Table Format files for all three FMEA Worksheet tables are the same. The following table describes the default fields for these tables.
Field
Description
Item Identifier
The unique identifier assigned to the item. The format for this identifier is specified by FMEA Item Identifier, which appears under Identifier in the System file properties. For more information, see Identifiers System File Properties.
Item Name
The name of the item for which modes, causes, and effects are inserted.
Item Description
A description of the item for which modes, causes, and effects are inserted.
Mode Identifier
The unique identifier assigned to the mode. While an identifier is assigned to the mode when it is inserted, you can change it to any unique value. The format for the assigned identifier is specified by FMEA Mode Identifier, which appears under Identifiers in the System file properties. For more information, see Identifiers System File Properties.
Failure Mode
The way in which the item could potentially fail to meet the design intent. The failure mode might also be the cause of a failure mode in a higher-level subsystem or system or an effect of a failure mode in a lower-level competent. A typical failure mode for an item can be that it is cracked, deformed, loose, leaking, short-circuited, or fractured.
Local Effect
The consequence or event associated with the cause at the current level due to the occurrence of the failure mode.
Next Effect
The consequence or event associated with the cause one level up from the current level due to the occurrence of the failure mode.
End Effect
The final (top-most) consequence or event associated with the cause due to the occurrence of the failure mode.
Cause of Failure
How the failure mode could occur in terms of something that can be corrected or controlled. You insert all possible failure causes for the failure mode. A typical cause of a failure mode can be that the item is missing a part or is improperly torqued, inaccurately gauged, or inadequately lubricated.
Additional Information
Additional information about the FMEA Worksheet table follows.
As data levels are inserted in the FMEA Worksheet table, cells containing parent information span to the height of their children. This automatic merging of individual cells makes understanding the relationship between data levels easy. Information about record sources, record management, and cell formatting appears in the following topics:
If Failure Rate is at the item (top) FMEA data level, the value shown is the failure rate percentage. The item failure rate is the product of the failure rate percentage and the subassembly failure rate.
If Mission Phase is shown in the FMEA Worksheet table, all mission phases defined in the Project’s Mission Profile file are available for selection. When the same phase exists in more than one mission profile, it is shown only once. For more information, see Mission Profile Files.
The FMEA Worksheet table supports aggregate functions for user-defined FMEA calculations. Information about aggregate functions appears in Field Functions.
The FMEA Worksheet table supports the numbering of items at each FMEA data level. For more information, see Numbering the FMEA Worksheet by Data Levels When MSG-3 is Enabled.