ISEE.SETDATA

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.

ISEE.SETDATA(<excel range>)

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:

  1. Setting parameters and graphicals. The basic format for this is just name, value as in:
    birth rate0.3
    average lifetime58
    Setting graphicals is similar and can include both x and y values or just y values. Arrayed variables can set multiple lines per row or column as specified in Setting Up Import Links.
  2. Setting values over time that will be use as exogenous drivers or comparison variables for calibration. These take the form:
    Time1234
    measured temperature[South]80607090
    measured temperature[North]50406070

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.