A Structured Approach to the development of Solutions in Excel

• URL: http://arxiv.org/abs/1704.01142v2
• Date: Mon, 5 Feb 2024 14:23:05 GMT
• Title: A Structured Approach to the development of Solutions in Excel
• Authors: Peter Bartholomew
• Abstract summary: 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.
• Score: 0.0
• License: http://arxiv.org/licenses/nonexclusive-distrib/1.0/
• Abstract: Spreadsheets offer a supremely successful democratisation platform, placing the manipulation and presentation of numbers within the grasp of users that have little or no mathematical expertise or IT experience. What appears to be almost completely lacking within a "normal" solution built using Excel default settings is the deployment of any structure that extends beyond a single-cell formula. The structural elements that allow conventional code to scale without escalating errors appear to be absent. This paper considers the use of controversial or lesser-used techniques to create a coherent solution strategy in which the problem is solved by a sequence of formulas resembling the steps of a programmed language.

Related papers

• Auto-Formula: Recommend Formulas in Spreadsheets using Contrastive Learning for Table Representations [36.2969566996675]
  We develop an Auto-Formula system that can accurately predict formulas that users want to author in a target spreadsheet cell. We use contrastive-learning techniques inspired by "similar-face recognition" from compute vision.
  arXiv  Detail & Related papers  (2024-04-19T03:28:18Z)
• Toward Unified Controllable Text Generation via Regular Expression Instruction [56.68753672187368]
  Our paper introduces Regular Expression Instruction (REI), which utilizes an instruction-based mechanism to fully exploit regular expressions' advantages to uniformly model diverse constraints. Our method only requires fine-tuning on medium-scale language models or few-shot, in-context learning on large language models, and requires no further adjustment when applied to various constraint combinations.
  arXiv  Detail & Related papers  (2023-09-19T09:05:14Z)
• Excel as a Turing-complete Functional Programming Environment [0.0]
  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.
  arXiv  Detail & Related papers  (2023-08-31T20:11:36Z)
• Conjunctive Query Based Constraint Solving For Feature Model Configuration [79.14348940034351]
  We show how to apply conjunctive queries to solve constraint satisfaction problems. This approach allows the application of a wide-spread database technology to solve configuration tasks.
  arXiv  Detail & Related papers  (2023-04-26T10:08:07Z)
• 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)
• CoreDiag: Eliminating Redundancy in Constraint Sets [68.8204255655161]
  We present a new algorithm which can be exploited for the determination of minimal cores (minimal non-redundant constraint sets) The algorithm is especially useful for distributed knowledge engineering scenarios where the degree of redundancy can become high. In order to show the applicability of our approach, we present an empirical study conducted with commercial configuration knowledge bases.
  arXiv  Detail & Related papers  (2021-02-24T09:16:10Z)
• 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)
• An Integer Linear Programming Framework for Mining Constraints from Data [81.60135973848125]
  We present a general framework for mining constraints from data. In particular, we consider the inference in structured output prediction as an integer linear programming (ILP) problem. We show that our approach can learn to solve 9x9 Sudoku puzzles and minimal spanning tree problems from examples without providing the underlying rules.
  arXiv  Detail & Related papers  (2020-06-18T20:09:53Z)
• ORCSolver: An Efficient Solver for Adaptive GUI Layout with OR-Constraints [63.59902335363947]
  ORCr is a novel solving technique for adaptive ORC layouts based on a branch-and-bound approach with preprocessing. We demonstrate that ORCr simplifies ORC specifications at runtime and our approach can solve ORC layout specifications efficiently at near-interactive rates.
  arXiv  Detail & Related papers  (2020-02-23T15:46:59Z)

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.