Nlowest function – Rockwell Automation 9307 FactoryTalk EnergyMetrix User Manual
Page 126

FactoryTalk EnergyMetrix Software
126
Usage
Quantity = LowestTimestamp(ValueType.enumValue)
Quantity = LowestTimestamp(ValueType.enumValue,
SeasonType.enumValue)
Quantity = LowestTimestamp(ValueType.enumValue,
SeasonType.enumValue, DayType.enumValue)
Quantity = LowestTimestamp(ValueType.enumValue,
DayType.enumValue)
Quantity = LowestTimestamp(ValueType.enumValue, startHour,
endHour)
Quantity = LowestTimestamp(ValueType.enumValue,
TimeOfUseType.enumValue)
Quantity = LowestTimestamp(ValueType.enumValue,
SeasonType.enumValue, DayType.enumValue, startHour, endHour)
Quantity = LowestTimestamp(ValueType.enumValue,
SeasonType.enumValue, DayType.enumValue,
TimeOfUseType.enumValue)
Quantity = LowestTimestamp(ValueType.enumValue,
DayType.enumValue, TimeOfUseType.enumValue)
Comments
The startHour and endHour arguments are integers in the range of 1…24, where 24 =
midnight.
Example
The following script returns the time stamp of the real demand power minimum value that
occurred during the Summer season, on working days, during the hours of 10:00 a.m. to
4:00 p.m.:
Dim dtMin As DateTime
dtMin = LowestTimestamp(ValueType.RealPowerDemand,
SeasonType.Summer, DayType.WorkingDay, 10, 16)
NLowest Function
The NLowest function returns the N smallest instances of the selected value logged
between the report start and end dates, and during the periods defined by the SeasonType,
DayType, TimeOfUseType (or StartHour and EndHour) arguments. The NLowest
function is generally used for rate-of-change values such as demand real and reactive
power (kW, kVAR). It returns a Double array of N elements.
Usage
Quantity = NLowest(ValueType.enumValue, N)
Quantity = NLowest(ValueType.enumValue, SeasonType.enumValue, N)
Quantity = NLowest(ValueType.enumValue, SeasonType.enumValue,
DayType.enumValue, N)
Quantity = NLowest(ValueType.enumValue, DayType.enumValue, N)
Quantity = NLowest(ValueType.enumValue, startHour, endHour, N)
Quantity = NLowest(ValueType.enumValue, TimeOfUseType.enumValue,
N)
Quantity = NLowest(ValueType.enumValue, SeasonType.enumValue,
DayType.enumValue, startHour, endHour, N)