Hi,
My power company has changed solar feed in tariffs as follows
[first five kilowatt hours paid @ 11.5 cents, remaining feed in KWH paid at 5 cents per KWH] .
I have entered daily usage details including total khw fed to the grid but I need a formula to calculate value of feed-in benefit based on the two different values
You need a battery, otherwise use IF.
Say your usage is in C1 =IF(C1<=5,C1*11.5,5*11.5+(C1-5)*5)
Thanks flywire,
I do have a battery and daily solar prioritises feeding the house demand first, followed by replenishing the battery. After the battery reaches 100%, the solar feed goes to the grid. Until recently, we got 14 cents feed in tariff but that will change to the above two stage rate in a few weeks. Thank you very much for taking the time to provide the formula - its greatly appreciated.
TheDuck.