The EUSES spreadsheet corpus: a shared resource for supporting experimentation with spreadsheet dependability mechanisms

ABSTRACT

In recent years several tools and methodologies have been developed to improve the dependability of spreadsheets. However, there has been little evaluation of these dependability devices on spreadsheets in actual use by end users. To assist in the process of evaluating these methodologies, we have assembled a corpus of spreadsheets from a variety of sources. We have ensured that these spreadsheets are suitable for evaluating dependability devices in Microsoft Excel (the most commonly used commercial spreadsheet environment) and have measured a variety of feature of these spreadsheets to aid researchers in selecting subsets of the corpus appropriate to their needs.

REFERENCES

• 1: Robin Abraham , Martin Erwig, Header and Unit Inference for Spreadsheets Through Spatial Analyses, Proceedings of the 2004 IEEE Symposium on Visual Languages - Human Centric Computing (VLHCC'04), p.165-172, September 26-29, 2004 [doi>10.1109/VLHCC.2004.29]
• 2: Y. Ahmad, T. Antoniu, S. Goldwater, and S. Krishnamurthi. A type system for statically detecting spreadsheet errors. In Proceedings of the 25th International Conference on Software Engineering, Portland, OR USA, October 2003.
• 3: Tudor Antoniu , Paul A. Steckler , Shriram Krishnamurthi , Erich Neuwirth , Matthias Felleisen, Validating the Unit Correctness of Spreadsheet Programs, Proceedings of the 26th International Conference on Software Engineering, p.439-448, May 23-28, 2004
• 4: Y. Ayalew, M. Clermont, and R. Mittermeir. Detecting errors in spreadsheets. In Proceedings of the European Spreadsheet Risks Interest Group Annual Conference, London, UK, July 2000.
• 5: Y. Ayalew and R. Mittermeir. Spreadsheet debugging. In Proceedings of the European Spreadsheet Risks Interest Group Annual Conference, Dublin, Ireland, July 2003.
• 6: Margaret Burnett , Curtis Cook , Omkar Pendse , Gregg Rothermel , Jay Summet , Chris Wallace, End-user software engineering with assertions in the spreadsheet paradigm, Proceedings of the 25th International Conference on Software Engineering, May 03-10, 2003, Portland, Oregon
• 7: Margaret Burnett , Andrei Sheretov , Bing Ren , Gregg Rothermel, Testing Homogeneous Spreadsheet Grids with the "What You See Is What You Test" Methodology, IEEE Transactions on Software Engineering, v.28 n.6, p.576-594, June 2002 [doi>10.1109/TSE.2002.1010060 ]
• 8: Gordon Filby, Spreadsheets in Science and Engineering, Springer-Verlag New York, Inc., Secaucus, NJ, 1997
• 9: Marc Fisher , Mingming Cao , Gregg Rothermel , Curtis R. Cook , Margaret M. Burnett, Automated test case generation for spreadsheets, Proceedings of the 24th International Conference on Software Engineering, May 19-25, 2002, Orlando, Florida [doi>10.1145/581339.581359]
• 10: Marc Fisher II , Dalai Jin , Gregg Rothermel , Margaret Burnett, Test Reuse in the Spreadsheet Paradigm, Proceedings of the 13th International Symposium on Software Reliability Engineering (ISSRE'02), p.257, November 12-15, 2002
• 11: M. Jackson and M. Staunton. Advanced Modeling in Finance Using Excel and VBA. John Wiley & Sons, Ltd., Chichester, West Sussex, UK, 2001.
• 12: James Reichwein , Gregg Rothermel , Margaret Burnett, Slicing spreadsheets: an integrated methodology for spreadsheet testing and debugging, Proceedings of the 2nd conference on Domain-specific languages, p.25-38, October 03-06, 1999, Austin, Texas, United States
• 13: Gregg Rothermel , Margaret Burnett , Lixin Li , Christopher Dupuis , Andrei Sheretov, A methodology for testing spreadsheets, ACM Transactions on Software Engineering and Methodology (TOSEM), v.10 n.1, p.110-147, Jan. 2001 [doi>10.1145/366378.366385]
• 14: Karen J. Rothermel , Curtis R. Cook , Margaret M. Burnett , Justin Schonfeld , T. R. G. Green , Gregg Rothermel, WYSIWYT testing in the spreadsheet paradigm: an empirical evaluation, Proceedings of the 22nd international conference on Software engineering, p.230-239, June 04-11, 2000, Limerick, Ireland [doi>10.1145/337180.337206]
• 15: J. Ruthruff , E. Creswick , M. Burnett , C. Cook , S. Prabhakararao , M. Fisher, II , M. Main, End-user software visualizations for fault localization, Proceedings of the 2003 ACM symposium on Software visualization, June 11-13, 2003, San Diego, California [doi>10.1145/774833.774851]
• 16: J. Sajaniemi. Modeling spreadsheet audit: A rigorous approach to automatic visualization. Journal of Visual Languages and Computing, 11(1):49--82, February 2000.

INDEX TERMS

Primary Classification:
  D. Software
  D.2 SOFTWARE ENGINEERING
      D.2.8 Metrics
          Subjects: Complexity measures

Additional Classification:
  H. Information Systems
  H.4 INFORMATION SYSTEMS APPLICATIONS
      H.4.1 Office Automation
          Subjects: Spreadsheets

General Terms:
Experimentation, Measurement

Keywords:
end-user programming, end-user software engineering