X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SDG&E EV rates - EV-TOU-5 vs EV-TOU-2?

    Back in April we got the PTO from SDG&E to start up our newly installed solar panels. It's a 4kW (DC) system with 12 LG335 panels feeding a SolarEdge Inverter. We are very pleased with the first 6 months of operation. The system design was over-sized for our current electric use since I was anticipating adding an EV to our demand early next year. Budget constraints require waiting a bit for the new car.

    In the mean time I've been brushing up on my spreadsheet skills (used to build big oil production forecasting spreadsheets for Chevron in my previous life) and am attempting to model the impact to our SDG&E bills once we start charging our new EV. Which, if you are curious, will most likely be a Kia Niro PHEV. I'm now at the stage where I need to proof-check my calculations. I would love t have something to compare my results with to see if I've got something seriously wrong or if I'm in the right neighborhood of the answer. I am wondering if there's a tool available that lets me plug in my anticipated net energy values for On-Peak, Off-Peak, Super-Off Peak periods and NBCs. and then generate what the anticipated SDG&E charges under the EV-TOU-5 and EV-TOU-2 rate schedules might be?

    My spreadsheet calculations are currently duplicating our monthly SDG&E bills to within a penny or two so I feel like I can model our electric use and resulting bill under our current TOU-DR rate schedule. It did take me a couple of billing cycles to work out how SDG&E calculates the individual line items in their bill. Not an easy task as those of you that have tried it can probably attest to.

    Thanks in advance.

  • #2
    One short answer to your question is there may be something similar to what you're looking for but I don't know of one on the open market or in the open literature.

    Since I was also looking for what you describe and came up empty, I did it myself. Very broadly and very briefly, the general approach/method I've done/found that works for me is to first find all the information necessary to correctly determine what SDG & E does to get a per kWh price for every kWh they charge me for at any time and in any quantity. Then, I repeat the quest and get a per kWh price they pay me for what I send back to them. Then, I subtract one from the other while keeping in mind things like NBC and such that can be confusing. The devil is in the details.

    What's below is a brief description of some on the details of the way oversimplified description given above..
    It's lengthy but offered on a take it for what it's worth or ignore it basis.

    Still reading ? Take a deep breath.

    I've done what sounds a lot of what sounds like you're describing/looking for. I first did it ~ 2006 after I moved into this house for the old and still used DR tiered rates and after some effort, I got to the penny for all the bills I replicated. I then added solar generation from spreadsheets and programming for PV generation that's similar to what you'll get from SAM or other generation models like PVWatts. That spreadsheet for the generation/billing/use under sch. DR was/is ~ 100 MB and generates a bunch of array and economic parameters besides a net bill.

    I'm not a spreadsheet guru (which may be a giveaway of how simple the spreadsheet portion of the task is), but that was indeed the easier portion of the task.

    To get what I think you're describing/asking about, I used 8,760+ row spreadsheets. That sounds daunting, but for rates, it starts with what's mostly a copy job of 2 different 168 hour weeks - one for summer, one for winter, and the March - April super off peak time period adjustments. Then those weeks are copied a bunch of times.

    Note: If/Before you go further, download your SDG & E pre PV green button usage - the stuff in 15 minute increments. You'll need it for total future usage estimates. Using pre PV acquisition usage is easier than using post PV acquisition green button data which needs to have PV generation added to get total usage. Using post PV acquisition green button data is certainly possible but more PITA steps are required to add solar monitor data to post PV PTO usage data (and any or either way, they'll both be estimates of future use. SDG & E 15 minute data only goes back 15 months for reasons I couldn't get a good answer for. The prior PV acquisition usage data is mostly helpful to get a handle on your usage patterns as well as total usage, particularly for any T.O.U. billing estimates.

    A bigger PITA for me was how to compress (8,760*4) 15 minute usage data cells to 8,760 hourly usage cells, but as I wrote, I'm not a spreadsheet guru. Note too that combing 4 ea. 15 minute intervals into 1 hr. intervals will cost some accuracy for NBC charge calculations. See below for some details of why. For my data, the error from combining the 15 minute data into 1 hr. data was small, and since I'm on NEM 1.0 and also not going on a tiered rate anytime soon, if ever, I live with that error. See below for some details of NBC.

    I'd guess a bigger PITA, and perhaps the biggest source of error for you may be learning all the stuff that SDG & E does that will affect a how a per kWh charge is generated and how a PV generated kWh is valued by the POCO.

    All this isn't conceptually difficult. It's just that there are a lot of little hooks with most of those hooks most likely linked to one another in ways not easy to grasp or apparent, mostly because SDG & E - like most POCO's - has nothing to gain by making it user friendly or easy to understand.

    But, believe it or not, and fortunately, most of the information that's needed can be gleaned from looking at and studying the effective tariff sheets. Google "SDG & E + effective tariffs". Also, Google "SDG & E biling cycle schedule".

    To investigate and estimate what any SDG & E tariff will do to my, or your, electric bill, needed info found on the tariff sheets includes, but is not necessarily limited to:
    - Rates, including total rate and rate components of the total (the rate components or some of them, mostly for NBC adjustments).
    - Minimum daily charge.
    - For T.O.U. tariffs, times of peak, semi, off and super off peak rates.
    - For straight tiered rates (sch. DR) and T.O.U. tariffs that have tiered rates laid over them, daily baseline allowances for whichever one the 4 climate zones you live in for summer/winter as well as for homes with gas service or all electric (no gas service).
    The daily baseline allowance is where the billing period baseline allowance comes from. Billing period baseline allowance = (daily baseline allowance) * (number of days in a period). The billing period baseline allowance is used for the old tiered schedules and all the tiered T.O.U. schedules. At this time tier one usage for any billing period is 130 % of the billing period baseline allowance.
    The min. daily charge is $120/yr/365 days/yr. That's why the min. billing period charge is close to but not equal to $10/billing period but instead ($120/365days/yr.)*(# of billing days/billing cycle).

    Study the rate tariff sheets until you're comfortable with all the terms and how and in what ways all the components can and will interact with one another and other things to influence the price of a kWh going in either direction.

    You will also need the billing schedule. It has a large influence on a bill. Some things to know about billing schedule(s):

    - There are 31 different billing cycles.
    - Your billing cycle number is on p.2 of your bill near the top to the right of your meter number.
    - Each cycle has 12 billing periods. All billing periods are about 30 days, but the number of days doesn't have any relation to the month lengths they cover or any relation to different schedules. Also, the # of billing days and the read date changes for each schedule every year. Aside: I ran an analysis and the only seasonal or annul pattern I might be able to see was a slightly higher number of summer billing periods that had less than the average # of days (which means lower monthly tier one sizes when rates are higher and so (big surprise) slightly more revenue for the POCO.
    - As a practical matter, I picked one year (2006) and used that billing cycle schedule and billing closing dates for all subsequent calcs. Life is not perfect and all this B.S. is nothing if not about estimates. 2006 started on a Sunday, and that made things a bit easier for me for the 168 hour week calcs. You'll understand if/when you get going with all this.

    That's for calculating/generating/back calculating a bill without any net metering involved. FWIW, I checked/debugged my billing algorithm for tiered rates by checking the results against my prior to PV bills with the tariff schedules in effect for the checked periods and found that to be the best/fastest way for me to catch errors in my calcing logic.

    Another thing to keep in mind: All the tariffs change several times/yr, or more. Stay on top of the rates and keep the old rates for reference if you want accuracy for current bills.

    To generate 12 annual bills = an annual cost of electricity from SDG & E for an account that has a NEM 2.0 PV system, I'd suggest you use the PVWatts model for system generation and use the hourly output option for PV generation data.
    See the PVWatts model and read all the help info screens for best use of that model.

    A simplified overview: What I do/did with a spreadsheet to get an annual bill or a bill for any billing period linked to a PV system: For each hour in a year, subtract [(a system's hourly generation, either actual or modeled) * (the per kWh rate charged for that specific hour as calc'ed)] from [(some actual or calculated or estimated hourly total usage)*(the per kWh rate I calculate for that specified hour.]
    Then, I do that 8,760 times, sum the totals for each billing period and for the total year. Note that the credited rate needs to be reduced for NBC. A bit more on that below.

    That method will work for DR-SES calc'ed bills. For other T.O.U. rates that have a tier scheme laid over them, the billing periods come into play as additional adjustments to the hourly rates both charged and credited with both reduced for all tier one usage in a billing period.

    Big note: SDG & E uses civil time for all data. That is, all the times from them are local and daylight saving time if applicable. Most models, including PVWatts DO NOT account for D.S.T.
    I found it easier to adjust the PVWatts or other PV modeling data to D.S.T. when I transferred it to the billing spreadsheet, but other's may find it easier to go the other way. Either way, not doing the DST adjustment will make any results FUBAR.

    On NBC: It's charged on every kWh that SDG & E sends to your residence. That's not every NET kWh over a day, billing period or year. It's EVERY kWh as determined in 15 minute increments. So, as a brief example, if, for any one 15 minute time increment, you use, say, 3 kWh and your PV system produces 1 kWh, you will draw 3 -1 = 2 kWh from the POCO. Now, say the next 15 minute increment has you using 1 kWh and your PV system producing 3 kWh for a net total of 3 - 1 = 2 kWh sent to the POCO. The net for the two 15 minute periods is 2 (- 2) = zero net draw from the POCO for the two 15 minute periods, and that's how the billing would be without NBC. However, WITH NBC, you're charged for every net kWh the POCO sends you over every 15 minute period with a reset every 15 minutes. So, for the example, the first 15 minute period you'd be charged NBC for 2 kWh. For the second 15 minute period you'd be charged no NBC because you didn't draw anything from the POCO. But, because the NBC charges are netted out and reset every 15 minutes, over the total 30 minute period, while you'd have a net zero usage, you'd still be charged for 2 kWh of NBC. That's an example of how and why combining four 15 minute periods into one hour as I do can throw off the NBC calculation. For my rate calcs. when using MEM 2.0, I simply reduce the per kWh credit from SDG & E by the NBC amount for every kWh I send back to the POCO. That's not exactly accurate, but I've found the error is small. The alternative is to use 15 minute increments and 8,760 * 4 = 35,040 row spreadsheets.

    Take all the above for what it's worth to you. The hope is it'll be of some use in your search to find some canned method to help compare rate plans and find the best one for your needs. Or, if you find similar to what I turned up, maybe an aid to doing your own.

    Good luck.

    Comment


    • #3
      Thank you for your detailed explanation. You've given me quite a bit to digest. Some of which I've worked thru already but some new good stuff here. I've been concentrating on figuring out SDG&E billing process and have yet to tackle forecasting solar generation. Thanks for the hint on using PVWatts hourly data. That's a new source of data for me as I've only used monthly data up to now. Hourly data would be a much more accurate way to parse out future solar generation into the TOU of periods.

      On a side note, at this point in time I just realized that I don't need an online tool to check the accuracy of my SDG&E billing model. I just need some kind person to share a few values from a recent, preferably in 2019, monthly SDG&E bill using either the EV-TOU-5 or EV-TOU-2 rates. I would need net energy for the On-Peak, Off-Peak and Super-Off Peak period plus the NBC total for the month and the resulting bill total.

      Comment


      • #4
        Originally posted by RichardCullip View Post
        Thank you for your detailed explanation. You've given me quite a bit to digest. Some of which I've worked thru already but some new good stuff here. I've been concentrating on figuring out SDG&E billing process and have yet to tackle forecasting solar generation. Thanks for the hint on using PVWatts hourly data. That's a new source of data for me as I've only used monthly data up to now. Hourly data would be a much more accurate way to parse out future solar generation into the TOU of periods.

        On a side note, at this point in time I just realized that I don't need an online tool to check the accuracy of my SDG&E billing model. I just need some kind person to share a few values from a recent, preferably in 2019, monthly SDG&E bill using either the EV-TOU-5 or EV-TOU-2 rates. I would need net energy for the On-Peak, Off-Peak and Super-Off Peak period plus the NBC total for the month and the resulting bill total.
        For any use my stuff may have, you're most welcome.

        Using hourly or more granular data may look like a PITA and lengthy task, and it can be, but not necessarily because of the size of the spreadsheet. Rather, it's the necessary details and stuff that one mostly needs to find mostly on their own with most of the discovery by trial/error rather than instruction from informed and knowledgeable sources.

        As I wrote, to figure out the SDG & E billing process, I've found most all of what's required in the sources I mentioned. Download and study them and my bet is you'll be well along the way to reaching your stated goals. Perhaps some helpful soul(s) can provide copies of billing usage.

        I'd respectfully suggest you'll need a spreadsheet that accounts for most or all of the details I mentioned to get a match between the spreadsheet and a bill, including the billing schedule and climate zone data as well as whether or not the supplied data is for a std. or an all electric customer. As I wrote, the devil is in the details. What you don't know or don't account for will screw up the results.

        Comment


        • #5
          Originally posted by RichardCullip View Post
          Back in April we got the PTO from SDG&E to start up our newly installed solar panels. It's a 4kW (DC) system with 12 LG335 panels feeding a SolarEdge Inverter. We are very pleased with the first 6 months of operation. The system design was over-sized for our current electric use since I was anticipating adding an EV to our demand early next year. Budget constraints require waiting a bit for the new car.

          In the mean time I've been brushing up on my spreadsheet skills (used to build big oil production forecasting spreadsheets for Chevron in my previous life) and am attempting to model the impact to our SDG&E bills once we start charging our new EV. Which, if you are curious, will most likely be a Kia Niro PHEV. I'm now at the stage where I need to proof-check my calculations. I would love t have something to compare my results with to see if I've got something seriously wrong or if I'm in the right neighborhood of the answer. I am wondering if there's a tool available that lets me plug in my anticipated net energy values for On-Peak, Off-Peak, Super-Off Peak periods and NBCs. and then generate what the anticipated SDG&E charges under the EV-TOU-5 and EV-TOU-2 rate schedules might be?

          My spreadsheet calculations are currently duplicating our monthly SDG&E bills to within a penny or two so I feel like I can model our electric use and resulting bill under our current TOU-DR rate schedule. It did take me a couple of billing cycles to work out how SDG&E calculates the individual line items in their bill. Not an easy task as those of you that have tried it can probably attest to.

          Thanks in advance.
          Have you been able to successfully replicate the SDG&E billing on a rate-plan that involves both tiers and time-of-use? I cannot do so for TOU-DR-P. I can't figure out the baseline credit---even knowing the baseline credit per kWh I can't figure out how the # of kWh to base the credit on is computed. I.e. I have X in total consumption kWh per month in super-off peak and peak billing periods and -Y in net generation. I do not get X * the tier kWh tier credit (it's less) or any combination of X and Y that I can figure out.

          Back to the EV & solar, this is also my situation. Here's what I think: if you have significant EV and total consumption then EV-TOU-5 is a no-brainer. But there is a minimum hard-money lower limit of $16 plus the non-bypassable charges (depends on usage, but maybe $7-10?) per month that you will owe out of pocket regardless of generation.

          EV-TOU-5 has an enormous rate gap between the off-peak (when solar generates) and the super-off peak (when you charge your car), and this gap extends all year (though March & April some prime solar hours are on super-off-peak). You can earn significant $ credit because of time arbitrage even if kWh generation and consumption is balanced. If you don't care about the ecological footprint you could use this to enjoy extra AC in the summer, particularly before 4pm.

          If your consumption is lower or production higher then I recommend looking at TOU-DR-P, which is what I'm on, if you can manage the critical "reduce your use" days. There were none in 2019 summer and 3 or 4 in 2018 summer. They will always be very hot weekdays and charge an extortionate rate penalty $1.16/kWh for consumption during these hours, 2 to 6pm. But if you can be out of the house and consume almost nothing, these can give you great credit from solar generation which is feasible at those hours, like $10-$15 a RYU day. Furthermore, in the summer outside those RYU days, the 4-9 pm on-peak is only 1c more than offpeak, so you can feel OK about using a fan or AC at 8pm. EV-TOU-* is a large on-peak vs off-peak differential.



          The main advantage otherwise of TOU-DR-P is (a) a good gap of about 10c between off-peak solar generation time and super off peak EV consumption during the 5 summer months. (b) lower real-money monthly charges, there's about $11 in a minimum bill, but unlike EV-TOU-5, the non-by-passable charges count towards that minimum. So excluding the climate credit I see TOU-DR-P at a hard lower limit cost of $125 per year and EV-TOU-5 at about $250-$300 per year, but you'll get lots of credit $$ on EV-TOU-5. All other rate plans I saw (https://www.sdge.com/total-electric-rates) had only about 6c gap of off-peak over super-off peak.

          I think these two rate plans are best for solar + EV users. I'm on TOU-DR-P. For you I might start with that with the EV for a year, and if @ the true-up yearly the hard money cost is more than $250 I would switch to EV-TOU-5. How much do you consume now without EV?
          Last edited by DrChaos; 10-21-2019, 05:08 PM.

          Comment


          • #6
            Originally posted by J.P.M. View Post
            For other T.O.U. rates that have a tier scheme laid over them, the billing periods come into play as additional adjustments to the hourly rates both charged and credited with both reduced for all tier one usage in a billing period.
            What is that adjustment? I can't get it to match any numbers on my bill.

            Comment


            • #7
              Originally posted by DrChaos View Post

              Have you been able to successfully replicate the SDG&E billing on a rate-plan that involves both tiers and time-of-use? I cannot do so for TOU-DR-P.


              I think these two rate plans are best for solar + EV users. I'm on TOU-DR-P. For you I might start with that with the EV for a year, and if @ the true-up yearly the hard money cost is more than $250 I would switch to EV-TOU-5. How much do you consume now without EV?
              A couple of good questions. My current solar output exceeds my demands from SDG&E's grid. I have a decent excess each month, averaging about 250kWh per month for the last 5 months. That will drop once winter arrives. That being said I haven't had to deal with handling the second tier situation as I have always been solidly below the Tier 1 upper limit. This makes my calculation a bit easier.

              I can handle bills that span two months with different rates. With my SDG&E billing schedule I normally get the bill near mid-month. The upcoming Nov bill should be based on 20 days under the Oct the schedule and the remaining 10-11 days under Nov's rate schedule. I will calculate the 20 days of use in Oct under Oct's rate schedule and the other 10-11 days of use under Nov's rate schedule. Add the two sub-totals together and I should match SDGE's total bill.The rate schedule for NBC's is the same for each month so I don't have to split NBCs btwn the two months. I will just use Oct's NBC rate multiplied by the NBC kWhs.

              Of course, in my situation, since I am currently a net generator, my bill will be the monthly minimum so I could take the easy way and just multiple the number of days times the Minimum Rate per Day (currently $0.338 per day) but what's the fun in taking the easy way.

              Comment


              • #8
                Originally posted by DrChaos View Post

                What is that adjustment? I can't get it to match any numbers on my bill.
                I believe this as described below works. HOWEVER, I'm On sch. DR and at this time, all of my neighbors that I cooperate with who have PV are either on sch. DR like me or on DR-SES which is a straight T.O.U schedule. I therefore have not yet checked my method against an actual bill.

                However, I've checked the general method I use for T.O.U. bill generation/checking against some actual DR-SES billing and my method does seem to accurately reproduce an electric bill, except for being a bit off in the NBC adjustment for reasons known and described in a post elsewhere on this thread.

                The general method I use is to consider/treat each of the 8,760 hours in a year by itself, put in the rate for each individual hour, things that affect those rates for each hour, SDG & E delivery for each hour, and solar generation for each hour, and other things including but not limited to things NBC, taxes, all by and for specific hours. A lot of what looks like a huge task is made a lot easier by the fact that most of it is a copy job.

                The hard part for me was (and still is) keeping straight what could be copied from what couldn't be copied from one row/week/billing period/season to another.

                To do it right also forced me to dig really deep into, and to really understand SDG & E and by association a lot of other POCO's billing and tariff methods (but by no means as well for the other POCOs).

                Adding a tiered rate credit for each hour as applicable against a billing period's hourly rate for that hour over part of a variable number of hours per billing period is no more than something else to add that "other things for that hour" list.

                I'll use sch. TOU-DR for example purposes here. The method and logic ought to work for any SDG & E T.O.U. rate tariff that has a tier scheme laid over it.

                I use 8,760 rows on all my rate, use and generation spreadsheets, one for each hour in a year. If you use a different method and logic than I do, what I describe may not and probably won't work for you.

                For T.O.U. tariffs that have a tiered rate laid over the top of them, I first figure the baseline allowance for any billing period as determined by the tariff sheets and my climate zone and that I'm an all electric customer and if that row's date is in summer or winter. See the SDG & E tariff sheets for those details if you have not already done so.

                I then multiply that baseline amount by 1.3 to figure out how big tier one is for that billing period. Note that the baseline amount and so tier one size is different for each billing period.

                Then, for all the electricity that comes in from SDG & E for that billing period, AND until that electricity totals up to the tier one level for that billing period, the per kWh rate for any such hour is reduced by the credit amount shown on the tariff schedule. Per cal P.U.C. sheet No. 32286-E submitted 08/01/2019, effective 11/01/19, that per kWh credit = $0.07571/kWh for summer deliveries and $0.06898/kWh for winter deliveries.

                Once the tier energy allotment is received from SDG & E for that billing period, the tier one credit is removed, controlled by an "if" statement using the tier one allotment for that billing period and the monthly running total delivered electricity as arguments. The tier one credit is then restored at the beginning of the next billing period as appropriate for that billing period.
                Last edited by J.P.M.; 10-22-2019, 08:58 AM. Reason: Added text.

                Comment


                • #9
                  Originally posted by J.P.M. View Post

                  I believe this as described below works. HOWEVER, I'm On sch. DR and at this time, all of my neighbors that I cooperate with who have PV are either on sch. DR like me or on DR-SES which is a straight T.O.U schedule. I therefore have not yet checked my method against an actual bill.

                  However, I've checked the general method I use for T.O.U. bill generation/checking against some actual DR-SES billing and my method does seem to accurately reproduce an electric bill, except for being a bit off in the NBC adjustment for reasons known and described in a post elsewhere on this thread.

                  The general method I use is to consider/treat each of the 8,760 hours in a year by itself, put in the rate for each individual hour, things that affect those rates for each hour, SDG & E delivery for each hour, and solar generation for each hour, and other things including but not limited to things NBC, taxes, all by and for specific hours. A lot of what looks like a huge task is made a lot easier by the fact that most of it is a copy job.

                  The hard part for me was (and still is) keeping straight what could be copied from what couldn't be copied from one row/week/billing period/season to another.

                  To do it right also forced me to dig really deep into, and to really understand SDG & E and by association a lot of other POCO's billing and tariff methods (but by no means as well for the other POCOs).

                  Adding a tiered rate credit for each hour as applicable against a billing period's hourly rate for that hour over part of a variable number of hours per billing period is no more than something else to add that "other things for that hour" list.

                  I'll use sch. TOU-DR for example purposes here. The method and logic ought to work for any SDG & E T.O.U. rate tariff that has a tier scheme laid over it.

                  I use 8,760 rows on all my rate, use and generation spreadsheets, one for each hour in a year. If you use a different method and logic than I do, what I describe may not and probably won't work for you.

                  For T.O.U. tariffs that have a tiered rate laid over the top of them, I first figure the baseline allowance for any billing period as determined by the tariff sheets and my climate zone and that I'm an all electric customer and if that row's date is in summer or winter. See the SDG & E tariff sheets for those details if you have not already done so.

                  I then multiply that baseline amount by 1.3 to figure out how big tier one is for that billing period. Note that the baseline amount and so tier one size is different for each billing period.

                  Then, for all the electricity that comes in from SDG & E for that billing period, AND until that electricity totals up to the tier one level for that billing period, the per kWh rate for any such hour is reduced by the credit amount shown on the tariff schedule. Per cal P.U.C. sheet No. 32286-E submitted 08/01/2019, effective 11/01/19, that per kWh credit = $0.07571/kWh for summer deliveries and $0.06898/kWh for winter deliveries.

                  Once the tier energy allotment is received from SDG & E for that billing period, the tier one credit is removed, controlled by an "if" statement using the tier one allotment for that billing period and the monthly running total delivered electricity as arguments. The tier one credit is then restored at the beginning of the next billing period as appropriate for that billing period.
                  Well, I think that's what I thought too, but it doesn't work for me.

                  I am well under the Tier limit in any accounting. Say I have 150 kWh consumption on super-off-peak. -200 generation on off peak, and maybe net -10 generation on peak.

                  My tier 1 is somewhere around 300 kWh. I would expect the line that said "Baseline Adjustment Credit" to equal 150 * the current BaselineAdjustment Credit per kWh figure on my rate plan, which is TOU-DR-P, and that value is .10404. It never is. It's almost always noticeably lower. It's possible the difference is added to my NEM credits that get rolled over, but I'm not sure. I've made spreadsheets and attempted to replicate the various portions of the bill but this one I never can.

                  I have my new bill today: on peak -7, off peak -252, super off peak 196. So multiplying 196 by .10404 gives $20.39. On my statement it is a credit of $15.19. I can't replicate that from anything in the rate sheet and various combinations of consumption/production, signed and unsigned. My NBCs are $6.14 so that's not the difference either.

                  What is PUC 23286-E btw? I am looking at the rate sheets, and I see no update since 2019-06-01. https://www.sdge.com/total-electric-rates

                  196 * 0.07571 gives $14.89, and not $15.19.

                  Comment


                  • #10
                    Originally posted by DrChaos View Post


                    I have my new bill today: on peak -7, off peak -252, super off peak 196. So multiplying 196 by .10404 gives $20.39. On my statement it is a credit of $15.19. I can't replicate that from anything in the rate sheet and various combinations of consumption/production, signed and unsigned. My NBCs are $6.14 so that's not the difference either....
                    I'm as confused about your bill as you are. I was feeling pretty confident, perhaps even cocky, about my understanding of SDG&E's billing details. Not anymore, as there is something about your current bill that doesn't make sense to me. Like you, I can't make the numbers work.

                    It's probably a curiosity, or coincidence, that the difference btwn the expected generation credit ($20.39) and the actual generation credit ($15.19) works out to be exactly 50kWh times the baseline adjustment of $0.10404. Is it possible that thru the magic accounting process that SDG&E uses that you went over your baseline by 50kWh?

                    Comment


                    • #11
                      Originally posted by RichardCullip View Post

                      I'm as confused about your bill as you are. I was feeling pretty confident, perhaps even cocky, about my understanding of SDG&E's billing details. Not anymore, as there is something about your current bill that doesn't make sense to me. Like you, I can't make the numbers work.

                      It's probably a curiosity, or coincidence, that the difference btwn the expected generation credit ($20.39) and the actual generation credit ($15.19) works out to be exactly 50kWh times the baseline adjustment of $0.10404. Is it possible that thru the magic accounting process that SDG&E uses that you went over your baseline by 50kWh?
                      The amount of the credit always seems to be a round number of kWh times the credit rate, but figuring out that # of kWh is eldritch magic. Is there some prorating of baseline per hour or TOU period?

                      That doesn't make sense and would be against NEM rules that say that NEM is treated like regular billing.

                      My previous bill is +5 on peak, -243 Off Peak, +215 super off peak. Baseline Adjustment Credit is $ -18.52.

                      I would expect (5+215)*.10404 = 22.89

                      18.52 / .10404 = 178.00xxx So they think I got 178 kWh of credit previous month.

                      This month they think I get 146 kWh. Where the heck does that come from? It's been a mystery for a year. TOU periods are the same so if there were a per-period baseline cap, I would have expected the same number.

                      My baseline allowance is 288, and 1.3 times that is 374.4

                      Comment


                      • #12
                        Originally posted by DrChaos View Post

                        Well, I think that's what I thought too, but it doesn't work for me.

                        I am well under the Tier limit in any accounting. Say I have 150 kWh consumption on super-off-peak. -200 generation on off peak, and maybe net -10 generation on peak.

                        My tier 1 is somewhere around 300 kWh. I would expect the line that said "Baseline Adjustment Credit" to equal 150 * the current BaselineAdjustment Credit per kWh figure on my rate plan, which is TOU-DR-P, and that value is .10404. It never is. It's almost always noticeably lower. It's possible the difference is added to my NEM credits that get rolled over, but I'm not sure. I've made spreadsheets and attempted to replicate the various portions of the bill but this one I never can.

                        I have my new bill today: on peak -7, off peak -252, super off peak 196. So multiplying 196 by .10404 gives $20.39. On my statement it is a credit of $15.19. I can't replicate that from anything in the rate sheet and various combinations of consumption/production, signed and unsigned. My NBCs are $6.14 so that's not the difference either.

                        What is PUC 23286-E btw? I am looking at the rate sheets, and I see no update since 2019-06-01. https://www.sdge.com/total-electric-rates

                        196 * 0.07571 gives $14.89, and not $15.19.
                        1.) I'm not trying to duck out on this, but have you called SDG & E and asked them W.T.F. ? Back in the day, I called them so often I got to recognize some of them by voice. Some of the folks were more knowledgeable than others, but if I stayed professional, persistent and most of all friendly, I usually and eventually got an answer or enough information from climbing the chain of command to figure it out.

                        2.) Still not trying to duck out, even though it may look that way, as I wrote a couple of posts back, I've not back calc'ed a tiered T.O.U. bill, but the method I use gets very close and consistent for non tiered T.O.U tariffs except for some NBC diff. That, as I described, I'm pretty sure comes from my combining of 15 minute periods into 1 hour periods for the 8,760 hour spreadsheets I use. I may not be correct on my idea of how to handle a tiered rate credit on a T.O.U. tariff, but If I get a copy of a tiered rate bill, I bet my method can be adjusted to make a tiered rate credit work with a T.O.U. tariff bill.

                        3.) On your question: "What is PUC 23286 btw ?". My apologies. I created an typo error and missed that error when I checked for errors before pulling the trigger. I actually wrote "...PUC sheet No 32286-E...". The correct PUC sheet number is: PUC 33286 - E. To your perhaps larger question, it is one of the tariff sheets you'll find if you Google "SDG & E + Current and Effective Tariffs". That will get you to the SDG & E Tariff Book. Choose schedule TOU-DR. that chosen screen will get you most of the information you'll need to get a per kWh rate for charges and credits on a 15 minute basis, including grandfathered rate times and rates. I say most because you'll still need to calc an NBC rate and know how to apply it to a usage if you don't already know how.

                        The tariff book is my bible for SDG & E rates and the published authority for tariffs and what goes into generating an SDG & E bill. What you're quoting and using, and I again mean no disrespect here, while it has current rates, by itself, it does not have all the information necessary to back calculate a bill, notably how the calculate a base period or T.O.U. times. I guess my questions might be: Do you use the tariff book ? Also, how do you calc a baseline period ? It looks to me that you may not be aware of everything that can effect a bill, or when some of those things may not apply or change. I say (write) that because it looks to me that you are encountering at least some of the same questions and frustrations and missed things SDG & E doesn't tell us or is vague about that I had when I first started doing what you're now doing. FWIW, I finally just bit the bullet, read all the tariff information, quit trying to cut corners and did it the hard way. Then I back calc'ed a bunch of bills, picked up more information SDG & E wouldn't/couldn't d tell me and learned some of the stuff I'm sharing now.

                        It looks to me that we currently approach this task differently. I do 8,760 hours and apply the SDG & E inputs that affect each hourly rate to get a net cost for each hour per kWh they send me, and a net price per kWh for what I send back to SDG & E. I'm pretty sure I've got some error by combining 15 minute increments into 1 hour increments, but it seems the error is small and I think I know (perhaps foolishly) where that error comes from. I get very close for T.O.U. tariffs that do not have a tier component. And, while I'm probably missing or not understanding some of what you're doing, and that's my bad and my ignorance, but it looks to me what you're doing is looking at a bill with the goal of matching what you're charged, and I'm wondering if you have all the information you need to do that and if you do, if you are applying the tariff rules correctly.

                        While I can get very close on a bill to a T.O.U. tariff that doesn't have a tiered rate laid over it, it's also quite likely that I'm under some incorrect assumptions or misunderstandings about how SDG & E handles billing under a T.O.U. tariff that does have a tiered rate laid over it and that makes my method of backing out the credit for tier one usage in any billing period simplistic and incorrect.

                        FWIW, one other respectful suggestion I have for your consideration (if you don't already know about green button data and haven't already done this) is that you download all the 15 minute green button data for a billing period and then spreadsheet it with the per kWh charge and credits with those charges and credits adjusted for everything that the tariff your using ads/subtracts/multiplies/changers to that hourly rate.

                        I honestly look forward to your thoughts and Richard's as well. If you're so inclined post (and/or send to me) an entire bill with name, address and acct. # removed with your climate zone and whether or not you're an all electric user, along with your green button data for the period covered by that bill, and I'll figure it out by adding the option for tiered rate overlay for my T.O.U. billing method..

                        I/WE may need some mod cooperation for that one. (Mods: how about it ?)

                        Respectfully,

                        Comment


                        • #13
                          Like J.P.M., I work with the 15 min interval data available from SDG&E.

                          I download the CSV version which opens up in a Excel spreadsheet just fine. I can match SDG&E's NBC values to the nearest whole number by summing up the 15 min kW data that are greater than zero, ignoring any 15 min period when I was generating more than I was using. The resulting sum needs to be adjusted at the end of the billing period by subtracting any On-Peak, Off-Peak or Super Off-Period totals that are positive. So far, this method of handling the NBC component has let me match the last 5 months of my SDG&E bills to the nearest penny.

                          To make the data easy to handle I do some spreadsheet magic with look-up tables (with Excel's vlookup function), to assign the 15 min data to the proper TOU period. I then use Excel's Pivot Table capabilities to add everything up in a neat summary table. Once I get the proper monthly sums for the On-Peak, Off-Peak, Super Off-Peak and NBCs I apply the proper SDG&E cost for each component resulting in a match to the closest penny.

                          That being said, I'm on the TOU-DR rate schedule and don't have to worry, so far, about any above baseline values since I've been a net producer each month since I turned on my system in April..

                          Comment


                          • #14
                            Originally posted by RichardCullip View Post
                            Like J.P.M., I work with the 15 min interval data available from SDG&E.

                            I download the CSV version which opens up in a Excel spreadsheet just fine. I can match SDG&E's NBC values to the nearest whole number by summing up the 15 min kW data that are greater than zero, ignoring any 15 min period when I was generating more than I was using. The resulting sum needs to be adjusted at the end of the billing period by subtracting any On-Peak, Off-Peak or Super Off-Period totals that are positive. So far, this method of handling the NBC component has let me match the last 5 months of my SDG&E bills to the nearest penny.

                            To make the data easy to handle I do some spreadsheet magic with look-up tables (with Excel's vlookup function), to assign the 15 min data to the proper TOU period. I then use Excel's Pivot Table capabilities to add everything up in a neat summary table. Once I get the proper monthly sums for the On-Peak, Off-Peak, Super Off-Peak and NBCs I apply the proper SDG&E cost for each component resulting in a match to the closest penny.

                            That being said, I'm on the TOU-DR rate schedule and don't have to worry, so far, about any above baseline values since I've been a net producer each month since I turned on my system in April..
                            I just learned something I wish I'd learned sooner. Thank you.

                            Comment


                            • #15
                              Originally posted by J.P.M. View Post

                              I just learned something I wish I'd learned sooner. Thank you.
                              I'm glad you could understand my rambling thru an explanation of how I handle the NBC data. Glad to have helped.

                              It only took me working thru the first 4 months of bills and banging my head against the keyboard when things didn't add up to figure out a method that matches SDG&E's values. The first two months of effort had me convinced that SDG&E was using a random number generator to get their NBC values. Now I have a better understanding, or at least a workable approximation, of what they are doing to get the monthly NBC value.

                              Comment

                              Working...
                              X