Excel warriors Excel spreadsheet errors are pretty common, and they can have huge ramifications—for example, that time Canopy Growth accidentally posted a CA$52 million loss that should have been CA$155 million. So enjoy this novel piece on the "Excel warriors" that (sometimes) swoop in to save the world from spreadsheet disaster. Wired UK
The NASA analysis of excel spreadsheet O-ring temperature failure data had huge ramifications for the Space Shuttle Challenger disaster, is your spreadsheet disaster like that?
Here's a direct link to the article without all the added metadata: https://www.wired.co.uk/article/spreadsheet-excel-errors .
Also, you can actually write your own VBA code to check for all manner of errors, especially tailored to the particular sheet/book, and run it automatically.
So you think NASA was calculating all that shuttle data in Excel on a Macintosh back in 1986? I am darn sure they were using custom mainframe code for severe number crunching, not IBM ATs or early Macs
Yes, back then was the beginning of the great Puretick scam in futures trading. But the subsequent analysis of NASA's O-ring failure is a classical problem for advanced statistics (what pray tell is that) and yes using a Excel Spreadsheet. You had over 30 posts yesterday - like every 4-5 mins - get a life.