Reliability HotWire

Issue 107, January 2010

Hot Topics

Importing Data from Excel Files to DOE++

DOE++ gives the user the ability to create Standard Folios by importing data from files created by other applications. The file types that available for import are:

  • Tab, Comma, Space and Semicolon delimited files (*.txt, *.csv, *.prn, *.smc)
  • Excel files (*.xls)

This article provides a simple step-by-step guide for importing data sets created in Excel.

Example
Consider a 2 level full factorial design of an experiment with 4 factors, for which data has been entered in Excel. Figure 1 shows the original data set that includes the 4 factors, the response variable, the standard order and the run order.



Figure 1: Original Data Set in Excel

Now suppose that we want to import this data set into DOE++ in order to perform further analysis. This can be done by starting DOE++ and choosing Project > Add From File. After selecting the Excel file that the data set was saved in, the File Import Wizard shown in Figure 2 appears.



Figure 2: File Import Wizard

The first step is to select the appropriate design type of the experiment. Figure 3 shows the list of available design types. In this case, we select the 2 Level Factor type.



Figure 3: Design Types

Once the design type has been selected, the Control Panel displays the information on the design requirements and the configuration options, as shown in Figure 4. In this case, at least two factors and one response variable are required.



Figure 4: Design requirements and configuration options

The next step is to define the column type for each column of data. For example, the first column in Figure 5 is specified as the standard order, the second column is specified as the run order, the third through sixth columns are specified as factors and the seventh column is specified as the response variable.



Figure 5: Defining the type of each column

The properties of the factors and response variables can be changed from the Control Panel. Figure 6 shows the Factor Properties window, which can be opened by clicking the Factor Properties button. In that window, we can specify what are the units of measure for each factor, whether a factor is qualitative or quantitative and the low and high levels of each factor.



Figure 6: The Factor Properties window

Finally, after defining the appropriate columns and setting the factor properties, we can click the Create Design button to create a new Folio that contains the imported data set. Figure 7 shows the new Folio that was created from our original data set.



Figure 7: Folio in DOE++

Conclusions
As we have seen in this example, importing data from Excel to DOE++ is a fast and easy task. While in this example we imported a 2 level full factorial design, DOE++ gives users the ability to import the data from a variety of different types of designs. Finally, the DOE++ Import Wizard enables users to select which columns in their Excel data sets are appropriate for the selected design and specify the different variable properties so that the data will be in the format required for analysis in DOE++.

Copyright © 2010 ReliaSoft Corporation, ALL RIGHTS RESERVED