From: Andy Peters

Sent: Wed Jul 21 13:23:20 2021

To: Ginger Harville

Cc: Gerald Fisher; Dan Huff; Chaunee Seifried; Ryan Hepler

Subject: RE: Confirming Water Curtailment Baseline

Importance: Normal

Attachments: image001.png; image002.jpg;

Ginger, I found the missing water use. The Caselle Baseline Report has a simple bug, they are not picking up the meter use on Retired Water Meters that got swapped out during the period. Excluding these, I get the same total usage as you did in Caselle’s Report. This means 32,773 cubic feet moved through these meters in June, but they aren’t counted in Caselles report. That solves the mystery for us. The correct number for water use figure, then, is indeed 4,192,242 cubic feet for June. Which makes our true Total Water Loss less, and is in our favor. It DOES appear that these usages were billed for.

Andy

select MeterID, c.ServiceAddress, StatusCode, Usage1, a.Date UsageReadOnDate from [UM0_MolallaOR].[dbo].[tblMeterActivity] a

inner join [UM0_MolallaOR].[dbo].[tblMeter] b on a.tblMeterID = b.ID

inner join [UM0_MolallaOR].[dbo].[tblLocation] c on a.tblLocationID = c.ID

where usage1 > 0 and a.Date>= '2021-06-01' and a.Date<='2021-06-30' and b.StatusCode<>'Active'

select sum(usage1) from [UM0_MolallaOR].[dbo].[tblMeterActivity] a

inner join [UM0_MolallaOR].[dbo].[tblMeter] b on a.tblMeterID = b.ID

inner join [UM0_MolallaOR].[dbo].[tblLocation] c on a.tblLocationID = c.ID

where usage1 > 0 and Date>= '2021-06-01' and Date<='2021-06-30' and b.StatusCode<>'Active'

From: Andy Peters

Sent: Wednesday, July 21, 2021 9:23 AM

To: Ginger Harville <gharville@cityofmolalla.com>

Subject: RE: Confirming Water Curtailment Baseline

select sum(usage1) from [UM0_MolallaOR].[dbo].[tblMeterActivity] a

inner join [UM0_MolallaOR].[dbo].[tblLocation] b on a.tblLocationID = b.ID

where usage1 > 0 and Date>= '2021-06-01' and Date<='2021-06-30'

From: Andy Peters

Sent: Wednesday, July 21, 2021 9:14 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: RE: Confirming Water Curtailment Baseline

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

rhepler@cityofmolalla.com

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

apeters@cityofmolalla.com

117 N Molalla Ave

Molalla, OR 97038