Schematiq Detailed Introduction

September 25, 2017 | Darren Harris
Transforming an Option Pricer spreadsheet using Schematiq.  Externalise data held in spreadsheets, simplify complex forumula, increase calculation performance and govern shared spreadsheet logic. Read More

Schematiq Workbench

September 07, 2017 | Darren Harris
Watch our latest video to see how easily Schematiq can transform the way you use Microsoft Excel. Read More

Schematiq converts your Excel Spreadsheets into dynamic API's

August 11, 2017 | Darren Harris
Watch our latest video to see how easily Schematiq can transform your existing Excel spreadsheets into dynamic API's. Read More

Novae Group plc improves their Capital Modelling Process in Microsoft Excel using Schematiq.

July 13, 2017 | Darren Harris
Novae Group, a Lloyd's of London insurer, has been listed on the London Stock Exchange since 1998 and wrote premiums of over £900m in value in 2016. When Novae Group wanted to enhance their Capital planning process the amount and complexity of data meant that their models could only be updated a few times a year.  Read More

Schematiq solves the Top 4 Excel Challenges for Insurance Firms

May 25, 2017 | Darren Harris
  Microsoft Excel is pervasive across the insurance industry, particularly in areas such as capital modelling, forecasting, pricing optimisation, risk management and regulatory reporting. However, while Excel itself is robust, the error prone spreadsheets people create can be fragile. Errors are caused by manual data entry, cutting and pasting data and formula complexity can simply generate wrong numbers.  For insurers, this can lead to incorrect regulatory reporting (under GAAP, IFRS and Solvency II) and material misstatements resulting significant losses, fines and reputational damage. Read More


March 29, 2017 | Neil Talbott
The Excel function VLOOKUP is often described as one of the most used Excel functions yet one of the least well understood. In particular, the question “How doI do a VLOOKUP of a VLOOKUP?” crops up time and time again, for example in the posts on StackOverflow here and here. Read More

Helping IT Love Spreadsheets

March 21, 2017 | Jonathan Glass
If we can learn to consider spreadsheets as apps, and the people who create them as developers, rigorous software engineering practices applied to Excel can solve a significant pain-point for IT. For many people, using Excel to build spreadsheets is the closest they get to being a software developer without needing to learn a programming language.  Read More

Improving on Excel and Access

March 21, 2017 | Mark Jefford
As inseparable as Bonnie and Clyde, Microsoft Excel and Access are often found in cohorts together in the end-user computing world. Their use in any business typically evokes suspicion and fear in ITmanagers and often their exploits in the enterprise leads to a long rap sheet listing their crimes. Read More

How to simplify your spreadsheet – Reusing Common Logic

March 20, 2017 | Kevin Crooks
Despite the popularity of languages such as Python and R, Excel still remains the tool that users turn to for data manipulation and data formatting tasks. There are a number of things that users loveabout Excel. In particular it allows you to look through a spreadsheet step-by-step and see how a change propagates through your data in real-time. Read More

Can't Excel Do Division?

March 11, 2017 | Neil Talbott
The notoriously fiendish Listener Crossword, first published in 1930 and now printed weekly in the Saturday Times, includes four puzzles a year which are primarily or solely numerical. Three weeks ago the challenge was a puzzle called Can’t You Do Division? by a setter known pseudonymously as Oyler: Short version of this blog post! Read More