Message-ID: <4360443.1075853071375.JavaMail.evans@thyme>
Date: Thu, 31 May 2001 22:29:00 -0700 (PDT)
From: lynn.blair@enron.com
To: dale.ratliff@enron.com
Subject: 
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-From: Lynn Blair
X-To: Dale Ratliff <Dale Ratliff/OTS/Enron@ENRON>
X-cc: 
X-bcc: 
X-Folder: \LBLAIR (Non-Privileged)\Blair, Lynn\Sent Items
X-Origin: Blair-L
X-FileName: LBLAIR (Non-Privileged).pst

Dale, does this help any?  Thanks. Lynn
---------------------- Forwarded by Lynn Blair/ET&S/Enron on 05/31/2001 07:29 PM ---------------------------
From:	Don Powell/ENRON@enronxgate on 05/22/2001 01:17 PM
To:	Angela Sayegh/OTS/Enron@ENRON
cc:	Lynn Blair/ET&S/Enron@ENRON, John Buchanan/ET&S/Enron@ENRON, Alice Johnson/ET&S/Enron@ENRON, Gary Spraggins/ET&S/Enron@ENRON, Dale Ratliff/ENRON@enronXgate, Steven January/ET&S/Enron@ENRON 

Subject:	

Here's what we have so far on the code to be incorporate into the SCADA Excel Addin.  I'll come up today at 3:00 to discuss it.

1.  NNG CAS operational capacity

select 
 a.nb_poi,
 b.dt_date,
 qt_operational_cap_mcf = sum(a.qt_operational_cap_mcf)

from nngadhoc..cas_poi_oper_cap a,
 nngadhoc..tms_date b

where nb_cmpy = 179
 and nb_poi = 129
 and b.dt_date = convert (char(10), getdate(), 111)
-- and id_poi_role = 'R' ???
 and b.dt_date between dt_effective and dt_termination

group by 
 a.nb_poi,
 b.dt_date


2.  NNG Current month imbalance

	Alice in working on this one.


3.  NNG Accum. month imbalance

	Alice in working on this one.


4. NNG Storage previous day / current day into.

	Alice in working on this one.