Enron's Spreadsheets and Related Emails: A Dataset and Analysis
Authors:
- Felienne HermansFHFelienne Hermans
- Emerson Murphy-HillEMEmerson Murphy-Hill
- 1 May 2015
- conference paper
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- Vol. 2 (02705257) , 7-16
Abstract
Spreadsheets are used extensively in business processes around the world and as such, are 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 might therefore not represent spreadsheets used in companies. This paper presents an analysis of a new dataset, extracted from 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 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 referring to or sending spreadsheets and 2) the emails are frequently discussing errors in and updates to spreadsheets.Keywords
This publication has 20 references indexed in Scilit:
- Detecting code smells in spreadsheet formulas2012
- Growth in a Time of DebtAmerican Economic Review, 2010
- Automatically Extracting Class Diagrams from Spreadsheets2010
- The evolution and impact of code smells: A case study of two open source systems2009
- Software Engineering for SpreadsheetsIEEE Software, 2009
- Automatic detection of dimension errors in spreadsheetsJournal of Visual Languages & Computing, 2009
- Errors in Operational SpreadsheetsJournal of Organizational and End User Computing, 2009
- UCheck: A spreadsheet type checker for end usersJournal of Visual Languages & Computing, 2007
- Quality control in spreadsheets: a software engineering-based approach to spreadsheet development2005
- What We Know About Spreadsheet ErrorsJournal of Organizational and End User Computing, 1998