Home / Monte Carlo / Model Building / Import Model from Quantum XL DOE
Import Model from Quantum XL DOE¶
From Excel click...
QXL Monte Carlo New > Design > Create/Modify Design Sheet > Import Model from Quantum XL DOE
Turns a fitted model that already sits on a Quantum XL DOE regression sheet into a Monte Carlo Design Sheet, with every input and output already marked.
It reads coefficients that are already on the sheet and fits nothing. The one exception is creating the uncoded model, described below, which is a fit.
Stand on the regression sheet holding the model you want, then run the command.
The steps¶
The command asks a short series of questions and then writes the sheet. Nothing is written until the last one is answered.
1. Where the sheet goes¶
Asked only when the workbook already holds a design sheet, and it is the same question Create Monte Carlo Design Sheet asks, with one difference: an imported sheet cannot go in a new workbook.
An imported design sheet has to be in the same workbook as the regression sheet it was built from, so it cannot go in a new workbook. Choose Add to This Workbook, or move this regression sheet into a workbook of its own first and run the command again.
The reason is that an imported sheet's per-term contribution cells and its level lists live on the workbook's own hidden lists sheet, and its output equations name the design sheet by name, so the two cannot be in different workbooks.
2. Coded units, if the model is in them¶
Shown only when the transfer function is written in coded units:
This model is in coded units
The transfer function is written in coded units, so each input runs from minus one to plus one rather than in its real units. A Monte Carlo model built from it cannot use real distributions or real specification limits.
Quantum XL can create the uncoded model for you. That adds one worksheet to this workbook and imports from it.
| Choice | What happens |
|---|---|
| Create the Uncoded Model and Import That | one worksheet is added holding the uncoded model, and the import reads that. This is the one step that fits anything |
| Import the Coded Model as It Is | the coded model is imported, with inputs running minus one to plus one |
| Cancel | nothing is written |
The first choice is unavailable when the uncoded model cannot be created, and the dialog says why in bold rather than leaving a dead button unexplained. It cannot be created when the design sheet the regression sheet was built from is not there to read.
3. What to import¶
Choose what to import
Tick the outputs and models this Monte Carlo design sheet should hold.
One entry per output, and where the regression sheet has both, each output offers two models:
- Y-hat (Average) Model
- S-hat (standard deviation) Model
A model the regression sheet does not have is shown unavailable rather than hidden, with the reason on it. At least one entry has to be ticked:
Tick at least one output to import.
What is written¶
The same sheet Create Monte Carlo Design Sheet writes, in the same layout and with the same protection, plus the imported values already filled in: each input's distribution and parameters, each output's equation, and the specification limits the regression sheet carried.
A term the regression left inactive is left out of the equation, rather than carried into it with a coefficient of zero. Level names are written as text, the way the regression sheet holds them and the way the dropdown supplies them, so the per-term contribution formulas match them.
A coded model is written in coded units throughout. Choosing Import the Coded Model as It Is brings a continuous input across coded: its distribution's mean, its Input Value cell and its valid operating region are all in the units the coefficients multiply. An input whose design ran 100 to 200 with its set point at 150 arrives running minus one to plus one with its mean at zero. A categorical input's level is not a quantity and is untouched. This is why the choice above says a Monte Carlo model built from a coded transfer function cannot use real distributions or real specification limits: if you want the model in the units you measure in, take Create the Uncoded Model and Import That.
A design with categorical factors gets one more area. Categorical inputs sit below the input blocks in their own two-column area headed Categorical Inputs, with an Input Name column and a Level column, each level chosen from a list on the cell. They are there rather than among the input blocks because a categorical factor is a fixed setting you pick, not a quantity the simulation samples.
Two things it refuses¶
A sheet that is not a Quantum XL DOE regression sheet:
This command needs a Quantum XL DOE regression sheet. Select the regression sheet that holds the model you want to import, then run the command again.
A DOE Pro regression sheet:
This is a DOE Pro regression sheet. Quantum XL imports models from Quantum XL DOE regression sheets only.
A second categorical import into the same workbook is also refused, because the two would overwrite each other's level lists:
This workbook already holds an imported design sheet that has categorical inputs. A second one would overwrite its level lists, so it is not allowed. Import this model into a workbook of its own: copy the regression sheet and its design sheet into a new workbook, then run the command there.
A design with no categorical factor writes nothing to the shared lists, so it never collides and is never refused this way.
A structure-protected workbook is refused up front rather than halfway through the build:
The workbook's structure is protected, so the markings cannot be saved. Unprotect the workbook (Review tab, Protect Workbook) and try again.
After the import¶
The sheet is an ordinary design sheet: open Mark Input or Mark Output on any of its cells to change a marking, and run Validate Model to check the equations will run in the fast engine.
Modify Monte Carlo Design Sheet works on an imported sheet unless it has categorical inputs, which that command cannot keep.