Quickly add input variables to your model by importing them from an Excel
spreadsheet.
Before you begin importing
input variables from an Excel spreadsheet, it is import that the data in your
spreadsheet is formatted correctly. For more information, refer to the Usability
Characteristics section in
Spreadsheet Model.
-
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.
The imported input variables
are added to the list of input variables in the Define Input Variables step, and the
imported output responses are added to the list of output responses in the Define Output
Responses step.