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

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

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

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

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