From: Gerald Fisher
Sent: Wed Jul 21 14:20:18 2021
To: Andy Peters; Ginger Harville; Dan Huff
Cc: Chaunee Seifried; Ryan Hepler
Subject: RE: Confirming Water Curtailment Baseline
Importance: Normal
Attachments: image001.png; image002.jpg; K. That seals it. Andy gets a Rockstar can for his shelf. Regards, Gerald Fisher, P.E. | Public Works Director City of Molalla 117 N Molalla Ave. | PO Box 248 |Molalla, OR 97038 Office: 503.829.6855 | Direct: 503.759.0218 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: Wednesday, July 21, 2021 2:18 PM To: Ginger Harville <gharville@cityofmolalla.com>; Dan Huff <dhuff@cityofmolalla.com> Cc: Gerald Fisher <gfisher@cityofmolalla.com>; Chaunee Seifried <cseifried@cityofmolalla.com>; Ryan Hepler <rhepler@cityofmolalla.com> Subject: Re: Confirming Water Curtailment Baseline Except for the fact that almost as soon as I sent this Ginger and I began to see even more questions underneath.... but we will eventually get it... If anything good comes out of water curtail this year it will be perfect system knowledge In the City of Molalla. Andy Sent from my Verizon, Samsung Galaxy smartphone
From: Dan Huff <dhuff@cityofmolalla.com>
Sent: Wednesday, July 21, 2021 1:41:30 PM
To: Andy Peters <apeters@cityofmolalla.com>; Ginger Harville <gharville@cityofmolalla.com>
Cc: Gerald Fisher <gfisher@cityofmolalla.com>; Chaunee Seifried <cseifried@cityofmolalla.com>; Ryan Hepler <rhepler@cityofmolalla.com>
Subject: RE: Confirming Water Curtailment Baseline
I am convinced the when you combine a problem with numbers you get an Andy!
From: Andy Peters <apeters@cityofmolalla.com>
Sent: Wednesday, July 21, 2021 1:23 PM
To: Ginger Harville <gharville@cityofmolalla.com>
Cc: Gerald Fisher <gfisher@cityofmolalla.com>; Dan Huff <dhuff@cityofmolalla.com>; Chaunee Seifried <cseifried@cityofmolalla.com>; Ryan Hepler <rhepler@cityofmolalla.com>
Subject: RE: Confirming Water Curtailment Baseline
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
MeterID
| ServiceAddress
| StatusCode
| Usage1
| UsageReadOnDate
|
33146193
| 102 S LEROY AVENUE
| Retired
| 1586.00
| 6/24/2021
|
33146261
| 102 TOLIVER COURT
| Retired
| 748.00
| 6/24/2021
|
33887739
| 1039 MT VIEW LANE
| Retired
| 3312.00
| 6/23/2021
|
48116234
| 113 S MOLALLA AVENUE
| Retired
| 147.00
| 6/24/2021
|
44098523
| 123 S MOLALLA AVENUE
| Retired
| 764.00
| 6/4/2021
|
44098523
| 123 S MOLALLA AVENUE
| Retired
| 1437.00
| 6/24/2021
|
33146212
| 155 THUNDERBIRD ST
| Retired
| 340.00
| 6/24/2021
|
33146217
| 160 GLORY LN
| Retired
| 1041.00
| 6/23/2021
|
33146202
| 169 FENTON AVENUE
| Retired
| 1704.00
| 6/24/2021
|
33146272
| 2 BERWICK COURT
| Retired
| 1057.00
| 6/24/2021
|
33146256
| 235 TAURUS ST
| Retired
| 138.00
| 6/24/2021
|
33146243
| 255 PROBE ST
| Retired
| 1569.00
| 6/24/2021
|
33146269
| 260 THUNDERBIRD STREET
| Retired
| 1174.00
| 6/24/2021
|
33146259
| 265 THUNDERBIRD ST
| Retired
| 1757.00
| 6/24/2021
|
33146258
| 275 THUNDERBIRD ST
| Retired
| 537.00
| 6/23/2021
|
33309028
| 314 TOLIVER ROAD
| Retired
| 350.00
| 6/24/2021
|
33146219
| 331 CHINOOK STREET
| Retired
| 734.00
| 6/24/2021
|
36543026
| 332 STEELHEAD STREET
| Retired
| 1602.00
| 6/23/2021
|
33146277
| 5 REVILOT COURT
| Retired
| 449.00
| 6/24/2021
|
40315521
| 536 HART AVENUE
| Retired
| 345.00
| 6/24/2021
|
33146241
| 601 KIMBERLY COURT
| Retired
| 164.00
| 6/24/2021
|
33309043
| 611 CORRAL COURT
| Retired
| 428.00
| 6/24/2021
|
33146265
| 614 TOLIVER DRIVE
| Retired
| 754.00
| 6/24/2021
|
33146239
| 617 KIMBERLY COURT
| Retired
| 731.00
| 6/24/2021
|
33146238
| 621 KIMBERLY COURT
| Retired
| 1240.00
| 6/24/2021
|
33309046
| 665 LAKOTA LANE
| Retired
| 1203.00
| 6/24/2021
|
33146200
| 704 W MAIN STREET
| Retired
| 947.00
| 6/24/2021
|
190250327
| 722 ERIC DRIVE
| Retired
| 1488.00
| 6/24/2021
|
33146213
| 835 BRONCO AVE
| Retired
| 632.00
| 6/24/2021
|
33309051
| 865 BRONCO AVE
| Retired
| 1026.00
| 6/23/2021
|
33146226
| 911 COHO ST
| Retired
| 1249.00
| 6/24/2021
|
33146225
| 916 COHO STREET
| Retired
| 128.00
| 6/24/2021
|
33146190
| 931 W MAIN STREET
| Retired
| 1992.00
| 6/24/2021 |
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
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