Advanced Aircraft Analysis (AAA) vs. Spreadsheets

Are you still designing airplanes using spreadsheets? Did you know that on average 88% of spreadsheets contain errors.1 Do you really want to risk your design or analysis to be incorrect? Did you use the correct conversion factors? Is the data linked to the correct cell? How hard is it to debug your spreadsheet?

AAA has been tested and verified to give you confidence in your calculations while reducing the risk of costly errors that could affect your reputation, bottom line or worse: pilot and passenger safety.

Dangers of Using Spreadsheets

A disturbingly high percentage of professional, corporate spreadsheets contain errors.

"Close to 90% of spreadsheet documents contain errors, a 2008 analysis of multiple studies suggests. “Spreadsheets, even after careful development, contain errors in 1% or more of all formula cells,” writes Ray Panko, a professor of IT management at the University of Hawaii and an authority on bad spreadsheet practices. “In large spreadsheets with thousands of formulas, there will be dozens of undetected errors.” 1 (Graphic 2)

Are you confident that your spreadsheet is error free because of your experience and thoroughness?

"When Brown and Gould (Brown & Gould, 1987) gave three spreadsheet development tasks to nine highly experienced spreadsheet developers, all made at least one error, and 63% of the spreadsheets overall had errors. Yet when asked about their confidence in the correctness of their spreadsheets, their median score was "very confident." 3

You may think your spreadsheet is properly debugged, with various checkups and multiple eyes inspecting the code, but think again.

"In three experiments that involved individual subjects code inspecting spreadsheets seeded with errors, subjects also caught about half of all errors or fewer (Galletta et al., 1993; Galletta, Hartzel, Johnson, & Joseph, 1997; Panko & Sprague, 1998)." 3

What is the potential magnitude of having spreadsheets errors?

"JPMorgan Chase lost more than $6 billion in its “London Whale” incident, in part due to spreadsheet errors." 4

5

Benefits of a Tested and Verified Commercial Software Product Like AAA

References

  1. 88% of Spreadsheets Have Errors - Jeremy Olshan, MarketWatch
    http://www.marketwatch.com/story/88-of-spreadsheets-have-errors-2013-04-17
  2. Cost Management Pitfalls: the Top 6 Spreadsheet Errors - Hard Dollar
    http://harddollar.com/cost-management-pitfalls-the-top-6-spreadsheet-errors/
  3. What We Know About Spreadsheet Errors - Raymond R. Panko, University of Hawai'i
    http://panko.shidler.hawaii.edu/SSR/Mypapers/whatknow.htm
  4. Spreadsheet Errors - Giles Farrow, LiveDataset
    http://livedataset.com/spreadsheet-errors/
  5. Sorry, Your Spreadsheet Has Errors (Almost 90% Do) - Stuart Leung, Salesforce on Forbes / Business
    http://www.forbes.com/sites/salesforce/2014/09/13/sorry-spreadsheet-errors/#6e72ecec7667