"Standard" lists of "random" numbers

[mrblister]

Hello,

I have an excel sheet which I want to run tests on large sets of input numbers. The number sets are processed with some random inputs involved, and the outputs of the system are saved. Ideally, the best way to test the number sets is to repeatedly test the same input set many times (with new randomized each time) and then run averages on the outputs, before testing the next number set. But I only want to run a few tests on each input set. So I would like to "standardize" my list of random numbers so that I can get more consistent results with less tests.

Is there a way to generate a static random list of values? I'm looking for something more ordered/standardized than using a RAND() function or similar and then copying the static values. For example:

1. Back when I was younger, one of the programming languages I used had a random number generating function (I don't remember the language), but you needed to specify a seed value or else if would generate the same numbers each time. Is there a way to get Excel to generate an unseeded list of "random" values?
2. Is there a list somewhere of "standard" "random" unseeded values I could use?
3. Alternatively I could create my own "randomize" function, using a long string as a seed, and for example, running some sort of hash formula on it?

Other ideas are welcome. Note I would prefer to not use VBA... at that point I would rather just go with the fallback plan of generating lists of random numbers, and then "freezing" those values.

Thanks in advance!