ENERGY CONSUMPTION DATA RECONCILIATION
Scope. Reconciliation of all estimated (or metered)
energy consumption data with the total actual consumption
(installation, feeder, metering point) is as important to
accurate energy allocation as the assignment of an initial EUI.
The reconciliation accounts for inaccuracies in the EUI value
assignments by forcing the sum of all estimated and metered
values to equal the total actual (billed) consumption. If all
initial estimates are based on similar assumptions and estimation
techniques, the reconciled values can be considered equitable
among each other.
Reconciliation may be performed at various levels
and/or sections of an installation as well as the overall
installation. A complete reconciliation incorporates all energy
use for an area or installation including buildings, ships,
processes, street lights, losses, and other nonbuilding uses.
Most Navy installations have some sort of reconciliation process.
If the process currently in place provides accurate, repeatable,
and equitable results, there may be no need to revise or replace
it. However, if an installation's process is either nonexistent
or nonfunctional, then part or all of the process presented here
should be considered.
This process can be done manually or with any spreadsheet or
database software. Using a spreadsheet or database is strongly
recommended and will provide faster and easier calculation.
Reconciliation Process. The process described here
involves inputs of estimated and known energy use. The
calculation assistance presented in Section 2 can be used to
prepare many of the inputs required. The forms and sample
reconciliation displayed in Tables 11 through 16 were completed
by following these steps:
a) Define a consumption period and group of buildings
and/or other energy uses (e.g., one-month time period and entire
b) Collect and enter the total billing (usually
utility metered) consumption values for all fuels for that time
period in Table 11as Billed Totals. It is important to verify
that these values relate directly to the group of buildings and
other energy uses under consideration as well as to the
appropriate time period being considered.