Hi All,
I just copy the spreadsheet from someone. Modify with solar and ev car example..
Assumption:
- EV charge offpeak
- Solar production peak at 2PM
- For E-6
- Winter partial peak: 20% for 5 days a week (Since It is 5PM-8PM)
- Winter off peak : the rest
- Summer peak : 60% for 5 days a week (since it starts from 1PM)
- Summer partial-peak : 40% for M-F and 20% for Sat-Sun
- Summer off-peak : the rest
- For EV-A
- Peak: 50% for M-F, 40% for Sat-Sun
- Partial Peak : 50% for M-F
- Off-peak : the rest
Load current last year usage from PG&E. Whatever number I change for having or not having EV car or different charging for EV car, EV-A rate is still better vs E-6 rate. E1 is the worst, so I do not expect to get money from PG&E or over production. My goal is to use all credits.
Since my production is very close to my usage plus EV car, I do not separate month by month calculation because I will be in tier 1 all the time. If you might be in tier 2,3,4 for many month the calculation should be done per month basic and add them together. You just need to replicate 12 times and input only one month per instance.
See the link. You can download and put your usage to try out.
Now, I wonder if I should change to EV-A. Even once I return the car (after the lease), I still be much better with EV-A.
However, one draw back is life style change for EV-A. I have to live with 11PM time ... If I ever think about run more AC, I will be tossed on EV-A plan. May be I will factor it into my next version.
I just copy the spreadsheet from someone. Modify with solar and ev car example..
Assumption:
- EV charge offpeak
- Solar production peak at 2PM
- For E-6
- Winter partial peak: 20% for 5 days a week (Since It is 5PM-8PM)
- Winter off peak : the rest
- Summer peak : 60% for 5 days a week (since it starts from 1PM)
- Summer partial-peak : 40% for M-F and 20% for Sat-Sun
- Summer off-peak : the rest
- For EV-A
- Peak: 50% for M-F, 40% for Sat-Sun
- Partial Peak : 50% for M-F
- Off-peak : the rest
Load current last year usage from PG&E. Whatever number I change for having or not having EV car or different charging for EV car, EV-A rate is still better vs E-6 rate. E1 is the worst, so I do not expect to get money from PG&E or over production. My goal is to use all credits.
Since my production is very close to my usage plus EV car, I do not separate month by month calculation because I will be in tier 1 all the time. If you might be in tier 2,3,4 for many month the calculation should be done per month basic and add them together. You just need to replicate 12 times and input only one month per instance.
See the link. You can download and put your usage to try out.
Now, I wonder if I should change to EV-A. Even once I return the car (after the lease), I still be much better with EV-A.
However, one draw back is life style change for EV-A. I have to live with 11PM time ... If I ever think about run more AC, I will be tossed on EV-A plan. May be I will factor it into my next version.
Comment