Navigation:  Module 1 - Energy Accounting > Accounts & Invoices Tab > User Defined Components > Examples >

Interval Meter Tariff Expressions

Previous page Next page
  rev. 2011-03-30        

Expressions can reference interval meter readings in the same way they can reference monthly readings.  Available operators and time/date based methods make it possible to define time-of-use and variable-rate tariffs

Examples of Interval Meter Tariff Expressions

In these examples, Consumption is the name of a User-Defined Component for consumption at the interval meter.  Metered values can be any frequency greater than 5 minutes.

Expression

Description

[Consumption].Sum

Obtains the sum of interval consumption readings for invoice range

[Consumption].Max

Obtains the max interval consumption reading for invoice range

[Consumption].Min

Obtains the min interval consumption reading for invoice range

[Consumption].Avg

Obtains the average interval consumption reading for invoice range

[Consumption].InRange(Date.New(“1/1/2009”),Date.New(“2/1/2009”))

Obtains the collection of interval consumption readings between Jan 1 2009 and Feb 1 2009

[Consumption].InRange(Date.New(“1/1/2009”),Date.New(“2/1/2009”)).Sum

Obtains the sum of all interval consumption readings between Jan 1 2009 and Feb 1 2009

[Consumption].Weekday

Obtains the collection of interval consumption readings occurring on weekdays for invoice range

[Consumption].Weekday.Sum

Obtains the sum of interval consumption readings occurring on weekdays

[Consumption].Weekday.InTimeRange(Time.New(12,0,0),Time.New(17,0,0))

Obtains the collection of interval consumption readings occurring on weekdays between 12:00pm and 5:00pm for invoice range

[Consumption].Weekday.InTimeRange(Time.New(12,0,0),Time.New(17,0,0)).Sum

Obtains the sum of interval consumption readings occurring on weekdays between 12:00pm and 5:00pm for invoice range

 



snippet_Interval_Meter_Tariff         ©2014 Managing Energy Inc.