A Domain Terms Visualization Tool for Spreadsheets

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.