Spreadsheet: rick_buy__32843__Summary Oct 08
Sheet: Graph Data Oct 08

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
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
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 (Includes 2 issues from previous week not reported)
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-12 00:00:00 | 14 ERMS EGM books were not picked up in RisktRAC due to a mismatch of attributes between ERMS and RisktRAC. | GRO | US Global Products | [NAME] | F | The over riding issue is that the current processes to keep RisktRAC up to date are so manual that the probability of errors such as this occuring are very high. Attribute mismatches happen frequently when there is more than one commodity per in the source system book.  When setting up new books, the book admin must indicate that there is more than one commodity in the book (or that the commodity identifier ie BRN has changed to BRNT) so Risk Analytics can set up the appropriate number of books.  Going forward we are implementing procedures to identify books that have attribute mismatches and correct. |  | Y | Y | Y | Done
2001-10-12 00:00:00 | EBS Longhaul Positions | EBS | US EBS | [NAME] | A | Positions were incorrect and had to be reloaded.  VaR rerun once updated. |  | Y | Y | N | Done
2001-10-12 00:00:00 | [NAME] | EEL | UK POWER | [NAME] | D1 | Only 2 of 4 files were transmitted during feed process.  Data was update and VaR rerun |  | Y | Y | N | Done
2001-10-12 00:00:00 | STEEL-HUNTCO-SG-PRC | GRO | US STEEL | [NAME] | C | Due to change in attributes on RisktRAC side to prevent duplication of book attributes, position were not captured.  Attributes corrected, however due to minimal VaR and credit exposure process not rerun. |  | N | Y | Y | Done
2001-10-12 00:00:00 | FT-BRIDGE-SUBA-BAS | Bridgeline | US Bridgeline |  | C | Book was officialized twice, which caused RisktRAC to reject both PostIDS.  Book has no VaR or credit impact. |  | N | N | N | Done
2001-10-11 00:00:00 | Weather Credit File | EGM | US Weather | [NAME] | H | File not transmitted on schedule |  | N | Y | N | Done
2001-10-11 00:00:00 | UK GAS | EEL | UK Gas | [NAME] | A | Positions incorrect due to incorrect deal capture.  Data corrected and reloaded. |  | Y | Y | Y | Done
2001-10-10 00:00:00 | UK  EBS Credit File | EEL | UK EBS | Niel Tarling | C | Due to new person managing process file, file was not processd on time. |  | N | Y | N | Done
2001-10-10 00:00:00 | UK POWER | EEL | UK POWER | [NAME] | D1 | Due to enPower server maintenance, books were officialized late.  Further simultaneous load of UK GAS extract time increased.  VaR rerun when extract process complete. |  | Y | Y | N | Done
2001-10-09 00:00:00 | UK POWER; UK POWER SPREADSHEETS | EEL | UK POWER | [NAME] | D1 | File was sent late due to Server space issues with initial [NAME] run.  UK Spreadsheets initially rolled and subsequently updated. |  | Y | Y | N | Done
2001-10-08 00:00:00 | ENA-IM-WC-ROX-PHY | EA | US Gas West | [NAME] | C | Book not officialized.  Was officialized in the AM. |  | Y | Y | Y | Done
2001-10-08 00:00:00 | ABDIRECT-3P-PRC; ABDIRECT-HEDGES | GRO | CAD POWER | [NAME] | D2 | Due to special requirements for EPMI books, books had to be reset up and data pulled in.  VaR was rerun. |  | Y | Y | N | Done
2001-10-08 00:00:00 | DUB-INT-PHY; DUB-OPT-PRC | EES | US EES GAS | [NAME] | C | Positions were loaded incorrectly.  Data was updated and VaR rerun. |  | Y | Y | N | Done
2001-10-08 00:00:00 | FINANCIAL-AFF-PRC; FINANCIAL-EM-PRC; FINANCIAL-PROP-PRC; FINANCIAL-TN10-PRC; FINANCIAL-TN5-PRC | EGM | US Financial | [NAME] | C | Books were not officialized, however book is not used in VAR calculation and data for credit is provided directly to credit.  Credit reported using previous days data. |  | N | Y | N | Done
2001-10-08 00:00:00 | UK POWER; UKPWRSWAP1 | EEL | UK POWER | [NAME] | D1 | Due to simultaneous load of UK GAS and UK POWER, processing times delated for UK POWER.  Loaded late into RisktRAC.  Only received 1 of 4 files for UKPWRSWAP1 |  | Y | Y | N | Done
2001-10-05 00:00:00 | Canada PWR VAR |  | CAD POWER | [NAME] RAC | H | VaR is being reported as zero on CM VaR.  MRM RAC working to identify issue and correct.
2001-10-05 00:00:00 | Freight VaR to high |  | US Freight | [NAME] | H | VaR being reported is thought to be too high.  Possible cause is due to correlations.  MRM RAC reviewing to identify and resolve issue.
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