Spreadsheet: rick_buy__32830__Summary Oct 01
Sheet: Graph Data Oct 01

SUMMARY BY WEEK OF |  |  |  |  |  | 4/05-4/11 | 4/12-4/18 | 4/19-4/25 | 04/26-05/01 | 5/2/-5/9 | 5/10-5/17 | 5/18-5/25 | 5/28-6/1 | 06/04-06/08 | 06/11-06/15 | 06/18-06/22 | 06/25-06/29 | 07/02-07/05 | 07/09-07/13 | 07/16-07/20 | 07/23-07/27 | 07/30-08/03 | 08/06-08/10 | 08/13-08/17 | 8/20-8/24 | 08/27-8/31 | 09/04/-09/07 | 09/10-09/14 | 09/17-09/21 | 09/24-09/28 | 10/01-10/05
Deal Capture |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Deal Valuation |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1
Breakdown in Officializing Process- Human |  |  |  |  |  |  |  |  |  | 13 | 7 | 2 |  | 5 | 6
Breakdown in Officializing Process- IT(UK) |  |  |  |  |  |  |  |  |  | 6 | 5 | 6 |  | 5 | 2
Breakdown in Officializing Process- IT (US) |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 | 3
Curve Issues |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 3
Uncontrollable-System Needs to Change |  |  |  |  |  |  |  |  |  | 2 | 1 |  |  |  | 3
Miscellaneous |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 2
Not identified
Total Errors for the Week |  |  |  |  |  | 44 | 16 | 19
SUMMARY BY WEEK OF |  |  |  |  |  | 2001-04-05 00:00:00 | 2001-04-12 00:00:00 | 2001-04-19 00:00:00 | 2001-04-26 00:00:00 | 2001-05-02 00:00:00 | 2001-05-10 00:00:00 | 2001-05-18 00:00:00 | 2001-05-28 00:00:00 | 2001-06-04 00:00:00 | 2001-06-11 00:00:00 | 2001-06-18 00:00:00 | 2001-06-25 00:00:00 | 2001-07-02 00:00:00 | 2001-07-09 00:00:00 | 2001-07-16 00:00:00 | 2001-07-23 00:00:00 | 2001-07-30 00:00:00 | 2001-08-06 00:00:00 | 2001-08-13 00:00:00 | 2001-08-20 00:00:00 | 2001-08-27 00:00:00 | 2001-09-04 00:00:00 | 2001-09-10 00:00:00 | 2001-09-17 00:00:00 | 2001-09-24 00:00:00 | 2001-10-01 00:00:00
EIM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  | EIM
EGM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57 |  |  | EGM
EBS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EBS
EEL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EEL
EES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EES
EAM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 5 |  | EAM
Book creation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Books Created
Curve Creation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Curve Creation
LOG OF WEEKLY VALUATION ISSUES
CLASS
A   -   Deal Capture
B   -   Deal Valuation
C   -   [NAME] in transfer of data to RiskTrac (Officializing Process) - Human
D1   -   [NAME] in transfer of data to RiskTrac (Officializing Process) - IT (UK)
D2   -   [NAME] in transfer of data to RiskTrac (Officializing Process) - IT (US)
E   -   Curve Issues
F   -   No ones fault.  System needs to change.
G   -   Other
H   -   Not identified.
 |  |  |  | RESPONSIBLE |  |  |  | VAR | CREDIT | IMPACT CASH | STATUS
DATE | BOOK/AREA | Group | COMMODITY/OFFICE | PARTY | CLASS | PROBLEM | ACTION PLAN | RERUN? | AFFECTED? | FLOWS? | (DATE)
2001-10-05 00:00:00 | NG-X-OPT-JV-PRC; NG-X-OPT-WTI-PRC; NG-X-OPT-NG-PRC | EA | US GAS FIN | [NAME] | C | JV AND WTI BOOKS WERE NOT OFFICIALIZED.  NG book had a missing region code.  Books were officialized in the AM |  | Y | Y | Y | Done
2001-10-05 00:00:00 | FINANCIAL-AFF-PRC; FINANCIAL-EM-PRC; FINANCIAL-PROP-PRC; FINANCIAL-TN10-PRC; FINANCIAL-TN5-PRC | EGM | US Financial | [NAME] | H | Issue not identified.  Left message with Book Administrator.  No impac t on VaR as currently calculated using Infinity engine. |  | N | Y | Y | Done
2001-10-05 00:00:00 | UK-EBS Credit file | EEL | UK EBS | Niel Tarling | H | File was saved out, but data was not captured by CAS process.  Issue not identified. |  | N | Y | N | Done
2001-10-05 00:00:00 | Uk Power/ UK Spreadsheets/UKPWRSWAP1 | EEL | UK Power | [NAME] | D1 | Lateness of UK Power is due to date mismatch between internal hedges which had Oct 3 date and UK Power which had Oct 5 data.  Spreadsheets late due to incorrect dates in spreadsheets. |  | Y | Y | N | Done
2001-10-05 00:00:00 | Eastern Spreadsheet 1 & 2 | EEL | Continental Power | [NAME] | E | Due to curve issues, NBP curve data not properly saved for  Oct 4 & 5, data was rolled for COB Oct 3. |  | N | Y | Y | Done
2001-10-04 00:00:00 | NG-X-OPT-NG-GDL | EA | US GAS FIN | [NAME] | C | Due to attribute mismatch, missing region code, post id did not resolve into RisktRAC book.  Book only has internal trades, as such no credit exposure. |  | N | N | N | Done
2001-10-04 00:00:00 | UK Power | EEL | UK Power | [NAME] | D1 | Book was late due to server failure on initial feed, which required reload.  Simultaneous load of multiple books delayed completion |  | Y | Y | N | Done
2001-10-03 00:00:00 | Revised 9/28 Coal Positions and VaR | EGM | US COAL | [NAME] | A | Positions for 9/28/01 were updated and reloaded.  VaR was rerun. |  | Y | Y | Y | Done
2001-10-03 00:00:00 | EPMI-NE-TRANS-PRC | EA | US POWER EAST | [NAME] / IT | H | Power RM indicated book was officialized, however data was not captured by RisktRAC.  Book was reofficialized and data captured.  Book had no 3rd party credit exposures.  Unable to identify the reason book not captured on 1st officialization.  Will monitor to ensure future capture. |  | N | N | N | Done
2001-10-03 00:00:00 | EPMI-W-BIO-INV-PRC; EPMI-W-BIO-PRC | EA | US POWER WEST | [NAME] | C | EnPower region codes did not match RisktRAC region codes.   Working with BA to resolve. |  | N | Y | Y | Done
2001-10-03 00:00:00 | EAF-AUS-SRA-PRC | EEL | AUSTRALIA POWER | HEIDI MASON | C | Spreadsheet was not loaded into RisktRAC.  Uploaded next day. |  | N | Y | Y | Done
2001-10-03 00:00:00 | CREDIT Trading file | EEL | UK | [NAME] | C | Credit file was not saved using appropriate procedures. |  | N | Y | N | Done
2001-10-03 00:00:00 | UK Power Spreadsheets; UKPWRSWAP1 | EEL | UK Power | [NAME] | C | Book officialized late due to incorrect data contained in file.  Data updated and loaded into RisktRAC. |  | Y | Y | N | Done
2001-10-03 00:00:00 | UK Power; Continental Power | EEL | UK Power | [NAME] | D1 | Book loaded late due to failures during extract process. |  | Y | Y | N | Done
2001-10-02 00:00:00 | COAL-SYNFUEL-M-PRC; COAL-ACCRUAL-BAS; COAL-ACCRUAL-PRC | EGM | US COAL | [NAME] | C | Accrual Books were inadvertantly officialized.  This caused the data to be picked up by CAS and Infinity. |  | N | Y | Y | Done
2001-10-02 00:00:00 | UK-EBS | EEL | UK EBS | Niel Tarling | C | Credit file was saved with old effective date. |  | N | Y | N | Done
2001-10-02 00:00:00 | UK POWER | EEL | UK Power | [NAME] | D1 | File was officialized late, partially due to slow server performance. |  | Y | Y | N | Done
2001-10-01 00:00:00 | DRAM Positions | EBS | US EBS | [NAME] | A | Positons were incorrect.  Had to reload positions and rerun VaR. |  | Y | Y | N | Done
2001-10-01 00:00:00 | ISOCTN-AFF-TMB-PRC; MEOH-AFF-TMB-PRC; MTBE-AFF-TMB-PRC; NC4-AFF-TMB-PRC; NG-AFF-TMB-PRC | EGM | US Global Products | [NAME] | G | Affiliate deals contained in these books were transferred to non-affiliate books, due to change in accounting treatment.  Will the non-affiliate books were properly officialized the, these books were not officialized to zero which caused CAS to double count.  Positions were moved on 10/01/01 for 9/28/01 effective date.  Reran VaR to properly include deals in non affiliate portfolios. |  | Y | Y | Y | Done
2001-10-01 00:00:00 | [NAME] feed | EIM | US Lumber | [NAME] | C | Credit feed file not transmitted.  Data provided late. |  | N | Y | N | Done
2001-10-01 00:00:00 | UK Power Spreadsheets | EEL | UK Power | [NAME] | D1 | Book was officialized  twice due missing add-in in 1st computer. |  | Y | Y | N | Done
2001-10-01 00:00:00 | Eastern SS 1&2 | EEL | UK Power | [NAME] | D1 | Initial data rolled from COB 09/27/01 due to incomplete data obtained from [NAME]. Subsequently officialized for COB 9/28. |  | Y | Y | N | Done
2001-10-01 00:00:00 | UK Power | EEL | UK Power | [NAME] | C | Book was officialized late due to Qtr end data volumes |  | Y | Y | N | Done
SUMMARY FOR  05/28 - 06/01 BY GROUP | % of Total Errors for the Week | # of errors | # Active books by group | Ratio of Errors to Active Books
EIM
EGM
EEL
EA-CAN
EA - GAS
EA - POWER
EES |  |  | 9
EBS
OTHER
TOTAL