Academic
Publications
Inferring templates from spreadsheets

Inferring templates from spreadsheets,10.1145/1134312,Robin Abraham,Martin Erwig

Inferring templates from spreadsheets   (Citations: 20)
BibTex | RIS | RefWorks Download
We present a study investigating the performance of a system for automatically inferring spreadsheet templates. These templates allow users to safely edit spreadsheets, that is, certain kinds of errors such as range, reference, and type errors can be provably prevented. Since the inference of templates is inherently ambiguous, such a study is required to demonstrate the eectiveness of any such automatic sys- tem. The study results show that the system considered performs significantly better than subjects with intermedi- ate to expert level programming expertise. These results are important because the translation of the huge body of exist- ing spreadsheets into a system based on safety-guaranteeing templates cannot be performed without automatic support. We also carried out post-hoc analyses of the video recordings of the subjects' interactions with the spreadsheets and found that although expert-level subjects needed less time and de- veloped more accurate templates than less experienced sub- jects, they did not inspect fewer cells in the spreadsheet.
Cumulative Annual
View Publication
The following links allow you to view full publications. These links are maintained by other sources not affiliated with Microsoft Academic Search.
    • ...Despite of its huge benefits, model-driven software development is sometimes difficult to realize in practice due to two main reasons: first, as some studies suggest, defining the business model of a spreadsheet can be a complex task for end users [1]...

    J'acome Cunhaet al. Type-Safe Evolution of Spreadsheets

    • ...In order to improve the robustness of SS, a considerable amount of research has been done [1,3,4,5,6]...
    • ...Several models have been proposed namely, templates [1], ClassSheets [3,6] and relational models [5] and also techniques to infer models from (legacy) spreadsheet data [1,3]...
    • ...Several models have been proposed namely, templates [1], ClassSheets [3,6] and relational models [5] and also techniques to infer models from (legacy) spreadsheet data [1,3]...

    Laura Beckwithet al. End-users Productivity in Model-based Spreadsheets: An Empirical Study

    • ...studies suggest, defining the business model of a spreadsheet can be a complex task for end users [1]...
    • ...Extracting templates from existing spreadsheets was described in [1]...

    Jácome Cunhaet al. Automatically Inferring ClassSheet Models from Spreadsheets

    • ...This research mainly aims at two directions: 1) the localizations of errors within existing spreadsheets [1,2,3,4,5,18] and 2) the development...
    • ...To determine the type of a cell, we use a simple strategy, that basically follows the approach of [2]...
    • ...Many papers on spreadsheet analysis use the Corpus to test their methodologies and algorithms, among which are [2] and [9]...
    • ...a series of articles on unit inference [1,2,3,4]...

    Felienne Hermanset al. Automatically Extracting Class Diagrams from Spreadsheets

    • ...The work presented in [9] automatically infers presentation templates (as proposed in [8, 14]) from existing spreadsheets...

    Woralak Kongdenfhaet al. Rapid development of spreadsheet-based web mashups

Sort by: