Time of Use pricing

Example model

Description: Electricity demand and generation is not constant, varying by time of day and season. For example, solar panels generate only when the sun is out, and demand drops in the wee morning hours when most people are sleeping. Time-of-use pricing is a rate tariff model used by utility companies that changes more during times when demand tends to exceed supply. This model import actual usage data from a spreadsheet obtained from NationalGridUS.com of historic average customer usage, uses that to project average future demand, and then calculates the time-of-use component of PG&E's TOU-C and TOU-D tariffs. (Note: The historical data came from Massachussets, the rate plan is from California, but these are used as examples). Developed during a User Group Webinar on 30-Sep-2020, which you can watch as well to see it built.

Keywords: Reading from spreadsheets, Time-of-use pricing, Electricity pricing.

Download: You need both the model Time of use pricing.ana and the accompanying spreadsheet MECOLS0620.xlsx (original source of spreadsheet, on 9-Sep-2020, was: Massachusetts - Class Average Load Shapes (.xlsx)

Author: Lonnie Chrisman

Video: Time of use pricing.mp4