Spreadsheet: rick_buy__32711__0806 summary of issues
Sheet: Graph Data July30

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
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
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
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-08-02 00:00:00 | UK Power | EEL | UK Power | [NAME] | H | Net Open positions reported by RisktRAC for UK power missing approximately 5 terrawatts compared to data transmitted. | RM researching issue. | N | Y | N | Pending
2001-08-02 00:00:00 | PWR-NG-TEXAS-GDI; PWR-NG-ST-HEDGE-GDI;PWR-MG-GAS-MTM-GDI; PWR-NE-GAS-MTM-GDI; PWR-MW-GAS-MTM-GDI; PWR-NG-ERCT0-AST-GDI | EA | US Power EAST | IT | H | Books were officialized, however the data was not captured by RisktRAC.  No problem noted during end of day procedures or with data attributes.  IT could not resolve the issue. | IT and RM will monitor GDI books to identify any future problems.  Subsequent review of Postids noted that positions were captured later in the day. | N | Y | N | Pending
2001-07-30 00:00:00 | Power VaR | EA | Power East | [NAME] | E | Volatilty for R1B curve was marked incorrectly by trader, which materially overstated VaR for positions against the curve.  Curve data was corrected, reloaded and VaR rerun. | Update Pending | Y | N | N | Pending
2001-07-27 00:00:00 | FIN-AGRI-GRAINS-PRC; UK-COFFEE-PRC;FIN-AGRI-SOFT-PRC;UK-COCOA-PROP-PRC;UK-SUGAR-NYBO-P-PRC | EGM | US Financial | [NAME] | H | Books had liquidated, but were still reporting deal legs with zero volumes and mtm value.  Book has been officialized to zero, however due to deal leg table it appears as though it has Credit and VaR exposure, when non appears to exist. | BA and ERMS IT working to identify issue and correct to insure proper data capture by RisktRAC and CAS. | N | Y | N | Pending
2001-07-27 00:00:00 | Eastern 1 & 2 spreadsheets | EEL | Eastern Spreadsheets | [NAME] | D1 | Positions in spreadsheets were rolled from COB Jul 26.  The data was rolled due to an error in the overnight MtM run of the Excel based models.  Data being rerun and will be feed to RisktRAC later. | Update pending. | Y | Y | Y | Pending
2001-07-23 00:00:00 | FT-IM-ENOV-GDL | EA | US Ennovate | [NAME] | C | Book was officialized, however due to an attribute mismatch the book was not captured by RisktRAC. | Issue was identified on 07/25.   Proper procedures for changing attributes communicated to BA. | N | Y | N | Pending
2001-07-20 00:00:00 | EES-MTM Power at Coutnerparty level | EES | EES Power | [NAME] | C | EES Power MTM at counterparty level feed for Credit not received for COB 07/19.  Per [NAME] this is due to IT issues. | Update pending | N | Y | Y | Pending
2001-07-20 00:00:00 | FT-IM-ENOV-GDL | EA | US Ennovate | [NAME] | C | Book was officialized, however due to an attribute mismatch the book was not captured by RisktRAC. | BA is working with ERMS IT to determine issue and resolution. | N | Y | Y | Pending
2001-07-18 00:00:00 | Nordic Power | EEL | Nordic Power | [NAME] | D1 | Nordic Power was loaded late into RisktRAC  due required rerun of MTM due to omission of Nordic futures and options. | Update Pending | Y | Y | Y | Pending
2001-07-09 00:00:00 | INTRA-EMWNSS2-GDL | EA | US GAS | [NAME] | C | Book was officialized, but due to an attribute mismatch the data was not captured by RisktRac.    [NAME] was resolved and data pulled in and VaR rerun. | Working to identify issue and resolve. | N | Y | Y | Pending
2001-07-02 00:00:00 | NBP Curve | EEL | UK Gas | [NAME] | E | Curve data after Sept 2003 is zeroed out on the [NAME] side, while data is valid on UK side.  Zero values can cause VaR to crash as it is a primary curve. | RM and IT researching to determine what is causing error and provide update. | N | N | N | Pending
2001-07-02 00:00:00 | EAF-AUS-PRC | Australia | Australia Power | [NAME] | H | Update pending |  |  |  |  | Pending
2001-06-29 00:00:00 | UK EBS | EEL | UK EBS | [NAME] | G | EBS credit file not transmitted for 06/29/01. | Will discuss importance of completing end of day process with RM | N | Y | N | Pending
2001-06-27 00:00:00 | EES-CANADA-PRC | EES | EES-GAS | [NAME] | E | Trader failed to load needed curve data, which prevented calcing of book.   Curve data was loaded and books were officialized | RM needs to develop procedures to identify when needed data is not loaded | Y | Y | Y | Pending
2001-06-27 00:00:00 | UK-EBS | EEL | UK-EBS | [NAME] | G | The credit file was not processed since there were no new deals or curve shift.  RM felt that processing was not necessary since there was no change in prior day data and given that the Credit system reverts to prior day data if current day is not available. | Discuss process given circumstance with [NAME] and UK RM | N | Y | N | Pending
2001-06-27 00:00:00 | FT-CAND-EGSC-BC-PRC;FT-CAND-EGSC-PRC; FT-CAND-EGSC-OPT IDX & PRC | EA | Canada Gas | [NAME] | G | Books were officialized late, but before VaR deadline.  However, the data was not captured for  credit reporting purposes since credit report runs at 1:30am. | Will discuss potential to change timing of credit process with [NAME] and [NAME]. | N | Y | N | Pending
2001-06-27 00:00:00 | [NAME] |  |  |  |  | The Solarc Europe file was not trasmitted to Credit, which understates credit exposure for physical nominations that have not been billed. | Application recently went to a new server which may have caused change.  Working to identify issues and correct. Fix expect 06/28 | N | Y | N | Pending
2001-06-26 00:00:00 | VaR failure |  |  |  | E | B33 & B11 primary power curves have not been marked for the past 15 days, which caused the VaR run to fail.  The curves have not been marked because their use has been discontinued.   RisktRAC requires that all primary curves be marked or VaR will fail to run completely. | Power RM notified users and RAC that the curves would be not be marked going forward and that they should be deleted during factor loading to prevent VaR failure.  Latest factor loading has not been approved, which prevented the deletion of the discontinued curves.  Need to approve latest factor loading or develop alternate process to add and delete curves. | Y | N | N | Pending
2001-06-22 00:00:00 | DUB-ERMS-XL-PRC; DUB-ERMS-XL-BAS; DUB-INT-PHY | EES | EES-GAS | [NAME] | H | Book [NAME] states that normal procedures were followed and file was uploaded into RisktRAC with no error messages noted, however positions were not noted in RisktRAC.  As file was reloaded in the AM IT could not determine the problem.  VaR was rerun. | Follow up to try and ID issue. | Y | Y | Y | Pending
2001-06-22 00:00:00 | Eastern Spreadsheets 1&2 | EEL | European | [NAME] | D1 | Original file feed size noted to be extremely small.  London RM reviewed and transmitted larger file. | Waiting on update related to issue and action plan. | Y | Y | Y | Pending
2001-06-21 00:00:00 | EES Credit File | EES |  | [NAME] | G | Due to problems with source system upgrade, the EES MTM credit file has not been received in a timely manner. | Risk Management working to identify problem and resolving issue. | N | Y | Y | Pending
2001-06-21 00:00:00 | Nordic Power | EEL | Nordic Power | [NAME] | E | Spreadsheets officialized late due to Overnight MTM failure caused by missing curve data.  The needed gas price curve was not saved. | Risk Management is working to develop a process to monitor the price curve saving process.  Expect to have process in production in about 2 weeks. | Y | Y | Y | Pending
2001-06-21 00:00:00 | Eastern 1&2 Spreadsheets | EEL | European | [NAME] | G | Spreadsheets officialized late to due file format incompatability with gas hedge files.  Due to a systems upgrade the file format was altered. | Currently there is no TEST server available to test system upgrades prior to placing into production.  RM working with IT to secure a test server to prevent future occurance. | Y | Y | Y | Pending
2001-06-21 00:00:00 | SAP FILE |  |  |  | G | Due to a change in the feed process, which was not communicated to downstream users, the data was not properly captured by Credit.  This change in feed caused an overstatement of Credit Risk by $500 million | Communicate the importance of discussing any changes in current procedures, feeds or formats with all impacted downstream users to minimize potential impact to systems and users. | N | Y | N | 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] | D1 | 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 | Heat Rate Swaps | EA-POwER | US-POWER |  | D2 | 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 | 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-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-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] | 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-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-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 | 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-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-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-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 | 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 bo | Waiting for an Action Plan from [NAME]. | N | 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
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