Daily Load Profiles: Average kW by Hour with AVERAGEIFS (and a Chart)
This lesson is part of the course
In this lesson
You turn 192 readings (Friday and Saturday) into an hourly load profile per day type, find the peak hour and chart both profiles.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- kW vs kWh: Turning 15-Minute Meter Readings into Energy Locked
- Daily Load Profiles: Average kW by Hour with AVERAGEIFS (and a Chart) Locked
- Peak Demand & Load Factor: How Peaky Is the Load? Locked
- Time-of-Use Tariff: Pricing Every Hour with an Approximate Lookup Locked
- Demand Charges & Peak Shaving: What a Lower Peak Saves Locked
- Baseload vs Variable Load: What Runs When Nobody Is There? Locked
- Weather Normalisation with Degree Days: SLOPE, INTERCEPT & a Scatter Chart Locked
- Tariff Comparison & Savings Dashboard Locked