Ohme Home Pro, Home Assistant, Google Sheets Integration

[davewins]

Hi all,

I use Home Assistant for Home Automation, and I have lots of things integrated including my Ohme Home Pro charger, Octopus Energy and Google Sheets.

I have created an couple of automations that trigger on an hourly and daily basis to calculate the amount of Energy put into the car (through integration with Ohme), the cost of that energy (through the Octopus integration) and then write it to a google spreadsheet.

I have 3 worksheets, one is for the Hourly energy/costs (so I can see how much energy/cost per hour (not sure if I actually need this!), one for the Daily Energy/Costs and then one for the Petrol fills (that I fill in manually everytime I fill up). The final spreadsheet tries to work out the "Effective MPG" and also a rough estimation of the pence per mile for petrol and electric. Not perfect as we can't know how many miles were electric vs petrol - but the overall figure for the combined would be pretty accurate.

I've attached a few screenshots.

All for fun.

 

[HStrophyPHEV2025rc]

Wow, kudos to you. This is such impressive stuff! When I first got my PHEV I had lofty aims of doing some analysis over time in a spreadsheet, but not as thorough as this, and I soon lost some petrol receipts ..

So well done for this!

 

[davewins]

Wow, kudos to you. This is such impressive stuff! When I first got my PHEV I had lofty aims of doing some analysis over time in a spreadsheet, but not as thorough as this, and I soon lost some petrol receipts ..

So well done for this!

I've got into the habit of taking photo's of the petrol pump and my ODO for that very same reason!

 

[davewins]

I've also redone the spreadsheet with all my records for the '72 plate MG HS I replaced so I can compare across the two cars.