 |
|
As we can seen in Figure 11.5, "Second step of wizard" a table (red) appears. This allows you to choose wich columns to import (representing variables of model) and which rows too (designs). After pressing in previous step, you find the table cells already selected. You can modify this selection using the mouse. Clicking or dragging on table header (green) allow you to select the whole column(s). You can do the same on the row header (yellow).
If in your data contain a row of words representing names for the model variables, you can choose it as in Figure 11.6, "Selecting names". Click the radio button (red) and a yellow highlight appear. Use the spinner (green) to choose the right row.
Goal of this tutorial
Our goal is to build a modeFRONTIERTM Work Flow (Section 4.2, "The Work Flow Canvas"), starting from the data of a MS Excel worksheet.
We select columns a1, b1, c1, r1 which will become our input variables and columns TotalCost, TotalSurface, TotalWeight as output variables. Press to proceed.
Note
The wizard will ignore:
each whole row that is not selected;
each whole row that is selected, but is empty;
each whole column that is selected, but is empty;
The wizard will consider as not-a-number
each text cell of a row selected for importing, but not highlighted;
each empty cell of a row with one or more non-empty cells;
