TOU Rate Management and Filtering for Tesla Charging Data
I would like the ability to set and store TOU rates for various time periods and holidays, making the data more accurate without having to manually update the rates every time they change. This feature would allow me to retroactively correct historical data based on rate changes or seasonal shifts, ensuring consistency and accuracy.
Features:
1. TOU Rate Storage: The ability to store multiple TOU rates for different time periods, seasonal changes, or holidays. For example, rates could be entered for each year or season (e.g., summer, winter) from November 2019 to the present.
2. Historical Data Adjustment: When TOU rates are changed or edited retroactively, the historical data would automatically update to reflect these new rates, ensuring that past data is accurate based on the correct rate at the time of charging.
3. Charging Data Filter: It would be helpful to have a filter to split and view charging data according to TOU rates, without altering the raw data. For example:
- Charge 1 (November 2, 2019 from 4:30 pm to 8:00 pm):
- 4:30 pm - 5:00 pm (Mid-peak rate): Charging data displayed for this period.
- 5:00 pm - 7:00 pm (On-peak rate): Charging data displayed for this period.
- 7:00 pm - 8:00 pm (Off-peak rate): Charging data displayed for this period.
This breakdown would allow me to accurately account for electricity usage in different TOU periods, making it easier to deduct Tesla usage from my home electricity bill for tax purposes as a self-employed individual. It would also streamline the process of exporting and analyzing charging data by rate and time period, reducing manual work.
November 1, 2019 to April 30, 2020 March 23, 2020 (Winter TOU Rates) - Cut off due to COVID
Off-peak 7pm-7am at $0.101 per kWh
On-peak 7am-11am & 5pm-7pm at $0.208 per kWh
Mid-peak 11am-5pm at $0.144 per kWh
Weekend & Holidays 24 hours at $0.101 per kWh
March 24, 2020 to May 31, 2020 (COVID Rate Change)
Everyday 24 hours at $0.101 per kWh
June 1, 2020 to October 31, 2020 (Second COVID Rate Change)
Everyday 24 hours at $0.128 per kWh
November 1, 2020 to April 30, 2021 December 31, 2020 (Winter TOU Rates) - Cut off due to COVID Wave
Off-peak 7pm-7am at $0.105 per kWh
On-peak 7am-11am & 5pm-7pm at $0.217 per kWh
Mid-peak 11am-5pm at $0.150 per kWh
Weekend & Holidays 24 hours at $0.105 per kWh
January 1, 2021 to February 22, 2021 (Third COVID Rate Change)
Everyday 24 hours at $0.085 per kWh
February 23, 2021 to April 30, 2021 (Resume Winter TOU Rates)
Off-peak 7pm-7am at $0.085 per kWh
On-peak 7am-11am & 5pm-7pm at $0.176 per kWh
Mid-peak 11am-5pm at $0.119 per kWh
Weekend & Holidays 24 hours at $0.085 per kWh
May 1, 2021 to October 31, 2021 (Summer TOU Rates)
Off-peak 7pm-7am at $0.082 per kWh
On-peak 11am-5pm at $0.170 per kWh
Mid-peak 7am-11am & 5pm-7pm at $0.113 per kWh
Weekend & Holidays 24 hours at $0.082 per kWh
November 1, 2021 to April 30, 2022 January 17, 2022 (Winter TOU Rates) - Cut off due to COVID Wave
Off-peak 7pm-7am at $0.082 per kWh
On-peak 7am-11am & 5pm-7pm at $0.170 per kWh
Mid-peak 11am-5pm at $0.113 per kWh
Weekend & Holidays 24 hours at $0.082 per kWh
January 18, 2022 to February 7, 2022 (Fourth COVID Rate Change)
Everyday 24 hours at $0.082 per kWh
February 7, 2022 to April 30, 2022 (Resume Winter TOU Rates)
Off-peak 7pm-7am at $0.082 per kWh
On-peak 7am-11am & 5pm-7pm at $0.170 per kWh
Mid-peak 11am-5pm at $0.113 per kWh
Weekend & Holidays 24 hours at $0.082 per kWh
May 1, 2022 to October 31, 2022 (Summer TOU Rates)
Off-peak 7pm-7am at $0.082 per kWh
On-peak 11am-5pm at $0.170 per kWh
Mid-peak 7am-11am & 5pm-7pm at $0.113 per kWh
Weekend & Holidays 24 hours at $0.082 per kWh
Nov 1, 2022 to April 30, 2023 (Winter TOU Rates)
Off-peak 7pm-7am at $0.074 per kWh
On-peak 7am-11am & 5pm-7pm at $0.151 per kWh
Mid-peak 11am-5pm at $0.102 per kWh
Weekend & Holidays 24 hours at $0.074 per kWh
May 1, 2023 to October 31, 2023 (Summer TOU Rates)
Off-peak 7pm-7am at $0.074 per kWh
On-peak 11am-5pm at $0.151 per kWh
Mid-peak 7am-11am & 5pm-7pm at $0.102 per kWh
Weekend & Holidays 24 hours at $0.074 per kWh
Nov 1, 2023 to April 30, 2024 (Winter TOU Rates)
Off-peak 7pm-7am at $0.087 per kWh
On-peak 7am-11am & 5pm-7pm at $0.182 per kWh
Mid-peak 11am-5pm at $0.122 per kWh
Weekend & Holidays 24 hours at $0.087 per kWh
May 1, 2024 to October 31, 2024 September 28, 2024 (Summer TOU Rates)
Off-peak 7pm-7am at $0.087 per kWh
On-peak 11am-5pm at $0.182 per kWh
Mid-peak 7am-11am & 5pm-7pm at $0.122 per kWh
Weekend & Holidays 24 hours at $0.087 per kWh
September 29, 2024 to October 31, 2024 (Ultra Low Overnight)
Weekdays
Ultra Low Overnight 11pm-7am at $0.028 per kWh
Mid-peak 7am-4pm & 9pm-11pm at $0.122 per kWh
On-peak 4pm-9pm at $0.286 per kWh
Weekend & Holidays
Ultra Low Overnight 11pm-7am at $0.028 per kWh
Off-peak 7am-11pm at $0.087 per kWh
Customer support service by UserEcho