Energy bills spreadsheet templates
Discussion
BGARK said:
Is anyone using a spreadsheet to keep on top of Electricity, Gas etc on a monthly basis?
Or a formula to add meter readings that automatically show costs. Maybe then comparing kwh £ to historical bills or any future trends upwards. maybe listed downwards by month.
Personally, I find google sheets helpful as you can share with friends and family. Comment and never duplicate by mistake.
Maybe doing this manually might also find any discrepancies between meters and bill providers estimating high energy consumption, then keeping your money for months.
Any links to such a thing or maybe share the formulas here for others to use if anyone has found something particularly useful.
yes - Weekly readings forGas and Elec (Day and Night time meters) it's not hard and the formula required to convery Gas M3 is on your billsOr a formula to add meter readings that automatically show costs. Maybe then comparing kwh £ to historical bills or any future trends upwards. maybe listed downwards by month.
Personally, I find google sheets helpful as you can share with friends and family. Comment and never duplicate by mistake.
Maybe doing this manually might also find any discrepancies between meters and bill providers estimating high energy consumption, then keeping your money for months.
Any links to such a thing or maybe share the formulas here for others to use if anyone has found something particularly useful.
if anyone wants a copy then I'm happy to provide
Edited by B'stard Child on Sunday 25th September 23:59
I use a spreadheet that I knocked up as others have.
One of the things I have found useful recently is to substitute the post October price guarantee rates into the bill just received to see what it would have been / will be next time and know exactly what the actual £ increase to me will be.
One of the things I have found useful recently is to substitute the post October price guarantee rates into the bill just received to see what it would have been / will be next time and know exactly what the actual £ increase to me will be.
GasEngineer said:
I use a spreadheet that I knocked up as others have.
One of the things I have found useful recently is to substitute the post October price guarantee rates into the bill just received to see what it would have been / will be next time and know exactly what the actual £ increase to me will be.
this is my madness on a page for working out the future costs etc One of the things I have found useful recently is to substitute the post October price guarantee rates into the bill just received to see what it would have been / will be next time and know exactly what the actual £ increase to me will be.
i really should tidy it up and get rid of the crap
Gassing Station | Homes, Gardens and DIY | Top of Page | What's New | My Stuff