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 Manager also ensures the inputs are reliable for each file with the possibility to set files as “required” and “validated”.

Define grids as Input

In your model, you can turn any grid that is assumptions-only into an Input grid.

Just open your Excel file, and add the flag /Input to the grid name. For example:

Then upload your model to Milliman Mind as usual.

Access the input manager

The Input manager is available directly in the project top navigation bar.

The Input manager popup appears and displays all the available inputs of the project.

Download input samples

You can download a sample of your inputs as CSV files to edit them more easily.

Two options are available:

• Download file by file.

• Download all files of the project. This feature might not work for very big models.

Please find in the screenshot how to access those two features:

Set an input required

You can set an input as REQUIRED. This will throw an alert during run if no file have been uploaded for this input. Just check the Req. checkbox to set an input as required.

Upload CSVs to match inputs

Set up files

You can upload a full file tree (folders in folders) of CSV files to import your inputs.

Set up your files within folders if you want or just on a root folder.

For better file recognition, your input files should have:

• The same name as the grid (Or InstanceName.Name if there are instances). Look at Input manager import with specific names‍ 

• .csv or .txt extension

Upload files

Two ways to upload files:

• First select delimiter wanted and culture of the file.

• Click on Browse file(s) and select a folder on your computer.

• Or Drag and drop files and/or folders directly on the drop zone (green area).

If your model has instances and you want to use the Instance Split feature, turn on the Instance split switch before dropping/selecting files.

Your files will then be uploaded.

Match unmatched grids

If Milliman Mind artificial intelligence system cannot match a CSV file with a grid, it will display a matching popup to define which file goes with which grid.

Select to match (or not) each file with available grids using the dropdown.

Then click on Match unmatched inputs.

Resize of grids

You just need to wait for Mind to automatically resize all your models to match the new input files.

If your model has /Resize grids, they will be also automatically resized.

CSV Imports and Instances

/InstanceSplit flag has two different effects when populating a grid:

• If you want to import one only .csv to update all your grid's instances (usual case need one .csv / instance).

• If you want to import one file populating all instances with specific data per instance. Milliman Mind will read .csv first column to match the line with the instance key defined in the first column.

There are three cases when populating a grid with instances:

• Case 1 - Grid without /InstanceSplit
  - Only one way to populate this grid: 1 CSV file per instance
  - Name of the CSV should be "InstanceName-GridName.csv" for auto-match
  - Only instances with a matching .csv will be updated
  - Every line of the imported .csv for the instance will be applied to the instance chosen.

• Case 2.1 - Grid with /InstanceSplit and import of one .csv for all instances by activating the Split switch
  - Name of the CSV should be "GridName.csv" for auto-match
  - All instances of the grid are updated
  - Each instance is populated by lines of .csv where the 1st column is the instance key:
  If .csv contains no line with a specific instance key on the first column, the grid will be empty for this instance.
  If for some lines, the first column content doesn't match any existing instance, these lines will be skipped.

• Case 2.2 - Grid with /InstanceSplut and import of one .csv per instance by deactivating the Split switch
  - Name of CSV(s) should be "InstanceName-GridName.csv" for auto-match
  - Only instances with imported .csv will be updated
  - For one instance, only lines of the .csv where the first column contains the instance key looked for will be applied:
  If there is no line in the .csv where the first column content matches the instance key, the grid will be empty for this instance.
  If for some lines, the first column content doesn't match the current instance key, these lines will be skipped.

Features for uploaded inputs

The input manager will display:

• A green Success tag for successfully uploaded inputs.

• A red Error tag for inputs that encountered errors during resize and validation. You can display log of errors by clicking on LOG.

Display a preview of the uploaded CSV by clicking on the Eye icon next to the filename.

Delete/clear an input by clicking on the red trash button.

Validate an input

When an input has been validated by the grid responsible, check the Validated checkbox.

It will prevent further changes of this input, undo from the audit trail and give the indication to other users.

Inputs grids in Mind

Input grids have a specific display in Mind. They will be:

• Read-only and cannot be linked or erased by an imported CSV other than through the Input Manager.

• Displayed in Green.

Control of inputs format

In the settings of your project, you can turn on a setting to add input format validation to the Input Manager. This feature will check your CSV or TXT input formats to be sure that it corresponds to the original grid format of your Excel file.

To turn it on, go to Settings > Other and turn on this option:

You will be asked then to choose a strategy when inputs do not match the Excel format of your original grid: Either raise a warning or reject the file.

All the newly imported inputs will be then analyzed and if one of the cells of the input doesn't match the original format, it will follow the policy you've decided.

New display features

Some new display features have been added to the Input manager:

• First options allows to sort all inputs alphabetically, removing the models/spreadsheet layers from the list.
• Second option will display all the time the upload information fo each of your inputs (who imported it and when).

Those two options can be activated in the Settings panel > Other settings.