{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["1. Own Sources","2. VoS, WI, WE","3. AC","4. Schematic","Meter Accuracy Report","Electronic Calibration Report"],"not_rendered":{"charts":2,"images":3},"read":"whole","date_system":"1900"}

{"sheet":"1. Own Sources","index":0,"n_rows":21,"n_cols":5,"rows_kept":21,"merged":[[2,1,2,4],[17,1,17,4],[18,1,18,4],[19,1,19,4],[20,1,20,4]]}
["Example of Supporting Documentation for Volume from Own Sources"]
[]
[null,"Treatment Plant Production (UNITS = AF)"]
[null,"Month","Raw Water Influent","Backwash Estimation","Finished Water Meter"]
[null,"2019-01-01",848.89,16,{"v":830.859,"d":"830.86"}]
[null,"2019-02-01",908.28,11,{"v":897.13536,"d":"897.14"}]
[null,"2019-03-01",{"v":1058.18,"d":"1,058.18"},14,{"v":1043.53784,"d":"1,043.54"}]
[null,"2019-04-01",{"v":1125.35,"d":"1,125.35"},32,{"v":1093.5561599999999,"d":"1,093.56"}]
[null,"2019-05-01",{"v":1255.24,"d":"1,255.24"},11,{"v":1244.372,"d":"1,244.37"}]
[null,"2019-06-01",{"v":1388.7889961811486,"d":"1,388.79"},15,{"v":1373.1687161811485,"d":"1,373.17"}]
[null,"2019-07-01",{"v":1291.2572941441922,"d":"1,291.26"},11,{"v":1280.9129341441921,"d":"1,280.91"}]
[null,"2019-08-01",{"v":1189.45,"d":"1,189.45"},14,{"v":1175.1437600000002,"d":"1,175.14"}]
[null,"2019-09-01",{"v":1165.565475828459,"d":"1,165.57"},18,{"v":1147.208435828459,"d":"1,147.21"}]
[null,"2019-10-01",{"v":955.8303230184603,"d":"955.83"},12,{"v":943.5000830184603,"d":"943.50"}]
[null,"2019-11-01",882.48,15,858.34]
[null,"2019-12-01",{"v":961.4115350649352,"d":"961.41"},18,{"v":943.2224550649352,"d":"943.22"}]
[null,"Audit Total",{"$f":"SUM(C5:C16)","v":{"v":13030.723624237196,"d":"13,030.72"}},{"$f":"SUM(D5:D16)","v":187},{"$f":"SUM(E5:E16)","v":{"v":12830.956744237195,"d":"12,830.96"}}]
[null,"NOTES"]
[null,"* Raw Water Influent meter measures flow into the treatment plant, 6\" mag meter, SCADA readings provide 15-min average flows but no totalizer, used for plant operations"]
[null,"* Backwash meter measures diversion from finished water line back into the plant. This is located before the finished water meter"]
[null,"* Finished Water Meter captures treatment plant effluent conveyed into distribution. Totalizer manual reads taken daily alongside SCADA logging. "]

{"sheet":"2. VoS, WI, WE","index":1,"n_rows":24,"n_cols":12,"rows_kept":24,"merged":[[2,1,2,6],[17,1,17,5],[17,9,17,11],[18,2,18,7],[19,2,19,7],[20,2,22,7],[23,2,23,7]]}
["Example of Supporting Documentation for all Water Supplied Volumes"]
[]
[null,"Volume from Own Sources, Water Imported, Water Exported\nUNITS = MG"]
[null,"Month","Import M-1","Well 1","Well 2","Well 3","Export E-1","Monthly Distribution Totals"]
[null,"2019-01-01",202.11,{"v":5.7536,"d":"5.75"},{"v":60.5806688,"d":"60.58"},{"v":36.224328,"d":"36.22"},0,{"$f":"SUM(C5:F5)-G5","v":{"v":304.66859680000005,"d":"304.67"}}]
[null,"2019-02-01",185.45,{"v":2.0336,"d":"2.03"},{"v":37.6729088,"d":"37.67"},{"v":32.578728,"d":"32.58"},0,{"v":257.7352368,"d":"257.74"}]
[null,"2019-03-01",178.74,{"v":1.488,"d":"1.49"},{"v":34.313103999999996,"d":"34.31"},{"v":32.04404,"d":"32.04"},0,{"v":246.585144,"d":"246.59"}]
[null,"2019-04-01",171.39000000000001,0,25.15,0,5.18,191.36]
[null,"2019-05-01",{"v":123,"d":"123.00"},{"v":2.3064,"d":"2.31"},{"v":39.3528112,"d":"39.35"},{"v":32.84607200000001,"d":"32.85"},45.79,{"v":151.71528320000002,"d":"151.72"}]
[null,"2019-06-01",49.11,{"v":5.4312,"d":"5.43"},{"v":58.5953296,"d":"58.60"},{"v":35.908376,"d":"35.91"},22.46,{"v":126.58490559999998,"d":"126.58"}]
[null,"2019-07-01",31.56,{"v":34.596,"d":"34.60"},{"v":23.819,"d":"23.82"},{"v":64.48988,"d":"64.49"},0,{"v":154.46488,"d":"154.46"}]
[null,"2019-08-01",7.290000000000001,{"v":31.942400000000003,"d":"31.94"},{"v":22.195,"d":"22.20"},{"v":61.889352,"d":"61.89"},0,{"v":123.31675200000001,"d":"123.32"}]
[null,"2019-09-01",6.0600000000000005,{"v":31.2232,"d":"31.22"},{"v":21.7,"d":"21.70"},{"v":61.184536,"d":"61.18"},0,{"v":120.16773599999999,"d":"120.17"}]
[null,"2019-10-01",58.44,{"v":35.5632,"d":"35.56"},24.43,{"v":65.437736,"d":"65.44"},0,{"v":183.870936,"d":"183.87"}]
[null,"2019-11-01",170.60999999999999,0,55.48,{"v":30.5858,"d":"30.59"},0,{"v":256.6758,"d":"256.68"}]
[null,"2019-12-01",171.39000000000001,0,25.15,0,0,{"v":196.54000000000002,"d":"196.54"}]
[null,"Audit Total",{"$f":"SUM(C5:C16)","v":{"v":1355.1499999999999,"d":"1,355.15"}},{"$f":"SUM(D5:D16)","v":{"v":150.33759999999998,"d":"150.34"}},{"$f":"SUM(E5:E16)","v":{"v":428.4388224,"d":"428.44"}},{"$f":"SUM(F5:F16)","v":{"v":453.18884799999995,"d":"453.19"}},73.43,{"$f":"SUM(H5:H16)","v":{"v":2313.6852704000003,"d":"2313.69"}}]
[{"$nulls":9},"Water Audit Software Totals"]
[null,"Source","Notes",{"$nulls":6},"Volume from Own Sources:",{"$f":"SUM(D17:F17)","v":{"v":1031.9652704,"d":"1,031.97"}},"MG"]
[null,"Import M-1","All  imported water comes through M-1, billed amounts shown here, hourly SCADA reads available for cross-reference, bi-annual calibration, no testing",{"$nulls":6},"Water Imported:",{"$f":"C17","v":{"v":1355.1499999999999,"d":"1,355.15"}},"MG"]
[null,"Well 1","Each well pump has a 6\" mag meter that's electronically calibrated once per year, all installed in 2013, daily manual reads and weekly compilation of well production data",{"$nulls":6},"Water Exported:",{"$f":"G17","v":73.43},"MG"]
[null,"Well 2"]
[null,"Well 3"]
[null,"Export E-1","Flow provided to neighboring agency in the fall/winter when needed"]

{"sheet":"3. AC","index":2,"n_rows":22,"n_cols":15,"rows_kept":22,"merged":[[3,1,3,13],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3]]}
["Example of Supporting Documentation for Billed Metered Authorized Consumption"]
[]
[]
[null,"Water Sold, UNITS = MG"]
[null,"Month","2019-01-01","2019-02-01","2019-03-01","2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","2019 TOTAL"]
[null,"Single Family Residential",38.42,28.18,42.15,47.77,48.99,52.18,59.73,51.48,42.54,41.15,32.15,34.45,{"$f":"SUM(C6:N6)","v":519.19}]
[null,"Multi Family Residential",{"v":18.535999999999998,"d":"18.54"},{"v":17.836,"d":"17.84"},{"v":18.487,"d":"18.49"},{"v":17.653999999999996,"d":"17.65"},{"v":19.285,"d":"19.29"},{"v":21.336,"d":"21.34"},{"v":24.367,"d":"24.37"},{"v":19.894,"d":"19.89"},{"v":19.684,"d":"19.68"},{"v":16.898,"d":"16.90"},{"v":15.525999999999998,"d":"15.53"},{"v":15.014999999999999,"d":"15.02"},{"$f":"SUM(C7:N7)","v":{"v":224.51799999999997,"d":"224.52"}}]
[null,"Commericial/Institutional",{"v":8.777999999999999,"d":"8.78"},{"$f":"(C8*0.98+4/8+3.7)*0.7","v":{"v":8.961707999999998,"d":"8.96"}},{"v":10.836,"d":"10.84"},{"v":13.005999999999998,"d":"13.01"},{"$f":"(F8*0.98+4/2+3.7)*0.7","v":{"v":12.912116,"d":"12.91"}},{"$f":"(G8*0.98+4/8+3.7)*0.7","v":{"v":11.797711576,"d":"11.80"}},{"v":12.936,"d":"12.94"},{"$f":"(I8*0.98+4/8+3.7)*0.7","v":{"v":11.814096,"d":"11.81"}},{"v":12.277999999999999,"d":"12.28"},{"v":10.836,"d":"10.84"},{"v":12.939499999999999,"d":"12.94"},{"v":13.594000000000001,"d":"13.59"},{"v":140.689131576,"d":"140.69"}]
[null,"Industrial",{"v":1.4,"d":"1.40"},{"v":1.5,"d":"1.50"},{"v":1.2,"d":"1.20"},{"v":1.1,"d":"1.10"},{"v":1.6,"d":"1.60"},{"v":1.8,"d":"1.80"},{"v":1.5,"d":"1.50"},{"v":1.6,"d":"1.60"},{"v":1.2,"d":"1.20"},{"v":1.4,"d":"1.40"},{"v":1.4,"d":"1.40"},{"v":1.4,"d":"1.40"},{"v":17.099999999999998,"d":"17.10"}]
[null,"Landscape Irrigation",2.54,4.82,8.42,10.48,11.94,12.71,14.45,12.45,10.98,11.11,9.92,7.45,{"v":117.27000000000001,"d":"117.27"}]
[null,"Municipal",{"$f":"(C8/2+2.157)*0.3384","v":{"v":2.2151663999999998,"d":"2.22"}},{"v":2.2462497935999997,"d":"2.25"},{"v":2.56338,"d":"2.56"},{"v":2.930544,"d":"2.93"},{"v":2.9146588271999994,"d":"2.91"},{"v":2.7261015986591994,"d":"2.73"},{"v":2.9187,"d":"2.92"},{"v":2.7288738431999997,"d":"2.73"},{"v":2.8073664,"d":"2.81"},{"v":2.56338,"d":"2.56"},{"v":2.9192921999999997,"d":"2.92"},{"v":3.0300336,"d":"3.03"},{"v":32.5637466626592,"d":"32.56"}]
[null,"Water Department",{"v":1.4951999999999999,"d":"1.50"},{"v":1.5456,"d":"1.55"},1.05,{"v":1.6632,"d":"1.66"},{"v":1.2011999999999998,"d":"1.20"},{"v":1.7136,"d":"1.71"},{"v":1.554,"d":"1.55"},{"v":1.4951999999999999,"d":"1.50"},{"v":2.1336,"d":"2.13"},{"v":1.218,"d":"1.22"},{"v":1.3776,"d":"1.38"},{"v":0.8231999999999999,"d":"0.82"},{"$f":"SUM(C12:N12)","v":{"v":17.2704,"d":"17.27"}}]
[null,"Recycled",{"v":10.084,"d":"10.08"},{"v":8.036,"d":"8.04"},10.83,{"v":11.954,"d":"11.95"},{"v":12.198,"d":"12.20"},{"v":12.836,"d":"12.84"},{"v":14.346,"d":"14.35"},{"v":12.696,"d":"12.70"},{"v":10.908,"d":"10.91"},10.63,8.83,{"v":9.290000000000001,"d":"9.29"},{"$f":"SUM(C13:N13)","v":{"v":132.638,"d":"132.64"}}]
[]
[]
[null,"WATER AUDIT TOTALS"]
[null,"excludes recycled water accounts"]
[]
[null,"Billed Metered Authorized Consumption:",null,null,{"$f":"SUM(O6:O11)","v":{"v":1051.3308782386594,"d":"1,051.33"}},"MG","includes SF Residential, MF Residential, Commerical/Institutional, Industrial, Landscape Irrigation (potable), and Municpal uses"]
[null,"Billed Unmetered Authorized Consumption: ",null,null,"N/A",null,"all billed customers have a meter"]
[null,"Unbilled Metered Authorized Consumption: ",null,null,{"$f":"SUM(O12)","v":{"v":17.2704,"d":"17.27"}},"MG","this includes our own facility use; all metered and read monthly but not revenue generating"]
[null,"Unbilled Unmetered Authorized Consumption: ",{"$nulls":4},"this includes minimal flushing, fire-fighting, and fire-flow testing - we currently do not track so default applied"]

{"sheet":"4. Schematic","index":3,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Meter Accuracy Report","index":4,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Electronic Calibration Report","index":5,"n_rows":0,"n_cols":0,"rows_kept":0}