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." 45
Benefits of a Tested and Verified Commercial Software Product Like AAA
- Advanced Aircraft Analysis has been under development for more than 25 years, at a cost of over 70,000 man hours and more than four million dollars.
- You will spend more in a two-month period developing your own in-house code, in man-hour cost alone, than if you purchased one commercial license of AAA.
- You will save over 80% in man-hour costs using AAA for preliminary design, versus using handbook and spreadsheet calculations.
- Using AAA will greatly reduce calculation errors.
- Being able to use multiple flight conditions (forward c.g., aft c.g., low speed, high speed, flaps up, flaps down, etc.) is a unique feature of AAA and significantly reduces time to track data and prevent potential errors.
- The "Recalculate All" feature in AAA is a significant time savings tool and allows you to export the data for different flight conditions into an Excel or text file. All plots for trim diagram, for example, can be saved as separate graphics files, using this same feature.
- We use AAA for our airplane design consulting services. We are constantly updating and refining the methods used, based on our research and wind tunnel tests that we perform. This leads to regular software version updates, which benefits all of our software clients.
- 88% of Spreadsheets Have Errors - Jeremy Olshan, MarketWatch
- Cost Management Pitfalls: the Top 6 Spreadsheet Errors - Hard Dollar
- What We Know About Spreadsheet Errors - Raymond R. Panko, University of Hawai'i
- Spreadsheet Errors - Giles Farrow, LiveDataset
- Sorry, Your Spreadsheet Has Errors (Almost 90% Do) - Stuart Leung, Salesforce on Forbes / Business