An end-user oriented graph-based visualization for spreadsheets

Kankuzi, Bennett; Ayalew, Yirsaw

doi:10.1145/1370847.1370866

Cited by 9 publications

(5 citation statements)

References 9 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Research on spreadsheets has focused on various aspects, including expanding spreadsheet languages through direct manipulation and gestures (Burnett, 1998), communicating unit error messages in spreadsheets (Abraham, 2005), type inferences for spreadsheets , graph-based visualizations (Kankuzi, 2008), testing (Rothermel, 2001), and web based spreadsheet-mediated collaboration (Ginige, 2010). However, little work has been done to identify the usability issues associated with spreadsheet applications (either mobile or desktop-based) and ways to go about solving them.…”

Section: Spreadsheets and Usabilitymentioning

confidence: 99%

Evaluating Mobile Applications

Flood

Harrison

Iacob

et al. 2012

International Journal of Mobile Human Computer Interaction

View full text Add to dashboard Cite

The power of mobile devices has increased dramatically in the last few years. These devices are becoming more sophisticated and allow users to accomplish a wide variety of tasks while on the move. The ease with which mobile apps can be created and distributed has resulted in a number of usability issues becoming more prevalent. This paper describes the range of usability issues encountered at all stages of the mobile app life cycle, from when users begin to search for an app to when they finally remove the app from their device. Using these results we developed a number of guidelines for both app developers and app platform developers that will improve the overall usability of mobile apps.

show abstract

Section: Spreadsheets and Usabilitymentioning

confidence: 99%

Evaluating Mobile Applications

Flood

Harrison

Iacob

et al. 2012

International Journal of Mobile Human Computer Interaction

View full text Add to dashboard Cite

show abstract

“…Dependencies between different parts of the spreadsheets are, for example, visualized in animations [9], in three-dimensional space [8], or in larger blocks of formulas [16]. Other approaches visualize the dependencies of the entire workbook in a graph like structure [6] and apply visual abstraction techniques to make the graph manageable [11,7]. But as these techniques only offer visual representations on different abstraction levels, the graph itself remains unchanged and still too complex to be understood.…”

Section: Related Workmentioning

confidence: 99%

A methodology for constructing the calculation model of scientific spreadsheets

Vos¹,

Wielemaker²,

Schreiber³

et al. 2015

Proceedings of the 8th International Conference on Knowledge Capture

View full text Add to dashboard Cite

Spreadsheets models are frequently used by scientists to analyze research data. These models are typically described in a paper or a report, which serves as single source of information on the underlying research project. As the calculation workflow in these models is not made explicit, readers are not able to fully understand how the research results are calculated, and trace them back to the underlying spreadsheets. This paper proposes a methodology for semiautomatically deriving the calculation workflow underlying a set of spreadsheets. The starting point of our methodology is the cell dependency graph, representing all spreadsheet cells and connections. We automatically aggregate all cells in the graph that represent instances and duplicates of the same quantities, based on analysis of the formula syntax. Subsequently, we use a set of heuristics, incorporating knowledge on spreadsheet design, computational procedures and domain knowledge, to select those quantities, that are relevant for understanding the calculation workflow. We explain and illustrate our methodology by actually applying it on three sets of spreadsheets from existing research projects in the domains of environmental and life science. Results from these case studies show that our constructed calculation models approximate the ground truth calculation workflows, both in terms of content and size, but are not a perfect match.

show abstract

“…[18]) (for example for tax purposes) together with tools to identify areas of complexity within spreadsheets [20]. Historically there has been much interest in deriving visualisations based on the calculation graph of a spreadsheet [52] [90]. Several visualisation tools have been proposed to avoid costly errors.…”

Section: Related Workmentioning

confidence: 99%