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 model, Mind will handle this dimension natively.

But if you are doing any other work in Visual Basic, you will need to rewrite them in C# to be used in Mind.

Your custom C# formulas will replace your VBA functions in your model, and once a formula is added to a company, it will be available for any project created by any company user.

Create new formula

Go to “Extensions” > “C# Formulas” item of the menu. You will access the list of all your custom formulas and their status.

To create a new formula, click the blue “Add Formula +” button. The formula editor will open in a new window. First, name your formula without spaces or special characters except - and _. Please note that names are case-sensitive.

Then, add one or many parameters and use the parameters text area.

Enter the code of your C# function in the editor using the parameters you defined earlier and using C# syntax and rules.

To save your formula, click on the blue button. The formula will need to compile successfully to be used in your projects.

Draft status

If your formula does not compile well when you save it, we will add a Draft tag, which will not be available in projects.

History

You can also access the history of versions of your formula with the dropdown menu at the top of the formula name. A version control system allows you to compare different versions of the same formula.

Help with custom formulas

Indicators

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

Set up custom indicators

You must have administrator rights to create an indicator that will be available for your entire company.

Connect to the administration interface, then click on the "Extensions" > “Indicators” item on the left bar.

A list of indicators will appear. Just click on "Add new indicator" button to add an indicator. Choose between:

• Value at Risk (VaR)
• Tail Value at Risk (TVaR)
• Probability of Ruin (PoR)

Then, enter the indicator's value (a percentage or a number).To delete an indicator, click on the trash button.

To save your indicators, click on “Save”. After updating your indicators, please reload your projects.