Towards a catalog of spreadsheet smells

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

Volumn 7336 LNCS, Issue PART 4, 2012, Pages 202-216

  Cunha, Jácome ^a   Fernandes, João P ^a,b   Ribeiro, Hugo ^a   Saraiva, João ^a  

^a UNIVERSITY OF MINHO   (Portugal)

^b UNIVERSITY OF PORTO   (Portugal)

Author keywords

Code Smells; EUSES Corpus; Spreadsheets

Indexed keywords

CODE SMELL; EUSES CORPUS;

ODORS;

SPREADSHEETS;

EID: 84863932419     PISSN: 03029743     EISSN: 16113349     Source Type: Book Series    
DOI: 10.1007/978-3-642-31128-4_15     Document Type: Conference Paper

References (30)

1. Abraham, R., Erwig, M.: Inferring templates from spreadsheets. In: Proc. of the 28th Int. Conf. on Software Engineering, pp. 182-191. ACM, New York (2006)
2. Abraham, R., Erwig, M.: Goaldebug: A spreadsheet debugger for end users. In: ICSE 2007: Proceedings of the 29th International Conference on Software Engineering, pp. 251-260. IEEE Computer Society, Washington, DC (2007)
3. Abreu, R., Riboira, A., Wotawa, F.: Constraint-based debugging of spreadsheets. In: Proceedings of the XV Ibero-American Conference on Software Engineering (CibSE 2012) (to appear, 2012)
4. Chiang, F., Miller, R.J.: Discovering data quality rules. The Proceedings of the VLDB Endowment 1, 1166-1177 (2008)
5. Codd, E.F.: A relational model of data for large shared data banks. Commun. ACM 13(6), 377-387 (1970)
6. Correia, J.P., Ferreira, M.A.: Measuring maintainability of spreadsheets in the wild. In: ICSM, pp. 516-519. IEEE (2011)
7. Cunha, J., Erwig, M., Saraiva, J.: Automatically inferring classsheet models from spreadsheets. In: 2010 IEEE Symposium on Visual Languages and Human-Centric Computing, pp. 93-100. IEEE Computer Society (2010)
8. Cunha, J., Fernandes, J.P., Mendes, J., Pacheco, H., Saraiva, J.: Bidirectional Transformation of Model-Driven Spreadsheets. In: Hu, Z., de Lara, J. (eds.) ICMT 2012. LNCS, vol. 7307, pp. 105-120. Springer, Heidelberg (2012)
9. Cunha, J., Fernandes, J.P., Mendes, J., Saraiva, J.: MDSheet: A Framework for Model-driven Spreadsheet Engineering. In: Proceedings of the 34rd International Conference on Software Engineering, ICSE 2012, pp. 1412-1415. ACM (2012)
10. Cunha, J., Fernandes, J.P., Saraiva, J.: From Relational ClassSheets to UML+OCL. In: The Software Engineering Track at the 27th Annual ACM Symposium On Applied Computing (SAC 2012), Riva del Garda (Trento), Italy, pp. 1151-1158 (2012)
11. Cunha, J., Mendes, J., Fernandes, J.P., Saraiva, J.: Embedding and evolution of spreadsheet models in spreadsheet systems. In: IEEE Symp. on Visual Languages and Human-Centric Computing, pp. 179-186. IEEE CS (2011)
12. Cunha, J., Saraiva, J., Visser, J.: Discovery-based edit assistance for spreadsheets. In: Proceedings of the 2009 IEEE Symposium on Visual Languages and Human- Centric Computing (VL/HCC), VLHCC 2009, pp. 233-237. IEEE Computer Society, Washington, DC (2009)
13. Cunha, J., Saraiva, J., Visser, J.: From spreadsheets to relational databases and back. In: Proceedings of the 2009 ACM SIGPLANWorkshop on Partial Evaluation and Program Manipulation, PEPM 2009, pp. 179-188. ACM, New York (2009)
14. Cunha, J., Visser, J., Alves, T., Saraiva, J.: Type-Safe Evolution of Spreadsheets. In: Giannakopoulou, D., Orejas, F. (eds.) FASE 2011. LNCS, vol. 6603, pp. 186-201. Springer, Heidelberg (2011)
15. Engels, G., Erwig, M.: ClassSheets: automatic generation of spreadsheet applications from object-oriented specifications. In: 20th IEEE/ACM Int. Conf. on Automated Sof. Eng., Long Beach, USA, pp. 124-133. ACM (2005)
16. Erwig, M., Burnett, M.: Adding Apples and Oranges. In: Adsul, B., Ramakrishnan, C.R. (eds.) PADL 2002. LNCS, vol. 2257, pp. 173-191. Springer, Heidelberg (2002)
17. Felienne Hermans, M.P., van Deursen, A.: Detecting and visualizing interworksheet smells in spreadsheets. In: Proceedings of the 34rd International Conference on Software Engineering, ICSE 2012. ACM (to appear, 2012)
18. Fowler, M.: Refactoring: Improving the Design of Existing Code. Addison-Wesley, Boston (1999)
19. Heitlager, I., Kuipers, T., Visser, J.: A practical model for measuring maintainability. In: Proceedings of the 6th International Conference on Quality of Information and Communications Technology, pp. 30-39. IEEE Computer Society,Washington, DC (2007)
20. Hermans, F., Pinzger, M., van Deursen, A.: Automatically Extracting Class Diagrams from Spreadsheets. In: D'Hondt, T. (ed.) ECOOP 2010. LNCS, vol. 6183, pp. 52-75. Springer, Heidelberg (2010)
21. Ii, M.F., Rothermel, G.: The euses spreadsheet corpus: A shared resource for supporting experimentation with spreadsheet dependability mechanisms. In: 1stWorkshop on End-User Software Engineering, St. Louis, Missouri, USA, pp. 47-51 (2005)
22. Janssen, T., Abreu, R., van Gemund, A.: Zoltar: A toolset for automatic fault localization. In: 24th IEEE/ACM International Conference on Automated Software Engineering, ASE 2009, pp. 662-664 (November 2009)
23. Levenshtein, V.: Binary Codes Capable of Correcting Deletions, Insertions and Reversals. Soviet Physics Doklady 10, 707 (1966)
24. Mäntylä, M., Vanhanen, J., Lassenius, C.: A taxonomy and an initial empirical study of bad smells in code. In: Proceedings of the International Conference on Software Maintenance, ICSM 2003, pp. 381-384. IEEE Computer Society, Washington, DC (2003)
25. Mäntylä, M.V., Lassenius, C.: Subjective evaluation of software evolvability using code smells: An empirical study. Empirical Softw. Engg. 11, 395-431 (2006)
26. Nardi, B.A.: A Small Matter of Programming: Perspectives on End User Computing, 1st edn. MIT Press, Cambridge (1993)
27. Panko, R.R., Aurigemma, S.: Revising the panko-halverson taxonomy of spreadsheet errors. Decision Support System 49, 235-244 (2010)
28. Panko, R.R., Halverson Jr., R.P.: Spreadsheets on trial: A survey of research on spreadsheet risks. In: Proceedings of the 29th Hawaii International Conference on System Sciences, HICSS 1996. Decision Support and Knowledge-Based Systems, vol. 2, pp. 326-335. IEEE Computer Society, Washington, DC (1996)
29. Rajalingham, K., Chadwick, D.R., Knight, B.: Classification of spreadsheet errors. In: Symposium of the European Spreadsheet Risks Interest Group (EuSpRIG), Amsterdam (2001)
30. Scaffidi, C., Shaw, M., Myers, B.: The '55m end-user programmers' estimate revisited. Tech. rep., Carnegie Mellon University, Pittsburgh (2005)