PMC Pilot
Website language
Menu
XLSX /

AI tools and documents for engineering and project management.

Energy Baseline Data Collection Worksheet

Blank worksheet for recording energy readings, meter boundaries, operating drivers and data-quality issues. Baseline calculations and normalization are performed separately.

How to use this template

This Excel template contains prepared working sheets and completion notes on a separate sheet. Enter your project data and review the completed workbook before use.

This editable workbook helps you organise project information. Check any included formulas, assumptions and results before use; it does not replace professional review.

The form prepares a separate brief; it does not fill the Word or Excel file.

Read product descriptions in your language. The Word and Excel template files are in English.

Selected page preview · XLSX

Only selected pages are shown. This is not the complete template. The full editable Word or Excel file is supplied with purchase.

Learning

How to use this template

When you need it

Use before evaluating energy improvements or comparing operating periods. Establish the baseline while meter boundaries, operating conditions and historical data quality can be verified, then review it after material facility changes.

What it helps you decide

The worksheet makes an energy comparison interpretable by connecting consumption with measurement boundaries and operating drivers. It prevents lower activity or estimated billing from being presented as demonstrated efficiency improvement.

How to complete it

  1. Define Meter / boundary and Period for each energy carrier. Identify overlapping meters, exports and unmetered consumption before combining readings into a baseline dataset.
  2. Record Energy / unit, Data source and Quality issue, distinguishing readings from estimates. Document meter changes and missing periods without silently replacing data.
  3. Identify Operating drivers and a reviewed Normalization reference. State Comparability limits; baseline calculations and any savings assessment belong in a separately checked model.

Who prepares and reviews it

An energy or facilities engineer prepares the record with meter custodians and production-data owners. A competent analyst reviews normalization separately; the asset owner approves the comparison basis and any subsequent performance claim.

A mistake to avoid

Attributing every reduction in consumption to the project ignores production, weather or operating-hour changes that may explain the observed difference without improved efficiency.

Illustrative example

Illustrative example: a factory's electricity bill falls after an equipment upgrade, but production also declines. The worksheet records meter boundaries, actual readings and output data for both periods. An analyst evaluates comparability before the owner decides whether the available evidence supports an efficiency claim.

Explore the wider topic

Document contents

  • Document control and decision owner
  • Evidence, scope and applicability
  • Boundary and meter mapping
  • Baseline data quality
  • Relevant drivers
  • Comparison conditions
  • Open points, competent review and decision

Required inputs

  • Project / asset identity, assessment date, scope and authorized decision owner
  • Verified source documents with exact revision and record locators
  • Meter boundaries and calibration evidence
  • Historical energy and production records
  • Operating hours, occupancy or weather data where relevant
  • Known meter gaps and operating changes

Practical tools.
Professional judgment.

Confirm the adopted edition, local amendments, National Annex where relevant, and contract requirements.

Prepare project brief