Reducing Spreadsheet Errors

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. Table 1 presents several strengths and weaknesses associated with using spreadsheets as numerical tools for the masses.

Open PDF

Document Details

Document Type
Technical Report
Publication Date
Sep 01, 2009
Accession Number
ADA508437

Entities

People

  • S. Kyle McKay

Organizations

  • United States Army Corps of Engineers

Tags

Communities of Interest

  • Energy and Power Technologies
  • Materials and Manufacturing Processes

DTIC Thesaurus Topics

  • Army Corps Of Engineers
  • Auditing
  • Basic Programming Language
  • Best Practices
  • Computer Programming
  • Computer Programs
  • Computers
  • Corporations
  • Data Sets
  • Data Storage Systems
  • Decision Support Systems
  • Engineers
  • Errors
  • Information Systems
  • Life Cycles
  • Quality Control
  • Spreadsheet Software

Readers

  • Computational Modeling and Simulation
  • Database Systems and Applications
  • Systems Analysis and Design