Enron's Spreadsheets and Related Emails: A Dataset and Analysis

Proceedings - International Conference on Software Engineering

Volumn 2, Issue , 2015, Pages 7-16

  Hermans, Felienne ^a   Murphy Hill, Emerson ^b  

^a DELFT UNIVERSITY OF TECHNOLOGY   (Netherlands)

^b NORTH CAROLINA STATE UNIVERSITY   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

ELECTRONIC MAIL; SEARCH ENGINES; SOFTWARE ENGINEERING;

BUSINESS PROCESS; COMMUNITY WELLS; E-MAIL ARCHIVES; EXCEL; RESEARCH INTERESTS;

SPREADSHEETS;

EID: 84930372918     PISSN: 02705257     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/ICSE.2015.129     Document Type: Conference Paper

References (39)

1. C. Scaffidi, M. Shaw, and B. Myers, "Estimating the numbers of end users and end user programmers, " in Visual Languages and Human-Centric Computing, 2005 IEEE Symposium on. IEEE, 2005, pp. 207-214.
2. F. Hermans, "Analyzing and visualizing spreadsheets, " Ph. D. dissertation, Delft University of Technology, the Netherlands, 2013.
3. C. M. Reinhart and K. S. Rogoff, "Growth in a time of debt, " National Bureau of Economic Research, Tech. Rep., 2010.
4. J. Cassidy, "The reinhart and rogoff controversy: A summing up, " April 2013, the New Yorker.
5. P. Coy, "Faq: Reinhart, rogoff, and the excel error that changed history, " April 2013, businessWeek.
6. R. Abraham and M. Erwig, "Goaldebug: A spreadsheet debugger for end users, " in Proceedings of the 29th international conference on Software Engineering. IEEE Computer Society, 2007, pp. 251-260.
7. F. Hermans, M. Pinzger, and A. v. Deursen, "Detecting and visualizing inter-worksheet smells in spreadsheets, " in Proceedings of the 2012 International Conference on Software Engineering. IEEE Press, 2012, pp. 441-451.
8. W. Dou, S.-C. Cheung, and J. Wei, "Is spreadsheet ambiguity harmful? detecting and repairing spreadsheet smells due to ambiguous computation, " in Proceedings of the 36th International Conference on Software Engineering. ACM, 2014, pp. 848-858.
9. B. Klimt and Y. Yang, "Introducing the enron corpus. " in CEAS, 2004.
10. (2014, Oct. ) Wikipedia. [Online]. Available: http: //en. wikipedia. org/wiki/Personal Storage Table
11. F. Hermans, M. Pinzger, and A. van Deursen, "Detecting and refactoring code smells in spreadsheet formulas, " Empirical Software Engineering, pp. 1-27, 2014.
12. R. McKeever and K. McDaid, "How do range names hinder novice spreadsheet debugging performance?" CoRR, vol. abs/1009. 2765, 2010. [Online]. Available: http: //arxiv. org/abs/ 1009. 2765
13. -, "Effect of range naming conventions on reliability and development time for simple spreadsheet formulas, " CoRR, vol. abs/1111. 6872, 2011. [Online]. Available: http: //arxiv. org/abs/1111. 6872
14. R. McKeever, K. McDaid, and B. Bishop, "An exploratory analysis of the impact of named ranges on the debugging performance of novice users, " CoRR, vol. abs/0908. 0935, 2009. [Online]. Available: http: //arxiv. org/abs/0908. 0935
15. F. Hermans, M. Pinzger, and A. van Deursen, "Detecting code smells in spreadsheet formulas, " in Proc. of ICSM'12, 2012, pp. 409-418.
16. J. Cunha, J. P. Fernandes, J. Mendes, and J. S. Hugo Pacheco, "Towards a catalog of spreadsheet smells, " in Proc. of ICCSA'12. LNCS, 2012.
17. B. Nardi and J. Miller, "The spreadsheet interface: A basis for end user programming, " in Proceeding of The IFIP Conference on Human-Computer Interaction (INTERACT). North-Holland, 1990, pp. 977-983.
18. G. A. Miller, "The magical number seven plus or minus two: some limits on our capacity for processing information. " Psychological review, vol. 63, no. 2, pp. 81-97, March 1956.
19. F. Hermans, "Improving spreadsheet test practices, " in Center for Advanced Studies on Collaborative Research, CASCON'12, Toronto, ON, Canada, November 18-20, 2013, J. R. Cordy, K. Czarnecki, and S. Han, Eds. IBM / ACM, 2013, pp. 56-69. [Online]. Available: http: //dl. acm. org/citation. cfm?id=2555531
20. A. Cassidy and M. Westwood-Hill. Removing pii from the edrm enron data set: Investigating the prevalence of unsecured financial, health and personally identifiable information in corporate data. [Online]. Available: http: //www. nuix. com/ images/resources/case study nuix edrm enron data set. pdf
21. F. Hermans, M. Pinzger, and A. van Deursen, "Supporting professional spreadsheet users by generating leveled dataflow diagrams, " in Proc. of ICSE'11, 2011, pp. 451-460.
22. R. R. Panko, "Two corpuses of spreadsheet errors, " in System Sciences, 2000. Proceedings of the 33rd Annual Hawaii International Conference on. IEEE, 2000, pp. 8-pp.
23. S. G. Powell, K. R. Baker, and B. Lawson, "A critical review of the literature on spreadsheet errors, " Decision Support Systems, vol. 46, no. 1, pp. 128-138, 2008.
24. R. Marinescu, "Detecting design flaws via metrics in objectoriented systems, " in Proc. of TOOLS'01. IEEE Computer Society, 2001, pp. 173-182.
25. M. Lanza, R. Marinescu, and S. Ducasse, Object-Oriented Metrics in Practice. Secaucus, NJ, USA: Springer-Verlag New York, Inc., 2005.
26. T. L. Alves, C. Ypma, and J. Visser, "Deriving metric thresholds from benchmark data, " in Proc. of ICSM'10. IEEE Computer Society, 2010, pp. 1-10.
27. S. Olbrich, D. S. Cruzes, V. Basili, and N. Zazworka, "The evolution and impact of code smells: A case study of two open source systems, " in Proc. of ESEM'09, 2009, pp. 390-400.
28. A. Bregar, "Complexity metrics for spreadsheet models, " in Proc. of EuSpRIG'04, 2004, p. 9.
29. K. Hodnigg and R. Mittermeir, "Metrics-based spreadsheet visualization: Support for focused maintenance, " in Proc. of EuSpRIG'08, 2008, p. 16.
30. S. Hole, D. McPhee, and A. Lohfink, "Mining spreadsheet complexity data to classify end user developers, " in Proc. of ICDM'09. CSREA Press, 2009, pp. 573-579.
31. J. Raffensperger, "New guidelines for spreadsheets, " International Journal of Business and Economics, vol. 2, pp. 141-154, 2009.
32. K. Rajalingham, D. Chadwick, B. Knight, and D. Edwards, "Quality control in spreadsheets: A software engineering-based approach to spreadsheet development, " in Proc. HICSS'00, 2000, pp. 133-143.
33. Y. Ayalew, M. Clermont, and R. T. Mittermeir, "Detecting errors in spreadsheets, " in Proc. of EuSpRIG'00, 2000, pp. 51-62.
34. R. R. Panko, "What we know about spreadsheet errors, " Journal of End User Computing, vol. 10, no. 2, pp. 15-21, 1998.
35. S. Powell, K. Baker, and B. Lawson, "Errors in operational spreadsheets: A review of the state of the art, " in Proc. of HICCS'09. IEEE Computer Society, 2009, pp. 1-8.
36. R. Abraham and M. Erwig, "Ucheck: A spreadsheet type checker for end users, " Journal of Visual Languages and Computing, vol. 18, pp. 71-95, 2007.
37. C. Chambers and M. Erwig, "Automatic detection of dimension errors in spreadsheets, " Journal of Visual Languages and Computing, vol. 20, pp. 269-283, 2009.
38. M. Erwig, "Software engineering for spreadsheets, " IEEE Software, vol. 26, pp. 25-30, September 2009.
39. F. Hermans, M. Pinzger, and A. van Deursen, "Automatically extracting class diagrams from spreadsheets, " in Proc. of ECOOP'10, 2010, pp. 52-75.