6 ms·
Computing's first 'killer app' changed everything
- Theodores 7y agoThe lessons from this article are many, the 400,000 jobs lost book-keeping vs. 600,000 jobs gained accounting is a figure worth remembering if you are trying to get some automation introduced somewhere. There are parallels in many areas of customer service for instance. Anywhere where you can do a better job of helping the customer with knowledgeable staff that don't have to be doing so much mundane stuff.
- RachelF 7y agoTrue, but the figures can be misleading. The US economy is probably 4x the size it was in 1978, so without these productivity advances we'd need 4x as many book-keepers and accountants. Whether the economy could have grown to 4x the size without productivity advances like spreadsheets is a related question.
- mhh__ 7y agoAlmost 9x by GDP
- freedomben 7y agoIn many fields, spreadsheet apps still are the killer app(s). I worked at a company that made tax software, and to this day Excel is still a mandatory skill for an accountant, despite the "advanced" software we have these days. In project management in many industries as well the data is largely spreadsheet driven. Couple that with the fact that you can literally use a Google Sheet as the database backend for small apps, and I think it's a good case that spreadsheets are still killer.
- reginaldo 7y agoBack in the day, Google itself used spreadsheets as the backend of small pages (e.g. customer success stories). The reason I know that is because I found a few spreadsheets that were writable by anyone, and ultimately led to cross-site-scripting vulnerabilities in google.com. I reported a bunch of those to their vulnerability rewards program.
- sverige 7y agoIt's popular to make fun of Excel in some circles, but it really is a nearly perfect tool for innumerable real-world business tasks. It's intuitive enough that newcomers can do some work with minimal instruction, and powerful enough that you can manage a half-billion dollar book of business with it. More than any of the iterations of Windows, Excel is Microsoft's great contribution to software, and I say that as an old-school MS hater. I think people too often forget that "useful" is the key ingredient in killer software.
- netsharc 7y agoAnother view is that spreadsheet software is the first user-friendly way to create computer programs almost anyone can do: you have input, algorithms you define, and output.
- erpellan 7y agoExcel was considerably inferior to Supercalc for many years, only winning because it was almost impossible to buy a pc without windows and office preinstalled for a chunk of the 90s
- simonsays2 7y agoFirst killer app was calculating trajectories for artillery.
- vkou 7y agoThis is both true, and humorous. A lot of advances in mechanical computing were driven by the needs of WWI and WWII artillery battalion colonels, and ship captains - hitting distant, often-times moving targets at different elevations, and in various wind conditions. For example, the Mark I mechanical computer[1] could, when pointed at a target, measure its distance, altitude and heading, its own ship's speed, pitch, and heading, current windspeed - and combine that with the chosen projectile type, weight, propellant type, and current temperature - all to compute a firing solution that had the best chance of sinking ships adorned with swastikas, or a rising sun. Not a general-purpose computation machine, but work on these sorts of devices heavily overlapped with work on programmable computers. [1] https://en.wikipedia.org/wiki/Mark_I_Fire_Control_Computer https://en.wikipedia.org/wiki/Mark_I_Fire_Control_Computer
- tomcam 7y agoThat was my dad, in WWII. He was the only one in his unit who could do the math. He kept going AWOL but they couldn’t do more than bring him back down to private because no one else could do the trig.
- Torwald 7y ago> no one else could do the trick. Haha lol. Happy downvoting, cunts! I accept it, it's worth it.
- hirundo 7y agoWhen I saw the "first killer app" headline I immediately thought "VisiCalc". I used it ad-nauseum on a TRS-80 III as a neuroscience lab assistant in the early '80s. Before I got that software I used actual paper spreadsheets, either big 17"x11" sheets, or painfully self ruled paper. After enough hours of that I carried my TRS-80 into the lab and introduced my professor to it and VisiCalc, who fell in love and bought one for the lab. If you've never spreadsheeted on paper you may not realize the glory of even the most primitive spreadsheet app. I used to use erasers until my fingers went numb or white-out by the quart. Up hill both ways. You young whippersnappers have no idea how good you have it. I sat with the prof to show him my first attempt, with a half dozen formulas in it. He looked over my shoulder and showed me that every. fucking. formula. was wrong. I felt humiliated. But we fixed them as we went, and watching the changes flow into the cells was magic. My force had been multiplied. The skills from VisiCalc have transferred to other spreadsheets over the years very well. It's amazing how much Mr. Bricklin got right. I wonder how much was his brilliance and how much was the inevitability of the design.
- contingencies 7y agoWe didn't quite invent everything. We didn't invent spreadsheets, and there's actually a good lesson in that. I think the reason we didn't invent spreadsheets is that we didn't have any use for them, since we didn't do accounting. - Dr. Butler Lampson, on Xerox PARC (2016) ... via http://github.com/globalcitizen/taoup http://github.com/globalcitizen/taoup
- dlhavema 7y agoI think the formulas being wrong helped solidify the value, as it showed that even if something that core is wrong, it will fix it immediately without any extra rework. It would have had the same effect if only one formula was left intentionally wrong :)
- deleted 7y ago[deleted]
- jhayward 7y agoBricklin didn't invent spreadsheets, they had existed for hundreds of years. He wasn't even the first to use a digital computer to implement one. He was, however, in the right place at the right time to put spreadsheets in the hands of many more people in a much more convenient and powerful form. See: http://www.dssresources.com/history/sshistory.html http://www.dssresources.com/history/sshistory.html
- RachelF 7y agoAlso note the inventors of VisiCalc failed to patent it for various reasons[1]. This led to quick improvements of the spreadsheet by Lotus, Borland and Microsoft. If it had been patented, it is unlikely innovation would have been so fast with VisiCalc having a monopoly. [1] http://www.bricklin.com/patenting.htm http://www.bricklin.com/patenting.htm
- bobbiechen 7y agoI saw a guest lecture in my HCI class at CMU this semester from Dan Bricklin [1], who demoed VisiCalc for us on an emulator [2]. One thing that really struck me was how similar the interface was to today's Excel or Google Sheets. He even demonstrated how a lot of the original shortcuts still worked in Excel. Another fun bit of his talk, about the max digits in VisiCalc: The number of digits that we stored for precision, it was stored as binary-coded decimal, just like a calculator, it was not stored as a binary number. It was stored as the digits, so that it would be exactly the same that you would see on your calculator, without funny round-off errors and stuff like that. But we had to figure out what the maximum number of digits would be. And we decided, let’s - ha-ha. We thought, here us, two little programmers trying to figure out if anyone would use it. Let’s take the budget of the United States of America, in dollars. That’s the maximum, at the time. So that’s the maximum number of digits we had. Sure enough, within a few years, people were using it, according to the Wall Street Journal, for calculating the budget of the United States of America, but only in dollars, not in pennies, because that’s all it could do without going to scientific notation. [1] https://scs.hosted.panopto.com/Panopto/Pages/Viewer.aspx?id=d129250d-7c28-45f5-874b-a9fa01542afb https://scs.hosted.panopto.com/Panopto/Pages/Viewer.aspx?id=... [2] https://www.pcjs.org/apps/pcx86/1981/visicalc/ https://www.pcjs.org/apps/pcx86/1981/visicalc/ [3] http://www.notetakerhd.com/about.html http://www.notetakerhd.com/about.html
- gumby 7y ago> One thing that really struck me was how similar the interface was to today's Excel or Google Sheets. UIs typically recapitulate neoteny: from the beginning, competitive spreadsheets needed to be UI-compatible with Visicalc (even today Excel accepts most Visicalc controls, and has, I have been told by Frankston+, VisiCalc-compatible bugs). Notably, spreadsheets or spreadsheet-like interfaces that don't confirm people's assumptions struggle in the market (e.g. Apple Numbers). + Bob Frankston who was the implementor of Visicalc, and later worked at Microsoft, though not on Excel. You can thank him that Windows had TCP rather than some proprietary system...for the same path-dependency / network reasons.
- dontbenebby 7y agoThe title's use of quotes made me think it was going to be an article on the Therac-25 incident, whose software was arguably the true first "killer" app and is used as a cautionary tale in every intro level human computer interaction course https://en.wikipedia.org/wiki/Therac-25 https://en.wikipedia.org/wiki/Therac-25
- fouc 7y agoThe article briefly mentions: >the Jennifer Unit, an earpiece that directs warehouse pickers to collect products by breaking down instructions into the most mindless, idiot-proof steps. That makes me think of the story of Manna, which predicted something like this. http://marshallbrain.com/manna1.htm http://marshallbrain.com/manna1.htm
- Lowkeyloki 7y agoThat's exactly what I thought of. I thought, dear god, it's real. I really hope someone didn't read Manna and think, gee, that sounds like a good idea! I have to disagree with Marshall Brain's "solution" to the problem. When I read those final chapters, I couldn't help but think the Vertebrane system was subtly and insidiously even worse than Manna.
- anchpop 7y agoI just read it, it's a great story. I can see some obvious drawbacks to Vertebrane (I like my privacy), but I can't imagine it being worse than Manna.
- Lowkeyloki 7y agoPrivacy was my first concern about it, too. Okay, so maybe not worse than Manna, but at least as bad as, if in a different way.
- kevin_thibedeau 7y agoBank ATMs were the first computing killer app, allowing people access to cash outside normal banking hours.
- Tor3 7y agoI don't think ATMs appeared equally early everywhere, but in any case, 'killer app' in this context points to the fact that the Visical application made businesses go out and buy Apple II computers, just so they could run Visicalc. They didn't, before Visicalc. That little piece of software made the sales of Apple II explode and laid the fundament for having something like the IBM PC in the office. ATMs were very useful for people, but it didn't create a fundamental change in the use of computers.
- Causality1 7y agoElectronic spreadsheets seem like such an obvious advantage of early personal computers that it's a bit surprising they weren't expressly designed with that in mind. I think their rise should serve as a reminder that building flexible systems gives people the ability to use your systems in amazing ways you never envisioned.
- nraynaud 7y agoI would like a (pseudo-)mode that color code the cells depending on the format they are in. And tools to easily change said format (let’s call it type). And probably use text by default.
- GrumpyNl 7y agoSupercalc got me starting my career as a software developer.
- dalbasal 7y agoAccountants are surprisingly avante garde technologists. Sumerian accountants seem to have invented cuineform, which evolved into the (AFAIK) earliest widespread writing system. Italian accountants (including Fibonacci's dad) first adopted Indo–Arabic numerals, because they made ledgering easier than roman numerals.. and opened the door to arab mathematics systems like algebra
- credit_guy 7y agoWhenever someone claims that robots will destroy our jobs, I point them to spreadsheets. How many people in the world were using physical spreadsheets before the advent of their software cousins? Ten thousand? How many people use Excel today? Hundreds of millions? Spreadsheet software has increased the number of spreadsheet workers by many orders of magnitude. It's a very extreme example, and not all automation will be the same story, but it's not all doom and gloom
- chungleong 7y agoThe lump of labor fallacy get pushed by journalists because it's actually operative in their field. Technological advances were not accompanied by demand for higher quality. If anything the lump has arguably gotten smaller.
- deleted 7y ago[deleted]