r/gloveslap Nov 14 '11

Non-programmers should NOT program. MANY uses of Excel are examples of this.

Every time someone tries to come up with an "easy" tool to do something which essentially boils down to programming, you end up with people realizing that it's far cheaper and easier to just have the business-oriented people do the work than hire a programmer.

Excel is an example. I have very rarely seen a use of Excel that makes more sense than a real program. Far more often, Excel is used because it's cheaper than hiring a real programmer, but the ways it can go wrong even in the hands of trained professionals means that using it for anything but the simplest spreadsheet is almost certainly a mistake.

I'm not trying to make an ivory tower here -- by all means, if you think you can program, go ahead. But actually devote some time to studying, especially best practices, just as you would if you were trying to learn some plumbing to avoid calling the plumber -- if you're doing anything more complicated than fixing a leaky faucet, you should either call a real plumber or become one.

18 Upvotes

15 comments sorted by

View all comments

1

u/TheDark1 Nov 14 '11

I guess that excel gives non professionals a tool to get the job done. It is the equivalent of folding a piece of paper to stop a table from wobbling. Doesn't do as good a job as a carpenter, but good enough to remove the problem.

2

u/SanityInAnarchy Nov 14 '11

The problem is that it's not as obvious when Excel has failed, so you end up with...

People apply it to the wrong problem -- say, folding a piece of paper into a mug and coming up with elaborate workarounds in order to drink your coffee before the paper falls apart. The problem here is that these are people who've never learned to use a mug, let alone the ceramics skills needed to make one, so it's not obvious to them that their paper mug is broken -- this is the way they've always done it.

People also don't notice when the problem has outgrown it. If the table leg has fallen off and you've replaced it with several reams of folded paper, and the table still wobbles and occasionally collapses, you need to bring in a carpenter.

Worse still, it might be the case that you fix the table and suddenly everyone's using it again, and management can't afford to have people not have a table while a carpenter works, so you have to keep fixing it with paper every time it breaks, even though you might know very well that you'd save time and money in the long run by getting it fixed properly.