Spreadsheet: rick_buy__32699__0608 summary of issues
Sheet: Graph Data May 28

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
Deal Capture
Deal Valuation |  |  |  |  |  |  |  |  |  |  |  |  | 1
Breakdown in Officializing Process- Human |  |  |  |  |  |  |  |  |  | 13 | 7 | 2
Breakdown in Officializing Process- IT(UK) |  |  |  |  |  |  |  |  |  | 6 | 5 | 6
Breakdown in Officializing Process- IT (US) |  |  |  |  |  |  |  |  |  |  |  | 1
Curve Issues |  |  |  |  |  |  |  |  |  |  |  | 1
Uncontrollable-System Needs to Change |  |  |  |  |  |  |  |  |  | 2 | 1
Miscellaneous |  |  |  |  |  |  |  |  |  | 1 |  | 1
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
LOG OF PENDING 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-06-01 00:00:00 | [NAME] | EBS | Bandwidth | [NAME] | E | Volatilty Curve Data not Captured in RisktRAC. | Following up with IT to determine issue and resolution | Y | N | N | Pending
2001-06-01 00:00:00 | EBS-BWT | EEL | EBS-BWT | [NAME] | C | Risk Management advised that file is late because of month-end issues and a larger than normal number of deals to be input. |  | Y | Y | Y | Pending
2001-06-01 00:00:00 | UK Power | EEL | UK Power | [NAME] | D1 | Book was loaded into RisktRac 14 mins late at 6:14 AM Houston time. | Resolution has been developed and is currently being tested.  Should be moved to production around 06/08/01 | N | N | N | Pending
2001-06-01 00:00:00 | Nordic Power | EEL | Nordic Power | [NAME] | C | Business holiday for 06/04/01, however appropriate holiday schedule not followed.  Communicated procedures required that 06/01/01 data be officialized prior to holiday. | Recommunicate holiday procedures with appropriate Business Risk Managers to insure that data is appropriatesly reported. | N | Y | Y | Pending
2001-05-31 00:00:00 | UK Power | EEL | UK Power | [NAME] | D1 | Book was loaded into RisktRac 14 mins late at 6:14 AM Houston time. | Steps are being taken by IT to try to reduce the feed time of moving the UK Power file to RisktRac. | Y | Y | N | Pending
2001-05-29 00:00:00 | Nordic Power | EEL | Nordic Power | [NAME] | D1 | Experienced problems sending their feed to RisktRac due to a failure in the overnight Nordic MTM system run. | IT is working on this issue. | N | N | N | Pending
2001-05-24 00:00:00 | Eastern Books | EEL | UK Eastern | [NAME] | D1 | Problems loading current day spreadsheet as a result, 70 Bcf of hedges did not make it to RisktRac. | IT is working on this issue. | N | Y | Y | Pending
2001-05-24 00:00:00 | UK Power | EEL | UK Power | [NAME] | D1 | Database is not functioning properly. (IT issues) | Houston IT working on fixing this problem. |  |  |  | Pending
2001-05-22 00:00:00 | UK Gas | EEL | UK Gas | [NAME] | E | PPP power curve was loaded into the curve file thus causing incorrect valuation and problems with the position files. | Waiting for an Action Plan from UK. | Y | N | N | Pending
2001-05-22 00:00:00 | Nordic Power | EEL | Nordic Power | [NAME] | D1 | File had to be re-send because of a deal that was doubled up.  File was re-sent before the first file sent completed reconciling deal and position table. | Houston IT suggested when having to re-send file, develop a test to check if first file was completed and wait 10 mins before sending the second one. | N | N | N | Pending
2001-05-21 00:00:00 | Unified Power | EA-POWER | Power | [NAME] | D1 | Unified power system failed and had to be re-run. | Unified system personnel are monitoring the system to determine cause of the problem. | N | Y | N | Pending
2001-05-18 00:00:00 | Nordic Power | EEL | Nordic Power | [NAME] | D1 | Multiple UK files came in at the same time, therefore, the Nordic file was not able to get through. | Have the DBA increase the size to allow files to be sent simultaneously. | Y | Y | N | Pending
2001-05-08 00:00:00 | Continental Power | EEL | Continental Power | [NAME] | D1 | Monday was a bank holiday and IT switched [NAME] off as they did not want the systems to run overnight.  However, it was not turned on by IT for Tuesday 8 May close of business overnight run.  Consequently, [NAME] did not run and there was no data for 8 May to be officialized by risk management.  [NAME] had to be subsequently re-run by IT during the current day and was then officialized and loaded into [NAME] at 7:35 am Houston time. | Procedure to be put in place so that the dates for running of the mtm are clearly stated and defined for the benefit of IT.  This will ensure that any confusion is removed as to the dates for the mtm run. | Y | Y | Y | Pending
2001-05-08 00:00:00 | Nordic Power | EEL | Nordic Power | [NAME] | D1 | Nordic Power data for 8 May did not load into [NAME] until 6:13 am Houston time.  This was due to a random IT error in that some options failed to be calculated in the overnight mtm run.  Nordic risk management had to manually determine which of the book's option positions failed to be calculated and then had to manually recalculate these options before officialization could be initiated. | Waiting for an Action Plan from [NAME]. | N | N | N | Pending
2001-04-30 00:00:00 | FT-CAND-AB-GDL-GDL, INTRA-CAND-BC-BAS, INTRA-CAND-BC-GD-GDL, INTRA-CAND-BE-PRC, INTRA-CAN-WE-DG-DGL, FT-CAND-OP-GD-GDL | EA-CAN | Canada | [NAME] | C | Books not officialized.  When running the exception reports, an incorrect effective date was used, resulting in the inaccurate capture of PostID's that were not officialized. | Implementation of new Active/Inactive book website should help identify any unofficialized books during end of day process. Canada Risk Mgmt. Group to be trained on using Active/Inactive book website. | Y | Y | Y | Pending
2001-04-27 00:00:00 | EBS Books | EBS | EBS US |  | D2 | Takes 1+ hour to upload books into RiskTrac. | Risk + RAC to determine if there is an easier way. [NAME] and Ramesh will meet with [NAME] to discuss prioritizing file load. | N | N | N | Pending
SUMMARY FOR  05/28 - 06/01 BY GROUP | % of errors to books | # of errors | # books by group
EIM |  | 0 | 33
EGM |  |  | 540
EEL |  |  | 13
EA-CAN |  | 0 | 36
EA - GAS |  |  | 288
EA - POWER |  |  | 132
EES |  | 0 | 9
EBS |  |  | 10