Using the Background Data task, the Business Process Owner for Utilities can perform the following tasks used by the Energy Management application:
Note: You are free to use different bill types for tracking various utilities and may define new bill types and enter bill data accordingly. However, for weather model calculations, the bill's bill type and the building’s (bl table record) heating or cooling utility type must be Electricity, Gas, Fuel 1, Fuel 2, Propane, or Water. These are the only utility types recognized by the out-of the-box code. If you add other bill types, be aware that you would need to modify the code to perform weather model calculations.
Note: The weather model regression analysis requires bills that have bill units that roll up to energy / consumption.
If you want to use the ARCHIBUS Connectors to load your energy bill data, see Loading Energy Bills Using the Connectors: Overview.
The Define Bill Units task enables you to define each specific type of unit that will be tracked on a utility bill. The Bill Units are a critical part of the Energy Management application as they require you to define how each unit rolls up to the following reporting categories:
Note: From the Thematic Energy Map, the Utility Bill Metrics, and the Measurement & Verification reports, you can select to show consumption either as kWh or MMBTU. However, be aware that these selections affect only consumption; demand is always expressed as kW, and volume is always expressed as CCF.
If the billing unit is one of the common units (MMBTU for energy / consumption, kW for Power / Demand, or CCF for Volume), their conversion factor is 1.0. For other units, you must enter the conversion factor to convert the unit to the common unit.
The following are examples of the types of units and conversions typically seen in the energy industry.
| Bill Type | Billing Unit Type | Billing Units | Applied to this type of energy for rollup | Common Unit | Conversion factor (billing units * conversion factor = common units) |
|---|---|---|---|---|---|
| Electric | Energy | MMBTU | Consumption (MMBTU) |
MMBTU |
1.000000000000 |
| Electric | Energy |
kWh (kilowatt hours) |
Consumption (MMBTU) | MMBTU |
0.003412000000 |
| Natural Gas | Energy | Therms | Consumption (MMBTU) | MMBTU |
0.1000 |
| Natural Gas | Energy |
BTU (British thermal units) |
Consumption (MMBTU) | MMBTU | 0.000001000000 |
| GAS - PROPANE | Energy | Gallons | Consumption (MMBTU) | MMBTU | 0.09133 |
| GAS - PROPANE | Energy | CCF | Consumption (MMBTU) | MMBTU | 0.2516 |
| GAS - PROPANE | Energy | BTU | Consumption (MMBTU) | MMBTU | 0.000001 |
| GAS - PROPANE | Energy | MMBTU | Consumption (MMBTU) | MMBTU | 1.000000 |
| Fuel Oil 1 | Energy | MMBTU | Consumption (MMBTU) | MMBTU | 1.000000 |
| Fuel Oil 1 | Energy | BTU | Consumption (MMBTU) | MMBTU | 0.000001 |
| Fuel Oil 1 | Energy | Gallons | Consumption (MMBTU) | MMBTU | 0.135 |
| Fuel Oil 1 | Energy | Barrels (US Liquid) | Consumption (MMBTU) | MMBTU | 5.67 |
| Fuel Oil 2 | Energy | MMBTU | Consumption (MMBTU) | MMBTU | 1.000000 |
| Fuel Oil 2 | Energy | BTU | Consumption (MMBTU) | MMBTU | 0.000001 |
| Fuel Oil 2 | Energy | Gallons | Consumption (MMBTU) | MMBTU | 0.138690 |
| Fuel Oil 2 | Energy | Barrels (US Liquid) | Consumption (MMBTU) | MMBTU | 5.82498 |
| Electric | Power | kW (kilowatts) | Power / Demand (kW) | kW |
1.000000000000 |
| Natural Gas | Energy |
CCF (one hundred cubic feet) |
Consumption (MMBTU) | MMBTU |
0.1029000000000 |
|
Natural Gas |
Energy | M3 (cubic meter) | Consumption (MMBTU) | MMBTU |
0.0363387920343 |
| Water | Volume |
TGAL (one thousand gallons) |
Volume (CCF) | CCF |
0.748000000000 |
|
Water |
Volume | L (liter) | Volume (CCF) | CCF |
0.000353146667 |
| Water | Volume | M3 (cubic meter) | Volume (CCF) | CCF |
0.353146667000 |
Note: Natural Gas Conversion factors obtained via http://www.energystar.gov/buildings/sites/default/uploads/tools/QuickConverter.xls.
Precise equation of energy per volume depends, in part, on the chemical composition of the natural gas. Consult your provider for more information.
The Define Bill Types task enables you to define each specific type of utility bill that will be entered into ARCHIBUS.
To add or edit a bill type:
The Define Bill Types form appears. All existing Bill Types appear in the Left panel.
Bill Type: Enter a unique identifier for this type of bill.
Cost Category: Select a utility cost category for the bill.
To add or edit a Bill Unit:
The Define Bill Units form appears. All existing Bill Units appear in the left panel.
Any bill units defined for that bill type appear in the Bill Units panel.
Bill Type: The list shows the bill type you selected, but, if needed, you can select a different bill type from the list.
Bill Unit: Enter the unit to be tracked for this bill.
Rollup Type: Select how this unit rolls up for reporting, such as Energy / Consumption (MMBTU), Power / Demand (kW, or Volume (CCF.)
Conversion Factor to Common Unit: The numeric value used to convert the bill unit to its common unit.
Note: It is critical to enter the Rollup Type and Conversion Factor to Common Unit. For example, kWh is a Bill Unit that rolls up to Energy / Consumption which is reported in MMBTU. You must enter the numeric value to convert kWh to MMBTU in the field titled “Conversion Factor to Common Unit”. For this example, the factor to convert kWh to MMBTU is 0.003412. If needed, there are sources on the Web to obtain Energy Units and their conversion factors.
Default?: Select “Yes” to indicate that this is the unit that is shown first in selection lists when users are entering line item data for bills. For consumption, it also determines if the application initially shows the report in MMBTU or kWh. The “Default” setting for other units will not change the display in the report. For example, Power demand is always expressed as kW, and volume is always expressed as CCF.
Only one unit per bill type can be specified as the default. If you select “Yes” for the currently displayed unit, any other unit that was specified as the default will automatically be set to “No”. In addition, you must designate one unit as the default or the system will not correctly display your results.
Note: If the default unit is different from the common units for a bill type, you may see small differences between the displayed unit value and the entered value. For example, in an energy bill where the common units are MMBTU and the default units are set to kWh, if you enter consumption information in increments less than 0.5 kWh for the bill line quantity, the displayed value in kWh may be off by 1/10,000 kWh due to the rounding that occurs when the entered value is converted to the common units (MMBTU), and the common units are converted back to the display units (KWH).
Description: Enter a description that helps to identify this bill unit.
| Copyright © 1984-2016, ARCHIBUS, Inc. All rights reserved. |