The Open UniversitySkip to content
 

Structuring Spreadsheets with the “Lish” Data Model

Hall, Alan Geoffrey; Wermelinger, Michel; Hirst, Tony and Phithakkitnukoon, Santi (2017). Structuring Spreadsheets with the “Lish” Data Model. In: Proceedings of the EuSpRIG 2017 Conference "Spreadsheet Risk Management".

Full text available as:
[img]
Preview
PDF (Accepted Manuscript) - Requires a PDF viewer such as GSview, Xpdf or Adobe Acrobat Reader
Download (449kB) | Preview
Google Scholar: Look up in Google Scholar

Abstract

A spreadsheet is remarkably flexible in representing various forms of structured data, but the individual cells have no knowledge of the larger structures of which they may form a part. This can hamper comprehension and increase formula replication, increasing the risk of error on both scores. We explore a novel data model (called the “lish”) that could form an alternative to the traditional grid in a spreadsheet-like environment. Its aim is to capture some of these higher structures while preserving the simplicity that makes a spreadsheet so attractive. It is based on cells organised into nested lists, in each of which the user may optionally employ a template to prototype repeating structures. These template elements can be likened to the marginal “cells” in the borders of a traditional worksheet, but are proper members of the sheet and may themselves contain internal structure. A small demonstration application shows the “lish” in operation.

Item Type: Conference or Workshop Item
Copyright Holders: 2017 The Authors
Academic Unit/School: Faculty of Science, Technology, Engineering and Mathematics (STEM)
Faculty of Science, Technology, Engineering and Mathematics (STEM) > Computing and Communications
Interdisciplinary Research Centre: Centre for Research in Computing (CRC)
Centre for Research in Education and Educational Technology (CREET)
Related URLs:
Item ID: 50150
Depositing User: Alan Geoffrey Hall
Date Deposited: 31 Jul 2017 08:58
Last Modified: 15 Sep 2017 11:02
URI: http://oro.open.ac.uk/id/eprint/50150
Share this page:

Download history for this item

These details should be considered as only a guide to the number of downloads performed manually. Algorithmic methods have been applied in an attempt to remove automated downloads from the displayed statistics but no guarantee can be made as to the accuracy of the figures.

Actions (login may be required)

Policies | Disclaimer

© The Open University   contact the OU