matth
Posts: 82
Joined: Fri May 06, 2011 11:35 am
Delivery Date: 9- 0-2011
Location: Berkeley, CA

PG&E Summer E-9A rates graphic

Sat May 05, 2012 1:24 pm

My household wanted a graphic way to figure out when peak/part peak/off peak hours are, so I made this. It's a bit crude, but it might useful for others as well.

It includes times and a $ multiplier based on the off peak rate, and tier 1, which is where I mostly live.

EDIT: I discovered an error I'd made in weekday evening rates. Fixed now, with better colors.

https://docs.google.com/open?id=0B7axCS ... XZQQVNwa3M" onclick="window.open(this.href);return false;
Last edited by matth on Mon May 07, 2012 8:31 pm, edited 1 time in total.
White, SL/QC
Blink EVSE
Delivery estimate 8/2011
Actual delivery 9/17/11

User avatar
planet4ever
Posts: 4674
Joined: Sat Apr 03, 2010 9:53 pm
Delivery Date: 02 May 2011
Leaf Number: 1537
Location: Morgan Hill, CA, south of San Jose

Re: PG&E Summer E-9A rates graphic

Sat May 05, 2012 5:05 pm

Here is the way I did it in a spreadsheet for our E6 rates. I didn't try to show multipliers, because many months we go past the tier one limit, and sometimes past tier 2.

Image

Ray
End of April 2013: Traded my 2011 SL for a 2013 S with charge pkg.

rclams
Posts: 65
Joined: Thu Sep 30, 2010 5:50 pm

Re: PG&E Summer E-9A rates graphic

Thu May 24, 2012 6:22 pm

planet4ever wrote:Here is the way I did it in a spreadsheet for our E6 rates. I didn't try to show multipliers, because many months we go past the tier one limit, and sometimes past tier 2.

Image

Ray

Thanks, Ray, looks nice.

But remind us again of the Winter-Summer and Summer-Winter transition dates?


Rclams

User avatar
planet4ever
Posts: 4674
Joined: Sat Apr 03, 2010 9:53 pm
Delivery Date: 02 May 2011
Leaf Number: 1537
Location: Morgan Hill, CA, south of San Jose

Re: PG&E Summer E-9A rates graphic

Thu May 24, 2012 11:57 pm

rclams wrote:Thanks, Ray, looks nice. But remind us again of the Winter-Summer and Summer-Winter transition dates?
You know, when I posted that I thought to myself that I should have included that important fact. I believe the transition dates are the same for all PG&E schedules with rates that differ by the time of the year: "Summer" is May 1 to October 31; "Winter" is November 1 to April 30.

As you have undoubtedly realized, all I did was define borders and background colors in a trivial spreadsheet. I happen to use the free Open Office suite, but I expect any modern spreadsheet program would have the same functionality.

Ray
End of April 2013: Traded my 2011 SL for a 2013 S with charge pkg.

DoxyLover
Posts: 517
Joined: Fri Jul 15, 2011 9:52 pm
Delivery Date: 16 Oct 2011
Leaf Number: 9214
Location: San Jose, CA

Re: PG&E Summer E-9A rates graphic

Fri May 25, 2012 11:09 am

Don't forget to shift everything one hour for the few weeks between "traditional" DST start/stop (used by PG&E) and current DST start/stop dates.
2011 Brilliant Silver Leaf SL
Reserved, quoted and ordered July 11, 2011
Delivered October 16, 2011 (Na. Plug-In Day)

User avatar
planet4ever
Posts: 4674
Joined: Sat Apr 03, 2010 9:53 pm
Delivery Date: 02 May 2011
Leaf Number: 1537
Location: Morgan Hill, CA, south of San Jose

Re: PG&E Summer E-9A rates graphic

Fri May 25, 2012 6:30 pm

Right:
The time periods shown above will begin and end one hour later for the period between the second Sunday in March and the first Sunday in April, and for the period between the last Sunday in October and the first Sunday in November.
This isn't so much PG&E's choice as it is the way the GE kV net use meters were programmed when they were built.

Ray
End of April 2013: Traded my 2011 SL for a 2013 S with charge pkg.

User avatar
OrientExpress
Posts: 1586
Joined: Sun Aug 08, 2010 12:22 pm
Delivery Date: 10 May 2011
Leaf Number: 2331
Location: San Jose, Ca

Our PG&E Summe/Winterr E-9A rates graphic

Sat May 26, 2012 7:54 am

Here is the version of the Matrix that our family uses:

Image
2018 LEAF SL
Gun Metalic
Delivery April 10 2018

Prior LEAF:
2014 LEAF SV
Ocean Blue
Delivery May 23 2014
50,000+ miles - all 12 bars - Same range as new - No warranty issues ever!

matth
Posts: 82
Joined: Fri May 06, 2011 11:35 am
Delivery Date: 9- 0-2011
Location: Berkeley, CA

Re: Our PG&E Summe/Winterr E-9A rates graphic

Thu May 31, 2012 10:35 am

OrientExpress wrote:Here is the version of the Matrix that our family uses:

Image
Very attractive layout! I think you have one error though. I believe weekend partial peak moves to off peak at 9:00 PM rather than 10:00 PM.
White, SL/QC
Blink EVSE
Delivery estimate 8/2011
Actual delivery 9/17/11

User avatar
Spies
Posts: 837
Joined: Sat Jul 31, 2010 8:22 am
Delivery Date: 10 Jan 2011
Leaf Number: 0255
Location: Foster City, CA

Re: Our PG&E Summe/Winterr E-9A rates graphic

Thu May 31, 2012 10:45 am

matth wrote:Very attractive layout! I think you have one error though. I believe weekend partial peak moves to off peak at 9:00 PM rather than 10:00 PM.
You are correct for the current E9 schedule and has been in effect since January 1, 2008. From the E9 rate schedule time periods:
Times of the year and times of the day are defined as follows:
Summer (service from May 1 through October 31):
Peak: 2:00 p.m. to 9:00 p.m. Monday through Friday.
Partial-Peak: 7:00 a.m. to 2:00 p.m. AND 9:00 p.m. to 12:00 midnight Monday through Friday, plus 5:00 p.m. to 9:00 p.m. Saturday and Sunday.
Off-Peak: All other hours.
Winter (service from November 1 through April 30):
Partial-Peak: 7:00 a.m. to 12:00 midnight Monday through Friday, and 5:00 p.m. to 9:00 p.m. Saturday and Sunday.
Off-Peak: All other hours.
DAYLIGHT SAVING TIME ADJUSTMENT: The time periods shown above will begin and end one hour later for the period between the second Sunday in March and the first Sunday in April, and for the period between the last Sunday in October and the first Sunday in November.
Green Honda EV Plus 02/1998-12/2003 plate "ZERO CO2" rip, Aptera 2e #726 canceled
Blue Nissan Leaf SL loaded reserved 04/20/2010 ordered 08/31/2010 EVSE Blink #182
CARWINGS Nickname Theres233, should be Spies

User avatar
OrientExpress
Posts: 1586
Joined: Sun Aug 08, 2010 12:22 pm
Delivery Date: 10 May 2011
Leaf Number: 2331
Location: San Jose, Ca

Re: PG&E Summer E-9A rates graphic

Thu May 31, 2012 11:23 am

All corrected, just do a refresh of this page to see the corrected image.

Image
2018 LEAF SL
Gun Metalic
Delivery April 10 2018

Prior LEAF:
2014 LEAF SV
Ocean Blue
Delivery May 23 2014
50,000+ miles - all 12 bars - Same range as new - No warranty issues ever!

Return to “Utilities”