3 ms·
Science is probably the least scary thing that an Excel bug can affect. JPMorgan Chase's "London Whale" venture lost $2 billion in part because spreadsheet mode
by sevenless 10y ago
Science is probably the least scary thing that an Excel bug can affect. JPMorgan Chase's "London Whale" venture lost $2 billion in part because spreadsheet modelers divided by a sum instead of an average to get a value at risk.
https://baselinescenario.com/2013/02/09/the-importance-of-excel/ https://baselinescenario.com/2013/02/09/the-importance-of-ex...
Then there was the infamous Reinhart-Rogoff paper in economics, used to justify harmful austerity policies worldwide post-2008, that came to false conclusions using a row formula that wasn't updated.
https://www.washingtonpost.com/news/wonk/wp/2013/04/16/is-the-best-evidence-for-austerity-based-on-an-excel-spreadsheet-error/ https://www.washingtonpost.com/news/wonk/wp/2013/04/16/is-th...
- woliveirajr 10y agoThat's not excel bug. I've seen co-workers getting wrong results due to a wrong copy-and-paste, where no attention was paid. This is no bug: it's a misuse off the program. Know your tools is always a good advice.
- sevenless 10y agoIt is a bug. There is no way to stop Excel from automatically turning certain strings in files that it reads in, into dates.