Skip to content

Home / DOE / Create Designs / Import DOE Pro Design / Import DOE Pro How-To

Import DOE Pro How-To

This walkthrough converts a DOE Pro design into a Quantum XL design sheet and shows what to check before you trust it.

Sample Data

You need a DOE Pro design to convert. If you have one, use it. If you want the walkthrough to line up with the rest of this section, build a three factor two-level design in DOE Pro XL and fill it from the block below, which is the same sixteen run experiment every other DOE walkthrough uses.

Temp Press Time Strength
180 40 10 49.5
220 40 10 65.4
180 60 10 61.8
220 60 10 66.8
180 40 20 52.3
220 40 20 70.7
180 60 20 60.7
220 60 20 70
180 40 10 50.6
220 40 10 66.4
180 60 10 61.2
220 60 10 67.2
180 40 20 51.4
220 40 20 67.1
180 60 20 61.9
220 60 20 71.6

Those four columns are what the conversion has to bring across intact, and the section below is the list of things to check it against once it has.

Steps

  1. Open the workbook holding the DOE Pro design and make its design sheet the active sheet.

  2. QXL DOE New > Create Design > Import DOE Pro Design. There is no dialog: the command reads the workbook and either converts it or reports why it cannot.

What you get

A Quantum XL design sheet carrying the same factors, levels and runs. From that point it is an ordinary design sheet: Run Regression reads it, Modify Design changes it, and the charts draw from it.

What to check before you trust it

The factor count and the run count, against the sheet you converted from. These are the two numbers a conversion can get wrong without looking wrong. With the block above that is 3 factors and 16 runs.

Each factor's type. A factor that was categorical in DOE Pro must still be categorical here, because the type decides how the model treats its levels and therefore how many degrees of freedom it spends.

The responses. A converted sheet brings the run settings across; confirm the responses landed in the output columns and not beside them.

The model. A converted design carries no record of how it was built, so the first regression may ask for what the sheet does not say, exactly as a custom design does.

If it cannot read the workbook

The command reports the reason rather than converting anything. The messages are on Import DOE Pro Design.

See Also