Introducing Morphit, a new type of spreadsheet technology
Software Engineering
2014-01-31 v1
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.
Keywords
Cite
@article{arxiv.1401.7799,
title = {Introducing Morphit, a new type of spreadsheet technology},
author = {Ted Hawkins and Andrew Lemon and Alec Gibson},
journal= {arXiv preprint arXiv:1401.7799},
year = {2014}
}
Comments
6 Pages, 4 colour figures, Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2013, ISBN: 978-1-9054045-1-3