Son activity
0 Articles Written Last Month
0 0 0 0 0 0 0
MM_SORT function (deprecated)
Description Sorts the numerical values of the dimensions of a specified cell. Warning This function is deprecated and available for model compatibility only, please use MM_SORTRANGE, MM_SORTRANGES or MM_SORTDIM. Syntax =MM_SORT(Cell, SortingOrder, [Name, Index], [Name2, Index2], ...) Cell Multidimensional cell which contains the values you want to s...
0 min reading timeIterations: design sequential calculations in your model
Description and model design Using the Iteration functionality, one can define the global run of a project as a subset of multiple sequential runs of one or several workbooks. We call one iteration, one run for a given workbook. In the entire article, we consider the following model example composed of 4 workbooks: Model parameters, B, M, and Consol...
2 min reading timeMM_PROJECTNAME function
Description Returns the name of the project of the current session. Syntax =MM_PROJECTNAME(["ProjectName"]) “ProjectName” (optional)String. Value returned in Excel. If not filled in, the value returned in Excel is an empty string. Remarks To return the GUID (id of the model used to access the project), refer to the function MM_PROJECTGUID. If you c...
0 min reading timeMM_READTABLE function
Description Returns the element of a table corresponding to a specified combination of criteria for which the first columns of that table are tested. The criteria must be values or references to values. This function is similar to a lookup function with one or multiple criteria. Syntax =MM_READTABLE(Range, Header, Comparison1, [Comparison2], ...) Ra...
1 min reading timeMM_READITERATION function
Description Retrieves values from a specific iteration in another workbook on which iterations were defined. To learn more about iterations, check the general article on iterations. Syntax =MM_READITERATION(Cell, Iteration) Cell Cell to read. The cell is from another workbook on which iterations are defined. Iteration The index of the iteration to o...
0 min reading timeMM_MIX function
Description The MM_MIX function performs a combination of two ranges by repeating the elements of Range2 for each element in Range1. Syntax =MM_MIX(Range1, Range2) Range1 The first range to be combined. Range2 The second range to be combined. Remarks You can include ranges of multiple columns in each range, and even mix a single-column range with a ...
1 min reading timeMM_FILTER function
Description Filters specified ranges with a given key. Syntax =MM_FILTER(Key, Output1, [Output2], [Output3]) Key Range that contains values equal to 0 or 1:- 0 to omit the value,- 1 to return the value. 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 th...
1 min reading timeMM_FILTERDIM function
Description Filters a grid taking into account values through all dimensions. Similar to MM_FILTER, except that dimensions from the input grid are not inherited. All values from the input grid (all dimensions) are used to output the filtered grid which has no dimensions. Syntax =MM_FILTERDIM(Key, Output1, [Output2], [Output3], ..., [Output15]) Key R...
0 min reading timeMM_READTABLENAN function
Description Returns the element of a table corresponding to a specified combination of criteria for which the first columns of that table are tested. The criteria must be values or references to values. This function is similar to a lookup function with one or multiple criteria. Syntax =MM_READTABLENAN(Range, Header, Comparison1, [Comparison2], ...)...
1 min reading timeMM_SIMULATE_TRUNC function
Description Simulates a desired truncated probability distribution using distribution parameters. Syntax =MM_SIMULATE_TRUNC("DistName", Param1, Param2, Param3, LowerBound, UpperBound) "DistName" String. Name of the distribution you want to simulate. Param1, Param2, Param3 Parameters of the distribution. Even if the distribution has less than thre...
0 min reading timeMM_INSTANCE function
Description Returns the value of a cell for a specified instance. Used to link different instances. Syntax =MM_INSTANCE(Cell, Param, [NanIfNotExists]) Cell Cell which contains the value you want the function to return. Cell is not meant to be a range bigger than a cell. Param Index or name of the instance you want to access. NanIfNotExists (optional...
1 min reading timeMM_CURRENTUSERMAIL function
Description Returns the email address of the user who launched the run. Syntax =MM_CURRENTUSERMAIL() No parameters. Remarks On Excel, the value returned is based on the account on which you are logged in to access Excel. To return the name of the user, refer to the function MM_CURRENTUSER. Example For a user registered with the name “John Doe” and ...
0 min reading timeMM_INSTANCEKEY function
Description Returns the label of the selected instance in a table. Syntax =MM_INSTANCEKEY(["DefaultKey"]) "DefaultKey" (optional)Label/key returned by the function in Excel. This parameter is not used in Mind. Remark Instances have to be added beforehand on your project. To learn more about instances , check the i ntroduction to instances . Examp...
0 min reading timeMM_SIMINDEXQUANTILE function
Description Returns the index of the simulation corresponding to the desired percentile. Syntax =MM_SIMINDEXQUANTILE(Value, Quantile) Value Cell in which simulations are generated (with functions such as RANDOM, MM_SIMULATE_MS, and so on.). Quantile The value at which the cumulative distribution function is evaluated. Remarks Note that in Excel, th...
0 min reading timeMM_LOOPINSTANCE function
Description This function creates a named loop on defined range per instance. Range should have only one column or only one row. Syntax =MM_LOOPINSTANCE(Name, MaxSizeRange, InstanceSizeRange, Index(Optional), IndexStart(Optional)) Name: Loop name MaxSizeRange: Target maximum range that defines size of loop. InstanceSizeRange: Target range that chang...
1 min reading timeMM_CURRENTUSER function
Description Returns the name of the user who launched the run. The value returned is the first name followed by the last name as input during the creation of the account. Syntax =MM_CURRENTUSER() No parameters. Remarks On Excel, the value returned is based on the account on which you are logged in to access Excel. To return the email address of the...
0 min reading timeMM_INPUTSTATUS function
Description Returns information about a parameter cell’s input grid. It tells if the grid is imported, not imported, or has warnings. Optionally checks for AOC-related information and returns a default value if no valid data is found. Syntax =MM_INPUTSTATUS(InputGridCell, CheckAOCInput, DefaultValue) InputGridCell A reference to a cell within the /I...
0 min reading timeMM_DISTRIBUTIONSLIST function
Description Returns a range that contains all supported probability distributions. The output values are the names of the probability distributions meant to be used in other functions of the add-in MMforExcel (for instance, MM_CDF, MM_PDF, MM_SIMULATE, ...). Syntax =MM_DISTRIBUTIONSLIST() No parameters. Remark Notice that the function MM_GETRANGE w...
0 min reading timeMM_SIMULATE function
Description Simulates a desired probability distribution using distribution parameters. Syntax =MM_SIMULATE("DistName", Param1, [Param2], [Param3]) "DistName" String. Name of the distribution you want to simulate. Param1 First parameter of the distribution. To check the definition of the parameters, refer to the MM_PARAMNAME function. [Param2], [P...
0 min reading timeMM_LOOP function
Description Creates a loop (multidimensional cells) from one range. Basically, it enables Mind to launch different scenarios. In Mind, you can navigate through all dimensions index of the cells that use the MM_LOOP function. Syntax =MM_LOOP("Name", Range, [Index], [IndexStart], [IndexEnd]) "Name" String. Name used to refer to the loop. Range Case 1...
1 min reading timeMM_PROJECTGUID function
Description Returns the ID of the project of the current session. Syntax =MM_PROJECTGUID() “ProjectGuid” (optional)String. Value returned in Excel. If not filled in, the value returned in Excel is 00000000-0000-0000-0000-000000000000. Remarks To return the name of the project, refer to the function MM_PROJECTNAME. Example If the ID of the project i...
0 min reading timeVersion 4.5.2
New features & improvements IMPROVED Input manager Improved auto-matching speed of uploaded inputs when the project has a lot of instances. IMPROVED Input manager When uploading instances, instances with similar names are now forbidden because of compatibility issue (ex : "Inst-1" and "Inst 1" are considered similar). A warning is raised during...
0 min reading timeMM_CHECKLEI function
Description Checks that the Legal Entity Identifier (LEI) input in the function is valid. Returns 1 if the LEI is valid, 0 otherwise. Syntax =MM_CHECKLEI("LEICodeValue") "LEICodeValue" String. LEI to check.Returns 1 if the LEI is valid, 0 otherwise. Remarks The algorithm used to check if the LEI code is valid is the following: Checks that LEICodeVal...
0 min reading timeMM_SIMULATE_MS function
Description Simulates a desired probability distribution using the mean and standard deviation. Syntax =MM_SIMULATE_MS("DistName", Mean, [StdDev], [Param3]) "DistName" String. Name of the distribution you want to simulate. Mean Mean of the desired distribution. StdDev (optional/required depending on the distribution) Standard deviation of the des...
0 min reading timeMM_GETRANGE function
Description This function is used to calculate dynamic functions from the add-in, for instance, MM_FILTER, MM_REMOVEDUPLICATES, MM_HUNION, MM_VUNION, ...etc. It appears automatically on adjacent cells if you use one of these functions. We call dynamic functions, functions that are automatically resized in Excel and in Mind using the MM_GETRANGE fun...
0 min reading timeMM_SIMULATE_MS_TRUNC function
Description Simulates a truncated probability distribution using the mean and standard deviation. Syntax =MM_SIMULATE_TRUNC("DistName", Mean, StdDev, Param3, LowerBound, UpperBound) "DistName" String. Name of the distribution you want to simulate. Mean Mean of the initial distribution. StdDev Standard deviation of the initial distribution. Param3...
0 min reading timeMM_RANDOMSAMPLE function
Description Returns a random integer between two specified numbers. You can choose to sample integers without replacement through simulations. Syntax =MM_RANDOMSAMPLE([WithReplacement], [Min,Max])=MM_RANDOMSAMPLE([WithReplacement], [Min,Max]) WithReplacement (optional) Boolean value.TRUE: The sampling is done with replacement.FALSE: The sampling is ...
0 min reading timeMM_SORTRANGE function
Description MM_SORTRANGE sorts a target multidimensional range. Syntax =MM_SORTRANGE(Obj, SortingOrderObj,[Name, Index],[Name2, Index2],..) Obj: Range on which you want to perform sorting. SortingOrderObj: Sorting order: True=ascending, False= descending Name: Name of your dimension loop (optional) Index: Index of your loop (optional) Warning: The ...
0 min reading timeMM_ITERATIONS function
Description Defines iterations on the workbook on which the function is used. To learn more about iterations, check the general article on iterations. Syntax =MM_ITERATIONS("Name", Size) Remarks The function can only be used once per workbook. Example The function MM_ITERATIONS("Projection Step", 5) creates iteration on the workbook on which it is d...
0 min reading timeMulticore strategy for calculations
Calculations in Milliman Mind are parallelized using multiple threads of execution. The strategy used to spread the calculations into threads can be modified in the project settings under the category Run. Different strategy can result in different run time. There is no definite way to determine the most efficient strategy without running the model,...
0 min reading timeMM_CURRENTITERATION function
Description Returns the index of the iteration that is selected or if not visible, the iteration that is calculated. To learn more about iterations, check the general article on iterations. Syntax =MM_CURRENTITERATION() No parameters. Remarks If the results of a grid with iterations are saved for display on the interface, the function returns the in...
0 min reading timeVersion 5.1.4
Various fixes Corrected an issue where a grid with a name containing the character "/" could not be validated. Corrected the parsing of formula range parameters containing the default separator. Enabled proper redirection when a user has no access to a company. Fixed an issue where instance selection changes when switching steps in workflow mode. Fi...
0 min reading time