Abstract:Spreadsheet technology is a cornerstone of IT systems in most organisations. It is often the glue that binds more structured transaction-based systems together. Financial operations are a case in point where spreadsheets fill the gaps left by dedicated accounting systems, particularly covering reporting and business process operations. However, little is understood as to the nature of spreadsheet usage in organisations and the contents and structure of these spreadsheets as they relate to key business functions with few, if any, comprehensive analyses of spreadsheet repositories in real organisations. As such this paper represents an important attempt at profiling real and substantial spreadsheet repositories. Using the Luminous technology an analysis of 65,000 spreadsheets for the financial departments of both a government and a private commercial organisation was conducted. This provides an important insight into the nature and structure of these spreadsheets, the links between them, the existence and nature of macros and the level of repetitive processes performed through the spreadsheets. Furthermore it highlights the organisational dependence on spreadsheets and the range and number of spreadsheets dealt with by individuals on a daily basis. In so doing, this paper prompts important questions that can frame future research in the domain.

Characteristics of Spreadsheets Developed with the SSMI Methodology

Spreadsheets Grow Up: Three Spreadsheet Engineering Methodologies for Large Financial Planning Models

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

Developing a Repeating Model Using the Structured Spreadsheet Modelling and Implementation Methodology

Multidisciplinary Engineering Models: Methodology and Case Study in Spreadsheet Analytics

A Paradigm for Spreadsheet Engineering Methodologies

Implementation Strategies for Multidimensional Spreadsheets

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

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

An Electronic Teaching Assistant for Basic Operations Management Methods

A Student-Centered Approach to the Business School Management Science Course

A Spreadsheet Auditing Tool Evaluated in an Industrial Context

Requirements for Automated Assessment of Spreadsheet Maintainability

Milestones for Teaching the Spreadsheet Program

Spreadsheets in Financial Departments: An Automated Analysis of 65,000 Spreadsheets using the Luminous Technology

The Semantic Spreadsheet

Exploring Higher Education Competencies through Spreadsheet Self-Assessment and Time

In Pursuit of Spreadsheet Excellence

Governance of Spreadsheets through Spreadsheet Change Reviews

A Case Study of Spreadsheet Use within the Finance and Academic Registry units within a Higher Education Institution

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