News for hackers. Stuff that matters.
Re:Ask HN: Do you feel Excel is dangerously overused? by brudgers on Monday May 11, 2015 @09:24AM (#9524493)
People have "voted with their feet". That is why they use Excel...and before it Lotus 123...speaking of which my experience of editing letters that the VP of Engineering wrote in 123 is illustrative of why people use Excel for so many things: when faced with a problem Excel is cheap and available (and by cheap I mean the purchase is already a sunk cost). The VP of Engineering wasn't budgeted for a copy of Word Perfect and had he been he probably wasn't going to have the time to learn how to use it before the letter needed to be out.

There is, at least in my mind, perhaps a lesson for a prospective MBA here. People are not stupid and when everyone is doing something that isn't ideal, it may be because it is good enough or even the best alternative in practice. Part of the reason there isn't a large open source community around Excel is that there good professional support is ubiquitous and Excel has commercial grade documentation in such a diversity of forms that there is something close to any user's particular needs or expectations.

http://www.dummies.com/how-to/computers-software/Software-Fo...

Re:Ask HN: Do you feel Excel is dangerously overused? by rskar on Monday May 11, 2015 @09:54AM (#9524697)
Adding to brudgers comment:

Rather than "Excel dangerously overused", I feel that technology is generally overused in an undisciplined unmindful inefficient way. Excel is often presented as the exemplary to such overuse.

I think that's because people who are motivated to come up with a solution to their common or more pressing problems of the day will naturally reach for the immediately accessible tools, and the more familiar the tool the better. In the usual corporate environment, Excel is already available for use.

Such people will be subjected to annual reviews that will not explicitly include any acquired or proven computer savviness. Instead they will be measured against the expectations of their job roles, which is likely not "applications developer". If they manage to create custom tools (via Excel or the many other manifestations of Microsoft Office) that have empirically demonstrated their worth to somehow become part of the production environment, then so much the better as far as the department or business is concerned (at least at first).

These people are not looking to become programmers. And besides, corporate desktops have gotten tremendously locked down since the late 1990's. It would take a fair bit of effort to make a business case to allow for some other computing environment (or tool) to be put on a corporate device. Which means experimentation would have to be done at home on their own time. Has it been mentioned that these people are not looking to become programmers?

We should put this sort of situation in perspective, and celebrate that there were and are folks willing to really learn a tool sufficiently as part of their problem solving in becoming more effective in their job roles. At some point of course the home-grown Excel-based solution will hit its limitations, which is where we as the truly expert computing professional types step in and get to work. If you really understand Excel and VBA and COM, you can really tease out quite a bit of the user story and business logic out the Excel "prototype" and come up with the more elegant solution.

And we can do this because we should be well versed at using this sort of technology in a more disciplined mindful efficient way.

Re:Ask HN: Do you feel Excel is dangerously overused? by collyw on Tuesday May 12, 2015 @04:20AM (#9530212)
The problem is that prototypes hardly ever remain prototypes and get hacked and hacked until they are a true nightmare.
Re:Ask HN: Do you feel Excel is dangerously overused? by davidgerard on Monday May 11, 2015 @12:34PM (#9525965)
I've had a manager who literally asked if we could work out some way to use a spreadsheet to do word processing in. This was DOS-era spreadsheets.
Re:Ask HN: Do you feel Excel is dangerously overused? by brudgers on Monday May 11, 2015 @06:14PM (#9528208)
In fairness, in the days before MSDOS shipped with `edit`, using Lotus 123 was a big step up from edlin because you didn't have to hold so much in your head.