Attachment XI - 4CP Report Sample.xlsx

XLSX spreadsheet 30 KB Posted Mar 22, 2023

Attached to: ERCOT CFE Electricity 2023
Solicitation number: SPE60423R0400
Issued by: Defense Logistics Agency Energy

About this file

Written by GovTribe AI · Dec 30, 2023

This solicitation requests proposals for the supply of carbon pollution-free electricity and ancillary services to Department of Defense and other federal agency installations located in the Electric Reliability Council of Texas region. The Defense Logistics Agency Energy seeks offers for a three-year delivery period from January 2024 through January 2027 totaling an estimated 1,340,500,819 kilowatt hours. Awards will be either firm-fixed-price or fixed-price requirements contracts using real-time settlement point pricing. Interested parties should submit any questions by January 27, 2023 and are encouraged to submit responsive proposals for consideration.

View the file

Other files

File	Type	Posted
Attachment I - Installation Data Sheet 0007.xlsx	XLSX spreadsheet	Nov 8, 2023
SPE60423R0400 0007 Solicitation.pdf	PDF	Nov 8, 2023
SF30 SPE60423R0400 0007.pdf	PDF	Nov 8, 2023
Attachment V - Fort Cavazos Invoice Verification Checklist.pdf	PDF	Oct 17, 2023
SPE60423R0400 0006 Solicitation.pdf	PDF	Oct 17, 2023
Attachment X - Pricing Sheet 0006.xlsx	XLSX spreadsheet	Oct 17, 2023
Attachment VI - Navy Service Point ID (SPID) List 0006.xlsx	XLSX spreadsheet	Oct 17, 2023
Attachment XIV - SPR Invoicing Requirements.pdf	PDF	Oct 17, 2023
SF30 SPE60423R0400 0006.pdf	PDF	Oct 17, 2023
Attachment VII - AAFES Block Purchase Schedule 0006.pdf	PDF	Oct 17, 2023
Attachment XIII - CLIN Invoicing Summary.xlsx	XLSX spreadsheet	Oct 17, 2023
Attachment I - Installation Data Sheet 0006.xlsx	XLSX spreadsheet	Oct 17, 2023
SPE60423R0400 0005 Solicitation.pdf	PDF	Aug 23, 2023
Attachment X - Pricing Sheet 0005.xlsx	XLSX spreadsheet	Aug 23, 2023
Attachment I - Installation Data Sheet 00005.xlsx	XLSX spreadsheet	Aug 23, 2023
SPE60423R0400 0005 - Tracked Changes.pdf	PDF	Aug 23, 2023
Attachment VII - AAFES Block Purchase Schedule 0005.pdf	PDF	Aug 23, 2023
SF30_SPE60423R04000005.PDF	PDF	Aug 23, 2023
Attachment IX - SPR Block Purchase Schedule 0005.pdf	PDF	Aug 23, 2023
SPE60423R0400 0004 Solicitation.pdf	PDF	Jun 30, 2023
SF30 SPE60423R0400 0004.pdf	PDF	Jun 30, 2023
Attachment X - Pricing Sheet 0003.xlsx	XLSX spreadsheet	Mar 27, 2023
SF30 SPE60423R0400 0003.pdf	PDF	Mar 27, 2023
Attachment VII - AAFES Block Purchase Schedule 0003.pdf	PDF	Mar 27, 2023
Attachment IX - SPR Block Purchase Schedule 0003.pdf	PDF	Mar 27, 2023
Attachment I - Installation Data Sheet 0002.xlsx	XLSX spreadsheet	Mar 22, 2023
Attachment X - Pricing Sheet 0002.xlsx	XLSX spreadsheet	Mar 22, 2023
Attachment VII - AAFES Block Purchase Schedule 0002.pdf	PDF	Mar 22, 2023
Attachment XII - Responses to Questions Received.pdf	PDF	Mar 22, 2023
SF30 SPE60423R0400 0002.pdf	PDF	Mar 22, 2023
Attachment II - Attestation Form 0002.pdf	PDF	Mar 22, 2023
SF30 SPE60423R0400 0001.pdf	PDF	Dec 20, 2022
Attachment VII - AAFES Block Purchase Schedule.pdf	PDF	Dec 16, 2022
Attachment VI - Navy Service Point ID (SPID) List.xlsx	XLSX spreadsheet	Dec 16, 2022
Attachment IX - SPR Block Purchase Schedule.pdf	PDF	Dec 16, 2022
Attachment III - Experience with End Users.pdf	PDF	Dec 16, 2022
Attachment V - Fort Hood Invoice Verification Checklist.pdf	PDF	Dec 16, 2022
Attachment X - Pricing Sheet.xlsx	XLSX spreadsheet	Dec 16, 2022
Attachment IV - Small Business Subcontracting Plan Requirements.pdf	PDF	Dec 16, 2022
SPE60423R0400 Solicitation.pdf	PDF	Dec 16, 2022
Attachment II - Attestation Form.pdf	PDF	Dec 16, 2022
Attachment I - Installation Data Sheet.xlsx	XLSX spreadsheet	Dec 16, 2022
Attachment VIII - NASA JSC Block Purchase Schedule.pdf	PDF	Dec 16, 2022

Show all 43

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.

Power Factor Solicitation SPE60423R0400 Attachment XI - 4CP Report Sample

Actual Demand and kVar
	Consumption		kVARH
Peak Interval	2466.18	<---Enter---->	736.02
Trans losses	2555.16		739.70
Divide by:	0.25		0.25
(> of 80% ratchet)	10,221	13380	2,959
Actual Demand and kVar	9,865	3,345.00	2,944.0800

Squared: 104,461,480.51 8,754,497.44

Summed divisor squared: 113,215,978

Divisor 10,640

Actual Power Factor:	0.961
Trans Voltage Adj PF, 3% per ONCOR

Lynn, Bobby Mr CIV USA: NOTE:

8-4-2020: Meter is on Low-Side, per Section 6.2.3.2 of Tariff.	0.932
	Target Power Factor:	0.95

Power Factor Adjustment Ratio: 1.01931

*PF Billing KW is the Higher of the Actual or 80% of the PF adjusted Ratchet for the previous 11 months			0.005
ERROR:#REF!	PF Billing KW	PF Billing 4 CP
	10418	9869
ERROR:#REF!
Location Svc: WFH-1
0.030	Trans Voltage Adjusted Power Factor (%)
8795	80% x PF Adjusted Ratchet (without losses)
9944	PF Adjusted Ratchet (with losses)
9865	PF Adjusted Ratchet (without losses)
9869	PF Adjusted 4CP
10221	Actual
10418	PF Adjusted KW (no losses)	*If the ratch was not PF adj, then PF ratio would be 1
10,470	PF Adjusted KW (with losses)	*If Actual is Higher then it would be PF adjusted
8,795	PREVIOUS Ratchet	*See PF Adjusted Ratchet Tab (for explanation)

PF Adjusted 4CP Solicitation SPE60423R0400 Attachment XI - 4CP Report Sample

Premise# 9416007
Power Factor Calculator for June				Power Factor Calculator for July
	Consumption		kVARH		Consumption		kVARH
6/23/21 17:00	1999.0691	<---Values---->	1355.8201	7/26/21 17:00	1963.1771	<---Values---->	1397.5801
Divide by:	0.25		0.25	Divide by:	0.25		0.25
	7,996		5,423.2803		7,853		5,590.3203

Squared:	63,940,435.6255		29,411,968.9954	Squared:	61,665,030.4719		31,251,681.2802
Summed divisor squared:		93,352,405		Summed divisor squared:		92,916,712
Divisor		9,662		Divisor		9,639
Actual Power Factor:		0.8276087		Actual Power Factor:		0.8146528
Trans Voltage Adj PF, 3% per ONCOR		0.80278		Trans Voltage Adj PF, 3% per ONCOR		0.79021
Target Power Factor:		0.950		Target Power Factor:		0.950
Power Factor Adjustment Ratio:		1.18339		Power Factor Adjustment Ratio:		1.20221

Power Factor Calculator for August				Power Factor Calculator for September
	Consumption		kVARH		Consumption		kVARH
8/24/21 17:00	2043.1893	<---Values---->	1501.3351	9/1/21 17:00	2218.9819	<---Values---->	1477.5299
Divide by:	0.25		0.25	Divide by:	0.25		0.25
	8,173		6,005.3403		8,876		5,910.1196

Squared:	66,793,962.2116		36,064,112.3590	Squared:	78,782,092.8907		34,929,514.1591
Summed divisor squared:		102,858,075		Summed divisor squared:		113,711,607
Divisor		10,142		Divisor		10,664
Actual Power Factor:		0.8058		Actual Power Factor:		0.8323603
Trans Voltage Adj PF, 3% per ONCOR		0.78167		Trans Voltage Adj PF, 3% per ONCOR		0.80739
Target Power Factor:		0.950		Target Power Factor:		0.950
Power Factor Adjustment Ratio:		1.21535		Power Factor Adjustment Ratio:		1.17663

PF Adjusted 4CP Calculation:
Date and Time Interval	Peak kW	Power Factor Ratio	Total
6/23/21 17:00	7996.28	1.1834	9,462.69
7/26/21 17:00	7852.71	1.2022	9,440.58
8/24/21 17:00	8172.76	1.2154	9,932.79
9/1/21 17:00	8875.93	1.1766	10,443.70
PF Billing 4 CP(without losses)			9,819.94
PF Billing 4 CP(with losses)			9,869.04
		Loss1-->	0.005
I N P U T D A T A F R O M O N C O R
DATE/TIME/GROUP	KWH	KVARs	<-- INFORMATION provided by Oncor
6/23/21 17:00	1999.06909	1355.82007
7/26/21 17:00	1963.17712	1397.58008
8/24/21 17:00	2043.18933	1501.33508
9/1/21 17:00	2218.98193	1477.52991

File details come from the government source that posted it. Updated Mar 22, 2023.