Display-based problems in spreadsheets: a critical incident and a design remedy
- 19 November 2002
- conference paper
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- p. 284-290
- https://doi.org/10.1109/vl.1995.520820
Abstract
A critical incident is reported where a discretionary user needed to partition the spreadsheet grid into an arithmetic series of blocks and apply a function to each, but was unable to devise a solution. The incident is first scrutinized to explicate the reasons for the failure. Then, a new method for progressional computation on tabular displays is described and reviewed for usability. The method increases the expressive power of cell referencing but also simplifies the notation. The spreadsheet is shown to be a surprisingly poor artefact for three classes of display-based problem.Keywords
This publication has 6 references indexed in Scilit:
- Creating, comprehending and explaining spreadsheets: a cognitive interpretation of what discretionary users think of the spreadsheet modelInternational Journal of Human-Computer Studies, 1994
- ACE: building interactive graphical applicationsCommunications of the ACM, 1993
- CogMap: a Visual Description Language for SpreadsheetsJournal of Visual Languages & Computing, 1993
- Twinkling lights and nested loops: distributed problem solving and spreadsheet developmentInternational Journal of Man-Machine Studies, 1991
- Naïve users and the Lotus* interface: a field studyBehaviour & Information Technology, 1990
- Construction Kits and Design Environments: Steps Toward Human Problem-Domain CommunicationHuman–Computer Interaction, 1987