GSA_IL__OH_GS-00P-17-BSD-1240_Exhibit_1_Amend2version.xlsx

XLSX spreadsheet 119 KB Posted Feb 27, 2017

Attached to: Electric power supply for various Accounts in Illinois
Solicitation number: GS-00P-17-BSD-1240
Issued by: General Services Administration Public Buildings Service Central Office Energy Division

About this file

From the source

Exhibit 1 (Amendment No. 2 version)

View the file

Other files

File	Type	Posted
ILOH2017_Electricity_solic_GS00P17BSD1240_AmendmentNo2.doc	DOC document	Feb 27, 2017
IL_&_OH_GS00P17BSD1240_Redline_Version_Amend_1_to_Amend_2.docx	DOCX document	Feb 27, 2017
IL&OH2017Electric_Solicitation_GS00P17BSD1240Amend2version.doc	DOC document	Feb 27, 2017
ILOH2017_Electricity_solic_GS00P17BSD1240_AmendmentNo1.doc	DOC document	Feb 9, 2017
IL&OH2017Electric_Solicitation_GS00P17BSD1240Amend1version.doc	DOC document	Feb 9, 2017
GSA_IL__OH_GS-00P-17-BSD-1240_Exhibit_1_Amend1version.xlsx	XLSX spreadsheet	Feb 9, 2017
IL&OH2017Electric_Solicitation_GS00P17BSD1240.doc	DOC document	Feb 6, 2017
GSA_IL__OH_SolicitationGS-00P-17-BSD-1240_Exhibit_1.xlsx	XLSX spreadsheet	Feb 6, 2017

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Notes

2/8/17	Pricing Group 1, account # 7022002112 - Marion US penitentiary - The US Bureau of Prisons is planning an Energy Savings Performance Contract (ESPC) that will reduce electric usage by 12.5% starting in contract year two.
	This reduction has been factored into the auction volumes by contract year provided in this Exhibit 1 for years two, three and four.
2/8/17	Pricing Group 1, account # 8991002616 - Marion VA Hospital
	1) The Veterans Administration is planning an ESPC that will reduce electric usage by 2,189,940 kWhs starting in contract year three. This reduction has been factored into the auction volumes by contract year provided in
	this Exhibit 1 for years three and four.
	2) While the utility data provided for the period of December 2015 - 2016 has three meter numbers associated with this account (72304865 ; 06093294; 72305236) only 72304865 is still active as of February 2017.
2/8/17	Pricing Group 4, account # 3690067401 - Cincinnati EPA - The EPA owns their own transformer and Duke reduces their metered usage by 1.5% for purposes of billing. The auction kWhs provided also
	reduce usage for all years by 1.5%. This reduction has been factored into the auction volumes by contract year provided in this Exhibit 1 for all contract years.
	NOTE: Suppliers will be required to reduce the metered kWh volumes provided by Duke Energy by 1.5% and bill the EPA on the reduced volume not the metered volume.
2/8/17	Pricing Group 4, account # 7360213701 - GSA 6751 Steger Drive - The current GSA lease for this facility expires in June 2018 so the contract term for this account will be 11 months and end with the May 2018 meter read date.
2/8/17	Pricing Group 4, account # 9180075001 - Cincinnati VA Hospital
	1) The VA owns their own transformer and Duke reduces their metered usage by 1.5% for purposes of billing. The auction kWhs provided also reduce usage for all years by 1.5%. This reduction has been factored into the auction
	volumes by contract year provided in this Exhibit 1 for all contract years.
	2) This facility expects to increase square footage by 10% over the 48 month term of this contract. Auction volumes for contract years two, three and four have been increased by 3.3% to account for this expansion.
	NOTE: Suppliers will be required to reduce the metered kWh volumes provided by Duke Energy by 1.5% and bill the VA on the reduced volume not the metered volume.
2/8/17	Two new sheets "PG2 Block Sizes" and "PG5 Block Sizes" have been provided in this Exhibit 1 that provide additional information on the block sizes requested and allocations per each account included in each of these pricing groups.

2/24/17	Com Ed Accounts - Updated the auction schedule to reflect that the accounts that were in Pricing Group 3 have been combined with the accounts in Pricing Group 2 and that the pricing product for this group has changed from
	block and index to fixed pricing with cap & trans passed through.
2/24/17	Duke Accounts - Updated the auction schedule to reflect that old Pricing Group 4 is now Pricing Group 3.
2/24/17	First Energy Accounts - Updated the auction schedule to reflect that old Pricing group 5 is now Pricing Group 4 and that the pricing product for this group has changed from block and index to fixed price with capacity passed through.
2/24/17	Deleted the two sheets "PG2 Block Sizes" and "PG5 Block Sizes" since GSA is no longer requesting block and index pricing for any of the accounts included in this buy.

Auction Schedule

EXHIBIT 1 GS-00P-17-BSD-1240
EnerNOC RFP #	Auction Date	Auction Bid Deadline (ET)	Pricing Group	Billing	State	Utility	Start Month	End Month	Renewable	Bid Prices Must be Held Until (ET)	Pricing Product	Term in Months	No of Accounts	Historical Annual kWhs	Auction Annual KWhs Contract Year 1	Auction Annual KWhs Contract Year 2	Auction Annual KWhs Contract Year 3	Auction Annual KWhs Contract Year 4
58514	3/8/17	11:05 AM	1	Dual Only	IL	Ameren	Apr-17	Apr-21	20%	1:30PM	Fixed Price All In	48	7	58,291,391	58,291,391	57,025,340	54,835,400	54,835,400
58516	3/8/17	11:15 AM	2	Dual Only	IL	Com Ed	Apr-17	Apr-21	0%	1:30PM	Fixed Price - Cap & Trans Pass-Through	48	5	71,752,961	71,752,961	71,752,961	71,752,961	71,752,961
58520	3/8/17	11:25 AM	3	Dual Only	OH	Duke	Jun-17	** Jun-21	20%	1:30PM	Fixed Price- Cap Pass-Through	48	7	47,128,661	46,107,795	42,071,268	42,730,387	43,349,360
58522	3/8/17	11:35 AM	4	Dual Only	OH	First Energy	Jun-17	Jun-21	20%	1:30PM	Fixed Price- Cap Pass-Through	48	3	34,033,424	34,033,424	34,033,424	34,033,424	34,033,424
TOTALS													22	211,206,437	210,185,571	204,882,993	203,352,172	203,971,145

NOTE:	The most recent twelve month's worth of monthly data available from the utility is included in this Exhibit 1. Interval data, for the accounts that have interval data, has been posted to the EnerNOC site for
	this procurement at:	https://www.exchange.enernoc.com/webportal/AnnouncementView.aspx?id=11932

* Note: The auction kWhs by contract year will be the contract volumes and any usage variance calculations associated with Section A.13 of the GSA solicitation must be based on these volumes.

**	Duke Energy account # 7360213701 with a service address of Steger Dr, Cincinnati OH will only have an 11 month term regardless of whether the government awards a 36 or 48 month contract. The contract end
	for this account will be its May 2018 utility meter read date regardless of the term awarded for this pricing group

https://www.exchange.enernoc.com/webportal/AnnouncementView.aspx?id=11932 Account List

Pricing Group

Utility

Contract Start Month

Contract End Month

Agency

Utility Account #

Utility Customer #

GSA Building #

Pricing Type

Service Address

City

State

Interval Data File Available on EnerNOC website?

Historical Annual kWhs

Auction Annual KWhs Contract Year 1

Auction Annual KWhs Contract Year 2

Auction Annual KWhs Contract Year 3

Auction Annual KWhs Contract Year 4

Notes

Ameren

Apr-17

Apr-21

USPB

696240817

N/A

FFP - All In

Federal Correctional Instit

Greenville

Yes

9,541,491

Ameren

Apr-17

Apr-21

USPB

4605033290

N/A

FFP - All In

Federal Correctional Institute

Greenville

139,029

Ameren

Apr-17

Apr-21

USPB

5028824812

N/A

FFP - All In

Federal Correctional Institute

Pekin

Yes

8,420,561

Ameren

Apr-17

Apr-21

USPB

7022002112

N/A

FFP - All In

US penitentiary

Marion

Yes

11,009,142

9,743,091

See Notes Sheet

Ameren

Apr-17

Apr-21

GSA

5500006712

IL0069ES

FFP - All In

General Admin Services

St. Louis

Yes

1,318,544

Ameren

Apr-17

Apr-21

5721030091

N/A

FFP - All In

1900 E. Main Street

Danville

Yes

15,838,695

Ameren

Apr-17

Apr-21

8991002616

N/A

FFP - All In

2401 W. Main Street

Marion

Yes

12,023,929

9,833,989

See Notes Sheet

Com Ed

Apr-17

Apr-21

GSA

0640567004

IL0054ZZ

FFP - Cap. & Trans. Pass-Through

536 S. Clark St

Chicago

Yes

9,288,709

Com Ed

Apr-17

Apr-21

GSA

1226631000

IL0032ZZ

FFP - Cap. & Trans. Pass-Through

610 S. Canal St.

Chicago

Yes

3,470,925

Com Ed

Apr-17

Apr-21

GSA

9232012000

IL0235FC

FFP - Cap. & Trans. Pass-Through

219 S.Dearborn St

Chicago

Yes

39,229,554

Com Ed

Apr-17

Apr-21

ACOE

3321128066

N/A

FFP - Cap. & Trans. Pass-Through

ACOE Fish Barrier Romeoville IIA

Romeoville

Yes

10,785,890

Com Ed

Apr-17

Apr-21

ACOE

4163171046

N/A

FFP - Cap. & Trans. Pass-Through

ACOE Fish Barrier Romeoville IIB

Romeoville

Yes

8,977,883

Duke

Jun-17

Jun-21

EPA

3450082301

N/A

FFP - Cap. & Trans. Pass-Through

1600 GEST

Cincinnati

Yes

1,467,669

Duke

Jun-17

Jun-21

EPA

3690067401

N/A

FFP - Cap. Pass-Through

26 M L KING DR W

Cincinnati

Yes

12,243,825

12,060,168

See Notes Sheet

Duke

Jun-17

Jun-21

EPA

7380074701

N/A

FFP - Cap. Pass-Through

5995 CENTER HILL RD

Cincinnati

Yes

751,818

Duke

Jun-17

Jun-21

GSA

3220074001

OH0028CN

FFP - Cap. Pass-Through

500 WALNUT

Cincinnati

Yes

2,786,947

Duke

Jun-17

Jun-21

GSA

8580067401

OH0189CN

FFP - Cap. Pass-Through

550 MAIN

Cincinnati

5,031,364

Duke

Jun-17

May-18

GSA

7360213701

OH2168ZZ

FFP - Cap. Pass-Through

6751 STEGER DR

Cincinnati

Yes

5,217,353

4,674,590

- 0

See Notes Sheet

Duke

Jun-17

Jun-21

9180075001

N/A

FFP - Cap. Pass-Through

3200 VINE

Cincinnati

19,629,685

19,335,240

19,973,303

20,632,422

21,251,394

See Notes Sheet

FE - CE

Jun-17

Jun-21

GSA

08006647204000006906

11 00 22 6158 5 7

OH0301ZZ

FFP - Cap. Pass-Through

801 Superior Ave W

Cleveland

Yes

12,042,720

FE - CE

Jun-17

Jun-21

GSA

08007552921280001414

11 00 23 4500 1 5

OH0192ZZ

FFP - Cap. Pass-Through

1240 E 9th St

Cleveland

Yes

20,017,904

FE - CE

Jun-17

Jun-21

GSA

08007552921240001293

11 00 23 7641 6 7

OH0033ZZ

FFP - Cap. Pass-Through

201 Superior Ave

Cleveland

1,972,800

TOTALS

211,206,437

210,185,571

204,882,993

203,352,172

203,971,145

Ameren Historical Data Summary

Sum of Total kWh										Month
Agency	Customer	Account#	Meter	Address	City	State	Current Delivery Services Class	Effective PLC	Notes	1	2	3	4	5	6	7	8	9	10	11	12	Grand Total
GSA	GENERAL SERVICES ADM	5500006712	15313666, 11165650	General Admin Services	St. Louis	IL	DS3B	509.684	(blank)	94,165	87,662	86,274	97,136	105,995	147,091	140,411	136,739	119,144	99,489	104,102	100,336	1,318,544
USBP	FEDERAL CORR INST PEKIN	5028824812	12303043, 91779477	Federal Correctional Institute	Pekin	IL	DS4	1919.683	(blank)	648,244	593,548	609,717	582,069	670,250	843,682	921,014	922,234	790,620	647,868	587,457	603,858	8,420,561
	US DEPT OF JUSTICE	696240817	71999582, 08060093	Federal Correctional Instit	Greenville	IL	DS4	2162.397	(blank)	659,435	712,210	651,193	684,272	787,847	1,295,805	766,985	981,042	804,623	733,403	686,710	777,966	9,541,491
		4605033290	15371171	Federal Correctional Institute	Greenville	IL	DS2	1.08	(blank)	12,066	10,746	9,349	11,956	11,838	14,956	13,178	13,719	10,548	8,332	10,242	12,099	139,029
	US PENITENTIARY	7022002112	15302029	US penitentiary	Marion	IL	DS4	2064.412	(blank)	922,035	831,925	847,855	768,241	811,500	1,151,906	995,703	1,039,531	1,128,417	818,536	781,406	912,087	11,009,142
VA	VETERANS ADM HOSPITAL	8991002616	72304865	2401 W. Main Street	Marion	IL	DS4	Not Available	(blank)	774,317	827,397	896,955	932,342	1,113,903	1,279,592	1,246,014	1,235,498	1,128,184	940,072	806,473	843,182	12,023,929
	VETERANS ADMINISTRATION MEDICAL CENTER	5721030091	7798569	1900 E. Main Street	Danville	IL	DS4	4065.961	(blank)	1,296,130	1,069,489	1,020,791	1,155,887	1,121,878	1,482,419	1,721,755	1,656,858	1,646,848	1,297,448	1,259,579	1,109,613	15,838,695
Grand Total										4,406,392	4,132,977	4,122,134	4,231,903	4,623,211	6,215,451	5,805,060	5,985,621	5,628,384	4,545,148	4,235,969	4,359,141	58,291,391

Ameren Historical Data

Customer	Agency	Account#	Meter	Address	City	State	Zip	Bill Group	Current Delivery Services Class	Effective PLC	Year	Month	StartDate	EndDate	Days	Total kWh	OnPeak kWh	OffPeak kWh	On-Peak Demand	Off-Peak Demand	Peak Demand kW	Notes
US DEPT OF JUSTICE	USBP	696240817	71999582, 08060093	Federal Correctional Instit	Greenville	IL		12	DS4	2162.397	2016	11	11/08/2016	12/09/2016	31	686710	272660	414050	1909.4	1269.1	1909.4
US DEPT OF JUSTICE	USBP	696240817	71999582, 08060093	Federal Correctional Instit	Greenville	IL		12	DS4	2162.397	2016	10	10/08/2016	11/08/2016	31	733403	291910	441493	1826.9	1570.6	1826.9
US DEPT OF JUSTICE	USBP	696240817	71999582, 08060093	Federal Correctional Instit	Greenville	IL		12	DS4	2162.397	2016	9	09/09/2016	10/08/2016	29	804623	320720	483903	1913.9	1798.4	1913.9
US DEPT OF JUSTICE	USBP	696240817	71999582, 08060093	Federal Correctional Instit	Greenville	IL		12	DS4	2162.397	2016	8	08/10/2016	09/09/2016	30	981042	385990	595052	2068.8	1956.7	2068.8
US DEPT OF JUSTICE	USBP	696240817	71999582, 08060093	Federal Correctional Instit	Greenville	IL		12	DS4	2162.397	2016	7	07/19/2016	08/10/2016	22	766985	310421	456564	1932.5	1942.1	1942.1
US DEPT OF JUSTICE	USBP	696240817	71999582, 08060093	Federal Correctional Instit	Greenville	IL		12	DS4	2162.397	2016	6	06/10/2016	07/19/2016	39	1295805	486027	809778	1949.8	1855.7	1949.8
US DEPT OF JUSTICE	USBP	696240817	71999582, 08060093	Federal Correctional Instit	Greenville	IL		12	DS4	2162.397	2016	5	05/11/2016	06/10/2016	30	787847	315228	472619	1871	1569.6	1871
US DEPT OF JUSTICE	USBP	696240817	71999582, 08060093	Federal Correctional Instit	Greenville	IL		12	DS4	2162.397	2016	4	04/12/2016	05/11/2016	29	684272	283384	400888	1809.3	1491.1	1809.3
US DEPT OF JUSTICE	USBP	696240817	71999582, 08060093	Federal Correctional Instit	Greenville	IL		12	DS4	2162.397	2016	3	03/13/2016	04/12/2016	30	651193	262758	388435	1520.6	1267.2	1520.6
US DEPT OF JUSTICE	USBP	696240817	71999582, 08060093	Federal Correctional Instit	Greenville	IL		12	DS4	2162.397	2016	2	02/11/2016	03/13/2016	31	712210	277812	434398	1328.4	1274.4	1328.4
US DEPT OF JUSTICE	USBP	696240817	71999582, 08060093	Federal Correctional Instit	Greenville	IL		12	DS4	2162.397	2016	1	01/13/2016	02/11/2016	29	659435	255747	403688	1309	1290.2	1309
US DEPT OF JUSTICE	USBP	696240817	71999582, 08060093	Federal Correctional Instit	Greenville	IL		12	DS4	2162.397	2015	12	12/11/2015	01/13/2016	33	777966	275912	502054	1306.8	1409.8	1409.8
US DEPT OF JUSTICE	USBP	4605033290	15371171	Federal Correctional Institute	Greenville	IL		12	DS2	1.08	2016	11	11/08/2016	12/11/2016	33	10242	0	0	0	0	0
US DEPT OF JUSTICE	USBP	4605033290	15371171	Federal Correctional Institute	Greenville	IL		12	DS2	1.08	2016	10	10/10/2016	11/08/2016	29	8332	0	0	0	0	0
US DEPT OF JUSTICE	USBP	4605033290	15371171	Federal Correctional Institute	Greenville	IL		12	DS2	1.08	2016	9	09/11/2016	10/10/2016	29	10548	0	0	0	0	0
US DEPT OF JUSTICE	USBP	4605033290	15371171	Federal Correctional Institute	Greenville	IL		12	DS2	1.08	2016	8	08/10/2016	09/11/2016	32	13719	0	0	0	0	0
US DEPT OF JUSTICE	USBP	4605033290	15371171	Federal Correctional Institute	Greenville	IL		12	DS2	1.08	2016	7	07/12/2016	08/10/2016	29	13178	0	0	0	0	0
US DEPT OF JUSTICE	USBP	4605033290	15371171	Federal Correctional Institute	Greenville	IL		12	DS2	1.08	2016	6	06/12/2016	07/12/2016	30	14956	0	0	0	0	0
US DEPT OF JUSTICE	USBP	4605033290	15371171	Federal Correctional Institute	Greenville	IL		12	DS2	1.08	2016	5	05/11/2016	06/12/2016	32	11838	0	0	0	0	0
US DEPT OF JUSTICE	USBP	4605033290	15371171	Federal Correctional Institute	Greenville	IL		12	DS2	1.08	2016	4	04/12/2016	05/11/2016	29	11956	0	0	0	0	0
US DEPT OF JUSTICE	USBP	4605033290	15371171	Federal Correctional Institute	Greenville	IL		12	DS2	1.08	2016	3	03/13/2016	04/12/2016	30	9349	0	0	0	0	0
US DEPT OF JUSTICE	USBP	4605033290	15371171	Federal Correctional Institute	Greenville	IL		12	DS2	1.08	2016	2	02/11/2016	03/13/2016	31	10746	0	0	0	0	0
US DEPT OF JUSTICE	USBP	4605033290	15371171	Federal Correctional Institute	Greenville	IL		12	DS2	1.08	2016	1	01/13/2016	02/11/2016	29	12066	0	0	0	0	0
US DEPT OF JUSTICE	USBP	4605033290	15371171	Federal Correctional Institute	Greenville	IL		12	DS2	1.08	2015	12	12/10/2015	01/13/2016	34	12099	0	0	0	0	0
FEDERAL CORR INST PEKIN	USBP	5028824812	12303043, 91779477	Federal Correctional Institute	Pekin	IL		21	DS4	1919.683	2016	12	11/30/2016	12/31/2016	31	603858	215385	388473	1075.2	1098.7	1098.7
FEDERAL CORR INST PEKIN	USBP	5028824812	12303043, 91779477	Federal Correctional Institute	Pekin	IL		21	DS4	1919.683	2016	11	10/31/2016	11/30/2016	30	587457	219082	368375	1233.1	1155.8	1233.1
FEDERAL CORR INST PEKIN	USBP	5028824812	12303043, 91779477	Federal Correctional Institute	Pekin	IL		21	DS4	1919.683	2016	10	09/30/2016	10/31/2016	31	647868	230886	416982	1273.4	1320.5	1320.5
FEDERAL CORR INST PEKIN	USBP	5028824812	12303043, 91779477	Federal Correctional Institute	Pekin	IL		21	DS4	1919.683	2016	9	08/31/2016	09/30/2016	30	790620	305127	485493	1710.2	1639.7	1710.2
FEDERAL CORR INST PEKIN	USBP	5028824812	12303043, 91779477	Federal Correctional Institute	Pekin	IL		21	DS4	1919.683	2016	8	07/31/2016	08/31/2016	31	922234	383631	538603	1753.9	1693.4	1753.9
FEDERAL CORR INST PEKIN	USBP	5028824812	12303043, 91779477	Federal Correctional Institute	Pekin	IL		21	DS4	1919.683	2016	7	06/30/2016	07/31/2016	31	921014	335922	585092	1774.1	1784.2	1784.2
FEDERAL CORR INST PEKIN	USBP	5028824812	12303043, 91779477	Federal Correctional Institute	Pekin	IL		21	DS4	1919.683	2016	6	05/31/2016	06/30/2016	30	843682	341812	501870	1764	1696.8	1764
FEDERAL CORR INST PEKIN	USBP	5028824812	12303043, 91779477	Federal Correctional Institute	Pekin	IL		21	DS4	1919.683	2016	5	04/30/2016	05/31/2016	31	670250	243895	426355	1606.1	1562.4	1606.1
FEDERAL CORR INST PEKIN	USBP	5028824812	12303043, 91779477	Federal Correctional Institute	Pekin	IL		21	DS4	1919.683	2016	4	03/31/2016	04/30/2016	30	582069	217838	364231	1159.2	1256.6	1256.6
FEDERAL CORR INST PEKIN	USBP	5028824812	12303043, 91779477	Federal Correctional Institute	Pekin	IL		21	DS4	1919.683	2016	3	02/29/2016	03/31/2016	31	609717	239836	369881	1102.1	1293.6	1293.6
FEDERAL CORR INST PEKIN	USBP	5028824812	12303043, 91779477	Federal Correctional Institute	Pekin	IL		21	DS4	1919.683	2016	2	01/31/2016	02/29/2016	29	593548	230719	362829	1176	1293.6	1293.6
FEDERAL CORR INST PEKIN	USBP	5028824812	12303043, 91779477	Federal Correctional Institute	Pekin	IL		21	DS4	1919.683	2016	1	12/31/2015	01/31/2016	31	648244	225120	423124	1256.6	1350.7	1350.7
GENERAL SERVICES ADM	GSA	5500006712	15313666, 11165650	General Admin Services	St. Louis	IL		10	DS3B	509.684	2016	11	11/04/2016	12/07/2016	33	104102	44511	59591	338	319.3	338
GENERAL SERVICES ADM	GSA	5500006712	15313666, 11165650	General Admin Services	St. Louis	IL		10	DS3B	509.684	2016	10	10/06/2016	11/04/2016	29	99489	48057	51432	367	373.2	373.2
GENERAL SERVICES ADM	GSA	5500006712	15313666, 11165650	General Admin Services	St. Louis	IL		10	DS3B	509.684	2016	9	09/07/2016	10/06/2016	29	119144	57514	61630	412.6	510.1	510.1
GENERAL SERVICES ADM	GSA	5500006712	15313666, 11165650	General Admin Services	St. Louis	IL		10	DS3B	509.684	2016	8	08/08/2016	09/07/2016	30	136739	64885	71854	522.5	518.4	522.5
GENERAL SERVICES ADM	GSA	5500006712	15313666, 11165650	General Admin Services	St. Louis	IL		10	DS3B	509.684	2016	7	07/11/2016	08/08/2016	28	140411	68389	72022	537.1	545.4	545.4
GENERAL SERVICES ADM	GSA	5500006712	15313666, 11165650	General Admin Services	St. Louis	IL		10	DS3B	509.684	2016	6	06/08/2016	07/11/2016	33	147091	67482	79609	541.8	548.8	548.8
GENERAL SERVICES ADM	GSA	5500006712	15313666, 11165650	General Admin Services	St. Louis	IL		10	DS3B	509.684	2016	5	05/09/2016	06/08/2016	30	105995	50924	55071	454.5	405.7	454.5
GENERAL SERVICES ADM	GSA	5500006712	15313666, 11165650	General Admin Services	St. Louis	IL		10	DS3B	509.684	2016	4	04/08/2016	05/09/2016	31	97136	45287	51849	369.1	358.7	369.1
GENERAL SERVICES ADM	GSA	5500006712	15313666, 11165650	General Admin Services	St. Louis	IL		10	DS3B	509.684	2016	3	03/09/2016	04/08/2016	30	86274	39290	46984	275.8	226	275.8
GENERAL SERVICES ADM	GSA	5500006712	15313666, 11165650	General Admin Services	St. Louis	IL		10	DS3B	509.684	2016	2	02/09/2016	03/09/2016	29	87662	39127	48535	304.8	236.4	304.8
GENERAL SERVICES ADM	GSA	5500006712	15313666, 11165650	General Admin Services	St. Louis	IL		10	DS3B	509.684	2016	1	01/11/2016	02/09/2016	29	94165	42008	52157	288.2	250.9	288.2
GENERAL SERVICES ADM	GSA	5500006712	15313666, 11165650	General Admin Services	St. Louis	IL		10	DS3B	509.684	2015	12	12/08/2015	01/11/2016	34	100336	39818	60518	271.6	250.9	271.6
VETERANS ADMINISTRATION MEDICAL CENTER	VA	5721030091	7798569	1900 E. Main Street	Danville	IL		21	DS4	4065.961	2016	12	11/22/2016	12/22/2016	30	1109613	417608	692005	2099	2041.4	2099
VETERANS ADMINISTRATION MEDICAL CENTER	VA	5721030091	7798569	1900 E. Main Street	Danville	IL		21	DS4	4065.961	2016	11	10/21/2016	11/22/2016	32	1259579	488813	770766	2681.8	2413	2681.8
VETERANS ADMINISTRATION MEDICAL CENTER	VA	5721030091	7798569	1900 E. Main Street	Danville	IL		21	DS4	4065.961	2016	10	09/22/2016	10/21/2016	29	1297448	523049	774399	3200.2	2930.9	3200.2
VETERANS ADMINISTRATION MEDICAL CENTER	VA	5721030091	7798569	1900 E. Main Street	Danville	IL		21	DS4	4065.961	2016	9	08/23/2016	09/22/2016	30	1646848	673949	972899	3565	3347.5	3565
VETERANS ADMINISTRATION MEDICAL CENTER	VA	5721030091	7798569	1900 E. Main Street	Danville	IL		21	DS4	4065.961	2016	8	07/25/2016	08/23/2016	29	1656858	699010	957848	3794.9	3494.4	3794.9
VETERANS ADMINISTRATION MEDICAL CENTER	VA	5721030091	7798569	1900 E. Main Street	Danville	IL		21	DS4	4065.961	2016	7	06/23/2016	07/25/2016	32	1721755	660449	1061306	3705.6	3353.3	3705.6
VETERANS ADMINISTRATION MEDICAL CENTER	VA	5721030091	7798569	1900 E. Main Street	Danville	IL		21	DS4	4065.961	2016	6	05/24/2016	06/23/2016	30	1482419	604361	878058	3616.3	3398.4	3616.3
VETERANS ADMINISTRATION MEDICAL CENTER	VA	5721030091	7798569	1900 E. Main Street	Danville	IL		21	DS4	4065.961	2016	5	04/25/2016	05/24/2016	29	1121878	463416	658462	2649.6	2476.8	2649.6
VETERANS ADMINISTRATION MEDICAL CENTER	VA	5721030091	7798569	1900 E. Main Street	Danville	IL		21	DS4	4065.961	2016	4	03/24/2016	04/25/2016	32	1155887	448186	707701	2617.4	2323.2	2617.4
VETERANS ADMINISTRATION MEDICAL CENTER	VA	5721030091	7798569	1900 E. Main Street	Danville	IL		21	DS4	4065.961	2016	3	02/24/2016	03/24/2016	29	1020791	409557	611234	2150.4	2118.2	2150.4
VETERANS ADMINISTRATION MEDICAL CENTER	VA	5721030091	7798569	1900 E. Main Street	Danville	IL		21	DS4	4065.961	2016	2	01/26/2016	02/24/2016	29	1069489	412665	656824	2169.6	2169.6	2169.6
VETERANS ADMINISTRATION MEDICAL CENTER	VA	5721030091	7798569	1900 E. Main Street	Danville	IL		21	DS4	4065.961	2016	1	12/23/2015	01/26/2016	34	1296130	450650	845480	2092.8	2099.5	2099.5
US PENITENTIARY	USBP	7022002112	15302029	US penitentiary	Marion	IL		18	DS4	2064.412	2016	12	11/17/2016	12/19/2016	32	912087	320529	591558	1396.8	1349.8	1396.8
US PENITENTIARY	USBP	7022002112	15302029	US penitentiary	Marion	IL		18	DS4	2064.412	2016	11	10/19/2016	11/17/2016	29	781406	300255	481151	1646.4	1544.6	1646.4
US PENITENTIARY	USBP	7022002112	15302029	US penitentiary	Marion	IL		18	DS4	2064.412	2016	10	09/21/2016	10/19/2016	28	818536	310223	508313	1820.2	1732.8	1820.2
US PENITENTIARY	USBP	7022002112	15302029	US penitentiary	Marion	IL		18	DS4	2064.412	2016	9	08/20/2016	09/21/2016	32	1128417	429314	699103	1945.9	1837.4	1945.9
US PENITENTIARY	USBP	7022002112	15302029	US penitentiary	Marion	IL		18	DS4	2064.412	2016	8	07/24/2016	08/20/2016	27	1039531	405329	634202	2053.4	1889.3	2053.4
US PENITENTIARY	USBP	7022002112	15302029	US penitentiary	Marion	IL		18	DS4	2064.412	2016	7	06/27/2016	07/24/2016	27	995703	388491	607212	2028.5	1984.3	2028.5
US PENITENTIARY	USBP	7022002112	15302029	US penitentiary	Marion	IL		18	DS4	2064.412	2016	6	05/24/2016	06/27/2016	34	1151906	428398	723508	2005.4	1909.4	2005.4
US PENITENTIARY	USBP	7022002112	15302029	US penitentiary	Marion	IL		18	DS4	2064.412	2016	5	04/22/2016	05/24/2016	32	811500	307101	504399	1517.8	1397.8	1517.8
US PENITENTIARY	USBP	7022002112	15302029	US penitentiary	Marion	IL		18	DS4	2064.412	2016	4	03/24/2016	04/22/2016	29	768241	293739	474502	1481.3	1433.3	1481.3
US PENITENTIARY	USBP	7022002112	15302029	US penitentiary	Marion	IL		18	DS4	2064.412	2016	3	02/24/2016	03/24/2016	29	847855	335378	512477	1559	1529.3	1559
US PENITENTIARY	USBP	7022002112	15302029	US penitentiary	Marion	IL		18	DS4	2064.412	2016	2	01/25/2016	02/24/2016	30	831925	319984	511941	1437.1	1467.8	1467.8
US PENITENTIARY	USBP	7022002112	15302029	US penitentiary	Marion	IL		18	DS4	2064.412	2016	1	12/23/2015	01/25/2016	33	922035	309662	612373	1385.3	1386.2	1386.2
VETERANS ADM HOSPITAL	VA	8991002616	72304865	2401 W. Main Street	Marion	IL		13	DS4	Not Available	2015	12	12/14/15	1/14/16	31	843182	304791	538391	1611	1602	1611
VETERANS ADM HOSPITAL	VA	8991002616	72304865	2401 W. Main Street	Marion	IL		13	DS4	Not Available	2016	1	1/14/16	2/12/16	29	774317	298098	476219	1653	1420	1653
VETERANS ADM HOSPITAL	VA	8991002616	72304865	2401 W. Main Street	Marion	IL		13	DS4	Not Available	2016	2	2/12/16	3/12/16	29	827397	309763	517634	1534.32	1509.48	1534.32
VETERANS ADM HOSPITAL	VA	8991002616	72304865	2401 W. Main Street	Marion	IL		13	DS4	Not Available	2016	3	3/12/16	4/13/16	32	896955	333152	563803	1617.12	1523.16	1617.12
VETERANS ADM HOSPITAL	VA	8991002616	72304865	2401 W. Main Street	Marion	IL		13	DS4	Not Available	2016	4	4/13/16	5/12/16	29	932342	362468	569874	1910.16	1825.56	1910.16
VETERANS ADM HOSPITAL	VA	8991002616	72304865	2401 W. Main Street	Marion	IL		13	DS4	Not Available	2016	5	5/12/16	6/13/16	32	1113903	394479	719424	2018.16	1967.04	2018.16
VETERANS ADM HOSPITAL	VA	8991002616	72304865	2401 W. Main Street	Marion	IL		13	DS4	Not Available	2016	6	6/13/16	7/13/16	30	1279592	495661	783931	2259.4	2143.9	2259.4
VETERANS ADM HOSPITAL	VA	8991002616	72304865	2401 W. Main Street	Marion	IL		13	DS4	Not Available	2016	7	7/13/16	8/11/16	29	1246014	494448	751566	2243.52	2181.12	2243.52
VETERANS ADM HOSPITAL	VA	8991002616	72304865	2401 W. Main Street	Marion	IL		13	DS4	Not Available	2016	8	8/11/16	9/10/16	30	1235498	448193	787305	20187.84	2113.44	20187.84
VETERANS ADM HOSPITAL	VA	8991002616	72304865	2401 W. Main Street	Marion	IL		13	DS4	Not Available	2016	9	9/10/16	10/11/16	31	1128184	436645	691539	2002.56	1897.92	2002.56
VETERANS ADM HOSPITAL	VA	8991002616	72304865	2401 W. Main Street	Marion	IL		13	DS4	Not Available	2016	10	10/11/16	11/9/16	29	940072	370611	569461	1947	1810	1947
VETERANS ADM HOSPITAL	VA	8991002616	72304865	2401 W. Main Street	Marion	IL		13	DS4	Not Available	2016	11	11/9/16	12/10/2016	28	806473	291229	515244	1663.9	1608.5	1663.9

ComEd Historical Data Summary

Sum of Total KWH Usage								Month
Agency	Customer Name	Account Number	Address	City	State	Capacity PLC	Network Service PLC	1	2	3	4	5	6	7	8	9	10	11	12	Grand Total
GSA	GSA	1226631000	610 S. Canal St.	Chicago	IL	901.6708	809.3664	278,151	259,933	255,833	224,830	266,283	322,119	375,844	329,002	348,922	260,907	235,457	313,644	3,470,925
		9232012000	219 S.Dearborn St	Chicago	IL	8155.7957	10663.6157	3,173,753	3,154,533	2,891,145	2,877,181	3,567,561	3,658,317	3,813,799	3,661,464	3,164,210	2,713,543	3,157,286	3,396,762	39,229,554
		0640567004	536 S. Clark St	Chicago	IL	2198.6233	2184.3484	764,686	650,407	587,237	630,927	750,745	865,824	1,037,737	1,014,113	898,708	688,976	680,741	718,608	9,288,709
ACOE	ACOE	4163171046	(blank)	IL	IL	1046.5897	1370.4278	506,511	836,246	741,280	871,251	828,444	977,797	797,901	493,421	821,108	414,251	797,376	892,297	8,977,883
		3321128066	(blank)	IL	IL	1286.1463	1506.808	998,349	929,491	837,982	1,037,769	916,937	1,051,067	748,614	881,260	851,759	874,625	795,527	862,510	10,785,890
Grand Total								5,721,450	5,830,610	5,313,477	5,641,958	6,329,970	6,875,124	6,773,895	6,379,260	6,084,707	4,952,302	5,666,387	6,183,821	71,752,961

ComEd Historical Data

Customer Name	Agency	Account Number	Address	City	State	Zip	Bill Group	Capacity PLC	Network Service PLC	Supply Group	Rate	Year	Month	Days	Start Date	End Date	Total KWH Usage	On-Peak KWH Usage	Off-Peak KWH Usage	Billing Demand (KW)	Monthly Peak Demand (KW)	Info
GSA	GSA	0640567004	536 S. Clark St	Chicago	IL		21	2198.6233	2184.3484	COMP DECL SUPPLY GROUP	R76	2016	12	29	11/29/16	12/28/16	718608	0	0	1,504.35	1,504.35
GSA	GSA	0640567004	536 S. Clark St	Chicago	IL		21	2198.6233	2184.3484	COMP DECL SUPPLY GROUP	R76	2016	11	33	10/27/16	11/29/16	680741	0	0	1,660.83	1,660.83
GSA	GSA	0640567004	536 S. Clark St	Chicago	IL		21	2198.6233	2184.3484	COMP DECL SUPPLY GROUP	R76	2016	10	29	9/28/16	10/27/16	688976	0	0	2,084.34	2,084.34
GSA	GSA	0640567004	536 S. Clark St	Chicago	IL		21	2198.6233	2184.3484	COMP DECL SUPPLY GROUP	R76	2016	9	30	8/29/16	9/28/16	898708	411322	487386	2,249.54	2,249.54
GSA	GSA	0640567004	536 S. Clark St	Chicago	IL		21	2198.6233	2184.3484	COMP DECL SUPPLY GROUP	R76	2016	8	31	7/29/16	8/29/16	1014113	444321	569792	2,272.10	2,287.70
GSA	GSA	0640567004	536 S. Clark St	Chicago	IL		21	2198.6233	2184.3484	COMP DECL SUPPLY GROUP	R76	2016	7	30	6/29/16	7/29/16	1037737	450441	587296	2,220.63	2,220.63
GSA	GSA	0640567004	536 S. Clark St	Chicago	IL		21	2198.6233	2184.3484	COMP DECL SUPPLY GROUP	R76	2016	6	29	5/31/16	6/29/16	865824	396095	469729	2,157.50	2,157.50
GSA	GSA	0640567004	536 S. Clark St	Chicago	IL		21	2198.6233	2184.3484	COMP DECL SUPPLY GROUP	R76	2016	5	33	4/28/16	5/31/16	750745	333246	417499	1,895.30	1,895.42
GSA	GSA	0640567004	536 S. Clark St	Chicago	IL		21	2198.6233	2184.3484	COMP DECL SUPPLY GROUP	R76	2016	4	29	3/30/16	4/28/16	630927	304538	326389	1,873.82	1,873.82
GSA	GSA	0640567004	536 S. Clark St	Chicago	IL		21	2198.6233	2184.3484	COMP DECL SUPPLY GROUP	R76	2016	3	28	3/2/16	3/30/16	587237	276216	311021	1,470.02	1,470.02
GSA	GSA	0640567004	536 S. Clark St	Chicago	IL		21	2198.6233	2184.3484	COMP DECL SUPPLY GROUP	R76	2016	2	29	2/2/16	3/2/16	650407	302023	348384	1,505.79	1,505.79
GSA	GSA	0640567004	536 S. Clark St	Chicago	IL		21	2198.6233	2184.3484	COMP DECL SUPPLY GROUP	R76	2016	1	33	12/31/15	2/2/16	764686	322339	442347	1,449.51	1,449.51
GSA	GSA	1226631000	610 S. Canal St.	Chicago	IL		21	901.6708	809.3664	COMP DECL SUPPLY GROUP	R75	2016	12	35	11/23/16	12/28/16	313644	0	0	564.1	564.1
GSA	GSA	1226631000	610 S. Canal St.	Chicago	IL		21	901.6708	809.3664	COMP DECL SUPPLY GROUP	R75	2016	11	29	10/25/16	11/23/16	235457	0	0	741.7	741.7
GSA	GSA	1226631000	610 S. Canal St.	Chicago	IL		21	901.6708	809.3664	COMP DECL SUPPLY GROUP	R75	2016	10	27	9/28/16	10/25/16	260907	0	0	711.22	711.22
GSA	GSA	1226631000	610 S. Canal St.	Chicago	IL		21	901.6708	809.3664	COMP DECL SUPPLY GROUP	R75	2016	9	30	8/29/16	9/28/16	348922	165374	183548	848.13	879.65
GSA	GSA	1226631000	610 S. Canal St.	Chicago	IL		21	901.6708	809.3664	COMP DECL SUPPLY GROUP	R75	2016	8	28	8/1/16	8/29/16	329002	158694	170308	828.74	854.02
GSA	GSA	1226631000	610 S. Canal St.	Chicago	IL		21	901.6708	809.3664	COMP DECL SUPPLY GROUP	R75	2016	7	32	6/30/16	8/1/16	375844	166589	209255	848.18	876.91
GSA	GSA	1226631000	610 S. Canal St.	Chicago	IL		21	901.6708	809.3664	COMP DECL SUPPLY GROUP	R75	2016	6	30	5/31/16	6/30/16	322119	152288	169831	843.62	872.16
GSA	GSA	1226631000	610 S. Canal St.	Chicago	IL		21	901.6708	809.3664	COMP DECL SUPPLY GROUP	R75	2016	5	32	4/29/16	5/31/16	266283	115937	150346	690.53	743.23
GSA	GSA	1226631000	610 S. Canal St.	Chicago	IL		21	901.6708	809.3664	COMP DECL SUPPLY GROUP	R75	2016	4	28	4/1/16	4/29/16	224830	106237	118593	860.3	860.3
GSA	GSA	1226631000	610 S. Canal St.	Chicago	IL		21	901.6708	809.3664	COMP DECL SUPPLY GROUP	R75	2016	3	31	3/1/16	4/1/16	255833	121808	134025	588.98	588.98
GSA	GSA	1226631000	610 S. Canal St.	Chicago	IL		21	901.6708	809.3664	COMP DECL SUPPLY GROUP	R75	2016	2	28	2/2/16	3/1/16	259933	116217	143716	577.92	577.92
GSA	GSA	1226631000	610 S. Canal St.	Chicago	IL		21	901.6708	809.3664	COMP DECL SUPPLY GROUP	R75	2016	1	29	1/4/16	2/2/16	278151	126104	152047	592.2	592.2
ACOE	ACOE	3321128066	ACOE Fish Barrier Romeoville IIA	Romeoville	IL		3	1286.1463	1506.808	COMP DECL SUPPLY GROUP	R76	2016	11	30	11/2/16	12/2/16	795527	0	0	1,210.64	1,249.21
ACOE	ACOE	3321128066	ACOE Fish Barrier Romeoville IIA	Romeoville	IL		3	1286.1463	1506.808	COMP DECL SUPPLY GROUP	R76	2016	10	33	9/30/16	11/2/16	874625	0	0	1,247.06	1,251.35
ACOE	ACOE	3321128066	ACOE Fish Barrier Romeoville IIA	Romeoville	IL		3	1286.1463	1506.808	COMP DECL SUPPLY GROUP	R76	2016	9	28	9/2/16	9/30/16	851759	313815	537944	1,467.76	1,467.76
ACOE	ACOE	3321128066	ACOE Fish Barrier Romeoville IIA	Romeoville	IL		3	1286.1463	1506.808	COMP DECL SUPPLY GROUP	R76	2016	8	30	8/3/16	9/2/16	881260	349100	532160	1,465.62	1,472.05
ACOE	ACOE	3321128066	ACOE Fish Barrier Romeoville IIA	Romeoville	IL		3	1286.1463	1506.808	COMP DECL SUPPLY GROUP	R76	2016	7	28	7/6/16	8/3/16	748614	289284	459330	1,424.91	1,487.05
ACOE	ACOE	3321128066	ACOE Fish Barrier Romeoville IIA	Romeoville	IL		3	1286.1463	1506.808	COMP DECL SUPPLY GROUP	R76	2016	6	34	6/2/16	7/6/16	1051067	376555	674512	1,514.90	1,514.90
ACOE	ACOE	3321128066	ACOE Fish Barrier Romeoville IIA	Romeoville	IL		3	1286.1463	1506.808	COMP DECL SUPPLY GROUP	R76	2016	5	31	5/2/16	6/2/16	916937	337387	579550	1,529.90	1,529.90
ACOE	ACOE	3321128066	ACOE Fish Barrier Romeoville IIA	Romeoville	IL		3	1286.1463	1506.808	COMP DECL SUPPLY GROUP	R76	2016	4	31	4/1/16	5/2/16	1037769	393637	644132	1,619.90	1,632.75
ACOE	ACOE	3321128066	ACOE Fish Barrier Romeoville IIA	Romeoville	IL		3	1286.1463	1506.808	COMP DECL SUPPLY GROUP	R76	2016	3	24	3/8/16	4/1/16	837982	323561	514421	1,782.74	1,829.88
ACOE	ACOE	3321128066	ACOE Fish Barrier Romeoville IIA	Romeoville	IL		3	1286.1463	1506.808	COMP DECL SUPPLY GROUP	R76	2016	2	29	2/8/16	3/8/16	929491	344631	584860	1,729.17	1,789.17
ACOE	ACOE	3321128066	ACOE Fish Barrier Romeoville IIA	Romeoville	IL		3	1286.1463	1506.808	COMP DECL SUPPLY GROUP	R76	2016	1	32	1/7/16	2/8/16	998349	364801	633548	1,495.62	1,568.47
ACOE	ACOE	3321128066	ACOE Fish Barrier Romeoville IIA	Romeoville	IL		3	1286.1463	1506.808	COMP DECL SUPPLY GROUP	R76	2015	12	30	12/8/15	1/7/16	862510	308995	553515	1,401.34	1,446.34
ACOE	ACOE	4163171046	ACOE Fish Barrier Romeoville IIB	Romeoville	IL		3	1046.5897	1370.4278	COMP DECL SUPPLY GROUP	R76	2016	12	32	12/2/16	1/3/17	892297	0	0	1,382.39	1,652.30
ACOE	ACOE	4163171046	ACOE Fish Barrier Romeoville IIB	Romeoville	IL		3	1046.5897	1370.4278	COMP DECL SUPPLY GROUP	R76	2016	11	30	11/2/16	12/2/16	797376	0	0	1,196.58	1,218.11
ACOE	ACOE	4163171046	ACOE Fish Barrier Romeoville IIB	Romeoville	IL		3	1046.5897	1370.4278	COMP DECL SUPPLY GROUP	R76	2016	10	33	9/30/16	11/2/16	414251	0	0	1,221.11	1,244.47
ACOE	ACOE	4163171046	ACOE Fish Barrier Romeoville IIB	Romeoville	IL		3	1046.5897	1370.4278	COMP DECL SUPPLY GROUP	R76	2016	9	29	9/1/16	9/30/16	821108	307262	513846	1,367.68	1,367.68
ACOE	ACOE	4163171046	ACOE Fish Barrier Romeoville IIB	Romeoville	IL		3	1046.5897	1370.4278	COMP DECL SUPPLY GROUP	R76	2016	8	29	8/3/16	9/1/16	493421	191908	301513	1,340.50	1,353.10
ACOE	ACOE	4163171046	ACOE Fish Barrier Romeoville IIB	Romeoville	IL		3	1046.5897	1370.4278	COMP DECL SUPPLY GROUP	R76	2016	7	29	7/5/16	8/3/16	797901	315079	482822	1,773.29	1,773.29
ACOE	ACOE	4163171046	ACOE Fish Barrier Romeoville IIB	Romeoville	IL		3	1046.5897	1370.4278	COMP DECL SUPPLY GROUP	R76	2016	6	33	6/2/16	7/5/16	977797	347296	630501	2,186.57	2,204.96
ACOE	ACOE	4163171046	ACOE Fish Barrier Romeoville IIB	Romeoville	IL		3	1046.5897	1370.4278	COMP DECL SUPPLY GROUP	R76	2016	5	31	5/2/16	6/2/16	828444	316673	511771	1,296.00	1,296.00
ACOE	ACOE	4163171046	ACOE Fish Barrier Romeoville IIB	Romeoville	IL		3	1046.5897	1370.4278	COMP DECL SUPPLY GROUP	R76	2016	4	31	4/1/16	5/2/16	871251	321493	549758	1,289.70	1,308.53
ACOE	ACOE	4163171046	ACOE Fish Barrier Romeoville IIB	Romeoville	IL		3	1046.5897	1370.4278	COMP DECL SUPPLY GROUP	R76	2016	3	24	3/8/16	4/1/16	741280	299665	441615	1,530.54	1,555.52
ACOE	ACOE	4163171046	ACOE Fish Barrier Romeoville IIB	Romeoville	IL		3	1046.5897	1370.4278	COMP DECL SUPPLY GROUP	R76	2016	2	29	2/8/16	3/8/16	836246	323444	512802	1,412.57	1,495.01
ACOE	ACOE	4163171046	ACOE Fish Barrier Romeoville IIB	Romeoville	IL		3	1046.5897	1370.4278	COMP DECL SUPPLY GROUP	R76	2016	1	32	1/7/16	2/8/16	506511	183671	322840	1,312.02	1,346.76
GSA	GSA	9232012000	219 S.Dearborn St	Chicago	IL		10	8155.7957	10663.6157	COMP DECL SUPPLY GROUP	RV5	2016	11	33	11/9/16	12/12/16	3157286	0	0	8,214.15	8,214.15
GSA	GSA	9232012000	219 S.Dearborn St	Chicago	IL		10	8155.7957	10663.6157	COMP DECL SUPPLY GROUP	RV5	2016	10	28	10/12/16	11/9/16	2713543	0	0	8,897.38	8,897.38
GSA	GSA	9232012000	219 S.Dearborn St	Chicago	IL		10	8155.7957	10663.6157	COMP DECL SUPPLY GROUP	RV5	2016	9	30	9/12/16	10/12/16	3164210	0	0	9,719.44	9,719.44
GSA	GSA	9232012000	219 S.Dearborn St	Chicago	IL		10	8155.7957	10663.6157	COMP DECL SUPPLY GROUP	RV5	2016	8	31	8/12/16	9/12/16	3661464	0	0	10,832.10	10,832.10
GSA	GSA	9232012000	219 S.Dearborn St	Chicago	IL		10	8155.7957	10663.6157	COMP DECL SUPPLY GROUP	RV5	2016	7	29	7/14/16	8/12/16	3813799	2043123	1770676	11,077.42	11,077.42
GSA	GSA	9232012000	219 S.Dearborn St	Chicago	IL		10	8155.7957	10663.6157	COMP DECL SUPPLY GROUP	RV4	2016	6	30	6/14/16	7/14/16	3658317	1920462	1737855	11,309.68	11,309.68
GSA	GSA	9232012000	219 S.Dearborn St	Chicago	IL		10	8155.7957	10663.6157	COMP DECL SUPPLY GROUP	RV4	2016	5	34	5/11/16	6/14/16	3567561	1856647	1710914	9,897.60	9,897.60
GSA	GSA	9232012000	219 S.Dearborn St	Chicago	IL		10	8155.7957	10663.6157	COMP DECL SUPPLY GROUP	RV4	2016	4	29	4/12/16	5/11/16	2877181	1541572	1335609	9,248.17	9,248.17
GSA	GSA	9232012000	219 S.Dearborn St	Chicago	IL		10	8155.7957	10663.6157	COMP DECL SUPPLY GROUP	RV4	2016	3	29	3/14/16	4/12/16	2891145	1535094	1356051	7,824.16	7,824.16
GSA	GSA	9232012000	219 S.Dearborn St	Chicago	IL		10	8155.7957	10663.6157	COMP DECL SUPPLY GROUP	RV4	2016	2	31	2/12/16	3/14/16	3154533	1624336	1530197	8,691.27	8,691.27
GSA	GSA	9232012000	219 S.Dearborn St	Chicago	IL		10	8155.7957	10663.6157	COMP DECL SUPPLY GROUP	RV4	2016	1	29	1/14/16	2/12/16	3173753	1625464	1548289	9,171.04	9,194.04
GSA	GSA	9232012000	219 S.Dearborn St	Chicago	IL		10	8155.7957	10663.6157	COMP DECL SUPPLY GROUP	RV4	2015	12	34	12/11/15	1/14/16	3396762	1623593	1773169	9,013.29	9,013.29

Duke Historical Data Summary

Sum of Actual or On Peak KWH									Month
Agency	AccountName	AccountNumber	Service Address	Service City	Service State	Meter Number	PLC	NSPL	1	2	3	4	5	6	7	8	9	10	11	12	Grand Total
EPA	US EPA	3450082301	1600 GEST	CINCINNATI	OH	108069748	328.83	322.66	104,721	99,024	99,287	101,936	127,123	148,861	168,364	177,906	129,078	106,014	104,498	100,857	1,467,669
		3690067401	26 M L KING DR W	CINCINNATI	OH	108051724, 108051757	2912.52	2959.04	908,179	801,629	838,982	897,614	875,995	1,081,296	1,347,187	1,440,538	1,299,413	996,528	914,194	842,270	12,243,825
		7380074701	5995 CENTER HILL RD	CINCINNATI	OH	106986043, 9180075001	196.57	224.58	56,440	50,394	50,732	54,012	61,272	76,520	82,881	87,308	72,541	51,528	54,930	53,260	751,818
GSA	GSA - OH 0028CN	3220074001	500 WALNUT	CINCINNATI	OH	106035844 ,106165234	604.27	684.7	249,618	229,457	228,747	236,766	213,595	228,626	236,512	233,629	248,900	212,014	215,075	254,008	2,786,947
	GSA 84402006	8580067401	550 MAIN	CINCINNATI	OH	106939913, 83041155, 83041946	1110.7	1219.61	439,155	397,822	393,266	417,058	406,450	423,944	447,408	451,636	441,280	381,338	382,897	449,110	5,031,364
	GSA FINANCE DIVISION	7360213701	6751 STEGER DR	CINCINNATI	OH	106165287, 108022473, 143323213, 143323219	1124.94	1346.71	320,714	300,480	305,261	344,701	361,319	542,763	584,096	728,291	644,896	421,488	333,185	330,159	5,217,353
VA	VETERANS ADMIN HOSP 539	9180075001	3200 VINE	CINCINNATI	OH	144323797	3600.4	3988.38	1,272,362	1,258,990	1,403,333	1,490,095	1,584,629	1,883,443	2,250,271	2,033,450	1,887,574	1,446,398	1,526,882	1,592,258	19,629,685
Grand Total									3,351,189	3,137,796	3,319,608	3,542,182	3,630,383	4,385,453	5,116,719	5,152,758	4,723,682	3,615,308	3,531,661	3,621,922	47,128,661

Duke Historical Data

AccountName	Agency	AccountNumber	Service Address	Service City	Service State	Service Zip	Meter Reading Cycle	PLC	NSPL	Duke Energy Rate Code	Meter Number	Year	Month	Days	FromDate	ToDate	Billed KW	Actual or On Peak KWH	Off Peak KWH	Actual or On Peak KW	Off Peak KW	Actual On Peak KVA	Off Peak KVA	Actual Or On Peak PF	Off Peak PF	Info
GSA - OH 0028CN	GSA	3220074001	500 WALNUT	CINCINNATI	OH	45202	N/A	604.27	684.7		106035844 ,106165234	2016	12	33	11/16/16	12/19/16	636	254008		636		669.4		0.95
GSA - OH 0028CN	GSA	3220074001	500 WALNUT	CINCINNATI	OH	45202	N/A	604.27	684.7		106035844 ,106165234	2016	11	29	10/18/16	11/16/16	612	215075		612		648.2		0.944
GSA - OH 0028CN	GSA	3220074001	500 WALNUT	CINCINNATI	OH	45202	N/A	604.27	684.7		106035844 ,106165234	2016	10	29	9/19/16	10/18/16	580.8	212014		580.8		626.6		0.927
GSA - OH 0028CN	GSA	3220074001	500 WALNUT	CINCINNATI	OH	45202	N/A	604.27	684.7		106035844 ,106165234	2016	9	32	8/18/16	9/19/16	652.8	248900		652.8		697.2		0.936
GSA - OH 0028CN	GSA	3220074001	500 WALNUT	CINCINNATI	OH	45202	N/A	604.27	684.7		106035844 ,106165234	2016	8	27	7/22/16	8/18/16	682.1	233629		682.1		727.1		0.938
GSA - OH 0028CN	GSA	3220074001	500 WALNUT	CINCINNATI	OH	45202	N/A	604.27	684.7		106035844 ,106165234	2016	7	30	6/22/16	7/22/16	610.7	236512		610.7		651.4		0.937
GSA - OH 0028CN	GSA	3220074001	500 WALNUT	CINCINNATI	OH	45202	N/A	604.27	684.7		106035844 ,106165234	2016	6	30	5/23/16	6/22/16	616.1	228626		616.1		664.8		0.927
GSA - OH 0028CN	GSA	3220074001	500 WALNUT	CINCINNATI	OH	45202	N/A	604.27	684.7		106035844 ,106165234	2016	5	31	4/22/16	5/23/16	558.71	213595		558.3		593.1		0.941
GSA - OH 0028CN	GSA	3220074001	500 WALNUT	CINCINNATI	OH	45202	N/A	604.27	684.7		106035844 ,106165234	2016	4	30	3/23/16	4/22/16	603.9	236766		603.9		642.2		0.94
GSA - OH 0028CN	GSA	3220074001	500 WALNUT	CINCINNATI	OH	45202	N/A	604.27	684.7		106035844 ,106165234	2016	3	29	2/23/16	3/23/16	644.5	228747		644.5		685.4		0.94
GSA - OH 0028CN	GSA	3220074001	500 WALNUT	CINCINNATI	OH	45202	N/A	604.27	684.7		106035844 ,106165234	2016	2	29	1/25/16	2/23/16	608.2	229457		608.2		655.8		0.927
GSA - OH 0028CN	GSA	3220074001	500 WALNUT	CINCINNATI	OH	45202	N/A	604.27	684.7		106035844 ,106165234	2016	1	34	12/22/15	1/25/16	586.2	249618		586.2		637		0.92
US EPA	EPA	3450082301	1600 GEST	CINCINNATI	OH	45204	10	328.83	322.66		108069748	2016	11	33	11/10/16	12/13/16	347.65	104498		229.1		250.4		0.915
US EPA	EPA	3450082301	1600 GEST	CINCINNATI	OH	45204	10	328.83	322.66		108069748	2016	10	29	10/12/16	11/10/16	368.6	106014		368.6		381.6		0.966
US EPA	EPA	3450082301	1600 GEST	CINCINNATI	OH	45204	10	328.83	322.66		108069748	2016	9	29	9/13/16	10/12/16	416.6	129078		416.6		434.6		0.959
US EPA	EPA	3450082301	1600 GEST	CINCINNATI	OH	45204	10	328.83	322.66		108069748	2016	8	32	8/12/16	9/13/16	409	177906		409		425.8		0.961
US EPA	EPA	3450082301	1600 GEST	CINCINNATI	OH	45204	10	328.83	322.66		108069748	2016	7	29	7/14/16	8/12/16	380.8	168364		380.8		393.7		0.967
US EPA	EPA	3450082301	1600 GEST	CINCINNATI	OH	45204	10	328.83	322.66		108069748	2016	6	30	6/14/16	7/14/16	394.2	148861		394.2		408.6		0.965
US EPA	EPA	3450082301	1600 GEST	CINCINNATI	OH	45204	10	328.83	322.66		108069748	2016	5	32	5/13/16	6/14/16	364.99	127123		351.4		363.6		0.966
US EPA	EPA	3450082301	1600 GEST	CINCINNATI	OH	45204	10	328.83	322.66		108069748	2016	4	29	4/14/16	5/13/16	364.99	101936		266.9		288.2		0.926
US EPA	EPA	3450082301	1600 GEST	CINCINNATI	OH	45204	10	328.83	322.66		108069748	2016	3	30	3/15/16	4/14/16	364.99	99287		227.8		265.8		0.857
US EPA	EPA	3450082301	1600 GEST	CINCINNATI	OH	45204	10	328.83	322.66		108069748	2016	2	29	2/15/16	3/15/16	364.99	99024		225.3		261		0.863
US EPA	EPA	3450082301	1600 GEST	CINCINNATI	OH	45204	10	328.83	322.66		108069748	2016	1	31	1/15/16	2/15/16	364.99	104721		181.1		193.4		0.936
US EPA	EPA	3450082301	1600 GEST	CINCINNATI	OH	45204	10	328.83	322.66		108069748	2015	12	32	12/14/15	1/15/16	364.99	100857		176		186.8		0.942
US EPA	EPA	3690067401	26 M L KING DR W	CINCINNATI	OH	45220	N/A	2912.52	2959.04		108051724, 108051757	2016	12	31	11/14/16	12/15/16	2464.32	842270		1939.2		2138.9		0.907
US EPA	EPA	3690067401	26 M L KING DR W	CINCINNATI	OH	45220	N/A	2912.52	2959.04		108051724, 108051757	2016	11	31	10/14/16	11/14/16	2581.1	914194		2572.8		2867.9		0.897
US EPA	EPA	3690067401	26 M L KING DR W	CINCINNATI	OH	45220	N/A	2912.52	2959.04		108051724, 108051757	2016	10	29	9/15/16	10/14/16	2630.4	996528		2630.4		2911.4		0.903
US EPA	EPA	3690067401	26 M L KING DR W	CINCINNATI	OH	45220	N/A	2912.52	2959.04		108051724, 108051757	2016	9	30	8/16/16	9/15/16	2822.4	1299413		2822.4		3134.4		0.9
US EPA	EPA	3690067401	26 M L KING DR W	CINCINNATI	OH	45220	N/A	2912.52	2959.04		108051724, 108051757	2016	8	29	7/18/16	8/16/16	2899.2	1440538		2899.2		3220.2		0.9
US EPA	EPA	3690067401	26 M L KING DR W	CINCINNATI	OH	45220	N/A	2912.52	2959.04		108051724, 108051757	2016	7	32	6/16/16	7/18/16	2880	1347187		2880		3194.6		0.902
US EPA	EPA	3690067401	26 M L KING DR W	CINCINNATI	OH	45220	N/A	2912.52	2959.04		108051724, 108051757	2016	6	30	5/17/16	6/16/16	2673.9	1081296		2668.8		2971		0.898
US EPA	EPA	3690067401	26 M L KING DR W	CINCINNATI	OH	45220	N/A	2912.52	2959.04		108051724, 108051757	2016	5	29	4/18/16	5/17/16	2550.2	875995		2534.4		2833.5		0.894
US EPA	EPA	3690067401	26 M L KING DR W	CINCINNATI	OH	45220	N/A	2912.52	2959.04		108051724, 108051757	2016	4	32	3/17/16	4/18/16	2545.92	897614		1900.8		2096		0.907
US EPA	EPA	3690067401	26 M L KING DR W	CINCINNATI	OH	45220	N/A	2912.52	2959.04		108051724, 108051757	2016	3	29	2/17/16	3/17/16	2545.92	838982		1843.2		2043.9		0.902
US EPA	EPA	3690067401	26 M L KING DR W	CINCINNATI	OH	45220	N/A	2912.52	2959.04		108051724, 108051757	2016	2	29	1/19/16	2/17/16	2545.92	801629		1708.8		1906.2		0.896
US EPA	EPA	3690067401	26 M L KING DR W	CINCINNATI	OH	45220	N/A	2912.52	2959.04		108051724, 108051757	2016	1	34	12/16/15	1/19/16	2545.92	908179		1804.8		2026.5		0.891
GSA FINANCE DIVISION	GSA	7360213701	6751 STEGER DR	CINCINNATI	OH	45237	N/A	1124.94	1346.71		106165287, 108022473, 143323213, 143323219	2016	12	33	11/17/16	12/20/16	1119.96	330159		765.6		838		0.914
GSA FINANCE DIVISION	GSA	7360213701	6751 STEGER DR	CINCINNATI	OH	45237	N/A	1124.94	1346.71		106165287, 108022473, 143323213, 143323219	2016	11	29	10/19/16	11/17/16	1119.96	333185		906		985.4		0.919
GSA FINANCE DIVISION	GSA	7360213701	6751 STEGER DR	CINCINNATI	OH	45237	N/A	1124.94	1346.71		106165287, 108022473, 143323213, 143323219	2016	10	29	9/20/16	10/19/16	1119.96	421488		888		960.9		0.924
GSA FINANCE DIVISION	GSA	7360213701	6751 STEGER DR	CINCINNATI	OH	45237	N/A	1124.94	1346.71		106165287, 108022473, 143323213, 143323219	2016	9	32	8/19/16	9/20/16	1269.6	644896		1269.6		1391.2		0.913
GSA FINANCE DIVISION	GSA	7360213701	6751 STEGER DR	CINCINNATI	OH	45237	N/A	1124.94	1346.71		106165287, 108022473, 143323213, 143323219	2016	8	29	7/21/16	8/19/16	1281.6	728291		1281.6		1399.2		0.916
GSA FINANCE DIVISION	GSA	7360213701	6751 STEGER DR	CINCINNATI	OH	45237	N/A	1124.94	1346.71		106165287, 108022473, 143323213, 143323219	2016	7	30	6/21/16	7/21/16	1317.6	584096		1317.6		1448.3		0.91
GSA FINANCE DIVISION	GSA	7360213701	6751 STEGER DR	CINCINNATI	OH	45237	N/A	1124.94	1346.71		106165287, 108022473, 143323213, 143323219	2016	6	32	5/20/16	6/21/16	1052.64	542763		1042.8		1118.9		0.932
GSA FINANCE DIVISION	GSA	7360213701	6751 STEGER DR	CINCINNATI	OH	45237	N/A	1124.94	1346.71		106165287, 108022473, 143323213, 143323219	2016	5	29	4/21/16	5/20/16	1052.64	361319		872.4		952.7		0.916
GSA FINANCE DIVISION	GSA	7360213701	6751 STEGER DR	CINCINNATI	OH	45237	N/A	1124.94	1346.71		106165287, 108022473, 143323213, 143323219	2016	4	30	3/22/16	4/21/16	1052.64	344701		781.2		860.2		0.908
GSA FINANCE DIVISION	GSA	7360213701	6751 STEGER DR	CINCINNATI	OH	45237	N/A	1124.94	1346.71		106165287, 108022473, 143323213, 143323219	2016	3	29	2/22/16	3/22/16	1052.64	305261		732		806.4		0.908
GSA FINANCE DIVISION	GSA	7360213701	6751 STEGER DR	CINCINNATI	OH	45237	N/A	1124.94	1346.71		106165287, 108022473, 143323213, 143323219	2016	2	31	1/22/16	2/22/16	1052.64	300480		501.6		514.1		0.976
GSA FINANCE DIVISION	GSA	7360213701	6751 STEGER DR	CINCINNATI	OH	45237	N/A	1124.94	1346.71		106165287, 108022473, 143323213, 143323219	2016	1	32	12/21/15	1/22/16	1052.64	320714		786		865		0.909
US EPA	EPA	7380074701	5995 CENTER HILL RD	CINCINNATI	OH	45224	21	196.57	224.58		106986043, 9180075001	2016	12	31	11/29/16	12/30/16	189.89	53260		111.4		146.6		0.76
US EPA	EPA	7380074701	5995 CENTER HILL RD	CINCINNATI	OH	45224	21	196.57	224.58		106986043, 9180075001	2016	11	33	10/27/16	11/29/16	189.89	54930		145.9		182		0.802
US EPA	EPA	7380074701	5995 CENTER HILL RD	CINCINNATI	OH	45224	21	196.57	224.58		106986043, 9180075001	2016	10	29	9/28/16	10/27/16	189.89	51528		169.6		193.3		0.877
US EPA	EPA	7380074701	5995 CENTER HILL RD	CINCINNATI	OH	45224	21	196.57	224.58		106986043, 9180075001	2016	9	30	8/29/16	9/28/16	219.5	72541		219.5		269		0.816
US EPA	EPA	7380074701	5995 CENTER HILL RD	CINCINNATI	OH	45224	21	196.57	224.58		106986043, 9180075001	2016	8	31	7/29/16	8/29/16	223.4	87308		223.4		269.6		0.828
US EPA	EPA	7380074701	5995 CENTER HILL RD	CINCINNATI	OH	45224	21	196.57	224.58		106986043, 9180075001	2016	7	30	6/29/16	7/29/16	222.1	82881		222.1		268.9		0.826
US EPA	EPA	7380074701	5995 CENTER HILL RD	CINCINNATI	OH	45224	21	196.57	224.58		106986043, 9180075001	2016	6	29	5/31/16	6/29/16	214.4	76520		214.4		263.4		0.814
US EPA	EPA	7380074701	5995 CENTER HILL RD	CINCINNATI	OH	45224	21	196.57	224.58		106986043, 9180075001	2016	5	32	4/29/16	5/31/16	180.03	61272		168.3		215.8		0.78
US EPA	EPA	7380074701	5995 CENTER HILL RD	CINCINNATI	OH	45224	21	196.57	224.58		106986043, 9180075001	2016	4	29	3/31/16	4/29/16	180.03	54012		164.5		214.9		0.766
US EPA	EPA	7380074701	5995 CENTER HILL RD	CINCINNATI	OH	45224	21	196.57	224.58		106986043, 9180075001	2016	3	30	3/1/16	3/31/16	180.03	50732		146.6		165.2		0.887
US EPA	EPA	7380074701	5995 CENTER HILL RD	CINCINNATI	OH	45224	21	196.57	224.58		106986043, 9180075001	2016	2	29	2/1/16	3/1/16	180.03	50394		105.6		125.5		0.841
US EPA	EPA	7380074701	5995 CENTER HILL RD	CINCINNATI	OH	45224	21	196.57	224.58		106986043, 9180075001	2016	1	32	12/31/15	2/1/16	180.03	56440		108.2		124.7		0.867
GSA 84402006	GSA	8580067401	550 MAIN	CINCINNATI	OH	45202	N/A	1110.7	1219.61		106939913, 83041155, 83041946	2016	12	33	11/16/16	12/19/16	1152	449110

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated Nov 14, 2017.