It is not uncommon to have situations where the units of measure change over the billing history of a given meter. An example would be a water meter where the initial billing data was provided in gallons (GAL) and then at some point in time, the utility vendor decided to change the billing units to kilo-gallons (KGAL). This billing change is accommodated in EnergyCAP by making a change to the bill entry template being used to hand-key the data. This change has no impact on reporting or viewing data at the building level or what is commonly referred to as the rollup level; however, the same cannot be said for viewing the usage trends and power views at the meter level. Rollup data is always converted to a common unit of measure to ensure clean data presentation and comparison. Meter level data is always presented in "native" units of measure, meaning the units of measure in which they were entered into EnergyCAP.
The EnergyCAP unit system has a feature built-in to identify and offer the option to convert the historical "native" units to be the same unit of measure for the entire billing history.
This topic will...
- Describe the Mixed Units of Measure table
- Provide an example of a meter with mixed units of measure over the history of the billing data
- Describe the options and process for managing Mixed Units of Measure situations
- The ability to modify Units of Measure and convert bill history requires permissions associated with the following User Roles:
- Administration Full Access
- Bill Entry & Account Setup
Mixed Units of Measure Table
- Navigate to the Administration section in one of two ways:
- Select Administration from the Main Menu, OR
- Click Admin under the More page header options.
- Select the Units of Measure tree node. Then select the Mixed Units of Measure tab to view the table
- The table provides a list of all meters having historical billing units of measure that are not the same as the units on the currently assigned bill entry template.
- Each row provides the meter, account, vendor, current bill entry template, and a message describing the noted discrepancies.
- The export icon in the upper right corner of the table provides the option to:
- Export a CSV that copies the grid content, OR
- Generate a Meter Update Setup Sheet to update the assigned bill entry template(s)
- Selecting any row reveals the option to Convert Bill History, such that all historical billing units align with the units of the currently assigned bill entry template.
Managing Mixed Units of Measure
The following discussion presents a scenario in which a water meter has units of measure on historical bills that are not the same as the assigned bill template. First we will review the data presentation issues that can result when a meter has mixed units of measure. Then we will walk through the steps to address the mixed units and generate more consistent power views. The previous image highlighted a water meter in which the message field indicated there were "12 bills found where Usage units (Gal) are not equal to units on current template (FD_KGAL_A_N_01)". When viewing the meter bill ledger it is easy to see that there was a drastic change in how the billing data was entered between Dec 2015 and Mar 2016.
The meter Trends Power View clearly shows that the units of measure were not consistent throughout the billing history. This results in making the Trends Power View ineffective for evaluating monthly trends in use per day and unit cost analysis.
If we go back to the Mixed Units of Measure table and select the "Convert Bill History" option, all of the historical bills are updated such that the "counted" usage values are converted to match the units of measure of the current bill template. The original usage value and unit of measure is recorded as an "info-only" line item on the historical bill so that the original entry is not lost and any modifications are clearly visible for record review.
Once the historical bills have been converted to coincide with the current bill entry template, the meter bill ledger and the Trends Power Views reflect the expected data presentation and allow for use and unit cost analysis.
- Given that the usage data being converted is the "native" unit at the meter level, all of the converted data is immediately available for review once the conversion is completed. Meter level data does not require staging table update processing; therefore, bill lists and relevant Power Views are updated and available for review upon the completion of the conversion calculations.
- EnergyCAP Express and EnergyCAP Pro Online users that require specific unit system conversion multipliers will need the assistance of EnergyCAP Technical Support to modify the settings in the hosted database. EnergyCAP Enterprise users can make these modifications through the legacy desktop application if necessary.
- If the unit system does not appear to correctly convert the units after the process has run, contact EnergyCAP Technical support through the Help menu in EnergyCAP.