Report-47

Bill Calendarization Details

An Excel report that provides the calendarized cost, use, and emissions output per bill for a 12-month period. This report is helpful in understanding how the cost, use, and emissions data from a bill is allocated to the appropriate month during the calendarization process.

*This report is emissions data from utility bills only.

Report-47 is available as: Excel

Set your filters for Report-47

  1. Set the Date range.

Other filters to consider for Report-47

  1. Decide if you need to narrow the focus of the report.
    • Select a specific group of sites or meters.
    • Set the filter Topmost place name or Topmost place code.
    • Select a specific commodity or vendor.

Available filters for Report-47

Required filters for Report-47

  • Date range - When you select less than or equal to this sets the end date for the report.

Recommended filters for Report-47

  • Market based - Location based emissions are used if this filter is not selected or set to No.
  • Meter group - lets you filter the report to a specific group of meters.
  • Site group - lets you filter the report to a specific group of sites.
  • Topmost place code - Select the topmost organization or site you want to be included. When you set a topmost organization or site it is the highest level of the facilities tree used, this lets you select a subset of data from your tree for reporting.
  • Topmost place name - Select the topmost organization or site you want to be included. When you set a topmost organization or site it is the highest level of the facilities tree used, this lets you select a subset of data from your tree for reporting.

Optional filters for Report-47

  • Commodity - Select one or more commodities for the report. This filter is not compatible with commodity category.
  • Commodity category - Select one or more commodity categories. This filter is not compatible with commodity.
  • Meter code - Filter to one or more meters. Not compatible with topmost filters.
  • Meter name - Fitler to one or more meters. Not compatible with topmost filters.
  • Vendor code - Filter by one or more vendors, to see all vendors do not include a topmost or group filter. TIP: You can combine with other filters if you want to refine your results.
  • Vendor name - Filter by one or more vendors, to see all vendors do not include a topmost or group filter. TIP: You can combine with other filters if you want to refine your results.