The Enron Errors Corpus - 2016-03-15
Thomas Schmitz and Dietmar Jannach
Download the corpus Download the overview file
Error Nr Spreadsheet Nr Faulty Spreadsheet Faulty worksheet Faulty cells Corrected Spreadsheet Corrected worksheet Corrected cells Type Subtype Cell type Change Additional information
1 1 2_HPLN0601.xls Sheet1 F28:G28 1_HPLN0531.xls Sheet1 F28:G28 Quantitative Mechanical Formula Inserted Range error
2 2 1_Southpoint Gas Model.xls Sheet1 I34 2_Southpoint Gas Model.xls Sheet1 I34 Quantitative Mechanical Formula Fixed Range error
3 3 1-BMSPT051.xls BMSPT066 W43 2-BMSPT051.xls BMSPT066 W43 Quantitative Mechanical Formula Fixed Range error
4 3 1-BMSPT051.xls BMSPT066 C43:V43   Quantitative Mechanical Formula Unchanged Range error
5 4 1_Tricia Roome.xls Sheet1 L16 2_Tricia Roome.xls Sheet1 L16 Quantitative Mechanical Formula Fixed Range error
6 5 1_July01invoice rev1.xls jul01 AL44 2_July01invoice rev1.xls July 01 AL44 Quantitative Mechanical Formula Fixed Range error
7 6 1_Plan - Real-Time Trading.xls Real Time V23 2_Plan - Real-Time Trading.xls Real Time V23 Quantitative Logical Formula Fixed Range error
8 7 1_5_14act.xls Deals AD142 2_5_14act.xls Deals AD142 Quantitative Logical Formula Fixed Range error
9 8 1_Sun Devil Project Request.XLS Cost Estimate Summary L23 2_Sun Devil Project Request.XLS Cost Estimate Summary L23 Quantitative Mechanical Formula Fixed Range error
10 9 1_ONEOKRECAP2001.xls OCT 01 T39 2_ONEOKRECAP2001.xls OCT 01 T39 Quantitative Mechanical Formula Fixed Wrong formula
11 10 1_SunDevil01CostSummary.xls EPSunDevil F10 2_SunDevil01CostSummary.xls EPSunDevil F10 Quantitative Mechanical Formula Fixed Wrong reference
12 11 1_Citrus Pass-Through 12.01.00.xls Data D13 2_Citrus Pass-Through 12.01.00.xls Data D13 Quantitative Logical Formula Fixed Wrong calculation
13 12 1_Huber - Existing & Proposed Deals 111201.xls Curves V5:V341 2_Huber - Existing & Proposed Deals 111201.xls Curves AA5:AA341 Quantitative Omission Formula Fixed Wrong calculation
14 13 1_Agro Case Question 3--Jeff.xls Sheet1 H33 2_Agro Case Question 3--Jeff revised.xls Sheet1 H33 Quantitative Logical Formula Fixed Wrong calculation
15 13 1_Agro Case Question 3--Jeff.xls Sheet1 I35 2_Agro Case Question 3--Jeff revised.xls Sheet1 I35 Quantitative Logical Formula Fixed Wrong calculation
16 13 1_Agro Case Question 3--Jeff.xls Sheet1 I38 2_Agro Case Question 3--Jeff revised.xls Sheet1 I43 Quantitative Omission Formula Fixed Wrong calculation
17 14 1_Book Request Form Central 010702.xls Sheet1 B30:C35; B42:C47 2_Book Request Form Central010702Revised.xls Sheet1 B30:C35; B42:C47 Qualitative Label Fixed Wrong labels
18 15 1_EES April Dailies.xls 4-16, 4-15 K8:K31 2_EES April Dailies.xls 4-16, 4-15 K8:K31 Quantitative Mechanical Value Fixed Wrong values
19 16 1_PSEG - Enron Bankruptcy Revised.xls Sheet1 B13:O13; B25:O25; B37:O37   Quantitative Omission Formula Unchanged Wrong calculation
20 16 1_PSEG - Enron Bankruptcy Revised.xls Sheet1 H17:N17; H29:N29; H41:N41   Quantitative Omission Value Unchanged Wrong values
21 17   1_Breakout Contracts.xls Contract Payment Summary F6 Quantitative Logical Formula Fixed Wrong calculation
22 18 1_CrackSpreadOptions.xls Crack Spread Option M9:M14 2_CrackSpreadOptions.xls Crack Spread Option M9:M14 Quantitative Logical Formula Fixed Wrong calculation
23 19 1_EPE_MAY_2002.xls MAY(2) AE18:AE41 2_EPE_MAY_2002.xls MAY(2) AE18:AE41 Quantitative Mechanical Formula Fixed Range error
24 20 1_oct2301.XLS Sheet1 D112 2_oct2301.XLS Sheet1 D112 Qualitative Formula Fixed Range error
25 21 1_SoCalIntCalc.xls Sheet1 (2) F94 2_SoCalIntCalc.xls Sheet1 (2) F94 Quantitative Logical Formula Fixed Wrong calculation
26 22 1_ENA-Cal Dec Liq.xls Sheet1 C7 2_ENA-Cal Dec Liq.xls Sheet1 C7 Qualitative Formula Fixed File reference not working
27 23 1_enron corp infomation request - Nov 2001.xls EGS EXP W12 2_enron corp infomation request-egas.xls EGS EXP W12 Quantitative Mechanical Formula Fixed Range error
28 24 1_CA rate exposure final 8-28 rev.xls New C10:E14; H10:J14; M10:O14; C25:E29; etc. 2_CA rate exposure final 8-28 rev1.xls New C10:E14; H10:J14; M10:O14; C25:E29; etc. Quantitative Omission Formula Fixed Wrong calculation
29 25 1_Ogleth200103.xls external D11:D35 2_Ogleth200105.xls external D11:D35 Quantitative Logical Formula Fixed Wrong calculation
30 25 1_Ogleth200103.xls external E36:E37 2_Ogleth200105.xls external E36:E37 Qualitative Formula Fixed Wrong reference
31 26 2_yr 2001 Commissioning Summary 2-26-02.xls Mar 2002 I132 1_yr 2001 Commissioning Summary 2-26-02.xls Mar 2002 I132 Qualitative Formula Inserted Fixed Value
32 27 1_ENA_PGE_JUNE_1_2002.xls JD-MAL OR CPTJK TRANS H12:H17; H34:H35 2_ENA_PGE_JUNE_3_2002.xls JD-MAL OR CPTJK TRANS H11:H16; H33:H34 Qualitative Formula Fixed Range error
33 28 1_Southpoint Gas Model.xls Sheet1 I25:I31 2_Southpoint Gas Model.xls Sheet1 I25:I31 Quantitative Mechanical Formula Fixed Wrong reference
34 28 1_Southpoint Gas Model.xls Sheet1 G33; I34   Qualitative Formula Unchanged Range error
35 29 1_EI365reveff060800.xls Sheet1 F8   Qualitative Formula Unchanged Formula: = SUM(D8*E8)
36 30 1_Global Hot List 1207.xls Hotlist - Identified  M22; M37 2_Global Hot List 0111.xls Hotlist - Identified  I22; I37 Quantitative Mechanical Formula Fixed Range error
Statistics  
Nb of errors: 36
Nb of quantitative errors: 28
     Mechanical errors: 14
     Logical errors: 9
     Omission errors: 5
Nb of qualitative errors: 8
Nb of formula errors: 33
Nb of fixed errors: 29
Nb of inserted errors: 2