Enhancing Excel's Random Number Generator!
 

Hi everyone:

I found this information on how to enhance Excel's RNG:

http://support.microsoft.com/default...Ben-us%3B86523

How can I take advantage of this to enhance my excel RNG?

Thanks,
Mike

Enhancing Excel's Random Number Generator!
 

Mike -

Maybe the simplest way to "enhance" Excel's random number generator is to
use Excel 2003:

http://support.microsoft.com/default...b;en-us;828795

- Mike

www.mikemiddleton.com


"Mike" wrote in message
oups.com...
Hi everyone:

I found this information on how to enhance Excel's RNG:

http://support.microsoft.com/default...Ben-us%3B86523

How can I take advantage of this to enhance my excel RNG?

Thanks,
Mike

Enhancing Excel's Random Number Generator!
 

I talks about an Excel INI file. I don't find one for Excel 2002.

However, they also say at the bottom that the default was changed from 0 to 1
in Excel 5. They probably didn't change it back. To check that, I started
Excel and typed the formula =RAND() in a cell and noted the result. Then I
closed Excel, reopened it, and repeated this. The 2nd number was NOT the same.
So it has probably already been "enhanced".

On 8 Mar 2005 13:55:48 -0800, "Mike" wrote:

Hi everyone:

I found this information on how to enhance Excel's RNG:

http://support.microsoft.com/default...Ben-us%3B86523

How can I take advantage of this to enhance my excel RNG?

Thanks,
Mike

Enhancing Excel's Random Number Generator!
 

PS: I don't find any registry setting that looks relevant.

On 8 Mar 2005 13:55:48 -0800, "Mike" wrote:

Hi everyone:

I found this information on how to enhance Excel's RNG:

http://support.microsoft.com/default...Ben-us%3B86523

How can I take advantage of this to enhance my excel RNG?

Thanks,
Mike

Enhancing Excel's Random Number Generator!
 

And if that is not good enough, you might look at the Mersenne Twister

http://www.math.sci.hiroshima-u.ac.j...at/MT/emt.html
http://www.math.sci.hiroshima-u.ac.j...S/FORTRAN/fort...
http://www-personal.engin.umich.edu/...neTwister.html

which is implemented in the freeware NtRand

http://www.numtech.com/NtRand/


Also note that the improved algorithm in 2003 only applies to the
worksheet function RAND(), not to the VBA or ATP random number generators.

http://groups.google.com/groups?selm...9.36e9afd8%40p...

implements the 2003 algorithm in VBA.

Jerry

Michael R Middleton wrote:

Mike -

Maybe the simplest way to "enhance" Excel's random number generator is to
use Excel 2003:

http://support.microsoft.com/default...b;en-us;828795

- Mike

www.mikemiddleton.com


"Mike" wrote in message
oups.com...

Hi everyone:

I found this information on how to enhance Excel's RNG:

http://support.microsoft.com/default...Ben-us%3B86523

How can I take advantage of this to enhance my excel RNG?

Thanks,
Mike