Options available to convert spreadsheetsThere are 3 options available to do this:Option 1: Recoding the system into another languageThis requires a full system build to replicate the underlying logic in the spreadsheet. This will require the developer to work alongside the model builder to explain the spreadsheet logic and check the results.+ Internal developer team can do it without requiring external systems– Cost is prohibitive (developer and pricing expertise required)– large volumes of models to convert which takes too much time– modelling errors are common– resources are unavailable– systems are hard and expensive to update when models changeOption 2: Use an existing commercial pricing platform to recode the spreadsheetThere are a number of software platforms that provide standard tools to help developers create pricing systems. These often have their own internal language and structures to reduce the time taken for the build, with experts on these systems needed to create and maintain the pricing system.+ commercial pricing platforms have tools that reduce the time required to recode the spreadsheet+ these tools have methods of checking for errors– Recoding spreadsheets remains difficult in these systems– The cost of the platform can be high– identifying developers who know the pricing system can be trickier than finding standard developersOption 3: Use an Excel converterAn Excel converter is new technology that allows the user to upload an Excel model and instantly convert it into a hosted system. This reduces the cost of the build and removes the need for developer involvement except for the integration to the core system.+ there is a significant reduction in the conversion time required per model (minutes rather than months per model)+ updates to the models can be done in Excel and automatically update in the system+ testing and debugging can be done against the spreadsheet while the Excel developer continues to maintain their own models– Integrating with other systems can be cumbersome as some Excel converters don’t work with all Excel models– There may be a system requirement to design screens for data inputs if not provided by the tool

Filter by
Reset
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
No items found.
Optalitix are Insurance Times Awards Gold Winner - Release

Optalitix are Insurance Times Awards Gold Winner - Release

Optalitix wins the Gold award for Excellence in Technology – Service Provider (General) category at the 2021 prestigious Insurance Times Awards. Read more here.

Underwriting
Insurance

The role of an underwriter should not be underestimated

The multi-faceted contribution an underwriter makes to any insurance business transcends simply assessing risk. Read more about underwriting and the impact of it.

Insurance
Changes to FCA Insurance Pricing

Changes to FCA Insurance Pricing

New rules from 2022 ensure customers who are renewing their insurance policies receive a quote no more than they would be quoted as a new customer. Read more.

No items found.
The future of systems with embedded Excel models

The future of systems with embedded Excel models

The ease with which Excel models can now be converted and the number available requires a new age of system design. Find out more in this guide.

Insurance
Convert pricing models using an Excel converter.

Convert pricing models using an Excel converter.

Optalitix have determined that using Excel converters to convert pricing models is the most efficient and effective method. Take a look at the features and more.

No items found.
Converting Spreadsheets - The 3 Options

Converting Spreadsheets - The 3 Options

At Optalitix, we are able to convert spreadsheets in 3 ways: by recoding the system, using an existing commercial platform, or using an Excel converter.

Insurance
Spreadsheet models need to go digital

Spreadsheet models need to go digital

Spreadsheets should move to cloud-based systems in order to benefit from rich features such as dashboards, databases and seamlessly integrated AI and automation.

No items found.
Spreadsheet dependancy and pricing

Spreadsheet dependancy and pricing

Spreadsheets are frequently used for pricing due to their ability to build complex calculations quickly in a flexible coding environment. Read our guide now.

No items found.
Optalitix powered United Trust Bank’s step into the future with instant mortgage decisioning

Optalitix powered United Trust Bank’s step into the future with instant mortgage decisioning

The mortgage market is always changing. Few banks are able to offer an instant decision on a mortgage, yet the United Trust Bank (UTB) is one of them. Read more.

No items found.
Five reasons why pricing in the cloud will increase sales

Five reasons why pricing in the cloud will increase sales

Cloud based pricing ensures that everything from conversion to compliance is streamlined, efficient and controlled ultimately leading to increased sales.

No items found.
Spreadsheet Sense Check

Spreadsheet Sense Check

As business strategy evolves and growth is more dependent on cloud based tools like AI, machine learning and data, the value of spreadsheets might be affected.

No items found.

Big Data Processing for Multiple Insurers

The insurance sector is data rich and decisions are made quickly using real time data. Find out how GoCompare embraced AI to add value to their partner offering.

Insurance
Learn about Lloyd’s Lab – an influential insurtech accelerator

Learn about Lloyd’s Lab – an influential insurtech accelerator

Membership in Lloyd's Lab allowed Optalitix to scale up and develop innovative ideas in collaboration with the world's largest insurance market. Learn more now.

No items found.
Learn about Mass Challenge – a US based start-up accelerator

Learn about Mass Challenge – a US based start-up accelerator

No items found.

A Year of Challenges and Opportunities