Navigate today’s most pressing health industry challenges with a leading global expert by your side.
ACO utilization & cost evaluation
Healthcare cost modeling
Preventive digital health
Insurance risk assessment
Medicare plan selection solution
Healthcare risk adjustment
Meet growing needs for innovative insurance solutions while increasing operational health and improving compliance.
Property & casualty advisory services
Modern flood insurance program
Investment, advisory & trading services
Financial modeling & industrialization
Geographic rating insights
Premium comparison platform
Retirement & Benefits
Deliver on the promises of the past and create smart solutions for the future.
Pension administration & communication
Retirement benefits administration platform
Compensations & benefits
Benefit plan evaluation
Health & welfare benefits administration platform
Manage complex risks using data-driven insights, advanced approaches, and deep industry experience.
Auto policy underwriting
Software performance enhancement
Mortgage platform for investments & reinsurance
Solvency II reporting & compliance
This is a place where your ideas and insights make an impact. Where an independent, entrepreneurial spirit is an advantage. And where diversity of thought and experience makes us who we are.
Data-driven insight. Deep expertise. Transformative innovation. Since 1947, Milliman has delivered intelligent solutions to improve health and financial security.
Frequently asked questions
Term discount rates are updated yearly by several sources and are available within the Arius Stochastic module for discounting stochastic estimates. You can download the latest rate tables below.
Download the ZIP file below to your computer. Unzip the three CSV files and place them in the same location as the prior discount rate tables (CSV files). For most users this will be
Once unzipped and stored in the \ConfigurationData directory, the new rates will be available in Model Options on the Term Discount tab under “Get rates from File.”
2019 Rates (for use in 2020):
SST YE2019 Risk Free Yield Curve (TermRates_19SST.csv)
EIOPA YE2019 Basic RFR Curves - With volatility adjustment (TermRates_19 w volatility adj.csv)
EIOPA YE2019 Basic RFR Curves - No volatility adjustment (TermRates_19 wo volatility adj.csv)
Download the 2019 discount rates here.
What do I need to do in my Arius files so that I can take advantage of the various Actual vs Expected tools in future periods?
There are several different approaches to estimating “expected” amounts for comparison with your actuals. The different tools are designed to help you evaluate and understand the effectiveness of different selections and approaches used in the prior Arius analysis file.
You can learn more about the various approaches and how they work here, or from the Help|User Documentation menu within Arius.
If you have an understanding of the tools available and just want a quick checklist of steps you should take to make sure your file is properly set up for estimating expecteds in the next period, a “Quick Tips” document is available here, and also from the system’s Help|User Documentation menu.
Arius incorporates segment names into the names of PDF files when using Export to PDF, and in Excel worksheet names and range names when using Export to Excel or API examples. Windows standard naming conventions apply; therefore, it is important to consider these Microsoft constraints when choosing your segment names.
Note: This only applies to versions of Arius prior to v2019a.
How do I resolve the error “Run time error 429: ActiveX component can’t create object” when trying to use the Arius API with my 64-bit version of Excel?
Before version 2019a, Arius was a 32-bit application. Those earlier versions will communicate with other 32-bit applications by default, but they will need help communicating with 64-bit applications.
In this case, you can make a small change in the registry of your computer to allow the Arius API to work with your 64-bit Excel. Any changes to the registry will require someone with administrator permission on the computer and may need to be approved by your local IT department beforehand.
To update the registry to allow the Arius API to communicate with a 64-bit version of Excel, someone with administrator permissions on the computer should follow the steps below.
Once you have followed the steps above, you can delete api64.reg and the ZIP file from your computer.
Download the registry update here.
The methods I typically use require data inputs that I don’t see listed under the data node in Arius. Can these be customized within the system? What about other exhibits, methods, and reports?
The Object Library lists all of the data arrays, exhibits, methods, and reports that are built into the file. You can also build your own data tables, exhibits, methods, and reports from within the Object Library. Refer to the Arius Deterministic Formula Functions user document for instructions, examples and a complete list of functions available for use in Arius formulas (Help|User Documentation|Formula functions).
I have created some user-defined tables in my Object Library. How do I make these available for use within my collections?
Arius Collections are the groupings that organize your tables and graphs into an efficient workflow on the main interface of the software. The left-hand navigation panel allows you to customize and organize these collections. For example, if you right-click, you can see options to add/edit/delete/rename collections or add/delete/rename folders. You can also drag items to reorganize or reorder collections and folders.
The system provides dozens of collections out of the box and you can also create your own. To create a new collection, you can either copy an existing collection and make modifications or start from scratch. Refer to Tips for Working with Collections on the User Documentation page for guidance (Help|User Documentation|Collections of tables).
I am performing an interim analysis. My last diagonal is a partial period and my most recent exposure period is not fully earned. Can Arius adjust for this?
The Project Settings|Data Structure tab contains a field called "Length of Last Calendar Period." This field defaults to the length of the development period (e.g., 12 months, assuming the last diagonal is a full period); however, it is also possible to import or enter a partial diagonal of data to perform interim analyses (e.g., < 12 months). The system will recognize that the last diagonal is a partial period and will automatically (a) exclude the last diagonal of age-to-age factors from development exhibits and (b) include rows for selecting interpolated development factors on the bottom of all development exhibits.
All of Arius' methods that use development factors use the IfInterpolate function to switch between full period and partial period calculations. If the last diagonal is a partial period, the IfInterpolate function is TRUE and will, therefore, return the first parameter (e.g., Interpolated Selected Development Factors) and if FALSE, will return the second parameter (e.g., Selected Development Factors). All ultimates are projected to a full period ultimate for comparison purposes.
Lastly, in order to adjust for unearned exposure periods, the system prorates the ultimate loss in the "Summary of Reserve Estimates" reports based on the "Proportion Earned" array under Data|Assumptions (in Object Library if not in left navigation pane). The system calculates the adjustment based on your selection from several system-provided earning patterns – uniform, based on exposures, based on premiums – or you can create a user-defined array for something more unique to your data.
I am trying to match interpolation results from Arius to my Excel spreadsheet where I have interpolated my factors using a linear curve fit, but my first factor does not match.
The interpolation approach used in Arius is based on the Average Date of Loss Approximation method. The key to this approach is in the handling of partial periods, i.e., the less than 12 month factor for an accident period or less than 24 month factor for a policy period. This method makes two adjustments: it first adjusts for the maturity of the partial period and it then adjusts for the unearned exposure of the partial period. For example, suppose you have a 3 month accident period evaluated at the end of 3 months. The difference between the evaluation date and average accident date would be 1.5 months. This would be equivalent to a 12 month accident period with an average accident date of 6 months, evaluated at 7.5 months. The system then multiplies this 3 month-to-ultimate factor times a factor of 4 to account for the remaining 9 months of exposure in order to project a full year ultimate. Refer to the Interpolation user guide for additional details and examples (Help|User Documentation|Interpolation).
Arius allows you to enter a scaling factor that indicates to the system that the amount fields were entered in, say, thousands (e.g., scaling factor = 1000). This scaling factor is important so that particular averages can be displayed with appropriate precision. For example, the system calculates paid severity as (Cumulate ("Paid Loss")/Cumulate ("Closed Claims")) x "Scaling Factor." The scaling factor currently only applies to the Deterministic module and can be found in the Object Library under Data|Assumptions or by pressing the "Source Data" button from any of the tables within the Claim Severity collection, where the scaling factor is used extensively.
I’d like to extrapolate my development factors to select a tail factor, but the options under the Tail Factor Analysis tool are grayed out.
While working within any development exhibit within Arius, you can invoke the Tail Factor Analysis tool. This tool is active and available on the tool bar once you have selected a row of factors to which to fit the appropriate curve(s). To use the tool, do the following:
Arius will fit a curve to your selected data using a least-squares regression approach. You can define how far into the future to extend the calculation, modify or omit factors, and graph the resulting curve fits. The results are then included back on the original exhibit for those curves you select to "Show on Exhibit" (see the check boxes above the graph). To zoom in on the graph, right click on the graph and select to "Enable Zoom." Refer to the Tail Factor Analysis user guide for additional details (Help|User Documentation|Tail factor analysis).
What is the purpose of the box-whisker plot, and what are the calculations behind this graph?
The box-whisker plots available from any development exhibit within the deterministic module provide a visual representation of the variability of the age-to-age factors at each age of maturity. Statistics assumes that your observations are clustered around some central value, so the "box" represents the interquartile range (IQR) or the range of factors from the 25th to 75th percentile, and the horizontal line represents the median value. Lower and upper "fences" help identify potential outliers; the fences are calculated as a multiple of 1.5 times the length of the IQR below the 25th percentile and above the 75th percentile. The plot’s whiskers extend to the lowest observation within the lower "fence" and the highest observation within the upper "fence." Any observations outside the "fences" are marked as potential outliers. See the figure below.
Possible outliers are depicted by orange markers. To see the effect of excluding an outlier from your statistics, highlight the corresponding age-to-age factor on your exhibit, right-click, and select "Exclude Factor(s) from Exhibits." This strikes through the factor on the table, automatically excludes the factor from all statistics calculations below, and adjusts the box-whisker plot accordingly.
The green markers are your selected factors. You can identify potential bias in these selections by observing for patterns in where your selection points fall within the various graphs.
I am a ReservePro user wishing to migrate to Arius. How do I get started?
In Arius, select File|New|Create a new Arius project from a ReservePro file to import the file structure, settings, user-defined tables, and data associated with a selected file and layer. This will import the following into a new Arius file and create a new segment for data related to this layer:
To import additional ReservePro files/layers with the same structure into new segments in your Arius file, select File|New|Create a new segment in the current Arius project from a ReservePro file. This will import data into system tables and into existing user-defined tables wherever possible.
I am trying to import user-defined tables from ReservePro into Arius, but Arius is not accepting some of the formulas.
Arius will import user-defined tables from ReservePro in most cases, but there are certain situations when formulas acceptable in ReservePro become unacceptable in Arius. To identify these situations, we advise you to edit each user-defined table and click through all columns of methods and reports to ensure no error messages are displayed. Here is a list of items to help troubleshoot these situations:
I used Interpolation in ReservePro, but noticed some of the settings are not available under Exhibit Options in Arius.
Many of the interpolation settings are handled automatically in Arius and, therefore, fewer settings need to be made under the Exhibit Options|Interpolated Factors tab.
How do I resolve the error “Run time error 429: ActiveX component can’t create object” when trying to use the TriangleMaker API with my 64-bit version of Excel?
The TriangleMaker API is a 32-bit application, so it will need a small change in the registry of your computer to allow it to communicate with your 64-bit Excel. Any changes to the registry will require someone with administrator permission on the computer and may need to be approved by your local IT department beforehand.
To update your registry to allow the TriangleMaker-specific API examples to communicate with a 64-bit version of Excel, have someone with administrator permissions follow the steps below.
Once you have followed the steps above, you can delete tmapi64.reg and the ZIP file from your computer.
It’s important to us that you get the most possible benefit from our solutions. Let’s chat about what’s going on with your software and how we can help.