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.
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.
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.
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.
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.
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.
In order to download the software, please accept the conditions of use and enter your e-mail address.
Latest update: 24/11/2020