Mersenne Twister Random Number Generator Add-In

×

Warning message

This extension was not updated recently. It might not work with latest versions of OpenOffice.

Primary tabs

Maintainer:
hanya
Rating:
4.5

Average: 4.5 (2 votes)

Application:
Calc
Tags:
Add-In Function
Source code:
http://hermione.s41.xrea.com/pukiwiki/index.php?plugin=attach&pcmd=open&file=MTR...
Post date:
Thursday, 18 November, 2010 - 09:01
Statistics
Week: Not tracked - Month: Not tracked - Year: Not tracked - Timeline
Download extension
Windows version - All releases
Compatible with OpenOffice 4: Yes
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

=MTRAND()
Generates pseud-random number between 0 to 1 in [0,1).
This result is one of 32-bit random numbers.
=MTRANDBETWEEN(Bottom;Top)
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: http://www.openoffice.org/issues/show_bug.cgi?id=14730 .

Mersenne Twister Random Number Generator Add-In

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