Skip to content
Shop | Excel system

Lean and Green System

Meters, energy value stream, base load, compressed air, leak tags, measures, waste and water, footprint and KPIs.

Screenshot of the Lean and Green System workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup holds prices, emission factors, hours, targets and the status date. Every sheet calculates from it.
  2. 03 Meters holds twelve months of good parts and meter readings. 04 Energy Value Stream splits the energy by process step into value-adding and idle.
  3. 05 Base Load and 06 Compressed Air show the energy used without production and lost to leaks. 07 Leak Tags logs every leak.
  4. 08 Measures puts every idea on the same card, with payback, cost per metric ton of CO2e and a chart of the climate effect per euro.
  5. 09 Waste and Water and 10 Footprint complete the picture, including a Scope 3 outlook per part.
  6. 11 KPIs tracks monthly targets. 12 Audit holds the 25 statements. 13 Action Plan and 14 Dashboard are for the monthly review.

Definitions used in the workbook

  • Energy per good part: Electricity plus gas in kWh, divided by good parts.
  • Idle share: Energy of a process step while it waits or is in standby, divided by its total energy.
  • Leakage rate: Time the compressor runs loaded without any demand, divided by the test time.
  • 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.
  • Scope 1, 2, 3: Direct emissions on site, purchased energy, and everything upstream and downstream.

Sheets in the workbook

  1. Start
  2. Setup
  3. Meters
  4. Energy Value Stream
  5. Base Load
  6. Compressed Air
  7. Leak Tags
  8. Measures
  9. Waste and Water
  10. Footprint
  11. KPIs
  12. Audit
  13. Action Plan
  14. Dashboard

Who it is for

Plants that steer energy, material and CO2 like output and quality.

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.