Limit access to cells as much as possible

Milliman Mind calculation engine's speed depend on how many cells it needs to evaluate while running an excel function in a cell's formula.

When designing your model, always think about cells that are used by a function, and if possible, use the one that is the simplest.

For example, VLOOKUP() will evaluate every cells while OFFSET() will only offset to a specific cell. Time of calculation can be up to twice faster.

How to know which cells / grids are time consuming

Milliman Mind has a built in performance profiler which will give you information about grids and cells that takes to more time to calculation.

It can give you clues on how to improve your runtime.

To turn it on, click on the Settings button then turn on Performance profiler.

Then run your model. A little tachometer icon will appear above your run button, click on it.

A popup will appear and you will be able to see either the grid or the cell profiler.
Grids are displayed in % of total run time while the runtime is given for cells.