Heuristics for the automatic identification of irregularities in spreadsheets

Proceedings of the 1st Workshop on End-User Software Engineering, WEUSE 2005

Volumn , Issue , 2005, Pages

  Clermont, Markus ^a  

^a UNIVERSITY OF LIMERICK   (Ireland)

Author keywords

End user programming; Program analysis; Spreadsheet visualization

Indexed keywords

AUTOMATION; COMPUTER PROGRAMMING; SEA ICE; SOFTWARE ENGINEERING; VISUALIZATION;

ABSTRACT REPRESENTATION; AUTOMATIC IDENTIFICATION; END USER PROGRAMMING; ENGINEERING TECHNIQUES; PROGRAM ANALYSIS; SPREADSHEET DEVELOPMENT; SPREADSHEET PROGRAM; SPREADSHEET PROGRAMMERS;

SPREADSHEETS;

EID: 84883291637     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1083231.1083234     Document Type: Conference Paper

References (24)

1. Y. Ayalew. Spreadsheet Testing Using Interval Analysis. PhD thesis, Universität Klagenfurt, Universitätsstrasse 65-67, A-9020 Klagenfurt, Austria, November 2001.
2. Y. Ayalew, M. Clermont, and R. Mittermeir. Detecting errors in spreadsheets. In Spreadsheet Risks, Audit and Development Methods, Volume 1, pages 51-62, AAAAAA, 7 2000. EuSpRIG, University of Greenwich.
3. R. Butler. Is This Spreadsheet a Tax Evader? How H. M. Customs & Excise Test Spreadsheet Applications. In Proceedings of the 33rd Hawaii International Conference on System Sciences - 2000, Volume 33, 2000.
4. D. Chadwick, K. Rajalingham, B. Knight, and D. Edwards. An Approach to the Teaching of Spreadsheets Using Software Engineering Concepts. In Proceedings of the 4th International Conference on Software Process Improvement, Research, Education and Training INSPIRE'99, pages 261-273, 1999.
5. Y. E. Chan and V. C. Storey. The use of spreadsheets in organizations: Determinants and consequences. Information & Management, 31:119-134, 1996.
6. M. Clermont. Analyzing large spreadsheet programs. In Proceedings of the10th Working Conference on Reverse Engineering. IEEE, 2003.
7. M. Clermont. A Scalable Approach to Spreadsheet Visualization. PhD thesis, Universität Klagenfurt, Universitätsstrasse 65-67, A-9020 Klagenfurt, Austria, 2003.
8. M. Clermont. A toolkit for scalable spreadsheet visualisation. In Risk Reduction in End User Computing, Volume 4. EuSpRIG, 7 2004.
9. M. Clermont, C. Hanin, and R. Mittermeir. A Spreadsheet Auditing Tool Evaluated in an Industrial Context. In Spreadsheet Risks, Audit and Development Methods, Volume 3, pages 35-46. EUSPRIG, 7 2002.
10. M. Clermont and R. Mittermeir. Auditing large spreadsheet programs. In ISIM'03, Proceedings of the 6th International Conference, pages 87-97, 2003.
11. S. Hipfl. Spreadsheet-Visualisierung unter Beruecksichtigung von Layout-Information. Master's thesis, University Klagenfurt, 1999.
12. S. Hipfl. Using layout information for spreadsheet visualization. In Risk Reduction in End User Computing, Volume 4. EuSpRIG, 7 2004.
13. K. Hodnigg, M. Clermont, and R. Mittermeir. Computational models of spreadsheet development: Basis for educational approaches. In Risk Reduction in End User Computing, Volume 4. EuSpRIG, 7 2004.
14. T. Isakowitz, S. Shocken, and H. C. Lucas. Toward a Logical/Physical Theory of Spreadsheet Modeling. ACM Transactions on Information Systems, 13(1):1-37, 1995.
15. B. Knight, D. Chadwick, and K. Rajalingham. A structured methodology for spreadsheet modelling. In Spreadsheet Risks, Audit and Development Methods, Volume 1, pages 43-50. EuSpRIG, University of Greenwich, 7 2000.
16. R. Mittermeir and M. Clermont. Finding High-Level Structures in Spreadsheets. In Proceedings of the 9th Working Conference on Reverse Engineering, 2002.
17. P. O'Beirne. Spreadsheet errors, news stories about spreadsheets with costly mistakes. http://www.eusprig.org/stories.html, 2005.
18. G. J. O'Brien and W. D. Wilde. Australian managers' perceptions, attitudes and use of information technology. Information and Software Technology, 38:783-789, 1996.
19. R. Panko and R. P. Halverson. Are Two Heads Better than One? (At Reducing Errors in Spreadsheet Modeling). Office Systems Research Journal, 1997.
20. R. R. Panko. What we know about spreadsheet errors. Journal of End User Computing: Special issue on Scaling Up End User Development, 10(2):15-21, Spring 1998.
21. 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, Volume 2, pages 25-38. ACM, 2000.
22. B. Ronen, M. Palley, and H. Lucas. Spreadsheet analysis and design. Communication of the ACM, 32(1):84-93, January 1989.
23. K. Rothermel, C. Cook, M. Burnett, J. Schonfeld, T. Green, and G. Rothermel. WYSIWYT testing in the spreadsheet paradigm: An empirical evaluation. In ICSE 2000 Proceedings, pages 230-239. ACM, 2000.
24. J. Sajaniemi. Modeling spreadsheet audit: A rigorous approach to automatic visualization. Journal of Visual Languages and Computing, 11(1):49-82, 2000.