Planted-model evaluation of algorithms for identifying differences between spreadsheets

@article{Harutyunyan2012PlantedmodelEO,
  title={Planted-model evaluation of algorithms for identifying differences between spreadsheets},
  author={Anna Harutyunyan and Glencora Borradaile and Chris Chambers and Christopher Scaffidi},
  journal={2012 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)},
  year={2012},
  pages={7-14}
}
Users often need to test, debug or reuse spreadsheets. We present a new algorithm that can identify differences between two spreadsheets, providing a basis for future tools to help users compare two versions of a spreadsheet (thereby seeing what is new and needs testing) or two different spreadsheets (thereby seeing which is more appropriate for reuse in a situation). This algorithm, RowColAlign, is a two-dimensional generalization of the classic dynamic programming algorithm for solving the… CONTINUE READING

Figures, Tables, and Topics from this paper.

Citations

Publications citing this paper.
SHOWING 1-6 OF 6 CITATIONS

Detecting and Predicting Evolution in Spreadsheets - A Case Study in an Energy Network Company

  • 2018 IEEE International Conference on Software Maintenance and Evolution (ICSME)
  • 2018
VIEW 1 EXCERPT
CITES METHODS

How effectively can spreadsheet anomalies be detected: An empirical study

  • Journal of Systems and Software
  • 2017
VIEW 1 EXCERPT
CITES METHODS

Finding errors in the Enron spreadsheet corpus

  • 2016 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC)
  • 2016
VIEW 3 EXCERPTS
CITES METHODS & BACKGROUND

References

Publications referenced by this paper.
SHOWING 1-10 OF 15 REFERENCES

SheetDiff: A Tool for Identifying Changes in Spreadsheets

  • 2010 IEEE Symposium on Visual Languages and Human-Centric Computing
  • 2010
VIEW 4 EXCERPTS
HIGHLY INFLUENTIAL

Struggling to Excel: A Field Study of Challenges Faced by Spreadsheet Users

  • 2010 IEEE Symposium on Visual Languages and Human-Centric Computing
  • 2010
VIEW 3 EXCERPTS

Unobtrusive data acquisition for spreadsheet research

  • 2008 IEEE Symposium on Visual Languages and Human-Centric Computing
  • 2008
VIEW 1 EXCERPT

Explaining Debugging Strategies to End-User Programmers

  • IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC 2007)
  • 2007
VIEW 1 EXCERPT

Goal-directed debugging of spreadsheets

  • 2005 IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC'05)
  • 2005
VIEW 1 EXCERPT

Similar Papers

Loading similar papers…