Skip to content

Category: Helper Functions

inject data series into simulation model

syInputRange

Introduces data series into the model as a sequence.

Syntax

syInputRange(Values, TimeNow, [PerRealization])

The syInputRange function syntax has the following arguments:

  • Values: required. Range or array with input values.
  • TimeNow: required. Reference to a cell with syClock().
  • PerRealization: optional. If True, the element respects realizations, if False or ommited the sequence follows timesteps.

Return value is one of the input values in sequence.

Remarks

During the simulation, the element takes values from Value range or array one by one. The sequence depends from timestep by default - for the first time interval the element takes the first value in range, for the second it takes the second one, etc. If PerRealization is True, the return value changes by realization.

If Values range consists of many rows and columns, it takes values by columns (first column is first, then the second, etc.). If some cells are empty, they are skipped.

Examples

  • =syInputRange({1;2;3},A1) - With syClock(5,10) the element returns a sequence 1, 2, 3, 1, 2, 3, 1, 2, 3, 1 in time intervals 1 to 10, in each realization.
  • =syInputRange({1;2;3},A1,True) - With syClock(5,10) it returns a sequence 1, 2, 3, 1, 2 in realizations 1 to 5. The return value doesn't depend from timestep, so it's not changed in simulation time.