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 line. Must be text and will be displayed in the interface.

Type

The type for this parameter line. There is for the moment 9 different types, each with different behavior:

• number
  A number input between a min and max value. The value will be displayed in a field that can be modified by arrow buttons or directly in the cell. The step for the buttons can be chosen (optional).
• text
  A string input.
• switch
  A switch. The value is equal to "true" if the switch is ON and "false" if it is OFF. In Excel, use "true" or "false".
• checkbox
  A list of checkboxes with possible multiple choices.
• radio
  A list of items (similar to checkboxes) but where only one item can be selected.
• slider
  A slider of numbers with a step of 1 (by default, can be customized) between a min and max value.
• dropdown
  A dropdown list choice of strings.
• percentage
  A percentage input between a min and max value, with a step to choose (optional).
• date
  A date picker.

PossibleValues

The possible values for this parameter:

• Number: Defining min/max(/step) following this structure min|max or min|max|step (for example 1|100|0.5)
• Text: field not required
• Switch: field not required
• Checkbox/Radio: The list of items separated by a pipe | (for example car|boat|motorbike)
• Slider: Defining min/max(/step) following this structure min|max or min|max|step (for example 1|100|0.5)
• Percentage: Defining min/max(/step) following this structure min|max or min|max|step (for example 1|100|0.5)
• Dropdown: The list of items separated by a pipe | (for example car|boat|motorbike)
• Date: field not required

Values (or any other name)

The columns starting from the fourth column of the table are the values displayed in the editor. After importing the model, the initial values displayed are the values in Excel, the latter can be left blank. For the checkbox, the value must be a string with the elements separated by pipes (|); the elements must be part of the possible values.

Each of those cells will be updated when the user saves their changes in the parameter editor displayed in Mind; thus, your formulas should refer to these cells to take into account user changes.

You can have as many columns as you want, the interface will allow you to switch from one to another with a dropdown list.

You will be able to dynamically add or remove columns directly in Milliman Mind too.

Please refer to the parameter editor section on the Projects' page for more information.

You can download an example file of the parameters editor there:

ParametersExample.xlsx