Keeping track of results of refreshed/updated data
 

Hello.

I am using the random number generator function essentially to run
a (Monte Carlo) simulation. I calculate a result (one run) of the simulation
each time that I refresh/update the data generated by the random
number generators. The calculations take up quite a bit of room, so
just copying the calculations so that the simulation is replicated on a
worksheet or multiple worksheets is impractical. I would like to refresh the
data 100,000 times or so, but keep track of the resulting output for each
iteration.

Does anyone have an idea of how to do this?

Thank you for your time.
vitaleca

Keeping track of results of refreshed/updated data
 

Just to clarify that the "do 2 simulation runs" in the line:
.. Or, just set up 1 sheet x 50,000 rows and then do 2 simulation runs
means pressing the F9 key twice. Each press generates 50,000 iterations (it
will take awhile for this to complete). When complete, copy entire sheet
paste special values into a new sheet. Then press F9 again to run the next
50,000 iterations.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---