Loops / Dimensions

How to make your model multi-dimensional in Milliman Mind?

Written By Nikolas Ethoré (Super Administrator)

Updated at February 18th, 2022

With Milliman Mind, each cell can be easily turned into a cube and become multidimensional.

Turning cells into cubes

Example:

In this sheet, we have a list of contracts and a list of scenarios:

Cell G1

We want G1 to be a loop on contracts annuities: we write =MM_LOOP(“Contracts”, D4:D7).

Where "Contracts" is the name of the loop.

Cell H1

We want H1 to be a loop on scenarios variations: we write =MM_LOOP(“Scenarios”, C11:C13).

Where "Scenarios" is the name of the loop.

Cell I1

If we want to apply the scenarios on each contract + add a random effect, we can just write for I1: =G1+H1+RAND()

Size of cells

  • G1 has a size of 4.
  • H1 has a size of 3.
  • I1 has a size of 4*3*number of simulations

Navigate in your model

Once you have uploaded your model and launched calculations in Milliman Mind, you can easily navigate through the different loop indexes.

Accessing cubes results

To access cubes results, you can use the specific Excel functions designed for Milliman Mind.

Please take a look at the specific documentation for MM_ functions in the MM4Excel category.