dataMarq Report Definition

This report allocates the energy bill information from the primary electric and steam bills for Marquette.  These primary bills include the account numbers listed below.

The distribution and allocation of funds to specific RC accounts requires the reading of internal Marquette meters and a percentage distribution of each of these bills to the appropriate usage of these meters and their respective buildings.

The meter crosswalk page of this report shows which meters belong to which buildings.

This is the number assigned to an energy account by the provider.  For We Energies, these accounts take the form of a ten digit account and a five digit sub account number (0711361164-00070).  Accounts can also be group, so that multiple accounts are billed under a single umbrella account.

In the allocation of energy costs for distributed accounts, an adjustment factor has to be calculated every month.  This is because the amount of energy tracked by the internal Marquette meters doesn't exactly line up with the amount listed on the bills that come in. This is due to a variety of reasons, but to account for this difference the use that is tracked by the internal meters is "adjusted" by an adjustment factor to  match exactly what is listed on the bills.  
On reports users will see an unadjusted use amount - this is the raw usage readings from the internal meters.  This amount is then compared to the total listed on the bill and then each internal meter's usage is adjusted to match the units on the bill.
Adjustment Factor = Total Billed Use / Total Internal Reading Use

Due to the complexity of routing of distributed accounts, some internal meters are applied toward multiple buildings energy use totals.   And in some cases the meter amount needs to be removed from a building's usage amount (negative percent).  The meter cross walk on the Allocation report will show the percent of a meter that is charged to a specific building.

There are nine accounts on Marquette that are not directly linked to a building, but are distributed throughout the campus.  Bills that come in under these accounts are paid by the holding account and then reallocated to specific RCs based on the actual energy usage by buildings on campus. This usage is determined by Marquette owned meters that track the reallocation of these main distributions.  The breakdown of We Energy accounts, Marquette distribution groups and external meters is listed below.