Sample IRA Project Submittal_ Reporting Form.xlsx

XLSX spreadsheet 7 MB Posted Jun 3, 2024

Attached to: Back Lot Security Fencing Project
Solicitation number: 47PF0024R0060
Issued by: General Services Administration Public Buildings Service Region 5

About this file

Written by GovTribe AI · Jun 3, 2024

This document is a Project Submittal/Reporting Form related to an Inflation Reduction Act (IRA)-funded project for the General Services Administration (GSA). The form is used to track sustainability impacts of low embodied carbon (LEC) materials, emerging and sustainable technologies (E&ST), and high-performance green building (HPGB) work items in GSA-owned buildings.

The form provides detailed instructions for completing the data required, including project identification information, milestone tracking, and specific data fields for LEC materials, E&ST, and HPGB technologies. It includes guidance on unique identifiers, calculations, data sources, and formatting. The form also includes links to further resources such as the IRA Input Database Standard Operating Procedure, FAQs, and data dictionaries. Overall, this appears to be a comprehensive set of reporting requirements for IRA-funded sustainability initiatives in GSA buildings.

View the file

Other files

File	Type	Posted
Amendment 1 to 47PF0024R0060.pdf	PDF	Jun 25, 2024
JPK_Back Lot Improvements_Pre-Bid_Minutes_061824.pdf	PDF	Jun 18, 2024
Signin Sheet 618.jpg	JPG image	Jun 18, 2024
Instructions IRA Project Submittal Reporting Form.pdf	PDF	Jun 3, 2024
RFP 47PF0024R0060.pdf	PDF	Jun 3, 2024
IRA Sustainability Factor Table.xlsx	XLSX spreadsheet	Jun 3, 2024
LEC Companies.pdf	PDF	Jun 3, 2024
Post AWARD ALLOCATION FORM IRA (2).xlsx	XLSX spreadsheet	Jun 3, 2024

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

LEC Instructions

Purpose of the Project Submittal/Reporting Form:

This workbook is used to track sustainability impacts of Inflation Reduction Act (IRA)-funded low embodied carbon (LEC) materials,

emerging and sustainable technologies (E&ST), and high performance green building (HPGB) work items in GSA-owned buildings.

All data is captured at the work-item level (as reported in IRIS), and should be identified by a Kahua project ID, building ID,

accounting string ID (ASID), and Work Item (WI) number. Data should be updated when each line-item reaches the milestone, as defined

in Kahua, that matches the submittals listed in the tables below. Milestones are specific to the project type (Energy Savings Performance

Contract (ESPC) or non-ESPC.

If your team has information to share at a Kahua milestone that does not align with the defined submittals, you may select an alternative

milestone from the dropdown list. If a work item is cancelled or deferred, please select that as a milestone.

Please inform our team if you need a specific milestone added to the dropdown options.

Frequency of Project Submittal Updates (Milestones):

LEC Milestone Guidance is currently in development. Any changes will be reflected in this guidance.
Non-ESPC Projects				ESPC Projects
Submittal Number	Submittal Name	Kahua Milestone Number	Kahua Milestone Name	Submittal Number	Submittal Name	Kahua Milestone Number	Kahua Milestone Name
1	Project Agreement	3.091	Initial Financial Agreement w Customer	1	Project Agreement	10.071	Preliminary Assessment (PA) Complete
2	Commissioner’s Concept	4.271	Commissioner's Concept Design Approval	2	35% DD	10.091	Investment Grade Audit (IGA) Start
3	35% DD	4.251	Design Start / NTP	3	65% DD Review / 50% CD	10.121	Award Design & Construction
4	65% DD Review / 50% CD	4.251	Design Start / NTP	4	90% CD	10.121	Award Design & Construction
5	90% CD	4.361	Design Complete	5	Hand-off/ Turnover	10.181	All ECMs 30 Day Proof of Performance Complete
6	Hand-off/ Turnover	4.691	Substantial Completion	6	Final Performance Submittal	10.221	Performance Year 1 Commences
7	Final Performance Submittal	4.691	Substantial Completion

Instructions:

Each workbook is project-specific and will remain the same for the duration of the project. Please use your project specific link.

If you are unable to locate your region specific workbook please email IRASustainabilitySubmittals@gsa.gov.

Within this workbook, you will see tabs across the bottom of the screen, please navigate to and review both the Low Embodied

Carbon Materials and Emerging & Sustainable Tech and HPGB tabs.

Color Coding:

Please take note of the following cell colors throughout the form:

Cells highlighted in gold require user input. Once data is inserted, the color will transition from gold to white.

Enter Work Item Information Below:
Enter your email address	Milestone Status	Building Number
sample@gsa.gov	Submittal 1 - Project Agreement - Milestone 3.091 - Initial Financial Agreement w Customer
sample@gsa.gov

The cells in blue will auto-populate based on your data. Please do not fill items in blue in yourself. For example, once you select a building ID,

the building name will populate from our backend.

Enter Work Item Information Below:
Enter your email address	Milestone Status	Building Number	Building Name
sample@gsa.gov	Submittal 1 - Project Agreement - Milestone 3.091 - Initial Financial Agreement w Customer	CT0053ZZ	AA RIBICOFF FB&CTHS
sample@gsa.gov

If a project has been either canceled or deferred, the corresponding row will automatically change to a grey color, indicating no further

information is required to be filled out.

Enter Work Item Information Below:
Enter your email address	Milestone Status	Building Number	Building Name

sample@gsa.gov	Deferred
sample@gsa.gov
sample@gsa.gov	Cancelled

Red fill indicates that there are duplicate work items entered. All line items must be represented by a UNIQUE IDENTIFIER

to track their progress over the lifecycle of a project. Line Item Identifiers are composed of the following columns:

Project # (Kahua), Building Number, ASID, Work Item, and LEC Identifier. If multiple line items have the same work item number,

enter a UNIQUE IDENTIFER into the LEC Identifier column to resolve the error.

Sample Duplicate Error:

Enter your email address	Milestone Status	Building Number	Building Name	Project # (Kahua)	Accounting String ID (ASID)	Work Item (WI) #	LEC Identifier
example@gsa.gov	Submittal 1 - Project Agreement - Milestone 3.091 - Initial Financial Agreement w Customer	MI00097ZZ	FEDERAL BLDG & US COURTHOUSE	6577	J765444	6065
example@gsa.gov	Submittal 1 - Project Agreement - Milestone 3.091 - Initial Financial Agreement w Customer	MI00097ZZ	FEDERAL BLDG & US COURTHOUSE	6577	J765444	6065

Resolution: Add a unique identifier (can be any format- i.e. a number, text etc.).

This allows various line items with the same work item ID to be uniquely identified and tracked over the project life cycle.

Enter your email address	Milestone Status	Building Number	Building Name	Project # (Kahua)	Accounting String ID (ASID)	Work Item (WI) #	LEC Identifier
example@gsa.gov	Submittal 1 - Project Agreement - Milestone 3.091 - Initial Financial Agreement w Customer	MI00097ZZ	FEDERAL BLDG & US COURTHOUSE	6577	J765444	6065	Glass 1
example@gsa.gov	Submittal 1 - Project Agreement - Milestone 3.091 - Initial Financial Agreement w Customer	MI00097ZZ	FEDERAL BLDG & US COURTHOUSE	6577	J765444	6065	Glass 2

Updating and Adding LEC Data

The following will highlight key instructions for completing the IRA LEC data. For a more comprehensive guide with detailed instructions,

please consult the IRA Input Database SOP linked with other further resources at the bottom of this instruction manual.

This will serve as a reference guide, offering detailed descriptions and definitions for the elements or attributes present in this sheet.

The categories below are the minimum data requirements for initial project submissions:

These categories allow for identifying your unique project. LEC Identifier is required only if one work item is represented on multiple rows:
Enter your email address	Milestone Status	Building Number	Project # (Kahua)	Accounting String ID (ASID)	Work Item (WI) #	LEC Identifier

The categories below are needed to perform database calculations. We recognize not all projects have EPDs
available or exact quantities in early phases. Until you have an EPD please provide your best estimate for quantity and a reported threshold target.
LEC Material Category	LEC Material Subcategory	Reported Threshold Target	Description of Material Installed	Quantity

The following should be entered as soon as project teams have the data available

Once project teams have an EPD please provide the following information
Provide link for Material EPD	Product Specific GWP	Product Category Rule (PCR)	Upstream Plant's ENERGY STAR Energy Performance Score	Year of plant's ENERGY STAR Energy Performance Score

Project teams should also ensure all other fields remain up to date as the project progresses.

1.) Start by entering data into the cells highlighted in gold. Begin with the gold boxes located at the top of the tracker as illustrated in the image below.

Click through them and input the required information.

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

2.) Each row of data should uniquely correspond to a SINGLE work item, that is, each line has a unique LEC material and subcategory. For example,

asphalt and concrete should be represented as two separate work items; as shown below.

Budget Activity Code	LEC Identifier	LEC Material Category	LEC Material Subcategory
PG21		Concrete (and cement or CMUs)	6000
PG21		Concrete (and cement or CMUs)	4000

Additionally, if LEC materials of the same material and subcategory have different EPDs

(and different global warming potentials (GWPs)), they must go on their own line.

3.) When you encounter the 'quantity' column, in this section you will specify how much of each material was acquired.

Quantities may change throughout your project. At that point you will be allowed to edit the live view of your form.

Note: Ensure that the declared units align with the quantity reporting units.

LEC Material Category	LEC Material Subcategory	Declared Unit	GWP Limit Specified in the Contract	Quantity	Quantity Reporting Unit
Concrete (and cement or CMUs)	4000	metric ton	284 kg CO2e/Declared Unit		U.S. ton

4.) After completing the form, carefully review all your responses to ensure there are no duplicates, errors, or misreported information.

Once you have verified the accuracy of your answers, kindly proceed to close the form to ensure proper recording of your responses.

If this is your initial submittal, please email IRAsustainabilitysubmittals@gsa.gov to initiate Climate and Infrastructure Program Management Office

(CIPMO) project review.

CIPMO Reviews do NOT need to be conducted for project sheet updates, but our team will be monitoring for data quality concerns.

Further Resources

IRA Input Database SOP

IRA Project Submittal Form FAQ

IRA Project Submittal Data Dictionary

E&ST and HPGB Instructions

Purpose of the Project Submittal/Reporting Form:

This workbook is used to track sustainability impacts of Inflation Reduction Act (IRA)-funded low embodied carbon (LEC) materials,

emerging and sustainable technologies (E&ST), and high performance green building (HPGB) work items in GSA-owned buildings.

All data is captured at the work-item level (as reported in IRIS), and should be identified by a Kahua project ID, building ID,

accounting string ID (ASID), and Work Item (WI) number. Data should be updated when each line-item reaches the milestone, as defined

in IRIS, that matches the submittals listed in the tables below. Milestones are specific to the project type (Energy Savings Performance

Contract (ESPC) or non-ESPC).

If your team has information to share at a Kahua milestone that does not align with the defined submittals, you may select an alternative

milestone from the dropdown list. If a work item is cancelled or deferred, please select that as a milestone.

Please inform our team if you need a specific milestone added to the dropdown options.

Frequency of Project Submittal Updates (Milestones):

Milestone Guidance is currently in development. Any changes will be reflected in this guidance.
Non-ESPC Projects				ESPC Projects
Submittal Number	Submittal Name	Kahua Milestone Number	Kahua Milestone Name	Submittal Number	Submittal Name	Kahua Milestone Number	Kahua Milestone Name
1	Project Agreement	3.091	Initial Financial Agreement w Customer	1	Project Agreement	10.071	Preliminary Assessment (PA) Complete
2	Commissioner’s Concept	4.271	Commissioner's Concept Design Approval	2	35% DD	10.091	Investment Grade Audit (IGA) Start
3	35% DD	4.251	Design Start / NTP	3	65% DD Review / 50% CD	10.121	Award Design & Construction
4	65% DD Review / 50% CD	4.251	Design Start / NTP	4	90% CD	10.121	Award Design & Construction
5	90% CD	4.361	Design Complete	5	Hand-off/ Turnover	10.181	All ECMs 30 Day Proof of Performance Complete
6	Hand-off/ Turnover	4.691	Substantial Completion	6	Final Performance Submittal	10.221	Performance Year 1 Commences
7	Final Performance Submittal	4.691	Substantial Completion

Instructions:

Each workbook is project-specific and will remain the same for the duration of the project. Please use your project specific link.

If you are unable to locate your region specific workbook please email IRASustainabilitySubmittals@gsa.gov.

Within this workbook, you will see tabs across the bottom of the screen, please navigate to and review both the Low Embodied

Carbon Materials and Emerging & Sustainable Tech and HPGB tabs.

Color Coding:

Please take note of the following cell colors throughout the form:

Cells highlighted in gold require user input. Once data is inserted, the color will transition from gold to white.

Enter Work Item Information Below:
Enter your email address	Milestone Status	Building Number
sample@gsa.gov	Submittal 1 - Project Agreement - Milestone 3.091 - Initial Financial Agreement w Customer
sample@gsa.gov

The cells in blue will auto-populate based on your data. Please do not fill items in blue in yourself. For example, once you select a building ID,

the building name will populate from our backend.

Enter Work Item Information Below:
Enter your email address	Milestone Status	Building Number	Building Name
sample@gsa.gov	Submittal 1 - Project Agreement - Milestone 3.091 - Initial Financial Agreement w Customer	CT0053ZZ	AA RIBICOFF FB&CTHS
sample@gsa.gov

If a project has been either canceled or deferred, the corresponding row will automatically change to a grey color, indicating no further

information is required to be filled out.

Enter Work Item Information Below:
Enter your email address	Milestone Status	Building Number	Building Name

sample@gsa.gov	Deferred
sample@gsa.gov
sample@gsa.gov	Cancelled

Red fill indicates that there are duplicate work items entered. All line items must be represented by a UNIQUE IDENTIFIER

to track their progress over the lifecycle of a project. Line Item Identifiers are composed of the following columns:

Project # (Kahua), Building Number, ASID, Work Item, and LEC Identifier. If multiple line items have the same work item number,

enter a UNIQUE IDENTIFER into the LEC Identifier column to resolve the error.

Sample Duplicate Error:

Enter your email address	Milestone Status	Building Number	Building Name	Project # (Kahua)	Accounting String ID (ASID)	Work Item (WI) #	Energy Conservation Measure /Water Conservation Measure (ECM/WCM) Identifier
example@gsa.gov	Submittal 1 - Project Agreement - Milestone 3.091 - Initial Financial Agreement w Customer	MI00097ZZ	FEDERAL BLDG & US COURTHOUSE	6577	J765444	6065
example@gsa.gov	Submittal 1 - Project Agreement - Milestone 3.091 - Initial Financial Agreement w Customer	MI00097ZZ	FEDERAL BLDG & US COURTHOUSE	6577	J765444	6065

Resolution: Add a unique identifier (can be any format- i.e. a number, text etc.).

This allows various line items with the same work item ID to be uniquely identified and tracked over the project life cycle.

Enter your email address	Milestone Status	Building Number	Building Name	Project # (Kahua)	Accounting String ID (ASID)	Work Item (WI) #	Energy Conservation Measure /Water Conservation Measure (ECM/WCM) Identifier
example@gsa.gov	Submittal 1 - Project Agreement - Milestone 3.091 - Initial Financial Agreement w Customer	MI00097ZZ	FEDERAL BLDG & US COURTHOUSE	6577	J765444	6065	Boiler 1
example@gsa.gov	Submittal 1 - Project Agreement - Milestone 3.091 - Initial Financial Agreement w Customer	MI00097ZZ	FEDERAL BLDG & US COURTHOUSE	6577	J765444	6065	Boiler 2

Updating and Adding E&ST and HPGB Data

The following will highlight key instructions for completing the IRA E&ST and HPGB data. For a more comprehensive guide with detailed instructions,

please consult the IRA Input Database SOP linked with other further resources at the bottom of this instruction manual.

This will serve as a reference guide, offering detailed descriptions and definitions for the elements or attributes present in this sheet.

The categories below are the minimum requirements for data submissions:

These categories allow for identifying your unique project. ECM/WCM Identifier is required only if one work item is represented on multiple rows:
Enter your email address	Milestone Status	Building Number	Project # (Kahua)	Accounting String ID (ASID)	Work Item (WI) #	Energy Conservation Measure /Water Conservation Measure (ECM/WCM) Identifier

The categories below are needed to perform database calculations. We recognize not all projects have exact quantities in early phases.

Please provide the most accurate information available for your project, data can be updated after the initial submission to reflect new information and changes.

ECM/WCM Category ECM/WCM Technology Quantity Installed Initial ECM/WCM implementation cost ($)

For savings, fill in all fuel types relevant to your project.

Electric Savings (kWh/year) Natural Gas Savings (scf/year) Fuel Oil Savings (gal/year) Steam Savings (mmBtu/year) Chilled Water Savings (mmBtu/year) Propane Fuel Savings (mmBtu/year) Water Savings (gal/year)

The following should be entered as soon as project teams have the data available (if applicable).
Not all data elements will be applicable to all projects - i.e. not all ECMs use refrigerants, and not all ECMs will result in O&M cost changes.
Select the guiding principle for the material or technology	Deep Energy Retrofit	All Electric Building	Net Zero Energy	Sustainable Building

Alternative ECM Design Life Primary Building Cooling Fuel Primary Building Heating Fuel Refrigerant Involved in ECM? Refrigerant Type Refrigerant Capacity (lbs) Estimated initial savings associated with ECM/WCM installation ($) Annual O&M Cost ($/year)

Project teams should also ensure all other fields remain up to date as the project progresses.

1.) Start by entering data into the cells highlighted in gold. Begin with the gold boxes located at the top of the tracker as illustrated in the image below.

Click through them and input the required information.

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

2.) Each row of data should uniquely correspond to a unique energy conservation measure (ECM) or water conservation measure (WCM).

Project # (Kahua)	Accounting String ID (ASID)	Work Item (WI) #	...	Energy Conservation Measure /Water Conservation Measure (ECM/WCM) Identifier	ECM/WCM Category	ECM/WCM Technology
1234	12345678	0001	...		Chiller Plant Improvements	Initial gas cooling
1234	12345678	0002	...		Chiller Plant Improvements	Install floor insulation

Quantity should reflect the amount of each technology deployed within a building, i.e. if 300 meters are installed, enter 300.

If the project team has accurate quantity values please report them to increase the precision of IRA data. If not, enter a quantity of 1.

Please ensure that total costs, energy, and water savings are accurate and reflect that of the entire line item (i.e. totals for all 300 meters).

If multiple ECMs/WCMs are installed under one work item, please ensure that the ECM/WCM lifespans and specs are the same.

For example, if you are installing multiple boilers with different estimated lifespans, those entries would need to be split into two line items.

Energy Conservation Measure /Water Conservation Measure (ECM/WCM) Identifier	ECM/WCM Category	ECM/WCM Technology	Quantity Installed
	Advanced Metering Systems	Install advanced metering systems	300
	Boiler Plant Improvements	Replace boiler	3
	Renewable Energy Systems	Install photovoltaic system	1

4.) After completing the form, carefully review all your responses to ensure there are no duplicates, errors, or misreported information.

Once you have verified the accuracy of your answers, kindly proceed to close the form to ensure proper recording of your responses.

If this is your initial submittal, please email IRAsustainabilitysubmittals@gsa.gov to initiate CIPMO project review.

CIPMO Reviews do NOT need to be conducted for project sheet updates, but our team will be monitoring for data quality concerns.

Further Resources

IRA Input Database SOP

IRA Project Submittal Form FAQ

IRA Project Data Submittal Dictionary

https://docs.google.com/document/u/0/d/15LxjBYRIwx3KETSbu7u6tWa5RKNEi3ocKsBp7MqUzZw/edithttps://docs.google.com/document/u/0/d/1tC2sfYILb5lLwJbf80zE-MHwnbMYlMx4Sv0GWaefrQw/edithttps://docs.google.com/spreadsheets/d/1MJEtPhdIBy6lPkyIYQELfS-xBIID2VCvaaRLlZzoWGg/edit 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 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

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

ECM type/category list aligns with CTS

ECM Technology

Filtered IRA Milestones

Submittal 1 - Project Agreement

Planning

Phase Start

3.091

Initial Financial Agreement w Customer

Submittal 1 - Project Agreement - Milestone 3.091 - Initial Financial Agreement w Customer

non-ESPC

CT0013ZZ

WILLIAM R. COTTER FB

CT0013ZZ

WILLIAM R. COTTER FB

PG21

**ECM Type Category**

ECM Example **Select ECM Type Category**

Helper Column

Design Life

Emerging & Sustainable Technology Alignment

TO Alignment

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

Submittal 2 - Commissioner's Concept Design Approval

Planning

Phase End

4.271

Commissioner's Concept Design Approval

Submittal 2 - Commissioner's Concept Design Approval - Milestone 4.271 - Commissioner's Concept Design Approval

non-ESPC

CT0024ZZ

Richard C. Lee U S Courthouse

CT0024ZZ

Richard C. Lee U S Courthouse

PG27

Boiler Plant Improvements

**Select ECM Technology below**

Boiler Plant Improvements-**Select ECM Technology below**

Select Emerging & Sustainable Technology Alignment

Select TO Alignment

Submittal 6 - Hand-off/Turnover - Milestone 4.691 - Substantial Completion

Planning

Phase End

4.101

Design or Bridging RFP Issued

4.101 - Design or Bridging RFP Issued

non-ESPC

CT0047ZZ

WATERBURY MAIN POST OFFICE

CT0047ZZ

WATERBURY MAIN POST OFFICE

Boiler Plant Improvements

Add energy recovery

Boiler Plant Improvements-Add energy recovery

HVAC - Electric Boilers

TC.1 - Boiler Plant Improvements

Submittal 5 - 90% CD - Milestone 4.361 - Design Complete

Planning

Phase End

4.421

Construction or Design/Build or CMC RFP Issued

4.421 - Construction or Design/Build or CMC RFP Issued

non-ESPC

CT0053ZZ

AA RIBICOFF FB&CTHS

CT0053ZZ

AA RIBICOFF FB&CTHS

Boiler Plant Improvements

Decentralize boiler

Boiler Plant Improvements-Decentralize boiler

HVAC - Electric Boilers

TC.1 - Boiler Plant Improvements

Submittal 4 - 65% DD Review/ 50% CD - Milestone 4.251 - Design Start / NTP

Design Procurement

Phase Start

4.101

Design or Bridging RFP Issued

4.101 - Design or Bridging RFP Issued

non-ESPC

CT0055ZZ

New US Courthouse - Hartford

CT0055ZZ

New US Courthouse - Hartford

Boiler Plant Improvements

Insulate boiler room

Boiler Plant Improvements-Insulate boiler room

HVAC - Electric Boilers

TC.1 - Boiler Plant Improvements

Submittal 3 - 35% DD - Milestone 4.251 - Design Start / NTP

Design Procurement

Phase End

4.221

Design or Bridging Award

4.221 - Design or Bridging Award

non-ESPC

CT0059ZZ

BRIEN MCMAHON USCH&FB

CT0059ZZ

BRIEN MCMAHON USCH&FB

Boiler Plant Improvements

Convert gas-fired unit to boiler loop

Boiler Plant Improvements-Convert gas-fired unit to boiler loop

HVAC - Electric Boilers

TC.1 - Boiler Plant Improvements

Submittal 2 - Commissioner's Concept Design Approval - Milestone 4.271 - Commissioner's Concept Design Approval

Submittal 3 - 35% DD

Design

Phase Start

4.251

Design Start / NTP

Submittal 3 - 35% DD - Milestone 4.251 - Design Start / NTP

non-ESPC

CT0060ZZ

SSA - TORRINGTON

CT0060ZZ

SSA - TORRINGTON

Boiler Plant Improvements

Clean and/or repair

Boiler Plant Improvements-Clean and/or repair

HVAC - Electric Boilers

TC.1 - Boiler Plant Improvements

Submittal 1 - Project Agreement - Milestone 3.091 - Initial Financial Agreement w Customer

Submittal 5 - 90% CD

Design

Phase End

4.361

Design Complete

Submittal 5 - 90% CD - Milestone 4.361 - Design Complete

non-ESPC

CT0061ZZ

ROBERT N GIAIMO FB

CT0061ZZ

ROBERT N GIAIMO FB

Boiler Plant Improvements

Upgrade operating protocols, calibration, and/or sequencing

Boiler Plant Improvements-Upgrade operating protocols, calibration, and/or sequencing

HVAC - Sequence of Operations

TC.1 - Boiler Plant Improvements

Deferred

Construction Procurement

Phase Start

4.421

Construction or Design/Build or CMC RFP Issued

4.421 - Construction or Design/Build or CMC RFP Issued

non-ESPC

CT3316ZZ

130 DARLIN STREET

CT3316ZZ

130 DARLIN STREET

Boiler Plant Improvements

Replace boiler

Boiler Plant Improvements-Replace boiler

HVAC - Electric Boilers

TC.1 - Boiler Plant Improvements

Cancelled

Construction Procurement

Phase End

4.491

Construction or Design/Build Contract Award or CMc Award

4.491 - Construction or Design/Build Contract Award or CMc Award

non-ESPC

CT3319ZZ

TWO LANDMARK SQUARE

CT3319ZZ

TWO LANDMARK SQUARE

Boiler Plant Improvements

Replace burner

Boiler Plant Improvements-Replace burner

HVAC - Electric Boilers

TC.1 - Boiler Plant Improvements

AoA Submittal

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated Jun 3, 2024.