Excel as a Turing-complete Functional Programming Environment

Since the calculation engine of Excel was the subject of a major upgrade to accommodate Dynamic Arrays in 2018 there has been a series of seismic changes to the art of building spreadsheet solutions. This paper will show the ad-hoc end user practices of traditional spreadsheets can be replaced by ra...

Full description

Saved in:
Bibliographic Details
Published inarXiv.org
Main Author Bartholomew, Peter
Format Paper
LanguageEnglish
Published Ithaca Cornell University Library, arXiv.org 31.08.2023
Subjects
Functional programming
Programming environments
Spreadsheets
Online AccessGet full text

Cover

More Information
Summary:Since the calculation engine of Excel was the subject of a major upgrade to accommodate Dynamic Arrays in 2018 there has been a series of seismic changes to the art of building spreadsheet solutions. This paper will show the ad-hoc end user practices of traditional spreadsheets can be replaced by radically different approaches that have far more in common with formal programming. It is too early to guess the extent to which the new functionality will be adopted by the business and engineering communities and the impact that may have upon risk. Nevertheless, some trends are emerging from pioneering work within the Excel community which we will discuss here.
Bibliography:content type line 50
SourceType-Working Papers-1
ObjectType-Working Paper/Pre-Print-1
ISSN:2331-8422