Spreadsheet: sally_beck__36213__05_30_01 Daily Log
Sheet: Sheet1

LOG OF DAILY 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 | COMMODITY/OFFICE | PARTY | CLASS | PROBLEM | ACTION PLAN | RERUN? | AFFECTED? | FLOWS? | (DATE)
2001-05-30 00:00:00 | INTRA-TEXAS-PHY | US Gas Texas | [NAME] | F | Book was replaced by ENA-IM-CARTHAGE, therefore, there were no position in this book. | Need to notify Risk Controls whenever a book is made inactive. | N | N | N | Done
2001-05-29 00:00:00 | INTRA-DENVER-PRC | US Gas West | [NAME] | C | Book administrator forgot to officialize. | Manager needs to review website to ensure all post [NAME] are officialized. | N | N | N | Done
2001-05-29 00:00:00 | FT-ONT-CENTRAL-PRC | US Gas Central | [NAME] | C | Book administrator forgot to officialize. | Manager needs to review website to ensure all post [NAME] are officialized. | Y | Y | N | Done
2001-05-29 00:00:00 | Nordic Power | Nordic Power | [NAME] | D1 | Experienced problems sending their feed to RisktRac due to a failure in the overnight Nordic MTM system run. | IT is working on this issue. | N | N | N | Pending
2001-05-29 00:00:00 | EBS-ADV-PRC | US EBS | Belinda Woo | C | Book administrator forgot to officialize. | Manager needs to review website to ensure all post [NAME] are officialized. | Y | Y | N | Done
2001-05-25 00:00:00 | Eastern Books | UK Eastern | [NAME] | G | Due to power outage, officialized the 24th instead of the 28th. | N/A | N | N | N | Done
2001-05-24 00:00:00 | MG-AGRI-COCOA-PRC | Interest/ FX Group | [NAME] | C | Book administrator forgot to load spreadsheet. | Implementation of new Active/Inactive book website should help identify any unofficialized books during end of day process. | Y | Y | N | Done
2001-05-24 00:00:00 | EPMI-LT-SERC-PRC, EPMI-LT-SPP-PRC, EPMI-SE-ANALYST-PRC, EPMI-ST-SOUTHEAST-PRC, EPMI-ST-SERC-PRC, EPMI-ST-SPP-PRC | US Power East | [NAME] | C | Book administrator forgot to officialize. | Book Administrator did not utilize the active/ inactive website. | Y | Y | Y | Done
2001-05-24 00:00:00 | Eastern Books | UK Eastern | [NAME] | D1 | Problems loading current day spreadsheet as a result, 70 Bcf of hedges did not make it to RisktRac. | IT is working on this issue. | N | Y | Y | Pending
2001-05-24 00:00:00 | UK Power | UK Power | [NAME] | D1 | Database is not functioning properly. (IT issues) | Houston IT working on fixing this problem. |  |  |  | Pending
2001-05-23 00:00:00 | UK Power | UK Power | [NAME] | D1 | Curve database was full resulting in UK Power curves not fully loaded into system for MTM calculation. | IT 24 hour support group has been notified to ensure that enough space is available before curve loading is initiated. | Y | Y | Y | Done
2001-05-22 00:00:00 | UK Gas | UK Gas | [NAME] | E | PPP power curve was loaded into the curve file thus causing incorrect valuation and problems with the position files. | Waiting for an Action Plan from UK. | Y | N | N | Pending
2001-05-22 00:00:00 | Nordic Power | Nordic Power | [NAME] | D1 | File had to be re-send because of a deal that was doubled up.  File was re-sent before the first file sent completed reconciling deal and position table. | Houston IT suggested when having to re-send file, develop a test to check if first file was completed and wait 10 mins before sending the second one. | N | N | N | Pending
2001-05-21 00:00:00 | Unified Power | Power | [NAME] | D1 | Unified power system failed and had to be re-run. | Unified system personnel are monitoring the system to determine cause of the problem. | N | Y | N | Pending
2001-05-21 00:00:00 | Nordic Power | Nordic Power | [NAME] | D1 | Multiple UK files came in at the same time, therefore, the Nordic file was not able to get through. | Increase the DBA size today -05/22/01-to allow files to be sent simultaneously. | Y | Y | N | Done
2001-05-18 00:00:00 | Nordic Power | Nordic Power | [NAME] | D1 | Multiple UK files came in at the same time, therefore, the Nordic file was not able to get through. | Have the DBA increase the size to allow files to be sent simultaneously. | Y | Y | N | Pending
2001-05-17 00:00:00 | JL-SAPWR-XL-PRC | SA Power | [NAME] | C | Liquidated swaps; therefore, spreadsheet should have been officialized one more time with a zero. | Book will be officialized one last time with a zero for May 17th. | N | Y | N | Done
2001-05-16 00:00:00 | UK Power | UK Power | [NAME] | D1 | UK Power book was late as there were technical problems experienced on the PC which runs the spreadsheet officialization excel macro. | IT will try to run macro from another PC. | N | N | N | Done
2001-05-14 00:00:00 | UK Power, UK Gas, Nordic Power | UK Power, UK Gas, Nordic Power | [NAME] | D1 | VAR from RisktRac does not reconcile to the VAR from the spreadsheet file sent for DPR reporting. | Risk Control continues to report the VAR from the spreadsheet file sent from the London office. | N | N | N | Done
2001-05-14 00:00:00 | Australian Weather (GG) | Australian Weather (GG) | [NAME] | C | Book Administrator sent file with the wrong extension for 05/14. | Book Administrator will delete the old .bkp version and load jn the fresh .xls version. | N | N | N | Done
2001-05-14 00:00:00 | LUMBER-US-PRC | US Lumber | [NAME] | C | Book was not officialized, Book Administrator forgot. | Implementation of new Active/Inactive book website should help identify any unofficialized books during end of day process. | Y | Y | N | Done
2001-05-11 00:00:00 | UK Power | UK Power | [NAME] | D1 | UK Power was officialized late due to an error in running the Dove Calc application. | Procedure to be put in place so that the dates for running of the mtm are clearly stated and defined for the benefit of IT.  This will ensure that any confusion is removed as to the dates for the mtm run. | N | N | N | Done
2001-05-11 00:00:00 | Nordic Power | Nordic Power | [NAME] | D1 | The feed from London was late primarily due to an error in the running of the Nordic mtm data. | Identified and understand reason for delay/problem. If system locks again, now able to resolve it very quickly. | N | N | N | Done
2001-05-11 00:00:00 | FT-NORTHWEST-IDX | US Gas | [NAME] | C | Book was not officialized.  Book has no positions. | Book will be made inactive after tonight. (05/14/01) | N | N | N | Done
2001-05-11 00:00:00 | [NAME] | US Power East | [NAME] | C | Book was not officialized.  Book has no positions. | Book will be made inactive after tonight. (05/14/01) | N | N | N | Done
2001-05-10 00:00:00 | UK Power | UK Power | [NAME] | D1 | UK Power file loaded into Risktrac late due to a change in password on the server used to send data to Risktrac. | All files updated for new password. | N | N | N | Done
2001-05-10 00:00:00 | MG-AGRI-COCOA-PRC | US Financial | [NAME] | C | Book was not officialized. Forgot to load spreadsheet. | Implementation of new Active/Inactive book website should help identify any unofficialized books during end of day process.  Training of staff on Monday, May 14th. | Y | N | N | Done
2001-05-10 00:00:00 | FT-CAND-EGSC-C-BAS | Canada Gas | [NAME] | C | Forgot to manually overwrite the Basis book with the post ID from the Price book. | Utilization of new Active/Inactive book website should help identify any unofficialized books during end of day process. | Y | N | N | Done
2001-05-09 00:00:00 | FT-CAND-PWR-PRC, CAND-PWR-GD-GDL, CAND-PWR-PR-PRC | Canada Gas | [NAME] | C | Canadian Power trader had gas positions that  were not being captured in the AGG-ECT portfolio.  Therefore, VAR and gas positions were not correctly reported. | Short-term solution is to add gas positions to the gas bench and copy the Canadian Gas portfolio to the AGG-ECT portfolio and start officializing in US dollars.  Long-term solution is to identify and ensure that all books with positions are being captured on the respective benchmark reports and books are included in AGG-ECT. | N | N | N | Done
2001-05-09 00:00:00 | Australian Weather (GG) | Australian Weather (GG) | [NAME] | C | Book Administrator sent file with the wrong extension resulted in information not properly being converted for processing. | Additional training is required to bring Book Administrator up to speed. | N | Y | N | Done
2001-05-08 00:00:00 | Continental Power | Continental Power | [NAME] | D1 | Monday was a bank holiday and IT switched [NAME] off as they did not want the systems to run overnight.  However, it was not turned on by IT for Tuesday 8 May close of business overnight run.  Consequently, [NAME] did not run and there was no data for 8 May to be officialized by risk management.  [NAME] had to be subsequently re-run by IT during the current day and was then officialized and loaded into [NAME] at 7:35 am Houston time. | Procedure to be put in place so that the dates for running of the mtm are clearly stated and defined for the benefit of IT.  This will ensure that any confusion is removed as to the dates for the mtm run. | Y | Y | Y | Pending
2001-05-08 00:00:00 | UK Power | UK Power | [NAME] | D1 | Previous day's data was officialized as current day data not available at time of officialization.  This did not load into [NAME] until 6:05 am Houston time.  The reason previous day's data had to be officialized was due to an IT error involving the overnight curve upload procedure.  The process is automatic, but if thre are system problems as there were last night, then the process is required to be re-run manually.  The manual re-run procedure was done correctly by the 24hr IT software support team and thus the Enpower mtm did not run. | The 24hr support team is now aware of procedures to re-start mtm if overnight system fails. | N | N | N | Done
2001-05-08 00:00:00 | Nordic Power | Nordic Power | [NAME] | D1 | Nordic Power data for 8 May did not load into [NAME] until 6:13 am Houston time.  This was due to a random IT error in that some options failed to be calculated in the overnight mtm run.  Nordic risk management had to manually determine which of the book's option positions failed to be calculated and then had to manually recalculate these options before officialization could be initiated. | Waiting for an Action Plan from [NAME]. | N | N | N | Pending
2001-05-08 00:00:00 | FT-NW-XL-OPT-BAS | US Gas | [NAME] | C | Book was officialized with wrong book name on the file. | Implementation of new Active/Inactive book website should help identify any unofficialized books during end of day process. | Y | N | N | Done
2001-05-08 00:00:00 | INTRA-DENVER-PRC | US Gas | [NAME] | C | Book was officialized with the incorrect date. | Implementation of new Active/Inactive book website should help identify any unofficialized books during end of day process. | Y | N | N | Done
2001-05-07 00:00:00 | MG-AGRI-COCOA-PRC | US Financial | [NAME] | G | London Holiday; positions were not rolled by Book Administrator. | Incorporating a holiday calendar in the RisktRAC system that will roll positions from prior day whenever there is a holiday. | Y | Y | Y | Done
2001-05-07 00:00:00 | INTRA-CAND-WEST-BAS | CAD Gas | [NAME] | C | Book was not manually pulled in.  Canadian office officialized INTRA-CAND-WEST-PRC after the Houston office had already left for the night. | Canadian office will contact Houston office to notify them of late officialization in the future. | Y | Y | Y | Done
2001-05-07 00:00:00 | Eastern Books | UK Eastern | [NAME] | C | Officialized twice. | UK Risk Management group and UK IT group are trying to resolve the issue. | N | N | N | Done
2001-05-07 00:00:00 | UK Metals | UK Metals | [NAME] | D1 | No positions in these books due to problems with the file load.  [NAME] of data was too big for table to calculate. | DBA will need to increase system size to accommodate file size. | N | N | N | Done
2001-05-07 00:00:00 | Continental Gas | Continental Gas | [NAME] | C | Incorrect curve loaded. Position came in ok. | UK Risk Management group working to resolve the problem. | N | N | Y | Done
2001-05-07 00:00:00 | UK Power & UK Continental Power Books | UK Power, Continental Power | [NAME] | D1 | There was an EN-Power server issue.  Positions eventually came in. | UK Risk Management group and UK IT group are trying to resolve the issue. | N | N | N | Done
2001-05-04 00:00:00 | PWR-EA-PWCN-OPT-PRC, PWR-EA-PWNT-OPT-PRC, PWR-EAST-PWCN-PRC, PWR-EAST-PWNT-PRC, PWR-EAST-PWQJ-PRC, PWR-EAST-PWTC-PRC | US Power | [NAME] | F | Power books no longer being calc'ed and has no positions. | Need to make inactive in RisktRAC and CAS. | N | N | N | Done
2001-05-04 00:00:00 | PAPER-EUROPE-PRC | Paper | [NAME] | C | Book was not officialized.  Relatively new person in position. | Implementation of new Active/Inactive book website should help identify any unofficialized books during end of day process.  Training of staff. | Y | Y | Y | Book was reofficialized at 8 am.
2001-05-04 00:00:00 | FT-BRIDGE-SUBA-GDL | US Gas |  | C | Book was not officialized.  Relatively new person in position. | Implementation of new Active/Inactive book website should help identify any unofficialized books during end of day process.  Training of staff. | N | N | N | Done
2001-05-04 00:00:00 | EPMI-HRLY-ERCOT-PRC, EPMI-ST-WHOURLY-PRC | US Power | [NAME] | C | Book was not officialized as book is flat and contains no positions. | Implementation of new Active/Inactive book website should help identify any unofficialized books during end of day process. | N | N | N | Done
2001-05-04 00:00:00 | EPMI-ETOWN-SVC-PRC, EPMI-LTON-SVCE-PRC, PWR-GD-LT-OPTB-GDL, PWR-GD-LT-OPTB-PRC | US Power | [NAME] | C | New books.  There are no positions in these books as yet.  Books should be marked and considered active in the future. | Implementation of new Active/Inactive book website should help identify any unofficialized books during end of day process. | N | N | N | Done
2001-05-03 00:00:00 | FT-CAND-ROLLOFF-BAS, FT-CAND-ROLLOFF-IDX | US Gas | [NAME] | C | No positions in these books. | Books will be marked inactive in RiskTrac. | N | N | N | Done
2001-05-03 00:00:00 | WEATHER-NG-PRC | US Gas | [NAME] | C | Book not officialized. | Implementation of new Active/Inactive book website should help identify any unofficialized books during end of day process | Y | Y | N | Weather Risk Mgmt. Group to be trained on using Active/Inactive book website.
2001-05-02 00:00:00 | GD-MARKET-BAS, GD-MARKET-GDL, GD-MARKET-PRC, INTRA-CES-ENTGY-IDX, INTRA-CES-ENTGY-PRC, INTRA-CES-ENTGY-BAS | US Gas | [NAME] | F | Books marked as inactive need to be officialized at month-end to meet accounting liquidation requirement. | [NAME] will contact [NAME] to determine a solution to the problem. | N | N | N | Done
2001-05-02 00:00:00 | UK Gas | UKGAS | UK IT Gas | D1 | Experienced problems sending their feed.  Valuation system not working due to a change in the front end system on the gas desk. | UK IT group re-sent the file and it processed into Risktrac correctly. | N | Y | N | Done
2001-05-01 00:00:00 | LT-TRANS-CE-(BAS, GDL, IDX,PRC), LT-TRANS-WE-(BAS, GDL, IDX,PRC) | US Gas | [NAME] | C | Books were new and should have been made inactive. | Positions in Central and West books need to be rolled to books LT-TRANS-EA-(BAS, GDL, IDX,PRC) | N | N | N | Done
2001-05-01 00:00:00 | INTRA-DENVER-BAS, INTRA-DENVER-IDX | US Gas | [NAME] | C | Books not officialized. | Books will be marked inactive in RiskTrac | N | N | N | Done
2001-05-01 00:00:00 | FT-CENT-IDX | US Gas | [NAME] | C | Book not officialized. | Implementation of new Active/Inactive book website should help identify any unofficialized books during end of day process | N | Y | Y | Done
2001-05-01 00:00:00 | US-UK-ARB-02GO-PRC, US-UK-GO-ARB-PRC, US-UK-GR-ARB-GOI-PRC, US-UK-GR-HO-ARB-PRC, US-UK-GR-KE-ARB-PRC, US-UK-GR-KR-ARB-PRC, US-UK-HO-ARB-PRC, US-UK-KE-ARB-PRC, US-UK-KERO-ARB-PRC | Global Products | [NAME] | C | No more activity in these books. | Books need to be officialized with a zero position. | N | Y | N | Done
2001-05-01 00:00:00 | PWR-MG-GS-MTM-GLD | US Power | [NAME] | C | Book not officialized. | Website was utilized, but book was assigned to incorrect trading group. | Y | Y | Y | Done
2001-05-01 00:00:00 | ERAC-ERMS-XL-PRC, HGO-ERMS-XL-PRC, PROD-ERMS-XL-PRC, RLL-ERMS-XL-PRC | Global Products | [NAME] | C | Books not officialized. Book Administrator misunderstood the uploading process. | Training of staff. | Y | Y | Y | Done
2001-04-30 00:00:00 | GD-TEXAS-GDL & ST-BAMMEL-HPL-GDL | US Gas | [NAME] | C | Books not officialized. | Implementation of new Active/Inactive book website should help identify any unofficialized books during end of day process | N | Y | N | Done
2001-04-30 00:00:00 | UKGASGSA1 | UK Gas | [NAME] |  | To be determined |  |  |  |  | Done
2001-04-30 00:00:00 | FT-CAND-AB-GDL-GDL, INTRA-CAND-BC-BAS, INTRA-CAND-BC-GD-GDL, INTRA-CAND-BE-PRC, INTRA-CAN-WE-DG-DGL, FT-CAND-OP-GD-GDL | Canada | [NAME] | C | Books not officialized.  When running the exception reports, an incorrect effective date was used, resulting in the inaccurate capture of PostID's that were not officialized. | Implementation of new Active/Inactive book website should help identify any unofficialized books during end of day process | Y | Y | Y | Canada Risk Mgmt. Group to be trained on using Active/Inactive book website.
2001-04-27 00:00:00 | EBS Books | EBS US |  | D2 | Takes 1+ hour to upload books into RiskTrac. | Risk + RAC to determine if there is an easier way. | N | N | N | [NAME] and Ramesh will meet with [NAME] to discuss prioritizing file load.
2001-04-27 00:00:00 | E-TRANSIT-ACC-PRC | EBS | [NAME] | C | EBS Risk Management Group did not complete the final stage of the spreasheet validation process. | Run RiskTrac post ID report before leaving at night. | N | Y | N | Done
2001-04-27 00:00:00 | E-TRANSPORT-ACC-PR | EBS | [NAME] | C | EBS Risk Management Group did not complete the final stage of the spreadsheet validation process. | Run RiskTrac post ID report before leaving at night. | N | Y | N | Done
2001-04-27 00:00:00 | Excel format error on spreadsheet | EBS UK | Neil Tarling | C / D1 | Added extra column on spreadsheet. Did not make it to credit and [NAME] Monday's report. |  | N | Y | N | 5/1 [NAME] is corrected.  Links in spreadsheet broke.
2001-04-27 00:00:00 | INTRA-CAND-BC-BAS | Canada | [NAME] | C | Manual overide was not done by Houston Risk Management Group. | Address which group should be responsible (Jeff & Debbie). |  |  |  | Done - to remain in Houston
2001-04-27 00:00:00 | INTRA-CAND-WE-GD-GDL | Canada | [NAME] | C | Book not officialized | Implement Active/Inactive website. |  |  |  | Canada Risk Mgmt. Group to be trained on using Active/Inactive book website.
2001-04-27 00:00:00 | INTRA-CAND-WEST-BAS | Canada | [NAME] | C | Book not officialized | Implement Active/Inactive website. |  |  |  | Canada Risk Mgmt. Group to be trained on using Active/Inactive book website.
2001-04-27 00:00:00 | INTRA-CAND-WEST-PRC | Canada | [NAME] | C | Book not officialized | Implement Active/Inactive website. |  |  |  | Canada Risk Mgmt. Group to be trained on using Active/Inactive book website.
2001-04-27 00:00:00 | Gas Unify |  |  | D2 | Unify did not feed into credit (took all night instead of 5 min.). | IT to watch more closely. | N | Y | N | 5/1 Per Debbie - done.
2001-04-27 00:00:00 | UK Power | UK Power | Houston IT | D1 | UK Power feed came in late 6:20. | Server slow. | Y | Y | N | Done
2001-04-27 00:00:00 | FT-NW-XL-OPT-BAS,  FT-NWXL-OPT-PRC,  GD-NEW-XL-OPT-BAS, [NAME]-NEW-XL-OPT-PRC | US Gas | [NAME] | C | New people in group uploaded 4/26 spreadsheets when they should not have.  Credit must delete.  Credit should not be responsible for deleting data. | Training of new staff.  Reupload with 0 MTM value the 2 books with position. | N | Y | Y | 4/30 Spreadsheets reloaded
2001-04-27 00:00:00 | Misc. Books | Agricultural Books | [NAME] | C | BA officialized books for the 12th, 17th, & 18th.  Credit picked up information again. | Training of staff. | N | Y | N | Done
2001-04-26 00:00:00 | DPR Prelim vs Final | EES Gas | [NAME] | A | Park Place deal was not booked at prelim. | Ensure deals are captured same day  (Review Global Standards) | N | Y | Y | Done
2001-04-26 00:00:00 | FT-WEST-IDX | West Gas | Darron Giron | C | Books not officialized | Implementation of new Active/Inactive book website should help identify any unofficialized books during end of day process | N | Y | N | Done
2001-04-26 00:00:00 | GD-NEW-IDX | West Gas | Darron Giron | C | Books not officialized | Implementation of new Active/Inactive book website should help identify any unofficialized books during end of day process | N | Y | N | Done
4/25-26/01 | Power Unify |  |  | D2 | Unify did not feed into credit (took all night instead of 5 min.).  Start up of sequel server 2000 was the cause. | IT to watch more closely. | N | Y | N | 5/1 Per Debbie - done.
2001-04-26 00:00:00 | INTRA-CAND-BC-BAS & INTRA-CAND-BC-PRC | Canada |  | D2 | They have the same credit position for two different days.  Credit must go in and delete one of them.  Credit should not be responsible for deleting data. |  | N | Y | N | Canada book restructing project.