Okay thank you. In the raw Meter Usage Data table in Caselle shows 4,192,242 cubic feet (31,357,970 gallons) of Metered Usage, which means this baseline report supplied by Caselle is missing 107,270 gallons that passed through meters. I expect it has to do with the report Criteria: “customer.final bill is null”, which will clip off any Metered Usage record where the account closed out during the period. There are implications to that slippage for both billing and water audit, but it’s probably a rabbit hole that is not necessary to explore at this time. Agreed? Instead, we can interpret this baseline report as introducing a +/- 0.2% error into our Final Water Audit numbers (that’s the difference between using this Reports numbers, and the raw Meter Data table numbers to run the audit).
Thanks,
Andy
From: Ginger Harville <gharville@cityofmolalla.com>
Sent: Tuesday, July 20, 2021 1:13 PM
To: Ryan Hepler <rhepler@cityofmolalla.com>; Andy Peters <apeters@cityofmolalla.com>
Cc: Chaunee Seifried <cseifried@cityofmolalla.com>; Gerald Fisher <gfisher@cityofmolalla.com>; Dan Huff <dhuff@cityofmolalla.com>
Subject: RE: Confirming Water Curtailment Baseline
Attached is the Water Usage report from Caselle for 6/1-30/2021 showing 4,166,760 cubic feet (31,250,700 gallons).
Ginger Harville
Utility Billing | City of Molalla
117 N Molalla Ave. | PO Box 248 |Molalla, OR 97038
Office: 503.829.6855
CONFIDENTIALITY NOTICE: The information contained in this email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient and have received this communication in error, please contact the sender by reply email and destroy all copies of the original message. Thank you.
From: Ryan Hepler <rhepler@cityofmolalla.com>
Sent: Thursday, July 15, 2021 12:00 PM
To: Andy Peters <apeters@cityofmolalla.com>; Ginger Harville <gharville@cityofmolalla.com>
Cc: Chaunee Seifried <cseifried@cityofmolalla.com>; Gerald Fisher <gfisher@cityofmolalla.com>; Dan Huff <dhuff@cityofmolalla.com>
Subject: RE: Confirming Water Curtailment Baseline
Andy,
Total flow through that meter was 39,643,000 gallons.
Ryan Hepler | Water Treatment Operator
City of Molalla
117 N Molalla Ave. | PO Box 248 |Molalla, OR 97038
Office: 503.829.5408 I Fax: 503.829.3676
CONFIDENTIALITY NOTICE: The information contained in this email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient and have received this communication in error, please contact the sender by reply email and destroy all copies of the original message. Thank you.
From: Andy Peters <apeters@cityofmolalla.com>
Sent: Thursday, July 15, 2021 11:57 AM
To: Ginger Harville <gharville@cityofmolalla.com>; Ryan Hepler <rhepler@cityofmolalla.com>
Cc: Chaunee Seifried <cseifried@cityofmolalla.com>; Gerald Fisher <gfisher@cityofmolalla.com>; Dan Huff <dhuff@cityofmolalla.com>
Subject: Confirming Water Curtailment Baseline
Ginger can you please confirm the total metered usage from June 1-30, 2021 shown in Caselle? I show 31,360,150 gallons. Also will you please add in the notes for Hydrant Meter 14903376 that Carter is working for the ODOT ADA RAMP Project.
Ryan, can you please confirm total production (through Totalizer Meter) from your spreadsheet for June? I show: 36,771,318 gallons.
This will calibrate us for monitoring going forward.
Respectfully,
Andy Peters
City of Molalla
Public Works Operations Supervisor
(503) 829-6855 x220
Cell: 503-793-0507
117 N Molalla Ave
Molalla, OR 97038