News for hackers. Stuff that matters.
Re:Gene name errors are widespread in the scientific literature by sevenless on Wednesday August 24, 2016 @08:25AM (#12351479)
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-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-th...

Re:Gene name errors are widespread in the scientific literature by woliveirajr on Thursday August 25, 2016 @09:17PM (#12363709)
That'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.

Re:Gene name errors are widespread in the scientific literature by sevenless on Saturday August 27, 2016 @09:35AM (#12372280)
It is a bug. There is no way to stop Excel from automatically turning certain strings in files that it reads in, into dates.