Enhance Excel
owing to Milliman Mind.

Add to Excel distributions, copulas and dozens of functions to design your models for Milliman Mind.

What is MMForExcel ?

Milliman MM for Excel is a library of functions for Excel, simplifying the setup of probability models and extending the Excel range of distributions and copulas, while adding dozens of functions to design your models for Milliman Mind.

23

Distributions

MMForExcel provides an exclusive library of distributions, enabling similar coding for each of them and facilitating the switch from one distribution to another. For each distribution you can get the Probability Distribution Function, the Cumulated Distribution Function or the Inverse-Cumulated Distribution Function.

8

Copulas

MMForExcel enables you to apply copulas to any model, by simulating correlated quantiles, corresponding to selected copula parameter (e.g. correlation Matrix). Combined with the use of Inverse-Cumulated Distribution Functions, it enables to quickly design advanced probability models.

30

Exclusive Modelling functions

MMForExcel enables you to design complex models easily for Milliman Mind. With its built-in modelling functions you can create loops, cubes, and it adds own implementation of Excel functions that handles multi-dimensions of Milliman Mind.

Download MMForExcel

Key features

  • Enhancing Mind RNG technology

    This module uses the Mind XORShift random generator which is seedable. This enables to reproduce the generated numbers, which is core for a better audit trail of models, and also to setup a desired quantile, facilitating models validation.

  • IFRS17 Ready

    Integrates copulas.

    Milliman MMForExcel integrates all copulas recommended in the International Actuarial Association ED for IFRS 17.

  • Design complex models

    Milliman MMForExcel is a library of functions for Excel, simplifying the setup of probability models and extending Excel range of distributions and copulas. It enhances an exclusive Mean/Standard deviation based version of all distributions, enabling to switch easily from one distribution to another.

    It also provides exclusing modeling functions to design complex models for Milliman Mind with cubes, loops, ... Everything you need for your life and non-life models.

  • Free for Microsoft Excel

    This Library is provided for free for any use. As such no support from MILLIMAN will be provided, and MILLIMAN cannot be liable for any use you make of the system, and any of the consequences.

MM4Excel

In order to download the software, please accept the conditions of use and enter your e-mail address.

Latest update: 08/06/2020

Milliman Mind

MMForExcel powered by Milliman Mind

Milliman Mind is a flexible and easy-to-use web-based platform which automatically converts Excel spreadsheets into more powerful models with the capabilities and controls of more expensive “black-box” systems, all within a secure, auditable framework.