Sample IRA Project Submittal_ Reporting Form.xlsx

XLSX spreadsheet 4 MB Posted Jan 15, 2025

Attached to: IRA Bismarck Federal Parking Lot Renovation
Solicitation number: 47PJ0025R0032
Issued by: General Services Administration Public Buildings Service Region 8

About this file

Written by GovTribe AI · Jan 15, 2025

This is a sample IRA project submittal reporting form spreadsheet template related to a project for replacing a deteriorating asphalt parking lot with a low embodied carbon concrete parking lot at a federal building in Bismarck. The template appears to be designed for contractors to submit project information related to GSA Public Buildings Service Region 8's solicitation #47PJ0025R0032.

The associated project involves renovating an approximately 45,000 square foot parking lot that is over 20 years old and currently has surface cracks throughout. The scope includes removing the existing asphalt, installing new concrete with low embodied carbon specifications, and adding perimeter fencing for security. The parking lot serves daily users of the federal building.

View the file

Other files

File	Type	Posted
Solicitation Amendment 47PJ0025R0032_0003 .pdf	PDF	Feb 7, 2025
Questions v3 Updated.docx	DOCX document	Feb 7, 2025
Past Performance Questionaire.pdf	PDF	Feb 3, 2025
Solicitation Amendment 47PJ0025R0032_0002.pdf	PDF	Feb 3, 2025
Questions and answers amendment 0002 .docx	DOCX document	Feb 3, 2025
Questions v1.0.docx	DOCX document	Jan 27, 2025
Solicitation Amendment 47PJ0025R0032_0001.pdf	PDF	Jan 23, 2025
SOW BMK38 Parking Lot Renovations v3.0_2024 (1).docx	DOCX document	Jan 23, 2025
Sol_SBSA_DB_1_Phase_April 2024 (1).pdf	PDF	Jan 15, 2025
IRA Project Submittal Form and Data Dictionary PDF.pdf	PDF	Jan 15, 2025
AWARD ALLOCATION FORM IRA .xlsx	XLSX spreadsheet	Jan 15, 2025
Product Category Rule Concrete.pdf	PDF	Jan 15, 2025
Wage Determination .pdf	PDF	Jan 15, 2025
47PJ0025R0032 Generated PDF with TOC.pdf	PDF	Jan 15, 2025
SUPPLEMENTAL PRICING AND INVOICING INSTRUCTIONS FOR PROJECTS FUNDED BY THE INFLATION REDUCTION ACT OF 2022.docx	DOCX document	Jan 15, 2025
Layout Proposal.pdf	PDF	Jan 15, 2025
Reps and Certs GC May 2024 .pdf	PDF	Jan 15, 2025
Agreement .pdf	PDF	Jan 15, 2025
SOW BMK38 Parking Lot Renovations v2_2024.docx	DOCX document	Jan 15, 2025
SAM.gov.pdf	PDF	Jan 15, 2025
Interim IRA LEC Material Requirements - used in Pilot May 2023 05162023 (1).pdf	PDF	Jan 15, 2025

Show all 21

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

ERROR:#NAME?

FALSE

ERROR:#NAME?

0.0 kg CO2e/Declared Unit

ERROR:#NAME?

FALSE

ERROR:#NAME?

0.0 kg CO2e/Declared Unit

ERROR:#NAME?

FALSE

ERROR:#NAME?

0.0 kg CO2e/Declared Unit

ERROR:#NAME?

FALSE

ERROR:#NAME?

0.0 kg CO2e/Declared Unit

ERROR:#NAME?

FALSE

ERROR:#NAME?

0.0 kg CO2e/Declared Unit

ERROR:#NAME?

FALSE

ERROR:#NAME?

0.0 kg CO2e/Declared Unit

ERROR:#NAME?

FALSE

ERROR:#NAME?

0.0 kg CO2e/Declared Unit

ERROR:#NAME?

FALSE

ERROR:#NAME?

0.0 kg CO2e/Declared Unit

ERROR:#NAME?

FALSE

ERROR:#NAME?

0.0 kg CO2e/Declared Unit

ERROR:#NAME?

FALSE

ERROR:#NAME?

0.0 kg CO2e/Declared Unit

ERROR:#NAME?

FALSE

ERROR:#NAME?

0.0 kg CO2e/Declared Unit

ERROR:#NAME?

FALSE

ERROR:#NAME?

0.0 kg CO2e/Declared Unit

ERROR:#NAME?

FALSE

ERROR:#NAME?

0.0 kg CO2e/Declared Unit

ERROR:#NAME?

FALSE

ERROR:#NAME?

0.0 kg CO2e/Declared Unit

ERROR:#NAME?

FALSE

ERROR:#NAME?

0.0 kg CO2e/Declared Unit

ERROR:#NAME?

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

ERROR:#NAME?

FALSE

ERROR:#NAME?

FALSE

ERROR:#NAME?

FALSE

ERROR:#NAME?

FALSE

ERROR:#NAME?

FALSE

ERROR:#NAME?

FALSE

ERROR:#NAME?

FALSE

ERROR:#NAME?

FALSE

ERROR:#NAME?

FALSE

ERROR:#NAME?

FALSE

ERROR:#NAME?

FALSE

ERROR:#NAME?

FALSE

ERROR:#NAME?

FALSE

ERROR:#NAME?

FALSE

ERROR:#NAME?

FALSE

ERROR:#NAME?

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	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 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		0	#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	0	#N/A	20%
						metric ton/kilogram	0.001			40%
						metric ton/U.S. ton	0.907185			Better Than Average
						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
0	5	ERROR:#NAME?	16384		0	0	5	ERROR:#NAME?	16384		0

Data Dictionary

File details come from the government source that posted it. Updated Jan 15, 2025.