DRBFM Worksheet

The Worksheet tab displays the records that will be tracked with the DRBFM. If you have the permissions necessary to edit the project properties, you can choose which fields will be enabled and what they will be called. For example, you can include user-defined fields and define the options in the user-defined drop-down menus, when applicable.

Xfmea provides two different "views" for the worksheet; one is intended to be used by the Design Engineer who performs the first draft of the analysis and the other is intended to be used by the entire Review Team to modify and expand upon the initial draft. Use the options at the top of the worksheet to toggle between the two views.

Select Design Engineer to hide the Other Concerns, Other Causes and Actions columns in the worksheet.
Select Review Team to display all enabled columns in the worksheet.

Note: If the Severity, Occurrence and Detection columns are enabled in the FMEA, then those columns are also displayed in the DRBFM Worksheet along with the initial and revised RPNs. (See FMEA > RPNs.)

When using the DRBFM worksheet, you have the following options:

To enter or edit data, double-click the cell.
- For text columns, you can use the HOME, END and arrow keys to move through the text in the cell. For date columns, you can click the column once to open a calendar or twice to type the date. You must use the mm/dd/yy or mm/dd/yyyy format.
- To save the changes, either press ENTER or TAB or click somewhere outside of the cell.
The following options apply to parts, functions, concerns, effects, causes, controls and actions. While the examples given are for parts, the commands are similar for each record type:
- To add a part, choose DRBFM > Records > Parts/Functions > Add Part/Function.
- To insert a part above the currently selected one, choose DRBFM > Records > Parts/Functions > Insert Part/Function.
- To copy, select the part in the worksheet area and choose Home > Clipboard > Copy. To paste a copied part, choose Home > Clipboard > Paste.
- To move a record up or down one place in the list of parts, select the part in the worksheet area, then right-click the worksheet and choose Up or Down from the shortcut menu or choose Home > Move Record > Up or Home > Move Record > Down.
- To delete, select the part in the worksheet area and either choose Home > Edit > Delete or press DELETE. You can undo the last deletion only.
To import functions from the FMEA, choose DRBFM > Sync > Get Functions from FMEA. To export the functions to the FMEA, choose DRBFM > Sync > Send Functions to FMEA.
To import header properties from the FMEA, choose DRBFM > Sync > Get Header from FMEA. To export the header properties to the FMEA, choose DRBFM > Sync > Send Header to FMEA. Performing either action makes the headers identical.
To import data from an Excel spreadsheet, choose Home > Excel > Excel > Import from Excel. To export data from the DRBFM worksheet to an Excel spreadsheet, choose Home > Excel > Excel > Export to Excel.
To generate a report of the DRBFM data, choose Home > Reporting > Reports. In the Reports window, the DRBFM reports are located in the DRBFM Spreadsheet and DRBFM Records sections of the Available Reports area.
To split the worksheet view so that you can view text at one side of the worksheet without moving the text at the other side, right-click a column header and choose Split. A split bar will be placed to the left of the column. To remove the bar, right-click any column header and choose Remove Split. (For example, you use this to see the function number while working on the actions.)
To rearrange the order in which the columns are displayed, select a column header and drag it to the place in the worksheet area you want it to appear. This updates the interface style for the project. You also can change the column order through the Project Interface Style window.
To change the descriptive information about each column that displays in tooltip form when you move the pointer over the column headers, open the Project Interface Style window and change the text in the appropriate DRBFM pages.