RiskSimtable

Descripción

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.

Ejemplos

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.

Reglas

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 para the extra simulations.