Please use this identifier to cite or link to this item:
|Title:||Strategies and visualization tools for enhancing user auditing of spreadsheet models|
|Authors:||Chan, H.C. |
|Source:||Chan, H.C., Ying, C., Peh, C.B. (2000). Strategies and visualization tools for enhancing user auditing of spreadsheet models. Information and Software Technology 42 (15) : 1037-1043. ScholarBank@NUS Repository. https://doi.org/10.1016/S0950-5849(00)00130-0|
|Abstract:||Spreadsheets are very widely used at various levels of the organization. Studies have shown that errors do occur frequently during the development of spreadsheet models. Empirical studies of operational spreadsheet models show that a large percentage of them contain errors. However, the identification of errors is difficult and tedious, and errors have led to drastically wrong decisions. It is thus important to develop new strategies and auditing tools for detecting errors. A suite of new auditing visualization tools have been designed and implemented in Visual Basic for Application (VBA), as an add-in module for easy inclusion in any Excel 97 or Excel 2000 installation. Furthermore, four strategies are proposed for detecting errors. These range from an overview strategy to identify logical components of the spreadsheet model, to specific strategies targeted at specific types of error. Illustrations show how these strategies can be supported with the new visualization tools.|
|Source Title:||Information and Software Technology|
|Appears in Collections:||Staff Publications|
Show full item record
Files in This Item:
There are no files associated with this item.
checked on Mar 8, 2018
WEB OF SCIENCETM
checked on Feb 6, 2018
checked on Mar 12, 2018
Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.