{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Base Calc","Group 1","Summary D+C","Summary O+M"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":10,"comments":3,"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":"Instructions","index":0,"n_rows":46,"n_cols":25,"rows_kept":46,"cut":false,"hidden":false,"merged":[[35,2,35,17],[30,2,30,4],[24,20,24,24],[31,2,31,4],[32,2,32,4],[24,13,24,17],[24,10,24,11],[24,6,24,9],[24,5,25,5],[25,6,25,7],[25,8,25,9],[24,2,25,4],[26,2,26,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[5,4,5,11],[2,4,2,11],[10,4,10,11],[6,4,6,11],[19,4,19,11],[15,4,15,11],[13,4,13,11],[9,4,9,9]]}
[]
[]
[null,null,null,null,"Indoor Water Use Reduction Calculator\nLEED v4 WE Prerequisite Indoor Water Use Reduction and WE Credit Indoor Water Use Reduction"]
[]
[null,null,null,null,"Step 1. "]
[null,null,null,null,"Enable macros."]
[null,null,null,null,"Note: This calculator is for use with Excel for Mac 2011 and Excel 2007 or later."]
[]
[null,null,null,null,"Step 2. "]
[null,null,null,null,"Unit of measurement",null,null,null,null,null,null,"IP units"]
[null,null,null,null,"Note: This selection must match the unit of measurement chosen during project registration."]
[]
[null,null,null,null,"Step 3. "]
[null,null,null,null,"Complete the Flush and/or Flow tables on the Group tab."]
[]
[null,null,null,null,"Note: Projects with extremely complex occupancy and/or fixture usage patterns (such as where different types of occupants have different annual days of operation and use fixtures with differing flush and flow rates within the building) may complete a separate calculator tab to represent the usage for complex scenarios. "]
[]
[]
[null,null,null,null,"Step 4. "]
[null,null,null,null,"Upload the completed spreadsheet to LEED Online.  Complete any related summary fields in the LEED credit form with the results of the calculator."]
[]
[]
[]
[null,null,"Assumptions"]
[null,null,"Fixture Type",null,null,"Gender","Maximum Installed Flush/Flow Rate",null,null,null,"Duration",null,null,"Uses per Day",null,null,null,null,null,null,"DEFAULT Uses per Day"]
[null,null,null,null,null,null,"IP",null,"SI",null,"Non-\nResidential \n(sec)","Residential\n(sec)",null,"Employees\n(FTE)","Visitors","Retail Customers","Students","Residential",null,null,"Employees\n(FTE)","Visitors","Retail Customers","Students","Residential"]
[null,null,"Toilet ",null,null,"Male",1.6,"gpf",6,"lpf","n/a","n/a",null,1,0.1,0.1,1,5,null,null,1,0.1,0.1,1,5]
[null,null,"Toilet ",null,null,"Female",1.6,"gpf",6,"lpf","n/a","n/a",null,3,0.5,0.2,3,5,null,null,3,0.5,0.2,3,5]
[null,null,"Urinal",null,null,"Male",1,"gpf",3.8,"lpf","n/a","n/a",null,2,0.4,0.1,2,0,null,null,2,0.4,0.1,2,0]
[null,null,"Public lavatory (restroom) faucet",null,null,"n/a",0.5,"gpm",1.9,"lpm",30,0,null,3,0.5,0.2,3,0,null,null,3,0.5,0.2,3,0]
[null,null,"Private lavatory faucet",null,null,"n/a",2.2000000000000002,"gpm",8.3000000000000007,"lpm",30,60,null,0,0,0,0,5,null,null,0,0,0,0,5]
[null,null,"Kitchen faucet",null,null,"n/a",2.2000000000000002,"gpm",8.3000000000000007,"lpm",15,60,null,1,0,0,0,4,null,null,1,0,0,0,4]
[null,null,"Showerhead",null,null,"n/a",2.5,"gpm",9.5,"lpm",300,480,null,0.1,0,0,0,1,null,null,0.1,0,0,0,1]
[null,null,true]
[null,null,"Default uses per day"]
[null,null,"Default uses can be modified in special circumstances. Provide a narrative in the special circumstances section of the LEED credit form explaining the modifications. Baseline and installed case usage values must match and cannot be modified independently.  Non-default uses are italicized."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V01",null,"UOM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copyright © 2012",null,{"$f":"IF(L10=\"IP units\",1,2)","v":1},"1 = IP, 2 = SI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U.S. Green Building Council"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All Rights Reserved",null,null,"Toilet ","Urinal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toilet ","Conventional Water Closet","Conventional Urinal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urinal","Low-Flow Water Closet","Low-Flow Urinal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dual-Flush Water Closet","Non-Water Urinal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Composting Toilet"]

{"sheet":"Base Calc","index":1,"n_rows":64,"n_cols":31,"rows_kept":64,"cut":false,"hidden":true,"merged":[[4,1,4,8],[7,1,7,2],[8,1,8,2],[6,1,6,2],[10,1,10,7],[9,1,9,8],[6,24,7,24],[4,27,4,28],[4,29,4,30],[24,1,25,2],[51,1,52,2],[42,20,42,21],[42,23,43,23],[41,1,41,23],[8,24,9,24],[16,1,17,1],[16,6,17,6],[16,7,17,7],[19,2,19,5],[16,2,17,5],[18,2,18,5],[16,8,17,8],[55,1,55,23],[56,7,56,8],[56,10,56,11],[56,12,56,13],[56,14,56,15],[56,16,56,17],[56,18,56,19],[56,20,56,21],[56,23,57,23],[56,1,57,1],[56,5,56,6],[56,4,57,4],[56,3,57,3],[56,2,57,2],[47,2,47,4],[42,8,43,8],[42,2,43,4],[42,5,43,5],[12,1,12,7],[29,1,30,1],[42,1,43,1],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[20,2,20,5],[29,2,30,3],[31,2,31,3],[29,4,30,4],[45,2,45,4],[46,2,46,4],[29,8,30,8],[29,5,29,6],[29,7,30,7],[29,23,30,23],[42,16,42,17],[42,18,42,19],[44,2,44,4],[42,6,42,7],[42,10,42,11],[42,12,42,13],[42,14,42,15],[11,1,11,8],[16,12,16,13],[28,1,28,23],[15,1,15,23],[29,10,29,11],[29,14,29,15],[29,16,29,17],[29,18,29,19],[29,20,29,21],[16,20,16,21],[16,23,17,23],[16,10,16,11],[29,12,29,13],[16,14,16,15],[16,16,16,17],[16,18,16,19]]}
[]
[null,{"$f":"REPLACE(CELL(\"filename\",A1),1,FIND(\"]\",CELL(\"filename\",A1)),\"\")","v":"Base Calc"}]
[]
[null,"Table 1. Project Information"]
[null,"Enter project occupancy information.  This information should be consistent with occupancy numbers used in other LEED credits.  The default gender mix is half male and half female.  If necessary, modify the Male and Female occupant type columns for non-default gender mix. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FLUSH",null,"FLOW"]
[null,null,null,"Employees\n (FTE)","Visitors","Retail Customers","Students\n(For Schools only)","Residential","Other (specify)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ref # if included","ref list w/o blanks","ref # if included","ref list w/o blanks"]
[null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Baseline","Flush",{"$f":"I22","v":0},{"$f":"IF(I19=\"Yes\",B19,\"\")","v":""},{"$f":"IFERROR(INDEX(AB7:AB9,SMALL((IF(LEN(AB7:AB9),ROW(INDIRECT(\"1:\"&ROWS(AB7:AB9))))),ROW(A1)),1),\"\")","v":""},{"$f":"IF(I45=\"Yes\",B45,\"\")","v":""},{"$f":"IFERROR(INDEX(AD7:AD10,SMALL((IF(LEN(AD7:AD10),ROW(INDIRECT(\"1:\"&ROWS(AD7:AD10))))),ROW(A1)),1),\"\")","v":""}]
[null,"Male",null,{"$f":"D7/2","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow",{"$f":"I49","v":0},{"$f":"IF(I20=\"Yes\",B20,\"\")","v":""},{"$f":"IFERROR(INDEX(AB7:AB9,SMALL((IF(LEN(AB7:AB9),ROW(INDIRECT(\"1:\"&ROWS(AB7:AB9))))),ROW(A2)),1),\"\")","v":""},{"$f":"IF(I46=\"Yes\",B46,\"\")","v":""},{"$f":"IFERROR(INDEX(AD7:AD10,SMALL((IF(LEN(AD7:AD10),ROW(INDIRECT(\"1:\"&ROWS(AD7:AD10))))),ROW(A2)),1),\"\")","v":""}]
[null,"Female",null,{"$f":"D7/2","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Design","Flush",{"$f":"I37","v":0},{"$f":"IF(I21=\"Yes\",B21,\"\")","v":""},{"$f":"IFERROR(INDEX(AB7:AB9,SMALL((IF(LEN(AB7:AB9),ROW(INDIRECT(\"1:\"&ROWS(AB7:AB9))))),ROW(A3)),1),\"\")","v":""},{"$f":"IF(I47=\"Yes\",B47,\"\")","v":""},{"$f":"IFERROR(INDEX(AD7:AD10,SMALL((IF(LEN(AD7:AD10),ROW(INDIRECT(\"1:\"&ROWS(AD7:AD10))))),ROW(A3)),1),\"\")","v":""}]
[null,"Determine the percent of males expected to use urinals (enter 100% if all male restrooms have urinals, 0% if the project contains no urinals, etc)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow",{"$f":"I64","v":0},null,null,{"$f":"IF(I48=\"Yes\",B48,\"\")","v":""},{"$f":"IFERROR(INDEX(AD7:AD10,SMALL((IF(LEN(AD7:AD10),ROW(INDIRECT(\"1:\"&ROWS(AD7:AD10))))),ROW(A4)),1),\"\")","v":""}]
[null,"Percent of males expected to use restrooms with urinals ",null,null,null,null,null,null,1]
[null,"Enter the number of days the project is accessible to employees or FTE."]
[null,"Annual days of operation ",null,null,null,null,null,null,365]
[null,{"$f":"IF(I13>365,\"Annual days of operation must be between 1 and 365.\",\"\")","v":""}]
[null,"Table 2. Flush Fixtures Baseline Case"]
[null,"1. Indicate whether the Fixture Type is present on the project using the Included in Project column.\n2. If necessary, modify the Uses per Day column for non-default uses."]
[null,"Fixture Reference","Baseline Case Fixture Type",null,null,null,"Gender",{"$f":"IF(Instructions!U40=1,\"Default Flush Rate \n(gpf)\",\"Default Flush Rate \n(lpf)\")","v":"Default Flush Rate \n(gpf)"},"Included \nin Project",null,"Employees (FTE)",null,"Visitors",null,"Retail Customers",null,"Students",null,"Residential",null,{"$f":"IF($I$6=\"Other (please specify)\",\"Other\",$I$6)","v":"Other (specify)"},null,null,{"$f":"IF(Instructions!$U$40=1,\"Total Daily Water Use \n(gpf)\",\"Total Daily Water Use \n(lpf)\")","v":"Total Daily Water Use \n(gpf)"}]
[null,null,null,null,null,null,null,null,null,null,"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"}]
[null,"_1",{"$f":"Instructions!$C$27","v":"Toilet "},null,null,null,{"$f":"Instructions!$F$27","v":"Male"},{"$f":"IF(Instructions!$U$40=1,Instructions!$G$27,Instructions!$I$27)","v":1.6},null,null,{"$f":"Instructions!N27+((1-I11)*Instructions!N28)","v":1},{"$f":"H19*D8*K19","v":0},{"$f":"Instructions!O27+((1-I11)*Instructions!O28)","v":0.1},{"$f":"$H19*E8*M19","v":0},{"$f":"Instructions!P27+((1-I11)*Instructions!P28)","v":0.1},{"$f":"$H19*F8*O19","v":0},{"$f":"Instructions!Q27+((1-I11)*Instructions!Q28)","v":1},{"$f":"$H19*G8*Q19","v":0},{"$f":"Instructions!R27+((1-I11)*Instructions!R28)","v":5},{"$f":"$H19*H8*S19","v":0},null,{"$f":"$H19*I8*U19","v":0},null,{"$f":"IF(I19=\"Yes\",SUM(L19,R19,N19,P19,T19,V19),0)","v":0}]
[null,"_2",{"$f":"Instructions!$C$28","v":"Toilet "},null,null,null,{"$f":"Instructions!$F$28","v":"Female"},{"$f":"IF(Instructions!$U$40=1,Instructions!$G$28,Instructions!$I$28)","v":1.6},null,null,{"$f":"Instructions!$N$28","v":3},{"$f":"H20*D9*K20","v":0},{"$f":"Instructions!$O$28","v":0.5},{"$f":"$H20*E9*M20","v":0},{"$f":"Instructions!$P$28","v":0.2},{"$f":"$H20*F9*O20","v":0},{"$f":"Instructions!$Q$28","v":3},{"$f":"$H20*G9*Q20","v":0},{"$f":"Instructions!$R$28","v":5},{"$f":"$H20*H9*S20","v":0},null,{"$f":"$H20*I9*U20","v":0},null,{"$f":"IF(I20=\"Yes\",SUM(L20,R20,N20,P20,T20,V20),0)","v":0}]
[null,"_3",{"$f":"Instructions!$C$29","v":"Urinal"},null,null,null,{"$f":"Instructions!$F$29","v":"Male"},{"$f":"IF(Instructions!$U$40=1,Instructions!$G$29,Instructions!$I$29)","v":1},null,null,{"$f":"Instructions!N29*I11","v":2},{"$f":"H21*D8*K21","v":0},{"$f":"Instructions!O29*I11","v":0.4},{"$f":"$H21*E8*M21","v":0},{"$f":"Instructions!P29*I11","v":0.1},{"$f":"$H21*F8*O21","v":0},{"$f":"Instructions!Q29*I11","v":2},{"$f":"$H21*G8*Q21","v":0},{"$f":"Instructions!$R$29*I11","v":0},{"$f":"$H21*H8*S21","v":0},null,{"$f":"$H21*I8*U21","v":0},null,{"$f":"IF(I21=\"Yes\",SUM(L21,R21,N21,P21,T21,V21),0)","v":0}]
[null,{"$f":"IF(Instructions!$U$40=1,\"Baseline case annual flush volume (gallons/year)\",\"Baseline case annual flush volume (liters/year)\")","v":"Baseline case annual flush volume (gallons/year)"},null,null,null,null,null,null,{"$f":"(SUM(X19:X21)*$I$13)","v":0}]
[]
[null,"For projects with dual-flush toilets"]
[null,"Enter the resulting per flush rate into the design case flush rate section for toilet.",null,{"$f":"IF(Instructions!$U$40=1,\"Low Flush\n(gpf)\",\"Low Flush\n(lpf)\")","v":"Low Flush\n(gpf)"},{"$f":"IF(Instructions!$U$40=1,\"High Flush\n(gpf)\",\"High Flush\n(lpf)\")","v":"High Flush\n(gpf)"},{"$f":"IF(Instructions!$U$40=1,\"Average Flush Rate\n(gpf)\",\"Average Flush Rate\n(lpf)\")","v":"Average Flush Rate\n(gpf)"}]
[null,null,null,null,null,{"$f":"((D26*2)+E26)/3","v":0}]
[]
[null,"Table 3. Flush Fixtures Design Case"]
[null,"1. Select the equivalent baseline fixture in the Fixture Reference column.\n2. Select the Fixture Type installed on the project.\n3. Enter the Flush Rate identified by the manufacturer - for dual flush toilets, use the dual flush calculator to determine average flush rate.\n4. Enter Fixture Information that matches the information provided for cutsheets.\n5. Enter Percent of Occupants with access to the fixture. If the fixture is installed in all restrooms, use 100%. Percentages for each Fixture Reference must total 100%."]
[null,"Fixture Reference","Design Case Fixture Type",null,"Gender","Fixture Information",null,{"$f":"IF(Instructions!U40=1,\"Flush Rate \n(gpf)\",\"Flush Rate \n(lpf)\")","v":"Flush Rate \n(gpf)"},"Percent of Occupants\n(%)",null,"Employees (FTE)",null,"Visitors",null,"Retail Customers",null,"Students",null,"Residential",null,{"$f":"IF($I$6=\"Other (please specify)\",\"Other\",$I$6)","v":"Other (specify)"},null,null,{"$f":"IF(Instructions!$U$40=1,\"Total Daily Water Use \n(gpf)\",\"Total Daily Water Use \n(lpf)\")","v":"Total Daily Water Use \n(gpf)"}]
[null,null,null,null,null,"Fixture Manufact.","Fixture \nModel",null,null,null,"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"}]
[{"$f":"IF(B32>=0,0,0)","v":0},null,null,null,{"$f":"IF(ISBLANK(B32),\"\",VLOOKUP(B32,$B$17:$V$21,6,0))","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(B32),0,VLOOKUP($B32,$B$18:$V$21,10,0))","v":0},{"$f":"IF(E32=\"Male\",H32*K32*D$8*(I32/100),H32*K32*D$9*(I32/100))","v":0},{"$f":"IF(ISBLANK(B32),0,VLOOKUP($B32,$B$18:$V$21,12,0))","v":0},{"$f":"IF(E32=\"Male\",$H32*M32*E$8*($I32/100),$H32*M32*E$9*($I32/100))","v":0},{"$f":"IF(ISBLANK(B32),0,VLOOKUP($B32,$B$18:$V$21,14,0))","v":0},{"$f":"IF(E32=\"Male\",$H32*O32*F$8*($I32/100),$H32*O32*F$9*($I32/100))","v":0},{"$f":"IF(ISBLANK(B32),0,VLOOKUP($B32,$B$18:$V$21,16,0))","v":0},{"$f":"IF(E32=\"Male\",$H32*Q32*G$8*($I32/100),$H32*Q32*G$9*($I32/100))","v":0},{"$f":"IF(ISBLANK(B32),0,VLOOKUP($B32,$B$18:$V$21,18,0))","v":0},{"$f":"IF(E32=\"Male\",$H32*S32*H$8*($I32/100),$H32*S32*H$9*($I32/100))","v":0},{"$f":"IF(ISBLANK(B32),0,VLOOKUP($B32,$B$18:$V$21,20,0))","v":0},{"$f":"IF(E32=\"Male\",$H32*U32*I$8*($I32/100),$H32*U32*I$9*($I32/100))","v":0},null,{"$f":"SUM(L32,R32,N32,P32,T32,V32)","v":0}]
[{"$f":"IF(B33>=0,0,0)","v":0},null,null,null,{"$f":"IF(ISBLANK(B33),\"\",VLOOKUP(B33,$B$17:$V$21,6,0))","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(B33),0,VLOOKUP($B33,$B$18:$V$21,10,0))","v":0},{"$f":"IF(E33=\"Male\",H33*K33*D$8*(I33/100),H33*K33*D$9*(I33/100))","v":0},{"$f":"IF(ISBLANK(B33),0,VLOOKUP($B33,$B$18:$V$21,12,0))","v":0},{"$f":"IF(E33=\"Male\",$H33*M33*E$8*($I33/100),$H33*M33*E$9*($I33/100))","v":0},{"$f":"IF(ISBLANK(B33),0,VLOOKUP($B33,$B$18:$V$21,14,0))","v":0},{"$f":"IF(E33=\"Male\",$H33*O33*F$8*($I33/100),$H33*O33*F$9*($I33/100))","v":0},{"$f":"IF(ISBLANK(B33),0,VLOOKUP($B33,$B$18:$V$21,16,0))","v":0},{"$f":"IF(E33=\"Male\",$H33*Q33*G$8*($I33/100),$H33*Q33*G$9*($I33/100))","v":0},{"$f":"IF(ISBLANK(B33),0,VLOOKUP($B33,$B$18:$V$21,18,0))","v":0},{"$f":"IF(E33=\"Male\",$H33*S33*H$8*($I33/100),$H33*S33*H$9*($I33/100))","v":0},{"$f":"IF(ISBLANK(B33),0,VLOOKUP($B33,$B$18:$V$21,20,0))","v":0},{"$f":"IF(E33=\"Male\",$H33*U33*I$8*($I33/100),$H33*U33*I$9*($I33/100))","v":0},null,{"$f":"SUM(L33,R33,N33,P33,T33,V33)","v":0}]
[0,null,null,null,{"$f":"IF(ISBLANK(B34),\"\",VLOOKUP(B34,$B$17:$V$21,6,0))","v":""},null,null,null,null,null,0,{"$f":"IF(E34=\"Male\",H34*K34*D$8*(I34/100),H34*K34*D$9*(I34/100))","v":0},0,{"$f":"IF(E34=\"Male\",$H34*M34*E$8*($I34/100),$H34*M34*E$9*($I34/100))","v":0},0,{"$f":"IF(E34=\"Male\",$H34*O34*F$8*($I34/100),$H34*O34*F$9*($I34/100))","v":0},0,{"$f":"IF(E34=\"Male\",$H34*Q34*G$8*($I34/100),$H34*Q34*G$9*($I34/100))","v":0},0,{"$f":"IF(E34=\"Male\",$H34*S34*H$8*($I34/100),$H34*S34*H$9*($I34/100))","v":0},0,{"$f":"IF(E34=\"Male\",$H34*U34*I$8*($I34/100),$H34*U34*I$9*($I34/100))","v":0},null,{"$f":"SUM(L34,R34,N34,P34,T34,V34)","v":0}]
[null,null,null,null,{"$f":"IF(ISBLANK(B35),\"\",VLOOKUP(B35,$B$17:$V$21,6,0))","v":""},null,null,null,null,null,0,{"$f":"IF(E35=\"Male\",H35*K35*D$8*(I35/100),H35*K35*D$9*(I35/100))","v":0},0,{"$f":"IF(E35=\"Male\",$H35*M35*E$8*($I35/100),$H35*M35*E$9*($I35/100))","v":0},0,{"$f":"IF(E35=\"Male\",$H35*O35*F$8*($I35/100),$H35*O35*F$9*($I35/100))","v":0},0,{"$f":"IF(E35=\"Male\",$H35*Q35*G$8*($I35/100),$H35*Q35*G$9*($I35/100))","v":0},0,{"$f":"IF(E35=\"Male\",$H35*S35*H$8*($I35/100),$H35*S35*H$9*($I35/100))","v":0},0,{"$f":"IF(E35=\"Male\",$H35*U35*I$8*($I35/100),$H35*U35*I$9*($I35/100))","v":0},null,{"$f":"SUM(L35,R35,N35,P35,T35,V35)","v":0}]
[null,null,null,null,{"$f":"IF(ISBLANK(B36),\"\",VLOOKUP(B36,$B$17:$V$21,6,0))","v":""},null,null,null,null,null,0,{"$f":"IF(E36=\"Male\",H36*K36*D$8*(I36/100),H36*K36*D$9*(I36/100))","v":0},0,{"$f":"IF(E36=\"Male\",$H36*M36*E$8*($I36/100),$H36*M36*E$9*($I36/100))","v":0},0,{"$f":"IF(E36=\"Male\",$H36*O36*F$8*($I36/100),$H36*O36*F$9*($I36/100))","v":0},0,{"$f":"IF(E36=\"Male\",$H36*Q36*G$8*($I36/100),$H36*Q36*G$9*($I36/100))","v":0},0,{"$f":"IF(E36=\"Male\",$H36*S36*H$8*($I36/100),$H36*S36*H$9*($I36/100))","v":0},0,{"$f":"IF(E36=\"Male\",$H36*U36*I$8*($I36/100),$H36*U36*I$9*($I36/100))","v":0},null,{"$f":"SUM(L36,R36,N36,P36,T36,V36)","v":0}]
["A",{"$f":"IF(Instructions!$U$40=1,\"Design case annual flush volume (gallons/year)\",\"Design case annual flush volume (liters/year)\")","v":"Design case annual flush volume (gallons/year)"},null,null,null,null,null,null,{"$f":"(SUM(X32:X36)*$I$13)","v":0}]
[]
[]
[]
[null,"Table 4. Flow Fixtures Baseline Case"]
[null,"1. Indicate whether the Fixture Type is present on the project using the Included in Project column.\n2. If necessary, modify the Uses per Day column for non-default uses."]
[null,"Fixture Reference","Baseline Case Fixture Type",null,null,{"$f":"IF(Instructions!U40=1,\"Default Flow Rate \n(gpm)\",\"Default Flow Rate \n(lpm)\")","v":"Default Flow Rate \n(gpm)"},"Duration",null,{"$f":"I17","v":"Included \nin Project"},null,"Employees (FTE)",null,"Visitors",null,"Retail Customers",null,"Students",null,"Residential",null,{"$f":"IF($I$6=\"Other (please specify)\",\"Other\",$I$6)","v":"Other (specify)"},null,null,{"$f":"IF(Instructions!$U$40=1,\"Total Daily Water Use \n(gpf)\",\"Total Daily Water Use \n(lpm)\")","v":"Total Daily Water Use \n(gpf)"}]
[null,null,null,null,null,null,"Non-\nResidential\n(sec)","Residential\n(sec)",null,null,"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"}]
[null,"_A",{"$f":"Instructions!$C$30","v":"Public lavatory (restroom) faucet"},null,null,{"$f":"IF(Instructions!$U$40=1,Instructions!$G$30,Instructions!$I$30)","v":0.5},{"$f":"Instructions!$K$30","v":30},{"$f":"Instructions!$L$30","v":0},null,null,{"$f":"Instructions!$N$30","v":3},{"$f":"$F45*($G45/60)*$K45*D$7","v":0},{"$f":"Instructions!$O$30","v":0.5},{"$f":"$F45*($G45/60)*M45*$E$7","v":0},{"$f":"Instructions!$P$30","v":0.2},{"$f":"$F45*($G45/60)*O45*$F$7","v":0},{"$f":"Instructions!$Q$30","v":3},{"$f":"$F45*($G45/60)*$Q45*$G$7","v":0},{"$f":"Instructions!$R$30","v":0},{"$f":"F45*($H45/60)*S45*$H$7","v":0},null,{"$f":"$F45*($G45/60)*U45*$I$7","v":0},null,{"$f":"IF(I45=\"Yes\",SUM(L45,R45,N45,P45,T45,V45),0)","v":0}]
[null,"_B",{"$f":"Instructions!$C$31","v":"Private lavatory faucet"},null,null,{"$f":"IF(Instructions!$U$40=1,Instructions!$G$31,Instructions!$I$31)","v":2.2000000000000002},{"$f":"Instructions!$K$31","v":30},{"$f":"Instructions!$L$31","v":60},null,null,{"$f":"Instructions!$N$31","v":0},{"$f":"$F46*($G46/60)*$K46*D$7","v":0},{"$f":"Instructions!$O$31","v":0},{"$f":"$F46*($G46/60)*M46*$E$7","v":0},{"$f":"Instructions!$P$31","v":0},{"$f":"$F46*($G46/60)*O46*$F$7","v":0},{"$f":"Instructions!$Q$31","v":0},{"$f":"$F46*($G46/60)*$Q46*$G$7","v":0},{"$f":"Instructions!$R$31","v":5},{"$f":"F46*($H46/60)*S46*$H$7","v":0},null,{"$f":"$F46*($G46/60)*U46*$I$7","v":0},null,{"$f":"IF(I46=\"Yes\",SUM(L46,R46,N46,P46,T46,V46),0)","v":0}]
[null,"_C",{"$f":"Instructions!$C$32","v":"Kitchen faucet"},null,null,{"$f":"IF(Instructions!$U$40=1,Instructions!$G$32,Instructions!$I$32)","v":2.2000000000000002},{"$f":"Instructions!$K$32","v":15},{"$f":"Instructions!$L$32","v":60},null,null,{"$f":"Instructions!$N$32","v":1},{"$f":"$F47*($G47/60)*$K47*D$7","v":0},{"$f":"Instructions!$O$32","v":0},{"$f":"$F47*($G47/60)*M47*$E$7","v":0},{"$f":"Instructions!$P$32","v":0},{"$f":"$F47*($G47/60)*O47*$F$7","v":0},{"$f":"Instructions!$Q$32","v":0},{"$f":"$F47*($G47/60)*$Q47*$G$7","v":0},{"$f":"Instructions!$R$32","v":4},{"$f":"F47*($H47/60)*S47*$H$7","v":0},null,{"$f":"$F47*($G47/60)*U47*$I$7","v":0},null,{"$f":"IF(I47=\"Yes\",SUM(L47,R47,N47,P47,T47,V47),0)","v":0}]
[null,"_D",{"$f":"Instructions!$C$33","v":"Showerhead"},null,null,{"$f":"IF(Instructions!$U$40=1,Instructions!$G$33,Instructions!$I$33)","v":2.5},{"$f":"Instructions!$K$33","v":300},{"$f":"Instructions!$L$33","v":480},null,null,{"$f":"Instructions!$N$33","v":0.1},{"$f":"$F48*($G48/60)*$K48*D$7","v":0},{"$f":"Instructions!$O$33","v":0},{"$f":"$F48*($G48/60)*M48*$E$7","v":0},{"$f":"Instructions!$P$33","v":0},{"$f":"$F48*($G48/60)*O48*$F$7","v":0},{"$f":"Instructions!$Q$33","v":0},{"$f":"$F48*($G48/60)*$Q48*$G$7","v":0},{"$f":"Instructions!$R$33","v":1},{"$f":"F48*($H48/60)*S48*$H$7","v":0},null,{"$f":"$F48*($G48/60)*U48*$I$7","v":0},null,{"$f":"IF(I48=\"Yes\",SUM(L48,R48,N48,P48,T48,V48),0)","v":0}]
[null,{"$f":"IF(Instructions!$U$40=1,\"Baseline case annual flow volume (gallons/year)\",\"Baseline case annual flow volume (liters/year)\")","v":"Baseline case annual flow volume (gallons/year)"},null,null,null,null,null,null,{"$f":"(SUM(X45:X48)*$I$13)","v":0}]
[]
[null,"For projects with metering faucets"]
[null,"Enter the resulting per minute flow rate into the design case flow rate section for public lavatory faucet.",null,{"$f":"IF(Instructions!$U$40=1,\"Gallons per Cycle\",\"Liters per Cycle\")","v":"Gallons per Cycle"},"Cycle Duration\n(sec)",{"$f":"IF(Instructions!$U$40=1,\"Flow Rate (gpm)\",\"Flow Rate (lpm)\")","v":"Flow Rate (gpm)"}]
[null,null,null,null,null,{"$f":"IFERROR((D53*60)/E53,0)","v":0}]
[]
[null,"Table 5. Flow Fixtures Design Case"]
[null,"1. Select the equivalent baseline fixture in the Fixture Reference column.\n2. Select the Fixture Type installed on the project.\n3. Enter the Flow Rate identified by the manufacturer - for metering faucets, use the metering faucet calculator to determine flow rate.\n4. Enter Fixture Information that matches the information provided for cutsheets.\n5. Enter Percent of Occupants with access to the fixture. If the fixture is installed in all restrooms, use 100%. Percentages for each Fixture Reference must total 100%."]
[null,"Fixture Reference","Design Case Fixture Type",{"$f":"IF(Instructions!U40=1,\"Flow Rate (gpm)\",\"Flow Rate (lpm)\")","v":"Flow Rate (gpm)"},"Percent of Occupants\n(%)","Fixture Information",null,"Duration",null,null,"Employees (FTE)",null,"Visitors",null,"Retail Customers",null,"Students",null,"Residential",null,{"$f":"IF($I$6=\"Other (please specify)\",\"Other\",$I$6)","v":"Other (specify)"},null,null,{"$f":"IF(Instructions!$U$40=1,\"Total Daily Water Use \n(gpf)\",\"Total Daily Water Use \n(lpm)\")","v":"Total Daily Water Use \n(gpf)"}]
[null,null,null,null,null,"Fixture Manufact.","Fixture \nModel","Non-\nResidential\n(sec)","Residential\n(sec)",null,"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"}]
[{"$f":"IF(B59>=0,1,1)","v":1},null,{"$f":"IF(ISBLANK(B59),\"\",VLOOKUP(B59,B$43:V$48,2,0))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(B59),0,VLOOKUP(B59,$B$45:$U$48,6,0))","v":0},{"$f":"IF(ISBLANK(B59),0,VLOOKUP(B59,$B$45:$U$48,7,0))","v":0},null,{"$f":"IF(ISBLANK(B59),0,VLOOKUP($B59,$B$43:$V$48,10,0))","v":0},{"$f":"$D59*($H59/60)*K59*($D$7*($E59/100))","v":0},{"$f":"IF(ISBLANK(B59),0,VLOOKUP($B59,$B$43:$V$48,12,0))","v":0},{"$f":"$D59*($H59/60)*M59*(E$7*($E59/100))","v":0},{"$f":"IF(ISBLANK(B59),0,VLOOKUP($B59,$B$43:$V$48,14,0))","v":0},{"$f":"$D59*($H59/60)*O59*(F$7*($E59/100))","v":0},{"$f":"IF(ISBLANK(B59),0,VLOOKUP($B59,$B$43:$V$48,16,0))","v":0},{"$f":"$D59*($H59/60)*Q59*($G$7*($E59/100))","v":0},{"$f":"IF(ISBLANK(B59),0,VLOOKUP($B59,$B$43:$V$48,18,0))","v":0},{"$f":"$D59*($I59/60)*S59*($H$7*($E59/100))","v":0},{"$f":"IF(ISBLANK(B59),0,VLOOKUP($B59,$B$43:$V$48,20,0))","v":0},{"$f":"$D59*($H59/60)*U59*(I$7*($E59/100))","v":0},null,{"$f":"SUM(L59,R59,N59,P59,T59,V59)","v":0}]
[{"$f":"IF(B60>=0,1,1)","v":1},null,{"$f":"IF(ISBLANK(B60),\"\",VLOOKUP(B60,B$43:V$48,2,0))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(B60),0,VLOOKUP(B60,$B$45:$U$48,6,0))","v":0},{"$f":"IF(ISBLANK(B60),0,VLOOKUP(B60,$B$45:$U$48,7,0))","v":0},null,{"$f":"IF(ISBLANK(B60),0,VLOOKUP($B60,$B$43:$V$48,10,0))","v":0},{"$f":"$D60*($H60/60)*K60*($D$7*($E60/100))","v":0},{"$f":"IF(ISBLANK(B60),0,VLOOKUP($B60,$B$43:$V$48,12,0))","v":0},{"$f":"$D60*($H60/60)*M60*(E$7*($E60/100))","v":0},{"$f":"IF(ISBLANK(B60),0,VLOOKUP($B60,$B$43:$V$48,14,0))","v":0},{"$f":"$D60*($H60/60)*O60*(F$7*($E60/100))","v":0},{"$f":"IF(ISBLANK(B60),0,VLOOKUP($B60,$B$43:$V$48,16,0))","v":0},{"$f":"$D60*($H60/60)*Q60*($G$7*($E60/100))","v":0},{"$f":"IF(ISBLANK(B60),0,VLOOKUP($B60,$B$43:$V$48,18,0))","v":0},{"$f":"$D60*($I60/60)*S60*($H$7*($E60/100))","v":0},{"$f":"IF(ISBLANK(B60),0,VLOOKUP($B60,$B$43:$V$48,20,0))","v":0},{"$f":"$D60*($H60/60)*U60*(I$7*($E60/100))","v":0},null,{"$f":"SUM(L60,R60,N60,P60,T60,V60)","v":0}]
[1,null,{"$f":"IF(ISBLANK(B61),\"\",VLOOKUP(B61,B$43:V$48,2,0))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(B61),0,VLOOKUP(B61,$B$45:$U$48,6,0))","v":0},{"$f":"IF(ISBLANK(B61),0,VLOOKUP(B61,$B$45:$U$48,7,0))","v":0},null,0,{"$f":"$D61*($H61/60)*K61*($D$7*($E61/100))","v":0},0,{"$f":"$D61*($H61/60)*M61*(E$7*($E61/100))","v":0},0,{"$f":"$D61*($H61/60)*O61*(F$7*($E61/100))","v":0},0,{"$f":"$D61*($H61/60)*Q61*($G$7*($E61/100))","v":0},0,{"$f":"$D61*($I61/60)*S61*($H$7*($E61/100))","v":0},0,{"$f":"$D61*($H61/60)*U61*(I$7*($E61/100))","v":0},null,{"$f":"SUM(L61,R61,N61,P61,T61,V61)","v":0}]
[null,null,{"$f":"IF(ISBLANK(B62),\"\",VLOOKUP(B62,B$43:V$48,2,0))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(B62),0,VLOOKUP(B62,$B$45:$U$48,6,0))","v":0},{"$f":"IF(ISBLANK(B62),0,VLOOKUP(B62,$B$45:$U$48,7,0))","v":0},null,0,{"$f":"$D62*($H62/60)*K62*($D$7*($E62/100))","v":0},0,{"$f":"$D62*($H62/60)*M62*(E$7*($E62/100))","v":0},0,{"$f":"$D62*($H62/60)*O62*(F$7*($E62/100))","v":0},0,{"$f":"$D62*($H62/60)*Q62*($G$7*($E62/100))","v":0},0,{"$f":"$D62*($I62/60)*S62*($H$7*($E62/100))","v":0},0,{"$f":"$D62*($H62/60)*U62*(I$7*($E62/100))","v":0},null,{"$f":"SUM(L62,R62,N62,P62,T62,V62)","v":0}]
[null,null,{"$f":"IF(ISBLANK(B63),\"\",VLOOKUP(B63,B$43:V$48,2,0))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(B63),0,VLOOKUP(B63,$B$45:$U$48,6,0))","v":0},{"$f":"IF(ISBLANK(B63),0,VLOOKUP(B63,$B$45:$U$48,7,0))","v":0},null,0,{"$f":"$D63*($H63/60)*K63*($D$7*($E63/100))","v":0},0,{"$f":"$D63*($H63/60)*M63*(E$7*($E63/100))","v":0},0,{"$f":"$D63*($H63/60)*O63*(F$7*($E63/100))","v":0},0,{"$f":"$D63*($H63/60)*Q63*($G$7*($E63/100))","v":0},0,{"$f":"$D63*($I63/60)*S63*($H$7*($E63/100))","v":0},0,{"$f":"$D63*($H63/60)*U63*(I$7*($E63/100))","v":0},null,{"$f":"SUM(L63,R63,N63,P63,T63,V63)","v":0}]
["B",{"$f":"IF(Instructions!$U$40=1,\"Design case annual flow volume (gallons/year)\",\"Design case annual flow volume (liters/year)\")","v":"Design case annual flow volume (gallons/year)"},null,null,null,null,null,null,{"$f":"(SUM(X59:X63)*$I$13)","v":0}]

{"sheet":"Group 1","index":2,"n_rows":64,"n_cols":31,"rows_kept":64,"cut":false,"hidden":false,"merged":[[56,16,56,17],[56,18,56,19],[56,20,56,21],[56,23,57,23],[55,1,55,23],[56,1,57,1],[56,2,57,2],[56,3,57,3],[56,4,57,4],[56,5,56,6],[56,7,56,8],[56,10,56,11],[56,12,56,13],[56,14,56,15],[42,23,43,23],[44,2,44,4],[45,2,45,4],[46,2,46,4],[47,2,47,4],[42,18,42,19],[42,20,42,21],[51,1,52,2],[42,10,42,11],[42,12,42,13],[42,14,42,15],[42,16,42,17],[42,1,43,1],[42,2,43,4],[42,5,43,5],[42,6,42,7],[42,8,43,8],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[41,1,41,23],[31,2,31,3],[24,1,25,2],[28,1,28,23],[29,1,30,1],[29,2,30,3],[29,4,30,4],[29,5,29,6],[29,7,30,7],[29,8,30,8],[29,10,29,11],[29,12,29,13],[29,14,29,15],[29,16,29,17],[29,18,29,19],[29,20,29,21],[29,23,30,23],[20,2,20,5],[15,1,15,23],[16,1,17,1],[16,2,17,5],[16,6,17,6],[16,7,17,7],[16,8,17,8],[16,10,16,11],[16,12,16,13],[16,14,16,15],[16,16,16,17],[16,18,16,19],[16,20,16,21],[16,23,17,23],[18,2,18,5],[19,2,19,5],[12,1,12,7],[4,1,4,8],[4,27,4,28],[4,29,4,30],[6,1,6,2],[6,24,7,24],[7,1,7,2],[8,1,8,2],[8,24,9,24],[9,1,9,8],[10,1,10,7],[11,1,11,8]]}
[]
[null,{"$f":"REPLACE(CELL(\"filename\",A1),1,FIND(\"]\",CELL(\"filename\",A1)),\"\")","v":"Group 1"}]
[]
[null,"Table 1. Project Information"]
[null,"Enter project occupancy information.  This information should be consistent with occupancy numbers used in other LEED credits.  The default gender mix is half male and half female.  If necessary, modify the Male and Female occupant type columns for non-default gender mix. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FLUSH",null,"FLOW"]
[null,null,null,"Employees\n (FTE)","Visitors","Retail Customers","Students\n(For Schools only)","Residential","Other (specify)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ref # if included","ref list w/o blanks","ref # if included","ref list w/o blanks"]
[null,"Total",null,35,10,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Baseline","Flush",{"$f":"I22","v":39816},{"$f":"IF(I19=\"Yes\",B19,\"\")","v":"_1"},{"$f":"IFERROR(INDEX(AB7:AB9,SMALL((IF(LEN(AB7:AB9),ROW(INDIRECT(\"1:\"&ROWS(AB7:AB9))))),ROW(A1)),1),\"\")","v":"_1"},{"$f":"IF(I45=\"Yes\",B45,\"\")","v":"_A"},{"$f":"IFERROR(INDEX(AD7:AD10,SMALL((IF(LEN(AD7:AD10),ROW(INDIRECT(\"1:\"&ROWS(AD7:AD10))))),ROW(A1)),1),\"\")","v":"_A"}]
[null,"Male",null,{"$f":"D7/2","v":18},{"$f":"E7/2","v":5},0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow",{"$f":"I49","v":22806},{"$f":"IF(I20=\"Yes\",B20,\"\")","v":"_2"},{"$f":"IFERROR(INDEX(AB7:AB9,SMALL((IF(LEN(AB7:AB9),ROW(INDIRECT(\"1:\"&ROWS(AB7:AB9))))),ROW(A2)),1),\"\")","v":"_2"},{"$f":"IF(I46=\"Yes\",B46,\"\")","v":""},{"$f":"IFERROR(INDEX(AD7:AD10,SMALL((IF(LEN(AD7:AD10),ROW(INDIRECT(\"1:\"&ROWS(AD7:AD10))))),ROW(A2)),1),\"\")","v":"_C"}]
[null,"Female",null,{"$f":"D7/2","v":18},5,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Design","Flush",{"$f":"I37","v":20225.52},{"$f":"IF(I21=\"Yes\",B21,\"\")","v":"_3"},{"$f":"IFERROR(INDEX(AB7:AB9,SMALL((IF(LEN(AB7:AB9),ROW(INDIRECT(\"1:\"&ROWS(AB7:AB9))))),ROW(A3)),1),\"\")","v":"_3"},{"$f":"IF(I47=\"Yes\",B47,\"\")","v":"_C"},{"$f":"IFERROR(INDEX(AD7:AD10,SMALL((IF(LEN(AD7:AD10),ROW(INDIRECT(\"1:\"&ROWS(AD7:AD10))))),ROW(A3)),1),\"\")","v":"_D"}]
[null,"Determine the percent of males expected to use urinals (enter 100% if all male restrooms have urinals, 0% if the project contains no urinals, etc)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow",{"$f":"I64","v":22806},null,null,{"$f":"IF(I48=\"Yes\",B48,\"\")","v":"_D"},{"$f":"IFERROR(INDEX(AD7:AD10,SMALL((IF(LEN(AD7:AD10),ROW(INDIRECT(\"1:\"&ROWS(AD7:AD10))))),ROW(A4)),1),\"\")","v":""}]
[null,"Percent of males expected to use restrooms with urinals ",null,null,null,null,null,null,1]
[null,"Enter the number of days the project is accessible to employees or FTE."]
[null,"Annual days of operation ",null,null,null,null,null,null,252]
[null,{"$f":"IF(I13>365,\"Annual days of operation must be between 1 and 365.\",\"\")","v":""}]
[null,"Table 2. Flush Fixtures Baseline Case"]
[null,"1. Indicate whether the Fixture Type is present on the project using the Included in Project column.\n2. If necessary, modify the Uses per Day column for non-default uses."]
[null,"Fixture Reference","Baseline Case Fixture Type",null,null,null,"Gender",{"$f":"IF(Instructions!U40=1,\"Default Flush Rate \n(gpf)\",\"Default Flush Rate \n(lpf)\")","v":"Default Flush Rate \n(gpf)"},"Included \nin Project",null,"Employees (FTE)",null,"Visitors",null,"Retail Customers",null,"Students",null,"Residential",null,{"$f":"IF($I$6=\"Other (please specify)\",\"Other\",$I$6)","v":"Other (specify)"},null,null,{"$f":"IF(Instructions!$U$40=1,\"Total Daily Water Use \n(gpf)\",\"Total Daily Water Use \n(lpf)\")","v":"Total Daily Water Use \n(gpf)"}]
[null,null,null,null,null,null,null,null,null,null,"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"}]
[null,"_1",{"$f":"Instructions!$C$27","v":"Toilet "},null,null,null,{"$f":"Instructions!$F$27","v":"Male"},{"$f":"IF(Instructions!$U$40=1,Instructions!$G$27,Instructions!$I$27)","v":1.6},"Yes",null,{"$f":"Instructions!N27+((1-I11)*Instructions!N28)","v":1},{"$f":"H19*D8*K19","v":28.8},{"$f":"Instructions!O27+((1-I11)*Instructions!O28)","v":0.1},{"$f":"$H19*E8*M19","v":0.8},{"$f":"Instructions!P27+((1-I11)*Instructions!P28)","v":0.1},{"$f":"$H19*F8*O19","v":0},{"$f":"Instructions!Q27+((1-I11)*Instructions!Q28)","v":1},{"$f":"$H19*G8*Q19","v":0},{"$f":"Instructions!R27+((1-I11)*Instructions!R28)","v":5},{"$f":"$H19*H8*S19","v":0},null,{"$f":"$H19*I8*U19","v":0},null,{"$f":"IF(I19=\"Yes\",SUM(L19,R19,N19,P19,T19,V19),0)","v":29.6}]
[null,"_2",{"$f":"Instructions!$C$28","v":"Toilet "},null,null,null,{"$f":"Instructions!$F$28","v":"Female"},{"$f":"IF(Instructions!$U$40=1,Instructions!$G$28,Instructions!$I$28)","v":1.6},"Yes",null,{"$f":"Instructions!$N$28","v":3},{"$f":"H20*D9*K20","v":86.4},{"$f":"Instructions!$O$28","v":0.5},{"$f":"$H20*E9*M20","v":4},{"$f":"Instructions!$P$28","v":0.2},{"$f":"$H20*F9*O20","v":0},{"$f":"Instructions!$Q$28","v":3},{"$f":"$H20*G9*Q20","v":0},{"$f":"Instructions!$R$28","v":5},{"$f":"$H20*H9*S20","v":0},null,{"$f":"$H20*I9*U20","v":0},null,{"$f":"IF(I20=\"Yes\",SUM(L20,R20,N20,P20,T20,V20),0)","v":90.4}]
[null,"_3",{"$f":"Instructions!$C$29","v":"Urinal"},null,null,null,{"$f":"Instructions!$F$29","v":"Male"},{"$f":"IF(Instructions!$U$40=1,Instructions!$G$29,Instructions!$I$29)","v":1},"Yes",null,{"$f":"Instructions!N29*I11","v":2},{"$f":"H21*D8*K21","v":36},{"$f":"Instructions!O29*I11","v":0.4},{"$f":"$H21*E8*M21","v":2},{"$f":"Instructions!P29*I11","v":0.1},{"$f":"$H21*F8*O21","v":0},{"$f":"Instructions!Q29*I11","v":2},{"$f":"$H21*G8*Q21","v":0},{"$f":"Instructions!$R$29*I11","v":0},{"$f":"$H21*H8*S21","v":0},null,{"$f":"$H21*I8*U21","v":0},null,{"$f":"IF(I21=\"Yes\",SUM(L21,R21,N21,P21,T21,V21),0)","v":38}]
[null,{"$f":"IF(Instructions!$U$40=1,\"Baseline case annual flush volume (gallons/year)\",\"Baseline case annual flush volume (liters/year)\")","v":"Baseline case annual flush volume (gallons/year)"},null,null,null,null,null,null,{"$f":"(SUM(X19:X21)*$I$13)","v":39816}]
[]
[null,"For projects with dual-flush toilets"]
[null,"Enter the resulting per flush rate into the design case flush rate section for toilet.",null,{"$f":"IF(Instructions!$U$40=1,\"Low Flush\n(gpf)\",\"Low Flush\n(lpf)\")","v":"Low Flush\n(gpf)"},{"$f":"IF(Instructions!$U$40=1,\"High Flush\n(gpf)\",\"High Flush\n(lpf)\")","v":"High Flush\n(gpf)"},{"$f":"IF(Instructions!$U$40=1,\"Average Flush Rate\n(gpf)\",\"Average Flush Rate\n(lpf)\")","v":"Average Flush Rate\n(gpf)"}]
[null,null,null,0.8,1.6,{"$f":"((D26*2)+E26)/3","v":1.07}]
[]
[null,"Table 3. Flush Fixtures Design Case"]
[null,"1. Select the equivalent baseline fixture in the Fixture Reference column.\n2. Select the Fixture Type installed on the project.\n3. Enter the Flush Rate identified by the manufacturer - for dual flush toilets, use the dual flush calculator to determine average flush rate.\n4. Enter Fixture Information that matches the information provided for cutsheets.\n5. Enter Percent of Occupants with access to the fixture. If the fixture is installed in all restrooms, use 100%. Percentages for each Fixture Reference must total 100%."]
[null,"Fixture Reference","Design Case Fixture Type",null,"Gender","Fixture Information",null,{"$f":"IF(Instructions!U40=1,\"Flush Rate \n(gpf)\",\"Flush Rate \n(lpf)\")","v":"Flush Rate \n(gpf)"},"Percent of Occupants\n(%)",null,"Employees (FTE)",null,"Visitors",null,"Retail Customers",null,"Students",null,"Residential",null,{"$f":"IF($I$6=\"Other (please specify)\",\"Other\",$I$6)","v":"Other (specify)"},null,null,{"$f":"IF(Instructions!$U$40=1,\"Total Daily Water Use \n(gpf)\",\"Total Daily Water Use \n(lpf)\")","v":"Total Daily Water Use \n(gpf)"}]
[null,null,null,null,null,"Fixture Manufact.","Fixture \nModel",null,null,null,"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpf)\")","v":"Daily Water Use \n(gpf)"}]
[{"$f":"IF(B32>=0,0,0)","v":0},"_1","Dual-Flush Water Closet",null,{"$f":"IF(ISBLANK(B32),\"\",VLOOKUP(B32,$B$17:$V$21,6,0))","v":"Male"},"Caroma","Caravelle 270",1.07,100,null,{"$f":"IF(ISBLANK(B32),0,VLOOKUP($B32,$B$18:$V$21,10,0))","v":1},{"$f":"IF(E32=\"Male\",H32*K32*D$8*(I32/100),H32*K32*D$9*(I32/100))","v":19.260000000000002},{"$f":"IF(ISBLANK(B32),0,VLOOKUP($B32,$B$18:$V$21,12,0))","v":0.1},{"$f":"IF(E32=\"Male\",$H32*M32*E$8*($I32/100),$H32*M32*E$9*($I32/100))","v":0.54},{"$f":"IF(ISBLANK(B32),0,VLOOKUP($B32,$B$18:$V$21,14,0))","v":0.1},{"$f":"IF(E32=\"Male\",$H32*O32*F$8*($I32/100),$H32*O32*F$9*($I32/100))","v":0},{"$f":"IF(ISBLANK(B32),0,VLOOKUP($B32,$B$18:$V$21,16,0))","v":1},{"$f":"IF(E32=\"Male\",$H32*Q32*G$8*($I32/100),$H32*Q32*G$9*($I32/100))","v":0},{"$f":"IF(ISBLANK(B32),0,VLOOKUP($B32,$B$18:$V$21,18,0))","v":5},{"$f":"IF(E32=\"Male\",$H32*S32*H$8*($I32/100),$H32*S32*H$9*($I32/100))","v":0},{"$f":"IF(ISBLANK(B32),0,VLOOKUP($B32,$B$18:$V$21,20,0))","v":0},{"$f":"IF(E32=\"Male\",$H32*U32*I$8*($I32/100),$H32*U32*I$9*($I32/100))","v":0},null,{"$f":"SUM(L32,R32,N32,P32,T32,V32)","v":19.8}]
[{"$f":"IF(B33>=0,0,0)","v":0},"_2","Dual-Flush Water Closet",null,{"$f":"IF(ISBLANK(B33),\"\",VLOOKUP(B33,$B$17:$V$21,6,0))","v":"Female"},"Caroma","Caravelle 270",1.07,100,null,{"$f":"IF(ISBLANK(B33),0,VLOOKUP($B33,$B$18:$V$21,10,0))","v":3},{"$f":"IF(E33=\"Male\",H33*K33*D$8*(I33/100),H33*K33*D$9*(I33/100))","v":57.78},{"$f":"IF(ISBLANK(B33),0,VLOOKUP($B33,$B$18:$V$21,12,0))","v":0.5},{"$f":"IF(E33=\"Male\",$H33*M33*E$8*($I33/100),$H33*M33*E$9*($I33/100))","v":2.68},{"$f":"IF(ISBLANK(B33),0,VLOOKUP($B33,$B$18:$V$21,14,0))","v":0.2},{"$f":"IF(E33=\"Male\",$H33*O33*F$8*($I33/100),$H33*O33*F$9*($I33/100))","v":0},{"$f":"IF(ISBLANK(B33),0,VLOOKUP($B33,$B$18:$V$21,16,0))","v":3},{"$f":"IF(E33=\"Male\",$H33*Q33*G$8*($I33/100),$H33*Q33*G$9*($I33/100))","v":0},{"$f":"IF(ISBLANK(B33),0,VLOOKUP($B33,$B$18:$V$21,18,0))","v":5},{"$f":"IF(E33=\"Male\",$H33*S33*H$8*($I33/100),$H33*S33*H$9*($I33/100))","v":0},{"$f":"IF(ISBLANK(B33),0,VLOOKUP($B33,$B$18:$V$21,20,0))","v":0},{"$f":"IF(E33=\"Male\",$H33*U33*I$8*($I33/100),$H33*U33*I$9*($I33/100))","v":0},null,{"$f":"SUM(L33,R33,N33,P33,T33,V33)","v":60.46}]
[0,"_3","Non-Water Urinal",null,{"$f":"IF(ISBLANK(B34),\"\",VLOOKUP(B34,$B$17:$V$21,6,0))","v":"Male"},"Sloan","WES-1000",0,100,null,2,{"$f":"IF(E34=\"Male\",H34*K34*D$8*(I34/100),H34*K34*D$9*(I34/100))","v":0},0.4,{"$f":"IF(E34=\"Male\",$H34*M34*E$8*($I34/100),$H34*M34*E$9*($I34/100))","v":0},0.1,{"$f":"IF(E34=\"Male\",$H34*O34*F$8*($I34/100),$H34*O34*F$9*($I34/100))","v":0},2,{"$f":"IF(E34=\"Male\",$H34*Q34*G$8*($I34/100),$H34*Q34*G$9*($I34/100))","v":0},0,{"$f":"IF(E34=\"Male\",$H34*S34*H$8*($I34/100),$H34*S34*H$9*($I34/100))","v":0},0,{"$f":"IF(E34=\"Male\",$H34*U34*I$8*($I34/100),$H34*U34*I$9*($I34/100))","v":0},null,{"$f":"SUM(L34,R34,N34,P34,T34,V34)","v":0}]
[null,null,null,null,{"$f":"IF(ISBLANK(B35),\"\",VLOOKUP(B35,$B$17:$V$21,6,0))","v":""},null,null,null,null,null,0,{"$f":"IF(E35=\"Male\",H35*K35*D$8*(I35/100),H35*K35*D$9*(I35/100))","v":0},0,{"$f":"IF(E35=\"Male\",$H35*M35*E$8*($I35/100),$H35*M35*E$9*($I35/100))","v":0},0,{"$f":"IF(E35=\"Male\",$H35*O35*F$8*($I35/100),$H35*O35*F$9*($I35/100))","v":0},0,{"$f":"IF(E35=\"Male\",$H35*Q35*G$8*($I35/100),$H35*Q35*G$9*($I35/100))","v":0},0,{"$f":"IF(E35=\"Male\",$H35*S35*H$8*($I35/100),$H35*S35*H$9*($I35/100))","v":0},0,{"$f":"IF(E35=\"Male\",$H35*U35*I$8*($I35/100),$H35*U35*I$9*($I35/100))","v":0},null,{"$f":"SUM(L35,R35,N35,P35,T35,V35)","v":0}]
[null,null,null,null,{"$f":"IF(ISBLANK(B36),\"\",VLOOKUP(B36,$B$17:$V$21,6,0))","v":""},null,null,null,null,null,0,{"$f":"IF(E36=\"Male\",H36*K36*D$8*(I36/100),H36*K36*D$9*(I36/100))","v":0},0,{"$f":"IF(E36=\"Male\",$H36*M36*E$8*($I36/100),$H36*M36*E$9*($I36/100))","v":0},0,{"$f":"IF(E36=\"Male\",$H36*O36*F$8*($I36/100),$H36*O36*F$9*($I36/100))","v":0},0,{"$f":"IF(E36=\"Male\",$H36*Q36*G$8*($I36/100),$H36*Q36*G$9*($I36/100))","v":0},0,{"$f":"IF(E36=\"Male\",$H36*S36*H$8*($I36/100),$H36*S36*H$9*($I36/100))","v":0},0,{"$f":"IF(E36=\"Male\",$H36*U36*I$8*($I36/100),$H36*U36*I$9*($I36/100))","v":0},null,{"$f":"SUM(L36,R36,N36,P36,T36,V36)","v":0}]
["A",{"$f":"IF(Instructions!$U$40=1,\"Design case annual flush volume (gallons/year)\",\"Design case annual flush volume (liters/year)\")","v":"Design case annual flush volume (gallons/year)"},null,null,null,null,null,null,{"$f":"(SUM(X32:X36)*$I$13)","v":20225.52}]
[]
[]
[]
[null,"Table 4. Flow Fixtures Baseline Case"]
[null,"1. Indicate whether the Fixture Type is present on the project using the Included in Project column.\n2. If necessary, modify the Uses per Day column for non-default uses."]
[null,"Fixture Reference","Baseline Case Fixture Type",null,null,{"$f":"IF(Instructions!U40=1,\"Default Flow Rate \n(gpm)\",\"Default Flow Rate \n(lpm)\")","v":"Default Flow Rate \n(gpm)"},"Duration",null,{"$f":"I17","v":"Included \nin Project"},null,"Employees (FTE)",null,"Visitors",null,"Retail Customers",null,"Students",null,"Residential",null,{"$f":"IF($I$6=\"Other (please specify)\",\"Other\",$I$6)","v":"Other (specify)"},null,null,{"$f":"IF(Instructions!$U$40=1,\"Total Daily Water Use \n(gpf)\",\"Total Daily Water Use \n(lpm)\")","v":"Total Daily Water Use \n(gpf)"}]
[null,null,null,null,null,null,"Non-\nResidential\n(sec)","Residential\n(sec)",null,null,"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"}]
[null,"_A",{"$f":"Instructions!$C$30","v":"Public lavatory (restroom) faucet"},null,null,{"$f":"IF(Instructions!$U$40=1,Instructions!$G$30,Instructions!$I$30)","v":0.5},{"$f":"Instructions!$K$30","v":30},{"$f":"Instructions!$L$30","v":0},"Yes",null,{"$f":"Instructions!$N$30","v":3},{"$f":"$F45*($G45/60)*$K45*D$7","v":26.25},{"$f":"Instructions!$O$30","v":0.5},{"$f":"$F45*($G45/60)*M45*$E$7","v":1.25},{"$f":"Instructions!$P$30","v":0.2},{"$f":"$F45*($G45/60)*O45*$F$7","v":0},{"$f":"Instructions!$Q$30","v":3},{"$f":"$F45*($G45/60)*$Q45*$G$7","v":0},{"$f":"Instructions!$R$30","v":0},{"$f":"F45*($H45/60)*S45*$H$7","v":0},null,{"$f":"$F45*($G45/60)*U45*$I$7","v":0},null,{"$f":"IF(I45=\"Yes\",SUM(L45,R45,N45,P45,T45,V45),0)","v":27.5}]
[null,"_B",{"$f":"Instructions!$C$31","v":"Private lavatory faucet"},null,null,{"$f":"IF(Instructions!$U$40=1,Instructions!$G$31,Instructions!$I$31)","v":2.2000000000000002},{"$f":"Instructions!$K$31","v":30},{"$f":"Instructions!$L$31","v":60},"No",null,{"$f":"Instructions!$N$31","v":0},{"$f":"$F46*($G46/60)*$K46*D$7","v":0},{"$f":"Instructions!$O$31","v":0},{"$f":"$F46*($G46/60)*M46*$E$7","v":0},{"$f":"Instructions!$P$31","v":0},{"$f":"$F46*($G46/60)*O46*$F$7","v":0},{"$f":"Instructions!$Q$31","v":0},{"$f":"$F46*($G46/60)*$Q46*$G$7","v":0},{"$f":"Instructions!$R$31","v":5},{"$f":"F46*($H46/60)*S46*$H$7","v":0},null,{"$f":"$F46*($G46/60)*U46*$I$7","v":0},null,{"$f":"IF(I46=\"Yes\",SUM(L46,R46,N46,P46,T46,V46),0)","v":0}]
[null,"_C",{"$f":"Instructions!$C$32","v":"Kitchen faucet"},null,null,{"$f":"IF(Instructions!$U$40=1,Instructions!$G$32,Instructions!$I$32)","v":2.2000000000000002},{"$f":"Instructions!$K$32","v":15},{"$f":"Instructions!$L$32","v":60},"Yes",null,{"$f":"Instructions!$N$32","v":1},{"$f":"$F47*($G47/60)*$K47*D$7","v":19.25},{"$f":"Instructions!$O$32","v":0},{"$f":"$F47*($G47/60)*M47*$E$7","v":0},{"$f":"Instructions!$P$32","v":0},{"$f":"$F47*($G47/60)*O47*$F$7","v":0},{"$f":"Instructions!$Q$32","v":0},{"$f":"$F47*($G47/60)*$Q47*$G$7","v":0},{"$f":"Instructions!$R$32","v":4},{"$f":"F47*($H47/60)*S47*$H$7","v":0},null,{"$f":"$F47*($G47/60)*U47*$I$7","v":0},null,{"$f":"IF(I47=\"Yes\",SUM(L47,R47,N47,P47,T47,V47),0)","v":19.25}]
[null,"_D",{"$f":"Instructions!$C$33","v":"Showerhead"},null,null,{"$f":"IF(Instructions!$U$40=1,Instructions!$G$33,Instructions!$I$33)","v":2.5},{"$f":"Instructions!$K$33","v":300},{"$f":"Instructions!$L$33","v":480},"Yes",null,{"$f":"Instructions!$N$33","v":0.1},{"$f":"$F48*($G48/60)*$K48*D$7","v":43.75},{"$f":"Instructions!$O$33","v":0},{"$f":"$F48*($G48/60)*M48*$E$7","v":0},{"$f":"Instructions!$P$33","v":0},{"$f":"$F48*($G48/60)*O48*$F$7","v":0},{"$f":"Instructions!$Q$33","v":0},{"$f":"$F48*($G48/60)*$Q48*$G$7","v":0},{"$f":"Instructions!$R$33","v":1},{"$f":"F48*($H48/60)*S48*$H$7","v":0},null,{"$f":"$F48*($G48/60)*U48*$I$7","v":0},null,{"$f":"IF(I48=\"Yes\",SUM(L48,R48,N48,P48,T48,V48),0)","v":43.75}]
[null,{"$f":"IF(Instructions!$U$40=1,\"Baseline case annual flow volume (gallons/year)\",\"Baseline case annual flow volume (liters/year)\")","v":"Baseline case annual flow volume (gallons/year)"},null,null,null,null,null,null,{"$f":"(SUM(X45:X48)*$I$13)","v":22806}]
[]
[null,"For projects with metering faucets"]
[null,"Enter the resulting per minute flow rate into the design case flow rate section for public lavatory faucet.",null,{"$f":"IF(Instructions!$U$40=1,\"Gallons per Cycle\",\"Liters per Cycle\")","v":"Gallons per Cycle"},"Cycle Duration\n(sec)",{"$f":"IF(Instructions!$U$40=1,\"Flow Rate (gpm)\",\"Flow Rate (lpm)\")","v":"Flow Rate (gpm)"}]
[null,null,null,null,null,{"$f":"IFERROR((D53*60)/E53,0)","v":0}]
[]
[null,"Table 5. Flow Fixtures Design Case"]
[null,"1. Select the equivalent baseline fixture in the Fixture Reference column.\n2. Select the Fixture Type installed on the project.\n3. Enter the Flow Rate identified by the manufacturer - for metering faucets, use the metering faucet calculator to determine flow rate.\n4. Enter Fixture Information that matches the information provided for cutsheets.\n5. Enter Percent of Occupants with access to the fixture. If the fixture is installed in all restrooms, use 100%. Percentages for each Fixture Reference must total 100%."]
[null,"Fixture Reference","Design Case Fixture Type",{"$f":"IF(Instructions!U40=1,\"Flow Rate (gpm)\",\"Flow Rate (lpm)\")","v":"Flow Rate (gpm)"},"Percent of Occupants\n(%)","Fixture Information",null,"Duration",null,null,"Employees (FTE)",null,"Visitors",null,"Retail Customers",null,"Students",null,"Residential",null,{"$f":"IF($I$6=\"Other (please specify)\",\"Other\",$I$6)","v":"Other (specify)"},null,null,{"$f":"IF(Instructions!$U$40=1,\"Total Daily Water Use \n(gpf)\",\"Total Daily Water Use \n(lpm)\")","v":"Total Daily Water Use \n(gpf)"}]
[null,null,null,null,null,"Fixture Manufact.","Fixture \nModel","Non-\nResidential\n(sec)","Residential\n(sec)",null,"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"},"Uses \nper Day",{"$f":"IF(Instructions!$U$40=1,\"Daily Water Use \n(gpf)\",\"Daily Water Use \n(lpm)\")","v":"Daily Water Use \n(gpf)"}]
[{"$f":"IF(B59>=0,1,1)","v":1},"_A",{"$f":"IF(ISBLANK(B59),\"\",VLOOKUP(B59,B$43:V$48,2,0))","v":"Public lavatory (restroom) faucet"},0.5,100,"Sloan","EAF-275",{"$f":"IF(ISBLANK(B59),0,VLOOKUP(B59,$B$45:$U$48,6,0))","v":30},{"$f":"IF(ISBLANK(B59),0,VLOOKUP(B59,$B$45:$U$48,7,0))","v":0},null,{"$f":"IF(ISBLANK(B59),0,VLOOKUP($B59,$B$43:$V$48,10,0))","v":3},{"$f":"$D59*($H59/60)*K59*($D$7*($E59/100))","v":26.25},{"$f":"IF(ISBLANK(B59),0,VLOOKUP($B59,$B$43:$V$48,12,0))","v":0.5},{"$f":"$D59*($H59/60)*M59*(E$7*($E59/100))","v":1.25},{"$f":"IF(ISBLANK(B59),0,VLOOKUP($B59,$B$43:$V$48,14,0))","v":0.2},{"$f":"$D59*($H59/60)*O59*(F$7*($E59/100))","v":0},{"$f":"IF(ISBLANK(B59),0,VLOOKUP($B59,$B$43:$V$48,16,0))","v":3},{"$f":"$D59*($H59/60)*Q59*($G$7*($E59/100))","v":0},{"$f":"IF(ISBLANK(B59),0,VLOOKUP($B59,$B$43:$V$48,18,0))","v":0},{"$f":"$D59*($I59/60)*S59*($H$7*($E59/100))","v":0},{"$f":"IF(ISBLANK(B59),0,VLOOKUP($B59,$B$43:$V$48,20,0))","v":0},{"$f":"$D59*($H59/60)*U59*(I$7*($E59/100))","v":0},null,{"$f":"SUM(L59,R59,N59,P59,T59,V59)","v":27.5}]
[{"$f":"IF(B60>=0,1,1)","v":1},"_C",{"$f":"IF(ISBLANK(B60),\"\",VLOOKUP(B60,B$43:V$48,2,0))","v":"Kitchen faucet"},2.2000000000000002,100,"Delta","23C334",{"$f":"IF(ISBLANK(B60),0,VLOOKUP(B60,$B$45:$U$48,6,0))","v":15},{"$f":"IF(ISBLANK(B60),0,VLOOKUP(B60,$B$45:$U$48,7,0))","v":60},null,{"$f":"IF(ISBLANK(B60),0,VLOOKUP($B60,$B$43:$V$48,10,0))","v":1},{"$f":"$D60*($H60/60)*K60*($D$7*($E60/100))","v":19.25},{"$f":"IF(ISBLANK(B60),0,VLOOKUP($B60,$B$43:$V$48,12,0))","v":0},{"$f":"$D60*($H60/60)*M60*(E$7*($E60/100))","v":0},{"$f":"IF(ISBLANK(B60),0,VLOOKUP($B60,$B$43:$V$48,14,0))","v":0},{"$f":"$D60*($H60/60)*O60*(F$7*($E60/100))","v":0},{"$f":"IF(ISBLANK(B60),0,VLOOKUP($B60,$B$43:$V$48,16,0))","v":0},{"$f":"$D60*($H60/60)*Q60*($G$7*($E60/100))","v":0},{"$f":"IF(ISBLANK(B60),0,VLOOKUP($B60,$B$43:$V$48,18,0))","v":4},{"$f":"$D60*($I60/60)*S60*($H$7*($E60/100))","v":0},{"$f":"IF(ISBLANK(B60),0,VLOOKUP($B60,$B$43:$V$48,20,0))","v":0},{"$f":"$D60*($H60/60)*U60*(I$7*($E60/100))","v":0},null,{"$f":"SUM(L60,R60,N60,P60,T60,V60)","v":19.25}]
[1,"_D",{"$f":"IF(ISBLANK(B61),\"\",VLOOKUP(B61,B$43:V$48,2,0))","v":"Showerhead"},2.5,100,"Symmons","96-500-B30-L-V",{"$f":"IF(ISBLANK(B61),0,VLOOKUP(B61,$B$45:$U$48,6,0))","v":300},{"$f":"IF(ISBLANK(B61),0,VLOOKUP(B61,$B$45:$U$48,7,0))","v":480},null,0.1,{"$f":"$D61*($H61/60)*K61*($D$7*($E61/100))","v":43.75},0,{"$f":"$D61*($H61/60)*M61*(E$7*($E61/100))","v":0},0,{"$f":"$D61*($H61/60)*O61*(F$7*($E61/100))","v":0},0,{"$f":"$D61*($H61/60)*Q61*($G$7*($E61/100))","v":0},1,{"$f":"$D61*($I61/60)*S61*($H$7*($E61/100))","v":0},0,{"$f":"$D61*($H61/60)*U61*(I$7*($E61/100))","v":0},null,{"$f":"SUM(L61,R61,N61,P61,T61,V61)","v":43.75}]
[null,null,{"$f":"IF(ISBLANK(B62),\"\",VLOOKUP(B62,B$43:V$48,2,0))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(B62),0,VLOOKUP(B62,$B$45:$U$48,6,0))","v":0},{"$f":"IF(ISBLANK(B62),0,VLOOKUP(B62,$B$45:$U$48,7,0))","v":0},null,0,{"$f":"$D62*($H62/60)*K62*($D$7*($E62/100))","v":0},0,{"$f":"$D62*($H62/60)*M62*(E$7*($E62/100))","v":0},0,{"$f":"$D62*($H62/60)*O62*(F$7*($E62/100))","v":0},0,{"$f":"$D62*($H62/60)*Q62*($G$7*($E62/100))","v":0},0,{"$f":"$D62*($I62/60)*S62*($H$7*($E62/100))","v":0},0,{"$f":"$D62*($H62/60)*U62*(I$7*($E62/100))","v":0},null,{"$f":"SUM(L62,R62,N62,P62,T62,V62)","v":0}]
[null,null,{"$f":"IF(ISBLANK(B63),\"\",VLOOKUP(B63,B$43:V$48,2,0))","v":""},null,null,null,null,{"$f":"IF(ISBLANK(B63),0,VLOOKUP(B63,$B$45:$U$48,6,0))","v":0},{"$f":"IF(ISBLANK(B63),0,VLOOKUP(B63,$B$45:$U$48,7,0))","v":0},null,0,{"$f":"$D63*($H63/60)*K63*($D$7*($E63/100))","v":0},0,{"$f":"$D63*($H63/60)*M63*(E$7*($E63/100))","v":0},0,{"$f":"$D63*($H63/60)*O63*(F$7*($E63/100))","v":0},0,{"$f":"$D63*($H63/60)*Q63*($G$7*($E63/100))","v":0},0,{"$f":"$D63*($I63/60)*S63*($H$7*($E63/100))","v":0},0,{"$f":"$D63*($H63/60)*U63*(I$7*($E63/100))","v":0},null,{"$f":"SUM(L63,R63,N63,P63,T63,V63)","v":0}]
["B",{"$f":"IF(Instructions!$U$40=1,\"Design case annual flow volume (gallons/year)\",\"Design case annual flow volume (liters/year)\")","v":"Design case annual flow volume (gallons/year)"},null,null,null,null,null,null,{"$f":"(SUM(X59:X63)*$I$13)","v":22806}]

{"sheet":"Summary D+C","index":3,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[[14,3,14,11],[7,4,9,4],[7,5,7,8],[7,9,7,12],[8,5,8,8],[8,9,8,12],[7,3,9,3],[12,3,12,11],[13,3,13,11]]}
[]
[null,null,1]
[null,null,1,"Summary for Design and Construction Rating Systems"]
[null,null,1,"Note: Baseline and design volumes are READ-ONLY. To edit, see the previous tab(s). "]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1,"Group Name","Percent Occupants using\nGroup\n(%)","Baseline Case",null,null,null,"Design Case"]
[null,null,null,null,null,{"$f":"IF(Instructions!U40=1,\"(gallons/year)\",\"(liters/year)\")","v":"(gallons/year)"},null,null,null,{"$f":"IF(Instructions!U40=1,\"(gallons/year)\",\"(liters/year)\")","v":"(gallons/year)"}]
[null,null,1,null,null,"Annual \nFlush \nVolume","Annual \nFlow \nVolume","Annual Baseline Consumption","Total\nBaseline Consumption","Annual \nFlush \nVolume","Annual \nFlow \nVolume","Annual Design\nConsumption","Total\nDesign Consumption"]
[null,null,{"$f":"IF(OR(D11=\"Introduction\",D11=\"Base Calc\",D11=\"Summary D+C\",D11=\"Summary O+M\",D11=\"\",D11=0),0,1)","v":1},{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A3),1),\"\")","v":"Group 1"},null,{"$f":"INDIRECT(\"'\"&D11&\"'!$AA$7\")","v":39816},{"$f":"INDIRECT(\"'\"&$D11&\"'!$AA$8\")","v":22806},{"$f":"F11+G11","v":62622},{"$f":"H11*E11","v":0},{"$f":"INDIRECT(\"'\"&$D11&\"'!$AA$9\")","v":20225.52},{"$f":"INDIRECT(\"'\"&$D11&\"'!$AA$10\")","v":22806},{"$f":"J11+K11","v":43031.519999999997},{"$f":"L11*E11","v":0}]
[null,null,1]
[null,"A",1,{"$f":"IF(Instructions!U40=1,\"Annual baseline water consumption (gallons/year)\",\"Annual baseline water consumption (liters/year)\")","v":"Annual baseline water consumption (gallons/year)"},null,null,null,null,null,null,null,null,{"$f":"SUM(I11:I12)","v":0}]
[null,null,1,{"$f":"IF(Instructions!U40=1,\"Annual design water consumption (gallons/year)\",\"Annual design water consumption (liters/year)\")","v":"Annual design water consumption (gallons/year)"},null,null,null,null,null,null,null,null,{"$f":"SUM(M11:M12)","v":0}]
[null,null,1,"Percent reduction from baseline (%)",null,null,null,null,null,null,null,null,{"$f":"IF(M14=0,0,(M13-M14)/M13)","v":0}]
[null,null,1]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(#REF!),1),\"\")","v":""}]

{"sheet":"Summary O+M","index":4,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[[6,7,6,12],[22,3,22,11],[13,3,15,3],[13,4,15,4],[13,5,13,8],[13,9,13,12],[14,5,14,8],[14,9,14,12],[18,3,18,11],[19,3,19,11],[20,3,20,11],[21,3,21,11]]}
[]
[null,null,1]
[null,null,1,"Summary for Operations and Maintenance Rating Systems"]
[null,null,1,"Note: Baseline and design volumes are READ-ONLY. To edit, see the previous tab(s). "]
[null,null,1]
[null,null,1]
[null,null,1,"Unrenovated percentage of fixtures installed before 1995",null,null,0,{"$f":"IF(AND(SUM(F7:F9)>0,SUM(F7:F9)<1),\"ERROR: The total percentage of fixtures installed must equal 100.\",\"\")","v":""}]
[null,null,1]
[null,null,1,"Renovated percentage of fixtures installed in 1995 or later",null,null,1]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1]
[null,null,1,"Group Name","Percent Occupants using \nGroup\n(%)","Baseline Case",null,null,null,"Design Case"]
[null,null,null,null,null,{"$f":"IF(Instructions!U40=1,\"(gallons/year)\",\"(liters/year)\")","v":"(gallons/year)"},null,null,null,{"$f":"IF(Instructions!U40=1,\"(gallons/year)\",\"(liters/year)\")","v":"(gallons/year)"}]
[null,null,1,null,null,"Annual \nFlush Volume","Annual \nFlow \nVolume","Annual Baseline Consumption","Total\nBaseline Consumption","Annual \nFlush \nVolume","Annual \nFlow \nVolume","Annual Design\nConsumption","Total\nDesign Consumption"]
[null,null,{"$f":"IF(OR(D17=\"Introduction\",D17=\"Base Calc\",D17=\"Summary D+C\",D17=\"Summary O+M\",D17=\"\",D17=0),0,1)","v":1},{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(A3),1),\"\")","v":"Group 1"},1,{"$f":"INDIRECT(\"'\"&D17&\"'!$AA$7\")","v":39816},{"$f":"INDIRECT(\"'\"&$D17&\"'!$AA$8\")","v":22806},{"$f":"F17+G17","v":62622},{"$f":"H17*E17","v":62622},{"$f":"INDIRECT(\"'\"&$D17&\"'!$AA$9\")","v":20225.52},{"$f":"INDIRECT(\"'\"&$D17&\"'!$AA$10\")","v":22806},{"$f":"J17+K17","v":43031.519999999997},{"$f":"L17*E17","v":43031.519999999997}]
[null,null,1]
[null,"A",1,{"$f":"IF(Instructions!U40=1,\"Annual baseline water consumption (gallons/year)\",\"Annual baseline water consumption (liters/year)\")","v":"Annual baseline water consumption (gallons/year)"},null,null,null,null,null,null,null,null,{"$f":"SUM(I17:I18)","v":62622}]
[null,null,1,{"$f":"IF(Instructions!U40=1,\"Annual design water consumption (gallons/year)\",\"Annual design water consumption (liters/year)\")","v":"Annual design water consumption (gallons/year)"},null,null,null,null,null,null,null,null,{"$f":"SUM(M17:M18)","v":43031.519999999997}]
[null,null,1,"Baseline multiplier (%)",null,null,null,null,null,null,null,null,{"$f":"((G7*150%)+(G9*120%))","v":1.2}]
[null,null,1,{"$f":"IF(Instructions!U40=1,\"Water consumption maximum (gallons/year)\",\"Water consumption maximum (liters/year)\")","v":"Water consumption maximum (gallons/year)"},null,null,null,null,null,null,null,null,{"$f":"M19*M21","v":75146.399999999994}]
[null,null,1,"Percentage below water consumption maximum (%)",null,null,null,null,null,null,null,null,{"$f":"IF(M22=0,0,(M22-M20)/M22)","v":0.4274}]
[null,null,1]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX(MID(Sheets,FIND(\"]\",Sheets)+1,255),ROW(#REF!),1),\"\")","v":""}]