Locks the seed of Mind random number generator.

Syntax

=MM_RANDOMIZE(Seed)

• Seed
  Defines the random seed that initializes the random number generator.
  If Seed < 0, the random seed uses the clock to initialize the generator.
  If Seed > 1, it takes the integer part of Seed.
  If 0 ≤ Seed < 1, stochastic cells return the quantile function evaluated at the value of Seed.

Remarks

• After importing an Excel file that uses the MM_RANDOMIZE function, the seed settings in the project will be overwritten. However, you can still change it afterwards directly in Mind. See the article about stochastic models.

• It is mainly useful if you want to lock the results of functions which uses Mind generator in Excel. Note that it locks MM_RANDOM but not the Excel RAND function. In Mind, it does not matter whether you use MM_RANDOM or RAND.

Example 1: 

Formula1: =MM_RANDOMIZE(0.8)
Formula2: =RAND() returns the quantile function of a uniformly distributed random variable between 0 and 1, evaluated at 0.8, that is to say: 0.8. 

However, remember that it returns a different value in Excel. If you want it to return the quantile function, use MM_RANDOM instead.

Example 2: 

If you upload a file with a RAND function after locking the seed using MM_RANDOMIZE, results will remain the same for each simulation and after each run.