HI All,
I have tried to search but can not find what i am looking for…
i hope i can explain correctly what i mean.
The tools maybe are right infront of me but i cant seem to figure it out…
Here it goes:
I want to Check my consumption (kwh) every hour, take the price for that hour and calculate and put somehere!?
Then the next hour, do the same again.
then the next and the next and the next hour… yeah you get it.
In the end of the month i want to be able to see my avarage $ per kwh.
There is more to this than i explained because my electrical company were i buy my electricity from also has something calls “smart charging”
What this means is that i get all power consumed from my Easee wallbox to a 50% discount of my total avarage on the house.
the thing here is that if i use smart charge it would NOT drive my avarage up on the house, it exludeded from the house avarage.
lets say that my house consumed 900kwh to an avarge of 0,90 SEK
and all energy consumed on top of that 900 kwh is my wall box, let say i charge my car with 300kwh
on those 300kwh i will get a 50% discount on what my house consumed which was 0,90.
This will result in that i will pay 0,45 for those 300kwh.
The point of this question is basically that i want to se if the current price is cheaper then 50% of my avarage this month to automatically switch the wallbox from smart chargin to regular charging.
in this way i can “work” my house avarage down by setting the wallbox to NOT smart charge.
so as i explained in the begining i want to store my hour consumtion followed by the current price for that hour if my car i charging on this hour i will also store energy consumed by the wall box to calculate away the consumtion from this sp it does not affetct my house avarage, depending on if the wall box is set to smart charg or to regular.
So my idea is:
Time Used (House) Wall box(smart chaged) Price Result
13:00-14:00 5kwh 10kwh 0,2 1SEK
Time Used (House) Wall box(regular) Price Result
14:00-15:00 5kwh 10kwh 0,1 1,5SEK
In this way i would be able to trigger events depending if the current price is under my avarage of the month so far.
Consumption*Price (include/exlude wall box KWH depending on state of smart or not) every hour
i am thinking to write to some spreadsheet but i dont know how to collect value from that either…
maybe this beacame a messy thread but maybe someone know what i mean who lives in Sweden an has Tibber as electricity provider,