Spreadsheet: rick_buy__32711__0806 summary of issues
Sheet: Graph Data June 11

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
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 | 2001-06-11 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-15 00:00:00 | Heat Rate Swaps | EA-POwER | US-POWER |  | F | Positions related to Heat Rate Swaps are being captured for [NAME] purposes, however data is not automatically captured for RisktRAC VaR calculation due to the problems associated with index issues noted below | EnPower needs to be updated to recognize basis legs and [NAME] needs to be updated to recognize change in source system.  Changed in systems is estimated to complete by 06/30/01 | Y | Y | Y | Pending
2001-06-15 00:00:00 | RMS Database |  |  | IT | F | During performance of weekly archive process, the INDEX process failed to run  appropriately.  Therefore the Index process was not completed by 6am.  The non completion of the Index process preveted the receipt of late UK feeds.  As US books are officialized end of business day, no impact on recording 06/15/01 positions. | DBA's working with help desks to identify problem and correct.  Upgrade to [NAME] 8 may resolve issue. | Y | Y | Y | Pending
2001-06-15 00:00:00 | UK Power | EEL | UK-Power | [NAME] | D1 | Due to maintenance error over the weekend, the Unix server did not receive needed data, which resulted in MTM failure.  MTM reperformed in AM and data submitted. | IT  working to implement procedures at close of business that would allow time to identify errors prior to Houston deadline. | Y | Y | Y | Pending
2001-06-15 00:00:00 | Eastern 1 & 2 spreadsheets | EEL | UK-Power | [NAME] | B | Due to Maintenance error the 06/15 MTM failed.  Rolled positions for 06/14 | IT  working to implement procedures at close of business that would allow time to identify errors prior to Houston deadline. | Y | Y | Y | Pending
2001-06-15 00:00:00 | DBL-XL-TRIGGER-PRC |  | US-GRM | [NAME] | C | Assigned staff believed they had loaded sheet successfully, however data not captured. | [NAME] use of Active/Inactive Website to RM to ensure any data transfer issues are properly identified. | Y | Y | Y | Pending
2001-06-14 00:00:00 | UK POWER Options | EEL | UK Power | [NAME] | A | 1.4 Terrawatt position is not being reported and therefore is not being captured for VaR purposes. | Risk management is working to identify why the positions are not being captured.  An amendment to [NAME] will take place in 2-3 weeks in an attempt to captured positions.  In the mean time [NAME] should run and AD-HOC VaR and transmit data for DPR purposes. | N | Y | Y | Pending
2001-06-12 00:00:00 | EAF-AUS-PRC | EEL | Australian Power | [NAME] | C | Book was not officialized. Update Pending |  | N | Y | Y | Pending
2001-06-11 00:00:00 | Heat Rate Swaps | EA-Power | US Power EAST | [NAME] | C, D2 | Heat rate swaps were not captured in RisktRAC, due to the lack of an appropriate book within [NAME] and that the appropriate commodity NG was not set up in EnPower.  These two factors prevented the capture of the Heat Swap positions. | The Needed book was created within [NAME] and the commodities were updated within EnPower.  The books were reofficialized and the VaR was rerun for Commodity VaR, AGG_ECT and AGG Power IV. W orking to develop procedures to insure reconcile positions between source and reporting systems. | Y | Y | Y | Pending
2001-06-11 00:00:00 | EAF-AUS-PRC | EEL | Australian Power | [NAME] | C | Book was not officialized.  Update is Pending |  |  |  |  | Pending
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.  Test file for new extraction appears to be working.  Will transmit one more test prior to placing into production. | 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-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-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 Total Errors for the Week | # of errors | # books by group
EIM
EGM
EEL
EA-CAN
EA - GAS
EA - POWER
EES |  |  | 9
EBS |  |  | 10
OTHER
TOTAL