Marc Fisher
Gregg Rothermel
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.
- R. Abraham and M. Erwig. Header and unit inference for spreadsheets through spatial analyses. In Proceedings of the IEEE Symposium on Visual Languages and Human-Centric Computing, Rome, Italy, September 2004. Google Scholar
Digital Library
- 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.Google ScholarDigital Library
- T. Antoniu, P. Steckler, S. Krishnamurthi, E. Neuwirth, and M. Felleisen. Validating the unit correctness of spreadsheet programs. In Proceedings of the 26th International Conference on Software Engineering, Edinburgh, Scotland, UK, May 2004. Google ScholarDigital Library
- 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.Google Scholar
- Y. Ayalew and R. Mittermeir. Spreadsheet debugging. In Proceedings of the European Spreadsheet Risks Interest Group Annual Conference, Dublin, Ireland, July 2003.Google Scholar
- M. Burnett, C. Cook, O. Pendse, G. Rothermel, J. Summet, and C. Wallace. End-user software engineering with assertions in the spreadsheet paradigm. In Proceedings of the 25th International Conference on Software Engineering, pages 93--103, Portland, OR USA, May 2003. Google ScholarDigital Library
- M. Burnett, A. Sheretov, B. Ren, and G. Rothermel. Testing homogeneous spreadsheet grids with the "What You See Is What You Test" methodology. IEEE Transactions on Software Engineering, pages 576--594, June 2002. Google ScholarDigital Library
- G. Filby. Spreadsheets in Science and Engineering. Springer, 1995. Google ScholarDigital Library
- M. Fisher II, M. Cao, G. Rothermel, C. Cook, and M. Burnett. Automated test case generation for spreadsheets. In Proceedings of the 24th International Conference on Software Engineering, pages 241--251, Orlando, FL USA, May 2002. Google ScholarDigital Library
- M. Fisher II, D. Jin, G. Rothermel, and M. Burnett. Test reuse in the spreadsheet paradigm. In Proceedings of the International Symposium on Software Reliability Engineering, pages 257--268, Annapolis, MD USA, November 2002. Google ScholarDigital Library
- M. Jackson and M. Staunton. Advanced Modeling in Finance Using Excel and VBA. John Wiley & Sons, Ltd., Chichester, West Sussex, UK, 2001.Google Scholar
- J. Reichwein, G. Rothermel, and M. Burnett. Slicing spreadsheets: An integrated methodology for spreadsheet testing and debugging. In Proceedings of the 2nd Conference on Domain Specific Languages. pages 25--38, Austin, TX USA, October 1999. Google ScholarDigital Library
- G. Rothermel, M. Burnett, L. Li, C. DuPuis, and A. Sheretov. A methodology for testing spreadsheets. ACM Transaction on Software Engineering and Maintenance, pages 110--147, January 2001. Google ScholarDigital Library
- K. Rothermel, C. Cook, M. Burnett, J. Schonfeld, T. Green, and G. Rothermel. WYSIWYT testing in the spreadsheet paradigm: An empirical evaluation. In Proceedings of the 22nd International Conference on Software Engineering, Limerick, Ireland, June 2000. Google ScholarDigital Library
- J. Ruthruff, E. Creswick, M. Burnett, C. Cook, S. Prabhakararao, M. Fisher II, and M. Main. End-user software visualizations for fault localization. In Proceedings of the ACM Symposium on Software Visualization, pages 123--132, San Diego, CA USA, June 2003. Google ScholarDigital Library
- J. Sajaniemi. Modeling spreadsheet audit: A rigorous approach to automatic visualization. Journal of Visual Languages and Computing, 11(1):49--82, February 2000.Google ScholarDigital Library
Index Terms
- The EUSES spreadsheet corpus: a shared resource for supporting experimentation with spreadsheet dependability mechanisms
Recommendations
The EUSES spreadsheet corpus: a shared resource for supporting experimentation with spreadsheet dependability mechanisms
WEUSE I: Proceedings of the first workshop on End-user software engineeringIn 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 ...
Integrating automated test generation into the WYSIWYT spreadsheet testing methodology
Spreadsheet languages, which include commercial spreadsheets and various research systems, have had a substantial impact on end-user computing. Research shows, however, that spreadsheets often contain faults. Thus, in previous work we presented a ...
Comments