Spreadsheet: rick_buy__32699__0608 summary of issues
Sheet: Graph Data June 4

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
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 | 2001-06-04 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-08 00:00:00 | UK Power | EEL | UK Power | [NAME] | D1 | UK Power Book was officialized on time, however the feed did not complete until 6:13 am due to length of time needed for extract process. | Resolution has been developed and is currently being tested.  Test feed should be in place by 06/11/01 | N | Y | Y | Pending
2001-06-08 00:00:00 | EAF-AUS-PRC | EEL | Australian Power | [NAME] | C | Due to Australian Holiday book was not officialized.  However, the holiday procedures were not followed. | Need to recommunicate holiday officialization procedures to Risk Management team. | Y | Y | Y | Pending
2001-06-07 00:00:00 | Eastern Spreadsheets 1&2 | EEL | UK Power | [NAME] | E | Since a Power Curve for Jun 7th was not saved, the spreadsheets were unable to run a valuation and report MTM & Risk exposures for [NAME].  Therefore data reported is as of Jun 6. | Risk Management is working to develop process to insure that all needed curve data is saved for each day.  Additionally, need to establish procedures for reporting MTM and P&L when process fails. | N | Y | Y | Pending
2001-06-07 00:00:00 | UK Power | EEL | UK Power | [NAME] | D1 | UK Power Book was officialized on time, however the feed did not complete until 6:50 am due to length of time needed for extract process. | Resolution has been developed and is currently being tested.  Test feed should be in place by 06/11/01 | N | Y | Y | Pending
2001-06-07 00:00:00 | UK Power | EEL | UK Power | [NAME] | E | Traders failed to save Power Curves for June 7th.   Therefore, no P&L Curve shift available.  All positions were properly loaded into RisktRAC | Risk Management is working to develop process to insure that all needed curve data is saved for each day. | N | N | N | Pending
2001-06-05 00:00:00 | Coal Positions | EGM | COAL | [NAME] | E | Positions related to a specific curve, F-CAPE-TC, was not captured in the system which impacts the VaR calculation.  Deals were being moved to different books and using different curves to value. |  | N | N | N | Pending
2001-06-04 00:00:00 | Factor Loading/Primary Curves |  |  | RAC | G | Due to current processes and procedures in place, factor loadings have not been approved since April 17, 2001.  This lack of factor loading prevents the addition of new primary curves in RisktRAC.  Therefore certain secondary curves are not mapped to the appropriate primary curves.  The addition of the new primary curves  could impact VaR. | Coordinate with various groups to identify improved process for approving factor loadings and primary curves into system. | N | N | N | Pending
2001-06-04 00:00:00 | UK Power | EEL | UK Power | [NAME] | D1 | UK Power Book was officialized on time, however the feed did not complete until 6:50 am due to database issues.  The database problem was caused by  "Rollback Segment"  error , which is caused by the size of data conflicting with other users. | DBA have improved rollback segment, but IT to research solution to prevent further occurance. | N | Y | Y | Pending
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
2001-04-27 00:00:00 | INTRA-CAND-WE-GD-GDL | EA-CAN | Canada | [NAME] | C | Book not officialized | Implement Active/Inactive website.Canada Risk Mgmt. Group to be trained on using Active/Inactive book website. |  |  |  | Pending
SUMMARY FOR  05/28 - 06/01 BY GROUP | % of Total Errors for the Week | # of errors | # books by group
EIM
EGM
EEL
EA-CAN |  |  | 36
EA - GAS
EA - POWER
EES |  |  | 9
EBS |  |  | 10
OTHER
TOTAL