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

Spreadsheets are often used by multiple people, and each user can add, change or remove data. There are some issues with this, most prominently the fact that users have different needs: They may need only a subset of features that is different for each user. These features can occur in different places in different files, Read more about Towards the Design and Implementation of Aspect-Oriented Programming for Spreadsheets – Jorge Mendes[…]

Live-Inspection of Spreadsheets – Daniel Kulezs

There are many tools for anomaly detection available, and most of them have a ‘scan’ button. But users do not hit this button too often, so why not make it ‘live’? This seems to be an approach that works well for traditional programming. The implementation seems simple, you just have to implement a few triggers Read more about Live-Inspection of Spreadsheets – Daniel Kulezs[…]

Using Calculation Fragments for Spreadsheet Testing and Debugging – Thomas Schmitz

Existing spreadsheet testing approaches assume that users can define test cases, or correct input values. But, this can be challenging for users. Thomas’s idea is to split a given spreadsheet in parts to make it easier for users to test parts. Therefore, they have to be easy to understand and loosely coupled. They start with Read more about Using Calculation Fragments for Spreadsheet Testing and Debugging – Thomas Schmitz[…]

Toward Reverse Engineering of VBA Based Excel Spreadsheets Applications – Domenico Amalfitano, Nicola Amatucci, Vincenzo De Simone, Anna Rita Fasolino and Porfirio Tramontana

Spreadsheets are commonly used (no surprise there) and comprehension is needed in many scenarios. Comprehension can be hard though, because there is no clear distinction between different layers: data, calculation and visualization. The use of VBA increases the complexity, as users can introduce user defined functions and form elements and even override existing functionality. Vincenzo’s Read more about Toward Reverse Engineering of VBA Based Excel Spreadsheets Applications – Domenico Amalfitano, Nicola Amatucci, Vincenzo De Simone, Anna Rita Fasolino and Porfirio Tramontana[…]

Structured Spreadsheet Modeling and Implementation – Paul Mireault

Paul is now retired, but taught Decision Support Systems in the 80s and 90s. Initially students used IFPS (Interactive Financial Programming System, no longer in existence) but gradually he moved on to Lotus 123 and then Excel. The goal was not to teach Excel (as in what button is where) but rather how to use Read more about Structured Spreadsheet Modeling and Implementation – Paul Mireault[…]