Enron email

Algorithmic Indexing

29 Nov 2000, 08:46 UTC

Chicago Temps

From
V Charles Weldon v.weldon@enron.com
To
Loftus Fitzwater
Date
Wed, 29 Nov 2000 00:46:00 -0800 (PST)
Loftus,

Here's the file.  If you break the date column up into three separate columns 
for month, day, and year then you can use subtotals and/or pivot tables to 
analyze the data a little more quickly and dynamically.  For example, you 
might want to look at the extremes or averages for any particular month or 
year or whatever.  I c an help you do this if you want.    Remember that this 
is a very limited data set statistically speaking, especially considering 
that the last 3 winters were far above normal.  If you want to investigate 
what the possible extreme scenarios are based on past history then I can get 
you the data for many decades further back if wish.  Just let mw know.

Thanks,

Charlie