System Requirements

• Actuarial Toolkit is fully supported on Microsoft Excel for Microsoft 365 (Windows desktop version).

• Actuarial Toolkit may function on Excel 2019, Excel 2021, and Excel 2024 for Windows; however, these versions have not been fully tested and are not officially supported. Users on non-supported versions may encounter compatibility limitations, and technical support is provided only for Microsoft 365 on Windows.

• Actuarial Toolkit is not supported on Excel for Mac, Excel Online, or mobile versions of Excel.

Summarize data

The Summarize Data Tool brings the power of SQL-style aggregation into an intuitive Excel form. Instead of writing code, you can visually build summaries directly from your Excel data by selecting grouping variables, summary fields, and desired metrics.

Quickly choose your key fields (group by variables), select one or more summary variables, and generate metrics such as sum, mean, count, standard deviation, minimum, and maximum for every unique combination of selected keys.

The tool automatically creates the formulas for you in seconds, producing flexible outputs that remain editable and transparent.

Compared to pivot tables, the Summarize Data Tool is often faster, cleaner, and easier to customize—making it ideal for users who want powerful summaries without the clunky setup.

Perfect for:

• SQL-style summaries without writing SQL

• Fast ad-hoc analysis on Excel datasets

• Counts, density checks, and data validation by segment

• Building tables for larger actuarial or financial models

• Live data summaries during meetings or client calls

• Presentation-ready outputs in seconds

A powerful way to summarize data visually inside Excel while keeping full control of your formulas and results.

Lag development

Build actuarial development triangles in seconds with a flexible, transparent tool designed for fast reserving analysis and ad-hoc data exploration.

The Lag Development Tool allows you to select two dates that define development timing—commonly service date and paid date in health insurance, accident date and paid date in property & casualty insurance, or incident date and paid date in AD&D insurance. Dates can be aggregated at the day, month, or year level depending on the analysis needed.

Next, choose your development metric—such as loss amount, paid amount, allowed amount, claim count, or another measure—and select the desired level of aggregation.

The tool automatically builds a full chain ladder style development model with editable Excel formulas, including:

• Initial lag development triangle

• Age-to-age development factors

• Flexible factor selections with custom averaging options

• Completion factors and ultimate summaries

• Total rollforwards and diagnostics

Unlike rigid reserving systems, every output remains transparent and fully customizable.

Additional advantages include:

• Swap origin and development axes with ease

• Include exposure inputs for benchmarking and ratios

• Analyze alternative development measures (loss amount, paid amount, allowed amount, counts, etc.)

• Study different lag relationships (received-to-paid, reported-to-paid, adjudicated-to-paid, service-to-paid, and more)

• Handle imperfect or one-off datasets that may not fit standard reserving models

• Instantly rebuild triangles using different date combinations or aggregation levels

Whether you already have a formal reserving platform or need a starting point, the Lag Development Tool provides a fast and powerful way to understand payment patterns, generate completion factors, and perform flexible actuarial analysis directly in Excel.

Trend setup

The Trend Setup Tool helps actuaries efficiently prepare trending analyses by automating the formula setup process. Choose the base period that reflects your source data, select up to five future periods to trend to, define applicable trend assumptions, and let the tool build the formulas for you.

Designed for flexibility across insurance lines, the tool helps standardize trend calculations while reducing repetitive spreadsheet work.

Example Trend Types by Industry

Healthcare

• Unit Cost Trend

• Utilization per 1,000 Trend

• Severity Trend

• Frequency Trend

• Mix / Demographic Trend

Property & Casualty

• Claim Severity Trend

• Claim Frequency Trend

• Exposure Trend

• Premium Trend

• Loss Cost Trend

Life Insurance

• Mortality Improvement Trend

• Lapse Trend

• Premium Growth Trend

• Incidence Trend

• Benefit Utilization Trend

Key Features

Select a base experience period and trend to up to five future periods simultaneously while applying up to five independent trend categories. Automatically create midpoint-to-midpoint trending formulas, choose which variables receive trend adjustments, and compare base period values to projected periods side-by-side. Reduce manual formula setup and spreadsheet errors with a flexible design that can be used across healthcare, P&C, life, and other insurance applications.

Why It Matters

Trending often requires repetitive date logic, linked formulas, and consistent assumption application across many variables. The Trend Setup Tool turns that into a faster, cleaner, and more reliable workflow.

Practical Use Cases

• Pricing and rate development

• Forecasting and budgeting

• Experience study adjustments

• Renewal analyses

• Scenario testing under alternative trend assumptions

• Multi-line actuarial modeling

Graph setup

The Graph Setup Tool transforms raw data into flexible, interactive visual analysis. Choose an x-axis variable, select any number of y-axis lines, and apply filters that instantly update the graph based on your selected values.

What makes this tool especially powerful is the ability to combine aggregations, formulas, and filter logic for each line Build advanced graphs that often require complex SQL or manual spreadsheet work—without writing code.

Whether analyzing health insurance companies claims, property & casualty insurance carriers results, or life insurance companies experience data, the Graph Setup Tool helps turn datasets into decision-ready visuals.

Key Features

Choose any variable for the x-axis, including automatic conversion of date fields into monthly or yearly periods. Select multiple y-axis lines and summarize each using sum, average, minimum, maximum, or count logic. Add any number of filter variables, with all available values dynamically presented below the graph for instant selection. Create custom formulas for each line, apply mathematical operations between variables, and control which filters each metric should follow. Explore complex relationships interactively without coding or manual graph rebuilding.

Why It Matters

Many graphing tools are limited to simple pivots or static dashboards. The Graph Setup Tool combines filtering flexibility, custom formulas, and aggregation logic into one fast workflow—making advanced analysis much easier to build and reuse.

Practical Example

A healthcare analyst may graph paid amount per member per month by month, filtered by:

• Population Cohort: Adult / Child

• Service Category: Inpatient / ER / Outpatient

Paid amount can follow all filters, while member months only follow the population filter—allowing accurate PMPM calculations directly in the graph setup.

Practical Use Cases

• Claims cost trends by category

• Utilization dashboards

• P&L or premium tracking

• Population cohort comparisons

• Frequency / severity monitoring

• Scenario and what-if analysis

• Executive-ready visual summaries

Shortcut tools

The Shortcut Tools are lightweight utilities built for speed. Whether you're in a meeting, brainstorming ideas, reviewing numbers live, or cleaning up worksheets, these tools help you get answers and complete common tasks in seconds.

They’re the kind of quick helpers that save time repeatedly throughout the day.

Included Shortcut Tools:

Trend Solver
Select a current value, target value, and number of years to instantly calculate the annualized trend required.

Compare Numbers
Select two numbers in your worksheet and immediately view percentage changes, differences, ratios, and other useful comparisons.

Table Formatter
Select any range and quickly apply clean header, data, and total-row formatting for polished presentation-ready tables.

Sheet View
See all visible and hidden worksheets in one place and move sheets between views instantly for easier workbook management.

Why It Matters

Small repetitive tasks can interrupt momentum. The Shortcut Tools reduce friction so you can stay focused on analysis instead of mechanics.

Practical Use Cases

• Live meeting calculations

• Quick what-if comparisons

• Brainstorming sessions

• Cleaning up exhibits

• Navigating large workbooks

• Fast trend calculations