Enron email

Algorithmic Indexing

1 May 2001, 19:06 UTC

Monthly Avg and MDT Avg on 1st day of each month

From
Yan Wang yan.wang@enron.com
To
Patti Sullivan, Jay Reitmeyer, Matt Smith
Cc
Kim D Alexander, Lindon Chiu, Angela Hylton, Colin Tonks, Tara Piazze, Chris Gaskill
Bcc
Kim D Alexander, Lindon Chiu, Angela Hylton, Colin Tonks, Tara Piazze, Chris Gaskill
Date
Tue, 1 May 2001 12:06:44 -0700 (PDT)
Guys,

Some of you have noticed that on many of today's reports, we are able to see flow value for a meter for 5/1/2000, but the MDT column showed
"na" on the daily report. "na" is also shown on the historical report for the average of May.  It is very easy to get confused (at least I was in the beginnieng, even 
though I wrote the program myself) when you see things like this, you may ask why isn't the average the value shown for today since there is 
only one day's data? The answer is that they are from different cycles. Coding used the business logic that grab the flow value from the latest
successful cycle,  while always use the last cycle when deal with average. At the time of report generation if the last cycle is not available, this will
happen. Fortunately this only happens on the first day of each month.

Please explain this to those who may raise this question when they see this "discrepancy".


Yan