Introducing Morphit, a new type of spreadsheet technology
arXiv:1401.7799
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.
6 Pages, 4 colour figures, Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2013, ISBN: 978-1-9054045-1-3
References in corpus (13)
- Detecting Errors in Spreadsheets
- Spreadsheet Debugging
- Spreadsheets and the Financial Collapse
- Reducing Overconfidence in Spreadsheet Development
- Revisiting the Panko-Halverson Taxonomy of Spreadsheet Errors
- The Role of Spreadsheets in the Allied Irish Bank / Allfirst Currency Trading Fraud
- Spreadsheets - the Good, the Bad and the Downright Ugly
- In Search of a Taxonomy for Classifying Qualitative Spreadsheet Errors
- Documenting Problem-Solving Knowledge: Proposed Annotation Design Guidelines and their Application to Spreadsheet Tools
- Protecting Spreadsheets Against Fraud
- EuSpRIG TEAM work:Tools, Education, Audit, Management
- Managing Critical Spreadsheets in a Compliant Environment
- Training Gamble leads to Corporate Grumble?