Description

Returns the size of a specified loop (number of dimensions) or the total number of launched simulations.

Syntax

=MM_DIMSIZE("Name")

• "Name"
  String.
  Case 1: Name of the loop whose size you want to know.
  Case 2: Choose Name equal to "SIM" if you want the function to return the total number of launched simulations.

Example 1: Loops

Let us say we define two loops:

• Loop Product with the formula:
  =MM_LOOP("Product",C3:C6)

• Loop SubProduct with the formula:
  =MM_LOOP("SubProduct",D3:D8)

Thus, 

• the formula: =MM_DIMSIZE("Product") returns 4,

• the formula: =MM_DIMSIZE("SubProduct") returns 6.

Example 2: Simulations

Notice, on the example above, that the number of run simulations is equal to 20. Thus, MM_DIMSIZE("SIM") returns 20.