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

TL;DR

This paper introduces Resolver, a new spreadsheet program that addresses longstanding issues in traditional spreadsheets by integrating continuous display and code interaction, advancing spreadsheet development into the modern era.

Contribution

It presents Resolver, a novel spreadsheet system that combines continuous display and code interaction to improve development methodologies beyond traditional paradigms.

Findings

Resolver effectively tackles existing spreadsheet problems.

The system enables new development methodologies.

It aligns spreadsheet technology with modern programming advances.

Abstract

We intend to demonstrate the innate problems with existing spreadsheet products and to show how to tackle these issues using a new type of spreadsheet program called Resolver. It addresses the issues head-on and thereby moves the 1980's "VisiCalc paradigm" on to match the advances in computer languages and user requirements. Continuous display of the spreadsheet grid and the equivalent computer program, together with the ability to interact and add code through either interface, provides a number of new methodologies for spreadsheet development.