SortedSimulationIndex
RiskAMP Simulation Analysis Functions
Using this function in Excel:
=SortedSimulationIndex(Reference Cell, Value)
Function arguments:
| Reference Cell | Cell to use as source |
| Value | Index in sort order |
The SortedSimulationIndex function can be used to find values from the reference cell in sorted order.
The function returns an index value which can be passed to the
SimulationValue function to retrieve the actual value. Value
corresponds to the desired index, between 1 and the total number of trials
from the simulation.