MIL1901E.audit_template_savings.xlsm

XLSM spreadsheet 5 MB Posted Aug 1, 2018

Attached to: MIL1901E-EC1 MIL-Natick-Solar PV-Design/Build
Solicitation number: BD-19-1019-DCP08-ENR01-29482
Issued by: Middlesex County, Massachusetts

About this file

Written by GovTribe AI · Aug 1, 2024

This document appears to be an audit template for the Accelerated Energy Program (AEP), which was established by the Massachusetts Department of Capital Asset Management and Maintenance (DCAMM) to accelerate the implementation of energy and water conservation projects across the Commonwealth. The template is designed for audits of all levels and provides instructions and data input sheets for auditors to record building information, utility accounts, and identified energy conservation measures (ECMs). The template includes tabs for the auditor to provide an overview of the audit, verify building and asset data, input ECM details, note code-related observations, and summarize the audit findings. DCAMM will use the information from the completed template to select which ECMs will be included in the energy efficiency project.

The project details indicate this is for a solar photovoltaic (PV) canopy and electric vehicle (EV) charging stations at the Massachusetts National Guard Supply Depot in Natick, Massachusetts. The project scope includes design and construction of a 205 kW solar PV canopy, with battery storage and rooftop solar as alternative ECMs. No specific details are provided regarding pricing, funding sources, set-asides, or the contract term.

View the file

Other files

File	Type	Posted
MIL1901E Natick Solar PV RFP.pdf	PDF	Aug 1, 2018
preproposalsignin8.7.18.pdf	PDF	Aug 1, 2018
MIL1901E Scope of Work Form_Final.xlsx	XLSX spreadsheet	Aug 1, 2018
MAARNG Natick_C-102_Lyt+Matls Pln_2015_As-Built_Mark-Up.pdf	PDF	Aug 1, 2018
017419-DBB-rev71-Construction Waste Mgmt and Disposal~1.pdf	PDF	Aug 1, 2018
MAARNG Natick_E1.00_Elec Site Pln_2015_As-Built_Mark-Up.pdf	PDF	Aug 1, 2018
MAARNG Natick_E1.01_Elec Site Dets_2015_As-Built_Mark-Up.pdf	PDF	Aug 1, 2018
018100-DBB-rev71-Commissioning~1.pdf	PDF	Aug 1, 2018
MIL1901E-EC1_Dec. of Soil Bearing Capacity.pdf	PDF	Aug 1, 2018
MAARNG Natick_E1.01_Elec Site Detls_2015_As-Built.pdf	PDF	Aug 1, 2018
017418-DBB-rev71-Demolition Waste Mgmt and Disposal~1.pdf	PDF	Aug 1, 2018
MIL1901E Eversource Elect Bills Nov 2015-July 2018.pdf	PDF	Aug 1, 2018
MIL1901E_EC1_ Response_Form.docx	DOCX document	Aug 1, 2018
Environmental Baseline Study Draft June.4.2010.pdf	PDF	Aug 1, 2018
MAARNG Natick_C-106_Utility Plan_2015_As-Built.pdf	PDF	Aug 1, 2018
MIL1901E Cover Letter.docx	DOCX document	Aug 1, 2018
MAARNG Natick_C-105_Utility Plan_2015_As-Built_Mark-Up.pdf	PDF	Aug 1, 2018
MIL1901E_Prevailing_Wage.pdf	PDF	Aug 1, 2018
260001-CMR-rev71-TB Electrical Work~1.pdf	PDF	Aug 1, 2018
site visit sign in sheet 8.9.18.pdf	PDF	Aug 1, 2018
024100-DBB-rev71-Demolition~1.pdf	PDF	Aug 1, 2018
MIL1901E EC1 Pricing Savings Form.xlsx	XLSX spreadsheet	Aug 1, 2018
Natick Readiness Center Report-6.7.17.pdf	PDF	Aug 1, 2018
MIL1901E Pre-Proposal Conference PresentanKAL.pptx	PPTX presentation	Aug 1, 2018
MAARNG Natick_C-103_Grading+Drain Pln_2015_As-Built_Mark-Up.pdf	PDF	Aug 1, 2018
DOC011.pdf	PDF	Aug 1, 2018
MAARNG Natick_Struct Sects+Detls_As-Built_Mark-Up.pdf	PDF	Aug 1, 2018
MAARNG Natick_C-101_Lyt Matls Pln_2015_As-Built_Mark-Up.pdf	PDF	Aug 1, 2018
MAARNG Natick_E1.00_Elec Site Plan_2015_As-Built.pdf	PDF	Aug 1, 2018
ESA Small Project Template August 2018.pdf	PDF	Aug 1, 2018
MAARNG Natick_H2.04_HVAC Roof New Wrk Pln_2015_As-Built_Mark-Up.pdf	PDF	Aug 1, 2018
MAARNG Natick_LS-101_Landscape+Plant Pln_2015_As-Built.pdf	PDF	Aug 1, 2018
SDO-certified MWBE Sub-contractors~2.xlsx	XLSX spreadsheet	Aug 1, 2018
MIL1901E_Natick_Real_Property.pdf	PDF	Aug 1, 2018
MIL1901E Proposals Recieved.pdf	PDF	Aug 1, 2018
MAARNG Natick_C-104_Grading+Drain Pln_2015_As-Built_Mark-Up.pdf	PDF	Aug 1, 2018
Geotechnical Engineering Report 03-22-11.pdf	PDF	Aug 1, 2018

Show all 37

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.

Instructions

Background Legend
White	Data Input from Auditor
Blue	Headers
Orange	Calculated Outputs (secure)
Yellow	Data Provided from DCAMM - to be verified by Auditor
Green	Calculated Totals (secure)

Instructions

The audit template may be used for only one site at a time. The spreadsheet file should be copied and used for each new audited site. One site may contain many buildings. The template is designed so that all buildings in a site can be included in the same audit template spreadsheet.

- The audit template has 10 tabs:

- - 2 red instructions sheets

- - 4 green data input sheets

- - 1 brown Notes sheet

- - 3 blue output sheets

- The audit template is designed for audits of all levels. Not all fields are required for all audits. Specifically, auditors are only required to fill in data on the Measures Input tab based upon ECM opportunities identified during the audit.

- Each data input tab has an "Instructions" button in the upper left-hand corner that links back to this instructions page.

- NOTE: During data entry, auditors MUST either type manually, use the drop-down menus, or use "Paste Special - Values" in order to keep the template's formatting integrity.

- "Print Page" buttons send the current tab to your default printer. Auditors are encouraged to export to PDF files as needed: File -> Save As -> Choose "PDF" from the "file type" dropdown menu.

Individual tab instructions are as follows:

If the auditor wishes to track fuel usage in units that are not listed in the template (ex., Water in MCF instead of Gallons), please indicate this to DCAMM as early as possible so an adjustment can be made.

Reference

- Measures to be included in Utility Vendor Audits. All Measures must be audited, and if not applicable, noted in the table.

-Measures to be included in Utility Vendor Audits. This table highlights Measures that should be focused on for Whole Building Analysis and Simple Fix in BLACK. Other Measures that may be more appropriate for large, Comprehensive Audits are listed in GREY.

-Check List for Small Energy Conservation Projects. This table highlights potential code problems that could arise during or resulting from the installation of common measures for Simple Fix and Whole Building Analysis audits.

Site-Input

This tab is used to provide an overview of the audit being performed and record the which buildings were audited and the types of fuel and water consumed in each building.

- Start by entering the CAMIS Site Code into Cell G3. The CAMIS Site Code will normally be provided by DCAM. By entering the CAMIS Site Code, the template is able to pre-populate much of the data currently on record. Pre-populated data appears throughout the template in yellow colored cells, is protected, and cannot be modified.

- During the audit, the auditor should validate all pre-populated data. In the event of a discrepancy, the auditor may use the Site Variances tab to record needed corrections.

- All white colored cells require data to be filled in by the auditor. This is accomplished by either typing in data or using the pull down menus to enter requested information.

- For buildings not in CAMIS, there is an Additional Buildngs section to the right of the pre-populated section where Auditor can input building information.

- To the right of Site information table, Auditor should input primary utility rates to be used across the template. In cases where there is more than one rate per fuel, Auditor must manually override calculated cells.

Asset-Input

This tab contains additional building-specific data to be verified by the auditor when possible and applicable.

- Validate pre-populated building data in yellow cells.

- Enter data in the white colored cells where applicable and available.

- When available, add all baseline energy consumption and cost data in applicable white cells.

Utility Accounts Information

- These columns are used to verify all known utility account and meter information at the building level. NOTE: pre-loaded data may be inaccurate or incomplete. Verification of these cells is necessary.

- In the absence of utility account information, identify which meters serve which buildings.

Measures-Input

This tab is used to enter all identified ECMs in each building audited.

- Begin by using the drop down menu to select the Building # where the ECM is recommended. This will pre-populate the building name.

- Select the appropriate DCAMM Measure Category from the pull down menu

- Select the appropriate Measure Type from the pull down menu

- Enter all available or calculated information related to the measure including total estimated installed cost, estimated annual energy savings, and estimated annual cost savings for the measure. Data entered should be the total value for the measure installed and not the per unit installed value. E.G. If an ECM costs $5 and saves 200 therms per year and the quantity is two, then the auditor enters the total installed cost of $10 and the total estimated annual savings of 400 therms. These calculations should be done on a separate tab to be inserted by the auditor after the Report Outline Tables tab. If an ECM impact multiple fuels and/or water, then data must be entered in all applicable fields.

- If there is more than one ECM identified in a building, start a new row, and repeat all steps described above.

- DCAMM will select which ECMs will be included in the project, indicating selection in column BC.

- Insert tabs as necessary after the report outline tab for lighting line-by-line workbooks and other ECM savings calculations support. Then link totals back to the Measures-Input tab.

Form B-Input

This tab is used to enter cost figures for each proposed ECM.

-Information to be automatically imported or calculated are in YELLOW cells.

-Enter information in all WHITE cells, and RED cells as approved by DCAMM.

Code-Related Observations

This tab is used to note any work that is known or may be required to comply with building/construction codes, with due to the execution of the energy work or otherwise.

- Use drop down menu to select applicable building and fill in location within building (e.g. office)

- Note the type (e.g. wiring) and a brief description (e.g. knob and tube exists in walls, will require work to before insulation can be installed)

Contract ECMs

- This tab is a copy of the Measures-Input tab, and will automatically fill itself out as DCAMM selects which measures to be included in the project.

Audit Summary

This tab summarizes the data into a standardized report for printing.

- Auditor should indicate next to each ECM type in the ECM Summary table whether or not that type of ECM was considered during the audit.

- Press the Print button above to send the reports to the printer.

- When copy/pasting to the AEP Audit Outline, Auditor MUST Paste Special - As Picture.

Report Outline Tables

- This tab contains all tables that will be necessary for the AEP Audit Report Outline, pre-populated with data entered in the AEP Audit Template. The auditor is able fill in any missing information, and can copy/paste these tables from the Template into Part 2 (Executive Summary) of the Outline.

&A &D

Reset

Print Reports

Print Page

Reference

Measures to be included in Utility Vendor Audits		DCAMM ECM No.	SF	WBA	Potential Existing Conditions	Potential ECMs	Applicable to Audit? (Y/N)
Lighting			ü	ü	Incandescent, older fluorescent lights with manual controls	CFLs, new fluorescent technologies, LEDs, sensors, timer, etc.
	Bulbs, Fixtures, Ballasts, Exit Signs	1.0			Incandescent, older fluorescent lights,	CFLs, new fluorescent technologies, LEDs
	Controls	2.0			Older Controls, manual switches, inoperable controls	Sensors, Timers, etc.
Motors		3.0		ü	Standard efficiency motors	VFDs, VSDs, ECMs,
Windows		12.0	ü	ü	Single pane, old, cracked, inoperable	E-Star Window
Doors		12.0	ü	ü	Hollow or cracked, poor alignment, broken, does not fully close, inoperable	New insulated door, proper fit
Overhead door		12.0	ü	ü	Uninsulated, no seals, poor alignment	New insulated overhead door, new seals
Air Sealing		10.0	ü	ü	Drafts around windows, doors, through walls, joints, corners	Air sealing ECMs (Blower door guided air sealing, foam, seals, etc.)
Energy Management System				ü	Inoperable or no EMS	Reprogram or Install EMS
	Ventilation Controls	4.0			non-functioning or missing	CO Sensors, Outside Air / Economisers
	Ventilation Hoods	4.0			Exhaust hoods running continuiously	Exhaust Hood Controls
Toilets & Urinals		5.0	ü	ü	Standard, large volume flush toilets and urinals	Low-flow toilets and urinals
Faucets		5.0	ü	ü	Older, standard faucets with no flow restrictors	Faucet aerators, actuated faucets, flow restrictors
Showers		5.0	ü	ü	Standard, older showerheads	Low-flow shower heads
Commercial Kitchen Pre-rinse Spray Valves		5.0	ü	ü	Standard, >2 gpm pre-rinse spray valves	Low-flow pre-rinse spray valves
Thermostats		4.0	ü	ü	Manual or older mechanical thermostats	Programmable thermostats
Boiler Reset Control		4.0	ü	ü	Reset control not functioning or does not exist	Boiler Reset Control
Water Heater		5.0	ü	ü	Stand alone tank type or "everhot"	Indirect tank or on-demand
Heating Systems			ü	ü	Oil	Convert to natural gas or pellet
	Boilers	14.0	ü	ü	Standard efficiency forced hot water or steam	Appropriately sized, condensing (FHW only) or new steam
	Furnaces	17.0	ü	ü	Standard efficiency	Condensing furnace with Electronically commutated motor
	Unit Heaters	17.0	ü	ü	Standard efficiency or steam	Condensing Unit Heater or Infrared tube
	Other	17.0		ü		Heat pumps
Cooling Systems
	Rooftop	17.0		ü	Standard efficiency rooftop unit	High SEER rooftop unit
	Window	17.0	ü	ü	Standard efficiency or older unit	E-Star rated unit
Pipe Insulation
	Water heater	10.0	ü	ü	Broken or no insulation on hot water pipe	Pipe Insulation
	Heating distribution	10.0		ü	Broken or no insulation on steam or water distribution pipes	Pipe Insulation
	Near boiler	10.0	ü	ü	Broken or no insulation on near-boiler piping	Near-boiler pipe insulation
Steam Traps/Valves		8.0		ü	Leaking or frozen steam traps	Replace steam traps and develop trap replacement program
Ducts
	Sealing	17.0	ü	ü	Leaking, unsealed or loose ducts	Duct sealing
	Insulation	10.0	ü	ü	Broken, torn or no insulation	Replace , seal, or install duct insulation
Wall Insulation		10.0		ü	Wet, torn or missing wall insulation	Wall Insulation (batts, blown-in or spray on)
Attic Insulation		10.0	ü	ü	Uneven, missing or no attic insulation	Blown-in attic insulation or fiberglass batts (after proper air sealing and when access point already exists) . Insulation area < 5000 sq. ft.
Appliances
	Refrigerators	23.0	ü	ü	Older refrigerators	ENERGY STAR rated refrigerator
	Computers	11.0	ü	ü	Computer and monitors left on	Power Maintenance software
	Vending Machines	11.0	ü	ü	Standard efficiency vending machines	Vending Mizer
	Washing Machines	23.0	ü	ü	Vertical axis washing machines	Horizontal Axis Washing Machines
Building Codes Check List for Small Energy Conservation Projects									updated 12/17/2012
Measures to be included in Smaller Site Audits		DCAMM ECM No.	SF	WBA	Potential Existing Conditions	Potential ECMs	Potential Code Areas	Potential Hazardous / Disposal Requirements	Design Professionals	Utility

Rebates Lighting ü ü Incandescent, older fluorescent lights with manual controls CFLs, new fluorescent technologies, LEDs, sensors, timer, etc. MA electrical code 527 CMR 12 MA-Amended IECC

When reconfiguring existing lighting (see Family of Codes description)	Yes
Bulbs, Fixtures, Ballasts, Exit Signs	1.0	Incandescent, older fluorescent lights,	CFLs, new fluorescent technologies, LEDs	MA electrical code 527 CMR 12

MA-Amended IECC

	Yes	When reconfiguring existing lighting (see Family of Codes description)
		Controls	2.0		Older Controls, manual switches, inoperable controls	Sensors, Timers, etc.	MA electrical code 527 CMR 12
MA-Amended IECC	No	No	Yes
	Motors		3.0	ü	Standard efficiency motors	VFDs, VSDs, ECMs,	MA electrical code 527 CMR 12

MA-Amended IECC Elevator Code 524 CMR

IEBC 2009 §403.1 Alteration Level 1	No	Site / project dependent	Yes
	Windows		12.0	ü	ü	Single pane, old, cracked, inoperable	E-Star Window	IECC 2009 §101.4.3 (additions, alterations)

IECC 2009 §101.4.2 (historic buildings) IECC 2009 §502.1.1 (commercial envelope) IEBC 2009 §403.1 Alteration Level 1

IEBC 2009 §502.3 (Glazing in hazardous locations)	Yes - if PCB contamination
Yes - EPA regs RE: lead paint, Yes - MA 454 CMR 22	Only if altering wall opening	No
	Doors		12.0	ü	ü	Hollow or cracked, poor alignment, broken, does not fully close, inoperable	New insulated door, proper fit	IECC 2009 §101.4.3 (additions, alterations)

IECC 2009 §101.4.2 (historic buildings) IEBC 2009 §403.1 Alteration Level 1

IECC 2009 §502.1.1 (commercial envelope)	Yes - if PCB contamination
Yes - EPA regs RE: lead paint		No
	Overhead door		12.0	ü	ü	Uninsulated, no seals, poor alignment	New insulated overhead door, new seals	MA electrical code 527 CMR 12

IECC 2009 §101.4.3 (additions, alterations) IECC 2009 §101.4.2 (historic buildings) IEBC 2009 §403.1 Alteration Level 1

IECC 2009 §502.1.1 (commercial envelope)	Yes - if PCB contamination
Yes - EPA regs RE: lead paint	Site / project dependent	No
	Air Sealing		10.0	ü	ü	Drafts around windows, doors, through walls, joints, corners	Air sealing ECMs (Blower door guided air sealing, foam, seals, etc.)	MA amended IECC

Combustion Air- 527 CMR 4

Combustion Air - 248 CMR	No	No - specialized trade	Yes
	Energy Management System		4.0	ü	Inoperable or no EMS	Reprogram or Install EMS	MA electrical code 527 CMR 12

MA-Amended IECC

IEBC 2009 §403.1 Alteration Level 1	No	Site / project dependent	Yes
	Toilets & Urinals		5.0	ü	ü	Standard, large volume flush toilets and urinals	Low-flow toilets and urinals	plumbing 248 CMR

521 CMR

IEBC 2009 §403.1 Alteration Level 1	No	Site / project dependent	No
	Faucets		5.0	ü	ü	Older, standard faucets with no flow restrictors	Faucet aerators, actuated faucets, flow restrictors	plumbing 248 CMR

521 CMR

IEBC 2009 §403.1 Alteration Level 1	No	Site / project dependent	Yes
	Showers		5.0	ü	ü	Standard, older showerheads	Low-flow shower heads	plumbing 248 CMR

521 CMR

IEBC 2009 §403.1 Alteration Level 1	No	Site / project dependent	Yes
	Commercial Kitchen Pre-rinse Spray Valves		5.0	ü	ü	Standard, >2 gpm pre-rinse spray valves	Low-flow pre-rinse spray valves	plumbing 248 CMR
IEBC 2009 §403.1 Alteration Level 1	No	Site / project dependent	Yes
	Thermostats		4.0	ü	ü	Manual or older mechanical thermostats	Programmable thermostats	MA electrical code 527 CMR 12

MA-Amended IECC

IEBC 2009 §403.1 Alteration Level 1	Yes (mercury)	No	Yes
	Boiler Reset Control		4.0	ü	ü	Reset control not functioning or does not exist	Boiler Reset Control	MA electrical code 527 CMR 12

MA-Amended IECC

IEBC 2009 §403.1 Alteration Level 1	No	No	Yes
	Water Heater		5.0	ü	ü	Stand alone tank type or "everhot"	Indirect tank or on-demand	plumbing 248 CMR

IEBC 2009 §403.1 Alteration Level 1 MA electrical Code 527 CMR 12

522 CMR Boiler Rules	Yes (asbestos)	Yes - when resizing or reconfiguring	Yes
	Heating Systems			ü	ü	Oil	Convert to natural gas or pellet
		Boilers	14.0	ü	ü	Standard efficiency forced hot water or steam	Appropriately sized, condensing (FHW only) or new steam	plumbing 248 CMR

MA electrical code 527 CMR 12 MA-Amended IECC IEBC 2009 §403.1 Alteration Level 1

522 CMR Boiler Rules	Yes (asbestos)	Yes - when resizing or reconfiguring (see Family of Codes description)	Yes
		Furnaces	17.0	ü	ü	Standard efficiency	Condensing furnace with Electronically commutated motor	plumbing 248 CMR

MA electrical code 527 CMR 12

MA-Amended IECC	Yes (asbestos)	Yes - when resizing or reconfiguring (see Family of Codes description)	Yes
		Unit Heaters	17.0	ü	ü	Standard efficiency or steam	Condensing Unit Heater or Infrared tube	plumbing 248 CMR

MA electrical code 527 CMR 12

MA-Amended IECC	Yes (asbestos)	Yes - when resizing or reconfiguring (see Family of Codes description)	Yes
		Other	17.0	ü	Heat pumps (air)	plumbing 248 CMR

MA electrical code 527 CMR 12

IECC 2009

DIG SAFE 220 CMR	No	Yes - when resizing or reconfiguring (see Family of Codes description)	Yes
	Cooling Systems
		Rooftop	17.0	ü	Standard efficiency rooftop unit	High SEER rooftop unit	plumbing 248 CMR

MA electrical code 527 CMR 12

IECC 2009

IEBC 2009 §403.1 Alteration Level 1	Yes - refrigerant	Yes - when resizing or reconfiguring (see Family of Codes description)	Yes
		Window	17.0	ü	ü	Standard efficiency or older unit	E-Star rated unit		Yes - refrigerant	No	No
	Pipe Insulation
		Water heater	10.0	ü	ü	Broken or no insulation on hot water pipe	Pipe Insulation	IECC 2009 §403.3 (pipe insulation)	Yes (asbestos)	No	Yes
		Heating distribution	10.0		ü	Broken or no insulation on steam or water distribution pipes	Pipe Insulation	IECC 2009 §403.3 (pipe insulation)	Yes (asbestos)	No	Yes
		Near boiler	10.0	ü	ü	Broken or no insulation on near-boiler piping	Near-boiler pipe insulation	IECC 2009 §403.3 (pipe insulation)	Yes (asbestos)	No	Yes
	Steam Traps/Valves		8.0		ü	Leaking or frozen steam traps	Replace steam traps and develop trap replacement program	plumbing 248 CMR

fire safety

IECC 2009

522 CMR Boiler Rules	No	Yes - when resizing or reconfiguring (see Family of Codes description)	Yes
	Ducts
		Sealing	17.0	ü	ü	Leaking, unsealed or loose ducts	Duct sealing	IECC 2009 §403.2 (duct sealing)	No	No	Yes
		Insulation	10.0	ü	ü	Broken, torn or no insulation	Replace , seal, or install duct insulation	IECC 2009 §403.2 (duct insulation)	No	No	Yes
	Wall Insulation		10.0		ü	Wet, torn or missing wall insulation	Wall Insulation (batts, blown-in or spray on)	IECC 2009 §101.4.3 (additions, alterations)

IECC 2009 §502.1.1 (commercial envelope)

MA electrical code 527 CMR 12 (potential based on existing wiring)	Yes - EPA regs RE: lead paint	Yes - over 35,000 cubic foot bldg (see Family of Codes description)	Yes
	Attic Insulation		10.0	ü	ü	Uneven, missing or no attic insulation	Attic insulation (Batts, blown-in or spray on)	IECC 2009 §101.4.3 (additions, alterations)

IECC 2009 §502.1.1 (commercial envelope)

MA electrical code 527 CMR 12 (potential based on existing wiring)	No	Yes - over 35,000 cubic foot bldg
may need structural analysis to cover snow load (see Family of Codes description)	Yes
	Appliances
		Refrigerators	23.0	ü	ü	Older refrigerators	ENERGY STAR rated refrigerator	Yes - refrigerant	No	No
		Computers	11.0	ü	ü	Computer and monitors left on	Power Maintenance software	No	No	No
		Vending Machines	11.0	ü	ü	Standard efficiency vending machines	Vending Mizer	No	No	Yes
		Washing Machines	23.0	ü	ü	Vertical axis washing machines	Horizontal Axis Washing Machines	No	No	No
	Overview: The Accelerated Energy Program (AEP) was established in December 2011 to accelerate the implementation of energy and water conservation projects across the Commonwealth to comply with E.O. 484. As part of the Program, DCAMM plans to retrofit 700 facilities encompassing 4,861 buildings throughout the Commonwealth which have not been retrofitted since 2000. The AEP is a three year initiative from 2012 through 2014.
	Purpose of this check list: The information presented here is intended for NON-building code personnel involved in developing small scale energy conservation audits and retrofits. It is not intended to be a replacement or substitution for the full range of code analysis and review that must be applied to all projects undertaken by a state agency, facility or consultant working on a Commonwealth project. All MA building and energy codes must be followed according to established code review procedures as required on all construction projects.
	Reference to the FAMILY OF CODES: the particular scope and scale of an energy audit or retrofit project can entail many categories of the IECC and IEBC codes. For this reason, this checklist includes reference to several "family of codes" that may or may not apply to a particular project. For example, the MA Architectural Access board requirements may apply to a project if the 521 CMR thresholds are "triggered" by a project's scope and construction cost.
	(1) Investigation and Evaluation: For existing buildings (with some exceptions) that involve Registered Design Professional (RDP) services and where the entire existing building is > 35,000 cubic feet as a condition of building permit application, an "Investigation and Evaluation" report is required. For reference purposes, the MA-amended IBC--2009, Chapter 34 is further amended sending the Reader to a MA-amended International Existing Building Code - 2009 (also known as MA-amended IEBC-09), Chapter 1, Section 101.5.4.0 and identified as "Investigation and Evaluation".
	(2) Construction Control: When a building other than 1 and 2 family stand-alone buildings are involved and such buildings are > 35,000 cubic feet of aggregate volume and involve Registered Design Professional services, 780 DCMR classified such activity as "Construction Control" and establishes requirements for certain RDP services and Contractor services. These requirements are found in the 8th Edition of 780 CMR, Chapter 1, Section 107.6 inclusive.
	(3) Registered Design Professional in Responsible Charge (RDPIRC): The 8th edition of 780 CMR consists of MA front-end amendments to the IBC-2009 and certain other International Codes (I Codes). Contained within the source language of the IBC-2009, Chapter 1 (not MA amended) is a requirement for a RDPIRC and this Code language is also in Massachusetts. This language reads: [107.3.4.1] When it is required that documents be prepared by a registered design professional, the building official shall be authorized to require the owner to engage and designate on the building permit application a registered design professional who shall act as the registered design professional in responsible charge.
	(4) MA Architectural Access Board regulations for Existing Buildings: All additions to, reconstruction, remodeling, and alterations or repairs of existing public buildings or facilities, which require a building permit or which are so defined by a state or local inspector, shall be governed by all applicable subsections in 521 CMR 3.00 - JURISDICTION.
	IECC 2009 = International Energy Conservation Code
	IEBC 2009 = International Existing Building Code

Instructions

/xl/drawings/drawing2.xml#Instructions!A16Print Page

Site-Input

Site - Audit Template

Audit Date

Site Contact - Name

AGAP4

270CAM9002

Utility Rates

Rate ($)

CAMIS Site Code

mil33

Site Contact - Title

270DEM9003

Electricity, [kWH]

$ 0.18

Site

MASS NATIONAL GUARD SUPPLY DEPOT

Site Contact - #

270DEM9004

Electricity, Renewable [kWH]

Secretariat

Public Safety

Site Contact - Email

270DEMPB05

Electricity, Demand [kW]

449MIL1500

Agency

MILITARY DIVISION

AGR01

257DFA9000

Fuel Oil, (No. 2) [Gallon]

449MILPB05

Site Address

149 Speen Street

Auditor Prime

AMES2

706DEM0100

Fuel Oil, (No. 4) [Gallon]

449MILPB04

Site City

Natick

Auditor Sub

706DEM0401

Fuel Oil, (No. 5 & 6) [Gallon]

Site ZIP

01760

Auditor - Name

706DEMPB01

Natural Gas, [Therm]

Prim Elect Util

Eversource

Auditor - Title

706DEMPB02

Other, [MMBTU]

Project Number

MIL1901E EC1

Auditor - #

706DEMPB03

Propane, [Gallon]

Data Source

Auditor - Email

ASHL3

451DEMPB01

Steam, [Pound]

Date of NTP

451DEMPB02

Water, [Gallon]

Audit Type

451DEMPB03

Consumes

ATTP1

655DEMPB01

Additional Buildings - Not in CAMIS

Consumes

Building Codes

Building Name

Sq Ft

Audited (Y/N)

In Use

Elect

Fossil Fuel

Water

655DEMPB02

Building Name

Sq Ft

Street Address

City

Zip Code

Year Built

Building Status

Building Use

Audited (Y/N)

In Use

Elect

Fossil Fuel

Water

Totals

660,000

- 0

655DEMPB03

Total

- 0

3482

MIL33

449MIL0920

GARAGE

660,000

655DEMPB04

3483

449MIL1500

Armory - Natick

46,450

655DEMPB05

3484

449MILPB05

Oil Pump Building

AUBR3

334DEM0521

3485

449MILPB04

Storage Shed

288

BCC00

111BCC0013

3486

MIL35

111BCC0015

3487

111BCC0020

3488

MIL36

111BCC0030

3489

MIL38

111BCC0040

3490

MIL39

111BCC0050

3491

111BCC0060

3492

MIL40

111BCC0070

3493

MIL42

111BCC0080

3494

MIL43

111BCC0090

3495

111BCC0600

3496

111BCCPB03

3497

111BCCPB04

3498

111BCCPB05

3499

111BCCPB06

3500

BEAR5

125DEM0020

3501

125DEM0022

3502

125DEMPB01

3503

125DEMPB03

3504

125DEMPB04

3505

127DEM0401

3506

127DEM1113

3507

127DEM1114

3508

127DEM3010

3509

127DEM3020

3510

127DEM3030

3511

127DEM3101

3512

127DEM7000

3513

127DEM7001

3514

127DEMPB07

3515

BFPL3

335DEM0401

3516

335DEM0402

3517

335DEM0403

3518

BLST3

358DEM0402

3519

358DEM0403

3520

358DEM0405

3521

358DEM0406

3522

BRAD2

518DEM0110

3523

518DEM0120

3524

518DEM0130

3525

518DEM0150

3526

518DEM0250

3527

518DEM0270

3528

518DEM0360

3529

518DEM0370

3530

518DEMPB01

3531

518DEMPB02

3532

518DEMPB03

3533

518DEMPB04

3534

519DEM0090

3535

519DEM0100

3536

MIL47

519DEM0110

3537

MIL49

519DEM0310

3538

MIL51

519DEM0320

3539

519DEM0380

3540

MIL55

519DEM0390

3541

MIL56

519DEM0400

3542

MIL57

519DEM0401

3543

MIL58

BRC00

664BRC0025

3544

664BRC0050

3545

MIL59

664BRC0060

3546

MIL60

664BRC0070

3547

MLPL3

664BRC0082

3548

664BRC0083

3549

664BRC0100

3550

664BRC0110

3551

MLRK3

664BRC0120

3552

MMA00

664BRCPB01

3553

664BRCPB02

3554

BREW1

756DEMPB41

3555

756DEMPB42

3556

756DEMPB43

3557

756DEMPB44

3558

756DEMPB45

3559

756DEMPB46

3560

756DEMPB59

3561

BRIM4

261DEM0100

3562

261DEM0120

3563

261DEM0130

3564

261DEM0140

3565

261DEM0150

261DEM0160

261DEM0170

261DEM0180

261DEM0200

261DEMPB06

261DEMPB08

353DEMPB10

BRRK2

707DEM0500

707DEM0530

707DEM0532

707DEM0540

707DEM0550

707DEM0560

BSB00

551BSB9001

BSB01

551BSB9999

BSB03

551BSB9004

BSB04

111BSB0012

BSB05

268BSB9000

BSB06

551BSB9000

BSC00

655BSC0900

669BSC0900

715BSC0020

715BSC0050

715BSC0060

715BSC0070

715BSC0080

715BSC0150

715BSC0151

715BSC0153

715BSC0156

715BSC0161

715BSC0166

715BSC0170

715BSC0180

715BSC0203

715BSC0250

715BSC0251

715BSC0255

715BSC0300

715BSC0301

715BSC0302

715BSC0303

715BSC0304

715BSC0600

715BSC0700

715BSC0701

715BSC0702

715BSC0703

715BSC0704

715BSC0705

715BSC0706

715BSC0707

715BSC0708

715BSC0709

715BSC1101

715BSC1102

715BSC1103

715BSC1105

715BSC9101

715BSCPB02

715BSCPB06

715BSCPB10

715BSCPB13

BSD00

669BSD0801

669BSD0802

669BSD0803

669BSD0804

669BSD0805

669BSD0806

669BSD0900

669BSD0901

669BSD0902

669BSD0903

669BSD0904

669BSD0905

669BSD0906

669BSD0907

669BSD0908

669BSD0909

669BSD0910

669BSD0911

669BSD0912

669BSD0913

669BSD0914

669BSD0915

669BSD0916

BSD01

668BSD0801

668BSD0802

668BSD0803

CALL3

450DEM0401

450DEM0402

450DEM0403

CCC00

761CCC0010

761CCC0011

761CCC0020

761CCC0030

761CCC0040

761CCC0050

761CCC0070

761CCC0080

761CCC0301

761CCC0400

761CCC9580

761CCCPB01

761CCCPB02

761CCCPB03

BASEBALL

BASKETBALL

INNER CAMP

PARK LOT 1

PARK LOT 2

PARK LOT 3

PARK LOT 4

PARK LOT 5

PARK LOT 6

PARK LOT 7

PARK LOT 8

PARK LOT 9

PARKLOT 11

PARKLOT 12

PARKLOT10

RING ROAD

SOC FIELD

TENNIS CT

UTILITY FL

CDA00

450CDA0210

450CDAPB01

450CDAPB02

CHBL5

251DEM0401

251DEM3220

251DEM3620

251DEM9000

251DEM9001

251DEMPB01

251DEMPB02

251DEMPB03

251DEMPB04

251DEMPB05

CHE00

552CHE0040

552CHE0050

552CHE0070

552CHE0080

552CHE0120

552CHE0140

552CHE0150

552CHE0160

552CHE0180

552CHE9202

552CHEPB01

CHIP4

258DEM1810

258DEM1820

258DEM1833

258DEM1850

258DEM1860

258DEM2190

258DEM9008

258DEMPB01

258DEMPB02

CHPL4

258DEM9003

258DEM9004

258DEM9005

CJT00

270CJT9201

CLNT3

319DEM0401

319DEM0402

319DEM0403

319DEM0404

319DEM0405

CLSF5

102DEM0280

102DEM0310

102DEM0312

102DEM0320

102DEM0330

102DEM0340

102DEM2230

102DEMPB01

CME00

551CME9801

CME01

762CME0801

COCH3

436DEM0420

436DEM0440

436DEM0450

436DEM7772

436DEM7773

436DEMPB01

449DEM0352

449DEM0360

449DEM0370

449DEM0390

449DEM0440

449DEM1480

449DEMPB02

449DEMPB03

CORR1

807DEM0401

807DEM3500

807DEM3510

807DEM3530

807DEM3540

807DEMPB01

CRGW4

157DEM0401

157DEMPB10

163DEM0401

212DEMPB16

213DEM0401

213DEMPB01

213DEMPB03

213DEMPB07

214DEMPB15

258DEMPB09

DARF5

203DEM0210

203DEM0212

203DEM0220

203DEM0230

203DEM0402

203DEM1840

203DEM4380

203DEM6060

203DEM6070

203DEM6120

203DEMPB02

203DEMPB04

203DEMPB06

203DEMPB07

203DEMPB08

203DEMPB09

203DEMPB10

203DEMPB11

203DEMPB14

203DEMPB15

203DEMPB16

203DEMPB18

DCP02

551CAM9603

DCP06

603CAM9601

DCP10

316CAM0040

316CAM0110

316CAM0240

316CAM0300

316CAM9203

316CAM9206

316CAM9208

316CAM9210

316CAM9212

316CAM9501

316CAM9504

316CAMPB01

316CAMPB03

316CAMPB08

316CAMPB09

316CAMPB10

316DOC0080

316DOC0160

316DOC9207

316DOC9209

316DOC9502

DCP15

268CAM9001

DCP18

322CAM9201

322CAM9202

322CAM9216

322CAM9217

DCP19

339CAM0450

339CAM0520

339CAM0630

339CAMPB01

339CAMPB05

DCP22

438CAM0001

438CAM0002

DCP23

551CAM9003

DCP24

340CAMPB04

340CAMPB11

340CAMPB12

DCP27

552CAMPB01

DCP30

620DMH0961

620DMH9208

620DMHPB02

DEML1

669DEM0401

669DEM1200

669DEM1490

669DEM2200

669DEM2300

DES00

707DET0030

DES01

664DET0020

DES03

668DET0001

DES04

658DET3333

DFS00

432DFS0110

432DFS0900

432DFS0901

432DFSPB03

432DFSPB04

432DFSPB05

432DFSPB06

432DFSPB07

432DFSPB09

432DFSPB10

432DFSPB11

432DFSPB12

432DFSPB13

432DFSPB14

432DFSPB17

DIGR1

660DEM0401

660DEM0402

660DEM0440

660DEMPB01

660DEMPB02

DMH00

516DMH3331

516DMH9007

516DMH9201

516DMH9202

DMH02

551DMH0701

551DMH9000

DMH04

551DMH9201

DMH05

763DMH0010

763DMHPB01

DMH06

707DMH0120

DMH07

603DMH9201

DMH08

552DMH9201

DMH09

526DMH9201

DMH10

664DMH9201

DMH11

664DMH0010

664DMH0020

664DMHPB01

664DMHPB02

DMH12

764DMH9201

DMH13

164DMH9000

DMH14

502DMH9201

DMH16

408DMH0010

DMH17

530DMH9201

DMH20

851DMH9201

DMH24

213DMH0200

213DMH0270

213DMH0560

213DMH0565

213DMH9801

213DMH9803

213DMH9804

DMH26

606DMH0001

606DMHPB01

606DMHPB02

DMH28

529DMH9201

DMH29

268DMH9001

DMH31

533DMH1001

533DMH2002

DMH32

658DMH0020

658DMH0050

658DMH0070

658DMH0080

658DMH0140

658DMH0170

658DMH0180

658DMH0190

658DMH0210

658DMH0220

658DMH0230

658DMH0240

658DMH0340

658DMH0601

658DMH9201

658DMH9202

658DMHPB05

658DMHPB10

658DMHPB15

658DMHPB16

DMH33

525DMH9201

DMH34

337DMH0330

337DMH0331

337DMH0390

337DMH0731

337DMH5555

337DMH5556

337DMH5557

337DMHPB01

337DMHPB03

337DMHPB04

339DMH0014

339DMH0060

339DMH0080

339DMH0140

339DMH0150

339DMH0180

339DMH0190

339DMH0200

339DMH0210

339DMH0220

339DMH0250

339DMH0290

339DMH0320

339DMH0420

339DMH0431

339DMH0530

339DMH0620

339DMH0630

339DMH0670

339DMH0680

339DMH0700

339DMH0720

339DMH0811

339DMH0821

339DMH4442

339DMH9205

339DMHPB02

339DMHPB03

339DMHPB04

339DMHPB05

339DMHPB06

339DMHPB07

339DMHPB08

339DMHPB09

339DMHPB10

339DMHPB11

339DMHPB12

339DMHPB13

339DMHPB14

339DMHPB15

339DMHPB16

339DMHPB17

339DMHPB18

339DMHPB19

339DMHPB21

339DMHPB22

DMH36

709DMH9201

DMH37

335DMH0240

335DMH0360

335DMH0570

335DMH0790

335DMH1100

335DMH9070

335DMHPB06

335DMHPB09

335DMHPB10

340CAMPB03

PARKINGA

PARKINGB

DMH40

213DMH9153

213DMH9164

DMH40

DMH41

526DMH0290

526DMH0320

DMR00

416DMR9218

416DMR9501

DMR01

207DMR9208

207DMR9209

DMR02

707DMR9201

DMR03

614DMR9205

614DMRPB01

614DMRPB02

DMR05

526DMR9501

526DMR9502

526DMR9503

526DMRPB04

526DMRPB05

DMR07

628DMR0350

628DMRPB15

DMR09

308DMR9201

308DMRPB01

DMR10

510DMR9203

510DMRPB01

510DMRPB02

510DMRPB03

DMR11

340DMR0900

340DMR9501

340DMR9502

340DMRPB01

DMR12

428DMR9601

428DMR9602

428DMRPB01

428DMRPB02

428DMRPB03

428DMRPB04

DMR13

528DMR9201

528DMRPB01

DMR14

620DMR9203

620DMRPB01

620DMRPB02

DMR16

668DMR0012

668DMRPB01

DMR18

420DMR9201

420DMR9202

420DMRPB01

DMR19

654DMR9201

654DMRPB01

DMR20

111DMR9201

111DMR9403

111DMR9404

111DMR9991

111DMRPB01

111DMRPB02

111DMRPB03

DMR21

336DMR9000

336DMR9001

336DMR9002

336DMR9003

336DMR9004

336DMR9005

336DMR9006

336DMR9007

336DMR9008

336DMR9009

336DMRPB01

336DMRPB02

336DMRPB03

336DMRPB04

DMR22

268DMR9000

268DMR9005

DMR23

658DMR0010

658DMR0020

658DMR0030

658DMR9210

658DMR9211

658DMR9212

658DMR9213

658DMR9214

658DMR9218

658DMR9221

658DMRPB01

658DMRPB02

658DMRPB03

658DMRPB04

658DMRPB05

658DMRPB06

658DMRPB07

658DMRPB08

658DMRPB09

658DMRPB10

658DMRPB11

658DMRPB12

658DMRPB13

658DMRPB14

658DMRPB15

658DMRPB53

DMR25

309DMR0581

309DMR0700

309DMR0910

309DMR1000

309DMR1010

309DMR1020

309DMR1030

309DMR1040

309DMR1050

309DMR1063

309DMR1070

309DMR1080

309DMR1090

309DMR1100

309DMR1110

309DMR1120

309DMR1130

309DMR1140

309DMR1180

309DMR1190

309DMR1210

309DMR1240

309DMR1270

309DMR1280

309DMR1310

309DMR1320

309DMR1330

309DMR1360

309DMR1380

309DMR1390

309DMR1400

309DMR1420

309DMR1450

309DMR1500

309DMR1510

309DMR3331

309DMR3332

309DMR3334

309DMR3335

309DMR4442

309DMR4443

309DMR4446

309DMR9201

309DMRPB01

309DMRPB03

309DMRPB04

309DMRPB05

309DMRPB07

309DMRPB08

309DMRPB09

309DMRPB10

309DMRPB11

309DMRPB12

309DMRPB13

309DMRPB14

309DMRPB15

309DMRPB16

309DMRPB17

309DMRPB18

309DMRPB20

309DMRPB22

DMR26

407DMR9205

407DMR9507

407DMRPB01

407DMRPB02

407DMRPB03

DMR27

438DMR0021

438DMR0071

438DMR0091

438DMR0100

438DMR0121

438DMR0160

438DMR0190

438DMR0200

438DMR0210

438DMR0220

438DMR0231

438DMR0320

438DMR0480

438DMR1220

438DMR4442

438DMR4443

438DMR4447

438DMR4448

438DMR6020

438DMR6023

438DMR6027

438DMR6029

438DMR6030

438DMR6033

438DMR6038

438DMR6039

438DMR6045

438DMR6051

438DMR6056

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 Aug 1, 2024.