Introducing Morphit, a new type of spreadsheet technology

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.