Quality control in spreadsheets: A visual approach using color codings to reduce errors in formulae
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.
spreadsheet visual color errors formulae development