Welcome to the community
Simply ask, learn and share
Showing results for 
Search instead for 
Did you mean: 

posted by Davc | 8 months ago
Re: Downloading Smart Meter data to CSV

@DHogg   I found this on the Ofgem site which I suppose is what SP have agreed to support  





posted by DHogg | 7 months ago
Re: Downloading Smart Meter data to CSV

For those interested, here is some sample data I downloaded from EDF showing what 1 energy provider currently provides consumers as a csv download.

It's a long way short of the half hr read data I used in Oz to work out if Time-of-day tariffs were best for me, but as I haven't seen TOD tariffs in the UK, it will at least help people see how little changes in day to day activities can make differences to there usage.

Oddly (given it is the electric meter that sends the data) all electricity readings except last are estimated. All gas except one are actual. There is provision for daily reports with half hr reads but this isn't populated yet.  Much like SP graphs, actual read data is several days behind and whilst balancing overall, can be ± 3kWh per day with Gas

Electricity Read DateElectricity ConsumptionElectricity Consumption EstimatedElectricity CostElectricity Cost EstimatedGas ConsumptionGas Consumption EstimatedGas CostGas Cost Estimated
13/11/2019    47.72N1.52N
14/11/2019    44.32N1.42N



posted by DaveBev | 3 months ago
Re: Downloading Smart Meter data to CSV
Im with you on this one. My direct debit keeps going up but my smart meter end of week for combined averages £26. But they say my initial £120/ month isnt enough, Im £360 in Debt and I need to be paying £174/month. Something fishy going on here.

posted by Davc | 3 months ago
Re: Downloading Smart Meter data to CSV

@DaveBev   Looks like your daily usage has dropped due to warmer weather, but you need a higher DD to pay off an accumulated debt from winter. Pay off the debt and your DD will drop.