Spreadsheet Model
Use the Spreadsheet model to perform calculations.
![](../../images/icons/icon_model_spreadsheet.png)
- Version
- Microsoft Office
- File Extension
-
- .xls
- .xlsx
- .xlsm
- Multi-Execute Support
- Yes
- Response Definition Support
- Yes
- Registration Steps
- N/A
- Usability Characteristics
-
- Input variable and output response cells are identified by the user.
- When creating a Spreadsheet model an input variable's value and label can be formatted in two consecutive rows or two consecutive columns. Input variable labels should only contain English characters, or a combination of English characters and numbers. If you do not create a label for a variable, HyperStudy will assign one by default.
- On a Windows operating system, Spreadsheet
models will be brought to the front. HyperStudy
will prevent you from accessing any spreadsheets that you had opened
prior to or after (by double-clicking) starting your current
HyperStudy session.
To access an Excel spreadsheet while running a study with Spreadsheet models, you must explicitly start a new session of Excel.
- Windows platform only
- Support for VB macros