I'm trying to build an Excel model to compare Oncor's TOU-GSD-A schedule versus the standard GS-2 rate for a client in Plano. Anyone have a template that handles the time-of-use periods and seasonal differences? The summer on-peak hours are brutal here. - Lisa B.
Excel model for comparing TOU rates - anyone have a template?
Lisa, I built one for Oklahoma but the concepts should transfer. Key is getting the hourly interval data from the utility and mapping it correctly to the TOU periods. Summer on-peak in Texas is usually 1-7 PM weekdays if I remember right. You need separate columns for each time period rate. - Steve B.
Steve's approach works great. I've done tons of these for CPS Energy here in San Antonio. The tricky part is handling the seasonal transitions and making sure you're using the right effective dates. Texas summer rates kick in May 1st through October 31st usually. Also watch for those fuel adjustment clauses that change monthly. - Angela R.
Angela knows her stuff - we work different parts of San Antonio. One thing to watch on Oncor territory is they have different TOU periods than the REP energy charges. You've got transmission/distribution charges from Oncor following their schedule, then the energy supplier has their own TOU structure. It gets messy. - Carlos R.
Great points everyone. Lisa, the key elements your model needs: 1) Hourly usage data mapped to correct TOU periods, 2) Seasonal rate changes, 3) Separate calculations for T&D vs energy charges in Texas, 4) Monthly fuel adjustments, 5) Customer charges and fees. I'd suggest building separate worksheets for summer and winter calculations. Texas deregulation makes this more complex than most states. - Randy Dawson
This is all super helpful! Carlos - you're absolutely right about the Oncor vs REP complexity. I'm working with a client who has Direct Energy for supply but obviously Oncor for delivery. Going to build separate sections for each component. Thanks everyone! - Lisa B.
If anyone gets this working well, I'd love to see the approach. California TOU rates are getting crazy complex with our new time periods. PG&E just changed their peak hours again. - Lewis B.