Spreadsheet: stacey_white__38853__Log as of 28 Nov 00
Sheet: Daily log - date

COB Date | Reported by: | Book | Commodity/office | Desk/BA | Office/ Trader | Responsibility for to do | Class | Problem | Long description/To do's | [NAME]? | Credit affected? | Impact cash flows? | # of open to do's
Total errors for week |  | 8
2000-11-28 00:00:00 | Risk Controls | NG-LTX-GDL | Gas | [NAME] | [NAME] | Risk Management | 1 | Book officialized on time, but positions had to becalced and reofficialized.  Caught on bench this morning. | System enhancements where book admin's do not have to calc same book 4 & 5 times (different positions needed during due to index settlement bid-week for VAR, trader, head trader). | yes | yes | yes | 1
2000-11-28 00:00:00 | Risk Controls | NG-PRICE-GDL | Gas | [NAME] | [NAME] | Risk Management | 1 | Book officialized on time, but positions had to becalced and reofficialized.  Caught on bench this morning. | System enhancements where book admin's do not have to calc same book 4 & 5 times (different positions needed during due to index settlement bid-week for VAR, trader, head trader). | yes | yes | yes | 1
2000-11-28 00:00:00 | IT | Nordic Power | UK |  |  |  | 3 | Book officialized on time, but feeds did not make 6am cut-off | Work on feed speed. | yes | yes | yes | 1
2000-11-27 00:00:00 | IT | UK power | UK |  |  |  | 3 | [NAME] did not make the 6am cut off |  | yes | yes | yes | 1
2000-11-22 00:00:00 | Risk Controls (not to be included on summary) | DUB-ERMS-XL-PRC | EES | [NAME] |  | EES Risk Mgmt | 1 | Price book not included on spreadsheet, therefore had to be downloaded after the VAR run. | Discuss with BA | yes | yes | yes | 1
2000-11-22 00:00:00 | UK RAC | UK Gas | UK |  |  |  | 1 | BA entered deal incorrectly and book needed to be recalced. | Discuss with BA | yes | yes | yes | 1
2000-11-22 00:00:00 | Risk Controls | PLAST-C2-HEDGE-PRC | Global Products |  |  |  | 3 | RisktRAC did not capture the correct positions (notional) | [NAME] reofficialized the book and the correct positions were captured by RisktRAC.  The BA calced and officialized as required. | yes | yes | no | 1
2000-11-22 00:00:00 | Risk Controls | PLAST-C3-HEDGE-PRC | Global Products |  |  |  | 3 | RisktRAC did not capture the correct positions (notional) | [NAME] reofficialized the book and the correct positions were captured by RisktRAC.  The BA calced and officialized as required. | yes | yes | no | 1
2000-11-22 00:00:00 | Risk Controls | RLL-XL-PRC | Global Products |  |  |  | 1 | Spreadsheet was not fully updated to include positions to 2003 | [NAME] made the correction on the spreadsheet, which was reofficialized and downloaded to RisktRAC | yes | yes | yes | 1
Total errors for week |  | 28
2000-11-21 00:00:00 | Risk Controls | EPMI-ST-CA-PRC | West power | [NAME] | [NAME] Richter |  | 1 | Enpower issue - ba did officialize, but desk did not show up for Risk Controls. | [NAME], [NAME] and [NAME] are working on the problem. | yes | yes | yes | 1
2000-11-21 00:00:00 | Risk Controls | EPMI-ST-NW-PRC | West power | [NAME] | [NAME] |  | 1 | Enpower issue - ba did officialize, but desk did not show up for Risk Controls. | [NAME], [NAME] and [NAME] are working on the problem. | yes | yes | yes | 1
2000-11-21 00:00:00 | Risk Controls | EPMI-ST-PLT-PRC | West power | [NAME] | [NAME] |  | 1 | Enpower issue - ba did officialize, but desk did not show up for Risk Controls. | [NAME], [NAME] and [NAME] are working on the problem. | yes | yes | yes | 1
2000-11-21 00:00:00 | Risk Controls | EPMI-ST-SW-PRC | West power | [NAME] | [NAME]/Mark Fischer |  | 1 | Enpower issue - ba did officialize, but desk did not show up for Risk Controls. | [NAME], [NAME] and [NAME] are working on the problem. | yes | yes | yes | 1
2000-11-21 00:00:00 | Risk Controls | FT-CAND-PWR-PRC | US GAS | ? | ? | Canada | 1 | The Canadian gas and power books are officialized and then e-mailed to the US gas desk who is responsible for uploading them.  This spreadsheet did not get fully uploaded. | Move process to Canada | yes | yes | yes | 1
2000-11-21 00:00:00 | UK RAC | UK & Continental Gas | UK |  |  |  | 3 | reval did not work properly | ? | yes | yes | yes | ?
2000-11-21 00:00:00 | UK RAC | Nordic Power | UK |  |  |  | 3 | Feeds were slow and did not make the 6am run. | Work on feed speed | yes | yes | yes | ?
2000-11-21 00:00:00 | UK RAC | UK power | UK |  |  |  | 3 | Officialization done on time, but the feeds, which worked in the test environment, do not work in the production environment. | ? | yes | yes | yes | ?
2000-11-20 00:00:00 | Risk Controls | FT-CAND-PWR-PRC | Canada power | [NAME] | [NAME] | US GAS | 1 | The Canadian gas and power books are officialized and then e-mailed to the US gas desk who is responsible for uploading them.  This spreadsheet did not get fully uploaded. | Task force needs to develop process to ensure all books have been officialized and commodity risk management needs to implement it | yes | yes | yes | 1
2000-11-20 00:00:00 | Risk Controls | INTRA-MKT4-GDL | US GAS |  |  | UK Risk Mgmt | 3 | BA officialized book but it did not resolve to a book name | IT to determine what problem is. | yes | yes | yes | 1
2000-11-20 00:00:00 | Risk Controls | UK-COAL-EURO-PRC | COAL |  |  | US IT | 3 | it appears [NAME] was marked official.  However, the translation to ERMS did not include this book. | [NAME] said sometimes Port Calc can lock a  particular post id and someone can do this. Therefore, MetaCalc can not officialize. | yes | yes | yes | 1
2000-11-20 00:00:00 | UK RAC | European Power | UK |  |  | UK Risk Mgmt/IT | 3 | The [NAME] valuation failed 4 X as a result of IT problems and resultted in missing the deadline. | Work on feed speed - since feed is consistently taking longer, should deadline to submit feed be earlier? | yes | yes | yes | 1
2000-11-20 00:00:00 | UK RAC | Nordic Power | UK |  |  | UK Risk Mgmt/IT | 3 | Feeds were not in by 6am cutoff time, but book was officialized before deadline (11am London time) | Work on feed speed - since feed is consistently taking longer, should deadline to submit feed be earlier? | yes | yes | yes | 1
2000-11-20 00:00:00 | UK RAC | UK Power | UK |  |  | UK Risk Mgmt | 1 | On the UK power book there was a (GBP 30) mil topside adjustment which does not feed into credit. The GBP 30 mil is due to PD deal E000535 peer ID 41957 being valued in EnPower when it was supposed to be excluded from the MTM. Officialization was done on time. | Determine how to eliminate top side adjustments | yes | yes | yes | 1
2000-11-20 00:00:00 | UK RAC | UK Power | UK |  |  | UK Risk Mgmt | 1 | BA forgot to officialize | Task force needs to develop process to ensure all books have been officialized and commodity risk management needs to implement it | yes | yes | yes | 1
2000-11-17 00:00:00 | Risk Controls | FT-CAND-EGSC-BC-PRC | Canada gas | [NAME] | [NAME] | US GAS | 1 | The Canadian gas and power books are officialized and then e-mailed to the US gas desk who is responsible for uploading them.  This spreadsheet did not get fully uploaded. | Task force needs to develop process to ensure all books have been officialized and commodity risk management needs to implement it | yes | yes | yes | 1
2000-11-17 00:00:00 | Risk Controls | OIL-NG-HDG-CAB-GDL | Gas | [NAME] | [NAME] | NA | 1 | BA forgot to officialize (JL's book which all positions are done with desk so no credit implications) | Task force needs to develop process to ensure all books have been officialized and commodity risk management needs to implement it | yes | no | yes | 1
2000-11-17 00:00:00 | Risk Controls | PLANT-EP-BOOKS | Power | NA |  | [NAME] | 3 | Why did this book show up on the risktrac list? | Determine why showed up on list | yes | yes | yes | 1
2000-11-17 00:00:00 | UK RAC | Power | Power 99 | NA | NA | UK IT | 3 | Power 99 failed - enpower will be live tomorrow to replace power 99 | nothing | yes | yes | yes | 0
2000-11-16 00:00:00 | Risk Controls | EPMI-LT-NW-EXT | Power | [NAME] | [NAME] | task force | 1 | Enpower issue - ba did officialize, but commodity codes did not show up. | Per [NAME], he could not diagnose the problem.   He will investigate it further if the problem recurs in the near future | yes | yes | yes | 1
2000-11-16 00:00:00 | Risk Controls | EPMI-LT-SW-EXT | Power | [NAME] | [NAME] | task force | 1 | Enpower issue - ba did officialize, but commodity codes did not show up. | Per [NAME], he could not diagnose the problem.   He will investigate it further if the problem recurs in the near future | yes | yes | yes | 1
2000-11-16 00:00:00 | Risk Controls | EPMI-ST-SW-EXT | Power | [NAME]/Mark Fischer | [NAME] | task force | 1 | Enpower issue - ba did officialize, but commodity codes did not show up. | Per [NAME], he could not diagnose the problem.   He will investigate it further if the problem recurs in the near future | yes | yes | yes | 1
2000-11-16 00:00:00 | Risk Controls | PLANT-EP-BOOKS (risktrac book name) | Power |  |  | task force | 1 | Enpower issue - ba did officialize, but commodity codes did not show up. | ? | yes | yes | yes | 1
2000-11-16 00:00:00 | IT | All but metals and cont. power | UK |  |  | IT | 3 | Feeds were not in by 6am cutoff time. | Work on feed speed | yes | yes | yes | 1
2000-11-15 00:00:00 | Risk Controls | EBS - bandwidth exotic spreadsheet | EBS - bandwidth | [NAME] |  | Risk management | 1 | There was a new spreadsheet format rolled out and the new format does not allow certain things that the old format did (ie deals now need to be in the appropriate sequence, counterparty errors).  EBS was not informed of the switch to new feeds | IT and risk management to determine appropriate format of spreadsheets.  Also this did not come out on Risk Controls error log. | yes | yes | yes | 0
2000-11-15 00:00:00 | Risk Controls | Advertising exotic spreadsheet | Advertising | [NAME] |  | Risk management | 1 | There was a new spreadsheet format rolled out and the new format does not allow certain things that the old format did (ie deals now need to be in the appropriate sequence, counterparty errors).  EBS was not informed of the switch to new feeds | IT and risk management to determine appropriate format of spreadsheets.  Also this did not come out on Risk Controls error log. | yes | yes | yes | 0
2000-11-15 00:00:00 | RAC | several power books (previously accrual) | Power | [NAME] |  | Risk mgmt/ risk controls | 3 | changes made to RiskTrac to move two  gas books from accrual to MTM were not initially effective | Figure out why not caught on morn. Report, figure out what the problem was with the change | yes | yes | yes | 2
2000-11-15 00:00:00 | IT | several UK books | several |  |  | IT | 3 | UK Gas & metals  not started, UK power, in process | Feeds slow or not started | yes | yes | yes | 1
Total errors for week |  | 10
2000-11-14 00:00:00 | UK RAC | Continental Power | UK |  |  | UK IT | 3 | The book calcs came across incorrectly 2X. | IT to figure out why, fix problem. | yes | yes | no | 0
2000-11-14 00:00:00 | IT | All but UK GAS and Continental GAS | UK |  |  |  | 3 | Not in on time (6am) - feed coming across, but take a long time. | IT working on change to feeds | yes | yes | yes | 0
2000-11-14 00:00:00 | Risk Controls | UK-COAL-BUNK-PRC | Coal | [NAME] |  | Risk Controls/ IT | 1 | The book was changed in RisTrac but not ERMS so the attributes did not match. | [NAME] need to get ERMS and RiskTrac matched. | yes | no | no | 0 (done)
2000-11-10 00:00:00 | Risk Controls | FT-NW-XL-OPT-BAS | US Gas | [NAME] (consolidation level person is [NAME]) | [NAME] | IT | 1 | Spreadsheets had 98 contracts on them (however net contracts of 2 only).  The gas benchmark person (gas consolidation group) was not able to upload these spreadsheets.  They only know about this the next day.  This type of thing happens when there is something in the spreadsheet that shouldn't be (an extra comma etc). | Discussed with Ramesh - until the roll out happens (due to happen in the next couple weeks) there is no way to change this.  The BA's need to be extremely accurate and precise when dealing with the current spreadsheets. | no (too small) | no (too small) | no (too small) | 0
2000-11-10 00:00:00 | Risk Controls | FT-NW-XL-OPT-PRC | US Gas | [NAME] (consolidation level person is [NAME]) | [NAME] |  | 1 | Spreadsheets had 98 contracts on them (however net contracts of 2 only).  The gas benchmark person (gas consolidation group) was not able to upload these spreadsheets.  They only know about this the next day.  This type of thing happens when there is something in the spreadsheet that shouldn't be (an extra comma etc). | Discussed with Ramesh - until the roll out happens (due to happen in the next couple weeks) there is no way to change this.  The BA's need to be extremely accurate and precise when dealing with the current spreadsheets. | no (too small) | no (too small) | no (too small) | 0
2000-11-09 00:00:00 | IT | Nordic power | London |  |  | [NAME] | 3 | Nordic Power was not in before 6am. | New feeds should clear this issue (update 11/13 - new gas feed halted, concentrating on Enpower.  Much improved - 95% of Enpower tieing out). | yes | yes | yes | 0
2000-11-09 00:00:00 | [NAME] (RAC) | London test feeds into RiskTrac | UK, Continental Gas |  |  | [NAME] | 3 | The vol curve goes to 2002 but positions go to 2005.  Curve needs to be extended.  Vol curves are being incorrectly loaded into the spreadsheet feeds. | 1) Extend vol curves, 2) roll volumes correctly (according to front month) | yes | yes | ? | 0 (done)
2000-11-09 00:00:00 | [NAME] (RAC) | London test feeds into RiskTrac | UK, Continental Gas |  |  | IT | 3 | The test feeds did not all work properly (production feed data wrong). | IT to work on obtaining proper production feeds. | ? | ? | ? | 1
2000-11-09 00:00:00 | Risk Controls | FINANCIAL-AFF-PRC (ERMS) | FX/INTEREST RATES | [NAME] | Pushcar Shahi | IT | 3 | Books were shown as officialized to FX/Int rate group, but did not show as officialized to [NAME] | These books are duplicates of the Infinity books and are used only to get information to the settlements department.  Infinity feeds VAR, Credit, and cash flows. These books are only officialized because ERMS requires them to be.  To do's - 1) check to ensure that no duplicate information is coming in from Infinity and ERMS (as these are usually officialized) - checked no duplicate info, 2) determine if there is a way that these books do not have to be officialized (to save system resources) - per Ramesh server resource not an issue for these books, and 3) determine why this problem happened and if it could happen to other ERMS books that are required to be officialized - could be attributes don't translate or 1 post id gives 2 books or 1 book gives 2 post id's | no | no | no | 0 (done)
2000-11-09 00:00:00 | Risk Controls | FINANCIAL-EM-PRC (ERMS) | FX/INTEREST RATES | [NAME] | Pushcar Shahi | IT
2000-11-09 00:00:00 | Risk Controls | FINANCIAL-PROP-PRC (ERMS) | FX/INTEREST RATES | [NAME] | Pushcar Shahi | IT
2000-11-09 00:00:00 | Risk Controls | FINANCIAL-TN10-PRC (ERMS) | FX/INTEREST RATES | [NAME] | Pushcar Shahi | IT
2000-11-09 00:00:00 | Risk Controls | FINANCIAL-TN5-PRC (ERMS) | FX/INTEREST RATES | [NAME] | Pushcar Shahi | IT
2000-11-08 00:00:00 | Risk Controls | EES-EST-FWD-XL-PRC | EES | [NAME] | Charles Decker & Suneet Shorma | IT (has been fixed) | 2 | problem with upload of spreadsheets (Burton’s computer was being fixed and the fix destroyed some upload capability) | Get [NAME]'s computer fixed, process needs to be changed:  spreadsheets to upload to a file server | yes | yes | no | 1
2000-11-08 00:00:00 | Risk Controls | EES-WST-FWD-XL-PRC | EES | [NAME] | [NAME] Bresnan | IT (has been fixed)
2000-11-08 00:00:00 | Risk Controls | EI-ARG-PWR-IDX | Argentina- power | [NAME] | [NAME] | IT (has been fixed)
2000-11-08 00:00:00 | Risk Controls | EI-ARG-PWR-PRC | Argentina - power | [NAME] | [NAME] | IT (has been fixed)
2000-11-08 00:00:00 | Risk Controls | EI-BRAZIL-PWR-PRC | Brazil - power | [NAME] | [NAME] | IT (has been fixed)
2000-11-08 00:00:00 | Risk Controls | EI-SC-GASLX-PRC | Argentina - gas | [NAME] | Roldofo Freyre | IT (has been fixed)
2000-11-08 00:00:00 | Risk Controls | EI-SC-XL-PRC | Argentina - power | [NAME] | [NAME] | IT (has been fixed)
2000-11-08 00:00:00 | Risk Controls | MG-AGRI-COCOA-PRC | Metals | [NAME] | [NAME] | IT (has been fixed)
Total errors for week |  | 33
2000-11-07 00:00:00 | Risk Controls |  | All | US | Houston | Credit | 4 | Credit issue | Need to check to make sure daily update from GCP to test is being completed so CAS and [NAME] will be OK.
2000-11-07 00:00:00 | Risk Controls |  | Gas | UK | London | IT/ Energy Ops | 3 | system problems | Due to 11/6 problems with UK Gas the data will be officialized today and sent across but will not be officialized until Saturday 11/11/00.
2000-11-07 00:00:00 | Risk Controls |  | Liquids | US | Houston | Energy Ops | 1 | incorrect data | Curve not loaded correctly.
2000-11-07 00:00:00 | Risk Controls |  | Liquids | UK | London | Energy Ops | 4 | Cash Flow Issues | J. Block data did not come across correctly. [NAME] is discussing with London. Note: Book has been changed to remove "take or pay"  so cash flow would look different.
2000-11-07 00:00:00 | Risk Controls |  | Power | UK | London | IT/ Energy Ops | 3 | system problems | Books officialized by 5 AM but slow feed.
2000-11-06 00:00:00 | Risk Controls |  | Gas | UK | London | IT/ Energy Ops | 3 | system problems | MTM fell over so books re-run and curves were wrong. Problem on SQL server. No valuation 11/6 DPR had to be an estimate.
2000-11-06 00:00:00 | Risk Controls |  | Gas | UK | London | IT/ Energy Ops | 3 | system problems | Received London's 11/2 data again due to data in London was corrupted and London had to restart system.
2000-11-06 00:00:00 | Risk Controls |  | Liquids | US | Houston | Energy Ops | 1 | incorrect data | Rerun Liquids Var because PHYOil2-Index and PhyOil-Index (crude) book was in the ERMS but should not have been due to position was also captured in the RLL_Epx_Pos spreadsheet. [NAME] needed to be re-run because numbers in credit are wrong and will need to be re-run
2000-11-06 00:00:00 | Risk Controls |  | Power | UK | London | IT/ Energy Ops | 3 | system problems | Books officialized by 3 AM but slow feed so books late coming across. Curves came in but no positions.
2000-11-06 00:00:00 | Risk Controls |  | Power | UK Nordic | London | IT/ Energy Ops | 3 | system problems | Macros and processors crashed so position files late.
2000-11-03 00:00:00 | IT |  | All | UK | London | IT/ Energy Ops | 3 | system problems | Feed problem all books officialized but not feed across.
2000-11-03 00:00:00 | IT |  | Liquids | UK | London | Energy Ops | 1 | curve pub code not tyed correctly | Liquids Var needed rerun because curve was not loaded correctly | yes
2000-11-03 00:00:00 | Risk Controls |  | Power | Canadian | Calgary | Energy Ops | 1 | book not officialized | Canada-Pwrwest-Prc book not officialized | yes
2000-11-02 00:00:00 | Risk Controls |  | Gas | US | Houston | Energy Ops | 1 | book not officialized | FT-CAND-EGSC-A-Prc book not officialized
2000-11-02 00:00:00 | Risk Controls |  | Gas | US | Houston | Energy Ops | 1 | book not officialized | FT-CAND-EGSC-A-Prc book not officialized
2000-11-02 00:00:00 | Risk Controls |  | Gas | UK | London | IT/ Energy Ops | 3 | system problems | data not in because feed is slow
2000-11-02 00:00:00 | Risk Controls | DABHOL-HO-AFF-IDX | Liquids | UK | London | Energy Ops | 1 | book not officialized | Affiliate book - BA did not know that book should be officialized
2000-11-02 00:00:00 | Risk Controls |  | merchant | US | Houston | IT/ Energy Ops | 3 | system problems | problem with Reuters Issues and the feed
2000-11-02 00:00:00 | Risk Controls |  | merchant | US | Houston | IT/ Energy Ops | 3 | system problems | CY-Explor-Bas book problem between medicalc and portcalc
2000-11-02 00:00:00 | Risk Controls |  | merchant | US | Houston | IT/ Energy Ops | 3 | system problems | CY-Explor-Prc book problem between medicalc and portcalc
2000-11-02 00:00:00 | Risk Controls |  | merchant | US | Houston | IT/ Energy Ops | 3 | system problems | EQ-Coal-East-Prc book problem between Metacalc and Portcalc
2000-11-02 00:00:00 | Risk Controls |  | merchant | US | Houston | IT/ Energy Ops | 3 | system problems | EQ-Coal-Jupiter-Prc book problem between Metacalc and Portcalc
2000-11-02 00:00:00 | Risk Controls |  | Merchant | US | Houston | IT/ Energy Ops | 3 | system problems | Equity-Cgas-Bas book problem between Metacalc and Portcalc
2000-11-02 00:00:00 | Risk Controls |  | Merchant | US | Houston | IT/ Energy Ops | 3 | system problems | Equity-CGAS-Prc book problem between Metacalc and Portcalc
2000-11-02 00:00:00 | Risk Controls |  | Merchant | US | Houston | IT/ Energy Ops | 3 | system problems | Equity-Mariner-Bas book problem between Metacalc and Portcalc
2000-11-02 00:00:00 | Risk Controls |  | Merchant | US | Houston | IT/ Energy Ops | 3 | system problems | Equity-Mariner-Prc book problem between Metacalc and Portcalc
2000-11-02 00:00:00 | Risk Controls |  | Power | UK | London | IT/ Energy Ops | 3 | system problems | data not in because feed is slow
2000-11-01 00:00:00 | Risk Controls |  | Gas | US | Houston | Energy Ops | 1 | book not officialized | FT-CAND-EGSC-A-Prc book not officialized
2000-11-01 00:00:00 | Risk Controls |  | Gas | US | Houston | Energy Ops | 1 | book not officialized | FT-CAND-EGSC-A-Prc book not officialized
2000-11-01 00:00:00 | Risk Controls |  | Liquids | US | Houston | IT/ Energy Ops | 3 | system problems | problem with Reuters Issues and the feed
2000-11-01 00:00:00 | Risk Controls |  | Power | UK | London | IT/ Energy Ops | 4 | system problems | EU-PWR-Bilateral book came across at 5 AM but JP received at 6 AM. WHY?
2000-11-01 00:00:00 | Risk Controls |  | Steel | US | Houston | Energy Ops | 1 | book not officialized | Steel-SCRC-Prc book not officialized - new BA | yes
2000-11-01 00:00:00 | IT |  | All | US | Houston | IT/ Energy Ops | 4 | system problems | Rerun of Var and Port Calc in morning is causing problems