PlantEnergyKit

Home / EnPI and baseline regression

EnPI and energy baseline regression calculator

Fit an energy baseline to your production data and measure savings that are normalised for changes in output, as ISO 50001 expects.

One period per line: an optional label, then production, then energy in kWh. Separate with spaces, tabs or semicolons, and leave out thousands separators. You can paste two columns straight from Excel.

Same format. Leave empty to see only the baseline model.

Energy saved in the reporting period

–kWh

Saving against baseline
–
Value of savings
–
Expected energy
–
Actual energy
–
Fixed energy per period
–
Energy per unit produced
–
R² of the model
–
CV(RMSE)
–

How the calculation works

The calculator fits a straight line through the baseline data by least squares:

Expected energy = a + b × production

The intercept a is the fixed energy used in each period regardless of output. The slope b is the energy used per extra unit produced. For each reporting period, the model predicts what the plant would have used under baseline performance. The difference between expected and actual energy is the saving, normalised for production.

Savings = Σ(a + b × production) − Σ actual energy
R² = 1 − SSresidual ÷ SStotal
CV(RMSE) = √(SSresidual ÷ (n − 2)) ÷ mean energy

Worked example

The sample data loaded above is a year of monthly production and electricity use for a plant, followed by three reporting months after an energy improvement project.

Using this for ISO 50001

Questions

What is an EnPI?

An energy performance indicator: a measure used to track energy performance, from a simple ratio such as kWh per tonne to a regression model that accounts for several variables.

Why use regression instead of kWh per tonne?

Because most plants have a fixed energy load. Regression separates the fixed part from the part that varies with output, so savings are not hidden or inflated by changes in production.

How much data do I need for a baseline?

Twelve monthly periods is a common minimum, as it covers a full year of seasonal variation. Weekly or daily data can give a stronger model if the meter data is reliable.