Had an embarrassing situation last month where I submitted a report with a major calculation error - mixed up peak vs off-peak rates and overstated savings by $40K. Client caught it before presenting to utility thankfully. What QC steps do others use to catch these kinds of mistakes before reports go out?
Quality control checklist before submitting reports
Sarah - we've all been there! I have a standard checklist: 1) Recalculate all dollar amounts independently, 2) Verify rate schedules match tariff sheets, 3) Double-check all demand multipliers and CT ratios, 4) Cross-foot all summary tables, 5) Have someone else review calculations if possible. The peer review step catches 90% of errors.
Good list Marie. I also always do a "reasonableness test" - does the claimed savings make sense as a percentage of total bill? If I'm claiming 15%+ savings on a well-managed account, that's a red flag to double-check everything. Most legitimate errors result in 2-8% bill reductions.
I keep a separate spreadsheet that recalculates key bills using my corrected methodology. If my "corrected" bills don't match what the utility actually billed (except for the errors I found), then I know I've misunderstood something. Helps catch interpretation errors before they become report errors.
Always verify your rate schedule interpretation against a recent utility bill that shows the calculation breakdown. Some utilities provide detailed calculation sheets that show exactly how they applied each rate component. Use those as your template for recalculating other periods.
One more check - make sure your error description actually matches the numbers. I've seen reports claiming "incorrect demand billing" but the math shows it was actually a rate schedule issue. The utility will catch inconsistencies like that immediately and it undermines your credibility.
All great suggestions. I also recommend keeping a "lessons learned" file with your past mistakes and how to avoid them. After 5 years of auditing I still reference mine regularly. Sarah, don't beat yourself up - we learn more from mistakes than successes sometimes.