{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Bill Estimator (Water)","Rate Option Data","Gallon Conversion"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"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":"Bill Estimator (Water)","index":0,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3]]}
["City of Poway"]
["Water"]
["Residential Bi-Monthly Bill Estimator"]
[]
["Inputs"]
["Bi-Monthly Use:",30]
["Meter Size:","3/4\""]
["Adopted (1/1/2025)","Proposed (1/21/2026)"]
[]
["Fun Facts"]
["Use (in Gallons)",{"$f":"$B$6*748.052","v":22441.56}]
["Equivalent To1:"]
["Water Bottles (12 Fl.Oz.)",{"$f":"+($B$11*'Gallon Conversion'!$B$2)/12","v":239376.64000000001}]
["Washing Machine Loads",{"$f":"+$B$11/'Gallon Conversion'!B3","v":1496.104}]
["Hot Tubs",{"$f":"+$B$11/'Gallon Conversion'!B4","v":56.103900000000003}]
["Semi-Truck Tankers",{"$f":"+$B$11/'Gallon Conversion'!B5","v":2.4935066666666668}]
["Swimming Pools",{"$f":"+$B$11/'Gallon Conversion'!B6","v":1.2467533333333334}]
[]
["Impacts","Adopted (1/1/2025)",null,"Proposed (1/21/2026)"]
["Variable"]
[{"$f":"IF('Rate Option Data'!$J$4<>\"\",'Rate Option Data'!$P$4&\" (\"&'Rate Option Data'!$J$4&\" Units)\",\" \")","v":"Tier 1 (20 Units)"},{"$f":"IFERROR(IF('Rate Option Data'!$J$4>$B$6,$B$6*INDEX('Rate Option Data'!$D$25:$E$25,MATCH('Bill Estimator (Water)'!$A$8,'Rate Option Data'!$D$24:$E$24,0)),'Rate Option Data'!$J$4*INDEX('Rate Option Data'!$D$25:$E$25,MATCH('Bill Estimator (Water)'!$A$8,'Rate Option Data'!$D$24:$E$24,0))),0)","v":134.4},"Uniform",{"$f":"B6*'Rate Option Data'!E29","v":246.3}]
[{"$f":"IF('Rate Option Data'!$J$5<>\"\",'Rate Option Data'!$P$5&\" (\"&'Rate Option Data'!$J$5&\" Units)\",\" \")","v":"Tier 2 (56 Units)"},{"$f":"IF(AND($B$6>'Rate Option Data'!$J$4,$B$6<='Rate Option Data'!$J$5),($B$6-'Rate Option Data'!$J$4)*INDEX('Rate Option Data'!$D$26:$E$26,MATCH('Bill Estimator (Water)'!$A$8,'Rate Option Data'!$D$24:$E$24,0)),IF($B$6<='Rate Option Data'!$J$4,0,('Rate Option Data'!$J$5-'Rate Option Data'!$J$4)*INDEX('Rate Option Data'!$D$26:$E$26,MATCH('Bill Estimator (Water)'!$A$8,'Rate Option Data'!$D$24:$E$24,0))))","v":77.8}]
[{"$f":"IF('Rate Option Data'!$J$6<>\"\",'Rate Option Data'!$P$6&\" (\"&'Rate Option Data'!$J$6&\" Units)\",\" \")","v":"Tier 3 (>56 Units)"},{"$f":"IF(AND($B$6>'Rate Option Data'!$J$5,$B$6<='Rate Option Data'!$J$6),($B$6-'Rate Option Data'!$J$5)*INDEX('Rate Option Data'!$D$27:$E$27,MATCH('Bill Estimator (Water)'!$A$8,'Rate Option Data'!$D$24:$E$24,0)),IF($B$6<='Rate Option Data'!$J$5,0,('Rate Option Data'!$J$6-'Rate Option Data'!$J$5)*INDEX('Rate Option Data'!$D$27:$E$27,MATCH('Bill Estimator (Water)'!$A$8,'Rate Option Data'!$D$24:$E$24,0))))","v":0}]
[{"$f":"IF('Rate Option Data'!J7<>\"\",'Rate Option Data'!P7&\" (\"&'Rate Option Data'!J7&\" Units)\",\" \")","v":" "}]
["Variable Total",{"$f":"SUM(B21:B24)","v":212.2},null,{"$f":"SUM(D21:D24)","v":246.3}]
[]
["Fixed (Basic Service)",{"$f":"INDEX('Rate Option Data'!$C$13:$D$21,MATCH('Bill Estimator (Water)'!$B$7,'Rate Option Data'!$A$13:$A$21,0),MATCH('Bill Estimator (Water)'!$A$8,'Rate Option Data'!$C$12:$D$12,0))","v":98.27},null,{"$f":"INDEX('Rate Option Data'!$C$13:$D$21,MATCH('Bill Estimator (Water)'!$B$7,'Rate Option Data'!$A$13:$A$21,0),MATCH('Bill Estimator (Water)'!$B$8,'Rate Option Data'!$C$12:$D$12,0))","v":113.03}]
[]
["Total Bi-Monthly Bill",{"$f":"SUM(B25:B28)","v":310.46999999999997},null,{"$f":"SUM(D25:D28)","v":359.33000000000004}]
["$ Increase",null,null,{"$f":"+D29-B29","v":48.86000000000007}]
["% Increase",null,null,{"$f":"+(D29-B29)/B29","v":0.15737430347537629}]
[]
["All-in/Unit",{"$f":"+B29/$B$6","v":10.348999999999998},null,{"$f":"+D29/$B$6","v":11.977666666666668}]
["$/Gallon",{"$f":"+B29/$B$11","v":1.3834599733708351E-2},null,{"$f":"+D29/$B$11","v":1.6011810230661328E-2}]
[]
["Notes:"]
["1. An approximation that assumes averages for each category based on online research."]
["2. Please note this spreadsheet is for estimating residential impacts only. Your actual bill"]
["may vary slightly due to rounding."]

{"sheet":"Rate Option Data","index":1,"n_rows":97,"n_cols":17,"rows_kept":97,"cut":false,"hidden":true,"merged":[[1,6,1,8],[1,12,1,14]]}
["WATER"]
[null,null,null,null,null,"Customer Class","Bi-monthly Tier Analysis",null,null,"Selected",null,"Customer Class","Bi-monthly Tier Analysis",null,null,"Selected"]
[null,null,null,null,null,"Single Family","2-Tiered","3-Tiered","4-Tiered",null,null,"Single Family","2-Tiered","3-Tiered"]
[null,null,null,null,null,"Tier 1",199,20,null,{"$f":"+H4","v":20},{"$f":"ISREF(J4)","v":true},null,"Tier 1","Tier 1",null,{"$f":"+N4","v":"Tier 1"},{"$f":"ISREF(P4)","v":true}]
[null,null,null,null,null,"Tier 2",{"$f":"\">\"&G4","v":">199"},56,null,{"$f":"+H5","v":56},{"$f":"ISREF(J5)","v":true},null,"Tier 2","Tier 2",null,{"$f":"+N5","v":"Tier 2"},{"$f":"ISREF(P5)","v":true}]
[null,null,null,null,null,"Tier 3",null,{"$f":"\">\"&H5","v":">56"},null,{"$f":"+H6","v":">56"},{"$f":"ISREF(J6)","v":true},null,null,"Tier 3",null,{"$f":"+N6","v":"Tier 3"},{"$f":"ISREF(P6)","v":true}]
[]
[]
["Selected"]
[]
[]
["Meter Size","Current","Adopted (1/1/2025)","Proposed (1/21/2026)"]
["5/8\"",72.69,72.69,81.540000000000006]
["3/4\"",98.27,98.27,113.03]
["1\"",149.41,149.41,176.03]
["1 1/2\"",277.27,277.27,333.52]
["2\"",430.67,430.67,522.5]
["3\"",916.53,916.53,1120.96]
["4\"",1632.5,1632.5,2002.89]
["6\"",3345.71,3345.71,4113.2299999999996]
["8\"",6158.49,6158.49,7577.96]
[]
[]
["Tiers","Bi-Monthly Tiers (Units)","Current","Adopted (1/1/2025)","Proposed (1/21/2026)"]
["Tier 1",{"$f":"+J4","v":20},6.72,6.72,0]
["Tier 2",{"$f":"+J5","v":56},7.78,7.78,0]
["Tier 3",">56",10.69,10.69,0]
[]
["Uniform",null,null,null,8.2100000000000009]
[]
[]
["WASTEWATER"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Fixed Charge","Current","Proposed (3/4/2020)","Proposed (1/1/2021)"]
[null,21.34,26.63,28.31]
[]
[]
["Tiers","Bi-Monthly Tiers (Units)","Current","Proposed (3/4/2020)","Proposed (1/1/2021)",null,null,null,"Tiers","Bi-Monthly Tiers (Units)","Tiers for Index/Match","Tier Width (Units)","Actual Tier Usage (Units)",null,"Current","25%/75% F/V (Option 2b)","30%/70% F/V (Option 2c)"]
["Tier 1",1,29.54,4.38,4.66]
["Tier 1",2,29.54,null,null,null,null,null,"Tier 1",5,5,{"$f":"+J48","v":5},{"$f":"MIN(#REF!,'Rate Option Data'!$L$48)","v":{"$error":"#REF!"}},null,29.54,4.6900000000000004,4.38]
["Tier 1",3,29.54,null,null,null,null,null,"Tier 2",12,{"$f":"+J49+1","v":13},{"$f":"+J49-J48","v":7},{"$f":"MIN(#REF!-SUM(M48),'Rate Option Data'!$L$49)","v":{"$error":"#REF!"}},null,52.12]
["Tier 1",4,29.54,null,null,null,null,null,"Tier 3",19,20,{"$f":"+J50-J49","v":7},{"$f":"MIN(#REF!-SUM(M48:M49),'Rate Option Data'!$L$50)","v":{"$error":"#REF!"}},null,78.45]
["Tier 1",5,29.54,null,null,null,null,null,"Tier 4",26,27,{"$f":"+J51-J50","v":7},{"$f":"MIN(#REF!-SUM(M48:M50),'Rate Option Data'!$L$51)","v":{"$error":"#REF!"}},null,85.99]
["Tier 2",6,52.12,null,null,null,null,null,"Tier 5",37,38,{"$f":"+J52-J51","v":11},{"$f":"MIN(#REF!-SUM(M48:M51),'Rate Option Data'!$L$52)","v":{"$error":"#REF!"}},null,101.04]
["Tier 2",7,52.12,null,null,null,null,null,"Tier 6",50,51,{"$f":"+J53-J52","v":13},{"$f":"MIN(#REF!-SUM(M48:M52),'Rate Option Data'!$L$53)","v":{"$error":"#REF!"}},null,116.09]
["Tier 2",8,52.12,null,null,null,null,null,"Tier 7",{"$f":"\">\"&J53","v":">50"},null,null,{"$f":"MIN(#REF!-SUM(M48:M53),'Rate Option Data'!$L$54)","v":{"$error":"#REF!"}},null,127.39]
["Tier 2",9,52.12,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M48:M54)","v":{"$error":"#REF!"}}]
["Tier 2",10,52.12,null,null,null,null,null,null,null,null,null,{"$f":"+M55-#REF!","v":{"$error":"#REF!"}}]
["Tier 2",11,52.12]
["Tier 2",12,52.12]
["Tier 3",13,78.45]
["Tier 3",14,78.45]
["Tier 3",15,78.45]
["Tier 3",16,78.45]
["Tier 3",17,78.45]
["Tier 3",18,78.45]
["Tier 3",19,78.45]
["Tier 4",20,85.99]
["Tier 4",21,85.99]
["Tier 4",22,85.99]
["Tier 4",23,85.99]
["Tier 4",24,85.99]
["Tier 4",25,85.99]
["Tier 4",26,85.99]
["Tier 5",27,101.04]
["Tier 5",28,101.04]
["Tier 5",29,101.04]
["Tier 5",30,101.04]
["Tier 5",31,101.04]
["Tier 5",32,101.04]
["Tier 5",33,101.04]
["Tier 5",34,101.04]
["Tier 5",35,101.04]
["Tier 5",36,101.04]
["Tier 5",37,101.04]
["Tier 6",38,116.09]
["Tier 6",39,116.09]
["Tier 6",40,116.09]
["Tier 6",41,116.09]
["Tier 6",42,116.09]
["Tier 6",43,116.09]
["Tier 6",44,116.09]
["Tier 6",45,116.09]
["Tier 6",46,116.09]
["Tier 6",47,116.09]
["Tier 6",48,116.09]
["Tier 6",49,116.09]
["Tier 6",50,116.09]
["Tier 7",51,127.39]

{"sheet":"Gallon Conversion","index":2,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
["Water Bottles (12 Fl.Oz.)",128,"Ounces in one gallon","https://www.calculateme.com/volume/fluid-ounces/to-gallons/12"]
["Washing Machine",15,"Gallons per Load","https://www.home-water-works.org/indoor-use/clothes-washer"]
["Hot Tub",400,null,"https://www.apsp.org/Portals/0/IHTA/Drought%20Fact%20Sheet%20-%20Water%20Districts%20final_09-2014.pdf"]
["Semi-Truck Tanker",9000,"Tank size","https://www.fueloyal.com/10-interesting-facts-tanker-truck/"]
["Swimming Pool",18000,"Avg LA pool","https://pacinst.org/water-policy-what-about-all-those-swimming-pools-in-los-angeles/"]