Dr Yishuang (Sherry) Xu24 May 20265 min read

How to Calculate CRREM Pathway Misalignment Without the Excel Tool

The core CRREM calculation explained step by step — what data you need, how the misalignment year is determined, and where to get the pathway datasets now that the Excel tool is retiring.

To calculate CRREM pathway misalignment, you need five inputs — property type, country, gross internal area, reporting year, and energy consumption by carrier — which you use to compute energy and carbon intensity per square metre, then compare against the CRREM 1.5°C-aligned pathway budget for that property type and region to find the year your building's trajectory crosses the pathway. That crossing point is the misalignment year (formerly called the stranding year).

With the CRREM Excel tool retiring on 1 July 2026, many practitioners are encountering the underlying calculation methodology for the first time. The good news is that the calculation is not complex — the CRREM Technical Blueprint published in the CRREM Library specifies every step, and the pathway datasets are freely available for download.

The Core Calculation in Four Steps

Step 1: Calculate current energy intensity. Sum all energy consumption by carrier (grid electricity, gas, oil, district heating/cooling, biomass) in kWh per year. Divide by gross internal area (GIA) in square metres. This gives you energy use intensity (EUI) in kWh/m²/year. All consumption must be whole-building (landlord plus tenant) to match CRREM methodology.

Step 2: Calculate current carbon intensity. Multiply each energy carrier's consumption by its emission factor from the CRREM Emission Factors dataset (these are country-specific and year-specific — grid emission factors decline annually as the grid decarbonises). Sum all carriers. Divide by GIA. This gives you greenhouse gas intensity (GHGI) in kgCO₂e/m²/year.

Step 3: Look up the pathway budget. From the CRREM Global Pathways dataset, find the 1.5°C-aligned pathway for your property type and country. This gives you a year-by-year budget — the maximum energy or carbon intensity the building should have in each year from 2020 to 2050 to remain aligned with the Paris Agreement target.

Step 4: Find the misalignment year. Project your building's energy and carbon intensity forward. Energy demand is held constant (conservative assumption). Carbon intensity declines annually because grid emission factors decline even without building improvements. Compare your projected trajectory against the pathway budget year by year. The first year your building's intensity exceeds the pathway budget is the misalignment year.

Key insight: Many UK office buildings rated EPC D or below are already misaligned — their current carbon intensity already exceeds the 2026 CRREM pathway budget. For these assets, the misalignment year is not in the future; the building is currently stranded under CRREM methodology. A typical EPC D office has carbon intensity around 52 kgCO₂e/m²/year against a 2026 pathway budget of approximately 22 kgCO₂e/m²/year for UK offices.

Where to Get the Data

All datasets are available as free downloads from the CRREM Library (crrem.org/library): the Global Pathways dataset provides year-by-year budgets, the Emission Factors dataset provides per-carrier emission factors by country and year, and the Technical Blueprint provides the complete calculation specification including handling of mixed-use buildings, forward projection methodology, and portfolio aggregation rules.

Or Use a Free Tool

If you need the misalignment year without building the calculation yourself, the Plinthos CRREM Misalignment Engine is a free browser-based tool that implements this calculation for UK commercial property. Input your property type, energy intensity, and carbon intensity; receive the misalignment year, pathway chart, gap analysis, and cumulative excess emissions — instantly, with no account or download required.

Try the Free CRREM Misalignment Engine

Calculate the stranding year for any UK commercial property — no Excel needed.

Use Free Tool