Spreadsheet failures, any recent examples? [Software]

posted by ElMaestro  – Belgium?, 2019-07-18 13:43 (439 d 14:54 ago) – Posting: # 20388
Views: 5,343

Hi all,

does anyone have recent examples of spreadsheet functions truly misbehaving with real-life realistic data?

I am not talking about for example the cases of standard deviations or variances that went funky when the application was fed extreme data ranges, or similar waterboarding of software, which was debated 10 years ago and which led regulators to conclude they were the only ones who could be trusted to make proper use of such pernicious creations.

Realistic.
Data.
Only.
Please.

I will leave it to the reader to quantitatively define what "realistic" and "recent" actually mean and I reserve the right to challenge the definitions, obviously :-D

Of course I ask because I never thought spreadsheets were or are as bad as their reputation. The users, on the other hand, are every bit as bad as their reputation. This certainly includes myself. Most likely I am the worst. But that will be the topic of another thread :-)

I could be wrong, but...

Best regards,
ElMaestro

R's base package has 274 reserved words and operators, along with 1761 functions. I can use 18 of them (about 14 of them properly). I believe this makes me the Donald Trump of programming.

Complete thread:

Activity
 Admin contact
21,086 posts in 4,398 threads, 1,468 registered users;
online 2 (0 registered, 2 guests [including 1 identified bots]).
Forum time: Wednesday 04:38 CEST (Europe/Vienna)

When puzzled, it never hurts to read the primary documents 
a rather simple and self-evident principle that has, nonetheless,
completely disappeared from large sectors
of the American experience.    Stephen Jay Gould

The Bioequivalence and Bioavailability Forum is hosted by
BEBAC Ing. Helmut Schütz
HTML5