{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Residential Water & Sewer","MeterTypes"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Residential Water & Sewer","index":0,"n_rows":64,"n_cols":10,"rows_kept":64,"cut":false,"hidden":false,"merged":[[0,1,0,4],[63,1,63,4],[5,1,5,4],[16,1,16,2],[7,1,7,2],[10,3,11,3],[10,4,11,4]]}
[null,"Rate Calculator"]
[]
[null,"Residential Meter Size",0.625,"Select your meter size which can be found on your utility bill. Your Base Rate is determined by the meter size."]
[null,"Usage in Hundred Cubic Feet (CCF)",4,"Enter your water usage which can be found on your utility bill."]
[]
[null,"Instructions: ​Provide the information requested above. Your water usage and meter size can be found on your utility bill. Some accounts have more than one meter. For those accounts with multiple meters, you will need to run the calculator for each meter."]
[]
[null,"Rates "]
[null,"Water",{"$f":"+E32","v":17.32}]
[null,"Sewer",{"$f":"+E51","v":26.2}]
[null,"New Rates Total",{"$f":"+C10+C9","v":43.52},null,{"$f":"+C11-C20","v":16.190000000000001}]
[]
[]
[]
[]
[]
[null,"Old Rates ",null,null,null,null,null,"Percent Change:   ",{"$f":"+E11/C20","v":0.59240000000000004}]
[null,"Water",{"$f":"+E40","v":8.52}]
[null,"Sewer",{"$f":"+E59","v":18.809999999999999}]
[null,"Old Rates Total",{"$f":"SUM(C18:C19)","v":27.33}]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(D24:D25)","v":4}]
[null,"Residential Water Tiers","Rate per CCF","Measured CCF","Charge for Tier"]
[null,"First 2 CCF",0,{"$f":"IF(C4<=2,C4,IF(C4>2,2,0))","v":2},{"$f":"+C24*D24/1","v":0}]
[null,"Next 4 CCF",4.2,{"$f":"IF(C4>6,4,IF(C4>2,C4-2,0))","v":2},{"$f":"+C25*D25/1","v":8.4},null,null,null,"Base Rates by Water Meter Size"]
[null,"Next 4 CCF",5.05,{"$f":"IF(C4>10,4,IF(C4<=10,C4-H22))","v":0},{"$f":"+C26*D26/1","v":0},null,null,"Size (Inches)","New","Old"]
[null,"Amount over 10 CCF",6.31,{"$f":"IF(C4>10,C4-10,0)","v":0},{"$f":"+C27*D27/1","v":0},null,null,0.625,6.12,3.13]
[null,"City Tax",null,null,{"$f":"SUM(E24:E27,E31)*0.0225","v":0.33},null,null,0.75,14.56,10.62]
[null,"State Tax",null,null,{"$f":"SUM(E24:E27,E31)*0.07","v":1.02}]
[null,"10%  Water Infrastructure Replacement  (WIR) fee",null,null,{"$f":"SUM(E24:E27,E31)*10%","v":1.45}]
[null,null,null,"Base Water Rate",{"$f":"IF(C$3=H27,I27,IF(C$3=H28,I28,IF(C$3=H31,I31,IF(C$3=H33,I33,IF(C$3=H34,I34,IF(C$3=H35,I35,IF(C$3=H36,I36,IF(C$3=H39,I39,IF(C$3=H40,I40,IF(C$3=H41,I41,IF(C$3=#REF!,#REF!)))))))))))","v":6.12},null,null,1,18.350000000000001,12.77]
[null,null,null,"Bill Amount",{"$f":"SUM(E24:E31)","v":17.32}]
[null,null,null,null,null,null,null,1.5,32.25,18.77]
[null,"Old Residential Water Tiers","Rate per CCF","Measured CCF","Charge for Tier",null,null,2,45.53,25.29]
[null,"First 2 CCF",0,{"$f":"IF(C4<=2,C4,IF(C4>2,2,0))","v":2},{"$f":"+C35*D35/1","v":0},null,null,3,72.75,33.380000000000003]
[null,"Amount over 2 CCF",2.33,{"$f":"IF(C4>2,C4-2,0)","v":2},{"$f":"+C36*D36/1","v":4.66},null,null,4,165.4,54.41]
[null,"City Tax",null,null,{"$f":"SUM(E35:E36,E39)*0.0225","v":0.18}]
[null,"State Tax",null,null,{"$f":"SUM(E35:E36,E39)*0.07","v":0.55000000000000004}]
[null,null,null,"Old Base Water Rate",{"$f":"IF(C$3=H27,J27,IF(C$3=H28,J28,IF(C$3=H31,J31,IF(C$3=H33,J33,IF(C$3=H34,J34,IF(C$3=H35,J35,IF(C$3=H36,J36,IF(C$3=H39,J39,IF(C$3=H40,J40,IF(C$3=H41,J41,IF(C$3=#REF!,#REF!)))))))))))","v":3.13},null,null,6,206.49,85.42]
[null,null,null,"Old Bill Amount",{"$f":"SUM(E35:E39)","v":8.52},null,null,8,268.68,133.59]
[null,null,null,"New versus Old Bill ",{"$f":"+E32-E40","v":8.8000000000000007},null,null,10,268.68,133.59]
[null,null,null,"Percentage Change",{"$f":"+E41/E40","v":1.0328999999999999}]
[]
[]
[]
[null,"Residential Sewer Tiers","Rate per CCF","Measured CCF","Charge for Tier",null,null,null,"Base Sewer Rates by Water Meter Size"]
[null,"First 2 CCF",0,{"$f":"IF(C4<=2,C4,IF(C4>2,2,0))","v":2},{"$f":"+C47*D47/1","v":0},null,null,"Size (Inches)","New","Old"]
[null,"Amount over 2 CCF",7.02,{"$f":"IF(C4>2,C4-2,0)","v":2},{"$f":"+C48*D48/1","v":14.04},null,null,0.625,9.7799999999999994,7.62]
[null,"10%  Sewer Infrastructure Replacement  (SIR) fee",null,null,{"$f":"SUM(E47:E48,E50)*10%","v":2.38}]
[null,null,null,"Base Sewer Rate",{"$f":"IF(C$3=H48,I48,IF(C$3=H50,I50,IF(C$3=H51,I51,IF(C$3=H52,I52,IF(C$3=H53,I53,IF(C$3=H54,I54,IF(C$3=H55,I55,IF(C$3=H57,I57,IF(C$3=H58,I58,IF(C$3=H59,I59,IF(C$3=#REF!,#REF!)))))))))))","v":9.7799999999999994},null,null,0.75,43.23,21.63]
[null,null,null,"Bill Amount",{"$f":"SUM(E47:E50)","v":26.2},null,null,1,55.94,26.05]
[null,null,null,null,null,null,null,1.5,108.89,38.29]
[null,"Old Residential Sewer Tiers","Rate per CCF","Measured CCF","Charge for Tier",null,null,2,152.97999999999999,51.57]
[null,"First 2 CCF",0,{"$f":"IF(C4<=2,C4,IF(C4>2,2,0))","v":2},{"$f":"+C54*D54/1","v":0},null,null,3,190.45,68.040000000000006]
[null,"Amount over 2 CCF",4.74,{"$f":"IF(C4>2,C4-2,0)","v":2},{"$f":"+C55*D55/1","v":9.48},null,null,4,540.41,110.88]
[null,"10%  Sewer User Surcharge",null,null,{"$f":"SUM(E54,E55,E58)*10%","v":1.71}]
[null,null,null,null,null,null,null,6,644.24,174.12]
[null,null,null,"Old Base Sewer Rate",{"$f":"IF(C$3=H48,J48,IF(C$3=H50,J50,IF(C$3=H51,J51,IF(C$3=H52,J52,IF(C$3=H53,J53,IF(C$3=H54,J54,IF(C$3=H55,J55,IF(C$3=H57,J57,IF(C$3=H58,J58,IF(C$3=H59,J59,IF(C$3=#REF!,#REF!)))))))))))","v":7.62},null,null,8,824.92,272.29000000000002]
[null,null,null,"Old Bill Amount",{"$f":"SUM(E54:E58)","v":18.809999999999999},null,null,10,824.92,272.29000000000002]
[null,null,null,"New versus Old Bill ",{"$f":"+E51-E59","v":7.39}]
[null,null,null,"Percentage Change",{"$f":"+E60/E59","v":0.39290000000000003}]
[]
[]
[null,"Note: This calculator is provided for informational purposes only. The calculated sewer portion of this spreadsheet does not reflect any sprinkler adjustment credits that you may receive during the months of April through November."]

{"sheet":"MeterTypes","index":1,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[0.625]
[0.75]
[1]
[1.5]
[2]
[3]
[4]
[6]
[8]
[10]
[12]