Display-Based Problems in Spreadsheets: A Critical Incident and a Design Remedy

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 rst 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 simpli es the notation. The spreadsheet is shown to be a surprisingly poor artefact for three classes of display-based problem. Keywords visual programming,spreadsheet, interaction style, human factors, cognitive dimensions, display-based problem solving, programming by demonstration

• Type: Conference
• Year: 1995
• Where: VL
• Authors: David G. Hendry
• Keywords: Critical Incident, Display-based Problem, Spreadsheet Grid, Visual Languages, VL 1995