The Sustainability Manager's Impossible Spreadsheet

The sustainability manager's impossible spreadsheet

Somewhere in your organisation is a person who has been handed a target measured in tonnes of carbon dioxide and a tool measured in spreadsheet tabs, and asked to close the distance between the two with willpower and follow-up emails. This is the sustainability manager, and theirs might be the most quietly impossible job in the building. The board has committed to net zero by some round-numbered year. The regulators want reports. The customers want disclosures. And the actual data needed to satisfy any of them is scattered across systems this person cannot reach, owned by people who do not report to them.

It is a job defined by a gap: enormous responsibility, almost no direct access to the thing they're responsible for.

The mandate arrives fully formed, the data does not

The commitments come down from above with great confidence. Cut emissions. Hit the intensity target. File the EECA report. Answer the CBAM data request from the European buyer who now wants verified embedded carbon per product. Complete the ESG disclosure the exchange expects. Each of these assumes, somewhere in its fine print, that the numbers simply exist and can be looked up.

They do not simply exist. The energy data lives in a building management system the facilities team guards. The production figures live with operations. The fuel and refrigerant records live in a drawer. The grid emission factor lives in a PDF someone has to remember to update. The sustainability manager's real first task, before any analysis, is archaeology: going department to department asking people to send numbers they have no particular incentive to send promptly, or at all.

The spreadsheet olympics

So the work becomes a quarterly, then frantically annual, act of collection. Emails go out. Half come back. The ones that come back are in different units, different periods, different formats, and at least one is a photo of a meter taken at a slight angle. The sustainability manager keys it all into a master spreadsheet that has, by now, achieved a level of complexity only its creator understands and which will break catastrophically the moment they take leave.

Where the numbers are missing, and numbers are always missing, the gaps get filled with estimates. Reasonable estimates, defensible ones, but estimates. The report goes out looking authoritative, built on a foundation that the author privately knows is part measurement and part educated guess.

The day the auditor asks "how do you know?"

The spreadsheet survives right up until someone asks it a hard question. An auditor, or a CBAM verifier, or a customer's procurement team, points at a figure and asks the worst possible question: how do you know this is true? And the honest answer, that it was assembled once a year from whatever data could be gathered and filled in with estimates where it couldn't, is not an answer that holds up. You cannot verify a number you reconstructed from memory. You cannot manage, in any real sense, a quantity you measure by hand twelve months apart.

This is the quiet dread under the sustainability role. Not the size of the target, but the fragility of the evidence. The whole edifice rests on data the manager neither owns nor trusts, and everyone is about to start checking the data far more carefully than they used to.

What would actually change the job

The thing that rescues this role is not a better spreadsheet or a more inspiring target. It is access to credible, continuous data that traces back to something real. When energy and the carbon derived from it come straight from the meters, at the equipment and site level, the sustainability manager stops being an archaeologist and starts being an analyst.

That changes the daily experience completely:

- Scope 1 and 2 numbers built from actual metered consumption, not collected by email, so they survive the auditor's question.
- Reports as a byproduct, not a project. EECA, ESG and carbon reporting drawn from the same live data, instead of assembled in an annual scramble.
- A baseline you can prove savings against, so a sustainability initiative can be shown to have worked rather than asserted, the discipline of measurement and verification.
- Attribution. Which site, which process, which piece of equipment is producing the carbon, so effort goes where it matters.

This is what the Sustainability module of a Smart Operation Platform is really for, and the deeper point underneath it is one we keep coming back to: credible sustainability reporting is a data problem before it's a carbon problem. Give the sustainability manager data they can stand behind, and the impossible job becomes merely a hard one.

Nobody should have to defend the future of the planet with a spreadsheet held together by follow-up emails. If that's the corner you've been painted into, come and see what reporting from real data instead of recollection looks like.