VisiCalc

Last updated

VisiCalc
Developer(s) Software Arts, published by VisiCorp
Initial release1979;45 years ago (1979)
Stable release
VisiCalc Advanced Version / 1983;41 years ago (1983)
Operating system Apple II, Apple SOS, Atari 8-bit family, CP/M, Commodore PET, HP Series 80, MS-DOS, Sony SMC-70, TRSDOS
Type Spreadsheet
License Commercial proprietary software
Website danbricklin.com/visicalc.htm

VisiCalc ("visible calculator") [1] is the first spreadsheet computer program for personal computers, [2] originally released for Apple II by VisiCorp on October 17, 1979. [1] [3] It is considered the killer application for the Apple II, [4] turning the microcomputer from a hobby for computer enthusiasts into a serious business tool, and then prompting IBM to introduce the IBM PC two years later. [5] More than 700,000 copies were sold in six years, and up to 1 million copies over its history.[ citation needed ]

Contents

Initially developed for the Apple II computer using a 6502 assembler running on the Multics time-sharing system, [6] [7] [8] VisiCalc was ported to numerous platforms, both 8-bit and some of the early 16-bit systems. 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.[ citation needed ]

VisiCalc uses the A1 notation in formulas. [9]

When Lotus 1-2-3 was launched in 1983, taking full advantage of the expanded memory and screen of the IBM PC, VisiCalc sales declined so rapidly that the company was soon insolvent. In 1985, Lotus Development purchased the company [10] and ended sales of VisiCalc. [11] [12]

History

VISICALC represented a new idea of a way to use a computer and a new way of thinking about the world. Where conventional programming was thought of as a sequence of steps, this new thing was no longer sequential in effect: When you made a change in one place, all other things changed instantly and automatically.

—  Ted Nelson [13]

Dan Bricklin conceived of VisiCalc while watching a presentation at Harvard Business School. The professor was creating a financial model on a blackboard that was ruled with vertical and horizontal lines (resembling accounting paper) to create a table, and he wrote formulas and data into the cells. When the professor found an error or wanted to change a parameter, he had to erase and rewrite several 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. [14]

Bob Frankston joined Bricklin at 231 Broadway, Arlington, Massachusetts, and the pair formed the Software Arts company, and developed the VisiCalc program in two months during the winter of 1978–79. Bricklin wrote:

with 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 was 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, and they pre-dated personal computers.

Frankston described VisiCalc as a "magic sheet of paper that can perform calculations and recalculations [which] allows the user to just solve the problem using familiar tools and concepts". The Personal Software company began selling VisiCalc in mid-1979 for under US$100(equivalent to $420 in 2023), after a demonstration at the fourth West Coast Computer Faire and an official launch on June 4 at the National Computer Conference. It requires an Apple II with 32K of random-access memory (RAM), and supports saving files to magnetic tape cassette or to the Apple Disk II floppy disk system. [15]

VisiCalc was unusually easy to use and came with excellent documentation. Apple's developer documentation cited the software as an example of one with a simple user interface. [16] [17] Observers immediately noticed its power. Ben Rosen speculated in July 1979, that "VisiCalc could someday become the software tail that wags (and sells) the personal computer dog". [18] [19] For the first 12 months, it was only available for Apple II, and became its killer app. [20] [4] [21] John Markoff wrote that the computer was sold as a "VisiCalc accessory", [22] and many bought $2,000(equivalent to $8,400 in 2023) Apple computers to run the $100 software [19] — more than 25% of those sold in 1979 were reportedly for VisiCalc [18] — even if they already owned other computers. [23] Steve Wozniak said that small businesses, not the hobbyists he and Steve Jobs had expected, purchased 90% of Apple IIs. [24] Apple's rival Tandy Corporation used VisiCalc on Apple IIs at their headquarters. [25] Other software supports its Data Interchange Format (DIF) to share data. [17] One example is the Microsoft BASIC interpreter supplied with most microcomputers that ran VisiCalc. This allowed skilled BASIC programmers to write features, such as trigonometric functions, that VisiCalc lacked.[ citation needed ]

Bricklin and Frankston originally intended to fit the program into 16k memory, but they later realized that the program needed at least 32k. Even 32k is too small to support some features that the creators wanted to include, such as a split screen for text and graphics. However, Apple eventually began shipping all Apple IIs with 48k memory following a drop in RAM prices, enabling the developers to include more features. The initial release supported tape cassette storage, but that was quickly dropped.[ citation needed ]

At VisiCalc's release, Personal Software promised to port the program to other computers, starting with those with the MOS Technology 6502 microprocessor, [15] and versions appeared for Atari 800 and Commodore PET. Both of those were easy, because those computers have the same CPU as Apple II, and large portions of code were reused. The PET version, which contains 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' inclusion of their own custom DOS, which uses a large amount of memory. The PET only has 32k versus Apple II's available 48k.[ citation needed ]

Other ports followed for Apple III, the Zilog Z80-based Tandy TRS-80 Model I, Model II, Model III, Model 4, and Sony SMC-70. The TRS-80 Model I and Sony SMC-70 ports are the only versions of VisiCalc without copy protection. The HP 125 and Sony SMC-70 ports are the only CP/M version. Most versions are disk-based, but the PET VisiCalc came with a ROM chip that the user must install in one of the motherboard's expansion ROM sockets. The most important port is for the IBM PC, and VisiCalc became one of the first commercial packages available when the IBM PC shipped in 1981. [25] It quickly became a best-seller on this platform, though severely limited to be compatible with the versions for the 8-bit platforms. It is estimated that 300,000 copies were sold on the PC, bringing total sales to about 1 million copies. [26]

By 1982, VisiCalc's price had risen from $100 to $250(equivalent to $790 in 2023). [27] Several competitors appeared in the market, such as SuperCalc [23] and Multiplan, [28] each of which have 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 Development Corporation's Lotus 1-2-3, created by former Personal Software/VisiCorp employee Mitch Kapor, who had written VisiTrend and VisiPlot. Unlike the IBM PC version of VisiCalc, 1-2-3 was written to take full advantage of the PC's increased memory, screen, and performance. Yet it was designed to be as compatible as possible with VisiCalc, including the menu structure, to allow VisiCalc users to easily migrate to 1-2-3.[ citation needed ]

1-2-3 was almost immediately successful, and in 1984, InfoWorld wrote that sales of VisiCalc were "rapidly declining", stating, that it was "the first successful software product to have gone through a complete life cycle, from conception in 1978 to introduction in 1979 to peak success in 1982 to decline in 1983 to a probable death according to industry insiders in 1984". The magazine added that the company was slow to upgrade the software, only releasing an Advanced Version of VisiCalc for Apple II in 1983, and announcing one for the IBM PC in 1984. [28] By 1985, VisiCorp was insolvent. Lotus Development acquired Software Arts, and ended sales of the application. [26]

Releases

Reception

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. [31] II Computing listed it second on the magazine's list of top Apple II software as of late 1985, based on sales and market-share data. [32]

In its 1980 review, BYTE wrote "The most exciting and influential piece of software that has been written for any microcomputer application is VisiCalc [...] VisiCalc is the first program available on a microcomputer that has been responsible for sales of entire systems". [33] Creative Computing 's review that 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". [34] Compute! reported, "Every Visicalc user knows of someone who purchased an Apple just to be able to use Visicalc". [20] 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." [35] The Addison-Wesley Book of Atari Software 1984 gave the application an overall A+ rating, praising its documentation and calling it "indispensable ... a straight 'A' classic". [17]

In 1999, Harvard Business School put up a plaque commemorating Dan Bricklin in the room where he had studied, saying, "Forever changed how people use computers in business." [36]

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", but also, "It's great because it demonstrated the power of personal computing." [37]

Since 2010, the anniversary of the October 17, 1979, launch of VisiCalc has been celebrated as Spreadsheet Day. [38] [39]

Legacy

VisiCalc is one of the earliest examples of metaphor-driven user interface design, due to its resemblance with paper spreadsheets. This metaphor made the program comprehensible and familiar to accountants, economists, and bookkeepers who were not used to using computers, and VisiCalc's release marked the point where "personal computers crossed the line from a hobbyist obsession to a compelling tool". Compared to paper spreadsheets, VisiCalc freed users to change numbers without having to recalculate the whole spreadsheet by hand, which, according to Steven Levy, "changed the perception of a spreadsheet from a document of hard costs into a modeling tool by which one tested business scenarios". [40]

See also

Related Research Articles

<span class="mw-page-title-main">Bob Frankston</span> American businessman

Robert M. Frankston is an American software engineer and businessman who co-created, with Dan Bricklin, the VisiCalc spreadsheet program. Frankston is also the co-founder of Software Arts.

<span class="mw-page-title-main">Dan Bricklin</span> VisiCalc inventor

Daniel Singer Bricklin is an American businessman and engineer who is the co-creator, with Bob Frankston, of VisiCalc, the first spreadsheet program. He also founded Software Garden, Inc., of which he is currently president, and Trellix, which he left in 2004. He currently serves as the chief technology officer of Alpha Software.

<span class="mw-page-title-main">Lotus 1-2-3</span> Spreadsheet software

Lotus 1-2-3 is a discontinued spreadsheet program from Lotus Software. It was the first killer application of the IBM PC, was hugely popular in the 1980s, and significantly contributed to the success of IBM PC-compatibles in the business market.

<span class="mw-page-title-main">Multiplan</span> Spreadsheet program

Multiplan is a spreadsheet program developed by Microsoft and introduced in 1982 as a competitor to VisiCalc.

<span class="mw-page-title-main">Spreadsheet</span> Computer application for organization, analysis, and storage of data in tabular form

A spreadsheet is a computer application for computation, organization, analysis and storage of data in tabular form. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cells of a table. Each cell may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells. The term spreadsheet may also refer to one such electronic document.

<span class="mw-page-title-main">TRS-80</span> 1977 microcomputer by Tandy Corporation

The TRS-80 Micro Computer System is a desktop microcomputer launched in 1977 and sold by Tandy Corporation through their Radio Shack stores. The name is an abbreviation of Tandy Radio Shack, Z80 [microprocessor]. It is one of the earliest mass-produced and mass-marketed retail home computers.

A killer application is any software that is so necessary or desirable that it proves the core value of some larger technology, such as its host computer hardware, video game console, software platform, or operating system. Consumers would buy the host platform just to access that application, possibly substantially increasing sales of its host platform.

Lotus Software was an American software company based in Massachusetts; it was "offloaded" to India's HCL Technologies in 2018.

Microsoft BASIC is the foundation software product of the Microsoft company and evolved into a line of BASIC interpreters and compiler(s) adapted for many different microcomputers. It first appeared in 1975 as Altair BASIC, which was the first version of BASIC published by Microsoft as well as the first high-level programming language available for the Altair 8800 microcomputer.

<span class="mw-page-title-main">Visi On</span> Operating environment program

Visi On is a graphical user interface (GUI)-based operating environment program for IBM compatible personal computers running MS-DOS. Visi On was developed by VisiCorp. It was one of the first GUIs on a personal computer. Visi On was never popular, as it had steep minimum system requirements for its day, but it was influential in the development of later GUIs like Microsoft Windows.

<span class="mw-page-title-main">VisiCorp</span>

VisiCorp was an early personal computer software publisher. Its most famous products were Microchess, Visi On and VisiCalc.

<span class="mw-page-title-main">SuperCalc</span>

SuperCalc is a CP/M-80 spreadsheet application published by Sorcim in 1980.

Dan Fylstra is a pioneer of the software products industry.

<span class="mw-page-title-main">Scripsit</span>

Scripsit is a word processing application written for the Radio Shack TRS-80 line of computers. Versions were available for most if not all computers sold under the TRS-80 name, including the TRS-80 Color Computer and several pocket computer designs, as well as the Tandy version of the Xenix operating system. Tandy Corp. also produced a version running under MS-DOS for its line of PC compatible computers. Some of the 8-bit versions are tape-based and have no ability to read or write to disk.

<span class="mw-page-title-main">History of personal computers</span> History of the consumer personal computer

The history of the personal computer as a mass-market consumer electronic device began with the microcomputer revolution of the 1970s. A personal computer is one intended for interactive individual use, as opposed to a mainframe computer where the end user's requests are filtered through operating staff, or a time-sharing system in which one large processor is shared by many individuals. After the development of the microprocessor, individual personal computers were low enough in cost that they eventually became affordable consumer goods. Early personal computers – generally called microcomputers – were sold often in electronic kit form and in limited numbers, and were of interest mostly to hobbyists and technicians.

<span class="mw-page-title-main">TRS-80 Model II</span> Tandy Radio Shack small-business computer launched in 1979

The TRS-80 Model II is a computer system launched by Tandy in October 1979, and targeted at the small-business market. It is not an upgrade of the original TRS-80 Model I, but a new system.

<span class="mw-page-title-main">Home computer</span> Class of microcomputers

Home computers were a class of microcomputers that entered the market in 1977 and became common during the 1980s. They were marketed to consumers as affordable and accessible computers that, for the first time, were intended for the use of a single, non-technical user. These computers were a distinct market segment that typically cost much less than business, scientific, or engineering-oriented computers of the time, such as those running CP/M or the IBM PC, and were generally less powerful in terms of memory and expandability. However, a home computer often had better graphics and sound than contemporary business computers. Their most common uses were word processing, playing video games, and programming.

Peter R. Jennings is a British-Canadian physicist, scientist, inventor, software developer, computer chess programmer, and entrepreneur. He is most notable for creating MicroChess, the first microcomputer game to be sold commercially.

References

  1. 1 2 "A sidebar to the article "Ten Years of Rows and Columns" published in Byte, issue 13/1989, pp. 326-328". Archived from the original on September 23, 2015. Retrieved June 24, 2015. Yeah, we called it all sorts of things – electronic ledger, electronic blackboard, visible calculator – that's what we finally based the name, VisiCalc, on.
  2. ↑ Justice, United States Congress House Committee on the Judiciary Subcommittee on Courts, Intellectual Property, and the Administration of (1991). Computers and Intellectual Property: Hearings Before the Subcommittee on Courts, Intellectual Property, and the Administration of Justice of the Committee on the Judiciary, House of Representatives, One Hundred First Congress, First and Second Sessions, November 8, 1989, and March 7, 1990. U.S. Government Printing Office. Archived from the original on October 19, 2022. Retrieved November 7, 2020.{{cite book}}: CS1 maint: multiple names: authors list (link)
  3. ↑ Jennings, Peter R. "VisiCalc 1979". Benlo Park. Archived from the original on October 17, 2022. Retrieved October 19, 2022. The first copy of VisiCalc for the Apple ][ (Version 1.37) went out the door on October 17, 1979.
  4. 1 2 Harford, Tim (May 22, 2019). "How computing's first 'killer app' changed everything". BBC News. Archived from the original on May 22, 2019. Retrieved May 22, 2019.
  5. ↑ Hill, Charles (January 1, 2014). Strategic Management: Theory & Cases: An Integrated Approach. Cengage Learning. p. C-177. ISBN   9781305142725.
  6. ↑ Bricklin, Dan (April 15, 2009). Bricklin on Technology. John Wiley & Sons. ISBN   9780470500583. Archived from the original on October 19, 2022. Retrieved July 6, 2015.
  7. ↑ "(Image 5) SLIDESHOW: CIO Blast from the Past - 40 years of Multics". CIO. Australia. Archived from the original on June 18, 2018. Retrieved July 6, 2015.
  8. ↑ Browne, Christopher. "Historical Background of Spreadsheets". Archived from the original on June 10, 2017. Retrieved August 8, 2021.
  9. ↑ "The Idea". Archived from the original on June 19, 2017. Retrieved February 7, 2017.
  10. ↑ Maloney, Eric (October 1985). "80 Micro, Side Tracks". Microcomputer Magazine (via archive.org). CW Communications. p. 12. Retrieved July 17, 2020.
  11. ↑ "Lotus acquires Software Arts". InfoWorld . June 24, 1985. p. 20.
  12. ↑ "VisiCalc discontinued". Infoworld. June 2, 1986. p. 8.
  13. ↑ Brand, Stewart (1989). Whole Earth Software Catalog. Quantum Press/Doubleday. ISBN   9780385233019.
  14. ↑ "VisiCalc and the Rise of the Apple II". Low End Mac. September 25, 2006. Archived from the original on June 9, 2017. Retrieved August 8, 2021.
  15. 1 2 "VisiCalc: User-Defined Problem Solving Package". The Intelligent Machines Journal. 1 (9): 22. June 11, 1979. ISSN   0199-6649. The formal introduction of VisiCalc is scheduled for the National Computer Conference, being held June 4–7, in New York City.
  16. ↑ Meyers, Joe; Tognazzini, Bruce (1982). Apple IIe Design Guidelines (PDF). Apple Computer. p. 22. Archived from the original (PDF) on September 23, 2015. Retrieved March 11, 2014.
  17. 1 2 3 Stanton, Jeffrey; Wells, Robert P. Ph.D.; Rochowansky, Sandra; Mellid, Michael Ph.D., eds. (1984). The Addison-Wesley Book of Atari Software. Addison-Wesley. p. 214. ISBN   0-201-16454-X.
  18. 1 2 Brandel, Mary (August 2, 1999). "PC Software Transforms The PC". PC Magazine. p. 62. Archived from the original on October 19, 2022. Retrieved October 3, 2020.
  19. 1 2 McMullen, Barbara E. & John F. (February 21, 1984). "Apple Charts The Course For IBM". PC Magazine. p. 122. Archived from the original on October 19, 2022. Retrieved October 24, 2013.
  20. 1 2 Budge, Joseph H. (July–August 1980). "VISICALC: A Software Review". Compute!. p. 19. Retrieved October 25, 2013.
  21. ↑ "Nintendo's Leap into the Unknown". Next Generation . No. 23. Imagine Media. November 1996. p. 15.
  22. ↑ Markoff, John (July 5, 1982). "Radio Shack: set apart from the rest of the field". InfoWorld. p. 36. Archived from the original on October 19, 2022. Retrieved February 10, 2015.
  23. 1 2 Barry, Tim (October 5, 1981). "SuperCalc Spread-Sheet Simulator from Sorcim Corp". InfoWorld. p. 30. Archived from the original on October 19, 2022. Retrieved January 1, 2015.
  24. ↑ Williams, Gregg; Moore, Rob (January 1985). "The Apple Story / Part 2: More History and the Apple III". BYTE (interview). p. 166. Retrieved October 26, 2013.
  25. 1 2 Reed, Matthew. "VisiCalc". TRS-80.org. Archived from the original on January 28, 2015. Retrieved January 23, 2015.
  26. 1 2 Langdell, James (August 6, 1985). "VisiCalc Production Ends". PC Magazine. p. 33. Archived from the original on October 19, 2022. Retrieved October 28, 2013.
  27. ↑ Tommervik, Allan (March 1982). "What Price Software? / Part 2 of The Great Arcade/Computer Controversy". Softline. p. 10. Archived from the original on July 17, 2014. Retrieved July 15, 2014.
  28. 1 2 Caruso, Denise (April 2, 1984). "Company Strategies Boomerang". InfoWorld. pp. 80–83. Archived from the original on October 19, 2022. Retrieved February 10, 2015.
  29. ↑ "1984 Radio Shack Computer Catalog RSC-10 page 21". Radio Shack Catalogs dot com. Tandy/Radio Shack. Archived from the original on October 3, 2014. Retrieved May 1, 2019.
  30. ↑ "1983 Radio Shack Computer Catalog RSC-8 page 10". Radio Shack Catalogs dot com. Tandy/Radio Shack. Archived from the original on June 30, 2019. Retrieved May 1, 2019.
  31. ↑ "The Most Popular Atari Program Ever". Softline. March 1983. p. 44. Archived from the original on July 29, 2014. Retrieved July 28, 2014.
  32. ↑ Ciraolo, Michael (October–November 1985). "Top Software / A List of Favorites". II Computing. p. 51. Retrieved January 28, 2015.
  33. ↑ Ramsdell, Robert E (November 1980). "The Power of VisiCalc". BYTE. pp. 190–192. Retrieved October 18, 2013.
  34. ↑ Green, Doug (August 1980). "VisiCalc: Reason Enough For Owning A Computer". Creative Computing. p. 26. Retrieved October 18, 2013.
  35. ↑ Kattan, Joseph (June 1984). "Product Reviews: VisiCalc". Antic . 3 (2): 80. Archived from the original on March 16, 2011. Retrieved April 15, 2011.
  36. ↑ "Public recognition of Dan Bricklin's work". www.bricklin.com. Archived from the original on March 20, 2018. Retrieved March 19, 2018.
  37. ↑ Babcock, Charles (November 8, 2006). "What's The Greatest Software Ever Written?". InformationWeek . UBM. Archived from the original on June 25, 2017. Retrieved February 19, 2014.
  38. ↑ Dalgleish, Debra. "About Spreadsheet Day". Spreadsheet Day. Archived from the original on October 16, 2022. Retrieved October 19, 2022.
  39. ↑ Pullen, John Patrick (October 16, 2015). "5 Excel Secrets That Will Make Your Boss Think You're a Pro". Time . Archived from the original on January 18, 2022. Retrieved October 19, 2022.
  40. ↑ Levy, Steven (June 2000). Insanely Great: The Life and Times of Macintosh, the Computer that Changed Everything. Penguin Publishing Group. pp. 68–69. ISBN   978-0-14-029177-3.

Further reading

This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.