11–14 of 14 posts
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.
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 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.
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?