World Library  
Flag as Inappropriate
Email this Article


Article Id: WHEBN0000032628
Reproduction Date:

Title: VisiCalc  
Author: World Heritage Encyclopedia
Language: English
Subject: Lotus 1-2-3, Ed Esber, Spreadsheet, Timeline of Steve Jobs media, VisiCorp
Collection: 1979 Software, Apple II Software, Atari 8-Bit Family Software, Microcomputer Software, Spreadsheet Software
Publisher: World Heritage Encyclopedia


An example VisiCalc spreadsheet on an Apple II
Developer(s) VisiCorp
Stable release VisiCalc Advanced Version / 1983
Operating system Apple II, Apple SOS, CP/M, Atari 8-bit family, Commodore PET, TRS-DOS, DOS, HP series 80
Type Spreadsheet
License Proprietary EULA

VisiCalc was the first spreadsheet computer program, originally released for the Apple II. It is often considered the application that turned the microcomputer from a hobby for computer enthusiasts into a serious business tool, and is considered the Apple II's killer app. VisiCalc sold over 700,000 copies in six years, and as many as 1 million copies over its history.

VisiCalc was ported to numerous platforms, both 8-bit and some of the early 16-bit systems. In order to do this, the company developed porting platforms that produced bug compatible versions. The company took the same approach when the IBM PC was launched, producing a product that was essentially identical to the original 8-bit Apple II version. Sales were initially brisk, with about 300,000 copies sold.

VisiCalc used the A1 notation in formulas.[1]

When Lotus 1-2-3 was launched in 1983, taking full advantage of the expanded memory and screen of the PC, VisiCalc sales practically ended overnight. Sales imploded so rapidly that the company was soon insolvent. Lotus Development purchased the company in 1985, and immediately ended sales of VisiCalc and the company's other products.


  • History 1
    • Releases 1.1
  • Reception 2
  • See also 3
  • References 4
  • Further reading 5
  • External links 6


VisiCalc traces its history to a presentation that Dan Bricklin was watching while attending Harvard Business School. The professor was creating a financial model on a blackboard that was ruled with lines to create a table, and formulas and data were being written into the cells. When the professor found an error or wanted to change a parameter, he had to erase and rewrite a number of sequential entries in the table. Bricklin realized that he could replicate the process on a computer using an "electronic spreadsheet" to view results of underlying formulae.[2]

Bricklin was joined by Bob Frankston, and the pair worked on VisiCalc for two months during the winter of 1978–79, forming Software Arts. Bricklin wrote, "[W]ith the years of experience we had at the time we created VisiCalc, we were familiar with many row/column financial programs. In fact, Bob had worked since the 1960s at Interactive Data Corporation, a major timesharing utility that was used for some of them and I was exposed to some at Harvard Business School in one of the classes." Bricklin is referring to the variety of report generators that were in use at that time, including Business Planning Language (BPL) from International Timesharing Corporation (ITS) and Foresight, from Foresight Systems. However, these earlier timesharing programs were not completely interactive, nor did they run on personal computers.

Their original intention was to fit the program into 16k, but this proved impossible and 32k became necessary. Some additional features they wanted like a split text/graphics screen still had to be omitted for space reasons. However, Apple eventually began shipping all Apple IIs with 48k following a drop in RAM prices and so this was no longer an issue. The initial release supported cassette storage, but that was quickly dropped. Distribution was taken up by Personal Software (later named VisiCorp), and VisiCalc appeared on the market in mid-1979 after an official launch on June 4 at the National Computer Conference.[3]

The power of the VisiCalc concept was noticed immediately. Ben Rosen speculated in July 1979 that "VisiCalc could someday become the software tail that wags (and sells) the personal computer dog". For the first 12 months it was only available for the Apple II computer, and became that platform's killer app. There are widespread stories of people buying $2000 computers to run the $100 software.[4] VisiCalc was unusually easy to use; Apple's developer documentation cited it as an example of software with a simple user interface.[5] Bricklin and Frankston developed ports for the Atari 800 and Commodore PET, both of which could be done easily because those computers used the same 6502 CPU as the Apple II, and large portions of code could be reused. The PET version, which contained two separate executables for 40 and 80-column models, was widely criticized for having a very small amount of worksheet space due to the developers' insistence on including their own custom DOS which used a large amount of memory (the PET only had 32k versus the Apple II's 48k). Other ports followed for the HP-150 and TRS-80 Model I and II. The TRS-80 Model I port was the only version of Visicalc that did not have any copy protection. On most versions, this was disk-based, but the PET Visicalc came with a ROM chip that the user had to install in one of the motherboard's expansion ROM sockets (the chip contained an ID string that the program looked for on startup).

Another, more complex, port was made to the IBM PC, and it was one of the first commercial packages available when it shipped in 1981. It quickly became a best-seller on this platform, in spite of being severely limited to be compatible with the versions from the 8-bit platforms. It is estimated that 300,000 copies were sold on the PC, bringing total sales to about 1 million copies.[6]

By 1982 VisiCalc's price had risen from $100 to $250.[7] Several competitors appeared in the market, notably SuperCalc and Multiplan, each of which added more features and corrected deficiencies in Visicalc, but could not overcome its market dominance. A more dramatic change occurred with the 1983 launch of Lotus 1-2-3, written by a former VisiCalc employee. Unlike the PC version of VisiCalc, 1-2-3 was written to take full advantage of the PC's increased memory, screen and performance. Yet it deliberately attempted to remain as compatible as possible with VisiCalc, including copying its menu structure as far as possible to allow VisiCalc users to easily migrate to 1-2-3. The program was an immediate runaway success, and sales of VisiCalc evaporated almost overnight.

By 1985 VisiCorp was insolvent, and sold Software Arts to their competitor, Lotus Development. Lotus immediately ended sales of the application.[6]


  • 1979 - Apple II
  • 1980 - Apple III, TRS-80 model 3, Apple II, IBM PC, TRS-80 model 2, Commodore PET CBM-80, HP 125, Atari 800
  • 1981 - IBM PC
  • 1982 - Apple III, Apple IIe - VisiCalc Advanced Version[8]


In its 1980 review, BYTE wrote "The most exciting and influential piece of software that has been written for any microcomputer application is VisiCalc". It concluded, "VisiCalc is the first program available on a microcomputer that has been responsible for sales of entire systems";[9] Creative Computing '​s review the same year similarly concluded, "for almost anyone in business, education, or any science-related field it is ... reason enough to purchase a small computer system in the first place".[10] Compute! reported, "Every Visicalc user knows of someone who purchased an Apple just to be able to use Visicalc".[11] In 1983 Softline readers named VisiCalc tenth overall, and the highest non-game, on the magazine's Top Thirty list of Atari 8-bit programs by popularity.[12] Antic wrote in 1984, "VisiCalc isn't as easy to use as prepackaged home accounting programs, because you're required to design both the layout and the formulas used by the program. Because it is not pre-packaged, however, it's infinitely more powerful and flexible than such programs. You can use VisiCalc to balance your checkbook, keep track of credit card purchases, calculate your net worth, do your taxes—the possibilities are practically limitless."[13]

In 2006, Charles Babcock of InformationWeek wrote that, in retrospect, "VisiCalc was flawed and clunky, and couldn't do many things users wanted it to do."[14]

See also


  1. ^ Dan Bricklin's VisiCalc History--The Idea
  2. ^ Coventry, Joshua (2006-11-02). "Interview with Dan Bricklin, Inventor of the Electronic Spreadsheet".  
  3. ^ "VisiCalc: User-Defined Problem Solving Package". The Intelligent Machine Journal (InfoWorld Media Group) 1 (9): p. 22. June 11, 1979.  . "The formal introduction of VisiCalc is scheduled for the National Computer Conference, being held June 4–7, in New York City."
  4. ^ McMullen, Barbara E. and John F. (1984-02-21). "Apple Charts The Course For IBM". PC Magazine. p. 122. Retrieved 24 October 2013. 
  5. ^ Meyers, Joe; Tognazzini, Bruce (1982). Apple IIe Design Guidelines. Apple Computer. p. 22. 
  6. ^ a b Langdell, James (1985-08-06). "VisiCalc Production Ends". PC Magazine. p. 33. Retrieved 28 October 2013. 
  7. ^ Tommervik, Allan (March 1982). "What Price Software? / Part 2 of The Great Arcade/Computer Controversy". Softline. p. 10. Retrieved 15 July 2014. 
  8. ^ PC Mag - Google Livros
  9. ^ Ramsdell, Robert E (November 1980). "The Power of VisiCalc". BYTE. pp. 190–192. Retrieved 18 October 2013. 
  10. ^ Green, Doug (August 1980). "VisiCalc: Reason Enough For Owning A Computer". Creative Computing. p. 26. Retrieved 18 October 2013. 
  11. ^ Budge, Joseph H. (July–August 1980). "VISICALC: A Software Review". Compute!. p. 19. Retrieved 25 October 2013. 
  12. ^ "The Most Popular Atari Program Ever". Softline. March 1983. p. 44. Retrieved 28 July 2014. 
  13. ^ Kattan, Joseph (June 1984). "Product Reviews: VisiCalc".  
  14. ^ "What's The Greatest Software Ever Written?"

Further reading

  • Grad, B. (2007). "The Creation and the Demise of VisiCalc". IEEE Annals of the History of Computing 29 (3): 20–20.  
  • Campbell-Kelly, M. (2007). "Number Crunching without Programming: The Evolution of Spreadsheet Usability". IEEE Annals of the History of Computing 29 (3): 6–8.  

External links

  • Dan Bricklin's Own VisiCalc Website – With history information as well as downloadable PC version
  • Implementing VisiCalc – By Bob Frankston, on his website
  • Was VisiCalc the "first" spreadsheet? – By Dan Bricklin, on his website
  • Three Minutes: Godfathers Of The Spreadsheet – PC World  interview with the creators of VisiCalc
  • Techdirt: What If VisiCalc Had Been Patented?
  • TRS-80 and more
This article was sourced from Creative Commons Attribution-ShareAlike License; additional terms may apply. World Heritage Encyclopedia content is assembled from numerous content providers, Open Access Publishing, and in compliance with The Fair Access to Science and Technology Research Act (FASTR), Wikimedia Foundation, Inc., Public Library of Science, The Encyclopedia of Life, Open Book Publishers (OBP), PubMed, U.S. National Library of Medicine, National Center for Biotechnology Information, U.S. National Library of Medicine, National Institutes of Health (NIH), U.S. Department of Health & Human Services, and, which sources content from all federal, state, local, tribal, and territorial government publication portals (.gov, .mil, .edu). Funding for and content contributors is made possible from the U.S. Congress, E-Government Act of 2002.
Crowd sourced content that is contributed to World Heritage Encyclopedia is peer reviewed and edited by our editorial staff to ensure quality scholarly research articles.
By using this site, you agree to the Terms of Use and Privacy Policy. World Heritage Encyclopedia™ is a registered trademark of the World Public Library Association, a non-profit organization.

Copyright © World Library Foundation. All rights reserved. eBooks from World Library are sponsored by the World Library Foundation,
a 501c(4) Member's Support Non-Profit Organization, and is NOT affiliated with any governmental agency or department.