{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions","3.2 Green Roof","3.3 Rainwater Harvesting","3.4 Impervious Surface Discon.","3.5 Permeable Pavement","3.6 Bioretention","3.8 Infiltration","3.9 O-1 Grass Channel","3.9 O-2 Dry Swale","3.9 O-3 Wet Swale","3.10, 3.11 SW Ponds + Wetlands","3.14 Tree Planting Preservation"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":11,"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":"Instructions","index":0,"n_rows":6,"n_cols":17,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change Log"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version","Date Published","Revisions Made"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"2020-01-31","Fully updated to coincide with release of 2020 Stormwater Management Guidebook"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"2020-04-17","Error in volume calculation for non-irrigated green roofs fixed.\nEach sheet protected to avoid erroneous changes to equations."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"2020-11-25","Added Sump Storage Volume calculation to 3.5 Permeable Pavement."]

{"sheet":"3.2 Green Roof","index":1,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,"Do Not Delete"]
[]
[null,null,null,null,null,null,null,null,"Irrigated"]
[null,null,null,null,null,null,null,null,"Non-irrigated"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Variable","Value","Units","Notes on use"]
[null,"SA",null,"ft2","Total green roof area"]
[null,"d",null,"in","Minimum of 3 inches"]
[null,"ŋ1",null,"unitless","If unknown, enter 0.10 as a baseline default."]
[null,"DL",null,"in","If drainage and media layers are combined, enter 0."]
[null,"ŋ2",null,"unitless","If unknown, enter 0.0 as a baseline default."]
[null,"Irrigation",null,"n/a","Select irrigation type from drop down list."]
[null,"Sv",{"$f":"IF(C34=\"Irrigated\",C29*((C30*C31)+(C32*C33))/12*0.5,IF(C34=\"Non-Irrigated\",C29*((C30*C31)+(C32*C33))/12,\"Select Irrigation Value\"))","v":"Select Irrigation Value"},"ft3"]
[null,"Rv",{"$f":"C35","v":"Select Irrigation Value"},"ft3","Calculated based on irrigation type selected."]
[null,"Rv",{"$f":"IFERROR(C36*7.48,\"\")","v":""},"gallons","Converted from cubic feet."]

{"sheet":"3.3 Rainwater Harvesting","index":2,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["3.3 RAINWATER HARVESTING"]
[]
["Download and complete the 2019 Rainwater Harvesting Retention Calculator from: "]
[null,"https://doee.dc.gov/swguidebook"]

{"sheet":"3.4 Impervious Surface Discon.","index":3,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Type","SAp (ft2)","Rv (ft3)","Rv (gallons)"]
[null,"D-1 (A/B)",null,{"$f":"4*C26/100","v":0},{"$f":"30*C26/100","v":0}]
[null,"D-1 (C/D)",null,{"$f":"2*C27/100","v":0},{"$f":"15*C27/100","v":0}]
[null,"D-2",null,{"$f":"6*C28/100","v":0},{"$f":"45*C28/100","v":0}]
[null,"D-3",null,{"$f":"4*C29/100","v":0},{"$f":"30*C29/100","v":0}]
[null,"Totals",{"$f":"SUM(C26:C29)","v":0},{"$f":"SUM(D26:D29)","v":0},{"$f":"SUM(E26:E29)","v":0}]

{"sheet":"3.5 Permeable Pavement","index":4,"n_rows":68,"n_cols":8,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Do Not Delete"]
[]
[null,null,null,null,null,null,null,"Enhanced"]
[null,null,null,null,null,null,null,"Underdrained Enhanced"]
[null,null,null,null,null,null,null,"Standard"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Variable","Value","Units","Notes on use"]
[null,"Design Type",null,"Select","From drop down list, select design type"]
[null,"Ap",null,"ft2","Total permeable pavement surface area"]
[null,"dp",null,"ft","The reservoir layer depth (includes infiltration sump depth for underdrained Enhanced designs)"]
[null,"dsump",null,"ft","For Underdrained Enhanced designs , enter depth of infiltration sump."]
[null,"ŋr",0.4,"unitless","0.4 for No. 57 stone"]
[null,"Ksat",null,"ft/day","Field-verified. With impermeable liners, enter 0. "]
[null,"tf",8.3000000000000004E-2,"days","Assume 0.083 days (2 hours)."]
[null,"td",{"$f":"IF(C56=\"\",\"\",IF(C56=\"\",\"Select Design Type\",IF(C56=\"Standard\",\"Not Applicable\",IF(C56=\"Enhanced\",C58*C60/C61,IF(C56=\"Underdrained Enhanced\",C59*C60/C61)))))","v":""},"days","Enhanced design volumes or Underdrained Enhanced sump volumes must drain within 48 hours. Calculated based on Design Type selected."]
[null,"Check td",{"$f":"IF(C56=\"Standard\", \"Not Applicable\", IF(C61=0,\"Not Applicable\", IF(AND(C63<=2),\"Within time\", \"Not within time\")))","v":"Not Applicable"},null,"Determines if drawdown time is less than 48 hours."]
[null,"Sv",{"$f":"IF(C56=\"\",\"Select Design Type\",C57*((C58*C60)+(C61*C62)))","v":"Select Design Type"},"ft3","Calculated based on design type selected."]
[null,"Sump Storage Volume",{"$f":"IF(C56=\"Underdrained Enhanced\",C57*((C59*C60)+(C61*C62)),\"N/A\")","v":"N/A"},"ft3","Only for Underdrain Enhanced design type."]
[null,"Rv",{"$f":"IF(C56=\"Enhanced\",C65,IF(C56=\"Standard\",5*C57/100,IF(C56=\"Underdrained Enhanced\",(C57*((C59*C60)+(C61*C62))+5*C57/100),\"Select Design Type\")))","v":"Select Design Type"},"ft3","Calculated based on design type selected."]
[null,"Rv",{"$f":"IFERROR(C67*7.48,\"\")","v":""},"gallons","Converted from cubic feet."]

{"sheet":"3.6 Bioretention","index":5,"n_rows":75,"n_cols":8,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Do Not Delete"]
[]
[]
[null,null,null,null,null,null,null,"Enhanced"]
[null,null,null,null,null,null,null,"Enhanced with Underdrain"]
[null,null,null,null,null,null,null,"Standard"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Variable","Value","Units","Notes on use"]
[null,"Type",null,"Select","From drop down list, select type of bioretention."]
[null,"SAtop ",null,"ft2"]
[null,"SAbottom ",null,"ft2"]
[null,"SAaverage",{"$f":"(C58+C59)/2","v":0},"ft2","Typical average"]
[null,"dmedia",null,"ft"]
[null,"ηmedia ",0.25,"unitless","Typically 0.25"]
[null,"dgravel",null,"ft"]
[null,"dsump",null,"ft","Depth of stone below underdrain (sump); only for Enhanced with Underdrain"]
[null,"ηgravel  ",0.4,"unitless","Typically 0.40"]
[null,"dponding ",null,"ft","Maximum depth is 1.5 ft; minimum depth is 0.25 ft."]
[null,"Sv",{"$f":"C59*((C61*C62)+((C63+C64)*C65))+C60*C66","v":0},"ft3"]
[null,"Ksat ",null,"ft/day","Must exceed 0.1 ft/day"]
[null,"td",3,"days","Must be within 3 days"]
[null,"nr",0.4,"unitless","Assumed to be 0.40"]
[null,"dsump",{"$f":"IF(C57=\"Enhanced with Underdrain\", C68*C69/C70, \"N/A\")","v":"N/A"},"ft","Maximum depth of stone below underdrain (sump) allowed."]
[null,"Svinfiltrate",{"$f":"C59*C68*C69","v":0},"ft3"]
[null,"Check for Svinfiltrate",{"$f":"IF(C57=\"\",\"Select Type\",IF(C57=\"Standard\",\"N/A\",IF(AND(C64>C71,C57=\"Enhanced with Underdrain\"),\"Exceeds 72 hours\",IF(AND(C64<=C71,C57=\"Enhanced with Underdrain\"),\"Drains within 72 hours\",IF(AND(C67>C72,C57=\"Enhanced\"),\"Exceeds 72 hours\",IF(AND(C67<=C72,C57=\"Enhanced\"),\"Drains within 72 hours\"))))))","v":"Select Type"},"N/A","Svinfltrate must be greater than or equal to Sv to ensure infiltration within 72 hours."]
[null,"Rv",{"$f":"IF(C57=\"\",\"Select Type\",IF(C57=\"Standard\", 0.6*C67,C67))","v":"Select Type"},"ft3","Calculated based on type selected."]
[null,"Rv",{"$f":"IFERROR(C74*7.48,\"\")","v":""},"gallons"]

{"sheet":"3.8 Infiltration","index":6,"n_rows":51,"n_cols":7,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"Do Not Delete"]
[]
[null,null,null,null,null,null,"Trench"]
[null,null,null,null,null,null,"Basin"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Variable","Value","Units","Notes on use"]
[null,"SA",null,"ft2"]
[null,"ηr ",0.4,"ft2","Typically 0.40"]
[null,"d",null,"ft"]
[null,"Ksat ",null,"ft/day","Must exceed 0.1 ft/day"]
[null,"tf",8.3000000000000004E-2,"days","Typically 2 hours, or 0.083 days"]
[null,"td",3,"days","Normally 3 days"]
[null,"Type",null,"Selection","From drop down list, select infiltration type"]
[null,"dmax",{"$f":"IF(C46=\"Basin\",(C43*C45),(C43*C45/C41))","v":0},"ft","Calculated based on infiltration type selected."]
[null,"dmax check",{"$f":"IF(C42<=C47, \"Within range\", \"Out of Range\")","v":"Within range"},"Check","Check to ensure depth is less than or equal to maximum allowable depth based on infiltration type seleced."]
[null,"Sv",{"$f":"IF(C46=\"Basin\", C40*(C42+(C43*C44)), C40*((C41*C42)+(C43*C44)))","v":0},"ft3","Calculated based on infiltration type selected."]
[null,"Rv",{"$f":"C49","v":0},"ft3"]
[null,"Rv",{"$f":"C50*7.48","v":0},"gallons"]

{"sheet":"3.9 O-1 Grass Channel","index":7,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Do Not Delete"]
[]
[null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,null,null,"No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"O-1","Amended? (Select)","Sv (ft3)","Rv (ft3)","Rv (gallons)"]
[null,1,null,null,{"$f":"IF(C22=\"Yes\",D22*0.3,D22*0.1)","v":0},{"$f":"E22*7.48","v":0}]
[null,2,null,null,{"$f":"IF(C23=\"Yes\",D23*0.3,D23*0.1)","v":0},{"$f":"E23*7.48","v":0}]
[null,3,null,null,{"$f":"IF(C24=\"Yes\",D24*0.3,D24*0.1)","v":0},{"$f":"E24*7.48","v":0}]
[null,4,null,null,{"$f":"IF(C25=\"Yes\",D25*0.3,D25*0.1)","v":0},0]
[null,5,null,null,{"$f":"IF(C26=\"Yes\",D26*0.3,D26*0.1)","v":0},0]
[null,"Totals",null,{"$f":"SUM(D22:D26)","v":0},{"$f":"SUM(E22:E26)","v":0},{"$f":"SUM(F22:F26)","v":0}]

{"sheet":"3.9 O-2 Dry Swale","index":8,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Do Not Delete"]
[]
[]
[null,null,null,null,null,null,null,"Enhanced"]
[null,null,null,null,null,null,null,"Enhanced with Underdrain"]
[null,null,null,null,null,null,null,"Standard"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Variable","Value","Units","Notes on use"]
[null,"SAtop ",null,"ft2"]
[null,"SAbottom ",null,"ft2"]
[null,"SAaverage",{"$f":"(C29+C30)/2","v":0},"ft2","Typical average"]
[null,"dmedia",null,"ft"]
[null,"ηmedia ",0.25,"unitless","Typically 0.25"]
[null,"dgravel",null,"ft"]
[null,"ηgravel  ",0.4,"unitless","Typically 0.40"]
[null,"dponding ",null,"ft","Maximum depth is 1.5 ft; minimum depth is 0.25 ft."]
[null,"Sv",{"$f":"C30*((C32*C33)+(C34*C35))+C31*C36","v":0},"ft3"]
[null,"Rv",{"$f":" 0.6*C37","v":0},"ft3"]
[null,"Rv",{"$f":"IFERROR(C38*7.48,\"\")","v":0},"gallons"]

{"sheet":"3.9 O-3 Wet Swale","index":9,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"O-3","Spool(ft3)","ED24hr (ft3)","Sv (ft3)","Rv (ft3)","Rv (gallons)"]
[null,1,null,null,{"$f":"C20+D20","v":0},{"$f":"0.1*E20","v":0},{"$f":"F20*7.48","v":0}]
[null,2,null,null,{"$f":"C21+D21","v":0},{"$f":"0.1*E21","v":0},{"$f":"F21*7.48","v":0}]
[null,3,null,null,0,{"$f":"0.1*E22","v":0},{"$f":"F22*7.48","v":0}]
[null,4,null,null,0,0,0]
[null,5,null,null,0,0,0]
[null,"Totals",{"$f":"SUM(C20:C24)","v":0},{"$f":"SUM(D20:D24)","v":0},{"$f":"SUM(E20:E24)","v":0},{"$f":"SUM(F20:F24)","v":0},{"$f":"SUM(G20:G24)","v":0}]

{"sheet":"3.10, 3.11 SW Ponds + Wetlands","index":10,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Type","Sv (ft3)","Rv (ft3)","Rv (gallons)"]
[null,"C-1",null,{"$f":"C27*0.1","v":0},{"$f":"D27*7.48","v":0}]
[null,"C-2",null,{"$f":"C28*0.1","v":0},{"$f":"D28*7.48","v":0}]
[null,"C-3",null,{"$f":"C29*0.1","v":0},{"$f":"D29*7.48","v":0}]
[null,"W-1",null,0,0]
[null,"W-2",null,0,0]
[null,"Totals",{"$f":"SUM(C27:C31)","v":0},{"$f":"SUM(D27:D31)","v":0},{"$f":"SUM(E27:E31)","v":0}]

{"sheet":"3.14 Tree Planting Preservation","index":11,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"Rv (ft3)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Type","n","Rvtype (ft3)","Rvtype (gallons)","Rv (ft3)","Rv (gallons)"]
[null,"T-1SMALL ",null,5,37.5,{"$f":"C37*D37","v":0},{"$f":"C37*E37","v":0}]
[null,"T-1LARGE",null,10,75,{"$f":"C38*D38","v":0},{"$f":"C38*E38","v":0}]
[null," T-2SMALL ",null,10,150,{"$f":"C39*D39","v":0},{"$f":"C39*E39","v":0}]
[null,"T-2LARGE",null,20,150,0,0]
[null,"T-2SPECIAL",null,30,225,0,0]
[null,"T-2HERITAGE",null,40,300,0,0]
[null,"Totals",{"$f":"SUM(C37:C41)","v":0},null,null,{"$f":"SUM(F37:F41)","v":0},{"$f":"SUM(G37:G41)","v":0}]