30th Hawaii International Conference on System Sciences (HICSS) Volume 3: Information System Track-Organizational Systems and Technology Maui, Hawaii January 03-January 06 ISBN: 0-8186-7743-0
Past research has shown that errors are relatively common in all types of spreadsheets. As spreadsheets are used widely by executives in analyzing financial, budgeting and forecasting problems to support their decision making, it is very important that spreadsheets are accurate. Errors undetected in spreadsheets may have undesirable consequences as they may adversely impact the firm's bottom line as well as the firm 's competitiveness. In this paper, we investigate the types of errors that occur for a simple domain-free spreadsheet model. We also show that spreadsheet errors can be difficult to detect during "what" analysis (i.e., when design parameters are changed) when the spreadsheets are not properly designed. The results show that most students do not take due care in designing their spreadsheets. The study appears to suggest that in teaching spreadsheets, emphasis must be placed on creating a comprehensible design that enables easy detection of errors and easy maintenance.
Citation:
Thompson SH Teo, Margaret Tan, "Quantitative and Qualitative Errors in Spreadsheet Development," hicss, vol. 3, pp.149, 30th Hawaii International Conference on System Sciences (HICSS) Volume 3: Information System Track-Organizational Systems and Technology, 1997 Usage of this product signifies your acceptance of the Terms of Use. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||