Looking for a Southern California Edison rate calculator

[Majebright]

Hi everyone,
I'm looking for a calculator to identify which SCE rate is the most interesting financially. It's mostly to compare the tiered-rate schedule D to the TOU rate. Does anyone know if such a tool is available?
Thank you!

[J.P.M.]

I believe some member(s) have some stuff. I also believe you will either need to have or be able to estimate your hourly use patterns over a typical year for a decent and semi reliable T.O.U. bill estimate.

[Majebright]

Thank you J.P.M for your help. Yes, I have the last bills for the past 12 months at least so I know the monthly usage and price. If anyone has heard of a reliable tool, that would be very helpful. Thanks!

[sensij]

You'll need to log in to your SCE account online and look for the "Green Button Data" to get your consumption reported in 15 min intervals. That is enough resolution for TOU evaluation. I have a decent (somewhat complicated) spreadsheet that I haven't updated in a few months... if you strip your personal information off your downloaded consumption data and share it (Dropbox?), I'll put it into the sheet correctly and send it to you.