ADVANCED ENERGY AUDITING

A. TARGET STUDENT:

Target student: Senior or junior energy auditor that needs to develop necessary analytical skills to calculate energy savings for energy conservation measures in large commercial and institutional facilities.

B. DESCRIPTION:

The course will cover MS Excel data manipulation and analyses techniques that are necessary to calculate energy savings acceptable to utilities for a wide variety of energy conservation measures (Envelope, Service Hot Water, Water systems, Air systems, Motors, VFDs, HVAC, Fans, Pumps, Chillers, Cooling Towers, Boilers, etc.). Detailed analyses of weather data and utility billing data, including interval data, will be included. VBA macros will be provided and developed in class. Simple analysis techniques (such as using degree days) will be reviewed, as well as detailed bin tables using regression analyses, 8,760-hour analyses and other advance techniques. Each student will need to be at a computer with Excel loaded (Excel 2010 or higher is necessary to take full advantage of the class. This class dovetails into Basic Energy Auditing, where energy using equipment, systems and energy conservation measures are discussed in detail.

C. ORGANIZATION:

The advanced class will go over detailed energy savings analyses used for ASHRAE level 2 and 3 audits (level 2 is a “Technical Audit” and level 3 is an “Investment-grade audit”). Many aspects of Excel-based calculations will be reviewed including detailed analysis of utility interval data, utility billing data, field-installed logger data, weather and scheduling data, equipment performance, system capacity, and many other aspects of energy-using systems.

D. COURSE OBJECTIVES

  1. To train students to use basic and advanced Excel techniques to review, troubleshoot, correct and interpret utility provided usage data, logger collected data and NOAA weather data.
  2. To instruct students how to develop methods and equations to calculate energy savings for many different equipment/systems/processes and associated energy conservation measure (ECM) analyses.
  3. To provide students with a host of essential “go to“ references, resource data and Excel routines.

E. TEXT AND REQUIRED SUPPLIES:

All information will be provided in class and sent electronically

F. GRADING PLAN:

The class is a non-credit class. However, CEUs (continuing education units) and/or PDHs (professional development hours) will be provided for attendance and completion of quizzes. Each class session counts for 0.2 CEUs or 2 PDHs.

ADVANCED ENERGY AUDITING

A. TARGET STUDENT:Target student: Senior or junior energy auditor that needs to develop necessary analytical skills to calculate energy savings for energy conservation measures in large commercial and institutional facilities.

B. DESCRIPTION:The course will cover MS Excel data manipulation and analyses techniques that are necessary to calculate energy savings acceptable to utilities for a wide variety of energy conservation measures (Envelope, Service Hot Water, Water systems, Air systems, Motors, VFDs, HVAC, Fans, Pumps, Chillers, Cooling Towers, Boilers, etc.). Detailed analyses of weather data and utility billing data, including interval data, will be included. VBA macros will be provided and developed in class. Simple analysis techniques (such as using degree days) will be reviewed, as well as detailed bin tables using regression analyses, 8,760-hour analyses and other advance techniques. Each student will need to be at a computer with Excel loaded (Excel 2010 or higher is necessary to take full advantage of the class. This class dovetails into Basic Energy Auditing, where energy using equipment, systems and energy conservation measures are discussed in detail.

C. ORGANIZATION:The advanced class will go over detailed energy savings analyses used for ASHRAE level 2 and 3 audits (level 2 is a “Technical Audit” and level 3 is an “Investment-grade audit”). Many aspects of Excel-based calculations will be reviewed including detailed analysis of utility interval data, utility billing data, field-installed logger data, weather and scheduling data, equipment performance, system capacity, and many other aspects of energy-using systems.

D. COURSE OBJECTIVES

  1. To train students to use basic and advanced Excel techniques to review, troubleshoot, correct and interpret utility provided usage data, logger collected data and NOAA weather data.
  2. To instruct students how to develop methods and equations to calculate energy savings for many different equipment/systems/processes and associated energy conservation measure (ECM) analyses.
  3. To provide students with a host of essential “go to“ references, resource data and Excel routines.

E. TEXT AND REQUIRED SUPPLIES:All information will be provided in class and sent electronically

F. GRADING PLAN:The class is a non-credit class. However, CEUs (continuing education units) and/or PDHs (professional development hours) will be provided for attendance and completion of quizzes. Each class session counts for 0.2 CEUs or 2 PDHs.

G. CLASSES:Classes will be held using the GoToMeeting app (there is no need to purchase this app.)
The next class will start on Tuesday, September 13th, 2022 and run from 3:30 to 5:30 Eastern time (Boston / New York). The course will held weekly at the same time for 14 sessions.

H. COST:The cost for the Advanced Energy Auditing class is currently $880. Call, or email Jim Guertin to sign up or respond on the web site via the Contact Us page. Credit cards are accepted and a 5% discount is applied for more than one student from your organization that signs up.