Spreadsheet bibliography

Title User-friendly spreadsheet querying: An empirical study
Authors Rui Pereira, Joao Saraiva, Jacome Cunha, & Joao Paulo Fernandes
Year 2016
Type Proceedings
Publication 31st ACM/SIGAPP Symposium on Applied Computing
Series April
Abstract

Spreadsheets are nowadays used in a variety of contexts, including in the manipulation of large and complex data. This data is stored in a large unstructured matrix, which is hard to understand and to manipulate. Recent research has been done to manipulate and query such unstructured data, namely by proposing different query approaches to spreadsheets.

In this paper we present an empirical study evaluating three recent query approaches to spreadsheets assessing their usage to query spreadsheets. The results of our study show that the end-users' productivity increases when using visual, model-driven queries are used.

Full version Available
Sample
Graphical query
Graphical query
We developed a graphical user interface for visual query construction. This visual interface, named Graphical-QuerySheet, hides syntax peculiarities and lets users choose attributes based on the spreadsheet's model.