PPL2014Exhibit1dataAmd1version.xls

XLS spreadsheet 402 KB Posted Aug 24, 2014

Attached to: Electric power supply for various Federal Accounts in Pennsylvania (PPL)
Solicitation number: GS-00P-14-BSD-1097
Issued by: General Services Administration Public Buildings Service Central Office Energy Division

About this file

From the source

Exhibit 1

View the file

Other files

File	Type	Posted
PPL2014ElecGS-00P-14-BSD-1097AmendNo2.doc	DOC document	Sep 5, 2014
GSA_PPL_2014_Solicitation_GS00P14BSD1097_AmendNo2_version.doc	DOC document	Sep 5, 2014
PPL2014SolicitationQ A.docx	DOCX document	Aug 24, 2014
AllenwoodPrisonInterconnectionLineDiagram_(1).pdf	PDF	Aug 24, 2014
PPL2014ElecGS-00P-14-BSD-1097AmendNo1.doc	DOC document	Aug 24, 2014
PPL2014Exhibit1data.xls	XLS spreadsheet	Aug 19, 2014
GSA_PPL_2014_Solicitation_GS00P14BSD1097.doc	DOC document	Aug 15, 2014

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.

Summary

		Note: Data provided will be updated in near future
				GSA Solicitation	GS-00P-14-BSD-1097
				PPL Accounts
				Exhibit 1 - Basic Monthly Data
		PRICING GROUP 1											Estimated Annual
Series	Zip	Interval	Estimated	Estimated		Meter	PPL						KWH
No.	Code	Data Y/N	ICAP (KW)	Transmission (KW)	Bill Cycle	Number	Rate Code	Account Number	Agency	Address	Location	State	Consumption
1	17954	Yes	1,257.28	1,372.44	17	93397779	LP4	7656033007	FCI Minersville	Rt 901	Minersville	PA	9,333,000
2	17752	Yes	6.76	9.00	18	93397570&86900583	LP4	2757045008	US Justice Dept	Bureau of Prison	Montgomery	PA	74,460
4	18472	Yes	1,989.41	2,017.83	6	93397257&88889419	LP4	4573560026	Federal Bur of Prison	3057 Easton TPKE, Prison	Waymart	PA	13,423,200
5	17837	Yes	1,728.49	1,649.18	17	93397200	LP4	8136050003	US Justice Dept	Institutional Acct RR3	Lewisburg	PA	10,327,200
6	17701	Yes	320.67	335.45	17	93397553	LP4	8778035008	GSA PA	240 W 3rd Street	Williamsport	PA	1,455,600
7	18701	Yes	259.81	196.05	2	93397404	LP4	8921029010	GSA Fin Div Utilities	197 S. Main Street	Wilkes Barre	PA	860,400
8	18702	Yes	991.28	931.39	3	93397350&93397372	LP4	0282030004	SSA	1150 E Mountain Drive	Wilkes Barre	PA	5,826,600
9	18702	Yes	2,939.15	2,653.97	20	93397378&93397373	LP4	7419041005	VA Hospital	1111 E End Blvd	Wilkes Barre	PA	16,891,200
10	18503	No	718.42	569.94	19	95702910	GS3	8942305426	GSA Federal Building	N Wash and Linden St	Scranton	PA	2,430,000
11	17108	No	793.33	595.49	10	90885663	GS3	6949066000	GSA Region 3	228 Walnut Street	Harrisburg	PA	2,797,800
12	18101	Yes	325.54	241.89	9	94710398	GS3	8368035490	Federal Bldg GSA Fin	5th and Hamilton Street	Allentown	PA	1,173,750
	*Data is from 2011		991	931									64,593,210
		PRICING GROUP 2
Series	Zip	Interval				Meter	PPL						KWH
No.	Code	Data Y/N	ICAP (KW)	Transmission (KW)	Bill Cycle	Number	Rate Code	Account Number	Agency	Address	Location	State	Consumption
3	17752	Yes	1,609.37	1,484.33	7	97128677	LP4	1486050007	US Justice Dept	New Allenwood Prison	Montgomery	PA	3,283,213

&Llast update 10/07/08hsp

Summary 0 0

Months Price/kwh NASA Pricing Comparison

Pricing Group 2 1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

PriceGrp1Totals 0 0

Months Price/kwh NASA Pricing Comparison

Cap & Trans 1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

1 1

#REF!

#REF!

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

0 0

Months Price/kwh NASA Pricing Comparison

Name

Region

Parent Account Name

UDC

UDC Account #

UDC Sub-Type

Site

Street Address Calc

City

State

Postal Code

HU Vintage Date

Meter Type

Load Factor

Control Area

Muni Code

Energy Zone

Capacity Zone

Peak Demand

Annual Usage

Annual OnPeak Usage

Annual OffPeak Usage

Rate Class

Rate Sub Class

Voltage

Capacity Rqmt KW

Meter Read Cycle

Transmission Req KW

Distribution Loss Factor

Load Profile

Tax Zip Override

Tax Classification

US Dept of Justice - 1486050007

Mid-Atlantic

General Services Administration - Pennsylvania

Pennsylvania Power & Light Company

1486050007

PPL

New Allenwood Prison

Montgomery

PA

177520000

7/2/14

Summary

0.168949

PJM

PPL

PPL

2,218

3,283,213

2,421,616

861,597

LP4

1,609.37

1

1,484.33

LP4

Commercial

*Allenwood Prison has a behind-the-meter cogeneration plant and will produce a substantial amount of RECs

HopeSParker:

Updated HopeSParker:

Updated HopeSParker:

Updated HopeSParker:

Updated HopeSParker:

Updated HopeSParker:

Updated HopeSParker:

Updated

Start	Stop	7656033007	2757045008	4573560026	8136050003	8778035008	8921029010	0282030004	7419041005	8942305426	6949066000	8368035490	Total
Jan-12	Feb-12	775800	13800		792000	133800	67200		1285200	193500			3261300
Feb-12	Mar-12	729000	9600	1180800	739200	101400	67200		1209600	195750	226200	88500	4547250
Mar-12	Apr-12	784800	7800	1099200	732000	90600	75600	500400	1270800	159000	228000	84750	5032950
Apr-12	May-12	698400	7800	1226400	686400	84000	88800	550800	1324800	201000	225000	87000	5180400
May-12	Jun-12	774000	9600	1226400	909600	94200	81600	585000	1551600	228750	265800	112500	5839050
Jun-12	Jul-12	896400	7800	1250400	1063200	111600	105600	574200	1620000	268500	290400	123000	6311100
Jul-12	Aug-12	808200	7800	1339200	976800	99600	87600	567000	1562400	266250	286200	126000	6127050
Aug-12	Sep-12	806400	7800	1279200	914400	93000	82800	568800	1569600	235500	292800	129750	5980050
Sep-12	Oct-12	802800	10200	1185600	861600	94200	70800	455400	1317600	178500	258000	104250	5338950
Oct-12	Nov-12	738000	9000	1128000	741600	102000	63600	486000	1414800	175500	201600	81750	5141850
Nov-12	Dec-12	766800	9600	1099200	880800	120000	70800	502200	1274400	183000	211200	87000	5205000
Dec-12	Jan-13	853200	10800	1233600	816000	156000	66000	455400	1249200	194250	209400	87000	5330850
Jan-13	Feb-13	781200	9600	1116000	742007.04	172200	64800	451800	1350000	186000	212400	78750	5164757
Feb-13	Mar-13	718200	7800	1075200	789600	133800	68400	495000	1166400	175500	201000	85500	4916400
Mar-13	Apr-13	786600	7200	1039200	727200	127800	70800	495000	1270800	184500	213600	87750	5010450
Apr-13	May-13	712800	5400	1101600	1142400	99600	76800	541800	1530000	200250	226800	96750	5734200
May-13	Jun-13	747000	6000	1096800	936000	99600	81600	505800	1537200	231750	238800	119250	5599800
Jun-13	Jul-13	864000	4800	1262400	847200	111000	98400	556200	1771200	280500	267600	126750	6190050
Jul-13	Aug-13	768600	4800	1190400	717600	96600	79200	504000	1602000	237000	277800	122250	5600250
Aug-13	Sep-13	775800	4800	1154400	792000	96600	80400	556200	1504800	227250	266400	128250	5586900
Sep-13	Oct-13	781200	6720	1142400	883200	86400	67200	468000	1375200	195000	249600	112500	5367420
Oct-13	Nov-13	716400	5220	1012800	828000	100800	60000	498600	1314000	174000	211800	72000	4993620
Nov-13	Dec-13	788400	8100	1070400	741600	153600	69600	482400	1364400	193500	205200	91500	5168700
Dec-13	Jan-14	876600	7560	1224000	813600	177600	64800	464400	1285200	198750	225000	90750	5428260
Jan-14	Feb-14	801000	7560	1096800	710400	188400	62400	459000	1270800	191250	208200	90750	5086560
Feb-14	Mar-14	720000	7560	1077600	943200	141000	67200	448200	1170000	178500	200400	81750	5035410
Mar-14	Apr-14	802800	6300	1161600	972000	120000	67200	459000	1422000	193500	210000	75750	5490150
Apr-14	May-14	682200	4860	1012800	0	93000	80400	504000	1386000	177000	233400	83250	4256910
May-14	Jun-14	788400	6480	1072800	0	99000	78000	475200	1436400	216000	242400	103500	4518180
Jun-14	Jul-14	831600	4500	1207200	0	102600	84000	507600	1760400	248250	267600	121500	5135250

Acct Number	Rate Class	Cap PLC	NITS PLC	Cap PLC Date	NITS PLC Date	Loss Factor	Interval Meter	Peak Demand	Annual Usage
0282030004	LP4	991.28	931.39	06/01/2014	01/01/2014	3.73	Y	972.00	5,946,542
2757045008	L4L	6.76	9.00	06/01/2014	01/01/2014	3.73	Y	31.00	84,450
4573560026	LP4	1,989.41	2,017.83	06/01/2014	01/01/2014	3.73	Y	2,185.00	13,588,789
6949066000	OP3	793.33	595.49	06/01/2014	01/01/2014	6.37	Y	883.00	2,778,709
7419041005	LP4	2,939.15	2,653.97	06/01/2014	01/01/2014	3.73	Y	3,048.00	16,905,430
7656033007	LP4	1,257.28	1,372.44	06/01/2014	01/01/2014	3.73	Y	1,567.00	9,347,998
8136050003	LP4	1,728.49	1,649.18	06/01/2014	01/01/2014	3.73	Y	1,738.00	10,169,218
8368035490	GS3	325.54	241.89	06/01/2014	01/01/2014	6.37	Y	795.00	1,190,329
8778035008	L4L	320.67	335.45	06/01/2014	01/01/2014	3.73	Y	623.00	1,428,071
8921029010	L4L	259.81	196.05	06/01/2014	01/01/2014	3.73	Y	270.00	880,539
8942305426	OP3	718.42	569.94	06/01/2014	01/01/2014	6.37	Y	831.00	2,443,755

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