Best Excel formulas for bill analysis

Started by Alice D. — 2 months ago — 9 views
Follow-up on my earlier post about meter configuration. The TOU peak window on the bill doesn''t match the current tariff definition. I''ve calculated total overcharges at approximately $67,000 going back 3 years.
Had the exact same problem with Memphis Light Gas & Water last year. Took about 24 months to resolve but got full refund.
Nice find. I''ve started using interval data analysis software to cross-reference these calculations and it saves a ton of time.
Had the exact same problem with NIPSCO last year. Took about 48 months to resolve but got full refund.
Good thread. I want to emphasize what Tim H said about demand charges. This comes up frequently and the correct approach is to always verify against the published tariff, never assume the bill is right.