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.