View source for Time of Use pricing

 [[Category: Examples]]
=== 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 [https://www9.nationalgridus.com/energysupply/load_estimate.asp 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 [https://www.pge.com/tariffs/assets/pdf/tariffbook/ELEC_SCHEDS_E-TOU-C.pdf TOU-C] and [https://www.pge.com/tariffs/assets/pdf/tariffbook/ELEC_SCHEDS_E-TOU-D.pdf 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 [[media:Time of use pricing.ana|Time of use pricing.ana]] and the accompanying spreadsheet [[media:MECOLS0620.xlsx|MECOLS0620.xlsx]] (original source of spreadsheet, on 9-Sep-2020, was: [https://www9.nationalgridus.com/energysupply/non_html/MECOLS0620.xlsx Massachusetts - Class Average Load Shapes (.xlsx)]

'''Author:''' Lonnie Chrisman

'''Video''': [https://webinars.analytica.com/Docs/2020-Sep-30%20Time%20of%20use%20pricing.mp4 Time of use pricing.mp4]