Keeping track of results of refreshed/updated data

[vitaleca]

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

 

[Max]

.. I would like to refresh the data 100,000 times or so ..

Perhaps try this previous response:
http://tinyurl.com/9o66f

It illustrates how to set it up to run the iterations in a new sheet using
the Data > Table menu command/feature. To get the 100,000 iterations up at
one go, think we could try setting up 2 sheets x 50,000 rows each (untested).
Or, just set up 1 sheet x 50,000 rows and then do 2 simulation runs (just
copy n paste special as values the 50,000 rows of iterated returns into new
sheets after each run completes).

 

[Max]

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.