VoseSimTable | Vose Software


See also: VoseSimCofV, VoseSimCorrelation, VoseSimCVARp, VoseSimCVARx, VoseSimKurtosis, VoseSimMax, VoseSimMean, VoseSimMin, VoseSimMoments, VoseSimMSE, VoseSimPercentile, VoseSimProbability, VoseSimMeanDeviation, VoseSimSemiStdev, VoseSimSemiVariance,  VoseSimSkewness, VoseSimStdev, VoseSimVariance, VoseSimCorelationMatrix, VoseSimValue

VoseSimTable({List of values}, ValueWhenNotSimulating)



Example model

This function returns a value from the list of input values in a sequence corresponding to the current simulation number. It is used to rerun the same model several times, replacing a model variable with a different value for each simulation run.

List of values – a list of values entered within curly brackets {…}, a cell range (e.g. A1:A5), or an Excel range name.

ValueWhenNotSimulating – is an optional parameter specifying the value that SimTable uses when a model is not simulating. This extra control makes it easier to build a model and test how it behaves.

Note: VoseSimTable returns the first listed value when a simulation is not running unless ValueWhenNotSimulating has been provided.

How to use this function

  1. Select one or more variables for which you wish to change the value between simulation runs.

  2. Write down the list of values you wish to use.

  3. Use the VoseSimTable function in the cell of your model that represents the variable in question, and link it to the set of values you wish to use. For example, =VoseSimTable(A1:A5) if the values you want to use are in cells A1:A5. Alternatively, write the list directly within the function, for example: =VoseSimTable({1,2,3,4,5}).

  4. In the Settings | Model Settings dialog of ModelRisk change the number of simulations to match the number of values you wish to use:  

    For example, =VoseSimTable({1,2,3,4,5}) has five values and changing the number of simulations to 5 as shown above will make ModelRisk rerun the model cycling through these five values in order. Note that you will get the most direct comparison of results between simulations if each simulation uses the same sequence of random numbers, which is achieved by setting the Seed generating option to Manual, and the Multiple Simulations seeds option to All Use Same Seed, as shown above.

  5. If the number of simulations is greater than the number of values listed in VoseSimTable, ModelRisk will repeatedly cycle through the values. So, for example, if a cell contains the formula =VoseSimTable({1,2,3,4,5}) and ModelRisk is set to run 12 simulation runs, the value in that cell will change with each simulation run following the sequence 1,2,3,4,5,1,2,3,4,5,1,2.