Per your request for year-to-date numbers: here's an example of what I could include in the daily EOL summary. Let me know if this is helpful for you, and if you'd like it included on the graph sheet. I think it might be too tight to fit on the page as it is, but there's no reason why we can't generate a two-page report. As long as we're going in that direction, is ther any other data you'd like to see in graph form?
Answer: Year-to-Date Deal Summary
Here is an email: what is happening? hope all is well, just got back from a week of skiing with Maco in Tahoe. Was great, but did my gambling suck. Joe
What is a potential subject line for this email?
A: You still there?
Q: Debbie- I have attached two Excel files representing the P&L by counterparty for all deals in the East and West Bankruptcy portfolios. Please do not hesitate to call if you have any questions or if you need any additional information. Thanks!
Propose a subject line
A: East and West Bankruptcy Portfolios
IN: Last Friday I was trying to get into my account online but couldn't remember my password. After three unsuccesful attempts the system locked me out. I know my password now, but I am still locked out. Please help.

Generate a subject line.

OUT: Access
IN: This is an email
Please begin to develop a list of issues (your top ten) that we need to be worrying about in ETS for 2002. We will jointly develop your lists into a larger list for ETS. I would like to think you caould have this done by the end of next week.

What is the subject?

OUT: 2002 Issues
Paul, I have been doing some analysis and have found a few problems that should be looked at. 1. The number Mother data is pulling for Zone P is wrong. The pointer for the data can be found on the SQL worksheet the expression is: avg(decode(prc.power_reference_period_cd,'DAYAHEAD', decode(pl.location_name,'PJM',price_amt))) PJM_DA, and avg(decode(prc.power_reference_period_cd,'HOURLY', decode(pl.location_name,'PJM',price_amt))) PJM_RT, I have looked at the PJM and NY prices and am unable to figure out where the number is coming from. 2. The other 24hr desk evidently has been told that the PJM night shift is to prep the PJM and Nepool portions of the shift notes. That is fine with me. I wrote a macro to pull, format and print the Nepool information. The PJM information is not available on the website. The East power portal has something. I think it does some kind of Op Sum pull at some unknown interval. The problem is the information is not accurate. Rob Bensen's frustration with this bad information is the main reason the other 24hr desk doesn't want any part of the reporting. 2.a All data points are different than the one hour averages calculated in edata. This makes me doubt that opsum is the source, as edata also pulls from opsum. 2.b When all interfaces and hubs are printing the same, the prices shown differ in the same hour on the website. I have no idea where this information is coming from but it is not right. If the correct data can be found there is an application that pulls from the database at "M:\Electrichour\PJM AVE\PJMSummary.exe". If they could fix this app I would care less about the web site. If they do not want to fix the app I can write a macro to pull the same data from the mother data template. I don't really care how I get the data, I just need to get yesterday's PJM for the shift note. In other news, if you are trading some of the regular products, are you following the DA-RT physical moves? If we do man the 24hr desk (even if Bryce is the day guy) we could cover the DA-RT physical. Having it part of the 24hr desk would seem to make sense because the evening load and more up to date weather forecasts could be used when entering the NY side in the early morning. I only mention this if you are finding yourself too busy trading PJM to spend the same amount of time on the analysis. It is certainly easier to do uninterrupted analysis on the back shift. Just a thought. Thanks,
Answer:
Data Problems