Attachement B Grant Table CPT14~1.xlsx
XLSX spreadsheet 52 KB Posted
- Solicitation number
- BD-26-1041-ENE01-ENE01-120677
- Issued by
- Massachusetts
About this file
This is an Excel-based Green Communities Grant Table (PON-ENE-2026-001) from the Massachusetts Department of Energy Resources (DOER) for municipal energy efficiency and decarbonization projects. The document details a grant application for the town of Ames, which includes four distinct energy-related projects scheduled for completion by December 2024: an air source heat pump installation at Town Offices, weatherization improvements, LED lighting at the High School, and the purchase of a Chevy Bolt electric vehicle for the Building Inspector's office. The total project scope encompasses 49,871 kWh of electricity savings, 2,535 natural gas therms, and 756 gasoline gallons, with an estimated total project cost of $301,291 and a requested Green Communities grant funding of $132,573.
The funding sources for the projects include a mix of Green Communities grant funds, utility incentives, and community contributions, with specific line items showing $40,600 from a private donation for the heat pump project, $11,375 from the general fund for weatherization, and $25,500 in community contribution for the electric vehicle. The projects are expected to generate significant energy cost savings, with projected annual savings of $3,557.95 for the heat pump, $1,137.50 for weatherization, $13,135.14 for LED lighting, and $2,030.94 for the electric vehicle. The grant application includes comprehensive metrics on energy savings, greenhouse gas reductions, and cost-effectiveness, aligning with the state's broader green energy transformation goals.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment A Worksheets CPT14~2.docx | DOCX document | |
| PON-ENE-2026-001 Green Communities Grant Program~1.pdf |
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
Community Information & Summary
Green Communities Grant Table - PON-ENE-2026-001
| Applicant Information | |
| Municipality Name: | |
| Contact Name: | |
| Contact Title: | |
| Contact E-mail: | |
| Contact Phone: | |
| Date of Application : | |
| Date of update (if an update to an existing application): | n/a |
Energy Cost ($) per Unit Enter your community's energy costs, leave blank if the fuel is not part of the savings calculation. Please note, energy savings are for reference. DOER may evaluate energy savings through a statewide average for each fuel
| Electricity (kWh) |
| Natural Gas (therms) |
| Oil Savings (gallons) |
| Gasoline (gallons) |
| Diesel (gallons) |
| Propane (gallons) |
Application Summary (cells will calculate basesd on data on next tab)
Green Communites Funding Requested $ - 0
| Projected Annual Cost Savings ($) | $ - 0 |
| Simple GC$ Payback Period | - 0 |
| MMBtu saved (annually) | - 0 |
| GC$/MMBtu, 3-year project average = 249 | - 0 |
| GHG metric tons saved (annually) | - 0 |
| GC$/GHG ton, 3-year project average = 3,629 | - 0 |
Grant Table
| Project Annual Energy Savings | Project Cost Information | Reference and Supporting Information | Data Summary | ||||||||||||||||||||||||
| Building Name and/or Location | |||||||||||||||||||||||||||
| (as noted in MEI) | Traditional, Administrative, Prescriptive Project, OR Building Decarbonization | ||||||||||||||||||||||||||
| (select from dropdown list) | Project Name | ||||||||||||||||||||||||||
| (description for Projects) [1] | Estimated Projected Completion (month/year) [2] | Electricity (kWh)[3] | Natural Gas (therms)[3] | Oil (gallons)[3] | Gasoline (gallons)[3] | Diesel (gallons)[3] | Propane (gallons)[3] | Total Project Cost ($) | GC Grant Funding ($) [4] | Utility Incentives ($) | Other Grants ($) (please list source in column N) | Community Contribution ($) | Funding Source(s) for Other Grants | Source of Community Contribution | |||||||||||||
| (if applicable) | Audit or Study Reference | Audit or Study Page Reference(s) [5] | Other Supporting Document(s) and Page References [5] | Part of Performance Contract? | |||||||||||||||||||||||
| (yes or no) | Projected Annual Energy Cost Savings ($) | MMBtu saved per Year | GC$/MMBtu | Simple GC Payback Period (years) | GHG emissions (tons CO2) saved per year | GC$/GHG (tons CO2) | |||||||||||||||||||||
| 0 | $0.00 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||||||
| 0 | $0.00 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||||||
| 0 | $0.00 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||||||
| 0 | $0.00 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||||||
| 0 | $0.00 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||||||
| 0 | $0.00 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||||||
| 0 | $0.00 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||||||
| 0 | $0.00 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||||||
| 0 | $0.00 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||||||
| 0 | $0.00 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||||||
| 0 | $0.00 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||||||
| 0 | $0.00 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||||||
| 0 | $0.00 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||||||
| 0 | $0.00 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||||||
| 0 | $0.00 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | ||||||||||||||||||||
| Green Community: | 0 | 0 | 0 | 0 | 0 | 0 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | N/A | N/A | N/A | N/A | N/A |
| Notes: |
| [1]Municipalities can submit any number of proposals, provided each meets all program requirements. Contact your regional coordinator if you need additional rows in the spreadsheet. |
| [2] Proposed projects should be completed within approximately one year from contract execution. |
| [3] Please estimate only the projected direct annual cost and energy savings. Please be sure to complete the energy costs per unit table in the first worksheet. For fuels not listed in this table, please contact your regional coordinator. DOER will perform the calculations for MMBtu and GHGs. |
| [4] GC Grant funding ($) = Total Project Cost ($) less Utility Incentives, Other Grants, and Community Contribution |
| [5] Please provide a specific page number/range from the audit or study that provides funding request and project details. |
Example Grant Table
| Project Annual Energy Savings | Project Cost Information | Reference and Supporting Information | Data Summary | |||||||||||||||||||||||||
| Building Name and/or Location | ||||||||||||||||||||||||||||
| (as noted in MEI) | Traditional, Administrative, Prescriptive Project, OR Building Decarbonization | |||||||||||||||||||||||||||
| (select from dropdown list) | Project Name | |||||||||||||||||||||||||||
| (description for Projects) [1] | Estimated Projected Completion (month/year) [2] | Electricity (kWh)[3] | Natural Gas (therms)[3] | Oil (gallons)[3] | Gasoline (gallons)[3] | Diesel (gallons)[3] | Propane (gallons)[3] | Total Project Cost ($) | GC Grant Funding ($) [4] | Utility Incentives ($) | Other Grants ($) (please list source in column N) | Community Contribution ($) | Funding Source(s) for Other Grants | Source of Community Contribution | ||||||||||||||
| (if applicable) | Audit or Study Reference | Audit or Study Page Reference(s) [5] | Other Supporting Document(s) and Page References [5] | Part of Performance Contract? | ||||||||||||||||||||||||
| (yes or no) | Projected Annual Energy Cost Savings ($) | MMBtu saved per Year | GC$/MMBtu | Simple GC Payback Period (years) | GHG emissions (tons CO2) saved per year | GC$/GHG (tons CO2) | ||||||||||||||||||||||
| Town Offices | B. Traditional: HVAC Equipment | Air Source Heat Pump | 12/2024 | (19,685) | 2,185 | $ 81,325.00 | $ 40,725.00 | $ 40,600.00 | $ - 0 | $ - 0 | n/a | Private Donation | Ames_Town_Audit.pdf | page 1 | Ames_Town_ERP.pdf | No | $ 3,557.95 | 236.5 | 172.2 | 11.45 | 17.35 | 2,347.23 | ||||||
| Town Offices | A. Traditional: Building Env. Improvement | Weatherization | 12/2024 | 350 | $ 22,750.00 | $ 11,375.00 | $ 11,375.00 | $ - 0 | $ - 0 | n/a | General Fund | Ames_Town_Audit.pdf | page 2 | Ames_Town_ERP.pdf | No | $ 1,137.50 | 48.7 | 233.8 | 10.00 | 3.55 | 3,201.53 | |||||||
| High School | K. Prescriptive: LED Lighting | LED Lighting | 12/2024 | 72,973 | $ 164,216.00 | $ 72,973.00 | $ 70,254.00 | $ - 0 | $ 20,989.00 | n/a | - | Ames_Town_Audit.pdf | page 3 | Ames_Town_ERP.pdf | No | $ 13,135.14 | 249.0 | 293.1 | 5.56 | 17.91 | 4,075.08 | |||||||
| Building Inspector | G. Prescriptive: Light Duty BEVs | Chevy Bolt | 12/2024 | (3,417) | 756 | $ 33,000.00 | $ 7,500.00 | $ - 0 | $ - 0 | $ 25,500.00 | General Fund | Chevy_Bolt.pdf | https://afdc.energy.gov/calc/ | - | No | $ 2,030.94 | 82.1 | 91.4 | 3.69 | 5.86 | 1,279.94 | |||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||||
| $ - 0 | $ - 0 | $ - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | |||||||||||||||||||||
| Green Community: | 49,871 | - 0 | 2,535 | 756 | - 0 | - 0 | $ 301,291.00 | $ 132,573.00 | $ 122,229.00 | $ - 0 | $ 46,489.00 | N/A | N/A | N/A | N/A | N/A |
| Notes: |
| [1]Municipalities can submit any number of proposals, provided each meets all program requirements. Contact your regional coordinator if you need additional rows in the spreadsheet. |
| [2] Proposed projects should be completed within approximately one year from contract execution. |
| [3] Please estimate only the projected direct annual cost and energy savings. Please be sure to complete the energy costs per unit table in the first worksheet. For fuels not listed in this table, please contact your regional coordinator. DOER will perform the calculations for MMBtu and GHGs. |
| [4] GC Grant funding ($) = Total Project Cost ($) less Utility Incentives, Other Grants, and Community Contribution |
| [5] Please provide a specific page number/range from the audit or study that provides funding request and project details. |
DOER Reference Data
| CO2e Emissions per Unit (metric tons) | 2023 Grant Table Updates: | |||
| Electricity (kWh) [2020 MassDEP Non-Biogenic Retail] | 0.00025 | Updated electric co2e emissions to equal non-biogenic retail emission from table 9 appendix 3 of the 2020 DEP Emissions Report | ||
| Natural Gas (therms) | 0.00531 | Changed CO2e emissions from short tons to metric tons | ||
| Oil Savings (gallons) | 0.01015 | Removed 25A column | ||
| Gasoline (gallons) | 0.00886 | Changed title of "Project Completion Date" column to "Estimated Project Completion Date" | ||
| Diesel (gallons) | 0.01015 | Changed GC$/MMBTU from 177 to 197 | ||
| Propane (gallons) | 0.00576 | Changed GC$/GHG from 2258 to 2863 | ||
| Source: Calculated from MEI: What factors are used for calculating CO2 emissions? | ||||
| 2024 Grant Table Updates: | ||||
| lbs to metric tons conversion for electricity | 2,204.62 | Updated Measures to include full list to pick from | ||
| Change wording on Notes [1] section | ||||
| Conversion Factors (Various Units to MMBtus) | Changed GC$/MMBTU from 197 to 3-year average 215 | |||
| Electricity (kWh) | 0.00341 | 360660.339435582 | Changed GC$/GHG from 2,863 to 3-year average 3,078 | |
| Natural Gas (therms) | 0.10000 | 39749.28 | Calculated GC$/MMBTU and GC$/GHG 3-year average from the tables on this page. Table data came from iMeet social math. | |
| Oil Savings (gallons) | 0.13900 | |||
| Gasoline (gallons) | 0.12400 | 363.36 | 2025/CPT14 Grant Table Updates: | |
| Diesel (gallons) | 0.13900 | Updated measures to match the PON | ||
| Propane (gallons) | 0.09100 | Added note about DOER may use statewide average for fuels | ||
| Source: MEI: What factors are used for converting fuel usage into MMBTUs? | Changed GC$/MMBTU from 215 to 4-year average 249 | |||
| Changed GC$/GHG from 3,078 to 4-year average 3,629 | ||||
| Measures | Letter | Category | Measure | Calculated GC$/MMBTU and GC$/GHG 4-year average from the tables on this page. |
| A. Prescriptive: VFDs | A | Prescriptive: | VFDs | |
| B. Prescriptive: Walk-in Refrigeration Controls | B | Prescriptive: | Walk-in Refrigeration Controls | |
| C. Prescriptive: Door and Window Weather-Stripping | C | Prescriptive: | Door and Window Weather-Stripping | |
| D. Prescriptive: Window Replacement | D | Prescriptive: | Window Replacement | |
| E. Prescriptive: Workforce Development | E | Prescriptive: | Workforce Development | |
| F. Prescriptive: Light Duty HEVs & PHEVs | F | Prescriptive: | Light Duty HEVs & PHEVs | |
| G. Prescriptive: Light Duty BEVs | G | Prescriptive: | Light Duty BEVs | |
| H. Prescriptive: Medium/Heavy Duty BEVs | H | Prescriptive: | Medium/Heavy Duty BEVs | |
| I. Prescriptive: EV Charging Stations | I | Prescriptive: | EV Charging Stations | |
| J. Prescriptive: Battery Lawncare Equipment | J | Prescriptive: | Battery Lawncare Equipment | |
| K. Prescriptive: LED Lighting | K | Prescriptive: | LED Lighting | |
| L. Prescriptive: LED Streetlights | L | Prescriptive: | LED Streetlights | |
| A. Traditional: Building Env. Improvement | A | Traditional: | Building Env. Improvement | |
| B. Traditional: HVAC Equipment | B | Traditional: | HVAC Equipment | |
| C. Traditional: Water Heaters | C | Traditional: | Water Heaters | |
| D. Traditional: Building Controls Systems | D | Traditional: | Building Controls Systems | |
| E. Traditional: Retro-commissioning | E | Traditional: | Retro-commissioning | |
| F. Traditional: Pumps, Motors, and Drives | F | Traditional: | Pumps, Motors, and Drives | |
| G. Traditional: Battery Storage | G | Traditional: | Battery Storage | |
| H. Traditional: Repairs to Existing RE | H | Traditional: | Repairs to Existing RE | |
| I. Traditional: Commercial Refrigeration | I | Traditional: | Commercial Refrigeration | |
| BUILDING DECARBONIZATION PROJECTS | BUILDING DECARBONIZATION PROJECTS | |||
| B. Special: Other | B | Special: | Other | |
| C. Special: Community Outreach | C | Special: | Community Outreach | |
| D. Special: New Solar PV | D | Special: | New Solar PV | |
| Administrative Costs | Administrative Costs |
| CPT10 Application Summary | Metrics |
| GC$ | 16,048,319 |
| Project$ | 25,381,613 |
| MMBTU (annually) | 82,579 |
| GHG (annually) | 6,146 |
| GC$/MMBTU (one year) | 194 |
| GC$/GHG (one year) | 2,611 |
| Project$/MMBTU (one year) | 307 |
| Project$/GHG (one year) | 4,130 |
| CPT11 Application Summary | Metrics |
| GC$ | 12,443,330 |
| Project$ | 27,920,384 |
| MMBTU (annually) | 59,771 |
| GHG (annually) | 4,114 |
| GC$/MMBTU (one year) | 208 |
| GC$/GHG (one year) | 3,025 |
| Project$/MMBTU (one year) | 467 |
| Project$/GHG (one year) | 6,787 |
| CPT12 Application Summary | Metrics |
| GC$ | 11,048,298 |
| Project$ | 20,285,630 |
| MMBTU (annually) | 41,567 |
| GHG (annually) | 2,587 |
| GC$/MMBTU (one year) | 266 |
| GC$/GHG (one year) | 4,271 |
| Project$/MMBTU (one year) | 488 |
| Project$/GHG (one year) | 7,841 |
| CPT13 Application Summary | Metrics |
| GC$ | 22,701,379 |
| Project$ | 53,179,104 |
| MMBTU (annually) | 65,933 |
| GHG (annually) | 4,304 |
| GC$/MMBTU (one year) | 344 |
| GC$/GHG (one year) | 5,274 |
| Project$/MMBTU (one year) | 807 |
| Project$/GHG (one year) | 12,355 |
| Four-year Average | Metrics |
| GC$ | 62,241,326 |
| Project$ | 126,766,731 |
| MMBTU (annually) | 249,850 |
| GHG (annually) | 17,151 |
| GC$/MMBTU (one year) | 249 |
| GC$/GHG (one year) | 3,629 |
| Project$/MMBTU (one year) | 507 |
| Project$/GHG (one year) | 7,391 |
File details come from the government source that posted it. Updated .