JohnFoxeSheets
Well-Known Member
- First Name
- John
- Joined
- Jan 29, 2022
- Threads
- 28
- Messages
- 3,415
- Reaction score
- 5,513
- Location
- San Francisco
- Website
- johnfoxesheets.com
- Vehicles
- 2022 Iced Blue Silver Mach E GT
- Occupation
- Retired Engineer
- Thread starter
- #1
This post may apply for all PG&E customers, but especially to those who get their electricity generated by a community power generation company but delivered by PG&E. This is my situation in San Francisco and while PG&E has rate plan calculators that provide comparisons for differing rate plans based on your actual usage, they don't model costs for non-PG&E generated power so their comparisons are much less useful (though frankly they are likely still in the ballpark).
I've attached a spreadsheet and the TOU-C and EV2 rate schedules for your reference/use.
The first sheet of the attached spreadsheet shows my calculations to arrive at the rates for each TOU period and rate plan. The PG&E distribution costs should be pretty much the same for you as they are for me, but you should definitely sanity check your numbers. You should be able to easily plug in your power generation costs in place of my CleanPower SF ones. And of course PG&E makes even just finding the rate schedule is a big PITA. So I've attached both TOU-C and EV2. (Other rates can be found by Googling "PG&E rate schedules".)
To make the comparison based on my actual usage I pulled the hourly usage data for the past year and made sheet two of the attached spreadsheet. This is my actual usage as downloaded off the PG&E website. (Negative numbers are when my solar was producing more than I'm using.) The spreadsheet is a real hack, but it does the job. (If you use above your baseline allotment then my spreadsheets won't work as I didn't take that into account since we only use less than our baseline allotment.) Feel free to adapt the spreadsheet if you'd like. Note that PG&E makes even just getting to the real cost per kWh super challenging and doing so required reverse engineering the rate schedules as well as looking at my actual billed usage.
Disclaimer: All of this is provided AS-IS. I am providing this to be useful, but cannot guarantee that it is error-free nor useful for your situation. In fact while preparing this email I found a significant error which I believe I've resolved, but YMMV!
I've attached a spreadsheet and the TOU-C and EV2 rate schedules for your reference/use.
The first sheet of the attached spreadsheet shows my calculations to arrive at the rates for each TOU period and rate plan. The PG&E distribution costs should be pretty much the same for you as they are for me, but you should definitely sanity check your numbers. You should be able to easily plug in your power generation costs in place of my CleanPower SF ones. And of course PG&E makes even just finding the rate schedule is a big PITA. So I've attached both TOU-C and EV2. (Other rates can be found by Googling "PG&E rate schedules".)
To make the comparison based on my actual usage I pulled the hourly usage data for the past year and made sheet two of the attached spreadsheet. This is my actual usage as downloaded off the PG&E website. (Negative numbers are when my solar was producing more than I'm using.) The spreadsheet is a real hack, but it does the job. (If you use above your baseline allotment then my spreadsheets won't work as I didn't take that into account since we only use less than our baseline allotment.) Feel free to adapt the spreadsheet if you'd like. Note that PG&E makes even just getting to the real cost per kWh super challenging and doing so required reverse engineering the rate schedules as well as looking at my actual billed usage.
Disclaimer: All of this is provided AS-IS. I am providing this to be useful, but cannot guarantee that it is error-free nor useful for your situation. In fact while preparing this email I found a significant error which I believe I've resolved, but YMMV!
Sponsored
