VisiCalc
Developer(s) | Software Arts, published by VisiCorp |
---|---|
Initial release | 1979 |
Stable release | VisiCalc Advanced Version
/ 1983 |
Type | Spreadsheet |
License | Commercial proprietary software |
Website | danbricklin |
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]
Initially developed for the Apple II computer using a
VisiCalc uses the A1 notation in formulas.[9]
When
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.
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
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.
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
Other ports followed for
By 1982, VisiCalc's price had risen from $100 to $250 (equivalent to $790 in 2023).
1-2-3 was almost immediately successful, and in 1984,
Releases
- 1979: Apple II
- 1980: Apple III, TRS-80 Model III, Apple II, IBM PC, TRS-80 Model 2, Commodore PET CBM-80, HP 125, Atari 800
- 1981: IBM PC, Sony SMC-70
- 1982: Apple III
- 1983: Enhanced VisiCalc for TRS-80 Model 4,[29] Model II (with RAM expansion card) and Model 16.[30] Used banked memory beyond the base 64 KB.
Reception
In 1983,
In its 1980 review,
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
- Visi On
- Triumph of the Nerds, A documentary hosted by Robert X. Cringely featuring the creators of VisiCalc and their contribution as the first killer app for the personal computer.
- Timeline of computing 1950–1979
References
- ^ a b "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.
- ^ 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) - ^ 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.
- ^ a b 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.
- ISBN 9781305142725.
- ISBN 9780470500583. Archivedfrom the original on October 19, 2022. Retrieved July 6, 2015.
- ^ "(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.
- ^ Browne, Christopher. "Historical Background of Spreadsheets". Archived from the original on June 10, 2017. Retrieved August 8, 2021.
- ^ "The Idea". Archived from the original on June 19, 2017. Retrieved February 7, 2017.
- ^ Maloney, Eric (October 1985). "80 Micro, Side Tracks". Microcomputer Magazine (via archive.org). CW Communications. p. 12. Retrieved July 17, 2020.
- ^ "Lotus acquires Software Arts". InfoWorld. June 24, 1985. p. 20.
- ^ "VisiCalc discontinued". Infoworld. June 2, 1986. p. 8.
- ISBN 9780385233019.
- ^ "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.
- ^ ISSN 0199-6649.
The formal introduction of VisiCalc is scheduled for the National Computer Conference, being held June 4–7, in New York City.
- ^ 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.
- ^ ISBN 0-201-16454-X.
- ^ a b 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.
- ^ a b 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.
- ^ a b Budge, Joseph H. (July–August 1980). "VISICALC: A Software Review". Compute!. p. 19. Retrieved October 25, 2013.
- Imagine Media. November 1996. p. 15.
- ^ 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.
- ^ a b 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.
- ^ 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.
- ^ a b Reed, Matthew. "VisiCalc". TRS-80.org. Archived from the original on January 28, 2015. Retrieved January 23, 2015.
- ^ a b Langdell, James (August 6, 1985). "VisiCalc Production Ends". PC Magazine. p. 33. Archived from the original on October 19, 2022. Retrieved October 28, 2013.
- ^ 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.
- ^ a b Caruso, Denise (April 2, 1984). "Company Strategies Boomerang". InfoWorld. pp. 80–83. Archived from the original on October 19, 2022. Retrieved February 10, 2015.
- ^ "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.
- ^ "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.
- ^ "The Most Popular Atari Program Ever". Softline. March 1983. p. 44. Archived from the original on July 29, 2014. Retrieved July 28, 2014.
- ^ Ciraolo, Michael (October–November 1985). "Top Software / A List of Favorites". II Computing. p. 51. Retrieved January 28, 2015.
- ^ Ramsdell, Robert E (November 1980). "The Power of VisiCalc". BYTE. pp. 190–192. Retrieved October 18, 2013.
- ^ Green, Doug (August 1980). "VisiCalc: Reason Enough For Owning A Computer". Creative Computing. p. 26. Retrieved October 18, 2013.
- ^ Kattan, Joseph (June 1984). "Product Reviews: VisiCalc". Antic. 3 (2): 80. Archived from the original on March 16, 2011. Retrieved April 15, 2011.
- ^ "Public recognition of Dan Bricklin's work". www.bricklin.com. Archived from the original on March 20, 2018. Retrieved March 19, 2018.
- ^ 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.
- ^ Dalgleish, Debra. "About Spreadsheet Day". Spreadsheet Day. Archived from the original on October 16, 2022. Retrieved October 19, 2022.
- ^ 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.
- ISBN 978-0-14-029177-3.
Further reading
- Grad, B. (2007). "The Creation and the Demise of VisiCalc". IEEE Annals of the History of Computing. 29 (3): 20–31. .
- 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 Worldinterview with the creators of VisiCalc
- Techdirt: What If VisiCalc Had Been Patented?
- TRS-80 and more
- TED Talk – "Dan Bricklin: Meet the inventor of the electronic spreadsheet"
- TEDx Talk – "A Problem That Changed The World | Dan Bricklin | TEDxBeaconStreet"
- VisiCalc (1979) — Internet Archive, runnable in an emulator in the local browser.