Mersenne Twister Random Number Generator Add-In



Average: 4.5 (2 votes)

Add-In Function
Source code:
Donnerstag, 18 November, 2010 - 09:01
Week: Nicht getrackt - Monat: Nicht getrackt - Jahr: Nicht getrackt - Timeline
Download extension
Windows version - All releases
Compatible with OpenOffice 4: Ja
User feedback:
Compatible with OpenOffice 4.x?

This extension provides pseud-random number generator based on Mersenne Twister algorithm which has 2^19937 -1 period, as an spreadsheet function add-in. And the generator as an UNO component is also provided.

Since Apache OpenOffice 4.0, RAND spreadsheet function uses Mersenne Twister algorithm from Boost. Therefore you do not need this extension except for the purpose for API use.

Implementation of the generator is based on Richard J. Wagner's C++ MTRand class.

How to Install

  1. Install the extension package from Tools - Extension Manager.
  2. Re-start your office.

Spreadsheet functions

Generates pseud-random number between 0 to 1 in [0,1).
This result is one of 32-bit random numbers.
Generates pseud-random integer number between Bottom to Top in [Bottom,Top].

You can specify a seed for initialization of the generator through Tools - Options - Calc - MT Random page. See help page for detail.

They can be found in the Mathematical category.

UNO component: mytools.math.MTRandom service. See here for more detail.

Original RAND function should use MT, and an issue is opened: .

Mersenne Twister Random Number Generator Add-In

Version Operating system Compatibility Release date
0.2.4 Linux 4.0 13/07/2013 - 03:23 Weitere Informationen Download
0.2.2-Linux-x86 Linux 3.4 06/12/2011 - 06:59 Weitere Informationen Download
0.2.2 Windows 3.4 06/12/2011 - 06:56 Weitere Informationen Download
0.2.1-Win32 Windows 3.4 21/11/2010 - 11:54 Weitere Informationen Download
0.2.1 Linux 3.4 21/11/2010 - 11:36 Weitere Informationen Download