Importing Data from Excel Files to DOE++
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
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
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++
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++.