We describe a data visualisation system which uses spreadsheets as its user interface metaphor. Similar systems implemented in the past were hampered by the contradiction between an imperative formula language and the declarative spreadsheet framework. We have analysed spreadsheets from a data visualisation point of view, and built a system that is an improvement over past efforts. Our prototype combines the following three techniques: we store lists of values in each spreadsheet cell; we use a functional programming language as the formula language and we make use of lazy evaluation. The novel combination of these techniques makes our system consistently declarative in nature, and gives it several advantages such as small, uncluttered visual programs, the ability to deal with potentially infinite datasets and the use of advanced functional language features.
[1]
Marko C. J. D. van Eekelen,et al.
Implementing a Functional Spreadsheet in Clean
,
1995,
J. Funct. Program..
[2]
John Hughes,et al.
Why Functional Programming Matters
,
1989,
Comput. J..
[3]
Marc Levoy,et al.
Spreadsheets for images
,
1994,
SIGGRAPH.
[4]
Marian Petre,et al.
Usability Analysis of Visual Programming Environments: A 'Cognitive Dimensions' Framework
,
1996,
J. Vis. Lang. Comput..
[5]
E.H. Chi,et al.
Principles for Information Visualization Spreadsheets
,
1998,
IEEE Computer Graphics and Applications.
[6]
Marko C. J. D. van Eekelen,et al.
CLEAN: A language for functional graph writing
,
1987,
FPCA.
[7]
Henry C. Lucas,et al.
Toward a logical/physical theory of spreadsheet modeling
,
1992,
TOIS.