Spreadsheet: rick_buy__32843__Summary Oct 08
Sheet: Graph Data Sep 17

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
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
EIM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | EIM
EGM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57 | EGM
EBS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EBS
EEL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EEL
EES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EES
EAM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 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-21 00:00:00 | EBS-BWT-PRC | EEL | UK EBS | Niel Tarling | G | Credit file was not appropriately saved for processing.  . |  | N | Y | N | Done
2001-09-21 00:00:00 | UK Gas/ Eastern SS 1 &2 | EEL | UK Power | [NAME] | D1 | Reran MTM process as original process generated inconsistent numbers.  However, change was due to change in deals.   Eastern SS rolled due to dependence on UK GAS mtm values. |  | Y | Y | N | Done
2001-09-21 00:00:00 | Uk Power | EEL | UK Power | [NAME] | D1 | Book was officialized twice as initial process feed data to incorrect books. Issue was caused to temporary rename of portfolios. |  | Y | Y | N | Done
2001-09-21 00:00:00 | FRT-DIESEL-PRC; FRT-FWD-TXFR-PRC; FRT-HO-PRC; FRT-LC-PRC; FRT-MIDWEST-BAS; [NAME]; FRT-MOUNTAIN-BAS; FRT-MOUNTAIN-PRC; FRT-NORTHEAST-BAS; FRT-NORTHEAST-PRC; FRT-NORTHWEST-BAS; FRT-NORTHWEST-PRC; FRT-OHIO-BAS; FRT-OHIO-PRC; FRT-SOUTHCENT-BAS;FRT-SOUTHCENT-PRC; FRT-SOUTHEAST-BAS; FRT-SOUTHEAST-PRC; FRT-UCF-PRC; FRT-WEST-BAS; FRT-WEST-PRC; FRT-WTI-PRC | EGM | US Freight | [NAME] | C | Books were not officialized. |  | Y | Y | Y | Done
2001-09-20 00:00:00 | UK Gas | EEL | UK Gas | [NAME] | H | During officialization process system generated an error message so process was reinitiated. |  | Y | Y | N | Done
2001-09-20 00:00:00 | Nordic Power | EEL | Nordic Power | [NAME] | A | Book was officialized late due to incorrect deal entry.   Data was reentered and book was reofficialized. |  | Y | Y | N | Done
2001-09-20 00:00:00 | UK Power/ Spreadsheet and Eastern Spreadsheets 1 & 2 | EEL | UK Power | [NAME] | D1 | The Dove calc process failed due to a virus detected by systems.  Manual process reinitiated and data updated.  Spreadsheets late due to reliance on [NAME]. |  | Y | Y | N | Done
2001-09-19 00:00:00 | UK Power/Spreadsheet | EEL | UK Power | [NAME] | D1 | The Dove calc process failed due to unsynchronized clocks.  This caused delay  in MTM process for spreadsheets and UK Power.  Process was reinitiated and books officilized |  | Y | Y | N | Done
2001-09-19 00:00:00 | Continental Power | EEL | Continental Power | [NAME] | D1 | Book was officialized late due to simultaneous running |  | Y | Y | N | Done
2001-09-18 00:00:00 | PWR-NG-ST-NENG-GDI;GDL | EA | US Power East | [NAME] | C | The book attributes did not agree with book request.  This prevented capture of data.  Attributes have been resolved.  Due to the immaterial values contained within the book VaR and Credit not  rerun. |  | N | N | Y | Done
2001-09-18 00:00:00 | FRT-SPOT-BAS; FRT-SPOT-PRC | EGM | US Freight | [NAME] | C | Books not officialized until AM |  | Y | Y | Y | Done
2001-09-18 00:00:00 | LNG-PRICE-BAS; IDX;PRC | EGM | US LNG |  | C | Books not officialed until AM |  | Y | Y | Y | Done
2001-09-18 00:00:00 | Zinc Deal Between EM-ENA-Galvak(Mex) | EGM |  | [NAME] | A | Deal was  completed on Aug 31st, but not entered into RisktRAC until Sep 17th. |  | N | Y | N | Done
2001-09-17 00:00:00 | FRT-EXOTIC-PRC | EGM | US Freight | [NAME] | C | Spreadsheet was not loaded into RisktRAC.  Uploaded in the AM and  VaR |  | Y | Y | N | Done
2001-09-17 00:00:00 | UK Credit Trading | EEL |  | [NAME] | C | Credit spreadsheet was not completed by deadline. |  | N | Y | N | Done
2001-09-17 00:00:00 | Continental Power | EEL | Continental Power | [NAME] | D1 | The MTM process failed due to unsynchronized time clocks.  This prevented curve load process.  [NAME] resolved and process reinitiated. |  | 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