The spreadsheet is a tool, but it is also a worldview -- reality by the numbers

Spreadsheets do not lie. They merely obey every stupid assumption with magnificent precision.

Revenue fits in a cell. So do headcount and conversion. Trust, morale, tacit knowledge and the maintenance that prevented yesterday’s disaster are awkward guests, so the model quietly seats them outside. Soon the measurable part is treated as the whole business and whatever resists a column becomes “soft”.

Thus support costs fall while customers wait longer. Brand investment loses to clicks whose delay is easier to ignore. A staffing model counts two employees as two units, even when one joined last Tuesday and the other knows which ancient server catches fire when somebody uploads a semicolon. A quarterly saving can look immaculate while quietly borrowing from next year’s resilience. The formula is correct. The decision is still daft.

Before admiring a forecast, ask what cannot enter it, who experiences that absence and when the missing cost arrives. Use scenarios instead of one immaculate future. Put operational stories beside aggregates. Track delayed consequences as aggressively as immediate savings. Let the model inform judgement without defining what judgement is permitted to notice. A spreadsheet is an excellent calculator and a terrible constitution. Reality does not forfeit voting rights because it lacks a convenient column.

Behavioural principles

Behavioural ideas at play in this post

Short, plain-English explanations of the principles behind this post, with links to related books and examples in the archive.