Capacity charge calculation

[utility saver]

I am wondering where I can get the data to calculate the 5 hours with highest PJM and COMED load like shown in this post.   https://groups.google.com/forum/#!topic/comed-rrtp/lMYk5WF0tjY  

I appreciate if anyone can give a pointer. 

[John]

Are you looking for dates/times for 2014 or 2015?

[utility saver]

Yes. Ideally I want to know where they get the data. I know the PJM data is somewhere on the PJM website, but not sure exactly where. I don't know where I can find the data form COMED. 

[John]

I think this is what you are looking for:

http://www.pjm.com/markets-and-operations/ops-analysis/historical-load-data.aspx

[utility saver]

On Thursday, August 6, 2015 at 9:02:17 AM UTC-5, John wrote:

I think this is what you are looking for:

http://www.pjm.com/markets-and-operations/ops-analysis/historical-load-data.aspx

Ah, I figured out. Thanks 

[utility saver]

I still have some questions. 

I assume the data downloaded there is Eastern time, showing the load of the hour ending in that time. For example, the number corresponding to HE17 is the load of hour 16:00 - 17:00 Eastern time. Is this right?

My own load data I download from rrtp.comed.com is central time if I am in Chicago. Is that right?

[Steve Lee]

That's correct.

[ks-man]

I import all of my RRTP data into a spreadsheet so I can compare all my usage and the cost for every hour of the year.  I then search for the highest two prices each month and note my usage during those hours.  Should that be a reasonable way of calculating my capacity charge obligation?  For example I'm seeing the following in 2015

Jan/Feb bill - Max price - $0.401, Second Max - $.364

Jun/Jul bill - Max price - $.335, Second Max - $.150

Jul/Aug bill - Max price - $.247, Second Max - $.215

May/Jun bill - Max price - $213, Second Max - $.194

Feb/Mar bill - Max price - $.212, Second Max - $.193

So from pulling this data I think I've found the highest capacity based on the prices that ComEd charged.  Eventually I'll update my sheet to find the 10 highest hours cumulatively as right now if Jan/Feb had 3 other hours above $.30/kWh I'm ignoring it but generally I think this should be pretty close.  Is my logic flawed by looking at it this way?  Thanks.

[Mark Beckstrom]

Nope

--
You received this message because you are subscribed to the Google Groups "Com*Ed RRTP User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to comed-rrtp+...@googlegroups.com.
To post to this group, send email to comed...@googlegroups.com.
Visit this group at http://groups.google.com/group/comed-rrtp.
For more options, visit https://groups.google.com/d/optout.

[ks-man]

Yeah, I went back to recreate what was done in the other post for the 2013 data.  I'm getting slightly different data though then what was calculated by Randy in this thread: https://groups.google.com/forum/#!topic/comed-rrtp/lMYk5WF0tjY

Are there certain dates or hours that shouldn't be included?  I've included my calculations for the 2013 data and I'm finding data points that Randy didn't include.  Was there a mistake on his end or am I including data points I should be leaving out?  If the error is on my part what am I including that I shouldn't be?  Thanks.

PJM RTO				ComEd						ComEd					PJM
MAX	HOUR (ET)	DATE		MAX	HOUR (ET)	DATE			Hour	Date	Max			Hour	Date	Max
157506.99	17	7/18/2013		22269.016	17	7/18/2013			17	7/18/2013	22269.02			17	7/18/2013	157508.9
154042.39	17	7/17/2013		21801.215	18	7/17/2013			17	7/19/2013	22038.39			15	7/19/2013	156076.7
151418.48	17	7/16/2013		21380.512	18	7/16/2013			18	8/27/2013	21959.53			17	7/17/2013	154044
150312.18	18	7/15/2013		19781.451	16	7/15/2013			18	7/17/2013	21801.22			17	7/16/2013	151420.9
139777.4	16	6/25/2013		19232.264	18	6/27/2013			17	9/10/2013	21572.05			18	7/15/2013	150314.7
136646.96	16	6/24/2013		18538.123	15	7/10/2013			18	8/30/2013	21519.13			17	9/10/2013	143460.8
134626.51	15	7/10/2013		18244.27	19	7/8/2013			18	7/16/2013	21380.51			15	9/11/2013	141477.2
133396.33	16	7/9/2013		17992.271	19	7/9/2013			18	9/9/2013	21251.53			16	6/25/2013	139780.5
133355.55	17	7/8/2013		17701.742	18	6/24/2013			18	8/26/2013	20460.02			18	8/27/2013	137624.8
131616.34	18	7/14/2013		17429.826	18	6/17/2013			16	7/15/2013	19781.45			16	6/24/2013	136648.9

[Mark Beckstrom]

The peak rates are for the "summer" only, forget the other billing periods. From https://hourlypricing.comed.com/faqs/

Capacity Obligation

If you were enrolled in Hourly Pricing or had a smart meter during the previous summer, your Capacity Obligation is based on your individual electricity usage data from that summer. In this case, ComEd calculates your highest electricity demand (adjusted for Transmission and Distribution losses) coincident with the five hours of the summer when the overall PJM System demand was highest (PJM Coincident Demand) (this has historically occurred between 1 p.m. and 5 p.m. on weekdays), and the five hours of the summer when ComEd’s System demand was highest (ComEd Coincident Demand) (these sets of hours may or may not overlap). These two sets of five coincident demands are averaged and adjusted to determine your contribution to the system load, creating your Capacity Obligation.

Your Capacity Obligation is then used to calculate your individual Capacity Charge. So the higher or lower your demand was during those ten peak hours (coincident with the five PJM System peak hours and the five ComEd System peak hours) of last summer, the higher or lower your Capacity Charge will be this year beginning with your June 2015 Billing Period.

[ks-man]

Ok, thanks.

Do you think they are literal so it is only from 6/21 through 9/20 or do you think they are generally referring to summer so perhaps anything within June through August?

[Mark Beckstrom]

From https://hourlypricing.comed.com/year/?date=03250611

Summer includes June through September.

[Rex Irby]

I made a huge error an took these dates as great candidates for 2015 CP numbers - These are 2013 - Wasted one hour of pulling data into these false 2015 dates - thankful that they are false since I had several timer periods with the AC blasting and 2.9 kwh for several hour slots!!

Rex Irby - The Computer Guy
r...@info-trex.com
630.592.9605 cell / text

[ks-man]

I pulled it all in from the 2015 spreadsheet and these are the results I got.  The bolded numbers are the top 5 for the summer months. 

[Larrymdwst]

ComEd posts links to this information on their website, currently on this page https://www.comed.com/customer-service/rates-pricing/retail-electricity-metering/Pages/res-resources.aspx. On the RES Resources tab, under the Guides and Manuals section, there is an Other Information section. This has links to the PJM website where the PJM 5CPs can be found as well as link to a pdf with ComEd's 5CPs. The dates and times for the summer of 2015 are there now, and they do match what was shown.

[ks-man]

Thanks for those links.  The data does match what was on my spreadsheet.  On the RTO I originally did it not just filtering out the summer which is why I bolded the summer ones.  They are entries 1, 3, 4, 5 and 7 on the RTO table and numbers 1-5 on my ComEd table.  Not sure if you were referring to my earlier efforts but here is my updated table again in case you didn't see it.

[Rex Irby]

Has anybody found the new rate for Summer 2016 capacity charge times your obligation KW - We are now at $4.18xx?

[Steve Lee]

I think that ComEd won't publish the summer 2016 rate until next spring, but based on the pjm capacity auction results, I estimate that the capacity charge rate for 2016 will be about $1.84.  Below are the past few years' auction results and capacity charges along with the most recent auction results for the upcoming years.

              RPM Residual Auction
Year        Resource Clearing Price     Capacity Charge
2012                16.46                            .51
2013                 27.73                           .84
2014                125.99                         3.99
2015                136.00                         4.21
2016                  59.37                         1.84 est
2017                 120.00                        3.71 est
2018                 164.77                        5.10 est

[Larrymdwst]

The rate won't be finalized and filed by ComEd until May 2016, since it is based in part on the results of the 3rd incremental auction of PJM's RPM (which takes place next year). This PJM website page (http://www.pjm.com/markets-and-operations/rpm.aspx) has all the information about the PJM Capacity Market (RPM). There usually isn't that much change in price from the base to 3rd incremental auction, but this year is different because PJM held a transitional auction in August (prior to next year's 3rd incremental auction) for the Capacity Performance (CP) Resource. There has been much discussion about the CP Resource and its effects at the Federal/FERC level.

The final MW-Day price for the current period 2015/2016 was $135.81.MW-Day. This resulted in the current $4.18073/kW-Month charge rate. The 2nd incremental auction MW-Day price for the next period 2016/2017 was $60.13, but the CP transitional auction added $38.17/MW-Day to that to arrive at a pre-3rd incremental auction price of $98.29/MW-Day. So if the 3rd incremental auction doesn't change the MW-Day price much, the ComEd Capacity Charge rate should go down somewhat starting in June 2016, but it won't necessarily be just a direct ratio, due to possible changes to the uncollectibles factors, but it should be close.

 
On Tuesday, December 1, 2015 at 4:56:02 PM UTC-6, Rex Irby wrote: