Excel spreadsheet misuse
-
- PlatinumLounger
- Posts: 5513
- Joined: 24 Jan 2010, 08:33
- Location: A cathedral city in England
Excel spreadsheet misuse
For a brief account of various Excel disasters over the years, I recommend this website.
John Gray
A car crashed into a barrier at speed; nobody was injured, but a front wheel became detached, and slowly rolled down the road.
Driver [sings]: "You picked a fine time to leave me, Loose Wheel"
A car crashed into a barrier at speed; nobody was injured, but a front wheel became detached, and slowly rolled down the road.
Driver [sings]: "You picked a fine time to leave me, Loose Wheel"
-
- Administrator
- Posts: 79561
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Excel spreadsheet misuse
I really love Excel, but I too have seen many horrible uses of spreadsheets. That it's being used to manage critical business accounts is madness.
Best wishes,
Hans
Hans
-
- Administrator
- Posts: 12833
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: Excel spreadsheet misuse
I have seen many cases where someone used Excel to prototype an approach, and then that became permanent. Usually even the person who developed the spreadsheet thought this was a terrible idea. This is almost always down to poor governance within the organization.
StuartR
-
- PlatinumLounger
- Posts: 5513
- Joined: 24 Jan 2010, 08:33
- Location: A cathedral city in England
Re: Excel spreadsheet misuse
Quite often I've seen an Excel spreadsheet being used (usually by an accountant, who 'understands' spreadsheets) rather than a Word table, which would have been more appropriate in the particular circumstance.
John Gray
A car crashed into a barrier at speed; nobody was injured, but a front wheel became detached, and slowly rolled down the road.
Driver [sings]: "You picked a fine time to leave me, Loose Wheel"
A car crashed into a barrier at speed; nobody was injured, but a front wheel became detached, and slowly rolled down the road.
Driver [sings]: "You picked a fine time to leave me, Loose Wheel"
-
- PlutoniumLounger
- Posts: 16307
- Joined: 24 Jan 2010, 23:23
- Location: brings.slot.perky
Re: Excel spreadsheet misuse
The Covid-cases was probably caused by an elected official who knew about Excel, and insisted that Excel be used (so that he/she had a chance of understanding it).John Gray wrote: ↑09 May 2023, 08:48For a brief account of various Excel disasters over the years, I recommend this website.
Twenty years ago I was hired for a day to help a high-priced vacation package firm improve their workbook. These folks charge $5,00 per day per person for luxury vacations.
The clerk was untrained.
I watched as she typed in 5000 for the price per day, under that typed in 8 for the number of people, reached across he desk to grab the solar-powered calculator and typed in 5000*8= and then typed 40000 into the third cell. She had no idea that Excel could calculate!
My current "client" uses Excel for data-entry and calculation, which is progress over twenty years, but again, no training in Excel, so the data entry and calculations are on the same sheet (which is akin to using DATA statements to hold your payroll data inside your BASIC payroll program, i think). And so the data entry clerks frequently type a value over a calculated cell. This in a sheet of Sunday Collection Plate data, so presumably the church issues fake tax-receipt statements for its parishioners each year!
I am thinking of a Word/VBA application with a GUI form for data input, a data file with encoded data (so that they can't work out how to edit it), and a second Word/VBA application to spit out reports, as my means of separating data-entry from calculations.
We never had this problem when we all used 80-column punched cards and (later) magnetic tapes. The operators kept the calculations and the data in separate containers!
Cheers, Chris
If it isn't one thing it's another, and very often both. E.F.Benson
-
- Microsoft MVP
- Posts: 1338
- Joined: 24 May 2013, 15:33
- Location: Warminster, PA
Re: Excel spreadsheet misuse
Quite a few of the instances reported in that article don't seem to have been caused by the use of Excel, and would have occurred regardless of the tool being used. For example,
I've seen plenty of foul-ups in "serious" programming, most of which were caught (or should have been caught) by a mandatory review by colleagues.The county says recently approved salary increases were “inadvertently omitted in the calculations.” Basically, someone forgot to include those numbers in the spreadsheet.
-
- PlutoniumLounger
- Posts: 16307
- Joined: 24 Jan 2010, 23:23
- Location: brings.slot.perky
Re: Excel spreadsheet misuse
Absolutely Correct!Jay Freedman wrote: ↑09 May 2023, 14:44Quite a few of the instances reported in that article don't seem to have been caused by the use of Excel, and would have occurred regardless of the tool being used.
Towards the end of my period of paid employment I realized that whenever someone called me in "because we have a computer problem" that it was never a computer problem.
It was always, no exceptions, a people problem.(1)
This makes sense when we think of computers as "machines" and look at motor-vehicles.
Cars do not cause collisions.
Across the street from me is a house lot which has a four-wheeler parked within. That car has not caused a collision since midnight.
And that car will not cause a problem at any time in the future.
But once a human being (with car keys) gets into the car, watch out for the possible Ka-Boom!
My new laptop causes no problems.
But once I fire up Excel, or MSWord/VBA, or MSPaint or any other application - Watch Out!
Back in 1969 Quentin von Abbe and I discovered a hardware bug in a CDC 3300 mainframe, but that is the only hardware malfunction I have discovered in 50 years of wrestling with the beasts.
I would argue that the problems caused by a hard disk crash are really the problems that arise because a human did not implement proper backup procedures.
Cheers, Chris
(1) I suspect that 90% of the time the people problem was "lack of proper training"
C.
If it isn't one thing it's another, and very often both. E.F.Benson
-
- PlutoniumLounger
- Posts: 16307
- Joined: 24 Jan 2010, 23:23
- Location: brings.slot.perky
Re: Excel spreadsheet misuse
Updated today "Just to let you know that we have now completely updated our horror stories page!"John Gray wrote: ↑09 May 2023, 08:48For a brief account of various Excel disasters over the years, I recommend this website.
Cheers, Chris
If it isn't one thing it's another, and very often both. E.F.Benson
-
- PlatinumLounger
- Posts: 5513
- Joined: 24 Jan 2010, 08:33
- Location: A cathedral city in England
Re: Excel spreadsheet misuse
Thanks, Chris. The horrors continue...
John Gray
A car crashed into a barrier at speed; nobody was injured, but a front wheel became detached, and slowly rolled down the road.
Driver [sings]: "You picked a fine time to leave me, Loose Wheel"
A car crashed into a barrier at speed; nobody was injured, but a front wheel became detached, and slowly rolled down the road.
Driver [sings]: "You picked a fine time to leave me, Loose Wheel"