
Spreadsheets are used by insurers for many different activities. At Optalitix, we believe that the IP built into these spreadsheets is valuable and a core component of each company’s enterprise value. The value provided by these spreadsheets can be significantly enhanced by converting the spreadsheet into a system using a product like Optalitix Models. In this series, we will be highlighting the use cases we have witnessed, and how they add real value to insurers and their analytics d out more about Optalitix Models
Create a pricing system from a spreadsheet model

Pricing models are some of the most frequent use cases we encounter for spreadsheet use in insurance. Setting a price for a new product is often an iterative procedure, requiring a number of different changes to ensure the results meet requirements Spreadsheets are a useful tool to create a first pricing models because they are so easy to adapt, and act as a first pass at the final system. These spreadsheets are then converted into a coded system, involving significant investment or kept as single use systems inhibiting scale. Optalitix Models offers an improved solution to this. Spreadsheets are converted more quickly (in under 5 minutes) into scalable API driven systems with the Optalitix low-code solution. The benefits of this approach to building pricing systems are:
- Significant reduction in build time and costs
- Allows Excel developers to create systems.
- Scale pricing models to allow for multiple users
- Remove development bottlenecks
Optalitix created a cyber insurance pricing model that considers key risk factors for a business to determine the risk price to be charged. The model has tables with rating factors in different tabs, as you would expect from a pricing model. It took minutes to convert the models into an API that can be connected to existing websites or that broker aggregators can connect to. It can simultaneously be embedded in existing websites.
Create a claims triage system using Excel logic
With claims, departments need to be able to filter out valid claims and pay them quickly amongst other tasks. See how Excel helps make a claims triage system.

Boost sales with an insight sales model
Generating sales will often cost time and money, particularly in the insurance sector. Learn how smart tools can help manage costs using Optalitix Models here.
Create a claims forecasting system
Calculating claims is vital for insurers as it can take months or even years for the claim payments after an insurance event to emerge. Learn more now.
Create a pricing application from a spreadsheet pricing model
When setting a price for a new product, the starting point is almost always Excel. Find out how to create a pricing application from a spreadsheet pricing model here.

Optalitix Models Use Cases
Insurance often involves using pricing models in spreadsheets. Use Optalitix Models to simplify processes by transforming these spreadsheets into a system.
Is the future of Lloyd’s algorithmic? - Part 2
Smart Follow underwriting and the algorithmic technology will bring a revolution of improved pricing and lower costs to insuring large and complex risks.
Is the future of Lloyd’s algorithmic? - Part 1
Take a look at a report that considers the impact of algorithmic underwriting on Lloyd’s and the London Market where complex risks are often underwritten..
Optalitix and Almagro Capital announce a new partnership that provides Almagro Capital with a rapid online quoting tool for its forthcoming expansion
Optalitix and Almagro Capital have agreed to partner to create improved pricing tools for Almagro and its brokers. Read more about their partnership in here.
The emergence of digital exchanges in the London Insurance Market
The Optalitix team were invited to contribute to a discussion where the digitisation on the underwriting process for the London Market. Read our insights here.
Iotatech and Optalitix announce the successful integration of their products providing significant added value to Iotatech’s clients
Iotatech and Optalitix are pleased to announce the successful integration of their platforms aimed at creating added value for clients of the Iotatech Platform.

Case Study: Catastrophe Reporting - Lloyd's of London
Learn how the London market could benefit from greater levels of digitisation and automation by converting data into cloud-based systems using low code software
Verto syndicate 2689 and Optalitix announce partnership - Press Release
Verto syndicate 2689 (Verto), a follow-only Lloyd’s syndicate, and Optalitix, an award-winning Insurtech company providing SaaS software to leading UK insurers.
FCA disrupts the insurance market
The FCA has changed the game for more established players in the insurance sector with its significant gear change in pricing for insurance business. Read more.
Optalitix Quote, the innovative new product for underwriters
Optalitix Quote is a new cloud product that enables underwriters using spreadsheets to improve their pricing processes. Learn more about it in this handy guide.
Insurance innovation – what will 2022 bring?
What might we expect for insurance in 2022? From digital insurance marketplaces to wellness products and profitability, read our predictions and more.