Report-14

Cost Avoidance Summary

Report-14 is a data table that summarizes BATCC Cost, Actual Cost, Cost Avoidance, and Cost Avoidance percentage. The report can be sorted on any column.

Report-14 recommendations

Remember to run Cost Avoidance -> Calculate Savings first.

Set a range of Billing periods (for example, current fiscal year) otherwise the report includes all the months beginning with the Savings Start Date of each meter and ending with the most recently processed bill.

Report-14 tip

BATCC is the Baseline Adjusted to Current Conditions, the pre-energy management baseline that has been adjusted for weather and other variables for a like-to-like comparison with the current bills.

Set your filters for Report-14

  1. Group by
    Select what is displayed on each row.
  2. Sort by
    Sorts the report by what you choose for each row with the Group by option. Sort by Avoidance % to see where you are saving the most.
  3. Value
    Decide if you want to report on cost or use.
  4. Billing period
    Set a range of Billing periods (for example, current fiscal year) otherwise the report includes all the months beginning with the Savings Start Date of each meter and ending with the most recently processed bill.
  5. Report on a subset of data
    Set a filter such as Topmost place, Building group, or Commodity.

Other filters to consider for Report-14

  1. Active accounts only
    Decide whether to include only active accounts.
    If this filter is not applied, your report includes both active and inactive accounts.

Example filters for Report-14

Building report sorted by building.

Available filters for Report-14

Required filters

  • Group by - This selection determines what is on each row in your report (commodity, buildings, meter).
  • Sort by - Select the value you want used for sorting the report, to sort the report alphabetically select the Group by option.
  • Value - Select what you want to report on.

Recommended filters

  • Billing period
  • Site group
  • Topmost place code
  • Topmost place name

Optional Filters

  • Account is active - If this filter is not included, includes both active and inactive accounts are including in the report.
  • Accounting period
  • Bill is from external vendor - When this filter is not selected, the report includes data from both vendor (external) and chargeback (internal) bills.
  • Commodity
  • Commodity category
  • Meter code
  • Meter group
  • Meter name
  • Meters in site code
  • Meters in site name
  • Topmost cost center code
  • Topmost cost center name
  • Vendor code
  • Vendor name