Download a complete copy of this risk
analysis resource for free here.
|
See also: VoseSimCofV, VoseSimCorrelation, VoseSimCorrelationMatrix, VoseSimCVARp, VoseSimCVARx, VoseSimKurtosis, VoseSimMax, VoseSimMean, VoseSimMin, VoseSimMoments, VoseSimMSE, VoseSimPercentile, VoseSimProbability, VoseSimMeanDeviation, VoseSimSemiStdev, VoseSimSemiVariance, VoseSimSkewness, VoseSimStdev, VoseSimVariance
VoseSimTable({List of values}, ValueWhenNotSimulating)
This function returns a value from the list of input values in a sequence corresponding to the current simulation number
• 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.
Example model