{"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":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,1,2,2],[0,1,0,3],[30,1,30,3],[31,1,31,3]]}
[null,"ACWWA 2026 Water and Sewer Tap Fee Estimator",null,null,null,"Enter Value in Green Shaded Cells"]
[]
[null,"Number of TEs served/charged per meter size -------------------------->",null,{"$f":"IF(ISBLANK($D$4)=TRUE, \"\", LOOKUP(D4,'Reference Tables'!A3:A9,'Reference Tables'!C3:C9))","v":""}]
[null,"Water Service Line Size","Meter Size->"]
[null,"Maximum gpm @ 10fps velocity","gpm->",{"$f":"IF(ISBLANK($D$4)=TRUE, \"\", LOOKUP($D$4,'Reference Tables'!$A$3:$A$9,'Reference Tables'!$F$3:$F$9))","v":""}]
[null,"DomesticTap",null,{"$f":"IF(ISBLANK($D$4)=TRUE, \"\", LOOKUP($D$4,'Reference Tables'!$A$2:$A$9,'Reference Tables'!$C$2:$C$9)*'Reference Tables'!$A$14)","v":""}]
[null,"Domestic Water Meter",null,{"$f":"IF(ISBLANK($D$4)=TRUE, \"\", VLOOKUP(LOOKUP(D$4,'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$4)=TRUE, \"\", 'Reference Tables'!$A$20)","v":""}]
[null,"Radio Read Meter ",null,{"$f":"IF(ISBLANK($D$4)=TRUE, \"\", 'Reference Tables'!$A$18)","v":""}]
[null,"Fire Line Service Inspection (if required)",null,{"$f":"IF(ISBLANK($D$4)=TRUE, \"\", IF($C$10=\"No\", 0, 'Reference Tables'!$A$21))","v":""}]
[null,"Total Domestic Tap Fee",null,{"$f":"SUM(D6:D10)","v":0}]
[]
[null,"Wastewater Service (based upon Domestic water meter size)","Line Size->"]
[null,"Sewer Tap",null,{"$f":"IF(AND(ISBLANK($D$4)=FALSE, ISBLANK($D$13)=FALSE),LOOKUP($D$4,'Reference Tables'!$A$2:$A$9,'Reference Tables'!$C$2:$C$9)*'Reference Tables'!$A$16,\"\")","v":""}]
[null,"Sewer Service Line Inspection",null,{"$f":"IF(AND(ISBLANK($D$4)=FALSE, ISBLANK($D$13)=FALSE),'Reference Tables'!$A$23,\"\")","v":""}]
[null,"Total Sewer Tap Fee",null,{"$f":"SUM(D14:D15)","v":0}]
[null,null,null,null,null,{"$f":"IF(ISBLANK($D$19)=TRUE,\"\",IF(D19<F19,\"\",IF((D19/F19)>2,CONCATENATE(\"Requires Board Approval\"),\"\")))","v":""}]
[null,"Irrigation Service Line Size","Meter Size->",null,null,{"$f":"IF(ISBLANK($D$18)=TRUE, \"\",\"Annual Allocation\")","v":""}]
[null,"Enter Total Annual Allocation (gallons per year)",null,null,null,{"$f":"IF(ISBLANK($D$18)=TRUE, \"\",LOOKUP($D$18, 'Reference Tables'!$A$3:$A$9,'Reference Tables'!$J$3:$J$9))","v":""}]
[null,"Maximum gpm @ 10fps velocity","gpm->",{"$f":"IF(ISBLANK($D$18)=TRUE, \"\", LOOKUP($D$18,'Reference Tables'!$A$3:$A$9,'Reference Tables'!$F$3:$F$9))","v":""}]
[null,"Irrigation Tap (Industrial/Commercial/MFR) Water Resource Fee may apply",null,{"$f":"IF(ISBLANK($D$18)=TRUE, \"\", LOOKUP($D$18,'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$18)=TRUE, \"\", VLOOKUP(LOOKUP(D$18,'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$18)=TRUE, \"\", 'Reference Tables'!$A$20)","v":""}]
[null,"Radio Read Meter ",null,{"$f":"IF(ISBLANK($D$18)=TRUE, \"\", 'Reference Tables'!$A$18)","v":""}]
[null,"Water Resource Fee * TEs",{"$f":"IF(ISBLANK($D$18),\"\",IF(ISBLANK($D$19), \"\", IF($D$19>$F$19, ROUND((($D$19-$F$19)/'Reference Tables'!$J$3),2),\"\")))","v":""},{"$f":"IF(ISBLANK($D$18)=TRUE,\"\",IF(ISBLANK(D19), \"\", IF(D19>F19, C25*'Reference Tables'!A25, \"\")))","v":""}]
[null,"Total Irrigation Tap Fee",null,{"$f":"SUM(D21:D25)","v":0}]
[]
[null,"Total Tap Application Fee",null,{"$f":"SUM(D11+D26+D16)","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":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["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\nSUPPLY\nGAL/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"]
[0,"Parker Fire Contract Reimbursement"]
[19979,"Water Resource Fee"]