Spreadsheet bibliography

Title A domain terms visualization tool for spreadsheets
Authors Bennett Kankuzi & Jorma Sajaniemi
Year 2014
Type Proceedings
Publication IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)
Series July
Abstract

Earlier research on spreadsheet authors' mental models has shown that people possess several types of information about spreadsheets.

The research results also suggested that a tool intended to aid in comprehension and debugging of spreadsheets should make prominent real-world and problem domain concepts and map them easily to spreadsheet-specific details.

This poster introduces a new spreadsheet visualization tool which was developed to demonstrate that it is possible to have an easy-to-use spreadsheet understanding and debugging tool that relieves users from spreadsheet details and lets them utilize more of their mental model of the application domain.

The tool translates traditional spreadsheet formulas into problem domain narratives and highlights referenced cells.

Full version Available
Sample
Visualization of a Sales Report spreadsheet
Visualization of a Sales Report spreadsheet

The cell cursor is in C9, whose formula is visible at the formula bar and narrated in domain terms in the light green box.

Cells referred to in the domain narrative are highlighted with light green background. All formula cells are marked with a pink right border.