Spreadsheet Components For All
Jocelyn Paine

TL;DR
This paper introduces a web-based repository of spreadsheet components that users can easily integrate into their own spreadsheets, enabling complex calculations without programming expertise.
Contribution
It presents a prototype for a component repository that adapts reusable spreadsheet formula collections to various user-specific spreadsheet layouts.
Findings
Prototype demonstrates flexible component integration
Supports diverse spreadsheet sizes and shapes
Aims to improve spreadsheet calculation accessibility
Abstract
We have prototyped a "spreadsheet component repository" Web site, from which users can copy "components" into their own Excel or Google spreadsheets. Components are collections of cells containing formulae: in real life, they would do useful calculations that many practitioners find hard to program, and would be rigorously tested and documented. Crucially, the user can tell the repository which cells in their spreadsheet to use for a componen's inputs and outputs. The repository will then reshape the component to fit. A single component can therefore be used in many different sizes and shapes of spreadsheet. We hope to set up a spreadsheet equivalent of the high-quality numerical subroutine libraries that revolutionised scientific computing, but where instead of subroutines, the library contains such components.
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
