Excel as a Turing-complete Functional Programming Environment
Peter Bartholomew

TL;DR
This paper explores how Excel's recent upgrades, especially Dynamic Arrays, enable it to function as a Turing-complete environment, allowing for more formal programming approaches in spreadsheet solutions.
Contribution
It demonstrates that Excel can be used as a Turing-complete programming environment, shifting from ad-hoc practices to formal programming methods.
Findings
Excel's Dynamic Arrays enable complex programming capabilities.
Emerging trends show adoption of formal programming in spreadsheets.
Potential impact on business and engineering practices.
Abstract
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.
Peer Reviews
No public reviews on file for this paper yet. If you reviewed it on a platform where reviews are public (OpenReview, ICLR, NeurIPS, ICML), you can paste yours below so the community can read it here.
Videos
No videos yet. Explain this paper in a talk, walkthrough, or lecture? Add one.
Taxonomy
TopicsSpreadsheets and End-User Computing
