Abstract:A spreadsheet usually starts as a simple and single-user software artifact, but, as frequent as in other software systems, quickly evolves into a complex system developed by many actors. Often, different users work on different aspects of the same spreadsheet: while a secretary may be only involved in adding plain data to the spreadsheet, an accountant may define new business rules, while an engineer may need to adapt the spreadsheet content so it can be used by other software systems. Unfortunately, spreadsheet systems do not offer modular mechanisms, and as a consequence, some of the previous tasks may be defined by adding intrusive "code" to the spreadsheet. In this paper we go through the design and implementation of an aspect-oriented language for spreadsheets so that users can work on different aspects of a spreadsheet in a modular way. For example, aspects can be defined in order to introduce new business rules to an existing spreadsheet, or to manipulate the spreadsheet data to be ported to another system. Aspects are defined as aspect-oriented program specifications that are dynamically woven into the underlying spreadsheet by an aspect weaver. In this aspect-oriented style of spreadsheet development, different users develop, or reuse, aspects without adding intrusive code to the original spreadsheet. Such code is added/executed by the spreadsheet weaving mechanism proposed in this paper.

Implementation Strategies for Multidimensional Spreadsheets

Structured Spreadsheet Modelling and Implementation with Multiple Dimensions - Part 1: Modelling

Mitigating Spreadsheet Risk in Complex Multi-Dimensional Models in Excel

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

A Structured Approach to the development of Solutions in Excel

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

Characteristics of Spreadsheets Developed with the SSMI Methodology

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

Strategies for Addressing Spreadsheet Compliance Challenges

Structuring Spreadsheets with the "Lish" Data Model

Spreadsheet Validation and Analysis through Content Visualization

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

Milestones for Teaching the Spreadsheet Program

Now You're Thinking With Structures: A Concept for Structure-based Interactions with Spreadsheets

A Spreadsheet Auditing Tool Evaluated in an Industrial Context

In Pursuit of Spreadsheet Excellence

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

Multidisciplinary Engineering Models: Methodology and Case Study in Spreadsheet Analytics

Exploring Human Factors in Spreadsheet Development

Towards the Design and Implementation of Aspect-Oriented Programming for Spreadsheets

Excel: Automated Ledger or Analytics IDE?