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.

How a spreadsheet helped me to land my dream job

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

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

Milestones for Teaching the Spreadsheet Program

A year in the life: what I learnt from using a time-tracking spreadsheet

Spreadsheets, Software, Storytelling, Visualization, Lifelong Learning: Essential Data Skills for Journalism and Strategic Communication Students

Exploring Higher Education Competencies through Spreadsheet Self-Assessment and Time

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

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

Spreadsheet Hell

Teaching Spreadsheets: Curriculum Design Principles

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

The Future of Spreadsheets in the Big Data Era

Characteristics of Spreadsheets Developed with the SSMI Methodology

Seek for Success: A Visualization Approach for Understanding the Dynamics of Academic Careers

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

Excel in the Teaching of Several Commonly Used Functions

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

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

In Pursuit of Spreadsheet Excellence

Querying Spreadsheets: An Empirical Study