Overview

This dashboard shows utility data by building for the selected date range. You can view consumption, cost, and consumption per square foot, cost per square foot, and more by utility. You can also view yearly and monthly graphs of the data you retrieved.

Search Bar

• Building Category: Select the building category you want to view.
• Building Group: Once the building category is selected, the Building Group drop-down box populates based on the building category.

• Date Range Picker: Select the date range you want to look up. For your convenience, there are 60 day trail, 90 day trail, 6 month trail, and 1 year trail options. Each option has a 60 day window, which means that the end date is the last day two months before today, since the invoice may not arrive yet. Of course, you can select any date you want with a custom range.

Data Table

Summary Data Table: The summary data table shows consumption totals, consumption by square foot, cost totals, cost by square foot, and annualized data for the selected date range, which you can view by clicking the tabs.

: A column that shows the ranking. The ranking appears when you sort a column of numbers such as sq.ft. consumption, cost, etc.

Flag(): The red flag means that there may be missing month data, but this is tracked with data from the TOTAL meter, so it may not mean missing data from the actual bill. You can see which months are missing by clicking row.

Monthly Data Table: The monthly data table shows the normalized monthly utility data for the building you clicked and the date range you selected. The table also shows consumption, consumption per square foot, cost, cost per square foot, and rate for each utility by month.

Charts

Yearly Charts: Select the date range you want to view the yearly graphs for(for example, if you want to view 10 years of graphs, select 7/1/2013 to 6/30/2023),  select the building, and click the  Yearly Charts  button to view the yearly EUI, square footage, utility usage, usage by square footage, cost, cost by square footage, and rates chart for each tab.

Building Comparison Charts: Select Building Group or Building Category, then select Date Range in the search bar to view the data. Once the data is looked up in the table, select the buildings you want to compare data for and click the  Building Comparison Charts  button to view charts comparing each building's EUI, square footage, utility usage, usage by square footage, cost, cost by square footage in each tab.

Monthly Charts: The monthly chart can be viewed by clicking on a row in the main table and clicking the  Monthly Charts  button in the popup window where you can view monthly data by building. You can view monthly EUI, square footage, utility usage, usage by square footage, cost, cost by square footage, and rates chart for each tab. Note, the date range is the range you selected in the search bar.

Misc.

Data Sorting: You can sort the data in ascending/descending order by clicking on the header of the table.

Export Data to Excel: You can export data that you retrieve to Excel with this button  

US Building Average: Toggling this on will allow you to compare a building's EUI to the US Average, which is based on CBECS data.

Solar Adjusted: Toggling this on will allow you to see the EUI and electricity consumption affected by solar.