Spreadsheet: stacey_white__39052__Summary Oct 15
Sheet: Graph Data Oct 015

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 | 09/04/-09/07 | 09/10-09/14 | 09/17-09/21 | 09/24-09/28 | 10/01-10/05 | 10/8-10/12 | 10/15-10/19
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 | 2001-09-04 00:00:00 | 2001-09-10 00:00:00 | 2001-09-17 00:00:00 | 2001-09-24 00:00:00 | 2001-10-01 00:00:00 | 2001-10-08 00:00:00 | 2001-10-15 00:00:00
EIM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  | 3 | EIM
EGM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57 |  |  |  | 16 | EGM
EBS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EBS
EEL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EEL
EES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EES
EAM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 5 |  |  |  | EAM
Book creation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Books Created
Curve Creation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Curve Creation
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-10-19 00:00:00 | ALBERTENA-PRC | IT/GRO | CANADA POWER | [NAME] | F | Book was officialized, however due to RisktRAC code requirements, the positions were not captured.  GRO working to correct naming convention to ensure position capture.  Positions flat, therefore no impact on VaR.  Credit captured positions |  | N | Y | Y | Done
2001-10-19 00:00:00 | UK Power; Continental Power | EEL | UK POWER | [NAME] | D1 | Extract feed ran slow due to simultaneous extract Continental Power, which resulted in late load into RisktRAC. |  | Y | Y | N | Done
2001-10-19 00:00:00 | Continental Power | EEL | Continental power | [NAME] | D1 | MTM values on EON transmission forwards are understated by $4.65 mil.  No impact on VaR.  [NAME] will not be reloaded. |  | N | Y | N | Done
2001-10-19 00:00:00 | CAND-BC-GD-XL-BAS; PRC | EA | Canada Gas | [NAME] | C | Due to an incorrect date selected for uploading data into RisktRAC, initial VaR run was delayed.  IT had to delete misdated data and  restart VaR. BA contacted to reload data using correct effective date. |  | Y | N | N | Done
2001-10-19 00:00:00 | Steel-Huntco-SG-PRC | EIM | US Steel | [NAME] | D2 | Attribute mismatch prevented capture of data.  BA and GRO have attended to correct data, however due to Metacalc functionality correction not captured.  Working to address. |  | Y | Y | Y | Done
2001-10-19 00:00:00 | EES A/R | EES |  | [NAME] | G | 1 of 5 credti files not received. |  | N | Y | N | Done
2001-10-19 00:00:00 | EESI-EAST-RTLG and EESI-OPTION | IT/GRO | EES  Power | [NAME] | F | Book was officialized, however due to RisktRAC code requirements, the positions were not captured.  GRO working to correct naming convention to ensure position capture.  Positions flat, therefore no impact on VaR. Credit captured data.
2001-10-18 00:00:00 | ALBERTENA-PRC | IT/GRO | CANADA POWER | [NAME] | F | Book was officialized, however due to RisktRAC code requirements, the positions were not captured.  GRO working to correct naming convention to ensure position capture.  Positions flat, therefore no impact on VaR.  Credit captured positions |  | N | Y | Y | Done
2001-10-18 00:00:00 | Steel-Huntco-SG-PRC | EIM | US Steel | [NAME] | D2 | Attribute mismatch prevented capture of data.  BA and GRO have attended to correct data, however due to Metacalc functionality correction not captured.  Working to address. |  | Y | Y | Y | Done
2001-10-18 00:00:00 | EIM-US-PAPER-PRC | EIM | US PAPER | Brent Price | C | Book was officialized late. |  | N | Y | Y | Done
2001-10-18 00:00:00 | [NAME] | EEL | UK POWER | [NAME] | D1 | Book received late. |  | Y | Y | N | Done
2001-10-17 00:00:00 | Power Benchmark | EA | Power West | [NAME] | G | LT-SW Index Option positions not being captured.  IT work to resolve. |  | N | Y | N | Done
2001-10-17 00:00:00 | CAND-BC-GD-XL-BAS; PRC | EA | Canada Gas | [NAME] | C | Spreadsheets were not uploaded.  As spreadsheets had no positions VaR not rerun. |  | N | Y | N | Done
2001-10-17 00:00:00 | EWS-RTL-EAST-NG-PRC | EES/EWS | EWS GAS | [NAME] | C | Book was officialized late |  | Y | Y | Y | Done
2001-10-17 00:00:00 | UK POWER | EEL | UK POWER | [NAME] | D1 | Due to slow server performance extract was slow and book loaded late.  VaR was rerun |  | Y | Y | N | Done
2001-10-16 00:00:00 | WEATHER-NA-PRC; WEATHER-EUROPE-PRC | EGM | US Weather | [NAME] | C | Data was not loaded to [NAME].  However no impact on VaR as VaR is calc'd by Quicksilver and Credit receives direct feed from Quicksilver. |  | N | N | N | Done
2001-10-16 00:00:00 | STEEL-HUNTCO-SG-PRC | EIM | US STEEL | [NAME] | C | Attribute mismatch.  Region code did not match RIsktRAC.  Corrected |  | Y | Y | Y | Done
2001-10-16 00:00:00 | FT-BRIDGE-SUBA-PRC | US BRIDGELINE | US Bridgeline | [NAME] | C | Book was officialized  twice, which caused non capture of positions. |  | N | Y | N | Done
2001-10-16 00:00:00 | CCO-ENPOWER-PRC | EEL | GRM | [NAME] | C | Book was officialized late |  | Y | Y | Y | Done
2001-10-16 00:00:00 | [NAME] | EEL | Uk POWER | [NAME] | C | File feed only contained 1 of 4 files required for upload into RisktRAC |  | Y | Y | N | Done
2001-10-15 00:00:00 | UKPOWER;UKPWRSWAP1; Continental Power; UK GAS; Eastern 1 & 2 Spreadsheets, UK GAS | IT/EEL | UK Office | [NAME] | G | Books were properly officialized for COB 10/15/01, however  RMS unable to load files on US side due to server permission issues.  IT working to resolve.  [NAME] will be loaded when resolved, with VaR and Credit rerun. |  | Y | Y | N | Done
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