Excel as a Turing-complete Functional Programming Environment

EuSpRIG Proceedings 2023, ISBN: 978-1-905404-57-5 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...

Full description

Saved in:
Bibliographic Details
Main Author Bartholomew, Peter
Format Journal Article
LanguageEnglish
Published 31.08.2023
Subjects
Online AccessGet full text

Cover

Loading…
More Information
Summary:EuSpRIG Proceedings 2023, ISBN: 978-1-905404-57-5 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.
DOI:10.48550/arxiv.2309.00115