Episode 606: Spreadsheets!
This Planet Money episode traces how Dan Bricklin invented the electronic spreadsheet in the late 1970s to automate tedious accounting calculations, and examines a 1984 article's warning that spreadsheets represent more than just a tool—they embody a worldview where "reality by the numbers" dominates decision-making.
- Before electronic spreadsheets, accountants manually calculated business finances on giant paper sheets taped together; a single change to one number could take a full day to recalculate across all columns and tax implications.
- Dan Bricklin, bored in a Harvard Business School class, conceived the idea for an electronic spreadsheet that would instantly recalculate when numbers changed—he built a prototype for the Apple II using Pong game controllers as input devices.
- Steven Levy's 1984 article warned that spreadsheets would transform how people think about reality itself, reducing complex business decisions to numerical models rather than broader judgment.
Before electronic spreadsheets existed, accountants like Allen Sneider worked with physical sheets of paper—sometimes taped together across an entire desk—to track business finances. Building a single spreadsheet took days and involved hundreds of interconnected numbers. The real nightmare came when a client asked for even minor changes. Sneider would grab an eraser, recalculate everything by hand with a calculator, then manually update every affected column. A single "what if" question from a factory owner could consume an entire day of tedious arithmetic.
In the late 1970s, Dan Bricklin was sitting in a Harvard Business School lecture, watching a professor do spreadsheet math on a blackboard, when he had a simple thought: what if you could erase a number, write a new one, and have everything recalculate automatically? The Apple II had just launched—a computer small enough to sit on a desk, though most people dismissed it as a toy. Bricklin saw its potential as his "magic blackboard." He wrote a program using the Apple II's Pong paddle controllers (which he later ditched for arrow keys) that let users move around cells, input numbers, and watch the computer recalculate instantly with its distinctive beeping sounds.
The spreadsheet's impact went far beyond saving accountants from erasers and calculators. A 1984 article by Steven Levy observed that the spreadsheet wasn't just a tool—it was "a worldview: reality by the numbers." The episode explores what happens when businesses start thinking of everything through numerical calculation, and how that shift fundamentally changed how we see and run organizations.