VisiCalc

~ the last words ~

visicalc was already discontinued the year i was born. by the time i first opened a spreadsheet, in a school computer lab on windows 95, it was excel. the line from visicalc to excel runs through lotus 1-2-3, and rip.so already has a grave for that one. visicalc is the founding entry of the line, the first real reason a non-programmer ever bought a personal computer.

dan bricklin had the original idea while watching a harvard business school professor erase and rewrite numbers on a chalkboard during a class case study. bricklin and bob frankston wrote the program through software arts, his company, and visicorp published it on october 17, 1979 for the apple ii. it was the first commercial spreadsheet on a personal computer, with a recalculate-on-edit grid that did the chalkboard work automatically. the demo at the west coast computer faire that year was the moment finance people realized what the apple ii was for.

more than a quarter of all apple ii units sold in 1979 were bought specifically to run visicalc. that statistic is where the phrase "killer app" first applied to software. by the early 80s the program had been ported to several other 8-bit machines and to the original ibm pc, and it sold around seven hundred thousand copies in six years before lotus 1-2-3 ended the run.

~ the record ~

~ the early days ~

the spreadsheet idea was not new in 1979. accountants had paper grids called spreadsheets for decades. the breakthrough was making the grid recalculate every cell automatically every time you changed an input. bricklin's prototype ran on a hand-built apple ii in his harvard dorm. frankston wrote the production version mostly overnight on a borrowed timeshare account, because that was the only multi-user system available at the price.

visicorp paid bricklin and frankston a royalty per copy and put real marketing money behind the launch. for the first time a piece of business software was being sold the way consumer products are sold, in a shrink-wrapped box at the local computer store, with print ads in fortune. that distribution model is the one every personal computer software company copied for the next twenty years.

~ what really happened ~

lotus 1-2-3 shipped in january 1983 and became visicalc's executioner. written in x86 assembly directly for the ibm pc, lotus took advantage of the 256k memory ceiling and the 80-column display, both of which were beyond what visicalc had been designed for. visicalc's own port to the ibm pc had been a straight transliteration of the apple ii version with the same memory and column constraints, and it could not be rewritten in time. by december 1983 visicalc sales had dropped to fifty-seven hundred copies a month.

visicorp tried to sue software arts in 1984 over the missed ibm pc rewrite, and the lawsuit broke both companies. visicorp went insolvent. lotus acquired software arts in 1985 and killed the visicalc product line on day one, mentioning it in the 1-2-3 release notes only as the program lotus had been built to replace.

~ what replaced it ~

every spreadsheet today is descended from visicalc. the cell grid and the recalculate-on-change behavior are visicalc inventions. excel inherited them through lotus 1-2-3, and google sheets inherited them through excel. airtable and every other saas spreadsheet trace back to the same 1979 prototype.

the second inheritance is conceptual. visicalc was the first piece of software that turned a personal computer into something a normal person had a real reason to buy. before visicalc, the apple ii was a hobbyist toy. after visicalc, it was a serious business expense. that transition from toy to tool is the single most important thing the personal computer industry ever needed to do, and visicalc did it in one shipping product.

@}-->--

              )
             (_)
            .-'-.
            |   |
            |   |
            |   |
            |   |
          __|   |__   .-.
       .-'  |   |  `-:   :
      :     `---'     :-'
       `-._       _.-'
           '""""""

« previous  ·  random  ·  next »