RiskData

Description

RiskData(cellref or output/input name,iteration#,Sim#) returns the simulated data value(s) in iteration iteration# of simulation Sim# for cellref. RiskData can optionally be entered as an array formula, where iteration# is the iteration to be returned in the first cell in the array formula range.  The data values for each subsequent iteration will be filled into cells in the range where the array formula is entered.

Examples

RiskData(A10,1) returns the simulated data value for cell A10 from iteration #1. No Sim# argument indicates that there is a single simulation.

RiskData("Profit",100,2) returns the simulated data value for the output named “Profit” from iteration 100 of simulation 2 (of multiple simulations).

Guidelines

None.