Blog

Blog

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 spreadsheets people create can be fragile. Spreadsheet errors 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

VLOOKUP of a VLOOKUP?

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 agothe 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

Microsoft Excel and BCBS 239 – 7 Steps to transform your End User Compute (EUC) capability

March 01, 2017 | Darren Harris
September 15th 2008, the day that Lehman Brothers Holdings Inc. filed for Chapter 11bankruptcy protection was another significant milestone in the global financial crisis that began in 2007. For those of us working at Credit Suisse during this entire period, fire drills [urgent business requests] were an hourly occurrence as we fought to respond to ad-hoc requests from the business in the face of swinging markets and creaking models (negative interest rates anyone?). Read More

Data Links, Viewer and a little bit of Magic brought to Microsoft Excel.

September 29, 2016 | Darren Harris
When introducing the Workbench to someone for the first time, we typically start by explaining two innovations that we’ve introduced into Excel called ‘Data Links’ and the ‘Viewer’. Grasping these concepts is.. Read More

csv,conf,v2

July 05, 2016 | Jonathan Glass
A couple of weeks ago, two of us attended “csv,conf”, a two-day conference dedicated to all things CSV-related, as well as the wider ethos embodied by data formats that are easy to share and easy for humans, as well as computers, to work with.  Read More

Too Many Grades!

April 15, 2016 | Kevin Crooks
How long is a piece of string? Have you ever heard that question? A common answer is “twice as long as from one end to the middle”, but perhaps an overlooked response is “according to which unit of measurement?”.  Read More