9. Sample IRA Project Submittal_ Reporting Form.xlsx
XLSX spreadsheet 3 MB Posted
- Solicitation number
- 47PH0825R0001
About this file
This document appears to be a solicitation for a Design Build Contract for the Kika De La Garza Land Port of Entry (LPOE) Border Roadway Improvement and Construction (BRIC) project in Pharr, Texas. The solicitation is funded in part by the Inflation Reduction Act of 2022 and contains numerous IRA-specific requirements related to pricing, invoicing, submittals, materials, and construction. The project involves approximately 515,000 sq. ft. of concrete pavement repair or replacement using low embodied carbon (LEC) materials, including LEC asphalt, concrete, and steel. The contractor must have NAICS code 237310 (Concrete and Asphalt Paving) and the current small business size standard is $45.0 million. The project is anticipated to take approximately 460 calendar days to complete, and the construction cost magnitude is between $20,000,000 and $30,000,000. The procurement is set aside for award to small business firms.
View the file
Other files
Show all 28
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
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 | 6 | 0 | L6 | FALSE | FALSE | FALSE | ||||||
| |||| | TRUE | FALSE | 7 | 0 | L7 | FALSE | Submittal 7 - Final Performance Submittal - Milestone 4.691 - Substantial Completion | PG24 | FALSE | FALSE | ||||
| |||| | FALSE | FALSE | 8 | 0 | L8 | FALSE | FALSE | FALSE | ||||||
| |||| | FALSE | FALSE | 9 | 0 | L9 | FALSE | FALSE | FALSE | ||||||
| |||| | FALSE | FALSE | 10 | 0 | L10 | FALSE | FALSE | FALSE | ||||||
| |||| | FALSE | FALSE | 11 | 0 | L11 | FALSE | FALSE | FALSE | ||||||
| |||| | FALSE | FALSE | 12 | 0 | L12 | FALSE | FALSE | FALSE | ||||||
| |||| | FALSE | FALSE | 13 | 0 | L13 | FALSE | FALSE | FALSE | ||||||
| |||| | FALSE | FALSE | 14 | 0 | L14 | FALSE | FALSE | FALSE | ||||||
| |||| | FALSE | FALSE | 15 | 0 | L15 | FALSE | FALSE | FALSE | ||||||
| |||| | FALSE | FALSE | 16 | 0 | L16 | FALSE | FALSE | FALSE | ||||||
| |||| | FALSE | FALSE | 17 | 0 | L17 | FALSE | FALSE | FALSE | ||||||
| |||| | FALSE | FALSE | 18 | 0 | L18 | FALSE | FALSE | FALSE | ||||||
| |||| | FALSE | FALSE | 19 | 0 | L19 | FALSE | FALSE | FALSE | ||||||
| |||| | FALSE | FALSE | 20 | 0 | L20 | FALSE | FALSE | FALSE | ||||||
| |||| | FALSE | FALSE | 21 | 0 | L21 | FALSE | FALSE | 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 | 6 | 0 | L6 | FALSE | FALSE | FALSE | FALSE | FALSE | ||
| |||| | FALSE | FALSE | 7 | 0 | L7 | FALSE | FALSE | FALSE | FALSE | FALSE | ||
| |||| | FALSE | FALSE | 8 | 0 | L8 | FALSE | FALSE | FALSE | FALSE | FALSE | ||
| |||| | FALSE | FALSE | 9 | 0 | L9 | FALSE | FALSE | FALSE | FALSE | FALSE | ||
| |||| | FALSE | FALSE | 10 | 0 | L10 | FALSE | FALSE | FALSE | FALSE | FALSE | ||
| |||| | FALSE | FALSE | 11 | 0 | L11 | FALSE | FALSE | FALSE | FALSE | FALSE | ||
| |||| | FALSE | FALSE | 12 | 0 | L12 | FALSE | FALSE | FALSE | FALSE | FALSE | ||
| |||| | FALSE | FALSE | 13 | 0 | L13 | FALSE | FALSE | FALSE | FALSE | FALSE | ||
| |||| | FALSE | FALSE | 14 | 0 | L14 | FALSE | FALSE | FALSE | FALSE | FALSE | ||
| |||| | FALSE | FALSE | 15 | 0 | L15 | FALSE | FALSE | FALSE | FALSE | FALSE | ||
| |||| | FALSE | FALSE | 16 | 0 | L16 | FALSE | FALSE | FALSE | FALSE | FALSE | ||
| |||| | FALSE | FALSE | 17 | 0 | L17 | FALSE | FALSE | FALSE | FALSE | FALSE | ||
| |||| | FALSE | FALSE | 18 | 0 | L18 | FALSE | FALSE | FALSE | FALSE | FALSE | ||
| |||| | FALSE | FALSE | 19 | 0 | L19 | FALSE | FALSE | FALSE | FALSE | FALSE | ||
| |||| | FALSE | FALSE | 20 | 0 | L20 | FALSE | FALSE | FALSE | FALSE | FALSE | ||
| |||| | FALSE | FALSE | 21 | 0 | L21 | FALSE | FALSE | FALSE | FALSE | 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/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 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
: HESC4000
: 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
: HESC4000
: HESC4000
: 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 .