Quickly add input variables to your model by importing them from an Excel
spreadsheet.
-
In the Define Models step, click Import Variables.
The Excel spreadsheet opens.
-
Select input variables.
-
In the Excel dialog, click
Yes to begin selecting input variables.
The Excel - HyperStudy Input Selector
dialog opens.
-
In the spreadsheet, select the input variable's value and label
cells.
Note: You can select an input variable's value and label in two
consecutive rows or two consecutive columns.
The selected cells display in the Excel - HyperStudy
Input Selector dialog.
-
Click OK to import the selected input
variables.
-
To continue selecting input variables in other areas of the
spreadsheet, repeat steps 2.b and 2.c.
-
Click Cancel in the Excel - HyperStudy
Input Selector dialog to stop selecting input
variables.
-
Select output responses.
-
In the Excel dialog, click
Yes to begin selecting output
responses.
The Excel - HyperStudy Input Selector
dialog opens.
-
In the spreadsheet, select the output responses' value and label
cells.
Note: You can select an output responses' value and label in two
consecutive rows or two consecutive columns.
The selected cells display in the Excel - HyperStudy
Input Selector dialog.
-
Click OK to import the selected output
responses.
-
To continue selecting output responses in other areas of the
spreadsheet, repeat steps 3.b and 3.c.
-
Click Cancel in the Excel - HyperStudy
Input Selector dialog to stop selecting output
responses.