Excel as a Turing-complete Functional Programming Environment
- URL: http://arxiv.org/abs/2309.00115v1
- Date: Thu, 31 Aug 2023 20:11:36 GMT
- Title: Excel as a Turing-complete Functional Programming Environment
- Authors: Peter Bartholomew
- Abstract summary: The Excel calculation engine was the subject of a major upgrade to accommodate Dynamic Arrays in 2018.
This paper will show the ad-hoc end user practices of traditional spreadsheets can be replaced by radically different approaches.
It is too early to guess the extent to which the new functionality will be adopted by the business and engineering communities.
- Score: 0.0
- License: http://arxiv.org/licenses/nonexclusive-distrib/1.0/
- 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.
Related papers
- InstructExcel: A Benchmark for Natural Language Instruction in Excel [72.018640505825]
This work investigates whether Large Language Models can generate code that solves Excel specific tasks provided via natural language user instructions.
Our benchmark includes over 10k samples covering 170+ Excel operations across 2,000 publicly available Excel spreadsheets.
We observe that (1) using GPT-4 over GPT-3.5, (2) providing more in-context examples, and (3) dynamic prompting can help improve performance on this benchmark.
arXiv Detail & Related papers (2023-10-23T02:00:55Z) - Reducing Errors in Excel Models with Component-Based Software
Engineering [0.0]
LAMBDA is an Excel function that creates functions from Excel's formulas.
LAMBDA functions can be reused in any project just like any Excel function.
arXiv Detail & Related papers (2023-08-31T20:28:48Z) - Model Ratatouille: Recycling Diverse Models for Out-of-Distribution
Generalization [99.6826401545377]
Foundation models are redefining how AI systems are built. Practitioners now follow a standard procedure to build their machine learning solutions.
We propose model ratatouille, a new strategy to recycle the multiple fine-tunings of the same foundation model on diverse auxiliary tasks.
arXiv Detail & Related papers (2022-12-20T17:21:46Z) - Constructing Effective Machine Learning Models for the Sciences: A
Multidisciplinary Perspective [77.53142165205281]
We show how flexible non-linear solutions will not always improve upon manually adding transforms and interactions between variables to linear regression models.
We discuss how to recognize this before constructing a data-driven model and how such analysis can help us move to intrinsically interpretable regression models.
arXiv Detail & Related papers (2022-11-21T17:48:44Z) - Enhanced Spreadsheet Computing with Finite-Domain Constraint
Satisfaction [1.6244541005112747]
We present an enhanced spreadsheet system where finite-domain constraint solving is well supported in a visual environment.
A spreadsheet-specific constraint language is constructed for general users to specify constraints among data cells.
The new spreadsheet system significantly simplifies the development of many constraint-based applications.
arXiv Detail & Related papers (2022-02-22T17:58:08Z) - Spreadsheet computing with Finite Domain Constraint Enhancements [0.0]
We present a framework seamlessly incorporating a finite constraint solver with the spreadsheet computing paradigm.
The framework provides an interface for constraint solving and further enhances the spreadsheet computing paradigm.
arXiv Detail & Related papers (2022-02-22T17:50:48Z) - SpreadsheetCoder: Formula Prediction from Semi-structured Context [70.41579328458116]
We propose a BERT-based model architecture to represent the tabular context in both row-based and column-based formats.
We train our model on a large dataset of spreadsheets, and demonstrate that SpreadsheetCoder achieves top-1 prediction accuracy of 42.51%.
Compared to the rule-based system, SpreadsheetCoder 82% assists more users in composing formulas on Google Sheets.
arXiv Detail & Related papers (2021-06-26T11:26:27Z) - COG: Connecting New Skills to Past Experience with Offline Reinforcement
Learning [78.13740204156858]
We show that we can reuse prior data to extend new skills simply through dynamic programming.
We demonstrate the effectiveness of our approach by chaining together several behaviors seen in prior datasets for solving a new task.
We train our policies in an end-to-end fashion, mapping high-dimensional image observations to low-level robot control commands.
arXiv Detail & Related papers (2020-10-27T17:57:29Z) - Will Dynamic Arrays finally change the way Models are built? [0.0]
Spreadsheets offer a supremely successful and intuitive means of processing and exchanging numerical content.
Their ad-hoc nature makes it hugely popular for use in diverse areas including business and engineering.
Many would question whether it is suitable for serious analysis or modelling tasks.
arXiv Detail & Related papers (2020-06-25T21:18:41Z) - Einsum Networks: Fast and Scalable Learning of Tractable Probabilistic
Circuits [99.59941892183454]
We propose Einsum Networks (EiNets), a novel implementation design for PCs.
At their core, EiNets combine a large number of arithmetic operations in a single monolithic einsum-operation.
We show that the implementation of Expectation-Maximization (EM) can be simplified for PCs, by leveraging automatic differentiation.
arXiv Detail & Related papers (2020-04-13T23:09:15Z) - A Structured Approach to the development of Solutions in Excel [0.0]
This paper considers the use of controversial or lesser-used techniques to create a coherent solution strategy.
The problem is solved by a sequence of formulas resembling the steps of a programmed language.
arXiv Detail & Related papers (2017-04-04T18:22:26Z)
This list is automatically generated from the titles and abstracts of the papers in this site.
This site does not guarantee the quality of this site (including all information) and is not responsible for any consequences.