Re:Structuring spreadsheets with the “lish” data model (2017)
by JadeNB on Tuesday January 08, 2019 @03:59PM
(#18859639)
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.
[ Parent
| on HN ]
Re:Structuring spreadsheets with the “lish” data model (2017)
by JadeNB on Tuesday January 08, 2019 @04:00PM
(#18859644)
The paper doesn't seem to explain why 'lish'. I originally thought 'list' + 'hash', but that doesn't seem to be consistent with their definition of the data model.
Re:Structuring spreadsheets with the “lish” data model (2017)
by twic on Tuesday January 08, 2019 @05:25PM
(#18860361)
> The model that we propose instead is called the “lish”. (The name is a portmanteau of “list” and “hash table” since in its fully specified form it shares some characteristics of both; it is the list-like properties that we focus on in this paper
Re:Structuring spreadsheets with the “lish” data model (2017)
by JadeNB on Tuesday January 08, 2019 @11:35PM
(#18862297)
> > The model that we propose instead is called the “lish”. (The name is a portmanteau of “list” and “hash table” since in its fully specified form it shares some characteristics of both; it is the list-like properties that we focus on in this paper
Thanks! I skimmed the paper, and obviously I missed that. (I dunno why I didn't just search for 'hash'.)