Report-02

Ranking Report

Report-02 is a data table to help you identify abnormally high or low use, cost, average unit cost, etc. by ranking objects from high to low. The results help you to prioritize buildings and meters that are good candidates for potential savings.

Use Group by to set what is ranked (what is on each row), a common option is either meter or building.

Recommendations

When you are reporting on Cost Avoidance, remember to run Cost Avoidance -> Calculate Savings first.

Tip

For the ranking to be useful, be sure the objects are comparable (ranking all electric meters or all libraries). It might be helpful to create your own building or meter group and use the new group as a filter.

Set your filters

  1. Choose the type of data you want with Data type.
    • Billing period data uses the raw billing data as received from the utility vendor. Billing period data is better when working with accounting functions or charging departments for their portion of bill.
    • Calendarized data is more representative of monthly use and cost. For year-over-year COST comparisons use calendarized data.
    • Normalized is best when comparing USE year-over-year because it removes weather as a variable.
  2. Choose what to rank by using the filter Group by. This determines what is on each row in your report. TIP: A common choice is building.
  3. Decide if you want to Include account charges. Account line item charges are one-time or periodic charges. A charge is typically assigned at the account level when it does not have a link or relation to the use or demand on the bill.
  4. Set Order by. Decide how you want the rows ordered. Select name or code if you want to order your report alphabetically. Select value if you want the report ordered highest to lowest by the use or cost you selected for the Rank by filter.
  5. Choose what you want ranked with Rank by (annualized cost per area, cost per day, etc.).
  6. Set the time frame for your report with the Date range filter or choose Accounting period (you must use billing period data with Accounting Period). 
    If you don't select a Date Range or Accounting Period, all billing periods are included.

Other filters to consider

  1. Use the Commodity category filter to view more granular commodity data in charts and reports.
  2. Do you want to include only Active accounts? If this filter is not included your report includes both active and inactive.
  3. Include or not include void bills?

Example

Identify extreme average unit cost for a meter.