PGE - Energy Audit Skills: Tools, Data Collection Techniques, & Calculations

Friday, June 8, 2012 - 8:30am to 4:30pm


Also Offered March 23 (Friday, 8:30 am to 4:30 pm) San Francisco--PEC
April 18 (Wednesday, 8:30 am to 4:30 pm) Auburn--Holiday Inn
June 19 (Tuesday, 8:30 am to 4:30 pm) Stockton--ETC

This one-day program serves as a hands-on follow-up to the PEC's 3-day Energy Auditing Techniques for Small and Medium Commercial Facilities class. The one-day program focuses on energy and cost calculations, data collection, and monitoring equipment. This training allows attendees to develop several specific energy reduction projects from conception to financial benefit analysis. Most of the in-class calculations are done in Microsoft Excel, and we provide laptops for students. We encourage attendees to bring their own laptops to class, and we will distribute the required files before the class begins. As noted below, all attendees for this program must first attend the 3-day Energy Auditing class and be proficient in MS Excel. 

Prerequisites: (1) Attendance at a PG&E three-day Energy Auditing Techniques for Small and Medium Commercial Facilities class is MANDATORY. We will drop students from the final roster who have not completed the three-day class. 

(2) Proficiency in Microsoft Excel. Students without the necessary skill level should not sign up for the Audit Skills class. Instructors will not furnish basic Excel support during class and may ask a student to leave the class if the student's Excel skills are inadequate. We are providing a "test" spreadsheet that illustrates the Excel skills required of anyone registering for the Audit Skills class. You should be able to take the "raw data" and create the "final data" worksheet and the chart in this sample spreadsheet. The spreadsheet includes an explanation of what you need to be able to do in the TAB labeled "demo-spreadsheet." If you are unable to complete this practice exercise, please consider sharpening your Excel skills and enrolling in the 1-day advanced Audit Skills class at another time. We will offer more Audit Skills classes in Spring 2010. Link to the test Excel spreadsheet.

Audience Level Intended for introductory-level attendees. Attendance at a PG&E 3-day Energy Auditing Techniques class is MANDATORY. Students must be proficient in MS Excel as demonstrated by completion of a sample spreadsheet (see class description).
  • 8:30 a.m. Safety announcements, introductions, and class overview
  • 8:40 a.m. Overview of concepts, terms, and efficiencies
  • 9:15 a.m. Lab #1: Collecting field data
  • 10:00 a.m. Energy saving calculations review with examples
  • 10:30 a.m. Billing data analysis and normalization
  • 11:00 a.m. Lab #2: Energy saving and billing calculations
  • 11:30 a.m. Financial saving calculation review with examples
  • 12:00 p.m. Lunch break
  • 1:00 p.m. Lab #3: Financial saving calculations
  • 1:30 p.m. Datalogger overview
  • 2:00 p.m. Temperature logger applications
  • 2:30 p.m. Lighting controls and lighting loggers
  • 2:50 p.m. Motor loggers and scheduling operation
  • 3:00 p.m. Lab #4: Launching data loggers
  • 3:15 p.m. Lab #5: Installing data loggers
  • 3:30 p.m. Lab #6: Downloading loggers and graphing data
  • 4:00 p.m. Top 10 non-retrofit audit findings
  • 4:20 p.m. Wrap-up, Q&A, Post-course evaluation
  • 4:30 p.m. Class adjourns

Ryan Stroupe

Ryan Stroupe is the Pacific Energy Center's Whole Building Performance Program Coordinator. He worked as the contact for the Center's Tool Lending Library program for several years and continues to support this program in an advisory role. Ryan also supports shading, daylighting, and other studies for architects and designers interested in optimizing the performance of their built projects. He develops and teaches many of the Energy Center's architectural and whole building performance programs. Ryan also teaches for The California College of the Arts and The Academy of Art University. He is currently supporting the monitoring-based commissioning efforts occurring at the University of California and California State University campuses. Ryan is a product of the Bachelor's of Environmental Design program at Miami University in Ohio and the Master's of Architecture Program at University of California, Berkeley.
Resources N/A
Cost No fee for this program


Click here for more information and to register.

San Francisco--PEC