Octopus data analysis guide - with template spreadsheet

If you'd like to analyse your Octopus Energy half hourly import and export data and didn't know where to start, this video might help. I walk you through the steps for downloading the data from your Octopus account, then show you a simple template for doing some basic processing of the data. From here you can take your analysis wherever you like!

00:00 Introduction
00:28 Spreadsheet introduction
01:01 Getting the Octopus data
02:52 Adding the data to the spreadsheet
06:44 Calculation tab
09:12 Setting up the tariff
11:11 Summing up into half-hours
15:24 Car savings
18:29 Instructions for downloading the spreadsheet
19:05 Closing thoughts

Link to the spreadsheet:
https://docs.google.com/spreadsheets/...

To make a copy go to File - Make a copy, then save that to your Google Drive.

Please note that Tim is not a professional consultant, just an enthusiastic amateur, so cannot reply to requests for advice or opinions on specific systems or green investment opportunities. Thank you for your understanding.

Support the channel and get £50 of credit by switching to Octopus Energy using my referral code:
https://share.octopus.energy/cute-qua...

Or buy us a coffee:
https://www.buymeacoffee.com/timandkat