{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Main","Districts_and_Fees"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":16,"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":"Main","index":0,"n_rows":64,"n_cols":16,"rows_kept":64,"cut":false,"hidden":false,"merged":[[10,4,10,7],[13,0,13,8],[52,0,52,8],[11,3,11,7],[12,0,12,6],[63,0,63,8],[62,0,62,8],[14,0,14,8],[51,0,51,8],[59,4,59,5],[0,0,0,8],[8,4,8,7],[9,4,9,7],[1,5,2,8],[4,6,4,8],[5,6,5,8],[6,0,6,8]]}
["Santa Cruz County Public Works Sewer Connection Fees / All Districts"]
[]
[]
["Please enter the appropriate values in the cells highlighted in yellow and blue (mandatory) on this page."]
["If not applicable, leave blank. Note that for the cell highlighted blue must have a value entered.",null,null,null,null,null,"Date"]
["This is an estimate only. Actual fees may be higher or lower than indicated below."]
["STEP 1 - Enter Parcel and Property Information in the Blue Cells Below"]
["Project Information"]
["CSA / Sanitation District",null,null,null,"-Select_District-"]
["Select Your Type of Property",null,null,null,"-Select_Type-"]
[null,null,null,null,"*Macros Must be Enabled for ADU Calculations*"]
["*If you do not know your Sanitaiton District, view a map here: ",null,null,"http://www.dpw.co.santa-cruz.ca.us/Portals/19/pdfs/Sanitation/Maps/SanitationAllDist.pdf"]
["**Districts: Santa Cruz County, Freedom, Davenport, CSA 2, CSA 5, CSA 7, CSA 10, CSA 20"]
["Please note: Estimates are only for a single property. If you have more than one property, complete a separate form for each property."]
["STEP 2 - Enter Number of Fixtures and Project Information in Yellow Cells Below"]
["RESIDENTIAL"]
["Kitchen",null,"Units",null,"Number of Fixtures"]
["Kitchen Sink (including dishwasher)",null,{"$f":"IF(E10=\"Commercial\",\"N/A\",\"2\")","v":"2"},null,null,"Sub Total",{"$f":"IFERROR(C18*E18,0)","v":0}]
["Dishwasher (independent drain)",null,{"$f":"IF(E10=\"Commercial\",\"N/A\",\"2\")","v":"2"},null,null,"Sub Total",{"$f":"IFERROR(C19*E19,0)","v":0}]
["Bar Sink",null,{"$f":"IF(E10=\"Commercial\",\"N/A\",\"1\")","v":"1"},null,null,"Sub Total",{"$f":"IFERROR(C20*E20,0)","v":0}]
["Drinking Fountain",null,{"$f":"IF(E10=\"Commercial\",\"N/A\",\"0.5\")","v":"0.5"},null,null,"Sub Total",{"$f":"IFERROR(C21*E21,0)","v":0}]
["Veggie Sink",null,{"$f":"IF(E10=\"Commercial\",\"N/A\",\"2\")","v":"2"},null,null,"Sub Total",{"$f":"IFERROR(C22*E22,0)","v":0}]
[]
["Bathroom"]
["Toilet (1.6 GPF gravity flush)",null,{"$f":"IF(E10=\"Commercial\",\"N/A\",\"3\")","v":"3"},null,null,"Sub Total",{"$f":"IFERROR(C25*E25,0)","v":0}]
["Toilet (3.5 GPF gravity flush)",null,{"$f":"IF(E10=\"Commercial\",\"N/A\",\"4\")","v":"4"},null,null,"Sub Total",{"$f":"IFERROR(C26*E26,0)","v":0}]
["Bidet",null,{"$f":"IF(E10=\"Commercial\",\"N/A\",\"1\")","v":"1"},null,null,"Sub Total",0]
["Urinal",null,{"$f":"IF(E10=\"Commercial\",\"N/A\",\"2\")","v":"2"},null,null,"Sub Total",0]
["Shower",null,{"$f":"IF(E10=\"Commercial\",\"N/A\",\"2\")","v":"2"},null,null,"Sub Total",0]
["Tub or Whirlpool Bath",null,{"$f":"IF(E10=\"Commercial\",\"N/A\",\"2\")","v":"2"},null,null,"Sub Total",0]
["Shower/Tub Combo",null,{"$f":"IF(E10=\"Commercial\",\"N/A\",\"2\")","v":"2"},null,null,"Sub Total",0]
["Single Lavatory",null,{"$f":"IF(E10=\"Commercial\",\"N/A\",\"2\")","v":"2"},null,null,"Sub Total",0]
["Double Lavatory",null,{"$f":"IF(E10=\"Commercial\",\"N/A\",\"1\")","v":"1"},null,null,"Sub Total",0]
[]
["Laundry"]
["Washing Machine",null,{"$f":"IF(E10=\"Commercial\",\"N/A\",\"3\")","v":"3"},null,null,"Sub Total",{"$f":"IFERROR(C36*E36,0)","v":0}]
["Utility Sink",null,{"$f":"IF(E10=\"Commercial\",\"N/A\",\"2\")","v":"2"},null,null,"Sub Total",0]
["Floor Drain",null,{"$f":"IF(E10=\"Commercial\",\"N/A\",\"2\")","v":"2"},null,null,"Sub Total",0]
[]
[null,null,null,null,null,"Total",{"$f":"SUM(G18:G38)","v":0}]
[]
["POOL",null,null,null,"Number of Filters"]
["Pool / Spa - Fourplex or less"]
["Pool / Spa - Complex with 5 or more units"]
[]
["AFFORDABLE HOUSING ADJUSTMENT - Contact County Sanitation Staff at 831-454-2160"]
["Affordable housing facilities include facilities specifically constructed for low-income senior citizens, or constructed"]
["for ownership by below-average-income households as as defined by the County Planning Department"]
[]
["COMMERCIAL PROPERTIES",null,null,null,"Gallons per Day"]
["Estimated Water Use**"]
["** A typical small business (such as a small office, retail store, hair salons, etc) uses approximately 250 gpd. \n   Larger businesses will need their actual water flows to accurately calculate gpd."]
["FEE ESTIMATE SUMMARY"]
[]
["Base Connection Fee (Residential)",{"$f":"if","v":{"$error":"#NAME?"}},{"$f":"IF(E10=\"residential\",\"(Includes up to 18 fixture units)\",\"\")","v":""},null,null,null,{"$f":"IF($E$9=\"-Select_District-\",\"\",IF($E$10=\"-Select_Type-\",\"\",IF($G$40=0,0,IF(OR($E$10=\"Residential\",$E$10=\"Residential_and_Commercial\"),VLOOKUP($E$9,Districts_and_Fees!$B$1:$H$10,2,FALSE),0))))","v":""},null,null,null,null,null,null,null,null,"`"]
["Extra Fixture Units (Residential)",null,null,null,null,null,{"$f":"IF($E$9=\"-Select_District-\",\"\",IF($E$10=\"-Select_Type-\",\"\",IF($E$10=\"ADU Conversion\",0,IF($E$10=\"ADU\",VLOOKUP($E$9,Districts_and_Fees!$B:$D,3,FALSE)*$G$40,IF($G$40<18.01,0,VLOOKUP($E$9,Districts_and_Fees!$B:$D,3,FALSE)*($G$40-18))))))","v":""}]
["Base Connection Fee (Commercial)",null,null,null,null,null,{"$f":"IF($E$9=\"-Select_District-\",\"\",IF($E$10=\"-Select_Type-\",\"\",IF($E$51=0,0,IF(OR($E$10=\"Commercial\",$E$10=\"Residential_and_Commercial\"),VLOOKUP($E$9,Districts_and_Fees!B:F,4,FALSE),0))))","v":""}]
["Exta GPD Fee (Commercial)",null,null,null,null,null,{"$f":"IF($E$9=\"-Select_District-\",\"\",IF($E$10=\"-Select_Type-\",\"\",IF(OR($E$10=\"Commercial\",$E$10=\"Residential_and_Commercial\"),IF(VLOOKUP($E$9,Districts_and_Fees!B:F,5,FALSE)*$E$51<VLOOKUP($E$9,Districts_and_Fees!B:F,4,FALSE),0,VLOOKUP($E$9,Districts_and_Fees!B:F,5,FALSE)*$E$51-VLOOKUP($E$9,Districts_and_Fees!B:F,4,FALSE)),0)))","v":""}]
["Swimming Pool",null,null,null,null,null,{"$f":"IF($E$9=\"-Select_District-\",\"\",IF($E$10=\"-Select_Type-\",\"\",(VLOOKUP($E$9,Districts_and_Fees!B:H,6,FALSE)*E43)+(VLOOKUP($E$9,Districts_and_Fees!B:H,7,FALSE)*E44)))","v":""}]
[null,null,null,null,"Connection Fee Total",null,{"$f":"IF($E$9=\"-Select_District-\",\"\",IF($E$10=\"-Select_Type-\",\"\",SUM(G55:G59)))","v":""}]
[]
["Notes:"]
["This spreadsheet is an estimate only. Actual amounts may vary based upon the scope of your project that cannot be accurately reflected in this spreadsheet."]
["Abbreviations: d.u. = Dwelling Unit / f.u. = Fixture Unit / gpd = Gallons per day / CSA = County Service Area"]

{"sheet":"Districts_and_Fees","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Type","District","Base_Connection","Extra_FU","Commercial_Base","Commercial_$/Gal","Pool_Res","Pool_Comm"]
["-Select_Type-","-Select_District-"]
["Residential","Santa_Cruz_County_Sanitation_District",3000,165,3000,12,200,600]
["ADU","Freedom_County_Sanitation_District",4000,200,4000,16]
["Commercial","Davenport_County_Sanitation_District",3000,150,3000,12]
["Residential_and_Commercial","CSA_02_Place_de_Mer"]
[null,"CSA_05_Sand_Dollar"]
[null,"CSA_07_Boulder_Creek",1135,88]
[null,"CSA_10_Rolling_Woods",2000,100]
[null,"CSA_20_Trestle_Beach"]