Reliability HotWire

Issue 107, January 2010

Tool Tips

* How can I sort my DOE++ Data Sheet by factors?

Much of the time you will need to sort the DOE++ Design tab Data Sheet either by the standard order (which is specified in the design type) or by the run order (which is the randomized order generated by DOE++ in which it is recommended to perform the runs to avoid biased results). To make this easy, these sorting options are provided on the Main page of the Design tab Control Panel. There may be times, however, when you need to sort the Data Sheet by other columns.

To sort the Data Sheet by any column, click a cell or the header in the column you want to sort by and then choose Sheet > Sort > Sort Ascending or Sheet > Sort > Sort Descending. The entire Data Sheet will be sorted by the selected column. If more than one contiguous column is selected, the Data Sheet will be sorted by the leftmost selected column.

Starting with version 1.0.3, you also can use the Sort Spreadsheet window to sort the Data Sheet by one or more factor columns, as well as by the Block column. To access this window, choose Sheet > Sort > Sort By Factors.

To use the Sort Spreadsheet window, move the column(s) you want to sort by from the Available Columns area into the Selected Columns area. To do this, you can:

  • Double-click a column to move it from one area to the other.
  • Select one or more columns in one area and then click the appropriate single arrow or drag the columns to the other area.
  • Use the double arrows between the areas to move all columns at once.

Next, arrange the selected columns in the desired sort order (i.e. the Data Sheet will be sorted by the first column in the Selected Columns area, then by the next column, etc.). To do this, you can select one or more columns and do either of the following:

  • Use the arrows on the right side of the window (Move to Top, Move Up, Move Down, Move to Bottom).
  • Drag the column(s) to the desired position.

Select whether you want to sort the Data Sheet in ascending order or in descending order, then click OK to sort.

* Which product is right for my organization: Xfmea, RCM++ or MPC?

ReliaSoft offers three software products that provide data management and reporting for FMEA and/or Reliability Centered Maintenance (RCM): Xfmea, RCM++ and MPC.

  • In general, Xfmea is recommended for those who wish to use FMEA and related techniques to evaluate risk and improve the design of a product or process (usually in a product development context).

  • For those who wish to use FMEA and/or Reliability Centered Maintenance (RCM) techniques to evaluate risk and determine an appropriate scheduled maintenance strategy (usually in an equipment operations context):

    • MPC may be preferred by users in the aircraft industry, as it was designed specifically to meet the needs of the aircraft industry for performing systems and powerplant analysis according to the MSG-3 guidelines. It includes logic constraints that are specific to the aircraft industry (e.g. uses ATA system and subsystem numbers, requires analysis one level above the lowest level in the system configuration, requires a task to be defined if the issue has been identified as safety-related, etc.). It also includes report output that has been accepted by the Air Transport Association (ATA) for this type of analysis.

    • RCM++ is recommended for all other applications. This software was designed as a general-purpose analysis, data management and reporting tool for FMEA and RCM. It allows you to configure the software with the Equipment Selection, Failure Effect Categorization and Maintenance Task Selection logic specified in the MSG-3 guidelines but applying the logic is left to the discretion of the user (e.g. nothing forces you to define a task if the issue has been identified as safety-related, etc.). The report output was designed to meet general needs and has not been tested for compliance with ATA requirements for MSG-3.

Copyright 2010 ReliaSoft Corporation, ALL RIGHTS RESERVED