{"id":1860,"date":"2020-04-19T16:09:47","date_gmt":"2020-04-19T16:09:47","guid":{"rendered":"http:\/\/jimmy.ekota.net\/?p=1860"},"modified":"2020-04-19T16:09:47","modified_gmt":"2020-04-19T16:09:47","slug":"spreadsheets","status":"publish","type":"post","link":"http:\/\/jimmy.ekota.net\/?p=1860","title":{"rendered":"Spreadsheets"},"content":{"rendered":"\n<p>Yesterday, Claire asked for help with a spreadsheet that someone had sent her. It may not have been the worst spreadsheet I\u2019ve ever seen, but it was easily in the top two. It was written in some version of Excel \u2014 the acknowledged \u201cking\u201d of spreadsheets for personal computers. I personally never liked Excel \u2014 since I\u2019ve retired, I like it even less. When I was working, I had to use it fairly often and I tolerated it then. Since I\u2019ve been retired, I\u2019ve used Numbers \u2014 a Mac spreadsheet. For my purposes, it far exceeds Excel \u2014 in every way that matters to me.\u00a0<\/p>\n\n\n\n<p>But that\u2019s not what this blog is about. After a lot of work to make the spreadsheet Claire received useable for her, I got to thinking\u2026. Electronic spreadsheets are relatively new \u2014 a spread sheet was probably the first \u201cuseful\u201d program that I remember for a personal computer.&nbsp;<\/p>\n\n\n\n<p>As far as I know, VisiCalc was the first spreadsheet computer program for PCs. It was originally released to run on the Apple II computer. (VisiCalc got it\u2019s name because it acted like a \u201cvisible calculator.\u201d)<\/p>\n\n\n\n<p>Dan Bricklin dreamed up ViciCalc while watching a presentation at Harvard Business school. Dan teamed up with Bob Frankston and they formed the Software Arts company. Together, they developed the VisiCalc program in two months \u2014 during the winter of 1978-79. Both Dan and Bob were familiar with many row\/column financial programs. These programs were really no more than report generators \u2014 some of the better known were Business Planning Language (BPL) and Foresight. However, none of the programs were completely interactive and they were used prior to the personal computer era.<\/p>\n\n\n\n<p>VisiCalc was marketed as \u201ca magic sheet of paper that can perform calculations and recalculations and allows the user to just solve the problem using familiar tools and concepts.\u201d<\/p>\n\n\n\n<p>VisiCalc hit the market in mid-1979 and sold for under $100. It required an Apple II computer with 32K of RAM and supported saving files to a magnetic tape cassette or to Apple\u2019s Disk II floppy disk system.<br>The program was unusually easy to use and came with excellent documentation. By 1982, VisiCalc\u2019s price had risen from under $100 to $250 and competitors, like Super Calc and Multiplan had come on the market.\u00a0<\/p>\n\n\n\n<p>In 1983, Lotus Development Corporation came up with Lotus 1-2-3. It was designed to be as compatible as possible with VisiCalc, including the menu structure \u2014 to allow VisiCalc users to easily migrate to 1-2-3.<\/p>\n\n\n\n<p>Lotus 1-2-3 was more powerful than VisiCalc and was almost immediately successful. By 1984, sales of VisiCalc were declining rapidly. The magazine <em>InfoWorld<\/em> wrote that VisiCalc 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 in 1984.<br>By 1985, Lotus Development acquired Software Arts and ended sales of VisiCalc.<\/p>\n\n\n\n<p>So another trip down memory lane\u2026 after struggling with Claire\u2019s spreadsheet, I guess I was longing for the good old \u201csimpler\u201d days. Of course remembrance of things past is not necessarily the remembrance of things as they were\u2026.<br>\u2014 30 \u2014<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Yesterday, Claire asked for help with a spreadsheet that someone had sent her. It may not have been the worst spreadsheet I\u2019ve ever seen, but it was easily in the top two. It was written in some version of Excel &hellip; <a href=\"http:\/\/jimmy.ekota.net\/?p=1860\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/jimmy.ekota.net\/index.php?rest_route=\/wp\/v2\/posts\/1860"}],"collection":[{"href":"http:\/\/jimmy.ekota.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/jimmy.ekota.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/jimmy.ekota.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/jimmy.ekota.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1860"}],"version-history":[{"count":1,"href":"http:\/\/jimmy.ekota.net\/index.php?rest_route=\/wp\/v2\/posts\/1860\/revisions"}],"predecessor-version":[{"id":1861,"href":"http:\/\/jimmy.ekota.net\/index.php?rest_route=\/wp\/v2\/posts\/1860\/revisions\/1861"}],"wp:attachment":[{"href":"http:\/\/jimmy.ekota.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1860"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/jimmy.ekota.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1860"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/jimmy.ekota.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1860"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}