Refactoring meets spreadsheet formulas

IEEE International Conference on Software Maintenance, ICSM

Volumn , Issue , 2012, Pages 399-408

  Badame, Sandro ^a   Dig, Danny ^a  

^a UNIVERSITY OF ILLINOIS AT URBANA CHAMPAIGN   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

CONTROLLED EXPERIMENT; EMPIRICAL METHOD; END-USERS; EXCEL; MICROSOFT EXCEL; OBJECT ORIENTED; PLUG-INS; PROFESSIONAL SOFTWARE; REFACTORINGS; SPREADSHEET PROGRAM; USER SURVEYS;

COMPUTER SOFTWARE MAINTENANCE; ODORS;

SPREADSHEETS;

EID: 84873119323     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ICSM.2012.6405299     Document Type: Conference Paper

References (30)

1. B. Boehm, C. Abts, A. Brown, S. Chulani, B. Clark, E. Horowitz, R. Madachy, J. Reifer, and Steece, Software Cost Estimation with COCOMO II. Prentice Hall PTR, 2000.
2. A. K. et al., "The state of the art in end-user software engineering," ACM Comput. Surv., vol. 43, no. 3, 2011.
3. C. Scaffidi, M. Shaw, and B. Myers, "Estimating the numbers of end users and end user programmers," in VLHCC, 2005.
4. M. Burnett, C. Cook, and G. Rothermel, "End-user software engineering," Commun. ACM, vol. 47, no. 9, 2004.
5. M. Fisher and G. Rothermel, "The euses spreadsheet corpus: a shared resource for supporting experimentation with spreadsheet dependability mechanisms," SIGSOFT Softw. Eng. Notes, vol. 30, no. 4, 2005.
6. (2012, Jun.) Formuladatasleuth excel spreadsheet checking. http://www.fairwayassociates.co.uk/formuladatasleuth.
7. K. J. Rothermel, C. R. Cook, M. M. Burnett, J. Schonfeld, T. R. G. Green, and G. Rothermel, "Wysiwyt testing in the spreadsheet paradigm: an empirical evaluation," in ICSE, 2000.
8. J. Cunha, J. P. Fernandes, J. Mendes, and J. S. Hugo Pacheco, "Towards a Catalog of Spreadsheet Smells," in ICCSA, 2012.
9. F. Hermans, M. Pinzger, and A. van Deursen, "Supporting professional spreadsheet users by generating leveled dataflow diagrams," in ICSE, 2011.
10. -, "Detecting and visualizing inter-worksheet smells in spreadsheets," in ICSE, 2012.
11. F. Hermans, M. Pinzger, and A. V. Deursen, "Code smells in spreadsheet formulas," in ICSM, 2012.
12. M. Erwig, "Software engineering for spreadsheets," IEEE Softw., vol. 26, no. 5, 2009.
13. J. F. Raffensperger, "New guidelines for spreadsheets," International Journal of Business and Economics, vol. 2, no. 2, 2003.
14. P. O'Beirne, "Spreadsheet refactoring," in EuSpRIG, 2010.
15. R. R. Panko, "What we know about spreadsheet errors," J. End User Comput., vol. 10, no. 2, 1998.
16. W. R. Harris and S. Gulwani, "Spreadsheet table transformations from examples," in PLDI, 2011.
17. (2012, Jun.) Pup v7 utilities, the spreadsheet page. http:// spreadsheetpage.com/index.php/pupv7/utilities.
18. (2012, Jun.) Asap utilities the essential add-in for excel. http://www.asap-utilities.com/index.php.
19. M. Fowler, Refactoring: Improving the Design of Existing Code. Addison-Wesley, 1999.
20. J. Ratzinger, T. Sigmund, and H. C. Gall, "On the relation of refactorings and software defect prediction," in MSR, 2008.
21. (2012, Jun.) EuSpRiG: European Spreadsheet Risk Interest Group. http://www.eusprig.org.
22. (2012, Jun.) Openoffice.org forum. http://www.oooforum.org/.
23. (2012, Jun.) Excel help forum. http://www.excelforum.org.
24. J. L. Overbey and R. E. Johnson, "Generating rewritable abstract syntax trees," in SLE, 2009.
25. S. Badame, "Refactoring meets spreadsheet formulas," Master's thesis, Univ of Illinois, http://hdl.handle.net/2142/31155, 2012.
26. (2012, Jun.) Apache openoffice calc suite page. http://www.openoffice. org/product/calc.html.
27. B. Opdyke, "Refactoring object-oriented frameworks," Ph.D. dissertation, University of Illinois at Urbana-Champaign, 1992.
28. (2012, Jun.) Apache poi. http://poi.apache.org/.
29. K. T. Stolee and S. Elbaum, "Refactoring pipe-like mashups for end-user programmers," in ICSE, 2011.
30. M. Erwig and M. M. Burnett, "Adding apples and oranges," in PADL, 2002.