Spreadsheet: rick_buy__32803__Summary Sep  17
Sheet: Graph Data Aug 27

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
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
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-08-31 00:00:00 | Nordic Power | EEL | Nordic Power | [NAME] | D1 | MTM failed due to unknown IT issue.  Process failed to generate error message.  Book was rerun and loaded into RisktRAC |  | N | Y | N | Done
2001-08-31 00:00:00 | UK Power; Eastern Spreadsheets | EEL | UK Power | [NAME] | E | Books loaded late into RisktRAC due to missing curve data which prevented completion of MTM process and feed.  Due to immaterial curves shift between prior day data, used prior day curve data to rerun MTM process.  Due to US Holiday data was captured in VaR run. |  | N | Y | N | Done
2001-08-31 00:00:00 | TOLUENE-DISTR-PRC | EGM | US Global Products | [NAME] | C | Attribute mismatch.  Book was officialized using risk type of   basis. |  | Y | Y | N | Done
2001-08-31 00:00:00 | OIL-CAND2-EGSC-PRC | EGM | US Global Products | [NAME] | C | Book was not officialized as part of end of day process.  Book was officialized in the AM. |  | Y | Y | N | Done
2001-08-30 00:00:00 | CR-AG-EES-RG-XL-PRC; CR-AGG-EES-RPS-PRC | EES | EES | [NAME] | C | MTM credit files at counterparty level were not updated for COB Aug 29 |  | N | Y | N | Done
2001-08-30 00:00:00 | EAF-AUS-SRA-PRC | EEL | Australia Power | [NAME] | D1 | Positions are held in spreadsheets due to enPower limitations.   RM are experiencing problems uploading data into RisktRAC.  Working with IT to resolve and upload data. |  | N | N | N | Done
2001-08-30 00:00:00 | STEEL VaR | EIM | Steel | [NAME] | E | VaR had to be rerun because BLCR & BLCRFH steel curves not loaded.  VaR reverted to prior day, however uploated new curve data and Reran VaR. |  | Y | N | N | Done
2001-08-30 00:00:00 | FT-CAND-EGSC-BC-IDX; FT-CAND-EGSC-BC-PRC; FT-CAND-EGSC-IDX; FT-CAND-EGSC-PRC; FT-CAND-EGSC-A-BAS; FT-CAND-EGSC-PRC; FT-CAND-EGSC-BO-PRC; FT-CAND-ROLLOFF-PRC | EA | Canada Gas | [NAME] | F | Due to the volume of deals and month end process books were officialized past 3 am.  This caused the books to miss the Credit process.  Additionally, certain books were officialized for current day and prior day, which caused manual processing for IR/FX group. |  | N | Y | Y | Done
2001-08-30 00:00:00 | UK Power | EEL | UK Power | [NAME] | D1 | Book loaded late into RisktRAC due to slightly late officialization |  | Y | Y | N | Done
2001-08-30 00:00:00 | GD-TEXAS-GDL & ST-BAMMEL-FNCL-GDL | EA | US GAS TEXAS | [NAME] | C | Books were not officialized during end of day process. |  | Y | Y | Y | Done
2001-08-30 00:00:00 | EBS-BWT-PRC | EEL | UK EBS | Niel Tarling | G | Credit file was not appropriately saved for processing.  . |  | N | Y | N
2001-08-29 00:00:00 | EAF-AUS-SRA-PRC | EEL | Australia Power | [NAME] | D1 | Positions are held in spreadsheets due to enPower limitations.   RM are experiencing problems uploading data into RisktRAC.  Working with IT to resolve and upload data. |  | N | N | N | Done
2001-08-29 00:00:00 | NG-X-OPT-HO-PRC | EA | US Gas Financial | [NAME] | D2 | Book was officialized, however due to attribute issues not captured by RisktRAC. |  | Y | N | N | Done
2001-08-29 00:00:00 | FT-KATY-GDI | EA | US GAS TEXAS | [NAME] | C | Book was not officialized |  | Y | Y | Y | Done
2001-08-29 00:00:00 | UK Credit Trading | EEL |  | [NAME] | G | Due to problems with DPR process file was not completed in time. |  | N | Y | N | Done
2001-08-29 00:00:00 | Nordic Power | EEL | Nordic Power | [NAME] | F | Book is encountering delays during upload due to systems performance issues.  IT is working to identify issue and resolve |  | Y | Y | N | Done
2001-08-28 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-PRC; FRT-SOUTHEAST-BAS;FRT-UCF-PRC;FRT-WEST-PRC; FRT-WEST-PRC;FRT-WTI-PRC | EGM | US Freight | [NAME] | C | Books were not officialized.  Done in the AM and VaR rerun. |  | Y | Y | Y | Done
2001-08-28 00:00:00 | UKPWRSWAP1, UK  Term | EEL | UK POWER | [NAME] | D1 | Uk [NAME] :Only 1 of the 4 files was transmitted.  Issue identified and file resent.  UK TERM:  File not received by 6:15, but did make the VaR Run. |  | Y | Y | N | Done
2001-08-28 00:00:00 | Nordic Power | EEL | Nordic Power | [NAME] | E | Due to an incorrect interest rate curve mapping in Energydesk, the book was late.  The Curve was corrected and the MTM rerun. |  | Y | Y | N | Done
2001-08-27 00:00:00 | EES AR File | EES |  |  | H | Due to systems issues the file received contained data for COB 08/27 and COB 08/26.  Corrected file was subsequently remitted.
2001-08-27 00:00:00 | DUB-INT-PHY | EES | US EES GAS | [NAME] | C | Book was not officialized. |  | N | Y | N | Done
2001-08-27 00:00:00 | COAL-SYN-XL-BAS | EGM | US COAL | [NAME] | C | Book was not officialized |  | Y | Y | N | Done
2001-08-27 00:00:00 | UK-POWER; CONTINENTAL POWER; EASTERN SPREADSHEETS | EEL | UK Power | [NAME] | D1 | Continental power was officialized late for COB 27 due to overnight MTM failure.  Process was subsequently rerun and officialized, VaR was Rerun.  UK Power was officialized late due to an unnecessary MTM process, that was halted by IT/Risk and officialized.  Eastern SS officialized late due to issues with UK Power, which is a precursor to Eastern SS officialization.
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