Grids, Sheets and Narratives

David Galbraith
Apr 12, 2018 · 2 min read

Design improvements to the three most powerful end user productivity tools.

  1. Grids

An error prone design

An alarming amount of the world’s financial system runs on spreadsheets, where relationships between elements and the source of data and formulas are buried and prone to error from mistakes in creating them, purely because of inherent product design reasons — the spreadsheet model currently mixes presentation with meaning and doesn’t make relationships visible at a glance.

In addition, the underlying relationships and formulas are attached to a two dimensional grid, so they cannot be serialised into a linear format, to debug the logic, in the way that most software can be.

That everyone likes to use

And yet, despite this, the flexible grid turns out to be incredibly user friendly and familiar way to model quantitative data. It’s a simple, flat file, end user, database creation tool. Visual relational database systems like FileMaker never took off the way that spreadsheets did and the grid model is not going to go away.

Which has an underlying structural design flaw

Just as a rigorous software language should be strongly typed to avoid underlying errors in the meaning of data, in a spreadsheet interface, all style elements should relate to the underlying data and have some meaning. For example, changing the look of an element to bold should mean something, it shouldn’t just be to look pretty. And the relationships between cells and even external data should be easily visualisable.

Examples: a $ sign next to a number should mean that the number has to be a currency; red text (or whatever style element is chosen and fixed at the time of shipping the software) could mean that a cell’s contents are formula derived rather than hardcoded and what cells contribute to the calculation should also be visible somehow.

Below Are some examples of this:

In summary: spreadsheet design could be improved by making all presentation relate to underlying meaning and making all relationships visually understandable, including those to external sources.

Design Matters

The design of everything, from websites to cities, with a focus on Venture Design in Financial Services.

David Galbraith

Written by

Architect: I used to design buildings, now I design companies. http://davidgalbraith.org

Design Matters

The design of everything, from websites to cities, with a focus on Venture Design in Financial Services.