9. Sample IRA Project Submittal_ Reporting Form.xlsx

XLSX spreadsheet 3 MB Posted Jan 15, 2025

Attached to: Design Build Contract for Santa Teresa Land Port of Entry (LPOE) Border Roadway Improvement and Construction (BRIC), Santa Teresa, NM
Solicitation number: 47PH0825R0004
Issued by: General Services Administration Public Buildings Service

About this file

Written by GovTribe AI · Jan 15, 2025

This file appears to be a sample report form template for tracking Inflation Reduction Act (IRA) project submittals, related to a solicitation for a Design Build Contract at the Santa Teresa Land Port of Entry (LPOE) in New Mexico. The template is associated with solicitation number 47PH0825R0004, which is a small business set-aside opportunity from GSA Public Buildings Service.

While the file itself is a template form, the associated solicitation details show this is for a design-build project involving approximately 190,000 sf of concrete pavement repair/replacement using Low Embodied Carbon (LEC) materials. The estimated project value is $5-10 million with a 300-day performance period. Key dates include a virtual pre-proposal meeting on January 22, 2025, site visit on January 23, 2025, and proposals due March 4, 2025 at 12:00 PM CST. Award is anticipated in April/May 2025. The contract will be awarded based on best value with four evaluation factors: Past Performance/Key Personnel, Company Experience, Technical Approach, and Sustainability.

View the file

Other files

File	Type	Posted
Amendment 3-47PH0825R0004.pdf	PDF	Apr 7, 2025
Amendment 2 - 47PH0825R0004.pdf	PDF	Feb 20, 2025
Amendment 1 47PH0825R0004.pdf	PDF	Jan 24, 2025
13. Bid Bond.pdf	PDF	Jan 15, 2025
4. Factor 4 LEC Material IRA Sustainability Factor Table.xlsx	XLSX spreadsheet	Jan 15, 2025
Santa Teresa Solicitation 47PH0825R0004.pdf	PDF	Jan 15, 2025
7. Offeror Representations and Certifications Form Dec 2023 (1).pdf	PDF	Jan 15, 2025
8. Award Allocation Form IRA.xlsx	XLSX spreadsheet	Jan 15, 2025
11. Steel - GSA IRA Low Embodied Carbon Requirements (Dec. 2023).pdf	PDF	Jan 15, 2025
15. Site Map Santa Teresa.pdf	PDF	Jan 15, 2025
6. GSA 527-21 - Contractor's Qualifications and Financial Informatio.pdf	PDF	Jan 15, 2025
1. GSA Affiliated Custom Accounts (GACA) for Google Drive.pdf	PDF	Jan 15, 2025
2. Past Experience & Performance of Co Questionnaire Factor 1.pdf	PDF	Jan 15, 2025
3. Past Experience_Past Performance Questionnaire (Factor 2).pdf	PDF	Jan 15, 2025
14. IRA Project Submittal Form and Data Dictionary PDF.pdf	PDF	Jan 15, 2025
10. Concrete - GSA IRA Low Embodied Carbon Requirements (Dec. 2023).pdf	PDF	Jan 15, 2025
12. Asphalt - GSA IRA Low Embodied Carbon Requirements (Dec. 2023).pdf	PDF	Jan 15, 2025
5. Wage Rate NM20250035 01-03-2025.pdf	PDF	Jan 15, 2025

Show all 18

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

||||

TRUE

FALSE

Submittal 7 - Final Performance Submittal - Milestone 4.691 - Substantial Completion

PG24

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 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

	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 PSI	Concrete (and cement or CMUs)-≤2499 PSI	cubic meter	cubic yard	277	261	228	cubic meter	1
	Concrete (and cement or CMUs)	3000 PSI	Concrete (and cement or CMUs)-3000 PSI	cubic meter	cubic yard	318	291	257	U.S. ton	0.907185
	Concrete (and cement or CMUs)	4000 PSI	Concrete (and cement or CMUs)-4000 PSI	cubic meter	cubic yard	352	326	284	cubic yard	0.764555
	Concrete (and cement or CMUs)	5000 PSI	Concrete (and cement or CMUs)-5000 PSI	cubic meter	cubic yard	382	357	305
	Concrete (and cement or CMUs)	6000 PSI	Concrete (and cement or CMUs)-6000 PSI	cubic meter	cubic yard	407	374	319
	Concrete (and cement or CMUs)	≥7200 PSI	Concrete (and cement or CMUs)-≥7200 PSI	cubic meter	cubic yard	402	362	321
	Concrete (and cement or CMUs)	HESC≤2499 PSI
: 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 PSI	cubic meter	cubic yard	360.1	339.3	296.4
	Concrete (and cement or CMUs)	HESC3000 PSI
: HESC4000	Concrete (and cement or CMUs)-HESC3000 PSI	cubic meter	cubic yard	413.4	378.3	334.1
	Concrete (and cement or CMUs)	HESC4000 PSI
: HESC4000	Concrete (and cement or CMUs)-HESC4000 PSI	cubic meter	cubic yard	457.6	423.8	369.2
	Concrete (and cement or CMUs)	HESC5000 PSI
: HESC4000	Concrete (and cement or CMUs)-HESC5000 PSI	cubic meter	cubic yard	496.6	464.1	396.5
	Concrete (and cement or CMUs)	HESC6000 PSI
: HESC4000	Concrete (and cement or CMUs)-HESC6000 PSI	cubic meter	cubic yard	529.1	486.2	414.7
	Concrete (and cement or CMUs)	HESC≥7200 PSI
: HESC4000	Concrete (and cement or CMUs)-HESC≥7200 PSI	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 E&ST_HPGB Dropdowns #REF! Filtered Region Filtered Location Code Filtered Building Name #REF!

: 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		#REF!	#REF!
	#N/A					cubic meter/cubic yard	0.764555		#N/A
						metric ton/kilogram	0.001
						metric ton/U.S. ton	0.907185
						metric ton/metric ton	1
						cubic meter/cubic meter	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 Jan 15, 2025.