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

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" <mas_it_2000@yahoo.com> wrote in message
news:1110318948.195550.251730@l41g2000cwc.googlegroups.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" <mas_it_2000@yahoo.com> 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" <mas_it_2000@yahoo.com> 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" <mas_it_2000@yahoo.com> wrote in message
> news:1110318948.195550.251730@l41g2000cwc.googlegroups.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
>>
>>
>
>