Message-ID: <32305994.1075851694736.JavaMail.evans@thyme> Date: Wed, 29 Nov 2000 00:46:00 -0800 (PST) From: v.weldon@enron.com To: loftus.fitzwater@enron.com Subject: Chicago Temps Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-From: V Charles Weldon X-To: Loftus Fitzwater X-cc: X-bcc: X-Folder: \Charles_Wheldon_Nov2001\Notes Folders\Sent X-Origin: WHELDON-C X-FileName: vweldon.nsf 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