Knowledge base

The SimulationInterval function returns the portion of a simulation — as a percentage — that falls within some bounds.

If you omit one of the bounds, then the function will return the portion that falls above (or below) the given bound. For example,

=SimulationInterval(A1,0,1)

returns the portion of the simulation that falls within 0 and 1, inclusive.

=SimulationInterval(A1,0)

returns the portion of the simulation that is greater than or equal to zero (only the first bound is provided); and

=SimulationInterval(A1,,0)

returns the portion of the simulation that is less than or equal to zero (note the empty parameter — the comma must still be provided).

The bounds are inclusive, meaning that in the first example, it returns results in which 0 <= A1 <= 1. This has some implications for creating tables.

For continuous variables, it is very unlikely that you will have an exact value 0 or 1, so this is functionally equivalent to 0 < A1 < 1. Therefore when creating a table, you can use sets of ascending values. For example, you could create a table:

However for discrete values, you may have exact matches. In that event, you should create a table using only one parameter (minimum or maximum, depending on your application) and subtract.