SESSION 1: 2 hours

Introduction to Smart Metering and Interval Data
• Electricity Metering 101
• Who's pushing smart metering, and why
• Smart meters and electric rates
• What is a load profile?
• Interval data: what it is and isn't
• Excel charts we will use on your PC

Power Usage Patterns and Their Impacts
• Monthly, daily and hourly profiles
• Load factor can't tell time
• Load factor vs. power pricing
• Ways to cut peak demand
• Wholesale pricing and capacity impacts

'Smart' Metering, Data Handling, Logging
• Accessing interval data
• Metering publications and resources
• Data acquisition systems
• Accessing and correlating weather data
• Paying for metering hardware and software
• Lessons learned

SESSION 2: 2 hours

Turning Numbers Into Pictures
• Why two dimensions are not enough
• 3D load Landscapes and Slices
• Formatting interval data for Excel
• Using macros to simplify the job
• Choosing and charting a single Slice

Understanding What We See in 3D Profiles
• Summary of analysis steps
• Examples of problems found and fixed
• Tips for anomaly analysis
• Analyzing 10 examples using 3D load profiles
• Correlating usage with hourly temperature data

SESSION 3: 2 hours

Enhancing Charts To Highlight Issues
• Changing and highlighting chart features
• Focusing on details and anomalies
• Making peaks stand out
• Revealing days of the week in data/charts
• Improving shape, orientation, colors & lines

Finding and Setting a Peak Demand Goal
• Using the load duration curve macro
• Understanding and using load duration curves
• Zeroing in on highest peaks and when they occur
• Determining their causes

Demand Response (DR) and Time-Of-Use (TOU) Options
• Who pays you to cut peak load, and why?
• Overview of DR contracts
• Choosing a DR provider, or going it alone
• Auditing loads to cut
• Putting your generator to work
• Using the TOU template to model cost
• Lessons learned