Abstract:Spreadsheets are a widespread functional programming paradigm that offer liveness and directness of interaction. However, spreadsheets are notoriously error-prone and difficult to debug. To overcome this limitation and improve the expressive power of spreadsheets, we propose an extension to the spreadsheet paradigm in the form of sheet-defined lambdas – user-defined functions that abstract computations on the sheet. This concept was developed and deployed in our web-based spreadsheet application named Lattice. We evaluate this approach through a user study which compared the user experience of programming in a spreadsheet with and without lambdas, as well as the difference in performance between learner (N = 12) and experienced (N = 12) programmers. The study measured participant task performance (task time, success rate and number of errors) and the quality of their user experience of using Lattice (video recordings of use, interviews and questionnaire responses). Our findings indicate that programming with lambdas is not only more efficient than writing formulas in a conventional way, but also provides a rewarding hedonic experience. However, we found that learners perceived the concept of functional abstractions with lambdas as difficult to comprehend; while experienced programmers noted potential utilitarian advantages that aid in managing the complexity of a spreadsheet program. The results obtained in this work contribute to a better understanding of human-spreadsheet interaction and can inform the future design of user-friendly computational systems.

Excel as a Turing-complete Functional Programming Environment

Will Dynamic Arrays finally change the way Models are built?

A Structured Approach to the development of Solutions in Excel

Online partial evaluation of sheet-defined functions

Excel: Automated Ledger or Analytics IDE?

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

To Abstract or Not to Abstract? A Comparative Study Evaluating the User Experience of Spreadsheet Programming with Sheet-Defined Functional Abstractions

Excelsior: Bringing the Benefits of Modularisation to Excel

Mitigating Spreadsheet Risk in Complex Multi-Dimensional Models in Excel

Managing the Hyflex Scheduling Activity Using Excel Dynamic Arrays

PERFORMANCE RESEARCH AND IMPROVEMENT ON AN ENTERPRISE SPREADSHEET ENGINE

InstructExcel: A Benchmark for Natural Language Instruction in Excel

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

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

The Future of Spreadsheets in the Big Data Era

Source Code Protection for Applications Written in Microsoft Excel and Google Spreadsheet

Enhanced Spreadsheet Computing with Finite-Domain Constraint Satisfaction

Excel Spreadsheet Analyzer

Spreadsheet computing with Finite Domain Constraint Enhancements

Experimenting with ChatGPT for Spreadsheet Formula Generation: Evidence of Risk in AI Generated Spreadsheets

Documenting Spreadsheets with Pseudo-Code: an Exercise with Cash-Flow and Loans