Forum Discussion
Random number generation
Hi everyone. I have been working on a formula that uses inputs that have been generated randomly (through RANDBETWEEN) to get to the result of this formula. Obviously, given that the inputs are random this result keeps on changing. What I would like to do is save each possible outcome of this formula (or say at least 1000 outcomes of this formula) in another spreadsheet and from that generate a graph to see the visual distribution of these results. How can I save these 1000 results??
Thanks for your help.
MS
6 Replies
on another note I was wondering why you are interested in doing this. I have some interest in random numbers for certain applications and created my own poor man's prng using worksheet functions and would love to get some outside input on how well it performs. my application is purely for non-scientific applications like building 'random' schedules or match pairings so it doesn't have to be ideal, but curious how it 'measures up'.
- you could create a small macro to copy/paste (values only) in another tab. maybe introduce a today() formula in the originating s/s and your result s/s would have a column for all dates and use a lookup of the date to update the value each time they are opened. I think you would need to open both s/s.
