Tariff Comparison & Savings Dashboard
This lesson is part of the course
In this lesson
You price twelve months of consumption on three tariffs with one formula, pick the cheapest, calculate the saving and highlight the winner of every month.
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