{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["ReadMe","Table 610.3","Table A 103.1"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"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":"ReadMe","index":0,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Version Date:","2025-02-03"]
["Purpose:","This spreadsheet is required to be filled out for site plan applications that are subject to the Reclaimed Water Connection Requirements and Onsite Water Reuse System Requirements in Section 25-9 of the Land Development Code. While not required for other projects, it may be filled out and submitted with a site plan application to help calculate Water Supply Fixture Units and water demands for a project. This sheet will provide a recommended minumum meter capacity based on applicant's reported fixture counts and peak demands. Meter sizing is ultimately the responsility of the applicant."]
[]
["Notes:","1. Table 610.3 must be used for projects with fewer than 10 toilets/urinals that have flushometer valves. Projects with 10 or more toilets/urinals with flushometer valves may use either Table 610.3 or Table A 103.1."]
[null,"2. These tables are from the 2021 version of the Uniform Plumbing Code, but have been modified slightly for ease of use."]
[null,"3. This calculator assumes projects using non-potable water for clothes washing will have a single cold non-potable supply line that branches off to an on-demand/tankless water heater for each clothes washer. Having a hot potable supply line enter the washing machine from a water heater supplying other potable fixtures creates a potential for backflow and contamination of a building's potable water supply. See the schematic below of the single non-potable supply line to toilets and clothes washers."]

{"sheet":"Table 610.3","index":1,"n_rows":72,"n_cols":19,"rows_kept":72,"cut":false,"hidden":false,"merged":[[58,5,59,7],[62,1,63,8],[58,8,59,8],[57,5,57,7],[56,5,56,7],[1,5,1,8],[36,1,36,6],[37,1,37,6],[54,5,54,7],[55,5,55,7],[7,1,8,8],[9,1,9,2],[10,1,10,2],[19,1,20,1],[23,1,24,1],[28,1,29,1],[44,7,47,8],[5,6,5,8],[6,1,6,8]]}
[]
[null,"Site Plan Case Number:",null,"Project Address:"]
[]
[null,"Step 1. Will this project use reclaimed or onsite water indoors?",null,null,"Will this project apply for OWRS fee in lieu?"]
[]
[]
[null,{"$f":"IF(AND(B6=\"no\",F6=\"NO\"),\"if answer is no to both above questions, skip to Step 4\",\"\")","v":""}]
[null,"Step 2. Fill out the \"Total Number of Fixtures\" column for your project and indicate the Water Supply Type in the table to get a total water supply fixture unit count by supply type (potable vs. non-potable). Fee in lieu projects must select \"Non-potable\" for urinals and water closets."]
[]
[null,"Fixture Type",null,"Total Number of Fixtures",null,"Water Supply Fixture Units (WSFU)",null,"Total WSFU",{"$f":"IF(F6=\"yes\",\"Fixtures to be served by future reclaimed\",\"Water Supply Type\")","v":"Water Supply Type"},null,"Yes"]
[null,null,null,null,null,"hot and cold",null,null,null,null,"No"]
[null,"Bathtub or Combination Bath/Shower",null,null,"x",4,"=",{"$f":"F12*D12","v":0},"Potable",null,null,null,null,null,null,null,null,null,"Potable"]
[null,"Bathtub with 3/4\" fill valve",null,null,"x",10,"=",0,"Potable",null,null,null,null,null,null,null,null,null,"Non-potable"]
[null,"Bidet",null,null,"x",1,"=",0,"Potable"]
[null,"Clothes Washer",null,null,"x",4,"=",0,"Non-potable"]
[null,"Dishwasher, domestic",null,null,"x",1.5,"=",0,"Potable"]
[null,"Drinking Fountain or Water Cooler",null,null,"x",0.5,"=",0,"Potable"]
[null,"Lavatory",null,null,"x",1,"=",0,"Potable"]
[null,"Sinks"]
[null,"Bar","Public",null,"x",2,"=",{"$f":"F20*D20","v":0},"Potable"]
[null,null,"Private",null,"x",1,"=",0,"Potable"]
[null,"Kitchen, domestic",null,null,"x",1.5,"=",0,"Potable"]
[null,"Laundry",null,null,"x",1.5,"=",0,"Potable"]
[null,"Service or mop basin","Public",null,"x",3,"=",0,"Potable"]
[null,null,"Private",null,"x",1.5,"=",0,"Potable"]
[null,"Washup basin",null,null,"x",2,"=",0,"Potable"]
[null,"Shower, per head",null,null,"x",2,"=",0,"Potable"]
[null,"Urinal, 1.0 GPF flushometer valve",null,null,"x","20,15,10,8,5","=",{"$f":"IF(D28>4,53+5*(D28-4),IF(D28>3,53,IF(D28>2,45,IF(D28>1,35,IF(D28>0,20,0)))))","v":0},"Non-potable"]
[null,"Water Closet, 1.6 GPF ","Flushometer Valve",null,"x","40,30,20,15,10","=",{"$f":"IF(D29>4,105+10*(D29-4),IF(D29>3,105,IF(D29>2,90,IF(D29>1,70,IF(D29>0,40,0)))))","v":0},"Non-potable"]
[null,null,"Tank Type",null,"x",2.5,"=",{"$f":"F30*D30","v":0},"Non-potable"]
[null,"First Hose Bibb",null,null,"x",2.5,"=",{"$f":"F31*D31","v":0},"Potable"]
[null,"Hose Bibb, each additional",null,null,"x",1,"=",0,"Potable"]
[null,null,null,null,"x",null,"=",0]
[null,null,null,null,"x",null,"=",0]
[null,null,null,null,"x",null,"=",{"$f":"F35*D35","v":0}]
[null,null,null,null,"x",null,"=",0]
[null,"Total Fixture Units (WSFU) ",null,null,null,null,null,{"$f":"SUMIF(I12:I36,\"Potable\",H12:H37)","v":0},"Potable"]
[null,"Total Fixture Units (WSFU) ",null,null,null,null,null,{"$f":"SUMIF(I12:I36,\"Non-potable\",H12:H36)","v":0},"Non-potable"]
[]
[null,"Step 3. Convert WSFU to gpm for each supply type",null,"Potable WSFU","=",{"$f":"H37","v":0},"->",200,"gpm"]
[null,"using Chart A 103.1 from the 2021 UPC.",null,"Non-potable WSFU","=",{"$f":"H38","v":0},"->",200,"gpm"]
[]
[null,"Step 4. Specify additional peak demands from water use by supply type (select Supply Type). F."]
[]
[null,"Additional Water Use","Peak Demand","Flow Rate",null,"Supply Type",null,"Note: it is the applicant's responsibility to report accurate peak demand in order to get appropriate meter sizing recommendations. AW will not confirm numbers provided."]
[null,"Process water or special use water",null,"gpm  ",null,"Non-potable"]
[null,"Cooling tower makeup water",null,"gpm  ",null,"Non-potable"]
[null,"Irrigation system ",null,"gpm  ",null,"Non-potable"]
[]
[null,"Step 5. Select the type of non-potable water supply system to add the demands for each required meter (select Yes or No). "]
[]
[null,"Reclaimed Water System",null,null,null,null,null,"Onsite Water Reuse System/Fee in Lieu",null,null,null,null,null,"Yes"]
[null,null,null,"*OR*",null,null,null,null,null,null,null,null,null,"No"]
[]
[null,"Required Meter Types","Recommended minimum meter capacity (GPM)",null,null,"Required Meter Types",null,null,"Recommended minimum meter capacity (GPM)"]
[null,"Domestic potable water meter",{"$f":"IF(B6=\"no\", \"applicant to size meter\",IF(I52=\"Yes\",H40+IF(F46=\"Potable\",C46,0)+IF(F47=\"Potable\",C47,0),0))","v":0},null,null,"Domestic potable meter",null,null,{"$f":"IF(B6=\"no\", \"applicant to size meter\",IF(I52=\"Yes\",H40+IF(F46=\"Potable\",C46,0)+IF(F47=\"Potable\",C47,0),0))","v":0}]
[null,"Reclaimed domestic meter",{"$f":"IF(C52=\"Yes\",H41+IF(F46=\"Non-potable\",C46,0)+IF(F47=\"Non-potable\",C47,0),0)","v":0},null,null,{"$f":"IF(F6=\"Yes\", \"Domestic potable meter (to serve NP fixtures)\",\"Potable back-up to OWRS NP meter\")","v":"Potable back-up to OWRS NP meter"},null,null,{"$f":"IF(I52=\"Yes\",H41+IF(F46=\"Non-potable\",C46,0)+IF(F47=\"Non-potable\",C47,0)+IF(F48=\"Non-potable\",C48,0),0)","v":0}]
[null,"Reclaimed irrigation meter",{"$f":"IF(C52=\"Yes\",C48,0)","v":0},null,null,{"$f":"IF(F48=\"Potable\",\"Potable Irrigation meter\",\"\")","v":""},null,null,{"$f":"IF(F58=\"\",\"\",C48)","v":""}]
[null,null,null,null,null,"Reclaimed main size needed for OWRS fee in lieu",null,null,{"$f":"IF(F6=\"Yes\",(IF(AND(I57>0,I57<442),6, IF(AND(I57>441, I57<784),8, IF(AND(I57>783, I57<1764),12, IF(AND(I57>1763, I57<3134),16,0))))),\"NA\")","v":"NA"}]
[]
[]
[null,"Step 6. Please email complete sheet to AW_ONSITEREUSE@austintexas.gov for approval"]
[null,"Step 7. Determine the appropriate sized meters to meet the demands and add them to the Meter Notice Table on the AW Standard Notes sheet along with a printout of this sheet."]
[]
[null,"Austin Water Staff Review"]
[null,null,"Signature:",null,null,null,null,"Date:"]
[null,"Type of Service/Rate:"]
[null,"(SP)       O Mandatory      O Non-mandatory      O Rainwater      O Graywater"]
[null,"(SA)       O  Residential      O  Commercial       O  City of Austin    O   Parkland",null,null,null,null,null,"Fee in lieu $",{"$f":"IF(I59=\"NA\",\"\",I59*40.16*500)","v":""}]
[null,"Potable Domestic Wastewater Flow Factor: O NA     O _____"]
[]
[null,"For Utility Permitting Office, reach out to AW_onsitereuse@austintexas.gov with questions at time of meter purchase"]

{"sheet":"Table A 103.1","index":2,"n_rows":72,"n_cols":21,"rows_kept":72,"cut":false,"hidden":false,"merged":[[36,1,36,6],[6,1,6,8],[57,5,57,7],[58,5,59,7],[58,8,59,8],[37,1,37,6],[62,1,63,8],[55,5,55,7],[56,5,56,7],[54,5,54,7],[44,7,47,8],[52,5,52,7],[1,5,1,8],[9,1,9,2],[10,1,10,2],[28,1,29,1],[19,1,20,1],[7,1,8,8],[23,1,24,1]]}
[]
[null,"Site Plan Case Number:",null,"Project Address:"]
[]
[null,"Step 1. Will this project use reclaimed or onsite water indoors?",null,null,"Will this project apply for OWRS fee in lieu?"]
[]
[]
[null,{"$f":"IF(AND(B6=\"no\",F6=\"NO\"),\"if answer is no to both above questions, skip to Step 4\",\"\")","v":""}]
[null,"Step 2. Fill out the \"Total Number of Fixtures\" column for your project and indicate the Water Supply Type in the table to get a total water supply fixture unit count by supply type (potable vs. non-potable). Fee in lieu projects must select \"Non-potable\" for urinals and water closets."]
[]
[null,"Fixture Type",null,"Total Number of Fixtures",null,"Water Supply Fixture Units (WSFU)",null,"Total WSFU",{"$f":"IF(F6=\"yes\",\"Fixtures to be served by future reclaimed\",\"Water Supply Type\")","v":"Water Supply Type"},null,"Yes"]
[null,null,null,null,null,"hot and cold",null,null,null,null,"No"]
[null,"Bathtub or Combination Bath/Shower",null,null,"x",4,"=",{"$f":"F12*D12","v":0},"Potable",null,null,null,null,null,null,null,null,null,"Potable"]
[null,"Bathtub with 3/4\" fill valve",null,null,"x",10,"=",0,"Potable",null,null,null,null,null,null,null,null,null,"Non-potable"]
[null,"Bidet",null,null,"x",1,"=",0,"Potable"]
[null,"Clothes Washer",null,null,"x",4,"=",0,"Non-potable"]
[null,"Dishwasher, domestic",null,null,"x",1.5,"=",0,"Potable"]
[null,"Drinking Fountain or Water Cooler",null,null,"x",0.5,"=",0,"Potable"]
[null,"Lavatory",null,null,"x",1,"=",0,"Potable"]
[null,"Sinks"]
[null,"Bar","Public",null,"x",2,"=",{"$f":"F20*D20","v":0},"Potable"]
[null,null,"Private",null,"x",1,"=",0,"Potable"]
[null,"Kitchen, domestic",null,null,"x",1.5,"=",0,"Potable"]
[null,"Laundry",null,null,"x",1.5,"=",0,"Potable",null,null,null,null,null,null,null,null,null,null,null,"10 or more toilets/urinals use App. A"]
[null,"Service or mop basin","Public",null,"x",3,"=",0,"Potable"]
[null,null,"Private",null,"x",1.5,"=",0,"Potable"]
[null,"Washup basin",null,null,"x",2,"=",0,"Potable",null,null,null,null,null,null,null,null,null,null,null,"This one is not for small systems."]
[null,"Shower, per head",null,null,"x",2,"=",0,"Potable"]
[null,"Urinal, 1.0 GPF flushometer valve",null,null,"x",4,"=",{"$f":"F28*D28","v":0},"Non-potable"]
[null,"Water Closet, 1.6 GPF ","Flushometer Valve",null,"x",5,"=",{"$f":"F29*D29","v":0},"Non-potable"]
[null,null,"Tank Type",null,"x",2.5,"=",{"$f":"F30*D30","v":0},"Non-potable"]
[null,"First Hose Bibb",null,null,"x",2.5,"=",{"$f":"F31*D31","v":0},"Potable"]
[null,"Hose Bibb, each additional",null,null,"x",1,"=",0,"Potable"]
[null,null,null,null,"x",null,"=",0]
[null,null,null,null,"x",null,"=",0]
[null,null,null,null,"x",null,"=",{"$f":"F35*D35","v":0}]
[null,null,null,null,"x",null,"=",0]
[null,"Total Fixture Units (WSFU) ",null,null,null,null,null,{"$f":"SUMIF(I12:I36,\"Potable\",H12:H37)","v":0},"Potable"]
[null,"Total Fixture Units (WSFU) ",null,null,null,null,null,{"$f":"SUMIF(I12:I36,\"Non-potable\",H12:H36)","v":0},"Non-potable"]
[]
[null,"Step 3. Convert WSFU to gpm for each supply type",null,"Potable WSFU","=",{"$f":"H37","v":0},"->",null,"gpm"]
[null,"using Chart A 103.1 from the 2021 UPC.",null,"Non-potable WSFU","=",{"$f":"H38","v":0},"->",null,"gpm"]
[]
[null,"Step 4. Specify additional peak demands from water use by supply type (select Supply Type)."]
[]
[null,"Additional Water Use","Peak Demand","Flow Rate",null,"Supply Type",null,"Note: it is the applicant's responsibility to report accurate peak demand in order to get appropriate meter sizing recommendations. AW will not confirm numbers provided."]
[null,"Process water or special use water",null,"gpm  ",null,"Non-potable"]
[null,"Cooling tower makeup water",null,"gpm  ",null,"Non-potable"]
[null,"Irrigation system ",null,"gpm  ",null,"Non-potable"]
[]
[null,"Step 5. Select the type of non-potable water supply system to add the demands for each required meter (select Yes or No). "]
[]
[null,"Reclaimed Water System",null,null,null,null,null,"Onsite Water Reuse System/Fee in Lieu",null,null,null,null,null,"Yes"]
[null,null,null,"*OR*",null,null,null,null,null,null,null,null,null,"No"]
[]
[null,"Required Meter Types","Recommended minimum meter capacity (GPM)",null,null,"Required Meter Types",null,null,"Recommended minimum meter capacity (GPM)"]
[null,"Domestic potable water meter",{"$f":"IF(B6=\"no\", \"applicant to size meter\",IF(F6=\"Yes\",H40+IF(F46=\"Potable\",C46,0)+IF(F47=\"Potable\",C47,0),0))","v":0},null,null,"Domestic potable meter",null,null,{"$f":"IF(B6=\"no\", \"applicant to size meter\",IF(I52=\"Yes\",H40+IF(F46=\"Potable\",C46,0)+IF(F47=\"Potable\",C47,0),0))","v":0}]
[null,"Reclaimed domestic meter",{"$f":"IF(C52=\"Yes\",H41+IF(F46=\"Non-potable\",C46,0)+IF(F47=\"Non-potable\",C47,0),0)","v":0},null,null,{"$f":"IF(F6=\"Yes\", \"Domestic potable meter (to serve NP fixtures)\",\"Potable back-up to OWRS NP meter\")","v":"Potable back-up to OWRS NP meter"},null,null,{"$f":"IF(I52=\"Yes\",H41+IF(F46=\"Non-potable\",C46,0)+IF(F47=\"Non-potable\",C47,0)+IF(F48=\"Non-potable\",C48,0),0)","v":0}]
[null,"Reclaimed irrigation meter",{"$f":"IF(C52=\"Yes\",C48,0)","v":0},null,null,{"$f":"IF(F48=\"Potable\",\"Potable Irrigation meter\",\"\")","v":""},null,null,{"$f":"IF(F58=\"\",\"\",C48)","v":""}]
[null,null,null,null,null,"Reclaimed main size needed for OWRS fee in lieu",null,null,{"$f":"IF(F6=\"Yes\",(IF(AND(I57>0,I57<442),6, IF(AND(I57>441, I57<784),8, IF(AND(I57>783, I57<1764),12, IF(AND(I57>1763, I57<3134),16,0))))),\"NA\")","v":"NA"}]
[]
[]
[null,"Step 6. Please email complete sheet to AW_ONSITEREUSE@austintexas.gov for approval"]
[null,"Step 7. Determine the appropriate sized meters to meet the demands and add them to the Meter Notice Table on the AW Standard Notes sheet along with a printout of this sheet."]
[]
[null,"Austin Water Staff Review"]
[null,null,"Signature:",null,null,null,null,"Date:"]
[null,"Type of Service/Rate:"]
[null,"(SP)       O Mandatory      O Non-mandatory      O Rainwater      O Graywater"]
[null,"(SA)       O  Residential      O  Commercial       O  City of Austin    O   Parkland",null,null,null,null,null,"Fee in lieu $",{"$f":"IF(I58=\"NA\",\"\",I58*40.16*500)","v":{"$error":"#VALUE!"}}]
[null,"Potable Domestic Wastewater Flow Factor: O NA     O _____"]
[]
[null,"For Utility Permitting Office, reach out to AW_onsitereuse@austintexas.gov with questions at time of meter purchase"]