When working with ISEE.SETDATA use this function to set the value of one or more model variables. Setting data in this manner works the same way importing does inside of Stella, except that you specify a range rather than a complete file or sheet. The format for the ranges is the same as that described in Setting Up Import Links. As with importing on the interface, the orientation and meaning of the range specified is determined from the content.
Use this to set the values of one or more variables in the model. The specified range can be in the form F6:G8, or a named range, or any other format Excel recognizes. Typically it is specified by drag selected what you want to include.
The range needs to include both variable names and values to set them to. There are two modes in interpretation, and which to use is determined automatically by Stella in Excel:
birth rate | 0.3 |
average lifetime | 58 |
Time | 1 | 2 | 3 | 4 |
measured temperature[South] | 80 | 60 | 70 | 90 |
measured temperature[North] | 50 | 40 | 60 | 70 |
Note If you combine ISEE.SETVALUE with ISEE.SETDATA for the same variable, or have multiple ISEE.SETDATA functions change the same variables the results will be unpredictable.
If successful, ISEE.SETDATA returns Success, otherwise it will provide an error message indicating the nature of the error. Most typically this a variable name that is not recognized.
Examples:
![]()
ISEE.SEDATA(A1:D2) sets the values of initial population in the north and south for 3 age groups and returns Success.
ISEE.SEDATA(A1:D3) sets the values of initial population in the north and south for 3 age groups, but returns an error message indicating that not all names were recognized.
ISEE.SEDATA(A3:D3) does nothing and returns an error message indicating that no names were recognized.
Note You can use spaces or underbars in variable names.
Note To get a list of all variable names click on Create Model Info Sheet in the Stella In Excel Task Pane.