kevin1
March 11, 2019, 6:41pm
1
Are you using a simple TOU electric rate plan from your utility and want closer estimated $$ numbers from Sense ? Here’s a simple example in Excel based on Southern California Edison’s rate structure:
I looked and it doesn’t say, and it’s a mute point now. They are discontinuing this rate plan as of next month, but I am grandfathered in for 2 years.
The good part of the .37 cents during the day is that I am earning from my solar at that rate and not using much power. Although, summer and my AC will change that.
I have attached both summer and winter rates.
I can change my plan, but will wait and see how my billing goes for a few months. I can only change twice a year. And once I move o…
Multi-tab spreadsheet for a single grid and double grid (winter/summer) starting here:
@rex ,
I’ve done a little experimentation, and for me, with my TOU rate schedule setup, a simple yearlong grid, that doesn’t take into account separate weekends/holidays and winter/summer rates, isn’t any more accurate for estimating costs than simply using a single fixed cost based on the average blended cost for an entire year.
Of course it’s pretty straightforward to build a simple grid table, as you describe, in Excel, then use it as a VLOOKUP table to calculate hourly costs. Then you can u…
1-hour data from Jan 01, 2019 to Jan 01, 2020.xlsx (200.6 KB)
2 Likes