Authors
S. Kyle McKay
Abstract
Increasing computational power and memory capacity in desktop computers has resulted in access to numerical techniques previously unavailable to many users.
Although computational capabilities have increased, many users are unable to take full advantage of this power due to limited programming expertise. Spreadsheets offer these users a means to capitalize upon computational potential without extensive training, though spreadsheet models can confer risks due to high error rates and lack of quality control.
Sample
Strengths and shortcomings of spreadsheets.
Strengths:
- Inexpensive to develop.
- Readily available.
- Transferable to a broad user base.
- Simple, logical interfaces easily understood and applicable without extensive training.
- Built-in tools and third-party add-ins provide computational power without extensive programming.
- Current spreadsheet programs have many capabilities previously associated with more sophisticated software (e.g. optimization routines).
Shortcomings:
- False sense of confidence due to the easy output of "answers".
- Can quickly become complex.
- Error rates are high.
- Troubleshooting and error checking may be time-consuming and difficult (as is the case with all end-user computer programs).
- Written quality assurance and control techniques are not often applied due to reliance on self-policing.
Publication
2009, U.S. Army Engineer Research and Development Center, Technical note, September
