Naperville_ComEd_EIA-861_Sales_Ult_Cust.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB
1	Notes: Detail data below extracted from U.S. Energy Information Administration (EIA) Annual Electric Power Industry Report, Form EIA-861 detailed data files' spreadsheet: Sales_Ult_Cust_yyyy.xlsx (for years 2012 thru 2023) Downloaded on 11/27/2024 from: https://www.eia.gov/electricity/data/eia861/ Constellation NewEnergy chosen as largest ARES provider based on total MWhs sold
2	Utility Characteristics									RESIDENTIAL				COMMERCIAL				INDUSTRIAL				TRANSPORTATION			TOTAL
3										Revenues	Sales	Customers	Residential	Revenues	Sales	Customers	Commercial	Revenues	Sales	Customers	Industrial	Revenues	Sales	Customers	Revenues	Sales	Customers	Total
4	Data Year	Utility Number	Utility Name	Part	Service Type	Data Type O = Observed I = Imputed	State	Ownership	BA Code	Thousand Dollars	Megawatthours	Count	Calculated Avg Price $ per kWh	Thousand Dollars	Megawatthours	Count	Calculated Avg Price $ per kWh	Thousand Dollars	Megawatthours	Count	Calculated Avg Price $ per kWh	Thousand Dollars	Megawatthours	Count	Thousand Dollars	Megawatthours	Count	Calculated Avg Price $ per kWh

5
6	2012	13208	City of Naperville - (IL)	A	Bundled	O	IL	Municipal		59,781.3	588,351	51,278	0.1016	57,081.4	629,980	6,012	0.0906	11,699.1	169,290	10	0.0691	.	.	.	128,561.8	1,387,621	57,300	0.0926
7	2012	4110	Commonwealth Edison Co	A	Bundled	O	IL	Investor Owned		2,685,125.6	21,724,278	2,655,604	0.1236	880,222.2	9,244,133	227,632	0.0952	39,793.9	682,555	115	0.0583	0.0	0	0	3,605,141.7	31,650,966	2,883,351	0.1139
8	2012	4110	Commonwealth Edison Co	C	Delivery	O	IL	Investor Owned		293,240.2	6,803,935	800,919	0.0431	468,785.0	24,027,472	142,694	0.0195	345,822.0	26,960,474	1,884	0.0128	6,442.5	534,184	2	1,114,289.7	58,326,065	945,499	0.0191
9	2012	13374	Constellation NewEnergy, Inc	B	Energy	O	IL	Retail Power Marketer		38,702.6	628,346	68,443	0.0616	906,063.9	18,074,330	4,228	0.0501	179,372.7	3,584,569	581	0.0500	37,958.5	781,822	3	1,162,097.7	23,069,067	73,255	0.0504
10	2012		ComEd Delivery + Constellation NewEnergy (Avg Price)										0.1047				0.0696				0.0629							0.0695
11	2012		ComEd Delivery % of Total ComEd (Bundled + Delivery)							9.8%	23.8%	23.2%		34.8%	72.2%	38.5%		89.7%	97.5%	94.2%		100.0%	100.0%	100.0%	23.6%	64.8%	24.7%
12
13	2013	13208	City of Naperville - (IL)	A	Bundled	O	IL	Municipal	PJM	56,233.6	526,181	51,758	0.1069	57,366.6	600,942	6,108	0.0955	18,156.0	234,630	10	0.0774	.	.	.	131,756.2	1,361,753	57,876	0.0968
14	2013	4110	Commonwealth Edison Co	A	Bundled	O	IL	Investor Owned	PJM	1,076,464.0	9,548,453	1,160,932	0.1127	673,057.4	7,883,890	149,508	0.0854	48,701.8	862,997	125	0.0564	0.0	0	0	1,798,223.2	18,295,340	1,310,565	0.0983
15	2013	4110	Commonwealth Edison Co	C	Delivery	O	IL	Investor Owned	PJM	854,040.2	18,251,809	2,308,028	0.0468	542,033.9	25,222,091	221,739	0.0215	346,059.7	26,821,488	1,865	0.0129	7,105.4	553,734	2	1,749,239.2	70,849,122	2,531,634	0.0247
16	2013	13374	Constellation NewEnergy, Inc	B	Energy	O	IL	Retail Power Marketer	PJM	47,792.0	869,767	94,650	0.0549	668,487.0	12,641,305	4,545	0.0529	254,849.0	5,509,689	716	0.0463	29,072.0	708,539	3	1,000,200.0	19,729,300	99,914	0.0507
17	2013		ComEd Delivery + Constellation NewEnergy (Avg Price)										0.1017				0.0744				0.0592							0.0754
18	2013		ComEd Delivery % of Total ComEd (Bundled + Delivery)							44.2%	65.7%	66.5%		44.6%	76.2%	59.7%		87.7%	96.9%	93.7%		100.0%	100.0%	100.0%	49.3%	79.5%	65.9%
19
20	2014	13208	City of Naperville - (IL)	A	Bundled	O	IL	Municipal	PJM	57,071.4	534,716	52,411	0.1067	70,434.0	795,969	6,273	0.0885	5,856.5	68,922	9	0.0850	.	.	.	133,361.9	1,399,607	58,693	0.0953
21	2014	4110	Commonwealth Edison Co	A	Bundled	O	IL	Investor Owned	PJM	1,115,425.3	9,114,941	1,187,567	0.1224	775,004.5	7,890,441	149,280	0.0982	79,885.6	1,056,386	134	0.0756	0.0	0	0	1,970,315.4	18,061,768	1,336,981	0.1091
22	2014	4110	Commonwealth Edison Co	C	Delivery	O	IL	Investor Owned	PJM	1,007,238.6	18,114,700	2,302,008	0.0556	625,820.6	25,051,368	223,191	0.0250	369,416.6	26,791,079	1,877	0.0138	7,063.5	561,728	2	2,009,539.3	70,518,875	2,527,078	0.0285
23	2014	13374	Constellation NewEnergy, Inc	B	Energy	O	IL	Retail Power Marketer	PJM	46,187.2	758,200	80,553	0.0609	372,857.6	5,585,152	2,105	0.0668	156,185.2	2,991,599	311	0.0522	34,408.5	612,302	1	609,638.5	9,947,253	82,970	0.0613
24	2014		ComEd Delivery + Constellation NewEnergy (Avg Price)										0.1165				0.0917				0.0660							0.0898
25	2014		ComEd Delivery % of Total ComEd (Bundled + Delivery)							47.5%	66.5%	66.0%		44.7%	76.0%	59.9%		82.2%	96.2%	93.3%		100.0%	100.0%	100.0%	50.5%	79.6%	65.4%
26
27	2015	13208	City of Naperville - (IL)	A	Bundled	O	IL	Municipal	PJM	56,738.7	507,809	52,627	0.1117	73,744.3	763,174	6,386	0.0966	5,965.4	71,559	9	0.0834	.	.	.	136,448.4	1,342,542	59,022	0.1016
28	2015	4110	Commonwealth Edison Co	A	Bundled	O	IL	Investor Owned	PJM	1,555,163.7	11,806,478	1,666,929	0.1317	765,118.4	7,749,547	169,515	0.0987	60,769.1	952,290	127	0.0638	0.0	0	0	2,381,051.2	20,508,315	1,836,571	0.1161
29	2015	4110	Commonwealth Edison Co	C	Delivery	O	IL	Investor Owned	PJM	889,896.3	14,689,551	1,853,400	0.0606	651,447.3	24,771,920	204,828	0.0263	397,419.7	26,257,317	1,853	0.0151	7,149.6	504,457	2	1,945,912.9	66,223,245	2,060,083	0.0294
30	2015	13374	Constellation NewEnergy, Inc	B	Energy	O	IL	Retail Power Marketer	PJM	148,906.8	2,117,576	234,063	0.0703	650,093.0	11,145,015	4,403	0.0583	291,806.5	5,614,287	531	0.0520	37,739.1	713,004	2	1,128,545.4	19,589,882	238,999	0.0576
31	2015		ComEd Delivery + Constellation Energy (Avg Price)										0.1309				0.0846				0.0671							0.0870
32	2015		ComEd Delivery % of Total ComEd (Bundled + Delivery)							36.4%	55.4%	52.6%		46.0%	76.2%	54.7%		86.7%	96.5%	93.6%		100.0%	100.0%	100.0%	45.0%	76.4%	52.9%
33
34	2016	13208	City of Naperville - (IL)	A	Bundled	O	IL	Municipal	PJM	65,303.8	534,759	52,824	0.1221	81,804.4	777,741	6,264	0.1052	6,637.3	72,931	9	0.0910	.	.	.	153,745.5	1,385,431	59,097	0.1110
35	2016	4110	Commonwealth Edison Co	A	Bundled	O	IL	Investor Owned	PJM	1,929,294.0	15,764,909	2,178,076	0.1224	735,693.1	8,093,438	190,954	0.0909	65,723.7	1,234,642	138	0.0532	0.0	0	0	2,730,710.8	25,092,989	2,369,168	0.1088
36	2016	4110	Commonwealth Edison Co	C	Delivery	O	IL	Investor Owned	PJM	673,303.1	12,024,728	1,396,443	0.0560	620,678.5	24,678,184	186,446	0.0252	396,102.6	26,607,299	1,848	0.0149	7,167.7	500,212	2	1,697,251.9	63,810,423	1,584,739	0.0266
37	2016	13374	Constellation NewEnergy, Inc	B	Energy	O	IL	Retail Power Marketer	PJM	52,577.0	748,334	75,378	0.0703	652,382.0	12,040,760	5,457	0.0542	240,031.0	4,689,829	524	0.0512	26,405.0	510,032	1	971,395.0	17,988,955	81,360	0.0540
38	2016		ComEd Delivery + Constellation Energy (Avg Price)										0.1263				0.0793				0.0661							0.0806
39	2016		ComEd Delivery % of Total ComEd (Bundled + Delivery)							25.9%	43.3%	39.1%		45.8%	75.3%	49.4%		85.8%	95.6%	93.1%		100.0%	100.0%	100.0%	38.3%	71.8%	40.1%
40
41	2017	13208	City of Naperville - (IL)	A	Bundled	O	IL	Municipal	PJM	65,557.3	502,468	53,060	0.1305	82,912.5	745,535	6,355	0.1112	6,664.5	69,876	9	0.0954	.	.	.	155,134.3	1,317,879	59,424	0.1177
42	2017	4110	Commonwealth Edison Co	A	Bundled	O	IL	Investor Owned	PJM	2,129,208.7	16,504,207	2,388,950	0.1290	779,604.7	8,227,370	200,918	0.0948	60,233.1	1,051,732	119	0.0573	0.0	0	0	2,969,046.5	25,783,309	2,589,987	0.1152
43	2017	4110	Commonwealth Edison Co	C	Delivery	O	IL	Investor Owned	PJM	587,108.6	9,788,077	1,219,404	0.0600	618,070.3	23,888,956	180,098	0.0259	394,322.7	26,415,223	1,867	0.0149	6,765.8	502,102	2	1,606,267.4	60,594,358	1,401,371	0.0265
44	2017	13374	Constellation NewEnergy, Inc	B	Energy	O	IL	Retail Power Marketer	PJM	72,686.0	1,051,279	113,207	0.0691	785,650.0	14,708,647	11,086	0.0534	231,073.0	4,564,399	531	0.0506	5,595.0	113,516	1	1,095,004.0	20,437,841	124,825	0.0536
45	2017		ComEd Delivery + Constellation NewEnergy (Avg Price)										0.1291				0.0793				0.0656							0.0801
46	2017		ComEd Delivery % of Total ComEd (Bundled + Delivery)							21.6%	37.2%	33.8%		44.2%	74.4%	47.3%		86.7%	96.2%	94.0%		100.0%	100.0%	100.0%	35.1%	70.2%	35.1%
47
48	2018	13208	City of Naperville - (IL)	A	Bundled	O	IL	Municipal	PJM	71,631.4	528,460	53,274	0.1355	83,429.6	737,945	6,401	0.1131	7,742.3	69,479	8	0.1114	.	.	.	162,803.3	1,335,884	59,683	0.1219
49	2018	4110	Commonwealth Edison Co	A	Bundled	O	IL	Investor Owned	PJM	2,363,667.6	18,130,982	2,454,905	0.1304	874,041.9	8,580,735	205,964	0.1019	73,904.4	1,071,695	128	0.0690	0.0	0	0	3,311,613.9	27,783,412	2,660,997	0.1192
50	2018	4110	Commonwealth Edison Co	C	Delivery	O	IL	Investor Owned	PJM	577,535.1	10,060,355	1,180,206	0.0574	652,885.1	23,970,052	178,926	0.0272	463,506.9	27,093,928	1,860	0.0171	7,800.4	532,183	2	1,701,727.5	61,656,518	1,360,994	0.0276
51	2018	13374	Constellation NewEnergy, Inc	B	Energy	O	IL	Retail Power Marketer	PJM	101,417.7	1,463,396	146,559	0.0693	1,077,425.8	20,020,484	60,601	0.0538	223,885.8	4,331,491	2,329	0.0517	0.0	0	0	1,402,729.3	25,815,371	209,489	0.0543
52	2018		ComEd Delivery + Constellation NewEnergy (Avg Price)										0.1267				0.0811				0.0688							0.0819
53	2018		ComEd Delivery % of Total ComEd (Bundled + Delivery)							19.6%	35.7%	32.5%		42.8%	73.6%	46.5%		86.2%	96.2%	93.6%		100.0%	100.0%	100.0%	33.9%	68.9%	33.8%
54
55	2019	13208	City of Naperville - (IL)	A	Bundled	O	IL	Municipal	PJM	66,132.7	500,777	54,231	0.1321	77,234.7	709,682	6,429	0.1088	7,245.3	65,019	8	0.1114	.	.	.	150,612.7	1,275,478	60,668	0.1181
56	2019	4110	Commonwealth Edison Co	A	Bundled	O	IL	Investor Owned	PJM	2,343,491.1	17,616,341	2,520,161	0.1330	838,165.3	8,415,392	210,284	0.0996	54,100.8	822,782	143	0.0658	0.0	0	0	3,235,757.2	26,854,515	2,730,588	0.1205
57	2019	4110	Commonwealth Edison Co	C	Delivery	O	IL	Investor Owned	PJM	572,201.4	9,196,718	1,137,735	0.0622	662,901.0	23,169,835	178,146	0.0286	485,970.4	26,834,839	1,826	0.0181	9,139.0	550,907	2	1,730,211.8	59,752,299	1,317,709	0.0290
58	2019	13374	Constellation NewEnergy, Inc	B	Energy	O	IL	Retail Power Marketer	PJM	132,446.9	1,901,250	212,826	0.0697	1,043,262.3	19,997,008	71,234	0.0522	189,525.4	3,780,685	2,285	0.0501	0.0	0	0	1,365,234.6	25,678,943	286,345	0.0532
59	2019		ComEd Delivery + Constellation NewEnergy (Avg Price)										0.1319				0.0808				0.0682							0.0821
60	2019		ComEd Delivery % of Total ComEd (Bundled + Delivery)							19.6%	34.3%	31.1%		44.2%	73.4%	45.9%		90.0%	97.0%	92.7%		100.0%	100.0%	100.0%	34.8%	69.0%	32.5%
61
62	2020	13208	City of Naperville - (IL)	A	Bundled	O	IL	Municipal	PJM	70,482.8	525,365	54,483	0.1342	74,783.6	669,464	6,467	0.1117	7,241.9	63,025	8	0.1149	.	.	.	152,508.3	1,257,854	60,958	0.1212
63	2020	4110	Commonwealth Edison Co	A	Bundled	O	IL	Investor Owned	PJM	2,547,676.2	19,250,047	2,637,056	0.1323	786,494.6	7,841,717	215,127	0.1003	54,721.4	858,862	174	0.0637	0.0	0	0	3,388,892.2	27,950,626	2,852,357	0.1212
64	2020	4110	Commonwealth Edison Co	C	Delivery	O	IL	Investor Owned	PJM	543,084.6	8,783,712	1,044,873	0.0618	651,184.3	21,369,962	176,067	0.0305	459,610.9	25,020,423	1,780	0.0184	6,809.7	433,045	2	1,660,689.5	55,607,142	1,222,722	0.0299
65	2020	13374	Constellation NewEnergy, Inc	B	Energy	O	IL	Retail Power Marketer	PJM	86,400.5	1,123,913	123,748	0.0769	792,680.1	14,830,590	52,803	0.0534	102,384.5	2,018,471	875	0.0507	0.0	0	0	981,465.1	17,972,974	177,426	0.0546
66	2020		ComEd Delivery + Constellation NewEnergy (Avg Price)										0.1387				0.0839				0.0691							0.0845
67	2020		ComEd Delivery % of Total ComEd (Bundled + Delivery)							17.6%	31.3%	28.4%		45.3%	73.2%	45.0%		89.4%	96.7%	91.1%		100.0%	100.0%	100.0%	32.9%	66.5%	30.0%
68
69	2021	13208	City of Naperville - (IL)	A	Bundled	O	IL	Municipal	PJM	70,367.7	537,789	54,868	0.1308	72,036.5	673,565	6,775	0.1069	7,416.7	69,430	8	0.1068	.	.	.	149,820.9	1,280,784	61,651	0.1170
70	2021	4110	Commonwealth Edison Co	A	Bundled	O	IL	Investor Owned	PJM	2,753,093.9	20,413,030	2,778,125	0.1349	916,924.7	8,203,678	223,595	0.1118	64,897.3	779,756	150	0.0832	0.0	0	0	3,734,915.9	29,396,464	3,001,870	0.1271
71	2021	4110	Commonwealth Edison Co	C	Delivery	O	IL	Investor Owned	PJM	479,999.3	7,930,951	921,290	0.0605	692,893.7	22,004,728	170,387	0.0315	493,837.6	25,640,230	1,713	0.0193	6,274.2	437,641	2	1,673,004.8	56,013,550	1,093,392	0.0299
72	2021	13374	Constellation NewEnergy, Inc	B	Energy	O	IL	Retail Power Marketer	PJM	61,890.1	798,775	86,718	0.0775	778,953.9	14,224,372	48,120	0.0548	90,959.5	1,745,751	697	0.0521	0.0	0	0	931,803.5	16,768,898	135,535	0.0556
73	2021		ComEd Delivery + Constellation NewEnergy (Avg Price)										0.1380				0.0863				0.0714							0.0854
74	2021		ComEd Delivery % of Total ComEd (Bundled + Delivery)							14.8%	28.0%	24.9%		43.0%	72.8%	43.2%		88.4%	97.0%	91.9%		100.0%	100.0%	100.0%	30.9%	65.6%	26.7%
75
76	2022	13208	City of Naperville - (IL)	A	Bundled	O	IL	Municipal	PJM	67,323.8	517,337	55,329	0.1301	69,500.4	670,062	6,763	0.1037	7,273.0	68,085	8	0.1068	.	.	.	144,097.2	1,255,484	62,100	0.1148
77	2022	4110	Commonwealth Edison Co	A	Bundled	O	IL	Investor Owned	PJM	3,633,470.3	22,049,120	3,006,833	0.1648	1,170,613.8	8,445,118	235,147	0.1386	93,267.7	902,236	136	0.1034	1,458.7	18,518	1	4,898,810.5	31,414,992	3,242,117	0.1559
78	2022	4110	Commonwealth Edison Co	C	Delivery	O	IL	Investor Owned	PJM	374,448.8	5,769,862	706,922	0.0649	769,486.2	21,792,097	160,383	0.0353	569,565.0	26,002,061	1,751	0.0219	8,157.3	420,266	2	1,721,657.3	53,984,286	869,058	0.0319
79	2022	13374	Constellation NewEnergy, Inc	B	Energy	O	IL	Retail Power Marketer	PJM	27,089.9	293,052	35,455	0.0924	837,387.1	13,779,816	44,169	0.0608	87,565.2	1,578,657	617	0.0555	0.0	0	0	952,042.2	15,651,525	80,241	0.0608
80	2022		ComEd Delivery + Constellation NewEnergy (Avg Price)										0.1573				0.0961				0.0774							0.0927
81	2022		ComEd Delivery % of Total ComEd (Bundled + Delivery)							9.3%	20.7%	19.0%		39.7%	72.1%	40.5%		85.9%	96.6%	92.8%		84.8%	95.8%	66.7%	26.0%	63.2%	21.1%
82
83	2023	13208	City of Naperville - (IL)	A	Bundled	O	IL	Municipal	PJM	64,799.2	500,293	55,563	0.1295	67,418.2	639,059	6,985	0.1055	7,363.2	69,001	8	0.1067	0.0	0	0	139,580.6	1,208,353	62,556	0.1155
84	2023	4110	Commonwealth Edison Co	A	Bundled	O	IL	Investor Owned	PJM	3,046,255.6	20,611,558	3,006,545	0.1478	930,756.2	8,002,788	235,795	0.1163	85,579.5	1,349,827	151	0.0634	0.0	0	0	4,062,591.3	29,964,173	3,242,491	0.1356
85	2023	4110	Commonwealth Edison Co	C	Delivery	O	IL	Investor Owned	PJM	376,756.5	5,411,007	725,914	0.0696	811,908.0	21,157,113	160,407	0.0384	596,723.5	25,358,007	1,724	0.0235	8,719.2	399,921	2	1,794,107.2	52,326,048	888,047	0.0343
86	2023	13374	Constellation NewEnergy, Inc	B	Energy	O	IL	Retail Power Marketer	PJM	25,845.3	272,183	34,577	0.0950	788,246.1	14,210,667	44,191	0.0555	76,841.2	1,439,097	561	0.0534	0.0	0	0	890,932.6	15,921,947	79,329	0.0560
87	2023		ComEd Delivery + Constellation NewEnergy (Avg Price)										0.1646				0.0938				0.0769							0.0902
88	2023		ComEd Delivery % of Total ComEd (Bundled + Delivery)							11.0%	20.8%	19.4%		46.6%	72.6%	40.5%		87.5%	94.9%	91.9%		100.0%	100.0%	100.0%	30.6%	63.6%	21.5%
89
90
91
92
93
94
95
96
97
98
99
100