We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
We're aware that some users are experiencing technical issues which the team are working to resolve. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Gas / Elect daily use calculator
Options

hawkwinddotcom
Posts: 517 Forumite


in Energy
Hopefully someone can help.
When I was with Scottish power, I could input as many daily readings as I wanted and it would show me what my daily usage was for 2 rates of elect and also gas, which i thought was useful.
Sadly since moving to EDF via bulb and having smart meters I dont have the useful info (ihd doesnt work properly yet).
Does anyone have an Excel sheet that, they could share, they use for an easy input and read.
When I was with Scottish power, I could input as many daily readings as I wanted and it would show me what my daily usage was for 2 rates of elect and also gas, which i thought was useful.
Sadly since moving to EDF via bulb and having smart meters I dont have the useful info (ihd doesnt work properly yet).
Does anyone have an Excel sheet that, they could share, they use for an easy input and read.
3.78 kWp PV SolarEdge with iBoost South facing.
30° pitch roof 4% shading. Installed 6th June 18.
Gloucester
30° pitch roof 4% shading. Installed 6th June 18.
Gloucester
0
Comments
-
No replies so here’s what I do / use. I’ve got an iPad app that lets me enter as many meter readings as I like. Been doing this for a good few years now, so have quite a history of not only gas, electric, water and solar generation but also that of a couple of family members too.1
-
As I have a standard meter, my spreadsheet would be of no use to you. Also, not rich enough for MS Office, I have to make do with Libre Office.
1 -
tim_p said:No replies so here’s what I do / use. I’ve got an iPad app that lets me enter as many meter readings as I like. Been doing this for a good few years now, so have quite a history of not only gas, electric, water and solar generation but also that of a couple of family members too.
3.78 kWp PV SolarEdge with iBoost South facing.
30° pitch roof 4% shading. Installed 6th June 18.
Gloucester0 -
PennineAcute said:As I have a standard meter, my spreadsheet would be of no use to you. Also, not rich enough for MS Office, I have to make do with Libre Office.3.78 kWp PV SolarEdge with iBoost South facing.
30° pitch roof 4% shading. Installed 6th June 18.
Gloucester1 -
hawkwinddotcom said:tim_p said:No replies so here’s what I do / use. I’ve got an iPad app that lets me enter as many meter readings as I like. Been doing this for a good few years now, so have quite a history of not only gas, electric, water and solar generation but also that of a couple of family members too.1
-
Not sure if its exactly what you are looking for, but you could try the Energy Consumption Analyzer App
https://play.google.com/store/apps/details?id=at.topfen.ecas&hl=en_GB
1 -
hawkwinddotcom said:PennineAcute said:As I have a standard meter, my spreadsheet would be of no use to you. Also, not rich enough for MS Office, I have to make do with Libre Office.
Thanks for that, I will have a look.
1 -
Sounds like a nice weekend project to learn how to create one yourself.
1
This discussion has been closed.
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 350.7K Banking & Borrowing
- 253K Reduce Debt & Boost Income
- 453.4K Spending & Discounts
- 243.7K Work, Benefits & Business
- 598.4K Mortgages, Homes & Bills
- 176.8K Life & Family
- 256.8K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards