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 optimization like were doing VLOOKUP and HLOOKUP in Mind in a previous version. From this version, VLOOKUP and HLOOKUP are now copying the exact behavior of Excel, but with much lower performance.
-
NEW MM_READTABLENAN
Same that MM_READTABLE but returns a NaN when no match is found.
-
NEW Passwords hints
When defining a new password, Milliman Mind will explain more clearly the requirements with a visual indicator when they are matched.
-
NEW Download run logs in TXT file
Run log window allows download of the complete log in a TXT file.
-
IMPROVED Datavalidation cells performance improvement
Models using data validation cells may see an increase in performance during the run.
-
IMPROVED Run logs display speed
Run logs window will display much faster with lazy loading.
-
IMPROVED MM_LASTCHANGEBY/DATE for Input grids
MM_LASTCHANGEDBY & MM_LASTCHANGEDATE could work also to know when input has been uploaded / by whom.
-
IMPROVED Charts various improvements (from v4.2.1.7)
Possibility to create cross instances charts and to "quantilize" the data.
-
NEW MM_RANDOMSAMPLE (from v4.2.1.6)
MM function to generate a random array of numbers with or without replacement.
Other fixes
- Fix the COUPNCD function in Milliman Mind to make the last parameter optional like in Excel
- Fix to prevent update of Apps to a newer version when a project is partially loaded
- Fix to increase the speed of filters display on columns with +1000 rows
- Fix to prevent "Retrieve session" when a session has not been fully loaded
- Fix to support 0/1 in addition to TRUE/FALSE in /ExportSettings grid
- Fix to prevent the upload of duplicated project model names within /InstanceKey table
- Fix about Update model input grids that will change their number of columns
- Fix to solve an inconsistent behavior between Project settings & Assumption manager
- Fix to clean uploaded but not added models in a session
- Fix to get a better error message when Windows cannot upload a file (already opened in Excel, ...)
- Fix to prevent auto-save of C# formulas when upgrading them in a model
- Fix to display hidden headers in debug mode within groups (like in classic grids)
- Fix to display more information in workflow mode by using the full height available of the viewport
- Fix to prevent the unwanted conversion of text into numbers when importing inputs
- Fix to warn administrators when a user is created without a role assigned
- Fix putting back Name ranges when exporting an updated Excel model
- Fix to prevent false positive warning message of unsaved changes just after an upload of models
- Fix preventing the upload of input files with a "Keys" column
- Fix to make YEAR function an Array function
- Fix the link opening a specific grid with highlighted cell when clicking on a formula when there are hidden elements
- Fix removing an empty blank space that could appear on top of groups in workflow mode
- Fix to make /ReadOnly grids and groups really read-only
- Fix to put back missing validation rules for AOC step order grid
- Fix to prevent loss of results after a run per instance group
- Fix to prevent crash of the 2nd run in some rare cases
- Fix to prevent mixed data only in the display when switching instances in workflow mode
- Fix of SUMIFS function when comparing text VS numbers
- Fix of MM_RANDOMSAMPLE (speed improvement)
- Fix to avoid error in case user created hyperlink formula to a cell that is empty
- Fix to automatically apply /ProjectSettings grid at upload and not only at refresh (for Workflow mode for example)
- Fix to handle badly created external links within Excel models (from v4.2.1.5)
- Fix to enable export of hidden grids in Debug mode (from v4.2.1.5)
- Fix to handle fallback protocols when Websockets are unavailable (from v4.2.1.4)
- Fix to support merge cells and hidden rows in groups (from v4.2.1.2)
- Fix of classic mode navigation bug that could prevent the display of all models (from v4.2.1.1)
