ISEE.GETVALUE

When working with ISEE.GETVALUE use this function to get the value of a model variable and put it in a cell.

ISEE.GETVALUE(<variable_name>, [<time>])

The ISEE.GETVALUE function returns the value of a Stella model variable. The variable_name must be a variable name, or an expression that evaluates to a variable name with all array dimensions specified when applicable. time is the time at which to get that value. If time is omitted the value at the end of the run is returned. If time is before the beginning of the run or after the end of the simulation #VALUE! will be returned.

To get the values at different times have time reference a row or column of increasing times.

Examples:

ISEE.SETVALUE("ipopulation",20) gets the value of population at time 20.

ISEE.SETVALUE("inventory["&C3&"]",D!1!) gets the value of the element of Inventory specified in C3 at the time specified in D1. Dragging or copying this will get successive elements.

ISEE.GETVALUE("not a variable) will return #VALUE!.

Note You can use spaces or underbars in variable names.

Note To get a list of all variable names use the button on the Stella In Excel Task Pane.