Please use this identifier to cite or link to this item: https://doi.org/10.1016/S0950-5849(00)00130-0
Title: Strategies and visualization tools for enhancing user auditing of spreadsheet models
Authors: Chan, H.C. 
Ying, C.
Peh, C.B.
Issue Date: 2000
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
URI: http://scholarbank.nus.edu.sg/handle/10635/42472
ISSN: 09505849
DOI: 10.1016/S0950-5849(00)00130-0
Appears in Collections:Staff Publications

Show full item record
Files in This Item:
There are no files associated with this item.

SCOPUSTM   
Citations

5
checked on Dec 11, 2017

WEB OF SCIENCETM
Citations

5
checked on Dec 11, 2017

Page view(s)

37
checked on Dec 9, 2017

Google ScholarTM

Check

Altmetric


Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.