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
- 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
- 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):
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