B8. IRA Project Submittal_ Reporting Form (Reference Doc for Post-Award).xlsx

XLSX spreadsheet 3 MB Posted May 31, 2024

Attached to: General Construction of Land Port of Entry Facility GSA PBS Region 2 in Rouses Point, New York
Solicitation number: 47PC0624R0001
Issued by: General Services Administration Public Buildings Service Region 2

About this file

Written by GovTribe AI · May 31, 2024

This document appears to be an Excel spreadsheet titled "B8. IRA Project Submittal_ Reporting Form" which is a reference document for a post-award federal contract opportunity.

The key details of the related federal contract opportunity are:

Solicitation Number: 47PC0624R0001

Name: General Construction of Land Port of Entry Facility GSA PBS Region 2 in Rouses Point, New York

Agency: General Services Administration (GSA) Public Buildings Service Region 2

Scope: Construction of a new approximately 13,000 square foot U.S. Land Port of Entry (LPOE) facility in Rouses Point, New York to replace the existing LPOE. Construction requirements include commercial and non-commercial vehicle inspection facilities, railways, utilities, site work, and sustainability features targeting LEED Gold certification.

Procurement Approach: Best Value Tradeoff Source Selection with non-price factors more important than Total Evaluated Price. Key evaluation factors include Sustainability (Inflation Reduction Act), Project Labor Agreement, and Subcontracting Methodology.

Pricing: Firm-Fixed Price contract, with a magnitude between $25-35 million. Bid guarantee (bond) of 20% of bid price or $3 million required.

Proposal Due Date: June 12, 2024 by 5:30pm ET.

View the file

Other files

File	Type	Posted
C3. Questions & Answers from RFI Period 3_rev070124.pdf	PDF	Jul 1, 2024
C3. Questions & Answers from RFI Period 3_v062824.pdf	PDF	Jun 28, 2024
C5. 47PC0624R0001 Solicitation Rouses LPOE General Construction vJune2024.pdf	PDF	Jun 28, 2024
C2. Attachment 5 - IRA Sustainability Factor Table_rev060524 w GSA weights.xlsx	XLSX spreadsheet	Jun 28, 2024
C1. RFP Amendment 2_Latest Changes and Attachments.pdf	PDF	Jun 28, 2024
C6. SF30 47PC0624R0001 RFP Amendment03 - acknowledge by signing and returning.pdf	PDF	Jun 28, 2024
B4. 47PC0624R0001 Rouses GC_Reps and Certs GC v0424 (Form C301).docx	DOCX document	May 31, 2024
B5. SF30 47PC0624R0001 RFP Amendment02 - acknowledge by signing and returning.pdf	PDF	May 31, 2024
B10. Instructions to SAM Entities Trying to Request Controlled Docs Access rev051524.pdf	PDF	May 31, 2024
B1. RFP Amendment 2_ IRA link - Latest Changes - Table of Contents.pdf	PDF	May 31, 2024
B6. Attachment 4 - IRA Weighted Score - addtl concrete_cement note added 053124.docx	DOCX document	May 31, 2024
B3. 47PC0624R0001 Solicitation Rouses LPOE General Construction amend02_053124.pdf	PDF	May 31, 2024
B11. Questions & Answers from RFI Period 2.pdf	PDF	May 31, 2024
B9. IRA Project Submittal Form and Data Dictionary PDF.pdf (Reference Doc for Post-Award).pdf	PDF	May 31, 2024
B7. Attachment 5 - IRA Sustainability Factor Table.xlsx	XLSX spreadsheet	May 31, 2024
A4. Local Unions' Contact Information - Rouses Point, NY.pdf	PDF	May 8, 2024
A2. SF30 47PC0624R0001 RFP Amendment01 - acknowledge by signing and returning.pdf	PDF	May 8, 2024
A6. Rouses LPOE GC Contractor Deliverables Checklist_updated 8May2024.pdf	PDF	May 8, 2024
A5. Instructions to SAM Entities Trying to Request Controlled Docs Access.pdf	PDF	May 8, 2024
A1. Rouses GC RFP 47PC0624R0001 Amendment 01 table of contents - QA - Scope Considerations.pdf	PDF	May 8, 2024
A3. SF1442 Corrected for 47PC0624R0001 v050824.pdf	PDF	May 8, 2024
Pricing Proposal Attachments 47PC0624R0001.zip	ZIP file	Apr 22, 2024
47PC0624R0001 Solicitation Rouses LPOE General Construction vApril2024.pdf	PDF	Apr 22, 2024
47PC0624R0001 Rouses Point LPOE Proposals Checklist.xlsx	XLSX spreadsheet	Apr 22, 2024
Technical Proposal Attachments 47PC0624R0001.zip	ZIP file	Apr 22, 2024
47PC0624R0001 Rouses LPOE GC Draft Agreement vApril2024.pdf	PDF	Apr 22, 2024
Reference Docs 47PC0624R0001.zip	ZIP file	Apr 22, 2024

Show all 27

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.

User Workflow

Click Here for User Workflow Chart https://docs.google.com/drawings/d/1oaECGj2-wo5r56G18gN6DX_vNrEJccTXl9yWmAqIlkI/edit LEC Instructions

#REF!

E&ST and HPGB Instructions

#REF!

Low Embodied Carbon Materials

Region	Contractor Name	Project Manager Name
Project Number (in Kahua)	Contractor Email Address	Project Manager Email Address
Project Type (non-ESPC or ESPC?)		Project Manager Approval Date
Enter Work Item Information Below:			Design-Build or Construction Team: Enter LEC Installation Information & Outcomes	Construction Manager as Advisor (CMa) or Commissioning Provider (CxP)

Certify information below:

Combined WI ID

Row Has Any Value

Min Requirements Met

Row Number

Region

First Column Address

Duplicate Check

Contractor Name

Contractor Email Address

Project Manager Name

Project Manager Email Address

Enter your email address

Milestone Status

Building Number

: Location Code (from REXUS)

Building Name

Project # (Kahua)

Accounting String ID (ASID)

: (8-digit alphanumeric string)

Work Item (WI) #

: 4 digit numeric string

Budget Activity Code

: PG Code for LEC projects: PG24

LEC Identifier

: Unique identifier for project teams to use during data entry process, if necessary. Example, ECM number in TO Schedule

LEC Material Category

LEC Material Subcategory

Declared Unit

GWP Limit Specified in the Contract

: Top 20% of Contract Limits by Material Subcategory

New GWP Limit Specified in the Contract (if Different than Previous Column)

Reported Threshold Target

Calculated Threshold Achieved

Provide link for Material EPD

Description of Material Installed

: Brief description of what material was used for on the project, supplier, mix type etc.

: Location Code (from REXUS) : (8-digit alphanumeric string) : 4 digit numeric string : PG Code for LEC projects: PG24

: Unique identifier for project teams to use during data entry process, if necessary. Example, ECM number in TO Schedule		Quantity	Quantity Reporting Unit	Product Category Rule (PCR)	Product Specific GWP	Conversion Factor A	Conversion Factor A Units	Conversion Factor B	Embodied Carbon Reduction (Calculated)
Upstream Scope 3	Upstream Plant's ENERGY STAR Energy Performance Score

: For glass, upstream cement plant, and steel from integrated mills, ask manufacturer to generate and report their ENERGY STAR Energy Performance Score per: http://www.energystar.gov/epis

Any cement, glass, or integrated steel plant based in the U.S. can use the free ENERGY STAR Energy Performance Indicator tool to generate a score, even if the plant is not ENERGY STAR certified.

: Top 20% of Contract Limits by Material Subcategory

Year of plant's ENERGY STAR Energy Performance Score

Certify information for this row is accurate

Certify the embodied carbon calculations

: Certify that the quantity is accurate, and reported product-specific GWP matches the identified EPD

Email of Certifier

||||

FALSE

||||

FALSE

||||

FALSE

||||

FALSE

||||

FALSE

L10

FALSE

||||

FALSE

L11

FALSE

||||

FALSE

L12

FALSE

||||

FALSE

L13

FALSE

||||

FALSE

L14

FALSE

||||

FALSE

L15

FALSE

||||

FALSE

L16

FALSE

||||

FALSE

L17

FALSE

||||

FALSE

L18

FALSE

||||

FALSE

L19

FALSE

||||

FALSE

L20

FALSE

||||

FALSE

L21

FALSE

https://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edit EPD Compliance

	Source:	How to assess EPD compliance
	LEC Material Category	LEC Example Select LEC Material Subcategory	Helper Column	Declared Unit	Quantity Reporting Unit	Better Than Average Limit (kgCO2e/Declared Unit)	Top 40% Limit (kgCO2e/Declared Unit)	Top 20% Limit (kgCO2e/Declared Unit)	Conversion Factors (To Metric)
	Concrete (and cement or CMUs)	Select LEC Material Subcategory below	Concrete (and cement or CMUs)-Select LEC Material Subcategory below						metric ton	1
	Concrete (and cement or CMUs)	≤2499	Concrete (and cement or CMUs)-≤2499	cubic meter	cubic yard	277	261	228	cubic meter	1
	Concrete (and cement or CMUs)	3000	Concrete (and cement or CMUs)-3000	cubic meter	cubic yard	318	291	257	U.S. ton	0.907185
	Concrete (and cement or CMUs)	4000	Concrete (and cement or CMUs)-4000	cubic meter	cubic yard	352	326	284	cubic yard	0.764555
	Concrete (and cement or CMUs)	5000	Concrete (and cement or CMUs)-5000	cubic meter	cubic yard	382	357	305
	Concrete (and cement or CMUs)	6000	Concrete (and cement or CMUs)-6000	cubic meter	cubic yard	407	374	319
	Concrete (and cement or CMUs)	≥7200	Concrete (and cement or CMUs)-≥7200	cubic meter	cubic yard	402	362	321
	Concrete (and cement or CMUs)	HESC≤2499
: High early strength concrete should be avoided where possible. Is there a need for it in this project?	Concrete (and cement or CMUs)-HESC≤2499	cubic meter	cubic yard	360.1	339.3	296.4
	Concrete (and cement or CMUs)	HESC3000
: HESC4000	Concrete (and cement or CMUs)-HESC3000	cubic meter	cubic yard	413.4	378.3	334.1
	Concrete (and cement or CMUs)	HESC4000
: HESC4000	Concrete (and cement or CMUs)-HESC4000	cubic meter	cubic yard	457.6	423.8	369.2
	Concrete (and cement or CMUs)	HESC5000
: HESC4000	Concrete (and cement or CMUs)-HESC5000	cubic meter	cubic yard	496.6	464.1	396.5
	Concrete (and cement or CMUs)	HESC6000
: HESC4000	Concrete (and cement or CMUs)-HESC6000	cubic meter	cubic yard	529.1	486.2	414.7
	Concrete (and cement or CMUs)	HESC≥7200
: HESC4000	Concrete (and cement or CMUs)-HESC≥7200	cubic meter	cubic yard	522.6	470.6	417.3
	Concrete (and cement or CMUs)	Cement

: Cement may only be used where provision of qualifying concrete is impractical.

: High early strength concrete should be avoided where possible. Is there a need for it in this project?

: HESC4000

: HESC4000	Concrete (and cement or CMUs)-Cement	metric ton	metric ton	858	819	751
	Concrete (and cement or CMUs)	Concrete Masonry Units	Concrete (and cement or CMUs)-Concrete Masonry Units	cubic meter	cubic meter	290	256	217
	Asphalt	Select LEC Material Subcategory below	Asphalt-Select LEC Material Subcategory below
	Asphalt	Asphalt	Asphalt-Asphalt	metric ton	U.S. ton	72.6	64.8	55.4
	Steel	Select LEC Material Subcategory below	Steel-Select LEC Material Subcategory below
	Steel	Rebar (fabricated)	Steel-Rebar (fabricated)	metric ton	metric ton	850	794	728
	Steel	Rebar (unfabricated)	Steel-Rebar (unfabricated)	metric ton	metric ton	760	716	611
	Steel	Hollow Structural Sections (fabricated)	Steel-Hollow Structural Sections (fabricated)	metric ton	metric ton	1,898	1854	1778
	Steel	Hollow Structural Sections from Electric Arc Furnaces (unfabricated)	Steel-Hollow Structural Sections from Electric Arc Furnaces (unfabricated)	metric ton	metric ton	1,652	1620	1580
	Steel	Hot-Rolled Sections (fabricated)	Steel-Hot-Rolled Sections (fabricated)	metric ton	metric ton	1,163	1128	1022
	Steel	Hot-Rolled Sections (unfabricated)	Steel-Hot-Rolled Sections (unfabricated)	metric ton	metric ton	869	713	686
	Steel	Cold-Formed and Galvanized (stud, track, framing, etc.)	Steel-Cold-Formed and Galvanized (stud, track, framing, etc.)	metric ton	metric ton	2,408	2324	2228
	Steel	Structural Steel Plate from Electric Arc Furnaces (unfabricated)	Steel-Structural Steel Plate from Electric Arc Furnaces (unfabricated)	metric ton	metric ton	1,190	1152	987
	Glass	Select LEC Material Subcategory below	Glass-Select LEC Material Subcategory below
	Glass	Flat Glass	Glass-Flat Glass	metric ton	metric ton	1,401	1370	1331

https://docs.google.com/presentation/d/10JM8-LF0kUJwtvaxAisV-IeyoZzLveKlUtMwCflCRQM/edit Emerging & Sustainable Tech and

Region

Contractor Name

Project Manager Name

Project Number (in Kahua)

Contractor Email Address

Project Manager Email Address

Project Type (non-ESPC or ESPC?)

Project Manager Approval Date

Enter Work Item Information Below:

Design-Build or Construction Team: Enter E&ST / HPGB Installation Information and Outcomes

Construction Manager as Advisor (CMa) or Commissioning Provider (CxP): Validate technology Installation

Combined WI ID

Row Has Any Value

Min Requirements Met

Row Number

Region

First Column Address

Duplicate Check

Contractor Name

Contractor Email Address

Project Manager Name

Project Manager Email Address

Enter your email address

Milestone Status

Building Number

: Location Code (from REXUS)

Building Name

Project # (Kahua)

Accounting String ID (ASID)

: 8-digit alphanumeric string

Work Item (WI) #

: 4 digit numeric string as reported in IRIS

Budget Activity Code

: PG Code for HPGB Projects: PG21

PG Code for E&ST Projects: PG27	IRA Program (E&ST, HPGB)	Select the guiding principle for the material or technology	Deep Energy Retrofit	All Electric Building	Net Zero Energy	Sustainable Building	Energy Conservation Measure /Water Conservation Measure (ECM/WCM) Identifier
: Unique identifier for project teams to use during data entry process, if necessary. Example, ECM number in TO Schedule	ECM/WCM Category
: AoA Dropdown	ECM/WCM Technology
: AoA Dropdown	Quantity Installed	TO Schedule Technology
: Auto populates based on ECM Category and Technology Selected	Emerging & Sustainable Technology
: Auto populates based on ECM Category and Technology Selected	ECM/WCM Default Design Life
: In years	Alternative ECM Design Life
: In years. If different than default. Max of 30 year design life	Primary Building Cooling Fuel	Primary Building Heating Fuel	Refrigerant Involved in ECM?	Refrigerant Type	Refrigerant Capacity (lbs)	Initial ECM/WCM implementation cost ($)	Estimated initial savings associated with ECM/WCM installation ($)

: ESPC estimated year one savings e.g. If you install a new high efficiency chiller instead of spending $10,000 to repair the old one, enter $10,000 here. Annual O&M Cost ($/year) : (Enter cost if O&M contracts will change due to ECM Implementation)

Enter negative value if there will be confirmed O&M savings	Electric Savings (kWh/year)
: Enter negative value if there will be an increase in energy use	Natural Gas Savings (scf/year)

: Enter negative value if there will be an increase in energy use

1 mmBtu = 974.66 scf Fuel Oil Savings (gal/year) : Enter negative value if there will be an increase in energy use

1 mmBtu = 7.246376812 gal Steam Savings (mmBtu/year) : Enter negative value if there will be an increase in energy use

: Location Code (from REXUS)		Chilled Water Savings (mmBtu/year)
: Enter negative value if there will be an increase in energy use	Propane Fuel Savings (mmBtu/year)
: Enter negative value if there will be an increase in energy use	Water Savings (gal/year)

: Enter negative value if there will be an increase in energy use : 8-digit alphanumeric string : 4 digit numeric string as reported in IRIS : PG Code for HPGB Projects: PG21 PG Code for E&ST Projects: PG27 : Unique identifier for project teams to use during data entry process, if necessary. Example, ECM number in TO Schedule : AoA Dropdown

: AoA Dropdown

Additional notes about ECM/WCM

Certify technology is installed and working properly

Email of Certifier

||||

FALSE

||||

FALSE

||||

FALSE

||||

FALSE

||||

FALSE

L10

FALSE

||||

FALSE

L11

FALSE

||||

FALSE

L12

FALSE

||||

FALSE

L13

FALSE

||||

FALSE

L14

FALSE

||||

FALSE

L15

FALSE

||||

FALSE

L16

FALSE

||||

FALSE

L17

FALSE

||||

FALSE

L18

FALSE

||||

FALSE

L19

FALSE

||||

FALSE

L20

FALSE

||||

FALSE

L21

FALSE

: Import range from ECM Design life tab. Any updates to E&S / TO alignment can be made in that sheet (https://docs.google.com/spreadsheets/d/1a_41ZddtVfM_VrZU2vYW7gQQUAp5gPwEolsrFzwPUTQ/edit#gid=339106882)

ECM type/category list aligns with CTS	ECM Technology		Filtered IRA Milestones
		#N/A		#N/A

LEC_Dropdowns

#REF!	Filtered Region	Filtered Location Code	Filtered Building Name	#REF!	LEC Material Subcategories	Unit Conversions		Filtered IRA Milestones		EPD Compliance
	#N/A					cubic meter/cubic yard	0.764555		#N/A	20%
						metric ton/kilogram	0.001			40%
						metric ton/U.S. ton	0.907185			Better Than Average
						metric ton/metric ton	1

: HESC4000

: Cement may only be used where provision of qualifying concrete is impractical.

: High early strength concrete should be avoided where possible. Is there a need for it in this project?

: HESC4000

Metadata

LEC Information						E&ST Information
Project Number	Header	Rows	Cols	A1 Reference	Formulas On Blank Row	Project Number	Header	Rows	Cols	A1 Reference	Formulas On Blank Row
	5	0	42		11		5	0	51		8

Data Dictionary

File details come from the government source that posted it. Updated May 31, 2024.