Abstract:Amongst the large number of write-and-throw-away spreadsheets developed for one-time use there is a rather neglected proportion of spreadsheets that are huge, periodically used, and submitted to regular update-cycles like any conventionally evolving valuable legacy application software. However, due to the very nature of spreadsheets, their evolution is particularly tricky and therefore error-prone. In our strive to develop tools and methodologies to improve spreadsheet quality, we analysed consolidation spreadsheets of an internationally operating company for the errors they contain. The paper presents the results of the field audit, involving 78 spreadsheets with 60,446 non-empty cells. As a by-product, the study performed was also to validate our analysis tools in an industrial context. The evaluated auditing tool offers the auditor a new view on the formula structure of the spreadsheet by grouping similar formulas into equivalence classes. Our auditing approach defines three similarity criteria between formulae, namely copy, logical and structural equivalence. To improve the visualization of large spreadsheets, equivalences and data dependencies are displayed in separated windows that are interlinked with the spreadsheet. The auditing approach helps to find irregularities in the geometrical pattern of similar formulas.

Teaching Spreadsheets: Curriculum Design Principles

Milestones for Teaching the Spreadsheet Program

Overview and main results of the DidaTab project

From Good Practices to Effective Policies for Preventing Errors in Spreadsheets

Edu-Edition Spreadsheet Competency Framework

Teaching spreadsheet development using peer audit and self-audit methods for reducing error

Qtier-Rapor: Managing Spreadsheet Systems & Improving Corporate Performance, Compliance and Governance

Spreadsheet Development Methodologies using Resolver: Moving spreadsheets into the 21st Century

Interpretation as a factor in understanding flawed spreadsheets

Integrating Spreadsheet Engineering in a Management Science Course: A Hierarchical Approach

Improving Feedback from Automated Reviews of Student Spreadsheets

Subject integration with spreadsheets -- Ignoring education is the greatest risk ever

Research Strategy and Scoping Survey on Spreadsheet Practices

Stop That Subversive Spreadsheet!

Exploring Higher Education Competencies through Spreadsheet Self-Assessment and Time

In Pursuit of Spreadsheet Excellence

Teaching statistics with Excel and R

Comparison of Spreadsheets with other Development Tools (limitations, solutions, workarounds and alternatives)

A Spreadsheet Auditing Tool Evaluated in an Industrial Context

The Paradox of Spreadsheet Self-Efficacy: Social Incentives for Informal Knowledge Sharing in End-User Programming

Teaching methods are erroneous: approaches which lead to erroneous end-user computing