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

• A Simple Baseline for Predicting Events with Auto-Regressive Tabular Transformers [70.20477771578824]
  Existing approaches to event prediction include time-aware positional embeddings, learned row and field encodings, and oversampling methods for addressing class imbalance. We propose a simple but flexible baseline using standard autoregressive LLM-style transformers with elementary positional embeddings and a causal language modeling objective. Our baseline outperforms existing approaches across popular datasets and can be employed for various use-cases.
  arXiv  Detail & Related papers  (2024-10-14T15:59:16Z)
• Excel: Automated Ledger or Analytics IDE? [0.0]
  Spreadsheets have undergone a gradual transformation, evolving from simple ledger automation tools to the current state of Excel. Excel includes a fully functional database, an OLAP Engine, multiple statistical programming languages, multiple third-party software libraries, dynamic charts, and real time data connectors. The importance of establishing a comprehensive risk framework for managing this distinctive development environment becomes clear.
  arXiv  Detail & Related papers  (2024-09-03T01:12:52Z)
• 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)
• 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)
• 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.