Spreadsheet: rick_buy__32819__Summary Sep  24
Sheet: Graph Data Sep 24

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
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
EIM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | EIM
EGM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57 |  | 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-09-28 00:00:00 | Paper VaR | EIM | US PAPER | [NAME] | A | Positions were incorrect.  Data was updated and VaR rerun. |  | Y | Y | Y | Done
2001-09-28 00:00:00 | Power VaR | EA | Power East | [NAME] | A | Canada Alberta GAS Positions were incorrect.  Data updated and VaR rerun. |  | Y | Y | Y | Done
2001-09-28 00:00:00 | EAF-AUS-SRA-PRC | EEL | AUSTRALIA POWER | HEIDI MASON | C | Book was not officialized for COB Sep 28 |  | N | N | N | Done
2001-09-28 00:00:00 | UK-EBS Credit file | EEL | UK EBS | Niel Tarling | G | Credit file not transmitted within schedule. |  | N | Y | N | Done
2001-09-28 00:00:00 | UK POWER | EEL | UK Power | [NAME] | D1 | Due to increased volumes associated with Month End the book finished processing into RisktRAC late. |  | Y | Y | N | Done
2001-09-27 00:00:00 | Unify Gas Credit Feed |  |  |  | G | Credit  feed not received as schedule.  Data provided later. |  | N | Y | N | Done
2001-09-26 00:00:00 | EPMI-W-BIO-INV-PRC; EPMI-W-BIO-PRC; EPMI-W-GEO-INV-PRC; WPMI-W-GEO-PRC; EPMI-W-WIND-INV-PRC | EA | US POWER WEST | [NAME] | C | Due to an attribute change in region codes data was not captured by RisktRAC.  Working to resolve. |  | Y | N | Y | Done
2001-09-26 00:00:00 | OPTIONS-EXOTIC-PRC | EA | US GAS FIN | [NAME] | C | Book was not officialized.  No impact on VaR as book only contains premium related to options reported on XL  sheet upload. |  | N | Y | Y | Done
2001-09-25 00:00:00 | [NAME] feed | EIM | US Lumber | [NAME] | G | Credit feed file not transmitted.  Data provided late. |  | N | Y | N | Done
2001-09-25 00:00:00 | Continental Power | EEL | UK Power | [NAME] | D1 | Due to improper documentation used to schedule Dove calc MTM process resulted in data for incorrect COB data.   Code correct and MtM rerun for COB 25.  Data loaded late into RisktRAC. |  | Y | Y | Y | Done
2001-09-25 00:00:00 | UK Power; Eastern SS 1&2; UKPWRSWAP1 | EEL | UK Power | [NAME] | D1 | Due to improper documentation used to schedule Dove calc MTM process resulted in data for incorrect COB data.   No COB 25 data positions and values rolled from  COB Sep 24th. |  | Y | Y | Y | Done
2001-09-24 00:00:00 | NG-PRICE-GDL | EA | US GAS   FIN | [NAME] | C | Due to attribute mismatch the book data was not captured by RisktRAC.   [NAME] was rerun once data loaded into RisktRAC. |  | Y | Y | Y | Done
2001-09-24 00:00:00 | Continental Power | EEL | Continental Power | [NAME] | B | Due to an upstream change in Continental Power the Price curve is based on COB Sep 21.   Downstream users not advised |  | Y | Y | N | Done
2001-09-24 00:00:00 | UK POWER, Eastern Spreadsheets 1 & 2 | EEL | UK Power | [NAME] | D1 | UK Power was officialized late due to code change for server that was inconsistent with Dove calc.  Process corrected.  Spreadsheets data rolled from COB Sep 20th due to dependence on UK Power. |  | N | 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