Spreadsheet: rick_buy__32803__Summary Sep  17
Sheet: Graph Data Sep 10

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
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
EIM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EIM
EGM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EGM
EBS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EBS
EEL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EEL
EES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EES
EAM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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-09-14 00:00:00 | PHYSOIL-EVERGREE-PRC;EGLI-C2MW-PRC; EGLI-C3MW-PRC; EGLI-C5MW-PRC; EGLI-NC4NW-PRC; EGLI-FEES-PRC; [NAME]; C5+-BRNT-HEDGE-PRC; NAPTHA-UR-PRC; [NAME]; [NAME]; PHYSOIL2-IDX; PHYSOIL-PRICE-PRC;C2-PRC | EGM | US Global Products | [NAME] | E | Due to curve data update, books were reofficialized.  Due to the immaterial change in P&L, VaR was not rerun.  Change in P&L will be captured in COB S EP 17 DPR. Credit was notified. |  | N | Y | Y | Done
2001-09-14 00:00:00 | [NAME] feed | EIM | US Lumber | [NAME] | C | Prior responsible party out of office and backup did not follow instructions for file feed.  Data was uploaded late into CAS. |  | N | Y | N | Done
2001-09-14 00:00:00 | STEEL VaR | EIM | Steel | [NAME] | A | Due to incorrect deal capture positions were incorrect.  Data was corrected and VaR rerun. |  | Y | Y | Y | Done
2001-09-14 00:00:00 | DUB-EESEAM-XL-BAS, DUB-EESEAM-XL-PRC, DUB-ERMS-XL-BAS, DUB-ERMS-XL-PRC, DUB-INT-PHY, DUB-OPT-BAS , DUB-OPT-PRC | EES | US EES GAS | [NAME] | C | Books were not officialized. Books were officialized in the AM.  Credit not impacted as they receive a separate credit file. |  | Y | N | N | Done
2001-09-14 00:00:00 | UK 4 File Feeds |  |  | RisktRAC IT | D2 | While the File was sent on time by London, it was not processed until after 6 am VaR run.  Due to certain systems upgrades, RistRAC database was brought down.  [NAME] were processed from the que and captured by 8 am VaR run. |  | Y | N | N | Done
2001-09-14 00:00:00 | LNG-PRICE-PRC. LNG-PRICE-BAS, LNG-PRICE-IDX | EGM | LNG | [NAME] | C | Book was not officialized.  Process completed in the AM and VaR Rerun. |  | Y | Y | Y | Done
2001-09-13 00:00:00 | EPMI-LT-NAMGMT-PRC; EPMI-LT-WNAMGMT-PRC | EA | US GAS FIN | KLOIBL | C | BA forgot to officialize.  Books were officialized in the AM |  | Y | N | N | Done
2001-09-13 00:00:00 | EAF-AUS-SRA-PRC | EEL | AUSTRALIA POWER | HEIDI MASON | D1 | BA initiated uploaded process and received no error message.   Assumed data had been captured.  Due to process of upload, through terminal server,  connection may have been lost which prevented deal capture. |  | N | N | N | Done
2001-09-13 00:00:00 | Continental Power | EEL | Continental Power | [NAME] | A | 4 Deals were entered incorrectly, which caused a               14 twh discrepancy.  1 new curve was not properly set up, which caused mtm to fail.  Data was corrected and process reiniated.  File was subsequently retransmitted to R isktRAC. |  | Y | Y | N | Done
2001-09-12 00:00:00 | Continental Power | EEL | Continental Power | [NAME] | D1 | Continental Power MTM process failed due to an inability of process to access curver  server. Issue identified to be curve server had not finished processing when MTM process is requesting data.  To prevent further problems pushed back MTM process 30 minutes. |  | N | N | N | Done
2001-09-10 00:00:00 | UK Power; Eastern Spreadsheets; UK Power SS | EEL | UK Power | [NAME] | D1 | Due to bad data that corrupted the valuation process the MTM failed.  Data was corrected and process re-initated for all books. |  | Y | Y | Y | 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