Healthy Family
  • Home
  • Business
    • Business Ideas
  • Education
  • Health
    • Beauty
  • Home Improvement
  • Lifestyle
    • Entertainment
    • Fashion
    • Family
    • Wedding
    • Shopping
  • Sport
  • Technology News
    • Apps Marketing
    • Digital Marketing
    • Internet Marketing
    • Social Media
    • Web Design
  • Travel
Home  /  Reviews  /  Five catastrophic Excel spreadsheet stories

Five catastrophic Excel spreadsheet stories

Trev December 09, 2019 Reviews Comments are off

For three decades, Excel has been the standard for report generation and data analysis. However, it’s not a one-size-fits-all solution and a simple error can cause disastrous results.

It’s been reported that almost 9 out of 10 spreadsheets carry errors. Here are 5 of the most catastrophic:

Image Credit

Copy-and-paste

The easiest error to make is via copy-and-paste as JPMorgan Chase discovered in 2012, to the cost of $6.5 billion. A finance employee copied and pasted the wrong information between spreadsheets. The formulae weren’t adjusted within the copied cells, resulting in a miscalculation of their synthetic credit portfolio. It became the largest financial loss they had suffered.

Too many zeros

Another common and often costly error comes from not counting those zeros carefully enough. Back in 2005, an employee of Eastman Kodak (or Kodak as it was then) added a few zeros too many to the employment termination benefits and pension data of another employee. It inflated severance pay figures by $11 million. News of the error caused the company’s stock to fall sharply, at a time when Kodak was already losing money.

Honest mistake

Fannie Mae, a US Government sponsored enterprise that guarantees mortgages, made an error in its financials to the tune of $1.136 billion. The discrepancy was described as being due to honest mistakes made in a spreadsheet.

Image Credit

Missing minus sign

In 1995, Fidelity Investments had to cancel a share dividend they’d promised to pay on their Magellan fund, due to their dividend estimates being out by $2.6 billion. The fund had a net capital loss of $1.3 billion, but while transferring records onto an Excel spreadsheet, a tax accountant had missed off the minus sign, making it look like a net capital gain.

A missed cell in the formula

Emerson Electric ended up with a discrepancy of $3.7 million, due to the contents of a single cell being excluded from a formula that calculated total expenses.

Simple errors can lead to catastrophic results if work is not checked carefully. Even PDF to Excel conversions using tools such as https://pdftables.com/convert-pdf-to-excel require some kind of manipulation afterwards and a second pair of eyes to check for errors.

To avoid becoming the subject of the next Excel horror story, always make sure you get a colleague to check your work first.

Previous Article
Next Article

About Author

Trev

Related Posts

  • Maximising the heat in the home.

    January 5, 2021
  • Qualifications a tree surgeon should have.

    November 30, 2020
  • Where did CCTV begin?

    August 4, 2020

Tweets

Recent Posts

  • The Value of a Garage January 7, 2021
  • Maximising the heat in the home. January 5, 2021
  • Replacement windows – what to think about January 5, 2021
  • Are you using social media to its fullest. January 5, 2021

Categories

  • Auto
  • Beauty
  • Business
  • Business Ideas
  • Digital Marketing
  • Education
  • Entertainment
  • Family
  • Fashion
  • Foreign Content
  • Health
  • Home Improvement
  • Lifestyle
  • Reviews
  • Shopping
  • Social Media
  • Sport
  • Technology News
  • Travel
  • Web Design
  • Wedding

Recent Posts

  • The Value of a Garage
  • Maximising the heat in the home.
  • Replacement windows – what to think about
  • Are you using social media to its fullest.
  • Drivers crashing supercars

Category Posts

Pages

  • Home
  • Contact Us
  • Terms & Conditions

Random Posts

  • Six kitchen trends for 2019 January 4, 2019
  • From engines to kids toys April 11, 2017
  • Signs of a cockroach infestation May 1, 2020
  • How headstones are installed April 29, 2020

Tags

Apple Apple carplay Auto Babysitter cooking Eat employees Facebook feedback home How To McLaren Mercedes-Maybach 6 New Hyundai i10 osteoporosis PayPal Prepare prevent Raw food treat osteoporosis trending woman yoga exercises
Theme by ThemesPie | Proudly Powered by WordPress