Calculating Solar System Installation Monetary Outcome
Collapse
X
-
-
Com Ed Charges Supply charge 0.06449 Transmission charge 0.01360 distribution facilities charge 0.03926 IL distribution Charge 0.00126 environmental costs 0.00053 Renewable portfolio 0.00502 Zero Emission 0.00195 Energy Efficiency programs 0.00233 Energy Transition assistance 0.00082 Total 0.12926 Comment
-
Yes 1st 2 lines are supply charges, next 2 lines are delivery charges, the remaining taxes and fees.
Com Ed Charges Supply charge 0.06449 Transmission charge 0.01360 distribution facilities charge 0.03926 IL distribution Charge 0.00126 environmental costs 0.00053 Renewable portfolio 0.00502 Zero Emission 0.00195 Energy Efficiency programs 0.00233 Energy Transition assistance 0.00082 Total 0.12926
the bill if covered by my net metering production. The only thing
left to pay each month is
Customer Charge $10.44
Standard Metering Charge $3.40
Bruce RoeComment
-
Thank you for the info. Kind of nice to see what a home constructed to Title 24 standards is capable of.
As for the spreadsheet work, it might not be as bad as you think. Once the spreadsheet template is done and checked, it's actually quite simple, and that's writing as one who only knows enough about spreadsheets to be dangerous and not much more. HelI, I don't even know what a macro is, much less know to write one and I get along just fine. I'm pretty sure a spreadsheet jockey with any facility at all would shake their head and laugh at my simplistic spreadsheet skills, but my stuff seems to agree with what SDG & E sends me and my neighbors. It was much more difficult back in Buffalo and way back in the days before PC's and excel (or LOTUS). Prior to that all my solar and conservation work was done with a TI- 30 until the early '80's when PC's came along. All my programming before then was done for work and done in Fortran IV for technical stuff, or COBAL for engineering economic work. PC's changed everything.
Through it all, I've been tracking and storing POCO rates, and reading/recording all my gas, electricity and water meter readings 1X/day with the good eyeball method and a notebook almost first thing in the A.M. The spreadsheet's the easy part. Making sense of the numbers is the rigorous and fun part.
For you or anyone in SDG & E's service area all that's needed for what you may consider a daunting task is the available green button data from SDG & E and an appropriate T.O.U. rate schedule, both or all of which are readily available - both current and past. Once the spreadsheet templates are done it's a rather easy task to get within a penny or two of an SDG & E bill - I've done it many times for neighbors - to see the impact on billing for various changes in quantity and manner of use (as in time shifting of the type Slinthicum mentioned he had something published about such things), or PV contributions to use reduction and its impact on bills.
All the necessary info is in plain sight for the price of the looking and some spreadsheet work of a couple of hours. It then becomes a plug and chug task and the guesswork is over. It was also a rather satisfying educational experience, but that's just me.
FWIW, for the little work involved to get it right, thorough, rigorous and flexible, I've been a bit surprised and somewhat amazed for years now that no one has published/marketed something just like it or better.
For an easy example, my first statement had 1 day of NEM charges/credits (December 7). I am on the TOU-DR1 Residential plan.
4 kwh on-peak, -14 kwh off-peak, 3 kwh super-off-peak.
My credits applied were $3.02 with $2.93 remaining credits for a total of $5.95.
If I use the December off-peak retail rate of 0.48161, that gives $6.74...too high.
If I use the off-peak UDC rate of 0.39848, I get $5.58 for my 14 hours...too low.
So I'm guessing it is UDC + something else to get the correct credit value. Do you know what specifically I'm supposed to use to multiply with the 14 hours?
bill-1.JPG
bill-2.JPG
Also, I don't quite understand the Baseline Allowance/Adjustment. For the statement above, it says the allowance is 10 kwh. And I read something about 130%, so I would think that would allow around 13 kwh. But the Baseline Adjustment credit was only applied to 4 kwh instead of the 7 that were used from the grid.
Any help you can provide would be appreciated.
Thanks!
Comment
-
I'm not surprised that you are a bit confused as SDG&E billing is quite obtuse. SDG&E should have given you the baseline credit for both the 4 kWh of On Peak usage and the 7 kWh of Super Off-peak usage. That's a mistake they made.
As to the total generation credit I have never been able to make it add up based on what data SDG&E gives you on the bill.Last edited by RichardCullip; 01-15-2023, 02:55 PM.Comment
-
Hi J.P.M., I am new to solar and also have SDG&E. I have been going through my first 2 statements and ALMOST understand how the calculations are made. I'm having a little trouble with how the excess generation is converted to credits. I understand they use the retail rate, but that rate is made of multiple components, and I can't quite seem to get the right combination of components to equal what the statement says.
For an easy example, my first statement had 1 day of NEM charges/credits (December 7). I am on the TOU-DR1 Residential plan.
4 kwh on-peak, -14 kwh off-peak, 3 kwh super-off-peak.
My credits applied were $3.02 with $2.93 remaining credits for a total of $5.95.
If I use the December off-peak retail rate of 0.48161, that gives $6.74...too high.
If I use the off-peak UDC rate of 0.39848, I get $5.58 for my 14 hours...too low.
So I'm guessing it is UDC + something else to get the correct credit value. Do you know what specifically I'm supposed to use to multiply with the 14 hours?
bill-1.JPG
bill-2.JPG
Also, I don't quite understand the Baseline Allowance/Adjustment. For the statement above, it says the allowance is 10 kwh. And I read something about 130%, so I would think that would allow around 13 kwh. But the Baseline Adjustment credit was only applied to 4 kwh instead of the 7 that were used from the grid.
Any help you can provide would be appreciated.
Thanks!
As to why the allowance is only based on 4 kWh I'm at a loss. I'd take a guess that SDG & E would have credited you more but what they may have done was apply as much of the 10 kWh as possible to the on peak for some reason and not the 3 kWh of super off peak. Give them a call. With some professional and courteous persistence, I've found the phone folks courteous. How informed they are seems to be hit/miss to my experience and some friendly persistence is often helpful.
Since the rate sheet that gives daily allowances (CAL P.U.C. 32695-E sheet that goes with the sheets for the DR-TOU tariff sheets that were in effect up to 12/31/2022) is missing for some reason, it's not possible to determine from that prior rate sheet just what the daily allowance was, because that sheet (#32695-E) is no longer available with the prior rate sheets that together are used to calculate a bill. Currently, the basic daily electric winter allowance for those with both gas and electric service for the inland zone in winter is 9.6 kWh/day (see current rate sheet #33080-E), so I'd guess that 10 kWh/day SDG & E is showing on your bill is correct since the daily allowance has been dropping for several years now.
FWIW, although I'm sure it's possible, and others have written that mistakes are possible, I've not seen one in any of my bills or those of my neighbors who have shared their bills with me.
The rub, to me anyway, is that SDG & E is not forthcoming in either explaining how their billing works or more importantly in making their billing understandable to their customers, so explanations are not needed, which, BTY was one of the several mandates the CPUC put forth when the all the T.O.U. mandate B.S. started.Comment
-
What did SDG & E say when you called them ?
As to why the allowance is only based on 4 kWh I'm at a loss. I'd take a guess that SDG & E would have credited you more but what they may have done was apply as much of the 10 kWh as possible to the on peak for some reason and not the 3 kWh of super off peak. Give them a call. With some professional and courteous persistence, I've found the phone folks courteous. How informed they are seems to be hit/miss to my experience and some friendly persistence is often helpful.
Since the rate sheet that gives daily allowances (CAL P.U.C. 32695-E sheet that goes with the sheets for the DR-TOU tariff sheets that were in effect up to 12/31/2022) is missing for some reason, it's not possible to determine from that prior rate sheet just what the daily allowance was, because that sheet (#32695-E) is no longer available with the prior rate sheets that together are used to calculate a bill. Currently, the basic daily electric winter allowance for those with both gas and electric service for the inland zone in winter is 9.6 kWh/day (see current rate sheet #33080-E), so I'd guess that 10 kWh/day SDG & E is showing on your bill is correct since the daily allowance has been dropping for several years now.
FWIW, although I'm sure it's possible, and others have written that mistakes are possible, I've not seen one in any of my bills or those of my neighbors who have shared their bills with me.
The rub, to me anyway, is that SDG & E is not forthcoming in either explaining how their billing works or more importantly in making their billing understandable to their customers, so explanations are not needed, which, BTY was one of the several mandates the CPUC put forth when the all the T.O.U. mandate B.S. started.
J.P.M. , how do you calculate the excess generation credits in your spreadsheet? Which components on the rate sheet do you use to calculate it? UDC? Do you add anything else? Do you subtract anything else?
Thanks.Comment
-
I took another try at calculating SDG&E excess generation credits. This time I came closer than my previous tries. Using the TOU periods that were negative from each monthly bill and multiplying the kWh values by the Total Electric Rate reduced by the Baseline Adjustment Credit I came within 0.17% of what SDG&E has credited me for the last eight months of bills. SDG&E's credits totaled up to $391.15 while my calculations totaled up to $390.49. Close but not exact. I assume there is some rounding errors in there since SDG&E only reports whole numbers for the kWhs in each TOU period in the monthly bill statement.Comment
-
Before writing the post above, I called SDG&E about how they calculate the excess generation credits. I didn't realize at the time that the baseline adjustment didn't seem correct, so I didn't ask about that. I was on hold for an hour before someone finally took my call. And he couldn't explain specifically how the credits were calculated. At first, he thought it was the full retail rate - the adjustment rate, but when I did the calculation on the phone with him, it didn't match. After that he said he wasn't sure how exactly the credits were calculated.
J.P.M. , how do you calculate the excess generation credits in your spreadsheet? Which components on the rate sheet do you use to calculate it? UDC? Do you add anything else? Do you subtract anything else?
Thanks.
1.) Logical answers do exist.
2.) The phone people are almost uniformly well intentioned but often not well informed.
3.) Errors are rare but they do happen.
As far as getting (correct) answers from them, like Calvin Coolidge said, nothing can replace persistence. I note that they did eventually take your call. I try to remember that as a practical matter and reality that listening to customer's bitch is probably not SDG & E's highest priority and staffing many not be good both in quantity and quality. That sucks but that's the way it is.
How I calculate my excess generation:
I calculate excess generation by meter readings and only then compare those readings to what my SDG & E billing says:
1.) I read my electric meter once each day about the same time, usually around 6 A.M. or before.
2.) I do the same with my PV system monitor along with a lot of physical monitoring of the PV system and a Davis Pro II Plus weather station located ~ 4 ft. north and on the same N-S centerline of the array with the anemometer about 50 cm. higher in elevation than the array high point.
3.) I calculate my daily electrical take from and supply to SDG & E and so and gross and net usage from the meter reading and my daily generation from the system monitor data.
4.) The difference is my excess generation or deficit.
My times of meter readings are not 12 midnite like SDG & E uses because I'm usually copping Z's at that time but I don't spend a lot of time worrying about it.
However, and further, I have done the readings in the past at midnight and also at precisely 0600 hrs. on lots of consecutive days and on billing closing dates and have determined through those and other readings that my system monitor is approx. 0.00513 or so higher in what it thinks my system is producing vs. what the SDG & E meter thinks the system is producing. Since the SDG & E meter is what I pay on, I define that as what to use and adjust the system monitor output downward by that amount.
The upshot of all this is that the excess generation I come up with agrees with what the SDG & E billing shows almost always spot on or rarely off by a kWh.
The process for me is a lot easier because I'm on NEM 1.0 and will be on tiered rates for as long as possible.
I also monitor about a dozen or so of cooperative neighbor's systems (although not nearly as rigorously as I monitor my own). While some of them are still on MEM 1.0, most are on NEM 2.0 and all but two are on T.O.U. rates so I do get the see the convoluted billing and try to keep up with the SDG & E shenanigans which is where most of my relatively recent experience with SDG & E and the phone comes from, which is for a different purpose than prior and relatively long ago experience trying to get info from them about prior and historical tariffs. That info is now published but that wasn't always the case. I'd like to think my (and probably mostly other's) efforts and persistence had something to do with the prior tariff sheets being published, but that's history.
As for the UDC info, I only need/use that UDC info to calculate/check the NBC charges for neighbor's on NEM 2.0.Last edited by J.P.M.; 01-16-2023, 12:45 PM.Comment
-
I took another try at calculating SDG&E excess generation credits. This time I came closer than my previous tries. Using the TOU periods that were negative from each monthly bill and multiplying the kWh values by the Total Electric Rate reduced by the Baseline Adjustment Credit I came within 0.17% of what SDG&E has credited me for the last eight months of bills. SDG&E's credits totaled up to $391.15 while my calculations totaled up to $390.49. Close but not exact. I assume there is some rounding errors in there since SDG&E only reports whole numbers for the kWhs in each TOU period in the monthly bill statement.
(total electric rate - baseline credit rate)x(total excess kwh generated)
Or was it
(total electric rate x total excess kwh generated) - total baseline adjustment credit?
In my example above, the December Total Electric Rate for off peak was 0.48161 $/kwh and the Baseline Adjustment Credit was 0.10182 $/kwh.
According to SDG&E, I generated 14 excess off-peak kwh and was given a credit of $5.95 for those hours. I was also given a Baseline adjustment credit of $0.41 for 4 kwh (4x0.10182).
If I take the 14 excess hours and multiply by (0.48161-0.10182), I get: $5.32.
If I take the 14 excess hours and multiply by (0.48161) and then subtract the credit of $0.41, I get: $6.33.
Either way of calculating it, I'm not very close to the $5.95 that SDG&E gave me credit for.Comment
-
RichardCullip Did you calculate it like this?
(total electric rate - baseline credit rate)x(total excess kwh generated)
It's hard to get a good handle on what SDG&E is doing with just a one day bill. Have you tried to match a full month's bill? It does add a complication when your bill spans a rate change as you have to match excess generation in TOU periods with the proper rate for each period.
I never matched a monthly bill exactly. I varied from $0.47 low to $0.25 high but when averaged out over 8 months I was only $0.08 low. That's as good as I could get it.Comment
-
Like this (total electric rate - baseline credit rate)x(total excess kwh generated)
It's hard to get a good handle on what SDG&E is doing with just a one day bill. Have you tried to match a full month's bill? It does add a complication when your bill spans a rate change as you have to match excess generation in TOU periods with the proper rate for each period.
I never matched a monthly bill exactly. I varied from $0.47 low to $0.25 high but when averaged out over 8 months I was only $0.08 low. That's as good as I could get it.
My Applied Credits for the period are $106.38. The previous month's Remaining Credits are $17.37. The current remaining credits are $25.00.
If my understanding is correct, that means the total amount of excess generation I was given credit for the past period is: 106.38 - 17.37 + 25.00 = $114.01
I only had negative totals (excess kWh) in the Off Peak period, and that was 246 kWh.
My baseline allowance is 278 kWh, but for some reason I don't understand, the baseline adjustment credit only uses 173 kWh instead of the 278.
If I use (total electric rate - baseline credit rate)x(total excess kWh generated), that gives (0.55194 - 0.11724) x 246 = $106.94, which is LESS than the $114.01 I got credit for.
So I just have 2 questions about the bill...- How exactly is excess generation converted to dollars for credit? (How do I calculate for myself the $114.01 amount based on the 246 hours of excess generation?)
- Why is the baseline adjustment credit only using 173 kWh instead of the 278 allowance?
Here is my bill:
febBill-1.JPG
febBill-2.JPGComment
-
I just received a bill for an entire month and with no rate changes, so I'm trying to analyze a few things.
My Applied Credits for the period are $106.38. The previous month's Remaining Credits are $17.37. The current remaining credits are $25.00.
If my understanding is correct, that means the total amount of excess generation I was given credit for the past period is: 106.38 - 17.37 + 25.00 = $114.01
I only had negative totals (excess kWh) in the Off Peak period, and that was 246 kWh.
My baseline allowance is 278 kWh, but for some reason I don't understand, the baseline adjustment credit only uses 173 kWh instead of the 278.
If I use (total electric rate - baseline credit rate)x(total excess kWh generated), that gives (0.55194 - 0.11724) x 246 = $106.94, which is LESS than the $114.01 I got credit for.
So I just have 2 questions about the bill...- How exactly is excess generation converted to dollars for credit? (How do I calculate for myself the $114.01 amount based on the 246 hours of excess generation?)
- Why is the baseline adjustment credit only using 173 kWh instead of the 278 allowance?
As to item #2, you only get the baseline credit for the amount of electricity you use from the grid which was 173kWh for your combined Peak and Super Off-Peak total. The baseline adjustment credit is calculated for the electricity you used up to maximum of your base line allowance. You get no baseline adjustment for any electricity above your baseline allowance.
Comment
-
I'm as confused as you are about item #1. You might want to call SDG&E and have them explain how they figure excess generation credits. You might find out that very few folks who answer the phone at SDG&E will have an explanation that makes sense.
As to item #2, you only get the baseline credit for the amount of electricity you use from the grid which was 173kWh for your combined Peak and Super Off-Peak total. The baseline adjustment credit is calculated for the electricity you used up to maximum of your base line allowance. You get no baseline adjustment for any electricity above your baseline allowance.Comment
Comment