Calculating daily export payments.

My ever-expanding spreadsheet includes daily payment amounts for export via Agile Outgoing. Up until now this data had been coming from the Octopus Watch App. Since we switched to the “E-FLAT2R-ENERGY-LOCAL-NORTHWALES-JUNE-21” tariff, which according to the API “doesn’t exist”, Octopus Watch fails to collect either import or export data.

Does anyone have a handy spreadsheet or other automation that pulls 30 minute exports and 30 minute payment rates and combines them? I have a spreadsheet that I acquired from somewhere that gets my 30 minute imports. No idea how it works but it updates automatically.

Thanks for any ideas