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

posted by Davc | 5 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  

https://www.ofgem.gov.uk/gas/retail-market/market-review-and-reform/midata-energy-project

 

 

Highlighted

posted by DHogg | 4 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
8/11/20194.1Y0.81Y15.74N0.65N
9/11/20194.1Y0.81Y45.03Y1.44Y
10/11/20194.1Y0.81Y45.03N1.44Y
11/11/20194.1Y0.81Y43.73N1.41N
12/11/20194.1N0.81Y33.95N1.14N
13/11/2019    47.72N1.52N
14/11/2019    44.32N1.42N