1-Meter Energy-Baseline-Target

Objective/Method/Outcome

  • Objective: Filter and aggregate meter data from a raw cumulative Trend Log sample and use historical consumption as a baseline with the adjustable target.
  • Method: Data transformation is performed in logic flow with aggregation interval on request. Negative cumulative values are replaced with zero values. The offset series retrieves historical consumption as a baseline, which is factored to calculate the target.
  • Outcome: Filtered and aggregate energy data, as well as baseline and target on request. Can be used to display energy data in public dashboards via the Kaizen public API.

Inputs

  • Meter Data 1: Raw Trend Log

Logic

  • Input TL [7] goes through the Delta block [13] to highlight changes that could be happening between samples, then the Delta feeds into a Multiple Expressions block [19] that works like a filter, and filters out any values below zero.
  • Data is then summed daily in the Aggregate block [1] and offset by a year [26].
  • Finally, the Data is calculated to show the desired 10% Energy saved baseline with block [31].
Target Logic Flow.

Applicable Systems

  • Primary: Energy