Skip to main content
SpringerLink
Log in

Quality Control in Spreadsheets: A Visual Approach using Color Codings to Reduce Errors in Formulae

  • Published:
Software Quality Journal Aims and scope Submit manuscript

Abstract

This paper presents continuing work conducted towards the development of an effective methodology for integrity control in the process of spreadsheet development. The framework for spreadsheet quality control is mainly aimed at addressing the widespread problem of errors in spreadsheet formulae. Two approaches are considered herein. The first addresses the wide-spread problem of formulae not reflecting the real-world phenomenon they are supposed to represent. The second addresses the wide-spread problems associated with the incorrect or inappropriate relative copying of formulae on the spreadsheet surface.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

References

  • Chadwick, D., Knight, J., and Clipsham, P. 1997. Information integrity in end-user systems. Proc. First Ann. IFIP TC-11 Working Group 11.5 Working Conf. on Integrity and Internal Control in Information Systems, Zurich, Switzerland, pp. 273-292.

  • Hendry, D.G. and Green, T.R.G. 1994. A cognitive interpretation of what users think of the spreadsheet model, Int. J. Human-Computer Studies 40: 1033-1065.

    Google Scholar 

  • KPMG Financial Modelling Department (London). 1997. Executive Summary: Financial Model Review Survey.

  • Panko, R.R. and Halverson, R.P. Jr. 1996. Spreadsheets on trial: A framework for research on spreadsheet risks. Proc. 29th Hawaii Int. Conf. System Sciences, Maui, Hawaii.

  • Rajalingham, K. and Chadwick, D. 1998. Integrity control of spreadsheets: Organisation & tools. Proc. 2nd Annual IFIP TC-11 Working Group 11.5 Working Conf. Integrity and Internal Control in Information Systems, Virginia, pp. 147-168.

  • Ward, M. 1997. Fatal addition. New Scientist.

Download references

Author information

Authors and Affiliations

  1. Information Integrity Research Centre, School of Computing & Mathematical Sciences, University of Greenwich, UK

    David Chadwick, Brian Knight & Kamalasen Rajalingham

Authors
  1. David Chadwick
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Brian Knight
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Kamalasen Rajalingham
    View author publications

    You can also search for this author in PubMed Google Scholar

Rights and permissions

Reprints and permissions

About this article

Cite this article

Chadwick, D., Knight, B. & Rajalingham, K. Quality Control in Spreadsheets: A Visual Approach using Color Codings to Reduce Errors in Formulae. Software Quality Journal 9, 133–143 (2001). https://doi.org/10.1023/A:1016631003750

Download citation

  • Issue Date:

  • DOI: https://doi.org/10.1023/A:1016631003750

Search

Navigation