Is it possible to export all trial values from a given simulation?

I was readying through the posts and found the SimulationValuesArray command and tried it by inputting "=SimulationValuesArray(XX)" into a cell, where "XX" was the row/column of my dustribution function. Only a single number was returned.

Hi,

That's an Excel array. Excel will only display the first value, but all the values are in there. For example, try

=COUNT( SimulationValuesArray( A1 ))

However if you want single values, you can use the SimulationValue function,

=SimulationValue( A1, 1 )

where "1" is the trial number. Build a table like that (1,2,3...) and you can get all the values.

Alex Edwards
alex@riskamp.com