Simulation.Running
RiskAMP Simulation Analysis Functions
Using this function in Excel:
=Simulation.Running()
Returns TRUE if the simulation is running, or FALSE.
This function was designed to support showing a default value instead of a random number when the simulation is not running. For example, you might want to show the mean value of a Normal distribution when the simulation is not running, or the mode (most likely) value of a Triangular distribution.
Example
In this example cell F3 uses an If()
function with Simulation.Running()
.
During a simulation, this will return a sample from the PERT distribution.
Outside of a simulation, it will show the most likely value.