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