RiskSimtable

Description

RiskSimtable({val1,val2,...,valn}) specifies a list of values that will be used sequentially in individual simulations executed during a run of simulations.  The number of simulations should be set to n (the @RISK ribbon). Then simulation 1 will use the first argument’s value from each RiskSimtable function in the model, simulation 2 will use the second argument’s value, and so on.

Examples

RiskSimtable({10,20,30,40}) should be used with the number of simulations set to 4. Then the value 10 will be used in simulation 1, 20 will be used in simulation 2, and so on.

RiskSimtable(A1:A6) should be used with the number of simulations set to 6. Then the value in cell A1 will be used in simulation 1, the value in cell A2 will be used in simulation 2, and so on.

Guidelines

Any number of arguments can be entered.

The number of simulations should ideally be set to the number of arguments in each RiskSimtable function in the model. If there are more arguments than simulations, the extra arguments will be ignored.  If there are fewer arguments than simulations, @RISK will report errors for the extra simulations.