iBet uBet web content aggregator. Adding the entire web to your favor.
iBet uBet web content aggregator. Adding the entire web to your favor.



Link to original content: https://doi.org/10.1023/A:1016631003750
Quality Control in Spreadsheets: A Visual Approach using Color Codings to Reduce Errors in Formulae | Software Quality Journal Skip to main content
Springer Nature Link
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

    We’re sorry, something doesn't seem to be working properly.

    Please try refreshing the page. If that doesn't work, please contact support so we can address the problem.

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

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

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