Spreadsheet Day
<p>On 17 October 1979 a small Boston software house called Personal Software put a programme on sale for the Apple II that did something no microcomputer had done before: it let you change one number and watch every figure that depended on it rearrange itself in front of your eyes. The programme was VisiCalc, and within a few years it had sold somewhere north of 700,000 copies and convinced a generation of accountants that the strange little machines from California were not toys. Spreadsheet Day, held each year on that anniversary, marks the moment the grid of cells escaped the paper ledger and went electronic.</p>
<h2 id="where-the-day-comes-from">Where the day comes from</h2><div class="ad-unit ad-in-article" aria-label="Advertisement">
<span class="ad-label">Advertisement</span>
<ins class="adsbygoogle" style="display:block;text-align:center"
data-ad-client="ca-pub-3726833845844946"
data-ad-slot="3291553914"
data-ad-format="auto"
data-full-width-responsive="true"></ins>
<script>(adsbygoogle = window.adsbygoogle || []).push({});</script>
</div>
<p>The observance itself is younger and humbler than the software it celebrates. It was proposed in 2010 by Debra Dalgleish, the Canadian Excel expert behind the long-running Contextures website, who suggested that the launch date of VisiCalc deserved an annual nod from the people who spend their working lives in rows and columns. There is no committee, no charity and no trademark behind it; it spread through Excel blogs, accountancy forums and the sort of online communities where a well-built workbook is genuinely admired. That grassroots character suits the subject, because the spreadsheet itself has always been less a glamorous product than a quietly indispensable habit.</p>
<h2 id="the-history-a-harvard-daydream">The history: a Harvard daydream</h2>
<p>The strongest part of this story belongs to the late 1970s and to Dan Bricklin, then a student at Harvard Business School. Watching a professor laboriously rub out and rewrite figures on a blackboard whenever one assumption changed, Bricklin imagined an “electronic blackboard” that would do the recalculation automatically. He sketched the idea, wrote a rough version in a single weekend, and then teamed up with Bob Frankston, an MIT-trained programmer who did much of the heavy coding through the winter of 1978–79, often working overnight when computer time was cheaper. The third figure was Dan Fylstra, whose company Personal Software (later renamed VisiCorp) published the result.</p>
<p>VisiCalc was demonstrated to the trade at the National Computer Conference in New York in June 1979 and went on sale that October. The effect on the Apple II was extraordinary: industry lore holds that a quarter of the Apple IIs sold in 1979 were bought specifically to run it, the clearest example yet of what the trade began calling a “killer application” — software so useful that people purchased an entire computer just to use it. Bricklin and Frankston, famously, never patented the underlying idea, and within a few years rivals had overtaken them. Lotus 1-2-3 arrived in 1983 and dominated the IBM PC era, before Microsoft Excel, first released for the Macintosh in 1985, eventually swept the field. VisiCorp itself did not survive the decade.</p>
<h2 id="how-the-magic-actually-works">How the magic actually works</h2><div class="ad-unit ad-in-article" aria-label="Advertisement">
<span class="ad-label">Advertisement</span>
<ins class="adsbygoogle" style="display:block;text-align:center"
data-ad-client="ca-pub-3726833845844946"
data-ad-slot="3291553914"
data-ad-format="auto"
data-full-width-responsive="true"></ins>
<script>(adsbygoogle = window.adsbygoogle || []).push({});</script>
</div>
<p>Strip away the menus and the spreadsheet is a single elegant idea: a grid in which any cell can hold a number, a label or a formula that refers to other cells. Change a value and every formula that depends on it recalculates instantly, the consequences rippling outward without a single sum being redone by hand. That is what Bricklin’s blackboard daydream delivered. The genuinely revolutionary part was not the arithmetic, which calculators already did, but the ability to ask “what if” — raise the interest rate, cut the marketing budget, add a fourth quarter — and see an entire model respond in real time. A task that had taken a clerk an afternoon of erasing and re-entering became the work of a keystroke.</p>
<h2 id="why-it-matters">Why it matters</h2>
<p>It is easy to underrate the spreadsheet precisely because it is everywhere, in the way one underrates the wheel. Yet it did something subtle to how organisations think. By making “what if” cheap, it encouraged planning by experiment rather than by single fixed forecast, and it put modelling power into the hands of people who could never have commissioned a programmer to write bespoke code. A regional manager could build a budget; a teacher could track a class; a researcher could organise an experiment, all without learning to programme. That democratisation of computation, more than any single feature, is what Spreadsheet Day is really honouring. The same logic underpins the vast administrative grids that run a modern state — the electoral rolls behind an event such as <a href="/specialdate/india-national-voters-day/">India’s National Voters’ Day</a> are, at bottom, enormous tables of records that have to be sorted, checked and totalled, exactly the work the spreadsheet was built to make manageable. The flip side is just as real: badly built spreadsheets have caused genuine disasters, from misplaced decimal points in financial models to the academic paper whose famous conclusions partly rested on a row accidentally left out of a sum. The tool is powerful precisely because it trusts the user, and that trust can be misplaced.</p>
<h2 id="the-succession-wars">The succession wars</h2>
<p>The story after VisiCalc is a small epic of corporate rise and fall that Spreadsheet Day tends to gloss over. Lotus 1-2-3, released in 1983 by Lotus Development Corporation, did to VisiCalc roughly what VisiCalc had done to the paper ledger: it combined the spreadsheet with charting and basic database functions, ran faster on the new IBM PC, and became the dominant business application of the 1980s, so ubiquitous that “1-2-3” was practically a synonym for the genre. Lotus in turn was caught out by the shift to graphical interfaces. Microsoft had released Excel for the Apple Macintosh in 1985, building it from the start for a mouse and on-screen windows, and when Windows took over the office through the early 1990s Excel was ready and Lotus was not. By the mid-1990s the company that had defined the category was in terminal decline, eventually absorbed by IBM in 1995. The pattern — a pioneer overtaken by a faster follower, which is then overtaken by a rival who reads the next platform shift correctly — is one of the cleanest case studies in technology history, and it all began with three men and an Apple II.</p>
<h2 id="how-it-is-marked">How it is marked</h2>
<p>For an observance about software, the celebrations are appropriately low-key and screen-bound. Accountants, analysts, scientists, teachers and the merely spreadsheet-curious share favourite functions, swap keyboard shortcuts and post tutorials on the day. There is a long tradition of showing off spreadsheets pushed to absurd extremes — playable games coded entirely in cells, pixel-art portraits rendered by conditional formatting, even a working model railway timetable. Some firms use the date as an excuse for an internal “best workbook” contest. For most people it is simply a moment to feel a flicker of affection for a tool they use daily and never think about, rather in the way one might raise a glass to the inventor of the paperclip. It is also worth remembering that the same always-on data culture the spreadsheet helped create has a human cost; the awareness behind observances such as <a href="/specialdate/world-suicide-prevention-day/">World Suicide Prevention Day</a> is a useful counterweight to the assumption that more measurement and more targets are always better, in offices as in life.</p>
<h2 id="from-paper-to-the-cloud">From paper to the cloud</h2>
<p>The word itself is older than any computer. A “spread sheet” originally meant a large sheet of paper spread across the two facing pages of an accountant’s ledger, used to lay financial information out in a single readable expanse; bookkeepers ruled and filled these grids by hand long before VisiCalc. The electronic version inherited the layout and discarded the drudgery. The story has since come full circle in an unexpected way: where early spreadsheets were solitary files on a single machine, cloud services such as Google Sheets now let dozens of people edit the same grid simultaneously from different continents, the cursor of a colleague flickering across cells in real time. The humble grid has proved more durable than almost any other piece of office software, outlasting countless specialist programmes that were supposed to replace it.</p>
<h2 id="fun-facts">Fun facts</h2>
<ul>
<li>Bricklin and Frankston never patented VisiCalc’s core concept; software was not clearly patentable in the United States at the time, a decision that arguably cost them a fortune and arguably accelerated the spreadsheet’s spread.</li>
<li>VisiCalc ran in around 32 kilobytes of memory — less than the size of a short email today — yet it was sophisticated enough to model a company’s finances.</li>
<li>The term “killer app” entered the language largely because of VisiCalc: it was the first program credited with single-handedly selling the hardware it ran on.</li>
<li>A 2013 economics paper that influenced austerity debates worldwide was later found to contain a spreadsheet error in which several rows were omitted from an average, a reminder that the tool magnifies human mistakes as faithfully as human insight.</li>
</ul>
<h2 id="a-closing-reflection">A closing reflection</h2>
<p>The most remarkable thing about the spreadsheet may be how invisible it has become. We notice the software that distracts us and forget the software that quietly underpins a school’s marks, a charity’s accounts, a scientist’s data and a family’s holiday budget. Bricklin once said he had simply wanted to save people from rubbing out numbers, and in a sense the whole digital revolution that followed was an elaboration of that modest wish. Spreadsheet Day is a chance to notice the grid for once — to recognise that some of the tools that change the world most do so without ever raising their voice.</p>
Advertisement
Related Content
Advertisement
