Blog
16 Mar 2026/
Real Estate Industry/

The Spreadsheet Ceiling: Why portfolio decarbonisation stalls without decision intelligence (and how to break through)

Evan Petkov

Most portfolios don’t stall on funding or intent. They stall at the point where complexity overwhelms spreadsheets. Decarbonisation isn’t a single project with a neat payback; it’s a path-dependent sequence of moves that cut across finance, engineering, tenants, and regulation. Spreadsheets were built for snapshots. Transition planning demands moving pictures.

Why spreadsheets quietly kill momentum

Spreadsheets hard-code yesterday’s assumptions into tomorrow’s decisions. They force single-point estimates (one energy price, one capex, one occupancy), so any “answer” is brittle the moment conditions shift. Version sprawl erodes trust: finance has one file, engineering another, ESG a third, and none reconcile quickly enough for the investment committee. There’s no native way to capture dependencies (e.g., envelope first, then electrify) or to price risk (policy changes, carbon costs, grid constraints). The result is paralysis masked as prudence.

Decision intelligence ≠ more dashboards

BI tells you what happened. Decision intelligence tells you what to do next under uncertainty. It unifies the minimum viable dataset (areas, metered energy, tariffs, asset condition, lease terms), maps each asset to credible pathways, and runs scenario simulations that respect constraints (capex limits, downtime windows, grid capacity, MEPS deadlines). Instead of one fragile plan, you get a resilient playbook: if energy prices rise 30%, do X; if carbon prices arrive early, do Y.

The shift that unlocks action

With decision intelligence, teams move from debating assumptions to comparing outcomes. Finance sees carbon-adjusted NOI and IRR by scenario. Engineering sees measure sequencing that actually fits outage windows. ESG sees pathway alignment and audit-ready evidence. Everyone sees the same truth at the same time, so the conversation shifts from “are we sure?” to “when do we start?”.

What “breaking through” looks like in practice

  1. Unify the data. Normalize areas, meters, tariffs, and baseline performance; fix boundary issues for scopes 1-3.
  2. Anchor to pathways. Place every asset against recognized curves (e.g., by type and country) to reveal stranding risk and timing.
  3. Model scenarios, not guesses. Stress-test energy prices, carbon costs, policy timelines, and financing terms; quantify upside/downside.
  4. Sequence measures. Fabric→systems→electrification→onsite renewables, with downtime, grid capacity, and lease events in the loop.
  5. Optimise at portfolio level. Push capex to the assets where it moves both carbon and value the most; set annual carbon and return targets.
  6. Operationalise governance. Create an evidence pack (assumptions, scenarios, decisions) and an M&V loop that updates quarterly.

The numbers that matter to the board

Boards don’t buy kilowatt-hours; they buy risk-adjusted returns. Translate technical wins into financial language: carbon-adjusted NOI, avoided compliance penalties, cost-of-capital impact from credible transition plans, and resilience to price shocks. Decision intelligence makes those links explicit and defensible.

A 90-day outcome you can ship

  • A reconciled portfolio baseline (energy, carbon, primary energy where required).
  • A scenario set agreed by Finance, ESG, and Engineering.
  • A three-year, path-dependent retrofit sequence with capex phasing and downtime windows.
  • An investment-committee pack showing IRR/NPV across scenarios and the effect on stranding risk and disclosure scores.
  • An M&V cadence that refreshes the plan as data changes, no more “spreadsheet archaeology.”

How Optiml helps

Optiml ingests your portfolio data, maps assets to decarbonisation pathways, and runs scenario-based optimisation across carbon, cost, and risk. You see where to spend the next euro for the biggest combined impact, and you get the governance trail to satisfy lenders, auditors, and the board. Instead of months of spreadsheet wrangling, you have a living plan in days that updates as reality does.

© Optiml AG 2026

contact@optiml.com

🇨🇭 Tessinerplatz 7, 8002 Zurich, Switzerland

🇩🇪 Munich, Germany