Skip to content
Shop | Excel tracker

Energy and CO2 per Unit Tracker

Track energy per good part and CO2e per unit, find base load and leaks, and rank measures by payback.

Screenshot of the Energy and CO2 per Unit Tracker workbook with example data
Example data from the workbook.

How it works

  1. Open 02 Setup. Enter your electricity and gas prices, the emission factors, production hours, base load target and the status date.
  2. Enter twelve months of good parts and meter readings in 03 Meters. Energy and CO2e per good part calculate per month and for the year.
  3. Read the main meter every Sunday afternoon and enter the value in 04 Base Load. The sheet shows what this load costs per year.
  4. Put every idea on the same card in 05 Measures. EUR, CO2e, payback, cost per metric ton and rank calculate.
  5. Log every compressed air leak in 06 Leak Tags. Open tags older than 14 days turn red.
  6. Review 07 Dashboard every month with the plant manager.

Definitions used in the workbook

  • Energy per good part: Electricity plus gas in kWh, divided by good parts. Scrap carries its full energy, so it shows up in this number.
  • CO2e: Carbon dioxide equivalent. Electricity times its factor plus gas times its factor. State whether the electricity factor is location based or market based.
  • Base load: Power drawn when nothing is produced. Everything above the target is waste.
  • Payback: Investment divided by the saving per year.
  • Cost per metric ton: Investment spread over its life, minus the saving per year, divided by the metric tons avoided. Negative means the measure saves money.

Sheets in the workbook

  1. Start
  2. Setup
  3. Meters
  4. Base Load
  5. Measures
  6. Leak Tags
  7. Dashboard

Who it is for

Energy managers, maintenance leads and plant managers.

The method behind the numbers

This workbook is part of the Lean and Green toolkits. The Starter Kit adds the guide and the checklist for the first 30 days. The Excellence Bundle adds playbook, workshop pack, templates, deck and the complete Excel system.

Newsletter

One Lean idea.
Every week.