Professor Raymond Panko of the University of Hawaii, Honolulu, discovered that people on average make a mistake typing data into one in every hundred "cells" - a location on a grid - of a spreadsheet, which is a piece of software that can build up complex mathematical relationships between any cell. Spreadsheets are routinely used, for example, to analyse variations in financial performance or predict the effect of interest rate changes.
But spreadsheets can be so complex, and rely so heavily on data from a particular cell, that a single error can be disastrous. Professor Panko found over the course of a decade that 30 per cent of all spreadsheets he has examined contain flaws - some serious. If a quantity is entered incorrectly, or the formula linking one cell to another is written wrongly, the result can be far from correct. "Human beings do not err often," he says in today's New Scientist. "But in large spreadsheets with many hundreds of cells, the normal human error rate is fatal."Reuse content