Add Weekend Only Comparison

[jepye]

Thank you so much for writing this tool. You saved me tons of Excel wrangling.

You should add an option to only compare weekends (off peek days) to allow better comparison when you are currently optimized for a particular plan that has varying time of use charges.

For example, I am currently on the EZ-3 plan and have optimized my A/C usage for that plan with precooling and increased peak time set temperatures during weekdays. As you would expect, both your tool and SRP's say that the EZ-3 plan is best for me. A more fair comparison would be for usage that isn't optimized to your current plan.

I tried doing this by filtering my data (for a whole year) in Excel to only weekends and saved that in a new CSV and then ran your tool.
Here are the unfiltered results:

Plan Name	Total	Avg/Day	Energy	Demand	Feees	Usage
SRP::EZThree	$1,961.38	$4.94	$1,701.21	$0.00	$260.18	20805.3
SRP::MPower	$2,191.51	$5.52	$2,191.51	$0.00	$0.00	20805.3
SRP::TimeOfUse	$2,210.15	$5.57	$1,949.97	$0.00	$260.18	20805.3
SRP/E29 (Electric Vehicle)	$2,237.30	$5.64	$1,977.13	$0.00	$260.18	20805.3
SRP/E13 (TOU Solar)	$2,371.98	$5.97	$1,949.97	$0.00	$422.01	20805.3
SRP/E14 (EV Solar)	$2,399.14	$6.04	$1,977.13	$0.00	$422.01	20805.3
SRP::Basic	$2,412.52	$6.08	$2,152.34	$0.00	$260.18	20805.3
SRP/E15 (Average Demand)	$2,898.63	$7.30	$840.46	$1,636.16	$422.01	20805.3
SRP/E27 (Customer Generation)	$2,954.25	$7.44	$840.46	$1,691.78	$422.01	20805.3

And here are only the weekend days:

Plan Name	Total	Avg/Day	Energy	Demand	Feees	Usage
SRP::MPower	$654.23	$5.74	$654.23	$0.00	$0.00	6195.5
SRP/E15 (Average Demand)	$655.11	$5.75	$236.30	$0.00	$418.81	6195.5
SRP/E27 (Customer Generation)	$655.11	$5.75	$236.30	$0.00	$418.81	6195.5
SRP::TimeOfUse	$703.66	$6.17	$445.46	$0.00	$258.21	6195.5
SRP/E29 (Electric Vehicle)	$717.10	$6.29	$458.90	$0.00	$258.21	6195.5
SRP::EZThree	$762.98	$6.69	$504.77	$0.00	$258.21	6195.5
SRP/E13 (TOU Solar)	$864.27	$7.58	$445.46	$0.00	$418.81	6195.5
SRP/E14 (EV Solar)	$877.71	$7.70	$458.90	$0.00	$418.81	6195.5
SRP::Basic	$900.66	$7.90	$642.45	$0.00	$258.21	6195.5

[cheald]

It's been a while, but I recall that I considered trying to do something like this and had some trouble with it. Usage patterns kind of "are what they are", and it's particularly difficult to disentangle how much power usage is due to time-shiftable elements (such as AC) vs less controllable elements (such as a water heater). Running calculations on only off-peak days is a complete non-starter for the solar plans, as well, since the bulk of their cost is in the demand charges, which are only calculated from on-peak days.

It wouldn't be hard to add a flag to only consider off-peak days (or even hours) for the calculation, but I'm not sure how useful that would be overall. Instead, my approach is more "model actual usage and adjust from there".

It might be interesting to add a flag to simulate on-peak power reductions of X%, to permit you to experimentally model how much shifting on-peak usage could affect you, but it would be a rough guess, at best!