Lisa F. in Arlington, TX. I'm working with several clients who are considering switching from standard rates to time-of-use schedules with Oncor. Does anyone have a good Excel template that can model the differences? Looking for something that handles demand charges in different time periods and the complex energy blocks.
Excel models for comparing TOU vs Standard rates?
Jennifer R. from Sacramento. I built one for PG&E's Schedule A-6 that might work as a starting point. Key is setting up separate columns for on-peak, part-peak, and off-peak kWh, then using VLOOKUP tables for the tiered pricing. The demand charge timing is trickier - you need 15-minute interval data to get accurate peak demand in each time period.
Derek O. in Charlotte here. Duke Energy's TOU-GSD has some quirky rules about minimum demand charges that caught me off guard. Make sure your model accounts for ratchet provisions - some months the demand charge is based on 80% of the highest demand in the past 12 months rather than actual monthly peak.
Good point Derek. Texas has some of those ratchet rules too. Jennifer, do you mind sharing your template structure? I'm particularly struggling with how to handle the seasonal rate changes - Oncor switches pricing tiers in June and September.