waitingforaleaf
Well-known member
I've spent a decent amount of time editing a rate calculator (originally written by Martin Eberhard) for estimating your electricity rates. Since there's plenty of customization available, it is a great tool for seeing what your rates would be under E1, E6, E7, E9A, or E9B.
The original file that I received had errors with regards to calculations for the Utility User's Tax and E9B tier calculations. Based upon my calculations, I believe that I have fixed the utility user's tax calculation. For the E9B calculations, I believe that the modifications I've made will allow E9B to be accurate IF EV charging is calculated for ONLY off-peak hours. I screwed up the calculation for partial-peak and peak charging (but don't have the time or need to fix it), so the numbers get vastly inaccurate if charging occurs during those periods (keep this in mind if you put in >36000 miles per year into the calculator as this will "force" you to charge in partial peak and skew the results into inaccuracy).
I've also made a second worksheet that includes the proposed rate changes to E-9 from Advice 3910-E, so you can do side-by-side comparisons for how the proposed changes will affect your bill. I would have loved to integrate them into a single worksheet, but the modifications to the worksheet are beyond the amount of time I would want to spend in doing so.
In any case, if anyone is interested in these two documents, feel free to shoot me a PM with your e-mail address, since I haven't figured out how to attach those documents to a forum post. I can also forward my written letter of protest for people to peruse or use as a template should you wish to send a letter of your own.
The original file that I received had errors with regards to calculations for the Utility User's Tax and E9B tier calculations. Based upon my calculations, I believe that I have fixed the utility user's tax calculation. For the E9B calculations, I believe that the modifications I've made will allow E9B to be accurate IF EV charging is calculated for ONLY off-peak hours. I screwed up the calculation for partial-peak and peak charging (but don't have the time or need to fix it), so the numbers get vastly inaccurate if charging occurs during those periods (keep this in mind if you put in >36000 miles per year into the calculator as this will "force" you to charge in partial peak and skew the results into inaccuracy).
I've also made a second worksheet that includes the proposed rate changes to E-9 from Advice 3910-E, so you can do side-by-side comparisons for how the proposed changes will affect your bill. I would have loved to integrate them into a single worksheet, but the modifications to the worksheet are beyond the amount of time I would want to spend in doing so.
In any case, if anyone is interested in these two documents, feel free to shoot me a PM with your e-mail address, since I haven't figured out how to attach those documents to a forum post. I can also forward my written letter of protest for people to peruse or use as a template should you wish to send a letter of your own.