|
|
Enron Mail |
I have excluded annuities.
-----Original Message----- From: Symes, Kate Sent: Friday, December 07, 2001 9:19 AM To: Amador, Susan Cc: Williams III, Bill Subject: RE: Spreadsheet. Susan - I just tested the schedule pull again and found one more deal type we need to exclude - ANNUITIES. The download pulls in purchase and sale annuities as regular forward purchases and sales, recognizing the average price as the total annuity price, which is, obviously, wrong. Anyway, when you get a chance could you exclude these deals from the query as well? Thanks, Kate -----Original Message----- From: Amador, Susan Sent: Thursday, December 06, 2001 11:10 AM To: Symes, Kate Subject: RE: Spreadsheet. << File: SchedulePull.xls << Thanks. Perfect timing, Kate. Check the on and off peak. Working on the archive schedule version - it's far too slow right now. -----Original Message----- From: Symes, Kate Sent: Thursday, December 06, 2001 11:06 AM To: Amador, Susan Subject: RE: Spreadsheet. Susan - This looks great. Now we've just got to tweak the on-peak and off-peak averages, and I think we'll be set. (Hopefully someone will get to use this someday!) Thanks for your help, Kate -----Original Message----- From: Amador, Susan Sent: Thursday, December 06, 2001 8:41 AM To: Symes, Kate Subject: FW: Spreadsheet. HI Kate! I changed the query for a couple of things. It was averaging per deal rather than per MW. The way a transmission schedule was excluded. I also excluded 0 price and 0 volume schedules (leet me know if this is correct). Note: still testing the code for the on peak and off peak average - so just review the hourly ones. << File: SchedulePull.xls << -----Original Message----- From: Symes, Kate Sent: Wednesday, December 05, 2001 9:48 AM To: Amador, Susan Cc: Williams III, Bill Subject: FW: Spreadsheet. Susan - This is the last thing Susmitha sent me. If you look two e-mails down, you'll see the parameters I sent to her. The spreadsheet is still coming up with some weird numbers - all are much, much lower than actual average prices for these days. Would you mind taking a look at the query to see if all the appropriate deals are being excluded? Also, the spreadsheet doesn't pull in anything for the first half of November (i.e. when I try to download av. prices for 11/1/01, nothing comes up.) Let me know when you get a chance to look at this. Thanks a lot! Kate -----Original Message----- From: Nalluri, Susmitha Sent: Thursday, November 29, 2001 3:26 PM To: Symes, Kate Subject: RE: Spreadsheet. Kate:Please look at this.I think it meets the requirements stated below. Thanks, Susmitha. << File: SchedulePull.xls << -----Original Message----- From: Symes, Kate Sent: Thursday, November 29, 2001 2:29 PM To: Nalluri, Susmitha Cc: Williams III, Bill Subject: FW: Spreadsheet. Susmitha - Bill sent me this spreadsheet to look over, and the prices it pulls look much too low to be an accurate average of our forward purchases and sales. My thought is that certain deals are being pulled into the query that should not be included. The deals in Enpower that need to be excluded from this query are: 1. Transmission - All deals under this heading in Enpower must be excluded 2. Forward - All purchases and sales to counterparty "California Imbalance" must be excluded 3. Buy-Resale - All deals with counterparty "EPMI California Pool" must be excluded Please let me know if you have any questions about this, or if you'd like me to show you specific deals in Enpower to illustrate this. Thanks, Kate Symes Real Time Trading Support Office/503-464-7744 Cell/503-819-2181 Fax/503-464-7996 -----Original Message----- From: Williams III, Bill Sent: Thursday, November 29, 2001 2:00 PM To: Symes, Kate Subject: FW: Spreadsheet. -----Original Message----- From: Nalluri, Susmitha Sent: Thursday, November 29, 2001 9:34 AM To: Williams III, Bill; Amador, Susan Subject: Spreadsheet. Please inform me of any changes. Thanks, Susmitha. << File: SchedulePull.xls << -----Original Message----- From: Williams III, Bill Sent: Friday, November 23, 2001 1:16 PM To: Amador, Susan Cc: Symes, Kate; Nalluri, Susmitha; Poston, David Subject: RE: spreadsheets Susan, Thank you. This looks good. To answer some of your questions, price is per mw, not per deal. Transmission deals, EpmiCalPool deals, and sales or purchases from the counterparty California Imbalance in Enpower need to be excluded. Thanks, Bill -----Original Message----- From: Amador, Susan Sent: Wednesday, November 21, 2001 2:07 PM To: Williams III, Bill; Symes, Kate Cc: Nalluri, Susmitha; Poston, David; Chen, Lei Subject: spreadsheets Bill, Here's an outline of what we talked about for the average price spreadsheet: Pull deals for WHourly at Mid-Columbia, WSCC_N, NP15, SP15, and (Palo Verde +) WSCC_S In a tabular format display: Average price from the schedules for buys and sells for each hour in each region (i.e. Mid-Columbia, WSCC_N, etc.) Underneath the table display: On Peak average Off Peak average for later: (i.e. next version) sort by groups: 24inc, EOL, EPEC For clarification: Average price is per MW not per deal? I've asked Susmitha Nalluri to work on this for you. She sits 2 desks down from me and works on the VMS team. She has experience with spreadsheets, however she is not yet familiar with the EnPower view of the database. I have given her a query to give her a jumpstart on pulling the data data you need from EnPower. She and I have also met to go over where the data is being pulled from. In my abscence she can go to Lei, Pete, Matt or David about questions regarding the EnPower Data. I told her to feel free to ask you or Kate any questions. I brought her down to meet you and Kate but did not realize you both (as well as most people) had left around lunchtime. Kate, I told her you would be bringing her more information on the Dow Jones sheet. I forwarded Susmitha our earlier emails about it. Susan Amador 503.464.8681 office 503.703.6714 cell
|