Applies to:
@RISK for Excel 4.x and Up
RISKOptimizer 1.x, 5.x

Retrieving Iteration-Level Simulation Data

 

How can I get data from all iterations of my simulation?
If you want data from all iterations of all inputs and outputs, the easiest options are:

• The Simulation Data window (the x-subscript-i icon), or

• The Simulation Data Excel report.

These tools automatically export complete iteration-level results without requiring formulas.

 

What if I want only selected variables or specific iterations?
If you want more control—such as extracting only certain inputs, outputs, or iteration ranges—you should use the RiskData( ) worksheet function.

RiskData( ) lets you retrieve the value of a specific input or output at a specific iteration (or range of iterations) and place it directly into worksheet cells.

 

Can I drag RiskData( ) formulas like normal Excel formulas?
No. RiskData( ) cannot be filled by typing the formula in one cell and dragging it across a range. Instead, it must be entered as an array formula.

 

How do I correctly enter RiskData( ) as an array formula?
Follow these steps:

1. Select the row or column range where you want the iteration values to appear.

2. In the formula bar, type a RiskData( ) formula. For example:

   • To capture the first 100 iterations of an input named The_Input:
     =RiskData("The_Input",1)

   • To capture iterations 151 through 250 of the value in cell A4:
     =RiskData(A4,151)

3. Optionally, include a third argument to specify the simulation number if you are running multiple simulations or using RISKOptimizer.

4. Instead of pressing Enter, press Ctrl+Shift+Enter to create the array formula.

Excel will automatically display curly braces { } around the formula. These braces cannot be typed manually.

 

What happens if I haven’t run a simulation yet?
If no simulation has been run, the array will display #N/A values. These will automatically update to numeric results once you run the simulation.

To see this in action, open the attached example workbook and run a simulation.

 

Related Article:

All Iterations of One Input or Output

Attachments:
RiskDataArray.xls