{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Baseline Calculation","Landscape Water Requirement","Summary"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":5,"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":"Instructions","index":0,"n_rows":71,"n_cols":12,"rows_kept":71,"cut":false,"hidden":false,"merged":[[19,4,19,8],[2,4,2,8],[5,4,5,8],[6,4,6,8],[13,4,13,7],[16,4,16,8],[58,2,58,6],[59,2,59,6],[52,2,52,8],[27,6,27,8],[36,2,36,4],[37,2,37,4],[50,2,50,4],[51,2,51,4],[55,2,56,6],[57,2,57,6],[55,7,55,8],[46,2,47,4],[48,2,48,4],[49,2,49,4],[38,2,38,4],[46,5,46,8],[43,2,43,5],[35,2,35,5],[39,2,39,4],[40,2,40,4],[41,2,41,4],[42,2,42,4],[27,2,28,5],[29,2,29,5],[30,2,30,5],[31,2,31,5],[32,2,32,5]]}
[]
[]
[null,null,null,null,"Outdoor Water Use Reduction Calculator\nLEED v4 for D+C - WE Prerequisite Outdoor Water Use Reduction and WE Credit Outdoor Water Use Reduction\nLEED v4 for O+M - WE Credit Outdoor 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,"SI 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 Baseline Calculation tab to determine the peak watering month."]
[]
[null,null,null,null,"Step 4. "]
[null,null,null,null,"Complete the Landscape Water Requirement tab to determine the monthly landscape water requirement."]
[]
[null,null,null,null,"Step 5. "]
[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,"Plant Type or Landscape Feature and Associated Landscape Coefficient"]
[null,null,"Source: LEED for Homes Rating System 2008"]
[null,null,"Plant Type or Landscape Feature",null,null,null,"KL"]
[null,null,null,null,null,null,"Low","Medium","High"]
[null,null,"Trees",null,null,null,0.2,0.5,0.9]
[null,null,"Shrubs",null,null,null,0.2,0.5,0.7]
[null,null,"Groundcover",null,null,null,0.2,0.5,0.7]
[null,null,"Turfgrass",null,null,null,0.6,0.7,0.8]
[]
[null,null,"Distribution Uniformity"]
[null,null,"Source: (The Irrigation Association, October 2001) Landscape Irrigation Scheduling and Water Management, IA 2005"]
[null,null,"Irrigation Type",null,null,"DU(LQ) \nor EU*"]
[null,null,"Drip (standard)",null,null,0.7]
[null,null,"Drip (press comp)",null,null,0.9]
[null,null,"Fixed spray",null,null,0.65]
[null,null,"Micro spray",null,null,0.7]
[null,null,"Rotor",null,null,0.7]
[null,null,"No irrigation",null,null,"N/A"]
[null,null,"* Lower quarter distribution uniformity (DULQ) applies to sprinkler zones and emission uniformity (EU) applies to drip/microirrigation zones. "]
[]
[null,null,"Appropriate Irrigation Types - Landscaped Areas with Irrigation Systems"]
[null,null,"Plant Type",null,null,"Irrigation Type"]
[null,null,null,null,null,"Drip\n(standard)","Drip\n(press comp)","Fixed \nSpray","Micro \nSpray"]
[null,null,"Trees",null,null,"x","x",null,"x*"]
[null,null,"Shrubs",null,null,"x","x",null,"x*"]
[null,null,"Groundcover",null,null,"x","x",null,"x*"]
[null,null,"Turfgrass",null,null,"x","x","x","x"]
[null,null,"* Micro spray may only be used on vegetation other than turfgrass if it meets the definition of microirrigation system, which according to the 2009 WaterSense Single-Family New Home Specification is: \"The frequent application of small quantities of water on or below the surgace as drops, tiny streams or miniature spray through emitters or applicators placed along a water delivery line. Microirrigation encompasses a number of methods or concepts, such as bubbler, drip, trickle, mist or spray, and subsurface irrigation. For the purposes of this specification, microirrigation includes emission devices that have flow rates less than 30 gallons per hour (114 liters per hour).\""]
[]
[null,null,"Appropriate Irrigation Types - Landscaped Areas without Irrigation Systems"]
[null,null,"Plant Type or Landscape Feature",null,null,null,null,"Irrigation Type"]
[null,null,null,null,null,null,null,"Drip\n(standard)","Fixed \nSpray"]
[null,null,"Trees, shrubs, or groundcover with low water requirements (KL = 0.2)",null,null,null,null,"x"]
[null,null,"Trees, shrubs, or groundcover with medium or high water requirements (KL > 0.2)",null,null,null,null,null,"x"]
[null,null,"Turfgrass with low, medium, or high water requirements (KL > 0.2)",null,null,null,null,null,"x"]
[]
[]
[null,null,null,null,null,null,null,null,null,"v02"]
[null,null,null,null,null,null,null,null,null,"Copyright © 2012"]
[null,null,null,null,null,null,null,null,null,"U.S. Green Building Council"]
[null,null,null,null,null,null,null,null,null,"All Rights Reserved"]
[null,null,null,null,null,null,null,null,null,"Last updated 8/2/2016"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"UOM"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I10=\"IP units\",1,2)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,"1 = IP, 2 = SI"]

{"sheet":"Baseline Calculation","index":1,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,1,25,3],[4,1,4,3],[24,1,24,3],[7,1,7,4],[22,1,22,3],[21,1,21,3],[23,1,23,3]]}
[]
[null,"Baseline Calculation"]
[]
[]
[null,{"$f":"CONCATENATE(\"Landscaped area \",IF(Instructions!$L$70=1,\"(sq ft)\",\"(sq m)\"))","v":"Landscaped area (sq m)"}]
[]
[null,"Table: Peak watering month"]
[null,"Determine the peak watering month at the project location by entering the monthly rainfall and evapotranspiration rate in the table below. The month with the highest watering demand is the peak watering month."]
[null,null,{"$f":"CONCATENATE(\"Monthly\nRainfall\n\",IF(Instructions!$L$70=1,\"(in)\",\"(mm)\"))","v":"Monthly\rRainfall\r(mm)"},{"$f":"CONCATENATE(\"Monthly\nETo\n\",IF(Instructions!$L$70=1,\"(in)\",\"(mm)\"))","v":"Monthly\rETo\r(mm)"},{"$f":"CONCATENATE(\"Watering\nDemand\n\",IF(Instructions!$L$70=1,\"(in)\",\"(mm)\"))","v":"Watering\rDemand\r(mm)"},null,"Rank Watering Demand"]
[null,"January",null,null,{"$f":"D10-C10","v":0},null,{"$f":"_xlfn.RANK.EQ(E10,$E$10:$E$21)","v":1}]
[null,"February",null,null,{"$f":"D11-C11","v":0},null,1]
[null,"March",null,null,0,null,1]
[null,"April",null,null,0,null,1]
[null,"May",null,null,0,null,1]
[null,"June",null,null,0,null,1]
[null,"July",null,null,0,null,1]
[null,"August",null,null,0,null,1]
[null,"September",null,null,0,null,1]
[null,"October",null,null,0,null,1]
[null,"November",null,null,0,null,1]
[null,"December",null,null,0,null,1]
[null,"Peak watering month",null,null,{"$f":"IF(SUM(E10:E21)=0,\"\",INDEX(B10:B21,MATCH(MIN(G10:G21),G10:G21,0)))","v":""}]
[null,{"$f":"CONCATENATE(\"Peak watering demand \",IF(Instructions!$L$70=1,\"(in)\",\"(mm)\"))","v":"Peak watering demand (mm)"},null,null,{"$f":"MAX(E10:E21)","v":0}]
[null,{"$f":"CONCATENATE(\"Peak watering month ETo \",IF(Instructions!$L$70=1,\"(in)\",\"(mm)\"))","v":"Peak watering month ETo (mm)"},null,null,{"$f":"IF(COUNTIF($G$10:$G$21,1)>1,MAX($D$10:$D$21),INDEX(D10:D21,MATCH(MIN(G10:G21),G10:G21,0)))","v":0}]
[null,{"$f":"CONCATENATE(\"Landscape water allowance \",IF(Instructions!$L$70=1,\"(gal/month)\",\"(l/month)\"))","v":"Landscape water allowance (l/month)"},null,null,{"$f":"IF(Instructions!$L$70=1,0.7*((E5*E24)*0.6233),0.7*(E5*E24))","v":0}]
[null,{"$f":"CONCATENATE(\"Landscape water baseline \",IF(Instructions!$L$70=1,\"(gal/month)\",\"(l/month)\"))","v":"Landscape water baseline (l/month)"},null,null,{"$f":"IF(Instructions!$L$70=1,(E5*E24)*0.6233,(E5*E24))","v":0}]

{"sheet":"Landscape Water Requirement","index":2,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[19,1,19,7],[20,1,20,7],[4,1,4,7],[7,7,8,7],[7,6,8,6],[7,5,8,5],[7,4,8,4],[7,3,8,3],[7,2,8,2],[7,1,8,1]]}
[]
[null,"Landscape Water Requirement"]
[]
[]
[null,{"$f":"CONCATENATE(\"Average monthly rainfall for the site's peak watering month \",IF(Instructions!$L$70=1,\"(in/month)\",\"(mm/month)\"))","v":"Average monthly rainfall for the site's peak watering month (mm/month)"},null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP('Baseline Calculation'!E22,'Baseline Calculation'!B10:D21,2,FALSE),\"\")","v":""}]
[]
[null,"Table: Landscape water requirement"]
[null,"Zone\nID",{"$f":"CONCATENATE(\"Hydrozone or\nLandscape Feature Area\n\",IF(Instructions!$L$70=1,\"(sq ft)\",\"(sq m)\"))","v":"Hydrozone or\rLandscape Feature Area\r(sq m)"},"Plant Type or \nLandscape Feature","Water Requirement","Landscape Coefficient \n(KL)","Irrigation \nType","Distribution Uniformity \n(DULQ)","LWRH"]
[null,null,null,null,null,null,null,null,{"$f":"IF(Instructions!$L$70=1,\"(gal/month)\",\"(l/month)\")","v":"(l/month)"}]
[{"$f":"IF(C10>0,0,0)","v":0},null,null,null,null,{"$f":"IFERROR(VLOOKUP(D10, Instructions!$C$29:$K$34, MATCH(E10, Instructions!$C$29:$K$29, 0), FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(G10,Instructions!$C$38:$F$43,4,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(Instructions!$L$70=1,(1/H10)*(('Baseline Calculation'!$E$24*F10)-(0.25*$I$5))*C10*0.6233,(1/H10)*(('Baseline Calculation'!$E$24*F10)-(0.25*$I$5))*(C10)),0)","v":0}]
[{"$f":"IF(C11>0,0,0)","v":0},null,null,null,null,{"$f":"IFERROR(VLOOKUP(D11, Instructions!$C$29:$K$34, MATCH(E11, Instructions!$C$29:$K$29, 0), FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(G11,Instructions!$C$38:$F$43,4,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(Instructions!$L$70=1,(1/H11)*(('Baseline Calculation'!$E$24*F11)-(0.25*$I$5))*C11*0.6233,(1/H11)*(('Baseline Calculation'!$E$24*F11)-(0.25*$I$5))*C11),0)","v":0}]
[0,null,null,null,null,{"$f":"IFERROR(VLOOKUP(D12, Instructions!$C$29:$K$34, MATCH(E12, Instructions!$C$29:$K$29, 0), FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(G12,Instructions!$C$38:$F$43,4,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(Instructions!$L$70=1,(1/H12)*(('Baseline Calculation'!$E$24*F12)-(0.25*$I$5))*C12*0.6233,(1/H12)*(('Baseline Calculation'!$E$24*F12)-(0.25*$I$5))*C12),0)","v":0}]
[0,null,null,null,null,{"$f":"IFERROR(VLOOKUP(D13, Instructions!$C$29:$K$34, MATCH(E13, Instructions!$C$29:$K$29, 0), FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(G13,Instructions!$C$38:$F$43,4,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(Instructions!$L$70=1,(1/H13)*(('Baseline Calculation'!$E$24*F13)-(0.25*$I$5))*C13*0.6233,(1/H13)*(('Baseline Calculation'!$E$24*F13)-(0.25*$I$5))*C13),0)","v":0}]
[0,null,null,null,null,{"$f":"IFERROR(VLOOKUP(D14, Instructions!$C$29:$K$34, MATCH(E14, Instructions!$C$29:$K$29, 0), FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(G14,Instructions!$C$38:$F$43,4,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(Instructions!$L$70=1,(1/H14)*(('Baseline Calculation'!$E$24*F14)-(0.25*$I$5))*C14*0.6233,(1/H14)*(('Baseline Calculation'!$E$24*F14)-(0.25*$I$5))*C14),0)","v":0}]
[0,null,null,null,null,{"$f":"IFERROR(VLOOKUP(D15, Instructions!$C$29:$K$34, MATCH(E15, Instructions!$C$29:$K$29, 0), FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(G15,Instructions!$C$38:$F$43,4,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(Instructions!$L$70=1,(1/H15)*(('Baseline Calculation'!$E$24*F15)-(0.25*$I$5))*C15*0.6233,(1/H15)*(('Baseline Calculation'!$E$24*F15)-(0.25*$I$5))*C15),0)","v":0}]
[0,null,null,null,null,{"$f":"IFERROR(VLOOKUP(D16, Instructions!$C$29:$K$34, MATCH(E16, Instructions!$C$29:$K$29, 0), FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(G16,Instructions!$C$38:$F$43,4,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(Instructions!$L$70=1,(1/H16)*(('Baseline Calculation'!$E$24*F16)-(0.25*$I$5))*C16*0.6233,(1/H16)*(('Baseline Calculation'!$E$24*F16)-(0.25*$I$5))*C16),0)","v":0}]
[{"$f":"IF(C17>0,0,0)","v":0},null,null,null,null,{"$f":"IFERROR(VLOOKUP(D17, Instructions!$C$29:$K$34, MATCH(E17, Instructions!$C$29:$K$29, 0), FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(G17,Instructions!$C$38:$F$43,4,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(Instructions!$L$70=1,(1/H17)*(('Baseline Calculation'!$E$24*F17)-(0.25*$I$5))*C17*0.6233,(1/H17)*(('Baseline Calculation'!$E$24*F17)-(0.25*$I$5))*C17),0)","v":0}]
[0,null,null,null,null,{"$f":"IFERROR(VLOOKUP(D18, Instructions!$C$29:$K$34, MATCH(E18, Instructions!$C$29:$K$29, 0), FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(G18,Instructions!$C$38:$F$43,4,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(Instructions!$L$70=1,(1/H18)*(('Baseline Calculation'!$E$24*F18)-(0.25*$I$5))*C18*0.6233,(1/H18)*(('Baseline Calculation'!$E$24*F18)-(0.25*$I$5))*C18),0)","v":0}]
[0,null,null,null,null,{"$f":"IFERROR(VLOOKUP(D19, Instructions!$C$29:$K$34, MATCH(E19, Instructions!$C$29:$K$29, 0), FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(G19,Instructions!$C$38:$F$43,4,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(Instructions!$L$70=1,(1/H19)*(('Baseline Calculation'!$E$24*F19)-(0.25*$I$5))*C19*0.6233,(1/H19)*(('Baseline Calculation'!$E$24*F19)-(0.25*$I$5))*C19),0)","v":0}]
["A",{"$f":"CONCATENATE(\"Total hydrozone or landscape feature area \",IF(Instructions!$L$70=1,\"(sq ft)\",\"(sq m)\"))","v":"Total hydrozone or landscape feature area (sq m)"},null,null,null,null,null,null,{"$f":"SUM(C10:C19)","v":0}]
[null,{"$f":"CONCATENATE(\"Landscape water requirement based on the site's peak watering month \",IF(Instructions!$L$70=1,\"(gal/month)\",\"(l/month)\"))","v":"Landscape water requirement based on the site's peak watering month (l/month)"},null,null,null,null,null,null,{"$f":"SUM(I10:I19)","v":0}]

{"sheet":"Summary","index":3,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Summary"]
[null,null,"Note: All information on this tab is READ-ONLY. To edit, see previous tabs. "]
[]
[null,null,{"$f":"CONCATENATE(\"Landscape water baseline \",IF(Instructions!$L$70=1,\"(gal/month)\",\"(l/month)\"))","v":"Landscape water baseline (l/month)"},null,null,null,null,{"$f":"'Baseline Calculation'!E26","v":0}]
[]
[null,null,{"$f":"CONCATENATE(\"Landscape water requirement (LWR) \",IF(Instructions!$L$70=1,\"(gal/month)\",\"(l/month)\"))","v":"Landscape water requirement (LWR) (l/month)"},null,null,null,null,{"$f":"'Landscape Water Requirement'!I21","v":0}]
[]
[null,null,"Percentage reduction from baseline (%)",null,null,null,null,{"$f":"IFERROR((1-'Landscape Water Requirement'!I21/'Baseline Calculation'!E26),0)","v":0},null,null,"Must be at least 30%"]