What I have been building these last few months...

Today, I want to tell you about something I’ve been building.

A few years ago, when I was working as a Life Cycle Analyst, I kept running into the same problem. My clients would spend hours every week pulling their energy data, cleaning it in spreadsheets, and trying to make sense of it before sending it to me to do the actual analysis.

By the time it arrived, I was finalising calculations right up to the 11th hour, rushing to have something meaningful to present.

The problem was always the same: the data was too raw or too sensitive to share easily or too time-consuming to process. Every single time the clients gave me the same reason.

In most cases, I had to estimate the numbers based on company size and operation. For me, this was as uncomfortable as it sounds when I was supposed to be the expert in the room.

When I started this newsletter, I noticed the same thing in my readership. Energy professionals, sustainability managers, and analysts spending too much time on data preparation before they could do the work they were actually hired to do.

Then I realised, what people needed wasn’t more data. They needed something that connected directly to the real data, ran the calculations automatically, and came with the interpretation already built in. They needed a decision support tool that did the heavy lifting before the meeting started.

So I quietly started building one.

Before I go further, I want to ask you something.

Hit reply and tell me: what’s the biggest gap you have when it comes to electricity data right now? What takes too long? What do clients ask that you can’t answer as quickly as you’d like?

Every reply shapes what this becomes.

The tool is UK-focused. It pulls live half-hourly data directly from the Elexon Balancing Mechanism Reporting Service and the NESO Data Portal. It is the same sources used by grid operators and energy traders but what this tool does is cleans the data, calculates it, and tells you what it means.

For example, in last 7 days, UK wholesale electricity prices ranged from -£30.84/MWh to £220/MWh. The toolkit captured every half-hour of that automatically, without anyone touching a spreadsheet.

All of it in one Google Sheet, refreshed every hour, with the interpretation built in.

Here, I am showing you one of the charts, freshly taken from Datawrapper. The lower line is the real UK wholesale price. The upper line (Gas-Only Price) is what the price would have been if renewables weren’t generating. The gap between them is what renewables are saving consumers right now. In July so far, the saving is worth up to £20.53/MWh.

I’m launching in August. But rather than wait until launch day, I’m going to spend the next few weeks proving it.

Starting next Tuesday, you’ll get a weekly insight pulled directly from the toolkit that includes what UK electricity did that week, where the interesting moments were, and what it means in practice.

By the time August arrives, you won’t need to take my word for it. You’ll have seen it working.

And one more thing. If you want to see the toolkit before the official launch, reply to this post and I’ll share a preview with you directly.

I am also determined to keep our usual Friday posts though I believe this tool will take majority of my energy between now and launch. But once it settles down, Tuesday would be the energy toolkit day and Friday would be our usual Green Solutions posts.

Thank you for being part of it.

Kind Regards,

Parva Chhantyal