Introducing Morphit, a new type of spreadsheet technology
Ted Hawkins, Andrew Lemon, Alec Gibson

TL;DR
This paper introduces Morphit, a novel spreadsheet technology that reduces errors by using structured tables with hierarchical fields and field-level formulas, enabling data modeling and reusability.
Contribution
Morphit presents a new spreadsheet design with structured tables and field-level formulas, improving error detection and supporting data modeling.
Findings
Enhanced error detection in spreadsheets
Hierarchical table organization improves clarity
Field-level formulas reduce referencing errors
Abstract
This paper describes a new type of spreadsheet which mitigates the errors caused by incorrect range referencing in formulae. This spreadsheet is composed of structured worksheets called tables which contain a hierarchical organization of fields. Formulae are defined at the field-level removing the need for positional references. In addition, relationships can be defined between fields in tables, allowing data to be modeled rather than simply processed and providing a re-usable framework for authoring spreadsheets. We shall describe the key features of tables with an emphasis on error detection and avoidance.
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 · Statistics Education and Methodologies · Advanced Database Systems and Queries
