Feature Request - Energy breakdown via Tariff slot

3 comments started 2021-12-25 last 2021-12-25
Cloud Portal
S
#1 Seye

I am trying to work ot the economics of adding more storage to my system. I have 8.2Kwh of storage and 4kW PV. When there is sun my grid import is low,maybe a few Kwh each day. When PV is not effective I import much more but I have sucessfully timeshifted many applainces to the 5 hours of cheap power I have ( Octopus Go 5h).. Octopus watch app shows my average price per kWh this winter is still only 8.5p, so only 3p more than the offpeak rate. It will be more next year when my tariff changes, it is the gap between offpeak and peak thats relevent here for the economics.

With the current portal I cannot see,other than va the graph for a specific day, when power was imported
If an additional breakdown on the 'grid in" was available that differentated between peak and off-peak that would be really useful I would use tht to see how many kWh are imported at peak rate every day. I would then use that over the year to determine if there is a value i adding further storage capacity. As another 8.2kWh battery is over £2k, the economics over the year are important to understand . ( There is little value in the summer, but potentially a significant value in the winter )

I think this would be useful to many people. I am happy to type in the tariff details so the time ranges and rates are user provided so not requiring complex deveopment to drag them in from suppliers, that may not have APIs.

Ultimatly I a lookng to calculate return on investment and determine years for payback ( which will be reducng as the gap between peak and off peak rates rise)

This request is to just exposing the data so I can make an informed decsion. It is not requesting any interprition of that data or recommedations based upon it.

( BTW I am doing this myself locally at present , it makes very interesting reading)

C
#2 Chanced

on the beta portal, on the inverter tab, choose grid data. This displays the amount imported/exported to the grid on a five minute interval - is that what you are looking for? BTW this can be exported to numbers/excel to be analysed over time.
Merry Christmas!

S
#3 Seye

Chanced
yes, you can do that. Thankyou for the suggestion. There are already APIs available to automatically download data too https://kb.givenergy.cloud/article.php?id=51&oid=8
The chart.api provides the data. Its the older style session based API but does work

I already have all the data in an InfluxDB. What I am suggesting is a feature that presents the data in a way that doesnt need local resources and computing knowledge to achieve.
Exporting the data from the system data would require reprocessing every time in a database or spreadsheet. Thats is very doable but I really dont want to spend time doing that if I can avoid it. APIs enable my influx to be constantly updated so I do have ongoing analytics without intervention.

What I do is:
1) store the readings from GE.
2) determine an attrubute for which the tariff ( peak or off peak ) applies to the reading and store that on the row.
3) Group the data by timeperiod ( day/week/month/year). I present Grid_Import subdivided by tariff ( Peak and Off_Peak), Export, and PV_Opportunity = (import@peak rate - export ). Any presentation tool that can access the datbase eg Excel, Grafana, PowerBI etc can do this provided the attributes are exposed

So what I am suggesting as an MVP exposing the additional tariff related attributes as part of the standard offering so that its avaialble to all easily, without having to undertaken lots of work.
Later down the line the visualisatons I describe would be great, but not essential if the data is easily accessible

I have already used this methodology to work out the payback period for an additional 8.2kW battery using my actual consumption at what time of day, and real PV generation ( export is the key as that is what would charge a battery ). That equation also requires knowledge of the off peak period length and inverter charging capacity as too much storage can't be charged from the grid within the "off-peak" period as there is a limit to charge speed. That is possible to resolve by the addition of another inverter, which in turn adds more costs.
yes, the full storage capacity can reached from PV in the summer but at that time of year the capacity generally isn't required. ( so a very complex equation )

Due to the energy deal I am on currently, payback is a very long time as I only benefit from additional capacity for about 4 or 5 months a year, only significantly for 3. That is not what I expected before I did the maths.
Newer tariffs change the equation very significantly !!

I am happy to share my logic as my Christmas present to the community if anyone is interested