Mind includes a full audit trail support with unique undo functionality. Global Audit trail of changes Delete Please note that you need to have the following right to access this feature: Project Audit trail access Click on the Audit trail button in the action bar. The audit trail tracks every change in the project. It displays the user, date, id of...

What are Internal apps? We offer possibility to companies to buy a specific option called App Builder that will allow you to create your own Internal apps. Internal apps are pre-packaged Milliman Mind apps with models and settings you have selected when creating the app. You will see these apps inside your available licenses and will be able to assi...

Milliman Mind v2.1.1 was published on June 13th, 2019. Changed Dashboards improvements: You can change dimension of a grid inside a dashboard. Bugs Various bug fixes in project manager and Milliman Mind. Performance improvements. Milliman Mind v2.1.0 was published on May 29th, 2019. Added Partial evaluation of formulas We reproduced behavior of Micr...

New features & improvements IMPROVED Administration and Project manager - When exporting the user summary from the admin, include app licenses.- Possibility to keep or remove Steps and Flags audit trail entries when cloning a project. IMPROVED Input Manager - Input manager's warnings were displayed at the instance level but not at the input leve...

Description Returns a range that contains all supported copulas. The output values are the names of the copulas meant to be used in MM_SIMCOPULA function. Syntax =MM_COPULASLIST() No parameters.  Remark  Notice that the function MM_GETRANGE will automatically appear in your table. This function is used as an intermediate step by some functions from ...

From the Administration platform, click "Groups" on the left, to display all currently existing groups in your company Create a new group Then on top-right, you can use the Create new group button to generate a new Project group. You will be asked for the name of your group: You'll also have to give users access rights. You can add several users at ...

If you closed your session/browser window by mistake, your changes and calculations are not lost because they are still stored in memory for a certain amount of time: 3 minutes by default (memory is automatically flushed from the server to improve overall performance). 48 hours if the Keep session alive feature is turned on. How to retrieve a closed...

Version 5.2.5 New features & improvements IMPROVED Exports Enabled using the alphabetical order for loops in export with a new setting "Order Loop Keys" (in Export Manager and also single grid). IMPROVED Timezones Use the defined timezone for the info cell in Excel export. Other fixes Enhanced steps refresh while navigating through the workflow....

New features & improvements NEW  Excel function DATEDIF() Support of DATEDIF() Excel function. IMPROVED  Input manager Do not display identical input logs in the input manager when not relevant. Other fixes Fix to prevent bad behavior when overriding a formula with a URL string. Fix the manual match of the input manager screen that could display...

Description Returns the cumulative distribution function of a truncated distribution evaluated at a specified value. Via distribution parameters. Syntax =MM_CDF_TRUNC("DistName", X, Param1, Param2, Param3, LowerBound, UpperBound) "DistName" String. Name of the desired distribution.  X The value at which the truncated cumulative distribution function...

Description Returns the cumulative distribution function of a distribution evaluated at a specified value. Via mean and standard deviation. Syntax =MM_CDF_MS("DistName", X, Mean, [StdDev], [Param3]) "DistName" String. Name of the desired distribution.  X The value at which the cumulative distribution function is evaluated.  Mean Mean of the desired ...

Description Returns normal value of input AOC cell in case of TRUE as second parameter, or stretched values in case of FALSE as second parameter. In Excel, it returns the default value of the cell. Syntax =MM_AOCVALUE(Cell, ValueType) Cell Cell from a /AOC table whose value you want to output. ValueType  Boolean to specify which type of value to ret...

Version 6.0.5 Other changes Made it possible to use the "partial save" option in HPC runs with the /AlwaysSave flag added via the Flag Manager. (#6654) Renamed "Multicore strategy" setting into "Multi-thread strategy". (#6797) Corrected display of some labels in the Interlinks Manager. (#6975) Improved display of loop indexes in classic and workflow...

Description Returns a matrix of quantiles generated by a given copula. Describes the dependence structure between random variables.  Syntax =MM_SIMCOPULA("CopulaName", NbCop, CorrelationMatrix, [CopulaParameter]) CopulaName String. Name of the copula you want to simulate. See the MM_COPULASLIST function to check the list of all supported copulas.  N...

Version 5.2.2 New features & improvements IMPROVED XBRL Manager Improvement of the XBRL Manager feature. Other fixes Correct and stabilize the merge of the audit trail entries process. Fixed a bug that made loop labels disappear at reload. Fixed a bug that led to a loss of data validation when exporting the updated Excel models. Disabled backup ...

Milliman Mind 6.0.0 is Here, featuring a completely redesigned Projects window to make your experience smoother, more intuitive, and more efficient. It also introduces the Milliman Mind High-Performance Computing (HPC) feature, changing the way you run heavy models. With HPC, you can execute heavy models in a fraction of the original time required i...

Version 6.1.9 Changes Improved the exported Audit Trail of runs. (#7377) Fixed a regression where long HPC runs were stuck at a certain point and could not finish. (#7475) Reduced the RAM during reload after input import. (#7459) Fixed an issue where the EOMONTH, DATE, and TIME functions prevented the model from being uploaded when using NaN as a pa...

Description Returns the index of the selected instance in a table. Syntax =MM_INSTINDEX() No parameters. Remark See MM_DIMINDEX function‍ the equivalent function for loops. Example 1: Basic example Instances have to be added beforehand. To learn more about instances, check Introduction to instances‍.  Do not forget to run the model after adding inst...

Version 6.3.1 Changes Improved the speed of the Input Manager display (#7862) Reduced the project duplication time according to the number of threads in the plan (#7790) Improved the ISERROR system to not always propagate the error status in a context of sum (#7859) Enabled to use the MATCH function on a range of size equals to 1 (#7858) Resolved a ...

Description Returns the name of one of the parameters of a specified probability distribution. Syntax =MM_PARAMNAME("DistName", ParamNumber) "Distname" String. Name of the probability distribution.  ParamNumber Index of the distribution parameter whose name you wish to return. The value must be an integer from 1 to the total number of parameters for...

Workspaces are the new name of what was previously called Project Groups. To edit the available workspaces in your company, click on the “Workspaces” item in the left menu.You will access the list of all your existing workspaces. Create a new workspace Click the “Add Workspace +” blue button to create a workspace. You will then need to give it a nam...

To create a drop-down list in Mind, you simply need to create them in Excel and they will be automatically imported during the upload of your model. Plus, it is possible to have a dynamic drop-down list, i.e. drop-down list with a list that can vary in size and in values. Create simple drop-down lists To create a simple drop-down list in Excel with ...

Application new features New interface Milliman Mind v3 introduces new interface with both functional and design changes. This redesign aims at helping small screens use and improving productivity for users. Switch between left and top action bars. From now on, you will find : On the left bar : Actions. It is what was earlier on the top bar, with ac...

New features & improvements NEW   Tags of projects in the manager New feature to tag projects within the Project manager. You can easily add one or several tags to your projects, and they will be displayed in the project boxes of the manager. Moreover, you can filter by tags using the search field by typing "tags:MyTag" for example. NEW   Export...

The grid backup feature enables you to transfer the full content of a set of grids, from a source to a target inside the same project, after the final user clicks on a button defined by the model designer. Setup /BackupSource and /BackupDest flags Put /Backupsource.(backup name) flag on the title cell of your source grid (the one that will get its v...

A feature is implemented to prevent two projects from having the same name within the same workspace. This will prevent the creation/rename of a project with the name of another project, but won't change projects with the same name before activating the feature. Turn on the feature Open the Administration panel (with Administrator right), navigate t...

When an Excel file is uploaded to Milliman Mind, all cells are scanned by the engine and organized in grids in accordance with their arrangements in Excel. The structure of your Excel model will define the navigation menu in Milliman Mind which provides 3 levels: Grids, Sheets, and Workbooks. Grids Sheets are read by Milliman Mind from left to right...

To access the monitoring panel as a non-administrator user, change the current environment and select “Milliman Mind Monitoring” on the menu. This window will summarize each of the sessions opened by the current user for the selected environment (#DEMO on the screenshot). For each session, you will get the following information: The start date (and ...

Instances consist in duplicating Excel workbooks in order to add another dimension to your workbook whereas loops give you the possibility to add dimensions to your cells. We call instances of a workbook several versions of a workbook. Moreover, you can handle calculations between instances of different workbooks. For complex models that need multip...

Please note that you need to have the following right to access this feature: Project Grid export Export the content of a grid to CSV / Text / Excel format. Select a grid to display in the left navigation pane. On the top right of the window, click on the Download grid icon to open the Export CSV/Text/Excel Data popup. You can then select if you wan...

Info This version has been initially released on February 25th, 2022. New features & improvements Various interlinks improvements Global optimization of interlinks features to improve performance and reduce required storage size. Add tooltip on the loops button to display loop choices. Add possibility to link headers. Add possibility to flatten ...

Switch between the product's main features After logging into Milliman Mind, you will access the Project Manager window to open, create, or manage the projects of the current environment. But, depending on your personal access rights, you may have access to other features: The monitoring panel: as a non-administrator user, you will be able to see yo...

Please note that you need to have the following right to access this feature: Project Settings access / Project Settings edition To enable Live Mode, click on the settings button of the action bar. Then turn on the switch button of the Live mode section. Do the inverse steps to turn it off. When Live Mode is enabled, Mind launches a run of simulatio...

Delete Please note that you need to have the following right to access this feature: Project edition Assumptions in your grids are flagged by their blue color. These assumptions can be edited by different ways that will be explained later in this article. Manual entry You can edit an assumption by clicking on a blue cell, and just use your keyboard ...

Description Binds ranges horizontally. Creates a new range by putting together ranges side-by-side. Syntax =MM_VUNION(RangeOutput, [RangeOutput2], [RangeOutput3]) RangeOutput First range you want to bind. RangeOutput2 (optional)Second range you want to bind. RangeOutput2 must have at least the same number of rows as RangeOutput.  RangeOutput3 (optio...

Important update This version fixes a blocking navigation issue introduced in the software by the latest versions of Edge and Chrome (Version 109+), released mid-January 2023.We recommend each client update their server to this version as soon as possible, to prevent any problems when they update their browser. Please contact support.mind@milliman.c...

Description The two functions return a table joining two ranges according to matching keys. If a key from a range is not matching with a key from the other range, the line to join will not be displayed. Syntax =MM_LEFTINNERJOIN(Key1, Output1, Key2, Output2) Key1: First range key Output1: First range Key2: Second range key Output2: Second range to jo...

Version 5.0.3 New features & improvements NEW New name for default Profile names Mind default profile names have been renamed: Reader becomes Reader, User becomes Runner, and Creator becomes Designer. IMPROVED Workflow mode order of loops It is possible to freeze the order of loops in workflow mode directly with the Step labels in the /Steplabel...

Improved features Teamwork merge of projects When you save a project while another user is using it, this user will be notified and will have possibility to retrieve your newest changes by merging both version. Load of projects without results When a project cannot load results it will still load but notify the user that results are not loaded. Live...

Version 6.1.2 NEW Real-time information about connected users on a project A new feature will retrieve and display info about connected users on the same project/scope directly in the project. Other changes Fixed an error related to consistency when undoing a backup in multiusers. (#7223) Renamed the run status "cancel" to "cancelled". (#7166) Set t...

Milliman Mind v2.2.0 was published on June 20th, 2019. Changed New version of Charts module Please note that the new charts feature is a complete rewrite of charting in Mind to make it much better. So you will have to recreate your graphs to benefit from these extended capacities. We introduce with this version a new chart feature based on a new pow...

To access the flag manager, first, click on the Edit project button on the left action bar. Then select the "Manage Flags" tab on the opened modal.This will give you access to the flag manager. First select the type of flag you want to apply: You will see the full list of your project grids, sorted by models and sheets.Click on the arrow next to a m...

Mind allows you to browse through your model easily and access all results you want in just some clicks. Display Grids Mind engine has reorganized your Excel files in a neat object model which you can browse through easily. You will find in the top navigation bar all your uploaded models: Click on one of it and a navigation area with all your sheets...

Create a workflow mode display Your browser does not support HTML5 video. Assign a grid to a step In Milliman Mind To assign one or many grids to a step in Milliman Mind, click on the Manage flags tab, then choose Steps flags from the selector. You only have to select which grid you want to assign to each step, then click on the Save flags button in...

New features New instances behavior Instances are no longer created directly in Milliman Mind but must be added to an uploaded Excel model with a /Instancekeys grid which will have Model names as headers. Documentation available soon... Add description to table for workflow mode: You can add a description to grids in workflow mode by simply adding a...

Milliman Mind provides a feature to use in combination with /InstanceSelect to load, run and save the full scope of your project, but without loading it all at once. All the processes will be launched group by group, with 2/4/6/8 groups in parallel depending on your company plan. Use the feature First, open your project in partial load mode. When yo...

v.1.9.4 Milliman Mind v1.9.4 was published on May 6th, 2019. ADDED New Milliman Mind resizing functions in Beta:MM_SETSIZEMM_VUNIONMM_HUNIONMM_FILTERMM_REMOVEDUPLICATES Please look at MMforExcel documentation for more information. BUG FIXES Various bug fixes. v.1.9.3 Milliman Mind v1.9.3 was published on April 9th, 2019. CHANGED Instances now suppor...

Description Returns the probability density function of a distribution evaluated at a specified value. Via distribution parameters.  Syntax =MM_PDF("DistName", X, Param1, [Param2], [Param3]) "DistName" String. Name of the desired distribution.  X The value at which the probability density function is evaluated.  Param1 First parameter of the distrib...

Improved features Improved Excel 365 compatibility Improved bubble chart and map bubble chart New rights for role management We add several roles to refine rights management in Milliman Mind. Import improvements TXT files, and CSV with or without headers are now supported. Culture selection You can choose which culture you want to use for Date and n...

IP restrictions You can restrict access to Milliman Mind only to specific IPs. To do so, go to "Settings" > “Security Settings” and turn on the IP restrictions feature. You will need at least to add your own IP to not block your administration access; then, you can add as many IPs to the whitelist as you want while selecting if this whitelisting ...

Please note that you need to have the following right to access this feature: Project run The partial run feature allows launching calculations only for one grid (and its dependant grids). Define the number of simulations you want in the action bar for stochastic models. Click on the Partial run button on the top right of your grid. Progress will be...

What are indicators? Indicators are available for each stochastic table in Mind and provide, in addition of the selected dimension values and observed mean / standard deviation, some indicators : it can be the tail value at risk (TVaR), the Value at risk (VaR) or the probability of ruin (PoR). Set up indicators Please note that you need to have the ...

Description Locks the seed of Mind random number generator. Syntax =MM_RANDOMIZE(Seed) Seed Defines the random seed that initializes the random number generator. If Seed < 0, the random seed uses the clock to initialize the generator. If Seed > 1, it takes the integer part of Seed. If 0 ≤ Seed < 1, stochastic cells return the quantile funct...

Description Returns the probability density function of a distribution evaluated at a specified value. Via mean and standard deviation. Syntax =MM_PDF_MS("DistName", X, Mean, [StdDev], [Param3]) "DistName" String. Name of the desired distribution.  X The value at which the probability density function is evaluated.  Mean Mean of the desired distribu...

Version 6.2.1 Changes Corrected the behavior of the “run only one simulation” button after a run with this option enabled. (#7571) Enabled export of uploaded inputs only. (#7495) Improved the display of run warnings in the Audit trail of run. (#7481) Introduced the Audit trail of save, which displays the list of saves performed in the project. (#717...

Mind offers you the ability to display Taylor-made charts, adapted to the exclusive Mind stochastic feature. Create and display a chart Open the chart panel Click on the Charts menu on the right of the top navigation bar, then click on "Create new chart" button.  This will open the chart manager on top of your opened tables. Charts are sorted into s...

How to display the formula field? To display the formula field, you must be in Classic mode. Then simply open a grid, and click on the cell with the formula you want to display: The formula, in Mind format, will appear on the top of your grid. By default, only the first line will appear; to display the full formula you can hover the formula with you...

By default Milliman Mind will automatically detect if your model is stochastic and turn on stochastic calculations. You can change this setting in the Settings popup: Then look at the Stochastic Run setting. You can also choose to lock the seed, then select if you want to run every simulation or only one. If you lock the seed, you can choose a speci...

Version 6.2.4 Changes Prevented the upload of projects where there are several dynamic reference grids with the same resize flag. (#7577) Reduced significantly the import time of big .csv files. (#7615) Enabled to duplicate projects and folders in another workspace. (#7613) Reduced the time of launching HPC runs when there are a lot of tasks. (#7594...

Milliman Mind 3.12.8 New features Combined charts New feature to combine two types of charts into the same plot.See specific chart documentation for more information Input Settings Possibility to create a matching table to automatically match input grids with a file that doesn't have the same name. Load/Run/Save by instance group automated feature I...

Description MM_GROUPBY function groups all values based on keys and and applies a grouping function (SUM, AVG, MIN, MAX). Syntax =MM_GROUPBY(Keys, Values, Type, Name, Index) Keys Keys range based on which we perform grouping. Values Values range that we group based on grouping type. Type String. Type of grouping (SUM, AVG, MIN, MAX) for values. Defa...

You can easily edit a project's start/end date, name, and status directly inside the project manager. To open the edition panel, right-click on your project box or click on the three dots on the right of your project to flip the tile, then click on the edit button. A popup window will appear: change name of the project and/or start/end date. Then cl...

By default, you will be redirected to the “Environments” panel when you open the administration panel. This panel is also accessible by clicking on “Subscription” > “Environments”. The Environments panel The environments panel will list all the available environments/servers for your company and the workspaces assigned to each server. First, you ...

Version 5.1.3 New features & improvements NEW Supported Excel functions Mind now supports: SORT(), LET(), FILTER(), TOCOL(), TOROW().Improves the behavior of the IFERROR function with an array formula. IMPROVED Interlinks2 Displays the instance name when the interlink status is warning due to different column headers. Other fixes This avoids cre...

Milliman Mind offers a complete set of settings to customize your experience within a project. Most of the settings are project-specific, meaning they will be applied only for this project but for any user opening it. Another possibility does exist to pre-set all the settings of a project within the Excel source file. To do so, look at this article:...

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 ...

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. What does it bring? 23 Distributions MMForExcel provides an exclusive library of distributions,...

Description Searches for a specified item in the dimensions of a cell and returns the index of the dimension where the item is found. Syntax =MM_MATCH(Value, Valuecomp, Type) Value The value that you want to match in the list of values of Valuecomp. Valuecomp Cell. The list of values of a dimensional cell that is being searched. Type (optional) Type...

Analysis of Change (AoC) enables to measure impacts of two different subsets of inputs on the variation of the result from their evaluation. Analysis of Sensitivities (AoS) is used as a standard loop in Mind. This analysis performs many time the calculations with each time applying a shock to a different set of variables. Both functionalities work w...

What does it do? Update models feature allows you, by uploading the full set of files (not only the one that has changed), to preserve: Audit trail entries Backups Assumption manager changes Charts Steps Dashboards Settings of the project A conflict resolver window will guide you through the process, to match your previous audit trail entries with t...

Description Returns the average of values of all dimensions or specified dimensions of a range that meet a chosen set of criteria. Syntax =MM_AVERAGEIFS(Average_value, Range1, Condition1, [Range2, Condition2], [Range3, Condition3], ["Name", Index], ["Name2", "Index2"], ...) Average_value Cells to average if the given set of criteria is met. Range1 R...

The first page you reach when accessing the administration panel is a dashboard giving a quick overview of your licenses, groups and tools. Active licenses You will find a list of your active licenses with their expiration date, type, and the number of available licenses. If you click on it you will be redirected to the specific license page. Projec...

Please note that you need to have the following right to access this feature: Project Settings access / Project Settings edition Enabling scrolling By default Milliman Mind cut grids and use pagination to navigate. To display every elements of the grids you can choose to display sliders instead of pagination. To change click on the Settings button o...

Description Removes duplicates from the key range and filters the output ranges accordingly. Syntax =MM_REMOVEDUPLICATES(Key, Output1, [Output2], [Output3]) Key Range from which to remove duplicates. Key must have only one column. Output1 First range to return and filter according to Key. Output1 can have several columns but must have at least the n...

To get real-time information about the CPU use percentage and the memory use of your project, simply hover the name of your project on the top left corner of the screen. This will display a black tooltip providing this useful information....

Description MM_GOALSEEK enables a specified cell to reach a target value by adjusting the value of the cell which contains the MM_GOALSEEK function. Instead of using an explicit formula, the function uses root-finding algorithms. Syntax =MM_GOALSEEK(GoalCell, GoalValue, [Tolerance], [Depth], ["MethodType"], [Min], [Max], [InitialValue, [StopConditio...

Version 6.2.6 Changes Optimized the display of groups of grids and of workflow mode. (#7712) Kept the results displayed in case of up-to consistency when an input entry is undone in the Input Manager. (#7692) Restricted the log to 1000 errors and displayed the total number of errors in the input control warnings. (#7627) Corrected the display of pro...

V 1.10.34 : Published 06/09/2022 MM_SORTRANGES now sorts in Excel as it does in Mind V 1.10.33 : Published 02/09/2022 New functions : MM_VLOOKUPOPTIMIZED, MM_HLOOKUPOPTIMIZED, MM_MATCHOPTIMIZED  V 1.10.30 : Published 26/08/2022 New function: MM_RANDOMSAMPLE MM_FILTER was not working in Excel as in Mind when the result had no rows V 1.10.26 : Publish...

Description Returns the index of the last row of a grid from one of its cells. In Excel, it returns the index of the row of the first empty cell minus 1, starting from the specified cell. Used for dynamic tables. Syntax =MM_LASTROW(Cell) Cell Any cell inside the grid from which you want to get the index of the last row. Remarks Warning: This formula...

The batch feature allows you to run multiple times in a row your models. Designing Excel model If you want to access to current batch index in your Excel formulas use MM_BATCHINDEX function (MM_BATCHINDEX function‍) If a table should keep results from each batch that has run add the flag /BatchResult to the grid name. Setup batch run First, click on...

Description Returns the index of the selected BATCH in Mind settings. MM_BATCHINDEX function is used in conjunction with the header /batchresult to create a loop named BATCH for the tables labeled with /batchresult. The difference with MM_LOOP is that you can choose which scenarios to run (instead of all) and for which tables you want to save all di...

Please note that you need to have the following right to access this feature: Project Grid import You can easily change a whole input grid by importing a CSV file: simply click on the Import CSV icon on the top right of the Grid. Warning Your grids that have to be resized with CSV import must be flagged. Please follow the Model design guide for more...

Description Returns the value of a multidimensional cell for specified loop dimensions. Sums dimensions for unspecified loops. Syntax =MM_RESULT(Cell, ["Name", Index], ["Name2", Index2], ...)  Cell Cell that contains the results you want to access.  "Name", Index (optional)String, Integer.Name and dimension index of the first loop whose results you ...

Please note that you need to have the following right to access this feature: Project Saving Save results and assumptions (and formatting, copulas, charts, ...) you entered by clicking the save button of the action bar. It will display a progress bar while the data is saved inside the server's disks. By default, Mind saves the result of a run. But i...

Description MM_SORTDIM enables us to sort the numerical values of the dimension of the target cell. This function is similar to MM_SORT function (deprecated)‍ . Syntax =MM_SORTDIM(Obj,SortingOrderObj,[Name1,Index1],[Name2,Index2],..) Obj: The cell on which you want to perform the sorting of dimension values. SortingOrderObj: Sorting order. True= asc...

Version 6.1.5 Other changes Fixed an upload error triggered by the use of the LET function with brackets in a specific case. (#7314) Improved handling of named ranges when referenced from external workbooks. (#2183) Fixed an issue that prevented the conflict resolver from being applied to an update model. (#7322) Optimized RAM usage for HPC loop whe...

Description Resizes and populates the table in which the function is contained to fit a specified grid. Useful to replace an array formula whose size varies depending on some parameters (you do not need to define beforehand an array formula that fits the result of your function).  Syntax =MM_RANGE(VirtualGrid) VirtualGrid The grid used to resize and...

Description Returns the inverse cumulative distribution function or quantile function of a distribution evaluated at a specified value. Via distribution parameters.  Syntax =MM_InvCDF("DistName", X, Param1, [Param2], [Param3]) "DistName" String. Name of the desired distribution.  X The value at which the inverse cumulative distribution function is e...

New features & improvements NEW  Results Consistency Milliman Mind provides real-time information about the consistency of the results produced by the latest run with the current state of your project. Related article:  Result consistency‍  NEW   New functions MM_VLOOKUPOPTIMIZED and MM_HLOOKUPOPTIMIZED These two functions use high-performance o...

Version 5.2.1 Other fixes Corrects the behavior of the MM_SORTRANGE function when resizing. Fixes specific front errors such as "error parsing formula" in the formula bar. Fixes a behavior that created multiple wrong audit trail entries when launching a backup after merging inconsistent changes. Corrects the behavior of the function MM_INSTANCEUNION...

Version 5.1.5 New features & improvements IMPROVED XBRL New IR- taxonomies for XBRL manager. Other fixes Fixed the status of a run launched with the functionality "run per group of instances" when some instances returned warnings. Fixed a run error related to interlinks data that could create overlap issues when reloading the project. Optimized ...

Description Creates a new table by concatenating all instances of a table. Syntax =MM_INSTANCEUNION(Cell, isHorizontalUnion) Cell First cell of the table you want to return. The table returned is defined by this cell, meaning it will start at the cell and end at the end of the table which contains that cell. isHorizontalUnion Boolean that determines...

Support channels We provide users various channels to get in touch with Milliman Mind support team: Built-in chat Mail Phone (unavailable during COVID period) Built-in chat Start a conversation You can start a conversation through the chat at any moment (even before login) by clicking on the blue chat button on the bottom-right corner of the screen....

New features AOC / AOS New Analysis of Changes / Analysis of Sensitivities feature.Documentation will be updated soon with more information. Improved features Flag manager The response time of the flag manager has been improved while adding some search and filtering features. Copy / Paste formulas Improved feature of copy-paste of formula to right/b...

Description Returns the cell in the same column as the specified cell and in the last row of the corresponding table. Used for dynamic tables. Syntax =MM_LASTROWCELL(Cell) Cell Cell that defines the table and the column for the output. Remarks Warning: This formula has a different behavior in Excel and in Mind. See the first example. This function i...

In order to ensure backward compatibility, the character "@" is equivalent to function SINGLE() in the new version of Excel (Office 365). Excel releases recently the dynamic array functionality. This functionality enables users to display arrays for any formula supposed to return arrays (like the MM_RANGE function‍). For example, the formula "=A2:B5...

Description Returns the probability density function of a truncated distribution evaluated at a specified value. Via distribution parameters. Syntax =MM_PDF_TRUNC("DistName", X, Param1, Param2, Param3, LowerBound, UpperBound) "DistName" String. Name of the desired distribution.  X The value at which the truncated probability density function is eval...

Create a new project Pre-requisite To create a new project, you must have specific rights: If you create a Platform empty project, you must have at least a Creator level license and the Project Creation right assigned. If you create an App-based project, you must have a license for this specific app. Have Read/Write rights on this workspace.   Creat...

Version 5.0.4 New features & improvements NEW Supported Excel functions Mind now supports: IFNA() IMPROVED AOC/AOS Added functionality to export the AOC grid from the input manager or from the single export functionality. IMPROVED Loading time Improvement of the loading time of projects with an important amount of results. Other fixes Fixed an i...

Milliman Mind will convert your Excel files into C# objects during an import, and all your models/spreadsheets/grids will be included in this new Milliman Mind structure. Cells format Cells format are kept during an import if they are included in this list: Standard Number (with support of defined decimal digits) Text Boolean Date Data validations (...

This article deals with the implementation of the parameter editor. Read Parameter editor‍ for a quick introduction to the parameter editor. To set up parameters for your model, you can use the flag /Parameters inside your grid name. Your grids must have the following structure: The columns have the following role: Label The label of your parameter ...

Version 5.1.1 New features & improvements NEW Supported Excel functions Mind now supports: WRAPCOLS(), WRAPROWS(), CHOOSEROWS(), CHOOSECOLS(), XMATCH(), PERCENTILE.INC(), PERCENTILE.EXC(), QUARTILE.INC() and QUARTILE.EXC(). NEW Sub-folders in Milliman Mind Project Manager Mind now supports the creation of subfolders for the project manager. Up t...

If you are turning off your computer, we highly recommend you log out of your account. This will prevent unauthorized accounts from your projects but will also allow you to access your account securely on another computer or tablet/smartphone. How to log out? Close every window of Milliman Mind, then back on the project manager, click on the log-out...

If you are an AppBuilder, you can access the list of all your created applications by Collection by clicking on the “Applications” item on the left menu. From this screen, you can edit each application's information or delete it, but you can no longer create new versions or apps directly from this screen.To To do so, you must go through the Project ...

Description This function checks if a chosen current value is in an instance loaded in the current model in Mind. Syntax =MM_ISINSTANCELOADED(Cell, InstanceKey) Cell : Cell containing the value you want to check if it's in an instance loaded in the current model. Cell is not meant to be a range bigger than a cell. InstanceKey: Name of the instance y...

This feature allows you to create a dashboard of selected tables and charts that can be displayed automatically at project launch. Create a dashboard and assign a chart/grid To create your first dashboard, click on the Pin to dashboard icon on the top right corner of your grid/chart. Then click on Create a new dashboard, give it a name, select it an...

To build a model with AOC/AOS, see Analysis of Sensitivities (AOS) and Analysis of Change (AOC)‍  Instead of calling every AOC grid in the AOC order grid, you can gather AOC grids into groups and call those groups instead of in your AoC Order grid. Grids dependent on /AOC tables from the same group will have the same behavior regarding AOC functiona...

Milliman Mind administration allows you to create custom profiles for your users. To access this panel go to “Accounts” > “Profiles”. By default, three profiles (for each kind of license) exist and cannot be deleted. These sets of actions define what a user can do or not do in Milliman Mind. Create a new custom profile To create a new custom prof...

Description Returns the rank of the sorted values of the dimensions of a specified cell. Syntax =MM_RANK(Cell, SortingOrder, [Name, Index], [Name2, Index2], ...) Cell Multidimensional cell which contains the values for which you want to return the rank. SortingOrder Boolean which determines the sort order.Case 1: TRUE for ascending order.Case 2: FAL...

What is a custom formula for? As Milliman Mind converts your excel file in a C# object-oriented model, you will need to rewrite your VBA functions which are not compatible with Mind. If your VBA functions are designed to add a stochastic dimension to your model, Mind will handle this dimension natively. But if you are doing any other work in Visual ...

Version 5.0.2 New features & improvements NEW FAC (.fac) export Adds a new ".fac" export option in the export manager and single export grid. IMPROVED IP Restrictions IP Restrictions now support network submasks. IMPROVED Display of cells Cell selection now distinguishes cells with formula (orange selector) and cells with assumptions (blue selec...

Hyperlink between cells This feature aims to turn a classic cell in Milliman Mind into a clickable hyperlink that will highlight a cell in the same grid or in another grid of your model.  Create a link with the MM_HYPERLINK function To create a link with MM_HYPERLINK, you must add +MM_HYPERLINK(MyCell) to the end of your cell formula: The MM_HYPERLI...

Classic behavior By default, when you import a set of CSV files in the Input Manager, the system will automatically match the CSV with grids that have the same name. You can find the expected Input name by hovering this icon on your input manager: /InputSettings grid behavior In order to manage better file matching during import, you have the possib...

If you have designed a grid in Excel with the flag /Parameters in the grid name, this grid won't display as a spreadsheet but as a parameter editor. Please follow the Setup parameters editor‍ for more information for implementing the parameter editor. Just answer the questions set up in Excel and click on Save parameters to save the results just as ...

Version 6.1.8 Other changes Improved the exported Audit Trail of run. (#7377) Reduced the time of input import. (#7412) Fixed a rare problem with grouped columns when only the last column is grouped and it is /HideRows. (#7424) Enhanced the update model control on previously imported input files in the case of grid resize. (#7416) Improved export of...

When you are using the workflow mode, you can define grids that belong to each step with a /Step flag and then define the steps name in the Flag manager. The most recent version of Milliman Mind introduces the possibility to define steps labels directly in the model / Excel file to save time and directly get your workflow mode ready to use. Define t...

A new feature has been implemented to prevent two projects to have the same name within a Project group. This will prevent the creation/rename of a project with the name of another project, but won't change projects that had the same name before activating the feature. Check if your server supports this feature and activate it Open Administration pa...

Deprecated Feature The Interlinks feature has been deprecated with version 4.5.3 and replaced by Interlinks V2 (see Interlink Manager v2‍).Migration will be done automatically at the first load of the projects. You can link two or more distinct projects easily in Milliman Mind. For example, if you have one/several grid(s) that gathers the results in...

Informative dates For informative dates such as :  Audit trail of changes entries Audit trail of runs entries Model manager dates Milliman Mind is automatically matching the timezone of the user's browser. Calculated dates Calculated dates using NOW(), TODAY() or MM_LASTCHANGEDDATE(Cell) can be set on a specific timezone within the project settings;...

Description Returns the inverse cumulative distribution function or quantile function of a truncated distribution evaluated at a specified value. Via mean and standard deviation. Syntax =MM_InvCDF_MS_TRUNC("DistName", X, Mean, StdDev, Param3, LowerBound, UpperBound) "DistName" String. Name of the distribution you want to simulate.  X The value at wh...

Resizing of models with CSV import To optimize resize time of models while importing CSV, you should add some parameters to your grids. Grids with the same number of cells To define that two grids have the same number of rows while resizing add a  /ResizeRow or  /Resize to the grid name.To define that two grids have the same number of columns while ...

Navigation through formulas When you click on a cell that is not an assumption, the converted formula in Mind format is displayed below the grid. Another way to navigate through dependencies of cell is simply to click on the cell that appears in the formula, when you highlight a cell in a grid. Just hold Shift then click on this link and the corresp...

Description This function returns the date of the last project change in Mind. Syntax =MM_LASTCHANGEDDATE(Cell) Cell: Cell for which to return the date of your last change on your Mind project. Remarks You cannot select the cell in which you write the formula as parameter of this function (because it produces circular references). This function does...

Milliman Mind capabilities can be extended easily with custom-made C# formulas or indicators. What are Custom C# formulas? As Milliman Mind converts your Excel file to a C# object-oriented model, you will need to rewrite your VBA functions, which are not compatible with Mind. If your VBA functions are designed to add a stochastic dimension to your m...

New features & improvements IMPROVED Run Warnings - Specific warning for conditional loops will only be displayed in debug mode IMPROVED Results consistency - New specific consistency behavior for a partial run (grid, group, or workflow step). Other fixes Fix a bug that could lead to a run error in very specific cases after an export set in a cu...

New features & improvements IMPROVED Performance improvements - A new format for interlinks improves the performance of load and run in projects with Interlinks2 big amount of data. Other fixes Solves an issue of the wrong size of merged cell in Milliman Mind. Enhancing interlinks behavior with empty grids. Fixing a rare interlinks issue during ...

Your browser does not support HTML5 video. Setup of grids to export and their settings Export flag To add a grid to the list of grids to export, you must add a flag /Export to this grid. By adding this flag, you will give information to Milliman Mind that it must be added to the Export Manager. A new button Export manager will then appear on the act...

To access the administration panel, you must have been granted access to it by another administrator or by Milliman Mind team. Access the Administration panel First login to the project manager with your administrator account. Click on your name and email on the top right corner to display a dropdown list, then click on Administration. This will ope...

Description Equivalent of SUMIFS Excel function. Returns the sum of values of all dimensions or specified dimensions of a range that meet a chosen set of criteria. Syntax =MM_SUMIFS(Sum_value, Range1, Condition1, [Range2, Condition2], [Range3, Condition3], ["Name", Index], ["Name2", Index2], ...) Sum_value Cells to sum if the given set of criteria i...

New features & improvements NEW XBRL Manager v2 The new version of the XBRL Manager (for specific clients). NEW Iterations and MM_ITERATIONS function A new feature to sequentially launch subsets of a Milliman Mind project potentially several times for a given subset. Please refer to the specific documentation for more information (Coming soon). ...

Upcoming release This version is available on updated servers from Friday, June 10th 2022. New features & improvements NEW  Project settings grid The settings for a project can be defined directly within the Excel file, with a specific /ProjectSettings grid. This grid can be updated later through the interface or a model update.You can also choo...

Delete Please note that you need to have the following right to access this feature: Project edition Add a distribution to a cell by right-clicking on an assumption, then click on Edit distribution settings. Then turn on the switch Enable distribution. You can then choose which distribution you want to apply. If you want to use parameters or Mean/St...

If you do not get basic knowledge on instances, you can learn more on: Introduction to instances‍  Sometimes, for complex models with lots of instances in each workbook, calculations can take time. One of the solutions to improve calculation time is to regroup instances with the flag /InstanceSelect. By regrouping instances into groups, you will be ...

New features & improvements NEW New MM_ functions New MM_SIMQUANTILE function that returns the quantile instead of the index. IMPROVED Audit trail of Runs Improve the audit trail of runs to keep the warning/error logs in the Logs panel and the export CSV. IMPROVED Interlinks V2 Global improvement and fixes of the new Interlink version introduced...

New features & improvements IMPROVED Run Consistency New Results Consistency summary in the audit trail to get a global overview of multiple instances' project consistency status in a single screen.Rewriting of the consistency internal system for better reliability. IMPROVED Interlinks V2 Various improvements on Tags override in Interlinks2.Limi...

New features & improvements NEW Interlink Manager V2 This version introduces the new Interlink system with the new manager window.It offers better performance and more possibilities to retrieve data from one or several source projects. Migration of all your existing projects will be performed during the publication of the version, then at the op...

New features & improvements NEW   New MM_CHECKLEI function New MM_CHECKLEI function that will check if an LEI code is valid. IMPROVED  Export dates as a formatted string in CSV/TXT New feature allowing to export of CSV/TXT files with dates displayed in date format instead of Excel's OADate format. This setting is disabled by default and will tak...

Description Returns the index of the last column of a grid from one of its cells. In Excel, it returns the index of the column of the first empty cell minus 1, starting from the specified cell. Used for dynamic tables. Syntax =MM_LASTCOLUMN(Cell) Cell Any cell inside the grid from which you want to get the index of the last column. Remarks Warning: ...

Your browser does not support HTML5 video....

New features & improvements IMPROVED IP Restrictions IP restrictions are added with a specific switch to limit it to API calls. IMPROVED Project Manager Improvement of the clone interface with the possibility to set the name of the copy before the clone. IMPROVED Interlinks V2 - New Public API V2 routes for Interlinks2 that should replace old In...

As in Excel, you can apply filters to your columns. Click on the arrow button at the right of your column header, then select Display filters for this column. A popup will appear with the list of values available. Just check/uncheck which value you want to display in the grid. Then click on Apply filters. Please note that: You can combine filters on...

Description Replaces loop indexes by labels in Mind tables. To be used with the MM_LOOP function.  Syntax =MM_LOOPLABELS("LoopName", Labels, [Index]) "LoopName" String. Name of the loop for which you want to add labels. Labels Range corresponding to the labels you want to add. Index (optional) Index of the loop label you want to display in the cell....

New features & improvements NEW  Server status New feature to know directly in the project manager if the linked server is off or unavailable by adding a small alert bar. IMPROVED  Public API Public API improvement with a new set of routes that manage the state of the client's servers for Public API licenses.API users can now easily retrieve an ...

New features & improvements IMPROVED Model manager User interface improvement to always gives the possibility to download all source or updated models in the Models Manager. IMPROVED Interlinks V2 Improve the Interlinks2 multiple source projects update time when no new data is retrieved.Better handling of Interlinks2 data when changing the Insta...

New features & improvements Input Manager formats control On newly uploaded/updated projects, a new setting allows you to detect a wrong inputs format on a CSV/TXT file compared to the Excel original format. Another setting defines if it will throw a warning or an error. MM_HYPERLINK Possibility to add this formula to a cell (like MM_SETSIZE) to...

New features & improvements First NaN detection setting Add a setting to automatically stop a run when calculations get a NaN, displaying in the run log the position of the NaN. Partial Run into Workflow mode Add a setting to enable to partial run per grids/groups within the workflow mode. Add a setting to enable the partial run of a full step w...

New features & improvements IMPROVED  Input manager By default, do not hide the culture and delimiter in the Input manager window.Support YYYY-MM-DD date format when importing a date in CSV/TXT file if culture's default format cannot parse the date. IMPROVED Exports Improve downloaded files by authorizing special characters from grid names in th...

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 ...

Version 5.2.0 New features & improvements IMPROVED Excel cell currencies Displayed currencies set up in Excel and not based on the user culture. Other fixes Fixed the fact that source projects not in a folder are not retrieved when an interlink is created (project selection). Removes the filter on data visible only in debug mode when switching b...

Fixes Improvements and fixes of the Interlinks2 feature. Solves a SUMIF function issue when a string concatenates a number, the letter "E" and more numbers. Solves an issue when merged cells are mixed with collapsed columns, not merging as expected. Solves bad behavior on Student distribution within Milliman Mind and MM Addin Handle the CompanyCode ...

Please note that you need to have the following right to access this feature: Project edition How to display the formula field? To display the formula field, you must be in Classic mode. Then simply open a grid, and click on the cell with the formula you want to display: The formula, in Mind format, will appear on the top of your grid. By default, o...

New features & improvements NEW   MM_DATESTRING function New MM_DATESTRING function that takes a date as an input and returns a formatted string (by default, "yyyy-MM-dd"). Same as TEXT() but not dependent on cultures. IMPROVED  Public API load New Public API method to load a project partially by providing an InstanceSelect string parameter to t...

Description Copies the formula in which the function is used to adjacent cells and resizes the table accordingly. Syntax If Formula returns a numerical value: =Formula + MM_SETSIZE(NbRows, NbCols) or if Formula returns a text: =Formula & IF(MM_SETSIZE(NbRows, NbCols)=0,"",0) Formula The formula you want to copy to adjacent cells. NbRows The tota...

Milliman Mind version required This feature requires Milliman Mind version 4.5.3 or more recent.The links created with the previous versions of Mind will be automatically migrated when moving to this version.   Milliman Mind provides a set of features to transfer data (inputs, settings, results from calculation, …) from one or several project(s) to ...

Description Flattens dimensions of target range into one single table. You can chose to return either all indexes of all dimensions or only specified indexes of loops and/or simulations. Syntax =MM_FLATTENDIM(Keys, WithLoopKeys, [Name, Index], [Name2, Index2], ...) Keys Range you want to flatten. WithLoopKeys (optional) Boolean. Value can be TRUE or...

Delete Warning This article is about App Builder feature, that requires a specific license.Contact us for more information about this feature. When updating an app, you were able to choose either to replace the current version or to create a new major version, not retro compatible meaning you had to create a new project to get the newer model (audit...

Edit a project You can edit a project's name, tags, and status directly inside the manager. To open the edition panel, right-click on your project or click on the three dots on the right of your project to open the contextual menu, then click on Edit. A modal will appear. Edit the information, then click on the Edit project button. Sign and validate...

For debugging and support purpose, we have built an option to give temporary access to all your administration and projects to our support team. At any moment you can turn off this feature, but we might ask you to turn it back on if you encounter any problem that we may have to solve with you. How to grant/prevent access Turn on / off the switch on ...

Info This version has been initially released on December 11th, 2021. We are pleased to publish version 4.0 of Milliman Mind, which includes new authentication options as well as many new features and bug fixes. New Authentication options Milliman Mind includes a new authentication system, improving all the security aspects while making it easier to...

Description These functions join two input ranges according to matching keys. Even if keys can not be matched, elements from the first table (or second table if you use RIGHTOUTERJOIN) are still displayed. Syntax =MM_LEFTOUTERJOIN(Key1, Output1, Key2, Output2) Key1: First range key Output1: First range Key2: Second range key Output2: Second range to...

Description Returns the cumulative distribution function of a distribution evaluated at a specified value. Via distribution parameters.  Syntax =MM_CDF("DistName", X, Param1, [Param2], [Param3]) "DistName" String. Name of the desired distribution.  X The value at which the cumulative distribution function is evaluated.  Param1 First parameter of the...

Added Display all dimensions in one grid We added a new feature to display every dimensions of a grid directly inside Milliman Mind (results will be the same as when your export all dimensions in CSV). Filters feature is available for these grids. Changed 3D charts should now work on every computer and browser. Sensitivity chart for Scatter chart ty...

Users list To access the users list, go to “Accounts” > “Users” in the Administration panel. You will see the lists of all the users existing in the company, categorized by “Active”, “Milliman consultants”, and “Disabled” users. You can search this list by clicking the Search button in the top bar. Add a new user To add a new user, click on the b...

How do I get Administrator access? In every Milliman Mind bundle pack, we include an Administrator access right.It will be automatically assigned to one of your company's users when your accounts are created, depending on the contract signed. Buy more Administrator licenses If you want more than one administrator, contact us or your local Milliman o...

Please find attached to this article the Milliman Mind System Description & Architecture PDF document.  ...

Description Returns the value of a specified risk measure evaluated for a given multidimensional cell. You can specify which loop dimensions you want to access.  Syntax =MM_RM(Cell, "RM", [Param], ["Name", Index], ["Name2", Index2], ...) Cell Cell that contains values on which you want to evaluate the risk measure. "RM" String.To check all supported...

Milliman Mind administration allows you to create custom roles for your users. By default, three roles (for each kind of license) exist and cannot be deleted. These sets of actions define what can be done or not done by any user in Milliman Mind. Create a new custom role The first step is to click on Users & Roles on the left bar, then on Roles....

To correlate a cell with a copula, you must have first added them to the DC (Distributions and Copulas) Manager. Then open DC Manager by clicking on the button in the action bar. You will see: On the left pane, your copulas. It should be empty for the moment. On the right pane, the cells that can be correlated. First, click on Add a new copula to cr...

New features & improvements NEW   New setting to allow multiple access to an instance group A new option in project settings allows you to stop preventing multiple users to access the same instance group/treaty selection at the same time, following the new multi-user behavior of results consistency. IMPROVED  Culture in the Input manager The cul...

Description Returns the inverse cumulative distribution function or quantile function of a distribution evaluated at a specified value. Via mean and standard deviation. Syntax =MM_InvCDF_MS("DistName", X, Mean, [StdDev], [Param3]) "DistName" String. Name of the desired distribution.  X The value at which the inverse cumulative distribution function ...

Description Binds ranges horizontally. Creates a new range by putting together ranges side-by-side. Syntax =MM_HUNION(RangeOutput, [RangeOutput2], [RangeOuput3], [...]) RangeOutput First range you want to bind. RangeOutput2 (optional)Second range you want to bind. RangeOutput2 must have at least the same number of rows as RangeOutput.  RangeOutput3 ...

Improved features Conditional formatting Milliman Mind supports Excel conditional formatting simple rules when using Excel style mode. CSV Inputs speed Projects with a lot of CSV inputs will be faster. Improved error messages for model design and overlapping grids. Fixes Various fixes Improved features Improved rows and columns outlines Level displa...

Milliman Mind supports bijectivity between Mind and Excel, meaning you can export back your models to Excel from the application Export back your projects to Excel Delete Please note that you need to have the following right to access this feature: Project export To export your models back to Excel with updated assumptions and formulas, click first ...

Please note that you need to have the following right to access this feature: Project Duplication Milliman Mind handles accurately the content of your duplicated project or folder, giving you the possibility to precisely choose what you want to preserve when copying a project. To copy a project, first, right-click on your project or your folder, the...

Add group access through user window Under the Administration view, go to Users&Roles then to Users. Select the user you want to change access right, then go to the Project groups section. There you can add, delete or modify access for this user to all Project groups available. Once you're done editing user, click on the "Update User" button a t...

Description Performs goal seek calculations to return the target rate for a defined target amount of profit sharing taking into accounts guaranteed rates.  Syntax =MM_PROFITSHARING_OPTI(RangeTX, RangePM, PB, [Tolerance]) RangeTX Range that contains the guaranteed rates for all contracts. The range must be a column. RangePM Range that contains the ma...

Delete Important note Please note that all features related to password management are only available if you are logged in with Milliman Mind credentials. If you are logged in using Enterprise Identity Provider, please contact your IT to manage your password. Change my password To change your password, be sure you are connected to the project manage...

Classic settings set-up By default, when you import Excel file(s) in a newly created Milliman Mind project, settings are always set at their default value (except Stochastic mode which is automatically enabled if you have stochastic formulas). Use /ProjectSettings grid If you want to define Milliman Mind settings directly into your Excel file, you w...

Project groups are a way to group projects. Projects groups are shared in a company, but administrators can restrict access of a project group to specified users (none, read or read/write rights). If you have been granted access to some project groups, you will be able to navigate through them by clicking on the currently selected project group (on ...

Setup my computer For model design: Install MMForExcel We provide an Excel addin', compatible with Excel 2007 and newer (ok with Excel 365, unfortunately not compatible with Excel for Mac for the moment) that will provide new modeling functions for Milliman Mind built-in Excel. To install this plugin: Go to https://www.milliman-mind.com/mm/ to downl...

Fixes Optimizing the rendering time of conditional formatting cells without rendering the full grid at each change. Fixing run errors for runs with more than 127 calculation iterations. Fixing errors on models that use the AOC/AOS functionality and dropdown lists in cells. Fixing loading errors on projects with interlinks that had removed instances ...

The default behavior for new accounts When your Mind account is newly created, we do not define a specific culture by default. If you are using a recent version of Mind, it will automatically choose your browser culture as a default culture. If your version of Mind is older than v. 4.5.1, it will be set as en-US by default.  Choose a culture Your cu...

Info This version is available for publication from Monday, July 11th. New features & improvements NEW   Project manager: Multiple duplications and delete For updated servers, the project manager now offers the possibility to select multiple files and duplicate them or delete them in one click. See Bulk actions on projects‍ article. NEW  Automat...

Description Returns a range starting from a specified cell and ending at the last cell of the corresponding table. Used for dynamic tables. Syntax =MM_TABLE(Cell) Cell Starting cell of the range the function returns. Remarks This function is useful when you have dynamic tables, i.e. when the size of your table varies, for instance, if you use the in...

Update my custom formulas to work with the 3.8.4 engine Two elements should be changed to work with the latest version. If x is an object, never use x.ToString(), use the function GetString(x) If a variable vg is a VirtualGrid, don't use vg[row, col], use vg.Cell(row, col) or vg.ReadValue(row, col) !!! These changes are mandatory for your formulas t...

Description  MM_AOCSTATUS returns true if switch for AOC is activated in Mind (before launching calculations). MM_SENSITIVITYSTATUS returns true if switch for sensitivity is activated in Mind (before launching calculations). Syntax =MM_AOCSTATUS() =MM_SENSITIVITYSTATUS() Example If you switch off AOC and AOS and run the model, both functions will re...

Version 6.2.9 Changes Corrected a bug where XLOOKUP function could not be used on ranges containing only one value (#7823) Better handling of error codes in the XBRL manager (license or technical errors) (#7817) Correct the behavior of the function TEXT when used with the format "00000000000" (#7820) Enabled to use array formula with usual operators...

What is the difference between a folder and a workspace? A workspace (the new "Project group"'s name) is a space where various users from the same environment can collaborate to create or open projects and folders. Workspace comes with an access management system allowing to grant or not read or read/write rights to users. A folder is a logic contai...

New features & improvements NEW   Support of new Excel functions Milliman Mind now supports FORMULATEXT() and XLOOKUP() native Excel functions. IMPROVED  Date and Time variables in Export Manager New feature allowing to add to Export manager's FileNamePattern, Prefix or Suffix a {Date} variable to add the date, or a {Time} variable, to add the e...

If you have been granted access to more than one company environment, you can easily navigate through the projects of these companies. To change the company, just click on the company name next to the Milliman logo in the upper left corner. A dropdown list will appear with every company you have access to. You just need to click on one to switch to ...

New features & improvements IMPROVED Public API - New Public API route to return the current version of a server. IMPROVED XBRL Manager - Rename the XBRL exported files and uniformize the XBRL status in the XBRL manager v2. IMPROVED Interlinks2 - Improving the audit trail entry of Interlinks2 data update with more precise and relevant informatio...

Add your models to Mind Please note that you need to have the following right to access this feature: Project import Click on the Upload my first file button on the top navbar, or click on the Models management button of the action bar to upload a new model. Select the model(s) file(s) on your computer to upload to the Mind Cloud, or just drag and d...

How Debug mode works For model developers, a specific Mind setting is available enabling the Debug mode which will disable some features and improve logs for better debugging of models during their development. First, you must have a Creator account to use this “Debug mode”. Enable the Debug mode Please note that you need to have the following right...

To access Milliman Mind, you must be granted access by your administrator.You will receive your credentials either by mail or from your administrator. Enter my email address The first step is to enter your email address in the mail field and click the Continue button. Enter my password Depending on whether your company enabled external IDP / SSO or ...

To access the list of users, click on the Users & Roles button on the left bar, then on Users. Create new user To create a new user, click on the Create new user button on the top right corner of the user list. It will display the creation of user window. First enter the email address of your new user. Delete Info If the user already exist in th...

Select the projects To select several projects at the same time, you can Right-click on a project > Select Project or click on this button: Then select the projects on which you want to proceed bulk-actions: Duplicate or Delete Once you've selected your projects, simply click on the Duplicate or the Delete button on the bottom bar:...

Milliman Mind 3.8.4 will be released on November 14th, 2020. Please read carefully if you are using Custom C# formulas: With this latest version, your custom formulas may not compile correctly anymore because of an engine improvement. Please follow this link to look at the new C# formulas guidelines. These changes are mandator y, but we are availabl...

New features & improvements IMPROVED  Input manager Input manager improvement keeps an uploaded input's original name and separator when downloading.Improvement of matching part when using the input manager to optimize performance. IMPROVED  Default culture Improvement of the default behavior about culture when creating a new user. When a user i...

New features Models translation A new setting at user level allow to define a favorite language.If you add a /Translations table to your project, every element in the translation table will be translated in Milliman Mind. Headers improvements Headers now support Excel formulas and if you add a /NoHeaders flag to your table, no header will be display...

Description Returns the probability density function of a truncated distribution evaluated at a specified value. Via mean and standard deviation. Syntax =MM_PDF_MS_TRUNC("DistName", X, Mean, StdDev, Param3, LowerBound, UpperBound) "DistName" String. Name of the distribution you want to simulate.  X The value at which the truncated probability densit...

To assign a license to a user you have two possibilities: Assign it through the license panel Click on the license button on the sidebar. Then select which license you want to edit users' rights. You will be displayed a table with each user who has been granted access to this license. Use the smart selector to add new users to this list, then do not...

New features In project change of formulas When you double-click on a formula, you can edit it easily thanks to a built in formulas editor. You can also add a formula to an assumption cell, and spread a formula to a range of cell by right-clicking then Copy formula, or by grabbing the little blue square on the bottom-right of the selected cell. New ...

In every Milliman, Mind bundle pack is included an Administrator access right.It will be automatically assigned to one of the users of your company when your accounts will be created. Delete Info If you want more than one administrator, you want to contact us or your local Milliman office to purchase an additional administrator license. If you have ...

New features & improvements NEW  Update project's flags with a CSV file New feature to update project's flags by exporting/importing a CSV, giving the possibility to update the steps structure of the project with an external file. IMPROVED  Audit trail & Audit trail of Runs New API flag on the Audit trail and Audit trail of Runs to know if t...

Create a group in Excel First, create two grids or more in the same Excel sheet. Creating parts of the group inside the same sheet prevents get uncoherent width or heights of cells. Once you have created your grids inside Excel, add the following flag to each grid name cell: /Group.(Group name).x.y Where: (Group name) is the unique identifier of thi...

Milliman Mind provides a  tool to monitor in real-time the use of CPU and memory of all your users. If you have a specific server you will be able to get a global look at your server consumption. To access this feature you must have administrator rights. Connect to the administration, then click on Tools > Monitoring. You will access a screen whi...

New features & improvements NEW   Support of NUMBERVALUE() Excel function NEW   New MM_CHECKISIN function New MM_CHECKISIN function checking the validity of an ISIN code. IMPROVED   Flags manager Improvement of the flag manager to prevent inappropriate errors when incompatible flags are selected anywhere in the model. IMPROVED Input manager dele...

You can import a set of users by using a CSV file with the needed data inside. Example file The set of users must follow the format of this example file : csv-users-sample.csv Import a list of users To access the list of users, click on the Users & Roles button on the left bar, then on Users. Then click on Import a CSV on the top-right corner. F...

New features & improvements NEW   New wildcard feature for input auto-match settings New feature allowing wildcards into the Input settings auto-match table: Add {*} to allow anything in part of the filename, or add {???} to allow any 3-character string in the filename (only accept the number of ? as the number of characters). NEW   C# Formulas ...

Access the Monitoring panel To access the monitoring panel, as an administrator, you must click on the Features switch and select Monitoring. Two tabs will be accessible from this Monitoring panel: a Dashboard and a List of active sessions. Dashboard The dashboard will give you a quick overview of all your servers and their current state: the number...

If you do not get basic knowledge on instances, you can learn more on: Introduction to instances‍ The flag /InstanceSplit enables you to tag a grid in which you can split data according to instances written in the table. When creating a grid with the flag /InstanceSplit added to your table name( #GridName /instancesplit), you should define in the fi...

Description Concatenates data from a range using a specified separator. This is particularly useful for the Setup parameters editor‍ .  Syntax =MM_CONCATENATE(Range, "Separator") Range The range that contains data you wish to concatenate. Separator (optional)A string that separates each data from Range. The default value is set to "|" (pipe). Exampl...

Some Milliman Mind users accessing the software with the browser Microsoft EDGE may experience loss of sessions when putting their Mind tab in the background for a certain amount of time. Why is it happening? Microsoft introduced in a recent version of EDGE a "Save resources with sleeping tabs" feature, which will put the unused tabs into a deep sle...

The usual behavior of Milliman Mind is to kill the session after 3 minutes without an open web browser on the project. Unfortunately, it could occur during a run if the computer is going in sleep mode. You can now go to Settings > Other > Click on the Switch to keep my session active 48h.Then your session will be kept alive for 48 hours, givin...

New features & improvements NEW   Native OS notifications at download and end of a run A new native notification from your operating system (Windows) will be displayed at the end of a run or when a download starts if you have granted access to the application in your web browser. IMPROVED  Access /NoFormula formulas in debug mode In debug mode, ...

Info This feature is available on Milliman Mind starting from version 4.3.If you are working with an earlier version of Milliman Mind and want to use this feature, you can contact our support to schedule an upgrade. Run results and consistency with the audit trail Milliman Mind provides real-time information about the consistency of the results prod...

Delete Please note that you need to have the following right to access this feature: Project run Click on the Run Calculation button to launch run (2). If you are running a stochastic model: select the number of simulations you want to run in the input field located in the right of the Run Calculation button in the action bar. For example, enter 100...

New features & improvements IMPROVED Performance Profiler - When a run is executed with the profiler, the profiler is saved and made accessible in the run log. IMPROVED Results consistency - Improved the run consistency functionality to be able to view the consistency of all the intance groups of a project. Other fixes Fix to avoid timeout durin...

Milliman Mind Read license This license gives you access to Milliman Mind projects without the possibility to run them. User license This license gives you access right to existing Milliman Mind projects with the possibility to run them. Creator license This license gives you full access to Milliman Mind projects, the possibility to create a new one...

Description Returns the cell in the same row as the specified cell and in the last column of the corresponding table. Used for dynamic tables. Syntax =MM_LASTCOLUMNCELL(Cell) Cell Cell that defines the table and the row for the output. Remarks Warning: This formula has a different behavior in Excel and in Mind. See the first example. This function i...

New features & improvements IMPROVED Interlinks V2 - Interlinks2 global status is now displayed directly with an indicator on the Interlink manager button of the action bar.  Other fixes Optimization of MM_REMOVEDUPLICATES performance on large datasets. Solves an issue of interlinks2 un-freezing by themselves after a save / reload. Solves an iss...

If you have created a new user but selected to not send directly the credentials email, you may want to send it later. Users created without sending the mail are flagged with a little blue mail icon next to their name. To send the mail to all users with this flag, just click on Send emails button on the top-right corner. After validation, it will se...

Added Display all dimensions of a cell Right click > Display all dim. allow you to open a new grid with every dimensions values for selected cell. MM_LOOP labels Your loops can have labels and not only indexes. Bugs Various bug fixes in project manager and Milliman Mind. Performance improvements....

Milliman Mind allows you to dynamically hide some rows, columns, and the headers line according to calculation results or selected dimensions/instances. How to hide rows To hide some columns inside a grid, you should create a new column at the right of your grid with the following header: /HideRows . This column can contain formulas that will return...

Description The equivalent of COUNTIF Excel function. Returns the number of dimension indexes of a range that meet a chosen criterion. It is possible to specify the index of one or several loops for which you want to apply the function.  Syntax =MM_COUNTIF(Value, Condition, ["Name", Index], ["Name2", Index2], ...) Value Cells to be counted if they m...

Milliman Mind accurately handles the content of your cloned project or folder, allowing you to precisely choose what you want to preserve when copying a project. To copy a project, right-click on your project or your folder, then click on the Duplicate item. Options for project duplication A new prompt window will ask you for the name of the copy an...

Description MM_SENSITIVITY creates sensitivity indexes of loop Analysis from one range. The function returns the row of the input range which corresponds to the selected index of the loop Analysis.  MM_SENSITIVITYLABELS adds labels to analysis sensitivity indexes of loop Analysis. Syntax =MM_SENSITIVITY(Range, [Index]) Range Target range. A table (u...

List of supported Excel formulas: Logical functions AND FALSE IF IFERROR IFS ISBLANK ISERR ISERROR ISEVEN ISLOGICAL ISNA ISNONTEXT ISNUMBER ISODD ISREF ISTEXT NOT OR TRUE Math & trig functions ABS ACOS ACOSH ASIN ASINH ATAN ATAN2 ATANH CEILING COMBIN COMPLEX COS COSH DEGREES DELTA EVEN EXP FACT FACTDOUBLE FLOOR IMAGINARY IMREAL INT LN LOG LOG10 ...

Milliman Project manager gives you the possibility to change easily the status of your project. You can choose to validate or validate and sign a project, which will block some features inside your project for governance purposes. Validate a project Please note that you need to have the following right to access this feature: Project Validation When...

To change this setting click on the Settings button on the action bar : Then turn on the Spread loops switch: Spreading loops & instances When this mode is on, each time you will change the loop/instance of a grid or a chart, this change will spread to all open grids/charts and newly opened ones....

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 ...

Intercom Before using Milliman Mind, you must agree with Intercom's privacy policy, as built-in chat is a full part of our software. You can find the privacy policy by clicking on the link below: Intercom Privacy Policy Delete...

To access the administration logs, click on “Logs & Reports” > “Administration Logs”. We constantly log all actions that are done by any users inside Milliman Mind administration. If you click on one, the action will be displayed with all the details of what has been done. Please note that these actions cannot be undone directly inside the lo...

Milliman Mind 3.11.4 Improvements New audit trail entry for cleaning data validation If at the end of a run, if some values liked to data validation formulas are not valid anymore, they are removed and this action is logged in the audit trail. Copy-paste of ranges on formulas We now allow to copy-paste ranges of values to override formulas. Dates in...

Description Returns the cumulative distribution function of a truncated distribution evaluated at a specified value. Via mean and standard deviation. Syntax =MM_CDF_MS_TRUNC("DistName", X, Mean, StdDev, Param3, LowerBound, UpperBound) "DistName" String. Name of the distribution you want to simulate.  X The value at which the truncated cumulative dis...

Description Generates a random number greater or equal to 0 and less than 1 (excluded) using Mind generator. The generated numbers are evenly distributed between 0 and 1. Syntax =MM_RANDOM() No parameters.  Remarks This function is equivalent to the RAND Excel function which uses Excel generator. Mind uses a different random number generator: xoshir...

Please note that you need to have the following right to access this feature: Project deletion To delete a project, right click on your project, then click on the Delete choice. You will be asked for a confirmation before erasing your project: write delete inside the input field, then click on Delete. Please note that we cannot recover erased projec...

If you have defined groups (outline) of rows or columns in your Excel file, you will get a new navigation interface to display different levels of hidden rows/columns. The hidden rows and columns will be notified in the headers by a blue line and two blue arrows. These rows/columns are hidden but can still be called for displaying a chart for exampl...

Description This function returns the user name who made the last change in your Mind project. Syntax =MM_LASTCHANGEDBY(Cell, ShowEmail) Cell: Cell for which to return the last user to make a change in Mind ShowEmail: Boolean to specify to display user name or user mail in Mind. Put False if you want user name, True if you prefer user mail. Remarks ...

Description The equivalent of SUMIF Excel function. Returns the sum of values of all dimensions or specified dimensions of a range that meet a chosen criterion. Syntax =MM_SUMIF(Value, Condition, [Sum_value], ["Name", Index], ["Name2", Index2], ...) Value Cells to sum if they meet the given criterion. If the Sum_value parameter is input, only the po...

Description Returns the inverse cumulative distribution function or quantile function of a truncated distribution evaluated at a specified value. Via distribution parameters. Syntax =MM_InvCDF_TRUNC("DistName", X, Param1, Param2, Param3, LowerBound, UpperBound) "DistName" String. Name of the desired distribution.  X The value at which the inverse tr...

Description Equivalent of AVERAGEIF Excel function. Returns the average of values of all dimensions or specified dimensions of a range that meet a chosen criterion.  Syntax =MM_AVERAGEIF(Value, Condition, [Average_value], ["Name", Index], ["Name2", Index2], ...) Value Cells to be averaged if they meet the given criterion. If the Average_value parame...

Description The equivalent of COUNTIFS Excel function. Returns the number of dimension indexes of a range that meet a chosen set of criteria. It is possible to specify the index of one or several loops for which you want to apply the function. Syntax =MM_COUNTIFS(Range1, Condition1, [Range2, Condition2], [Range3, Condition3], ["Name", Index], ["Name...

New features & improvements IMPROVED Save Improvement of the save process by making it a non-blocking process, allowing to navigate in the project during its duration.Improvement of the Save button status (blinking when unsaved changes) reliability. IMPROVED Apps - Improvement of the update App screen by displaying the targeted version number. I...

We released on 18th of May the version 2.0 of Milliman Mind, introducing several big new features and changes that we will describe in this document. If you have any question or noticed any bug, please contact us at europeansoftware@milliman.com or through the built-in chat. New licenses levels We are introducing with version 2.0 of Milliman Mind a ...

Display organization and relationships between cells of your Excel models. To display the dependencies of a cell, right-click and select Display cell dependencies. This will open a popup with a treeview: On the left are Ascending dependencies of the selected cell. At the center is the selected cell. On the right are the Descending dependencies of th...

Version 5.2.3 New features & improvements ADDED (BETA) High-Performance Computing We added a new feature currently in BETA to launch massively parallel runs on on-demand servers. Billing is accessible on the administration and calculated at a fixed price per hour/per core. API routes have also been added to interact with this feature.If you are ...

New features & improvements NEW  Sessions monitoring rewriting Rewriting of the sessions monitoring to have more detailed metrics of each server connected to a company. The metrics are more precise and can be displayed as a chart for the last 24 hours, seven days, or 30 days. IMPROVED  Public API Improvement of the Public API to handle the speci...

Description Returns a range that contains all supported risk measures.  Syntax =MM_RISKMEASURESLIST() No parameters. Remarks The output values are the names of risk measures meant to be used in the MM_RM function of DCforExcel. See the MM_RM function article.  The risk measures or indicators can also be found and defined in the administration (if yo...

New features Assumption manager Assumption manager is a new tool built within Milliman Mind to export/import a set of assumptions according to their background color defined in Excel. New interlink manager Gives the possibility to link automatically two projects, copying /OutputLink grids to /InputLink grids with a user-friendly interface. YIELD Exc...

You can define specific grids in your model as Input grids in Milliman Mind. Those grids will be considered as sources for your model's data. Through the Input manager built in the project manager, you will be able to import folders of CSV files that will automatically match to same name grids and resize the model to match the imported data. Input M...

Description Returns a row range starting from a given cell and ending at the last column of the corresponding table. Used for dynamic tables. In Excel, it returns a row range starting from the specified cell and ending at the first empty cell (excluded).  Syntax =MM_ROW(Cell) Cell Starting cell of the row. Remarks Warning: This formula has a differe...

Error 1: Limit of 100 calculation iteration has been reached... This issue is usually related to loop calculation. The most frequently encountered situations are: MM_RESULT function that calls a loop that was never created MM_LOOPLABELS function that calls a loop that was never created Anything else that references a loop that was never created Loop...

App Requirements Modern web browser Milliman Mind requires a modern web browser installed on your computer. We currently support : Microsoft EDGE Google Chrome Mozilla Firefox Apple Safari Please note that Internet Explorer is not anymore supported nor updated by Microsoft, and therefore is not able to run Milliman Mind, which uses the latest IT tec...

Create a project Delete Please note that you need to have the following right to access this feature: Project creation To create a project, you must have been granted access to an application (Milliman Mind Platform, an app, or an internal app) by your administrator, while having the correct set of rights and licenses. This will display a + button o...

Description Sums the results of all simulations for a given cell. Syntax =MM_SUM(Cell) Cell Cell whose results of simulations you want to sum. Remark It is very similar to the MM_RESULT function, except it does not have loop specifications as parameters, which means that by using MM_SUM, you are keeping all the loops from your table for the specifie...

Write /Translations grid Delete Please note that you need to have the following right to access this feature: Project translation grid import The first step to translate a model is to create a grid in one of your excel files with the flag /Translations . This grid should contain in the header the ISO 639-1 Code two-letters identifier of the language...

This feature goal is to allow input to import with columns in a different order than in the original Excel model. Milliman Mind will automatically change the imported input columns to match the Excel file/Mind order. Add specific /Reorder flag You must add a /Reorder flag to your grids to do so. Those grids must follow these requirements: Do have a ...

Description Returns a column range starting from a given cell and ending at the last row of the corresponding table. Used for dynamic tables. In Excel, it returns a column range starting from the specified cell and ending at the first empty cell (excluded). Syntax =MM_COLUMN(Cell) Cell Starting cell of the column. Remarks Warning:  This formula has ...

Description Returns the index of the selected dimension of a specified loop or of the selected simulation. Syntax =MM_DIMINDEX("Name") "Name" String.Case 1: Name of the loop whose index you want to access.Case 2: Choose Name equal to "SIM" if you want to access the index of the selected stochastic simulation.  Warning: The parameter LoopName is case...

What is Multi-Factor Authentication? Multi-factor authentication is an electronic authentication method in which a user is granted access to an application only after successfully presenting two or more pieces of evidence (or factors) to an authentication mechanism. Activate Multi-Factor for my company If you are the administrator of your company, y...