{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["annual  combined rate calc","5-8 Meters","3-4\" Meters","1\" Meter","1.5\" Meters","2\" Meters","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"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":"annual  combined rate calc","index":0,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[5,1,5,2],[4,1,4,2]]}
[]
[null,null,"Bill",{"$f":"SUM(G8,F10:F18)","v":40.049999999999997},null,"Rate Calculator"]
[null,null,null,null,null,1,"Months to Calculate Bill"]
[null,null,null,null,null,1,"Tap Equivalents per Month"]
[null,"Gallons Used",null,"Base/TE",null,5000,"Total Gallons used for Billing Period above"]
[null,{"$f":"F5","v":5000},null,{"$f":"F4","v":1},null,{"$f":"D2*F3","v":40.049999999999997},"Total of bill for the above"]
[]
[null,{"$f":"G9","v":0},"Base",null,null,"H2O Chrge",{"$f":"D6*H8","v":29},29]
[null,{"$f":" B6-B8","v":5000}," ",null,null,null,{"$f":"D6*H9","v":0},0,2.11]
[null,{"$f":" G10","v":4000},"Tier 1",{"$f":"IF(B9>B10,B10,B9)","v":4000},null,{"$f":"IF(D10>0,D10/1000*I9)","v":8.44},{"$f":"D6*H10","v":4000},4000,2.61]
[null,{"$f":" B9-B10","v":1000}," ",null,null," ",{"$f":"D$6*H11","v":19000},19000,4.49]
[null,{"$f":"G11-G10","v":15000},"Tier 2",{"$f":"IF(B11>B12,B12,B11)","v":1000},null,{"$f":"IF(D12>0,D12/1000*I10)","v":2.61},{"$f":"D$6*H12","v":59000},59000,7.32]
[null,{"$f":"B11-B12","v":-14000},null,null,null,null,{"$f":"D$6*H13","v":129000},129000,21.97]
[null,{"$f":"G12-G11","v":40000},"Tier 3",{"$f":"IF(B13>B14,B14,B13)","v":-14000},null,{"$f":"IF(D14>0,D14/1000*I11,0)","v":0},{"$f":"D$6*H14","v":0}]
[null,{"$f":"B13-B14","v":-54000}]
[null,{"$f":"G13-G12","v":70000},"Tier 4",{"$f":"IF(B15>B16,B16,B15)","v":-54000},null,{"$f":"IF(D16>0,D16/1000*I12,0)","v":0}]
[null,{"$f":"B15-B16","v":-124000}]
[null,{"$f":"B17","v":-124000},"Tier 5",{"$f":"IF(B17>B18,B18,B17)","v":-124000},null,{"$f":"IF(D18>0,D18/1000*I13,0)","v":0}]
[null,null,null,{"$f":"SUM(D10:D18)+B8","v":-187000}]

{"sheet":"5-8 Meters","index":1,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":true,"merged":[[5,1,5,2],[6,1,6,2]]}
[null,"5/8\" Meter Rate Calculation"]
[]
[null,null,"Bill",{"$f":"SUM(G9,F11:F19)","v":12419.779999999999}]
[]
[]
[null,"Gallons Used",null,"Base/TE"]
[null,706000,null,1]
[]
[null,{"$f":"G10","v":0},"Base",null,null,"H2O Chrge",{"$f":"D7*H9","v":29},{"$f":"'annual  combined rate calc'!H8","v":29}]
[null,{"$f":" B7-B9","v":706000}," ",null,null,null,{"$f":"D7*H10","v":0},0]
[null,{"$f":" G11","v":4000},"Tier 1",{"$f":"IF(B10>B11,B11,B10)","v":4000},null,{"$f":"IF(D11>0,D11/1000*I11,0)","v":8.44},{"$f":"D$7*H11","v":4000},4000,{"$f":"'annual  combined rate calc'!I9","v":2.11}]
[null,{"$f":" B10-B11","v":702000}," ",null,null," ",{"$f":"D$7*H12","v":19000},19000,{"$f":"'annual  combined rate calc'!I10","v":2.61}]
[null,{"$f":"G12-G11","v":15000},"Tier 2",{"$f":"IF(B12>B13,B13,B12)","v":15000},null,{"$f":"IF(D13>0,D13/1000*I12,0)","v":39.15},{"$f":"D$7*H13","v":59000},59000,{"$f":"'annual  combined rate calc'!I11","v":4.49}]
[null,{"$f":"B12-B13","v":687000},null,null,null,null,{"$f":"D$7*H14","v":199000},199000,{"$f":"'annual  combined rate calc'!I12","v":7.32}]
[null,{"$f":"G13-G12","v":40000},"Tier 3",{"$f":"IF(B14>B15,B15,B14)","v":40000},null,{"$f":"IF(D15>0,D15/1000*I13,0)","v":179.60000000000002},{"$f":"D$7*H15","v":0},null,{"$f":"'annual  combined rate calc'!I13","v":21.97}]
[null,{"$f":"B14-B15","v":647000}]
[null,{"$f":"G14-G13","v":140000},"Tier 4",{"$f":"IF(B16>B17,B17,B16)","v":140000},null,{"$f":"IF(D17>0,D17/1000*I14,0)","v":1024.8}]
[]
[null,{"$f":"B16-B17","v":507000},"Tier 5",{"$f":"IF(B19>B19,B19,B19)","v":507000},null,{"$f":"IF(D19>0,D19/1000*I15,0)","v":11138.789999999999}]
[null,null,null,{"$f":"SUM(D11:D19)+B9","v":706000}]

{"sheet":"3-4\" Meters","index":2,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":true,"merged":[[5,1,5,2],[6,1,6,2]]}
[null,"3/4\" Meter Rate Calculation"]
[]
[null,null,"Bill",{"$f":"SUM(G9,F11:F19)","v":39.269999999999996}]
[]
[]
[null,"Gallons Used",null,"Base/TE"]
[null,7000,null,1]
[]
[null,{"$f":"G10","v":0},"Base",null,null,"H2O Chrge",{"$f":"D7*H9","v":23},23]
[null,{"$f":" B7-B9","v":7000}," ",null,null,null,{"$f":"D7*H10","v":0},0]
[null,{"$f":" G11","v":4000},"Tier 1",{"$f":"IF(B10>B11,B11,B10)","v":4000},null,{"$f":"IF(D11>0,D11/1000*I11,0)","v":8.44},{"$f":"D$7*H11","v":4000},{"$f":"'5-8 Meters'!H11","v":4000},{"$f":"'5-8 Meters'!I11","v":2.11}]
[null,{"$f":" B10-B11","v":3000}," ",null,null," ",{"$f":"D$7*H12","v":19000},{"$f":"'5-8 Meters'!H12","v":19000},{"$f":"'5-8 Meters'!I12","v":2.61}]
[null,{"$f":"G12-G11","v":15000},"Tier 2",{"$f":"IF(B12>B13,B13,B12)","v":3000},null,{"$f":"IF(D13>0,D13/1000*I12,0)","v":7.83},{"$f":"D$7*H13","v":59000},{"$f":"'5-8 Meters'!H13","v":59000},{"$f":"'5-8 Meters'!I13","v":4.49}]
[null,{"$f":"B12-B13","v":-12000},null,null,null,null,{"$f":"D$7*H14","v":199000},{"$f":"'5-8 Meters'!H14","v":199000},{"$f":"'5-8 Meters'!I14","v":7.32}]
[null,{"$f":"G13-G12","v":40000},"Tier 3",{"$f":"IF(B14>B15,B15,B14)","v":-12000},null,{"$f":"IF(D15>0,D15/1000*I13,0)","v":0},null,null,{"$f":"'5-8 Meters'!I15","v":21.97}]
[null,{"$f":"B14-B15","v":-52000}]
[null,{"$f":"G14-G13","v":140000},"Tier 4",{"$f":"IF(B16>B17,B17,B16)","v":-52000},null,{"$f":"IF(D17>0,D17/1000*I14,0)","v":0}]
[]
[null,{"$f":"B16-B17","v":-192000},"Tier 5",{"$f":"IF(B19>B19,B19,B19)","v":-192000},null,{"$f":"IF(D19>0,D19/1000*I15,0)","v":0}]
[null,null,null,{"$f":"SUM(D11:D19)+B9","v":-249000}]

{"sheet":"1\" Meter","index":3,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":true,"merged":[[5,1,5,2],[6,1,6,2]]}
[null,"1\" Meter Rate Calculation"]
[]
[null,null,"Bill",{"$f":"SUM(G9,F11:F19)","v":5211.84}]
[]
[]
[null,"Gallons Used",null,"Base/TE"]
[null,800000,null,4]
[]
[null,{"$f":"G10","v":0},"Base",null,null,"H2O Chrge",{"$f":"D7*H9","v":116},{"$f":"'5-8 Meters'!H9","v":29}]
[null,{"$f":" B7-B9","v":800000}," ",null,null,null,{"$f":"D7*H10","v":0},{"$f":"'5-8 Meters'!H10","v":0}]
[null,{"$f":" G11","v":16000},"Tier 1",{"$f":"IF(B10>B11,B11,B10)","v":16000},null,{"$f":"IF(D11>0,D11/1000*I11,0)","v":33.76},{"$f":"D$7*H11","v":16000},{"$f":"'5-8 Meters'!H11","v":4000},{"$f":"'5-8 Meters'!I11","v":2.11}]
[null,{"$f":" B10-B11","v":784000}," ",null,null," ",{"$f":"D$7*H12","v":76000},{"$f":"'5-8 Meters'!H12","v":19000},{"$f":"'5-8 Meters'!I12","v":2.61}]
[null,{"$f":"G12-G11","v":60000},"Tier 2",{"$f":"IF(B12>B13,B13,B12)","v":60000},null,{"$f":"IF(D13>0,D13/1000*I12,0)","v":156.6},{"$f":"D$7*H13","v":236000},{"$f":"'5-8 Meters'!H13","v":59000},{"$f":"'5-8 Meters'!I13","v":4.49}]
[null,{"$f":"B12-B13","v":724000},null,null,null,null,{"$f":"D$7*H14","v":796000},{"$f":"'5-8 Meters'!H14","v":199000},{"$f":"'5-8 Meters'!I14","v":7.32}]
[null,{"$f":"G13-G12","v":160000},"Tier 3",{"$f":"IF(B14>B15,B15,B14)","v":160000},null,{"$f":"IF(D15>0,D15/1000*I13,0)","v":718.40000000000009},null,null,{"$f":"'5-8 Meters'!I15","v":21.97}]
[null,{"$f":"B14-B15","v":564000}]
[null,{"$f":"G14-G13","v":560000},"Tier 4",{"$f":"IF(B16>B17,B17,B16)","v":560000},null,{"$f":"IF(D17>0,D17/1000*I14,0)","v":4099.2}]
[]
[null,{"$f":"B16-B17","v":4000},"Tier 5",{"$f":"IF(B19>B19,B19,B19)","v":4000},null,{"$f":"IF(D19>0,D19/1000*I15,0)","v":87.88}]
[null,null,null,{"$f":"SUM(D11:D19)+B9","v":800000}]

{"sheet":"1.5\" Meters","index":4,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":true,"merged":[[5,1,5,2],[6,1,6,2]]}
[null,"1.5\" Meter Rate Calculation"]
[]
[null,null,"Bill",{"$f":"SUM(G9,F11:F19)","v":11726.64}]
[]
[]
[null,"Gallons Used",null,"Base/TE"]
[null,1800000,null,9]
[]
[null,{"$f":"G10","v":0},"Base",null,null,"H2O Chrge",{"$f":"D7*H9","v":261},{"$f":"'5-8 Meters'!H9","v":29}]
[null,{"$f":" B7-B9","v":1800000}," ",null,null,null,{"$f":"D7*H10","v":0},{"$f":"'5-8 Meters'!H10","v":0}]
[null,{"$f":" G11","v":36000},"Tier 1",{"$f":"IF(B10>B11,B11,B10)","v":36000},null,{"$f":"IF(D11>0,D11/1000*I11,0)","v":75.959999999999994},{"$f":"D$7*H11","v":36000},{"$f":"'5-8 Meters'!H11","v":4000},{"$f":"'5-8 Meters'!I11","v":2.11}]
[null,{"$f":" B10-B11","v":1764000}," ",null,null," ",{"$f":"D$7*H12","v":171000},{"$f":"'5-8 Meters'!H12","v":19000},{"$f":"'5-8 Meters'!I12","v":2.61}]
[null,{"$f":"G12-G11","v":135000},"Tier 2",{"$f":"IF(B12>B13,B13,B12)","v":135000},null,{"$f":"IF(D13>0,D13/1000*I12,0)","v":352.34999999999997},{"$f":"D$7*H13","v":531000},{"$f":"'5-8 Meters'!H13","v":59000},{"$f":"'5-8 Meters'!I13","v":4.49}]
[null,{"$f":"B12-B13","v":1629000},null,null,null,null,{"$f":"D$7*H14","v":1791000},{"$f":"'5-8 Meters'!H14","v":199000},{"$f":"'5-8 Meters'!I14","v":7.32}]
[null,{"$f":"G13-G12","v":360000},"Tier 3",{"$f":"IF(B14>B15,B15,B14)","v":360000},null,{"$f":"IF(D15>0,D15/1000*I13,0)","v":1616.4},null,null,{"$f":"'5-8 Meters'!I15","v":21.97}]
[null,{"$f":"B14-B15","v":1269000}]
[null,{"$f":"G14-G13","v":1260000},"Tier 4",{"$f":"IF(B16>B17,B17,B16)","v":1260000},null,{"$f":"IF(D17>0,D17/1000*I14,0)","v":9223.2000000000007}]
[]
[null,{"$f":"B16-B17","v":9000},"Tier 5",{"$f":"IF(B19>B19,B19,B19)","v":9000},null,{"$f":"IF(D19>0,D19/1000*I15,0)","v":197.73}]
[null,null,null,{"$f":"SUM(D11:D19)+B9","v":1800000}]

{"sheet":"2\" Meters","index":5,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":true,"merged":[[5,1,5,2],[6,1,6,2]]}
[null,"2\" Meter Rate Calculation"]
[]
[null,null,"Bill",{"$f":"SUM(G9,F11:F19)","v":37.44}]
[]
[]
[null,"Gallons Used",null,"Base/TE"]
[null,4000,null,1]
[]
[null,{"$f":"G10","v":0},"Base",null,null,"H2O Chrge",{"$f":"D7*H9","v":29},{"$f":"'5-8 Meters'!H9","v":29}]
[null,{"$f":" B7-B9","v":4000}," ",null,null,null,{"$f":"D7*H10","v":0},{"$f":"'5-8 Meters'!H10","v":0}]
[null,{"$f":" G11","v":4000},"Tier 1",{"$f":"IF(B10>B11,B11,B10)","v":4000},null,{"$f":"IF(D11>0,D11/1000*I11,0)","v":8.44},{"$f":"D$7*H11","v":4000},{"$f":"'5-8 Meters'!H11","v":4000},{"$f":"'5-8 Meters'!I11","v":2.11}]
[null,{"$f":" B10-B11","v":0}," ",null,null," ",{"$f":"D$7*H12","v":19000},{"$f":"'5-8 Meters'!H12","v":19000},{"$f":"'5-8 Meters'!I12","v":2.61}]
[null,{"$f":"G12-G11","v":15000},"Tier 2",{"$f":"IF(B12>B13,B13,B12)","v":0},null,{"$f":"IF(D13>0,D13/1000*I12,0)","v":0},{"$f":"D$7*H13","v":59000},{"$f":"'5-8 Meters'!H13","v":59000},{"$f":"'5-8 Meters'!I13","v":4.49}]
[null,{"$f":"B12-B13","v":-15000},null,null,null,null,{"$f":"D$7*H14","v":199000},{"$f":"'5-8 Meters'!H14","v":199000},{"$f":"'5-8 Meters'!I14","v":7.32}]
[null,{"$f":"G13-G12","v":40000},"Tier 3",{"$f":"IF(B14>B15,B15,B14)","v":-15000},null,{"$f":"IF(D15>0,D15/1000*I13,0)","v":0},null,null,{"$f":"'5-8 Meters'!I15","v":21.97}]
[null,{"$f":"B14-B15","v":-55000}]
[null,{"$f":"G14-G13","v":140000},"Tier 4",{"$f":"IF(B16>B17,B17,B16)","v":-55000},null,{"$f":"IF(D17>0,D17/1000*I14,0)","v":0}]
[]
[null,{"$f":"B16-B17","v":-195000},"Tier 5",{"$f":"IF(B19>B19,B19,B19)","v":-195000},null,{"$f":"IF(D19>0,D19/1000*I15,0)","v":0}]
[null,null,null,{"$f":"SUM(D11:D19)+B9","v":-261000}]

{"sheet":"Sheet2","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}