Hi folks,
Rather than reviving an old TOU thread, I figured this was worth starting a new one. When I was deciding to install a Level 2 EVSE, part of the process was applying for a rebate from my electric utility. One of the conditions of the rebate was to shift to a Time Of Use (TOU) rate plan. Fortunately, my utility allowed me to download my usage data for the past year, and I used that data to estimate whether a TOU plan would save money or not.
I figured the spreadsheet I created would be helpful for anyone else who might have access to their own electricity usage data, and might want to examine the impact of different TOU plans. I cleaned up the formulas and data entry a little, and figured I would share it here.
The spreadsheet is available as an Excel file here: TOU Calculator Excel
If you have a Google account, you can open it in Google Sheets and make a copy: TOU Calculator Google Sheets
The "UsageData" tab is where you can copy and paste your usage data into the white cells. It just needs date, time, and kWh used. Don't edit the grey cells - those are formulas to extract the month, day of the month, and day of the week from the date. There are 8760 rows for data (365 days x 24 hours).
![34348]( "34348")
The "Pricing" tab is where you can enter the pricing information. Rather than trying to use formulas, I just created tables with 24 rows (one for each hour). There's a table for year-round pricing, and then 2 separate tables for summer and winter pricing. You'll need to enter the start and end dates (month and day) for the summer and winter periods.
![34355]( "34355")
The "Summary" tab will take your usage data and calculate the cost based on the hour, date (whether it falls in summer or winter), and weekday or weekend status. The spreadsheet assumes the winter period covers the Dec 31st to Jan 1st transition, so the winter cost table actually adds all usage from the Winter "Start" date to Dec 31st, and from Jan 1st to the Winter "End" date.
![34356]( "34356")
Note that this spreadsheet does NOT account for delivery charges, demand charges / tiered pricing, taxes / fees, etc.
Anyway, I hope this is helpful for anyone who is considering a shift to a TOU plan from their utility. I'm open to suggestions for improvement, but I may need specific guidance on formulas, etc.
Rather than reviving an old TOU thread, I figured this was worth starting a new one. When I was deciding to install a Level 2 EVSE, part of the process was applying for a rebate from my electric utility. One of the conditions of the rebate was to shift to a Time Of Use (TOU) rate plan. Fortunately, my utility allowed me to download my usage data for the past year, and I used that data to estimate whether a TOU plan would save money or not.
I figured the spreadsheet I created would be helpful for anyone else who might have access to their own electricity usage data, and might want to examine the impact of different TOU plans. I cleaned up the formulas and data entry a little, and figured I would share it here.
The spreadsheet is available as an Excel file here: TOU Calculator Excel
If you have a Google account, you can open it in Google Sheets and make a copy: TOU Calculator Google Sheets
The "UsageData" tab is where you can copy and paste your usage data into the white cells. It just needs date, time, and kWh used. Don't edit the grey cells - those are formulas to extract the month, day of the month, and day of the week from the date. There are 8760 rows for data (365 days x 24 hours).
The "Pricing" tab is where you can enter the pricing information. Rather than trying to use formulas, I just created tables with 24 rows (one for each hour). There's a table for year-round pricing, and then 2 separate tables for summer and winter pricing. You'll need to enter the start and end dates (month and day) for the summer and winter periods.
The "Summary" tab will take your usage data and calculate the cost based on the hour, date (whether it falls in summer or winter), and weekday or weekend status. The spreadsheet assumes the winter period covers the Dec 31st to Jan 1st transition, so the winter cost table actually adds all usage from the Winter "Start" date to Dec 31st, and from Jan 1st to the Winter "End" date.
Note that this spreadsheet does NOT account for delivery charges, demand charges / tiered pricing, taxes / fees, etc.
Anyway, I hope this is helpful for anyone who is considering a shift to a TOU plan from their utility. I'm open to suggestions for improvement, but I may need specific guidance on formulas, etc.
