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.