Print Email Facebook Twitter Enron’s Spreadsheets and Related Emails: A Dataset and Analysis Title Enron’s Spreadsheets and Related Emails: A Dataset and Analysis Author Hermans, F. Murphy-Hill, E. Faculty Electrical Engineering, Mathematics and Computer Science Department Software Computer Technology Date 2014-11-30 Abstract Spreadsheets are used extensively in business processes around the world and as such, a topic of research interest. Over the past few years, many spreadsheet studies have been performed on the EUSES spreadsheet corpus. While this corpus has served the spreadsheet community well, the spreadsheets it contains are mainly gathered with search engines and as such do not represent spreadsheets used in companies. This paper presents a new dataset, extracted for the Enron Email Archive, containing over 15,000 spreadsheets used within the Enron Corporation. In addition to the spreadsheets, we also present an analysis of the associated emails, where we look into spreadsheet specific email behavior. Our analysis shows that 1) 24% of Enron spreadsheets with at least one formula contain an Excel error, 2) there is little diversity in the functions used in spreadsheets: 76% of spreadsheets in the presented corpus only use the same 15 functions and, 3) the spreadsheets are substantially more smelly than the EUSES corpus, especially in terms of long calculation chains. Regarding the emails, we observe that spreadsheets 1) are a frequent topic of email conversation with 10% of emails either sending or referring spreadsheets and 2) the emails are frequently discussing errors in and updates to spreadsheets. To reference this document use: http://resolver.tudelft.nl/uuid:085374fa-06a3-48c9-a022-aa02c32507e8 Publisher Delft University of Technology, Software Engineering Research Group Source Technical Report Series TUD-SERG-2014-021 Part of collection Institutional Repository Document type report Rights © 2014 The Author(s)Software Engineering Research Group, Department of Software Technology, Faculty of Electrical Engineering, Mathematics and Computer Science, Delft University of Technology Files PDF TUD-SERG-2014-021.pdf 329.66 KB Close viewer /islandora/object/uuid:085374fa-06a3-48c9-a022-aa02c32507e8/datastream/OBJ/view