SimulationValuesArray
RiskAMP Simulation Analysis Functions
Using this function in Excel:
=SimulationValuesArray(Reference Cell)
Function arguments:
| Reference Cell | Cell to use as source |
Returns all values from the simulation, as an array (1 column by n rows).
This function returns all values in the order they were observed in the simulation. Use the function SimulationValuesArray.Ordered to return results in a different order.
This is an array function. You can enter it in a range of cells using Ctrl + Shift + Enter, or you can enter it into a single cell and use Excel’s spill function.