I'm not sure I can adequately describe the method I've come up with to evaluate different EV charging situations. However, I'll try my best at writing a brief summary. I first forecast my electric demand, starting with historic SDGE usage (15/60 min data). This is broken down into TOU periods by billing periods using Excel's VLookup capability. This is then summarized into billing period totals via a Pivot Table. Using a similar technique, I forecast solar production from PVWatts into corresponding billing period totals. From there I can subtract the electric demand TOU results from the TOU solar production for each billing period to get the Net Energy for billing purposes. It got a bit tricky to account for the change in TOU periods for weekends, holidays and the months of March and April but a semi-complex VLookup function takes care of that detail.
From there, I can add in the extra electrical demand for charging an EV, or in my anticipated case, a PHEV. For simplicity sakes, I add all the EV demand to the Super Off-Peak category assuming my charging will be done at night.
Finally I can use SDGE rate tables to calculate what a yearly billing total might be. For my situation, I've looked at TOU-DR, EV-TOU-5, EV-TOU-2, TOU-DR-P, DR-SES and TOU-DR1 rate schedules. I'm a late adapter of solar so I'm on NEM2 and have NBCs to account for (that was fun)
For my base case (no EV charging) all of the rate schedules except for EV-TOU-5 come in within a dollar or two of each other at my yearly true up. No surprise there since I'm currently generating a surplus of solar most months and my monthly bills have been at the SDGE minimum. I can use up to 200kWh/month of EV charging before I have to carefully consider which rate plan I need to be on. Above that amount of EV charging the yearly true up bill starts to have some significant differences btwn rate plans. At 300kWh/month of EV charging the TOU-DR-P rate becomes the best choice as long as I can avoid the stiff penalty for using electricity during the few reduce your use days. It takes an EV demand over 400 kWh per month to make the EV-TOU-5 rate plan attractive for me.
The upshot of my analysis is that I'll be staying on my current TOU-DR rate plan when I add a PHEV early next year as I only anticipate adding about 150kWh to my monthly demand. However, in the future, if I ever get over my EV range anxiety and add an EV to my fleet of vehicles I might reach the electrical demand level where a switch to EV-TOU-5 pays off.
Since I built this spreadsheet for my own personal use, it's not built to evaluate a wide range of solar situations. In other words, if you might want to do a similar analysis you are on your own and at the mercy of your specific level of spreadsheet expertise.
From there, I can add in the extra electrical demand for charging an EV, or in my anticipated case, a PHEV. For simplicity sakes, I add all the EV demand to the Super Off-Peak category assuming my charging will be done at night.
Finally I can use SDGE rate tables to calculate what a yearly billing total might be. For my situation, I've looked at TOU-DR, EV-TOU-5, EV-TOU-2, TOU-DR-P, DR-SES and TOU-DR1 rate schedules. I'm a late adapter of solar so I'm on NEM2 and have NBCs to account for (that was fun)
For my base case (no EV charging) all of the rate schedules except for EV-TOU-5 come in within a dollar or two of each other at my yearly true up. No surprise there since I'm currently generating a surplus of solar most months and my monthly bills have been at the SDGE minimum. I can use up to 200kWh/month of EV charging before I have to carefully consider which rate plan I need to be on. Above that amount of EV charging the yearly true up bill starts to have some significant differences btwn rate plans. At 300kWh/month of EV charging the TOU-DR-P rate becomes the best choice as long as I can avoid the stiff penalty for using electricity during the few reduce your use days. It takes an EV demand over 400 kWh per month to make the EV-TOU-5 rate plan attractive for me.
The upshot of my analysis is that I'll be staying on my current TOU-DR rate plan when I add a PHEV early next year as I only anticipate adding about 150kWh to my monthly demand. However, in the future, if I ever get over my EV range anxiety and add an EV to my fleet of vehicles I might reach the electrical demand level where a switch to EV-TOU-5 pays off.
Since I built this spreadsheet for my own personal use, it's not built to evaluate a wide range of solar situations. In other words, if you might want to do a similar analysis you are on your own and at the mercy of your specific level of spreadsheet expertise.
Comment