The company’s chief financial officer wanted certain information, and his top “experts” had difficulty providing it. So one weekend he brought an Apple computer and a copy of VisiCalc home with him. Monday morning, he called his people in and showed them how he had gotten the information he had been clamoring for. “With one swipe of the diskette, he cut them off at the knees.” Stein said. “He out-teched them. His experts! He’d cut the chain. The following week, they all came down to learn VisiCalc – fast.”
That's the kind of disruptive technonology that'll get you sales. Making things done, and having Cx0s demanding your product.
The spreadsheet embodies, embraces, that end, and ultimately serves to reinforce it. As Marshall McLuhan observed, “We shape our tools and thereafter our tools shape us.” The spreadsheet is a tool, and it is also a world view — reality by the numbers. If the perceptions of those who play a large part in shaping our world are shaped by spreadsheets, it is important that all of us understand what this tool can and cannot do.
Steve Sinofsky (http://en.wikipedia.org/wiki/Steven_Sinofsky) made a similar point on HN yesterday:
Second, people tend to underestimate the way that new tools, as ineffective as they are, drive changes in the very definition of work. Said another way, people forget that tools can also define the work and jobs people have. It isn't like work was always "mail around a 10MB presentation before the meeting". In fact a long time ago meeting agendas were typed out in courier by a typist -- that job was defined by the Selectric. The tools that created presentations, attachments, and follow up email defined a style of working. While we're reading all this, the exponential rise of mobile is changing what it means to work--to go to a meeting, to collaborate, to decide, to create, etc.
This is a fun quote:
Already, the spreadsheet has redefined the nature of some jobs; to be an accountant in the age of spreadsheet program is — well, almost sexy.
This is the real double-edged sword of spreadsheets. They simultaneously surface data, logic and presentation. This enables a very fluid modelling process because you can see everything that's happening... at first. Eventually these things always become intractable hairballs, dumped on the desk of the office "Spreadsheet Mechanic" for critical repair. Ugh.
Excel's Data Tables, ODBC connectivity and named ranges help with this. It gives you have some assurance that the raw data comes from a Source Of Truth and hasn't been totally borked. Unfortunately, most users (that I have worked with) don't understand how to use these features properly, leading to a multitude of math crimes.
Bricklin’s teachers at Harvard thought he was wasting his time: why would a manager want to do a spreadsheet on one of those “toy” computers?
or the one about the origins of the telephone:
The invention is practically worthless. Don't through your money away!
Creating a spreadsheet model is similar to creating a Knowledge Representation of a financial or mathematical system. The interdependencies within the spreadsheet mimic variables whose values are tied together by causation.
Does anyone know if there is a spreadsheet interface for some of the CLP or Prolog programming systems?
That was a long time ago, Open Office still does not have this -- since I last looked. Think if emacs lost its elisp editable recording keyboard macros for some reason, what a loss. This is evidence progress is not monotonic increasing.
Great article.
