Applies to:
RISKOptimizer, all releases

Accessing Iteration Data with RiskData( )

 

Overview:
You can use the RiskData() function in your Excel worksheet to extract iteration data from your @RISK simulation. This allows you to reference the simulated values of an input or output in cells directly, for further calculations, reporting, or charting.

Usage:

• Enter =RiskData(OutputName, IterationNumber) in a cell.

  • OutputName – The name of the input or output variable from which you want iteration data.

  • IterationNumber – The specific iteration number you want to retrieve.

Example:
Suppose you have an output named Profit and you want the value from iteration 25:

=RiskData("Profit", 25)

This returns the simulated value of Profit for that iteration.

Additional Resources:

• For a full worked-out example, see Placing Iteration Data in Worksheet with RiskData( ), which demonstrates how to populate a range of cells with iteration data for analysis or visualization.

Tip:

• You can use RiskData() in combination with Excel functions (e.g., SUM, AVERAGE) to compute statistics directly from iteration data.

• If you reference an iteration number greater than the total number of iterations, the function returns an error.

This method makes it easy to interact with simulation results directly within your worksheet.

 

Related Articles:

Placing Iteration Data in Worksheet with RiskData( )

Exporting Information During Simulation