Message-ID: <14820914.1075840179501.JavaMail.evans@thyme> Date: Wed, 6 Feb 2002 06:47:54 -0800 (PST) From: ganapathy.ramesh@enron.com To: kam.keiser@enron.com Subject: RE: Gas Books - found some small duplicates in the spreadsheet Cc: virendra.patel@enron.com, andrew.champion@enron.com, john.valdes@enron.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Bcc: virendra.patel@enron.com, andrew.champion@enron.com, john.valdes@enron.com X-From: Ramesh, Ganapathy X-To: Keiser, Kam X-cc: Patel, Virendra , Champion, Andrew , Valdes, John X-bcc: X-Folder: \ExMerge - Keiser, Kam\Inbox X-Origin: KEISER-K X-FileName: kam keiser 7-11-02.PST Kam, We created the real portfolios of all these books as well. We are waiting on the hierarchy from Risk Controls. If that is delayed, then we will simply dump all the real portfolios under a root portfolio for purposes of testing potential exposure, credit reserve and VaR. Regards, Ramesh -----Original Message----- From: Keiser, Kam Sent: Wednesday, February 06, 2002 7:32 AM To: Champion, Andrew; Valdes, John Cc: Ramesh, Ganapathy; Patel, Virendra Subject: RE: Gas Books - found some small duplicates in the spreadsheet Thanks for making those changes. Let us know when we are ready to start setting up the hierarchy. Thanks Kam -----Original Message----- From: Champion, Andrew Sent: Tuesday, February 05, 2002 9:13 PM To: Keiser, Kam; Valdes, John Cc: Ramesh, Ganapathy; Patel, Virendra Subject: Gas Books - found some small duplicates in the spreadsheet Kam, John, we found a few book_id name issues while trying to batch-load the books. We were able to figure out the issues ourselves, but for your reference here are the changes we made: FB-EXECUTIVE M F P FIN US FINANCIAL ERMS emglaugh FB-EXECUTIVE M F D FIN US FINANCIAL ERMS emglaugh FB-EXECUTIVE M F I FIN US FINANCIAL ERMS emglaugh FB-EXECUTIVE M F M FIN US FINANCIAL ERMS emglaugh FB-EXECUTIVE M F Y FIN US FINANCIAL ERMS emglaugh Note all 5 books were labeled as 'FB-EXECUTIVE'. We instead named them FB-EXECUTIVE-PRC FB-EXECUTIVE-BAS FB-EXECUTIVE-IDX FB-EXECUTIVE-GDM FB-EXECUTIVE-GDY Also, we found these two books that had the same book ID: FB-WEST1-GDM M F M WEST1 US GAS WEST ERMS plove FB-WEST1-GDM M F M WEST10 US GAS WEST ERMS plove Note that the second book should be named 'FB-WEST10-GDM', based on the WEST10 Region Code. We fixed that one as well. Please update your spreadsheet, and let us know if we need to discuss in the morning. The next step is the hierarchy, which we should receive from Stephanie or Debbie in the morning. Thanks. Andrew x57534