Time of Use pricing

Revision as of 19:43, 3 November 2026 by Mhenrion (talk | contribs) (Description no longer starts with the model name (it is the page title))
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)


Type: Model example, Extra

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.

Video: Time of use pricing.mp4

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

Keywords: Data import and cleaning, Energy and electricity, Time series, Reading from spreadsheets, Time-of-use pricing, Electricity pricing

See Also

Comments
Loading comments...