{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tap Fees","Reference Tables"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Tap Fees","index":0,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,1,0,3],[28,1,28,3],[29,1,29,3]]}
[null,"ACWWA 2026 Multi-Family Water and Sewer Tap Fee Estimator",null,null,null,"Enter Value in Green Shaded Cells"]
[]
[null,"Water Service Line Size","Meter Size->",null,null,{"$f":"IF(CELL(\"contents\",D4)=0,\"\",\"Number of TEs\")","v":""}]
[null,"Number of Units",null,null,null,{"$f":"IF(CELL(\"contents\",D4)=0,\"\",IF((INT(D4)=D4)=TRUE, SUM(D4*'Reference Tables'!$A$25), \"<- Enter Integer\"))","v":""}]
[null,"DomesticTap",null,{"$f":"IF(ISBLANK($D$4)=TRUE,\"\", IF(CELL(\"contents\",D4)>=1,F4*'Reference Tables'!A14,\"\"))","v":""}]
[null,"Domestic Water Meter",null,{"$f":"IF(ISBLANK($D$3)=TRUE, \"\", VLOOKUP(LOOKUP(D$3,'Reference Tables'!$A$2:$A$9,'Reference Tables'!$C$2:$C$9),'Reference Tables'!$C$3:$D$9,2))","v":""}]
[null,"Water Service Line Inspections (including meter installation observation)",null,{"$f":"IF(ISBLANK($D$3)=TRUE, \"\", 'Reference Tables'!$A$20)","v":""}]
[null,"Radio Read Meter ",null,{"$f":"IF(ISBLANK($D$3)=TRUE, \"\", 'Reference Tables'!$A$18)","v":""}]
[null,"Fire Line Service Inspection (if required)",null,{"$f":"IF(ISBLANK($D$3)=TRUE, \"\", IF($C$9=\"No\", 0, 'Reference Tables'!$A$21))","v":""}]
[null,"Total Domestic Tap Fee",null,{"$f":"SUM(D5:D9)","v":0}]
[]
[null,"Wastewater Service (based upon Domestic water meter size)","Line Size->",null,null,{"$f":"IF(OR(ISBLANK($D$12)=TRUE,CELL(\"contents\",D4)=0), \"\",\"Number of TEs\")","v":""}]
[null,"Sewer Tap",null,{"$f":"IF(ISBLANK($D$12)=TRUE, \"\",IF(ISNUMBER(F13)=TRUE, F13*'Reference Tables'!A16,\"\"))","v":""},null,{"$f":"IF(ISBLANK($D$12)=TRUE, \"\",F4)","v":""}]
[null,"Sewer Service Line Inspection",null,{"$f":"IF(AND(ISBLANK($D$3)=FALSE, ISBLANK($D$12)=FALSE),'Reference Tables'!$A$23,\"\")","v":""}]
[null,"Total Sewer Tap Fee",null,{"$f":"SUM(D13:D14)","v":0}]
[null,null,null,null,null,{"$f":"IF(ISBLANK($D$18)=TRUE,\"\",IF(D18<F18,\"\",IF((D18/F18)>2,CONCATENATE(\"Requires Development Services Manager Review\"),\"\")))","v":""}]
[null,"Irrigation Service Line Size","Meter Size->",null,null,{"$f":"IF(ISBLANK($D$17)=TRUE, \"\",\"Annual Allocation\")","v":""}]
[null,"Enter Total Annual Allocation (gallons per year)",null,null,null,{"$f":"IF(ISBLANK($D$17)=TRUE, \"\",LOOKUP($D$17, 'Reference Tables'!$A$3:$A$9,'Reference Tables'!$J$3:$J$9))","v":""}]
[null,"Irrigation Tap (Industrial/Commercial/MFR) Water Resource Fee may apply",null,{"$f":"IF(ISBLANK($D$17)=TRUE, \"\", LOOKUP($D$17,'Reference Tables'!$A$2:$A$9,'Reference Tables'!$C$2:$C$9)*'Reference Tables'!$A$14)","v":""}]
[null,"Irrigation Water Meter",null,{"$f":"IF(ISBLANK($D$17)=TRUE, \"\", VLOOKUP(LOOKUP(D$17,'Reference Tables'!$A$2:$A$9,'Reference Tables'!$C$2:$C$9),'Reference Tables'!$C$3:$D$9,2))","v":""}]
[null,"Water Service Line Inspections (including meter installation observation)",null,{"$f":"IF(ISBLANK($D$17)=TRUE, \"\", 'Reference Tables'!$A$20)","v":""}]
[null,"Radio Read Meter ",null,{"$f":"IF(ISBLANK($D$17)=TRUE, \"\", 'Reference Tables'!$A$18)","v":""}]
[null,"Water Resource Fee * TEs",{"$f":"IF(ISBLANK($D$17),\"\",IF(ISBLANK($D$18), \"\", IF($D$18>$F$18, ROUND((($D$18-$F$18)/'Reference Tables'!$J$3),2),\"\")))","v":""},{"$f":"IF(ISBLANK($D$17)=TRUE,\"\",IF(ISBLANK(D18), \"\", IF(D18>F18, C23*'Reference Tables'!A26, \"\")))","v":""}]
[null,"Total Irrigation Tap Fee",null,{"$f":"SUM(D19:D23)","v":0}]
[]
[null,"Total Tap Application Fee",null,{"$f":"SUM(D10+D24+D15)","v":0}]
[]
[]
[null,"The tools provided here are for ESTIMATION ONLY.  Final determination of Tap size and"]
[null," costs is the sole responsibility of ACWWA."]

{"sheet":"Reference Tables","index":1,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,1,24,3]]}
["METER SIZE","METER SIZE (Decimal)","TAP EQUIVALENT","Water Meter (updated 12/2025)","Radio Read Meter (Do not Use)","DESIGN CAPACITY (GPM)","WATER SUPPLY AC-FT/YR","Fire/Sewer Line Sizes","WATER\nSUPPLY\nAC-FT/YR","WATER SUPPLY GAL/YR"]
[null,0,0,0,null,0,0]
["¾\"",0.75,1,335,163,14,0.5,"2\"",0.5,{"$f":"ROUND(SUM(7.48051*43560*I3),0)","v":162926}]
["1 \"",1,2,385,209,25,1,"3\"",1,{"$f":"ROUND(SUM(7.48051*43560*I4),0)","v":325851}]
["1 ½\"",1.5,4,1800,440,51,2,"4\"",2,651702]
["2\"",2,8,2034,614,98,4,"6\"",4,1303404]
["3\"",3,18,2632,1000,221,9,"8\"",9,2932659]
["4\"",4,38,7426,null,292,19,"10\"",19,6191169]
["6\"",6,72,7860,null,882,36,null,36,11730637]
[]
[]
[2026,"Rate Increase (rounded)",null,0.03,null,"List Values","Description"]
["Fee","Description",null,null,null,"* Clear to Print *","Message"]
[{"$f":"ROUND(33195*1.03,0)","v":34191},"Potable water service tap fee",null,null,null,null,"Blank to Print"]
[{"$f":"ROUND(33195*1.03,0)","v":34191},"Non-potable water service tap fee",null,null,null,"P","Check Mark"]
[{"$f":"ROUND(8839*1.025,0)","v":9060},"Sewer service tap fee",null,null,null,"Yes","Yes (Default)"]
[14540,"Impervious acre fee",null,null,null,null,"Blank - \"No\""]
[233,"Radio Read Meter fee",null,null,null,0.2,"Local Service"]
[null,"Domestic Water Meter (number is on Table)"]
[320,"Meter Inspection and Installation Observation"]
[500,"Fire Line Service Inspection"]
[100,"Residential Fire Sprinkler Service Inspection (1\")"]
[200,"Sewer Service Line Inspection"]
[null,"Parker Fire Contract Reimbursement"]
[0.28000000000000003,"Multi-family TEs/unit"]
[19979,"Water Resource Fee"]