Mersenne Twister

[Tony]

I posted this in the general section, but have had no
response, so I'm trying here again - sorry if this double-
dipping is bad form or causes a problem.

Does anyone have a VBA implementation of the Mersenne
Twister pseudo random number generator. I've seen several
C versions and even a Fortran version. My C is pretty
weak and it's been a while since I did anything in
Fortran, but between the two I think I can figure
out "pseudo code" that I need. But I can't find the bit
shifting functions that the generator depends on in VBA.

Tony

 

[Tom Ogilvy]

this links to the originator's page:
Home page of Makoto Matsumaoto:
http://www.math.sci.hiroshima-u.ac.jp/~m-mat/eindex.html (English version)

which has links to this page which contains links to an xll implementation
which you can use:
http://www.math.sci.hiroshima-u.ac.jp/~m-mat/MT/VERSIONS/EXCEL/excel.html

I haven't tried it, but that is what is says.