Oz F. from Lexington. Does anyone have a good Excel template for comparing time-of-use rates against standard rates? I'm working with Kentucky Utilities and they have a TOU-GSD option that looks promising for some customers but manually calculating the savings across different time periods is tedious. Looking for something that can handle multiple rate schedules and different load profiles.
Excel model for comparing TOU vs standard rates?
Karen W. from Charlotte here. I built one a few years ago for Duke Energy comparisons. The key is setting up your time periods correctly - peak, off-peak, and shoulder if applicable. I use conditional formulas that multiply each hour's usage by the appropriate rate based on time and season. Happy to share the basic structure if you're interested. It handles up to 5 different rate schedules for comparison.
Karen, that would be incredibly helpful! I'm particularly struggling with Kentucky Utilities' seasonal variations. They have different TOU periods for summer vs winter and the shoulder period rates change too. Do you account for demand charges in your model as well or just energy charges?