{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["X","Instructions","GSI Requirement Calculator","Pre-Sized Flow Control","Feasibility Checklist-RW","Feasibility Checklist-SFRParcel","GSI BMP Design Requirements"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":30,"comments":2,"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":"X","index":0,"n_rows":186,"n_cols":11,"rows_kept":186,"cut":false,"hidden":true,"merged":[[97,3,98,3],[97,0,98,0],[97,2,98,2],[70,2,71,2],[72,2,73,2],[91,0,94,0],[97,1,98,1],[89,0,90,0],[15,3,16,3],[17,2,19,2],[65,3,66,3],[15,2,16,2],[20,2,22,2],[26,2,28,2],[29,2,31,2],[32,2,35,2],[51,2,53,2],[60,2,62,2],[23,2,25,2],[54,2,56,2],[57,2,59,2],[15,1,16,1],[4,0,5,0],[6,0,7,0],[42,2,44,2],[9,0,10,0],[11,0,12,0],[15,0,16,0],[36,0,47,0],[17,0,35,0],[45,2,47,2],[39,2,41,2],[36,2,38,2],[48,0,50,0],[78,2,80,2],[67,0,69,0],[51,0,56,0],[67,2,69,2],[57,0,62,0],[65,0,66,0],[65,2,66,2],[78,0,81,0],[74,2,75,2],[76,2,77,2],[70,0,73,0],[74,0,77,0]]}
["City of Seattle Stormwater BMP Flow Control Credits, Sizing Factors and Sizing Equations (2012-04-025)"]
[]
["Flow Control Credits"]
["BMP",null,"Design Variable","Pre-developed\nPasture Standard","Peak Flow \nControl Standard","GSI \nStandard","Minimum (sf)",null," "]
["Retained Tree",null,"Evergreen",0.2,0.2,0.2,100,null," "]
[null,null,"Deciduous",0.1,0.1,0.1,50]
["New Tree",null,"Evergreen",50,50,50]
[null,null,"Deciduous",20,20,20]
["Dispersion",null,null,0.9,1,1]
["Permeable Pavement Surface",null,"Slope ≤ 2% ",1,1,1]
[null,null,"Slope 2%-5% ",0.45,0.7,0.55000000000000004]
["Green Roof",null,"Single-Course / 4 inch Growth Medium",0.46,0.71,0.55000000000000004]
[null,null,"Multi-Course / 8 inch Growth Medium",0.54,0.79,0.84]
[]
["Sizing Factors for Infiltration Facilities"]
["BMP","Selection List","Facility Overflow Depth","Design \nInfiltration Rate\n(inch/hour)","Sizing Factor"]
[null,null,null,null,"Pre-developed \nPasture Standard","Peak Flow \nControl Standard","Water Quality\n Treatment Standard","GSI \nStandard (91%)","GSI Standard \nSFR Only (95%)"]
["Bioretention Cell",2,"2 inch ponding depth",0.25,0.23,"Factor Not Available for Peak Std",9.2999999999999999E-2,9.2999999999999999E-2,0.126]
[null,4,null,0.5,0.158,"Factor Not Available for Peak Std",5.7000000000000002E-2,5.7000000000000002E-2,7.8E-2]
[null,6,null,1,9.2999999999999999E-2,"Factor Not Available for Peak Std",3.3000000000000002E-2,3.3000000000000002E-2,4.5999999999999999E-2]
[null,8,"4 inch ponding depth (interpolated)",0.25,{"$f":"ROUND(AVERAGE(E18,E24),3)","v":0.188},"Sizing Factor Not Available for Peak Std",{"$f":"ROUND(AVERAGE(G18,G24),3)","v":7.1999999999999995E-2},{"$f":"ROUND(AVERAGE(H18,H24),3)","v":7.1999999999999995E-2},{"$f":"ROUND(AVERAGE(I18,I24),3)","v":0.1}]
[null,10,null,0.5,{"$f":"ROUND(AVERAGE(E19,E25),3)","v":0.129},"Sizing Factor Not Available for Peak Std",{"$f":"ROUND(AVERAGE(G19,G25),3)","v":4.2999999999999997E-2},{"$f":"ROUND(AVERAGE(H19,H25),3)","v":4.2999999999999997E-2},{"$f":"ROUND(AVERAGE(I19,I25),3)","v":6.2E-2}]
[null,12,null,1,{"$f":"ROUND(AVERAGE(E20,E26),3)","v":7.9000000000000001E-2},"Sizing Factor Not Available for Peak Std",{"$f":"ROUND(AVERAGE(G20,G26),3)","v":2.5000000000000001E-2},{"$f":"ROUND(AVERAGE(H20,H26),3)","v":2.5000000000000001E-2},{"$f":"ROUND(AVERAGE(I20,I26),3)","v":3.6999999999999998E-2}]
[null,null,"6 inch ponding depth",0.25,0.14599999999999999,0.33100000000000002,0.05,0.05,7.3999999999999996E-2]
[null,null,null,0.5,9.9000000000000005E-2,0.20499999999999999,2.9000000000000001E-2,2.9000000000000001E-2,4.5999999999999999E-2]
[null,null,null,1,6.4000000000000001E-2,0.106,1.6E-2,1.6E-2,2.8000000000000001E-2]
[null,null,"8 inch ponding depth (interpolated)",0.25,"NA (pool drawdown time exceeded)","NA (pool drawdown time exceeded)","NA (pool drawdown time exceeded)","NA (pool drawdown time exceeded)","NA (pool drawdown time exceeded)"]
[null,null,null,0.5,{"$f":"ROUND(E35+(ABS(12-8)*(E25-E35)/(ABS(6-12))),3)","v":8.7999999999999995E-2},0.18099999999999999,{"$f":"ROUND(G35+(ABS(12-8)*(G25-G35)/(ABS(6-12))),3)","v":2.5000000000000001E-2},2.5000000000000001E-2,0.04]
[null,null,null,1,5.6000000000000001E-2,9.2999999999999999E-2,1.4E-2,1.4E-2,2.4E-2]
[null,null,"10 inch ponding depth (interpolated)",0.25,"NA (pool drawdown time exceeded)","NA (pool drawdown time exceeded)","NA (pool drawdown time exceeded)","NA (pool drawdown time exceeded)","NA (pool drawdown time exceeded)"]
[null,null,null,0.5,{"$f":"ROUND(E35+(ABS(12-10)*(E25-E35)/(ABS(6-12))),3)","v":7.5999999999999998E-2},0.158,{"$f":"ROUND(G35+(ABS(12-10)*(G25-G35)/(ABS(6-12))),3)","v":2.1000000000000001E-2},2.1000000000000001E-2,3.4000000000000002E-2]
[null,null,null,1,4.9000000000000002E-2,0.08,1.0999999999999999E-2,1.0999999999999999E-2,2.1000000000000001E-2]
[null,null,"12 inch ponding depth",0.25,"NA (pool drawdown time exceeded)","NA (pool drawdown time exceeded)","NA (pool drawdown time exceeded)","NA (pool drawdown time exceeded)","NA (pool drawdown time exceeded)"]
[null,null,null,"0.25*",8.8999999999999996E-2,0.193,0.03,0.03,4.5999999999999999E-2]
[null,null,null,0.5,6.5000000000000002E-2,0.13400000000000001,1.7000000000000001E-2,1.7000000000000001E-2,2.8000000000000001E-2]
[null,null,null,1,4.1000000000000002E-2,6.7000000000000004E-2,8.9999999999999993E-3,8.9999999999999993E-3,1.7000000000000001E-2]
["Permeable Pavement Facility (May Receive Runon)","≥6","6 inch ponding depth in storage reservoir",0.25,0.60599999999999998,1.3140000000000001,"Sizing Factor Not Available",0.33329999999999999]
[null,8,null,0.5,0.34499999999999997,0.52400000000000002,"Sizing Factor Not Available",0.33329999999999999]
[null,10,null,1,0.33329999999999999,0.33329999999999999,"Sizing Factor Not Available",0.33329999999999999]
[null,12,"8 inch ponding depth in storage reservoir  (interpolated)",0.25,{"$f":"ROUND(E46+(ABS(12-8)*(E37-E46)/(ABS(6-12))),3)","v":0.53100000000000003},{"$f":"ROUND(F46+((F37-F46)/(8-6)),3)","v":1.036},"Sizing Factor Not Available",0.33329999999999999]
[null,null,null,0.5,{"$f":"ROUND(E47+(ABS(12-8)*(E38-E47)/(ABS(6-12))),3)","v":0.34100000000000003},0.45600000000000002,"Sizing Factor Not Available",0.33329999999999999]
[null,null,null,1,0.33329999999999999,0.33300000000000002,"Sizing Factor Not Available",0.33329999999999999]
[null,null,"10 inch ponding depth in storage reservoir  (interpolated)",0.25,{"$f":"ROUND(E46+(ABS(12-10)*(E37-E46)/(ABS(6-12))),3)","v":0.45700000000000002},{"$f":"ROUND(F46+((F37-F46)/(10-6)),3)","v":0.89700000000000002},"Sizing Factor Not Available",0.33329999999999999]
[null,null,null,0.5,{"$f":"ROUND(E47+(ABS(12-10)*(E38-E47)/(ABS(6-12))),3)","v":0.33700000000000002},0.42099999999999999,"Sizing Factor Not Available",0.33329999999999999]
[null,null,null,1,0.33329999999999999,0.33300000000000002,"Sizing Factor Not Available",0.33329999999999999]
[null,null,"12 inch ponding depth in storage reservoir",0.25,0.38200000000000001,0.75800000000000001,"Sizing Factor Not Available",0.33329999999999999]
[null,null,null,0.5,0.33329999999999999,0.38700000000000001,"Sizing Factor Not Available",0.33329999999999999]
[null,null,null,1,0.33329999999999999,0.33329999999999999,"Sizing Factor Not Available",0.33329999999999999,"GSI Credit"]
["Bioretention Planter with Underdrain",6,"6 inch ponding depth","NA","NA for Pasture Standard","6\" NA for Peak Standard",2.5999999999999999E-2,2.5999999999999999E-2,0.46]
[null,9,"9 inch ponding depth (interpolated)","NA","NA for Pasture Standard","9\" NA for Peak Standard",{"$f":"ROUND(AVERAGE(G49,G51),3)","v":2.3E-2},{"$f":"ROUND(AVERAGE(H49,H51),3)","v":2.3E-2},0.51]
[null,12,"12 inch ponding depth","NA","NA for Pasture Standard",6.5000000000000002E-2,0.02,0.02,0.56000000000000005]
["Infiltration Trench",1.5,"1.5 foot depth",0.25,0.27300000000000002,0.55100000000000005,0.127,"NA"]
[null,3,null,0.5,0.16800000000000001,0.3,8.2799999999999999E-2,"NA"]
[null,null,null,1,0.107,0.17399999999999999,5.2499999999999998E-2,"NA"]
[null,null,"3.0 foot depth",0.25,0.17,0.31900000000000001,8.5999999999999993E-2,"NA"]
[null,null,null,0.5,0.12,0.20100000000000001,5.8999999999999997E-2,"NA"]
[null,null,null,1,7.8E-2,0.13100000000000001,0.04,"NA"]
["Drywell",4,"4.0 foot depth",0.25,0.13600000000000001,0.249,7.4999999999999997E-2,"NA"]
[null,6,null,0.5,0.10100000000000001,0.17599999999999999,5.0999999999999997E-2,"NA"]
[null,null,null,1,6.7000000000000004E-2,0.111,3.5000000000000003E-2,"NA"]
[null,null,"6.0 foot depth",0.25,9.7000000000000003E-2,0.17499999999999999,6.0999999999999999E-2,"NA"]
[null,null,null,0.5,7.9000000000000001E-2,0.13200000000000001,4.2000000000000003E-2,"NA"]
[null,null,null,1,5.7000000000000002E-2,8.8999999999999996E-2,2.8000000000000001E-2,"NA"]
[]
["Sizing Equations for Detention Facilities"]
["BMP",null,"Facility Overflow Depth","Infilt Rate or Contributing Area","BMP Area Threshold \n(between values set to 5,000sf)",null,"Sizing Equation"]
[null,"Selection List",null,null,"Pre-developed\n Pasture Standard","Peak Flow\n Control Standard","Pre-developed\n Pasture Standard",null,"Peak Flow\n Control Standard",null,"GSI Credit"]
["Bioretention Cell with Detention",12,"12 inch ponding depth",0.25,"NA","NA","NA","NA for Pasture Std",199,3.8199999999999998E-2,0.81]
[null,null,null,0.5,"NA","NA","NA","NA for Pasture Std",129,2.9700000000000001E-2,0.81]
[null,null,null,1,"NA","NA","NA","NA for Pasture Std",97,2.0799999999999999E-2,0.81]
["Detention Pipe",24,"24 inch diameter","<5,000sf",380,298,2.6299999999999999E-5,1.94,5.0799999999999996E-6,2.1]
[null,36,null,"5,000 - 10,000sf",379,301,-235,0.12,-314,0.123]
[null,null,"36 inch diameter","<5,000sf",157,{"$f":"ROUND(I73*POWER(5000,J73),0)","v":106},2.1899999999999999E-7,2.4,2.7700000000000002E-6,2.0499999999999998]
[null,null,null,"5,000 - 10,000sf",156,{"$f":"ROUND(J74*5000+I74,0)","v":106},-110,5.1499999999999997E-2,-167,5.4600000000000003E-2]
["Detention Vault",3,"3.0 foot depth","<5,000sf",353,218,4.2799999999999997E-5,1.87,6.1600000000000007E-5,1.77]
[null,4,null,"5,000 - 10,000sf",352,220,-255,0.121,-130,7.0000000000000007E-2]
[null,null,"4.0 foot depth","<5,000sf","NA",{"$f":"ROUND(I77*POWER(5000,J77),0)","v":155},"NA","NA for Pasture Std",4.4100000000000001E-6,2.04]
[null,null,null,"5,000 - 10,000sf","NA",{"$f":"ROUND(J78*5000+I78,0)","v":156},"NA","NA for Pasture Std",-98,5.0799999999999998E-2]
["Detention Cistern",3,"3.0 foot depth","<6,140sf","<760","NA",5.9899999999999997E-3,1.347,5.31E-4,1.59]
[null,4,null,">8,000sf",">760",null,-289,0.13100000000000001,"DO WE WANT TO UPDATE THE PEAK STD SIZING LIKE GSI TO MEF?"]
[null,null,null,"6,140 - 8,000sf",{"$f":"760","v":760},null,0,8000]
[null,null,"4.0 foot depth","NA","NA","NA","NA","NA for Pasture Std",4.17E-4,1.58]
[]
["Contributing A","BMP"]
[6140,{"$f":"H79*POWER(A85,G79)","v":1.4192494162429585}]
[8000,{"$f":"G80*A85+H80","v":-1774459.8689999999}]
[8000,{"$f":"G81*A86+H81","v":8000}]
[]
["GSI to MEF Sizing Equations and Credits for Variably Sized Detention Cisterns"]
["BMP","GSI Sizing (same as Peak Flow Control Std)",null,null,"GSI Credit"]
[null,"Cont Area","SF or Size",null,"Cont Area","Credit"]
["Detention Cistern","150 to <317",6.68,null,"150 to <317",0.59]
[null,"317 to <10,000","EQN:    0.0008 x [A^1.57]",null,"317 to <2200","EQN:    0.212 x Ln(A) - 0.63"]
[null,null,8.0000000000000004E-4,1.57,null,0.21199999999999999,-0.63]
[null,null,null,null,">2200 to 10,000",1]
[]
["GSI to MEF Sizing Equations and Credits for Detention Cisterns to Bioretention"]
["BMP","Number of Cisterns","Configuration","Design \nInfiltration Rate\n(inch/hour)","Contributing Area","GSI Requirement"]
[null,"Number of Cisterns",null,null,null,"Sizing Factor"]
["Detention Cistern to Bioretention","1 cistern","6\" Ponding BR Cell",0.25,"200-500 sf",1.2E-2]
[null,"1 cistern",null,null,">500-1000 sf",2.3E-2]
[null,"1 cistern",null,null,">1000-1500 sf",2.8000000000000001E-2]
[null,"1 cistern",null,null,">1501-2000 sf",3.4000000000000002E-2]
[null,"1 cistern",null,0.5,"200-500 sf",1E-3]
[null,"1 cistern",null,null,">500-1000 sf",7.0000000000000001E-3]
[null,"1 cistern",null,null,">1000-1500 sf",1.0999999999999999E-2]
[null,"1 cistern",null,null,">1501-2000 sf",1.6E-2]
[null,"1 cistern",null,1,"200-500 sf",1E-3]
[null,"1 cistern",null,null,">500-1000 sf",1E-3]
[null,"1 cistern",null,null,">1000-1500 sf",2E-3]
[null,"1 cistern",null,null,">1501-2000 sf",5.0000000000000001E-3]
[null,"1 cistern","12\" Ponding BR Cell",0.25,"200-500 sf",1E-3]
[null,"1 cistern",null,null,">500-1000 sf",7.0000000000000001E-3]
[null,"1 cistern",null,null,">1000-1500 sf",1.0999999999999999E-2]
[null,"1 cistern",null,null,">1501-2000 sf",1.4999999999999999E-2]
[null,"1 cistern",null,0.5,"200-500 sf",1E-3]
[null,"1 cistern",null,null,">500-1000 sf",1E-3]
[null,"1 cistern",null,null,">1000-1500 sf",2E-3]
[null,"1 cistern",null,null,">1501-2000 sf",5.0000000000000001E-3]
[null,"1 cistern",null,1,"200-500 sf",1E-3]
[null,"1 cistern",null,null,">500-1000 sf",1E-3]
[null,"1 cistern",null,null,">1000-1500 sf",1E-3]
[null,"1 cistern",null,null,">1501-2000 sf",2.0000000000000001E-4]
[null,"2 cisterns","6\" Ponding BR Cell",0.25,"200-500 sf",1.0999999999999999E-2]
[null,"2 cisterns",null,null,">500-1000 sf",0.02]
[null,"2 cisterns",null,null,">1000-1500 sf",2.5999999999999999E-2]
[null,"2 cisterns",null,null,">1501-2000 sf",3.1E-2]
[null,"2 cisterns",null,0.5,"200-500 sf",2.0000000000000001E-4]
[null,"2 cisterns",null,null,">500-1000 sf",5.0000000000000001E-3]
[null,"2 cisterns",null,null,">1000-1500 sf",8.9999999999999993E-3]
[null,"2 cisterns",null,null,">1501-2000 sf",1.2999999999999999E-2]
[null,"2 cisterns",null,1,"200-500 sf",1E-3]
[null,"2 cisterns",null,null,">500-1000 sf",1E-3]
[null,"2 cisterns",null,null,">1000-1500 sf",1E-3]
[null,"2 cisterns",null,null,">1501-2000 sf",3.0000000000000001E-3]
[null,"2 cisterns","12\" Ponding BR Cell",0.25,"200-500 sf",1E-3]
[null,"2 cisterns",null,null,">500-1000 sf",5.0000000000000001E-3]
[null,"2 cisterns",null,null,">1000-1500 sf",0.01]
[null,"2 cisterns",null,null,">1501-2000 sf",1.4E-2]
[null,"2 cisterns",null,0.5,"200-500 sf",1E-3]
[null,"2 cisterns",null,null,">500-1000 sf",1E-3]
[null,"2 cisterns",null,null,">1000-1500 sf",1E-3]
[null,"2 cisterns",null,null,">1501-2000 sf",3.0000000000000001E-3]
[null,"2 cisterns",null,1,"200-500 sf",1E-3]
[null,"2 cisterns",null,null,">500-1000 sf",1E-3]
[null,"2 cisterns",null,null,">1000-1500 sf",1E-3]
[null,"2 cisterns",null,null,">1501-2000 sf",1E-3]
["Values in red- modeling results are VERY small SF, so applied a minimum of 0.1"]
[]
[]
["NAMES:"]
[]
["Standards"]
["Pre-developed Pasture Standard"]
["Peak Flow Control Standard"]
["Pre-developed Pasture and Peak Flow Control Standards"]
[]
["Soil"]
["Yes"]
["No"]
[]
[]
["Project Type"]
["Single Family"]
["Sidewalk"]
["Trail"]
["Parcel"]
["Roadway"]
[]
["ProjectFC"]
["Parcel-based Project"]
["Roadway Project"]
[]
["Number Cisterns"]
["1 cistern"]
["2 cisterns"]
[]
["Cistern to BR Depth"]
[6]
[12]
[]
["Checklist-RW"]
[{"$f":"IF('GSI Requirement Calculator'!Q3=\"\",\"\",IF(OR('GSI Requirement Calculator'!Q3=\"Roadway\",'GSI Requirement Calculator'!Q3=\"Trail\",'GSI Requirement Calculator'!Q3=\"Sidewalk\"),\"√\",\"NA\"))","v":""}]
[]
["Checklist-Parcel"]
[{"$f":"IF('GSI Requirement Calculator'!Q3=\"\",\"\",IF(OR('GSI Requirement Calculator'!Q3=\"Single Family\",'GSI Requirement Calculator'!Q3=\"Parcel\"),\"√\",\"NA\"))","v":""}]

{"sheet":"Instructions","index":1,"n_rows":165,"n_cols":5,"rows_kept":165,"cut":false,"hidden":false,"merged":[[163,0,163,4],[159,0,159,4],[146,1,146,4],[24,2,24,4],[73,3,73,4],[2,0,2,4],[6,0,6,4],[9,0,9,4],[10,0,10,4],[161,0,161,4],[7,0,7,4],[5,0,5,4],[3,0,3,4]]}
["Introduction"]
[]
["This spreadsheet tool helps the user implement green stormwater infrastructure (GSI) stormwater best management practices (BMPs) to meet the GSI to the maximum extent feasible (MEF) requirement for the City of Seattle, Washington. "]
["The \"GSI Requirement Calculator\" sheet supports the user in selecting and sizing GSI BMPs, the \"Feasibility Checklist\" sheet helps the user evaluate and determine BMP feasibility.  Both sheets can be used to provide documentation for compliance with the GSI to MEF requirement. Instructions are provided below."]
[]
["Refer to the following Seattle directors' rules for complete GSI to MEF requirements:"]
["Directors’ Rule DWW-201.2 SPU / 16-2011 DPD for information on Roadway, Trail, and Sidewalk Projects (Seattle 2012a)"]
["Directors’ Rule DWW-201.2 (SPU) / 16-2011 (DPD) for Roadway, Trail, and Sidewalk Projects (Seattle 2012b)"]
[]
["Refer to Volume 3 of the Seattle Stormwater Manual (Seattle 2009) for GSI BMP design considerations and requirements."]
[]
["How to Use the GSI to MEF Requirement Calculator"]
[]
["1-","Enable macros for full functionality. "]
[]
["2-","Enter project Building Permit Number and Project Address."]
[]
["3-","Select Project Type: \"Single-Family\", \"Parcel\", \"Roadway\", \"Trail\" or \"Sidewalk\". "]
[null,"Note: If a project is a Joint Project, separate calculators shall be submitted for the Parcel-Based and the Roadway portions of the project. "]
[]
["4-","Enter Project Area.  While this area does not affect GSI to MEF calculations, it is included for DPD record keeping. "]
[]
["5-","Enter total New plus Replaced Impervious Surface Area for the project."]
[null,null,"The calculator reports the \"Area Requiring Mitigation\".  For Single-Family Residential projects, this is the new plus replaced impervious surface "]
[null,null,"minus 1,500 square feet. "]
[]
["6-","Select and size Runoff Reduction Methods."]
[]
[null,null,"Retained Trees:"]
[null,null,null,"Enter the number and the total canopy area for retained trees.  The calculator reports the impervious surface reduction credit as \"Area Mitigated\".   "]
[null,null,null,null,"Runoff from this amount of impervious surface need not be mitigated with other BMPs. "]
[null,null,null,null,"Note: The maximum tree credit varies based on project type. "]
[null,null,"New Trees:"]
[null,null,null,"Enter the number of newly planted trees.  The calculator reports the impervious surface reduction credit as \"Area Mitigated\".   "]
[null,null,null,null,"Runoff from this amount of impervious surface need not be mitigated with other BMPs. "]
[null,null,null,null,"Note: The maximum tree credit varies based on project type. "]
[null,null,"Dispersion:"]
[null,null,"(NOTE: Single-Family Residential Projects and Trail/Sidewalk Projects are not required to evaluate this BMP.)"]
[null,null,null,"Enter the area of impervious surface to be dispersed to compost amended lawn or landscape."]
[null,null,null,null,"The calculator reports the dispersed area as \"Area Mitigated\". "]
[]
["7-","Select and size Infiltration and Reuse Facilities."]
[null,null,"Bioretention Cell (without  Underdrain): "]
[null,null,"a)","Enter the area contributing stormwater runoff to the bioretention cell."]
[null,null,"b)","Select the bioretention ponding depth: 2, 4, 6, 8, 10 or 12 inches."]
[null,null,null,null,"Ponding depth is measured from the bottom of the facility (top of the bioretention soil) to the invert elevation of the overflow conveyance."]
[null,null,"c)","Select the design infiltration rate of the native underlying soil rounded down to the nearest value: 0.25, 0.5 or 1.0 inches per hour (see Note 1)."]
[null,null,null,null,"Bioretention pool (i.e., ponding) drawdown time must not exceed 24 hours (eliminating certain ponding depth and infiltration rate combinations).  "]
[null,null,"d)","The calculator reports the bioretention bottom area required to mitigate the contributing area given the selected ponding depth and infiltration rate. "]
[null,null,null,null,"The minimum bottom area is 4 square feet and the maximum bottom area is 5,000 square feet (see Note 2).    "]
[null,null,"e)","Enter the bottom area of the bioretention cell. "]
[null,null,null,null,"The calculator reports the \"Area Mitigated\" based on the contributing area and the area mitigated by a facility of the selected design and size:  "]
[null,null,null,null,"- If the bioretention area is optimized to mitigate runoff from the contributing area, the \"Area Mitigated\" is the contributing area routed to the facility."]
[null,null,null,null,"- If the bioretention cell is undersized, the \"Area Mitigated\" is the maximum impervious area that is mitigated when routed to a facility of this size."]
[null,null,null,null,"- If the bioretention cell is oversized, the \"Area Mitigated\" is the contributing area routed to the facility."]
[null,null,null,null,"Note: The bioretention area entered in the calculator is the cell bottom area. The total footprint will be larger and may be calculated based on total facility depth (ponding depth plus freeboard) and facility side slopes (3H:1V, typical)."]
[null,null,"f)","Iteratively size the bioretention facility bottom area, adjust the ponding depth and/or revise the contributing drainage area to achieve desired performance."]
[]
[null,null,"Detention Cistern to Bioretention Cell: "]
[null,null,"(NOTE: This BMP is available only for Single-Family Residential Projects)"]
[null,null,"a)","Enter the area contributing stormwater runoff to the detention cistern (limited to 200 to 2,000 square feet). "]
[null,null,"b)","Select number of cisterns: \"1 cistern\" or \"2 cisterns\""]
[null,null,"c)","Select the bioretention ponding depth: 6 or 12 inches."]
[null,null,null,null,"Ponding depth is measured from the bottom of the facility (top of the bioretention soil) to the invert elevation of the overflow conveyance."]
[null,null,"d)","Select the design infiltration rate of the native underlying soil rounded down to the nearest value: 0.25, 0.5 or 1.0 inches per hour (see Note 1)."]
[null,null,"e)","The calculator reports the bioretention bottom area required to mitigate the contributing area given the cistern and bioretention design. "]
[null,null,null,null,"Also note that the minimum acceptable bottom area is 4 square feet.  "]
[null,null,"f)","Enter the bottom area of the bioretention cell. "]
[null,null,null,null,"The calculator reports the \"Area Mitigated\" based on the contributing area and the area mitigated by a facility of the selected design and size.  "]
[null,null,null,null,"- If the bioretention area is optimized to mitigate runoff from the contributing area, the \"Area Mitigated\" is the contributing area routed to the facility."]
[null,null,null,null,"- If the bioretention cell is undersized, the \"Area Mitigated\" is the maximum impervious area that is mitigated when routed to a facility of this size."]
[null,null,null,null,"- If the bioretention cell is oversized, the \"Area Mitigated\" is the contributing area routed to the facility."]
[null,null,null,null,"Note: The bioretention area entered in the calculator is the cell bottom area. The total footprint will be larger and may be calculated based on total facility depth (ponding depth plus freeboard) and facility side slopes (3H:1V, typical)."]
[null,null,"g)","Iteratively adjust the number of cisterns, size the bioretention facility bottom area, adjust ponding depth and/or revise the contributing drainage area to achieve desired performance."]
[]
[null,null,"Permeable Pavement Facility:"]
[null,null,"a)","Enter the area contributing stormwater runoff to the permeable pavement facility (this does not include the permeable pavement area itself). "]
[null,null,null,null,"This area will be zero if the pavement is mitigating only the rain falling on it."]
[null,null,null,null,"The area contributing runoff to a facilities may not exceed three times the permeable pavement area (corresponding to a minimum sizing factor of 33.3%)."]
[null,null,"b)","Select the subsurface ponding depth: ≥ 6 inches is the only option available currently."]
[null,null,null,null,"This is the average subsurface ponding depth required in the aggregate storage reservoir for stormwater management purposes."]
[null,null,"c)","Select the design infiltration rate of the native underlying soil rounded down to the nearest value: 0.25, 0.5 or 1.0 inches per hour (see Note 1)."]
[null,null,"d)","Enter the area of the permeable pavement facility."]
[null,null,"e)","The calculator reports the impervious area that is mitigated (i.e., the permeable pavement area plus contributing drainage area, if any)."]
[null,null,"f)","Size the permeable pavement facility area and/or contributing drainage area to achieve desired performance. "]
[]
[null,null,"Reuse Facilities"]
[null,null,"(NOTE: Single-Family Residential Projects and Trail/Sidewalk Projects are not required to evaluate this BMP.)"]
[null,null,"a)","Enter the \"Area Mitigated\" by water rainwater harvesting. "]
[null,null,"b)","Applicant must provide documentation that the reported area is mitigated to the GSI to MEF target."]
[]
["8-","Select and size Impervious Surface Reduction Methods."]
[null,null,"Permeable Pavement Surface:"]
[null,null,"a)","Determine the subgrade slope at the proposed permeable pavement location (i.e., ≤ 2 percent or >2 to 5 percent). "]
[null,null,null,null,"Note that the subgrade slope may be different from the pavement wearing course slope. "]
[null,null,"b)","Enter the area of the permeable pavement surface.  "]
[null,null,null,null,"The calculator reports the corresponding \"Area Mitigated\" by this BMP."]
[null,null,null,null,"Note that permeable pavement over a subgrade slope exceeding 2 percent does not receive 100% credit, so additional flow control measures (e.g., downstream bioretention) would be required to achieve the target. If the designer wishes to receive full GSI to MEF credit for a permeable pavement BMP on a slope, they may design it as a permeable pavement facility and provide subsurface berms to contain stored water within the aggregate storage reservoir. "]
[null,null,"c)","Size the permeable pavement area to achieve the desired performance. "]
[]
[null,null,"Green Roof:"]
[null,null,"(NOTE: Single-Family Residential Projects and Trail/Sidewalk Projects are not required to evaluate this BMP.)"]
[null,null,"a)","Select the green roof type. "]
[null,null,"b)","Enter the area of green roof.   "]
[null,null,null,null,"The calculator reports the corresponding \"Area Mitigated\". "]
[null,null,null,null,"Note that green roofs do not receive 100% credit, so additional flow control measures (e.g., downstream bioretention facility) would be required to achieve the target. "]
[null,null,"c)","Size the green roof area to achieve the desired performance. "]
[]
[null,null,"Bioretention Cell with Detention: "]
[null,null,"(NOTE: Single-Family Residential Projects and Trail/Sidewalk Projects are not required to evaluate this BMP.)"]
[null,null,"a)","Enter the area contributing stormwater runoff to the bioretention cell with detention."]
[null,null,null,null,"Note that the minimum contributing area for this BMP is 1,500 square feet.  For smaller area, the designer should use bioretention cells without detention. "]
[null,null,"b)","Select the bioretention ponding depth: 12 inches is the only option available currently."]
[null,null,null,null,"Ponding depth is measured from the bottom of the facility (top of the bioretention soil) to the invert elevation of the overflow conveyance."]
[null,null,"c)","Select the design infiltration rate of the native underlying soil rounded down to the nearest value: 0.25, 0.5 or 1.0 inches per hour (see Note 1)."]
[null,null,"d)","The calculator reports the bioretention bottom area required to mitigate the contributing area given the selected ponding depth and infiltration rate. "]
[null,null,"e)","Enter the bottom area of the bioretention cell. "]
[null,null,null,null,"Note that minimum bioretention bottom areas are applicable for this BMP: 256.3, 173.6 and 128.2 square feet for 0.25, 0.5 and 1 inch per hour infiltration rate, respectively.   "]
[null,null,null,null,"The calculator reports the \"Area Mitigated\" based on the contributing area and the area mitigated by a facility of the selected design and size.  "]
[null,null,null,null,"- If the bioretention area is optimized to mitigate runoff from the contributing area, the \"Area Mitigated\" is the contributing area routed to the facility."]
[null,null,null,null,"- If the bioretention cell is undersized, the \"Area Mitigated\" is the maximum impervious area that is mitigated when routed to a facility of this size."]
[null,null,null,null,"- If the bioretention cell is oversized, the \"Area Mitigated\" is the contributing area routed to the facility."]
[null,null,null,null,"Note: The bioretention area entered in the calculator is the cell bottom area. The total footprint will be larger and may be calculated based on total facility depth (ponding depth plus freeboard) and facility side slopes (3H:1V, typical)."]
[null,null,"f)","Iteratively size the bioretention facility bottom area and revise the contributing drainage area to achieve desired performance."]
[]
["9-","Select and size Non-Infiltrating Facilities."]
[null,null,"Bioretention Planter: "]
[null,null,"a)","Enter the area contributing stormwater runoff to the planter."]
[null,null,"b)","Select the bioretention ponding depth: 6, 9 or 12 inches."]
[null,null,null,null,"Ponding depth is measured from the bottom of the facility (top of the bioretention soil) to the invert elevation of the overflow conveyance."]
[null,null,"c)","The calculator reports the optimal bioretention bottom area required to mitigate the contributing area given the selected ponding depth. "]
[null,null,null,null,"Because this planter is optimized, performance relative to the GSI to MEF target will decrease when the facility size is increased or decreased.  For this reason, no additional credit is given for larger planters.  "]
[null,null,"d)","The calculator reports the corresponding \"Area Mitigated\"."]
[null,null,null,null,"Note that planters do not receive 100% credit, so additional flow control measures (e.g., downstream bioretention facility) would be required to achieve the target. "]
[null,null,"e)","Iteratively size the bioretention facility bottom area, adjust the ponding depth and/or revise the contributing drainage area to achieve desired performance."]
[]
[null,null,"Detention Cistern with Harvesting Capacity: "]
[null,null,"(NOTE: This BMP is available only for Single-Family Residential Projects)"]
[null,null,"a)","Enter the area contributing stormwater runoff to the detention cistern (limited to 150 to 10,000 square feet). "]
[null,null,"b)","The calculator reports the bioretention bottom area required to mitigate the contributing area given the cistern and bioretention design. "]
[null,null,null,null,"Also note that the minimum acceptable bottom area is 4 square feet.  "]
[null,null,"c)","Enter the bottom area of the bioretention cell. "]
[null,null,null,null,"The calculator reports the \"Area Mitigated\" based on the contributing area and the area mitigated by a facility of the selected design and size.  "]
[null,null,null,null,"Note that detention cisterns do not receive 100% credit, so additional flow control measures (e.g., downstream bioretention facility) would be required to achieve the target. "]
[null,null,"d)","Iteratively adjust the contributing drainage area to achieve desired performance."]
[]
["10-","Iteratively select and size BMPs until the GSI to MEF target is achieved.  "]
[null,null,"The calculator will report \"YES\" when the target is achieved."]
[null,null,"If the GSI to MEF target is not achieved,  additional submittal documentation regarding feasibility is required.  See \"Feasibility Checklist\" sheets."]
[null,null,"Based upon the Project Type selected, the appropriate \"Feasibility Checklist\" will be visible"]
["Notes:"]
["1. Infiltration rates are design rates and should be derived using correction factors (safety factors), as applicable, per the Stormwater Flow Control and "]
[null,"Water Quality Treatment Technical Requirements Manual, Volume 3."]
["2. The drainage area contributing runoff to an individual bioretention facility shall be no larger than 5,000 square feet. For larger contributing areas, the "]
[null,"designer may split the area into multiple drainages (less than 5,000 square feet) routed to separate facilities or size a single facility with an approved "]
[null,"continuous hydrologic model using a lower design infiltration rate (i.e., calculated using a higher correction factor).  "]
[]
["References"]
[]
["Seattle 2009. Stormwater Flow Control and Water Quality Treatment Technical Requirements Manual. Seattle Public Utilities and Department of Planning and Development. December 2009."]
[]
["Seattle 2012a. Draft Requirements for Green Stormwater Infrastructure to the Maximum Extent Feasible for Roadway, Trail, and Sidewalk Projects. \nDirectors’ Rule: DWW-201.2 (SPU) / 16-2011 (DPD). City of Seattle  Public Utilities Department of Planning and Development. May 8, 2012."]
[]
["Seattle 2012b. Draft Requirements for Green Stormwater Infrastructure to the Maximum Extent Feasible for Single-Family Residential and Parcel-Based Projects.\nDirectors’ Rule: 2009-007 (SPU) / 19-2009 (DPD). City of Seattle  Public Utilities Department of Planning and Development. May 8, 2012."]
[null,null,null,null,"2013-01-07"]

{"sheet":"GSI Requirement Calculator","index":2,"n_rows":121,"n_cols":18,"rows_kept":121,"cut":false,"hidden":false,"merged":[[84,2,84,10],[92,5,92,15],[100,11,100,13],[102,10,102,13],[22,4,22,17],[34,2,34,10],[40,2,40,9],[46,2,46,9],[52,2,52,9],[20,10,20,14],[76,0,76,3],[55,1,55,4],[66,0,66,3],[33,5,33,7],[32,5,32,7],[60,0,60,3],[38,5,38,7],[39,5,39,7],[45,5,45,7],[64,2,64,8],[109,0,109,1],[22,0,22,3],[89,0,89,3],[88,0,88,3],[74,0,74,3],[75,0,75,3],[26,0,26,3],[27,0,27,3],[93,0,93,3],[70,0,70,3],[71,0,71,3],[72,0,72,3],[73,0,73,3],[87,0,87,3],[69,0,69,3],[77,0,77,3],[104,10,104,13],[4,2,6,6],[47,0,47,5],[2,2,2,3],[28,0,28,3],[17,0,17,3],[16,0,16,3],[18,0,18,3],[23,0,23,3],[13,0,13,3],[12,0,12,3],[10,9,10,13],[6,8,6,13],[11,7,11,16],[67,5,67,13],[44,5,44,7]]}
["City of Seattle GSI to MEF Requirement Calculator (2013-03-01)"]
[]
["Building Permit No.",null,null,null,null,null,null,null,null,null,null,null,null,"Project Type"]
[]
["Project Address",null,null,null,null,null,null,null,null,null,null,null,null,"Project Area",null,null,null,"sf"]
[]
[null,null,null,null,null,null,null,null,"New plus Replaced Impervious Area",null,null,null,null,null,null,null,null,"sf"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area Requiring Mitigation for Single Family",null,null,{"$f":"IF(OR($Q$7=\"\",AND(Q3=\"Single Family\",Q7>10000)),\"\",IF($Q$7-1500<0,0,$Q$7-1500))","v":""},"sf"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Area Requiring Mitigation for non-Single Family",null,null,{"$f":"IF($Q$7=\"\",\"\",IF(Q7>=2000,Q7,0))","v":""},"sf"]
[null,null,null,null,null,null,null,null,null,"Area Requiring Mitigation",null,null,null,null,null,null,{"$f":"IF(OR($Q$7=\"\",Q3=\"\"),\"\",IF(Q3=\"Single Family\",Q9,Q10))","v":""},"sf"]
[null,null,null,null,null,null,null,{"$f":"IF(OR($Q$7=\"\",Q3=\"\"),\"\",IF(AND(Q3=\"Single Family\",Q7>10000),\"Note: Projects of this size cannot be categorized as Single Family\",IF(Q3=\"Single Family\",\"Note: 1,500 sf credit for SFR projects\",\"\")))","v":""}]
["Runoff Reduction Methods",null,null,null,null,"Facility Size",null,null,null,null,"Credit",null,null,null,null,null,"Area Mitigated"]
["Retained Trees"]
["Existing Evergreen",null,"# Trees",null,null,"Total Canopy Area of Trees",null,null,"sf","x","20% Canopy (or min 100 sf/tree) =",null,null,null,{"$f":"IF(AND(H15=\"\",D15=\"\"),\"\",MAX(H15*X!D5, D15*X!G5))","v":""}]
["Existing Deciduous",null,"# Trees",null,null,"Total Canopy Area of Trees",null,null,"sf","x","10% Canopy (or min 50 sf/tree) =",null,null,null,{"$f":"IF(AND(H16=\"\",D16=\"\"),\"\",MAX(H16*X!D6, D16*X!G6))","v":""}]
["New Trees"]
["New Evergreen",null,null,null,null,"# Trees",null,null,null,"x","50 sf/tree =",null,null,null,{"$f":"IF(H18=\"\",\"\",H18*X!D7)","v":""}]
["New Deciduous",null,null,null,null,"# Trees",null,null,null,"x","20 sf/tree =",null,null,null,{"$f":"IF(H19=\"\",\"\",H19*X!D8)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,"Total Area Mitigated by Trees",null,null,null,null,"=",{"$f":"IF(OR(Q11=\"\",AND(O15=\"\",O16=\"\",O18=\"\",O19=\"\")),\"\",IF(Q11=0,SUM(O15:O19),IF(SUM(O15:O19)>M22,M22,SUM(O15:O19))))","v":""},"sf"]
[null,null,null,null,null,null,null,null,null,null,"Maximum","=",{"$f":"IF(OR(Q11=0,Q11=\"\"),SUM(O15:O19),IF(AND(Q3=\"Single Family\",SUM(O15:O16)>0),0.25*Q7,0.25*Q11))","v":0},"sf"]
["Dispersion   1",null,null,null,{"$f":"IF(OR(Q11=\"\",Q11=0,SUM(O15:O19)=0),\"\",IF(AND(Q3=\"Single Family\", SUM(O15:O16)>0),\"Note:  Maximum tree credit is 25% of New plus Replaced Impervious Area \",IF(SUM(O15:O16)=0,\"Note:  Maximum tree credit is 25% of Area Requiring Mitigation\",\"\")))","v":""}]
["Downspout or Sheet Flow Dispersion",null,null,null,null,"Dispersed Impervious Area",null,null,"sf","x",{"$f":"X!F9","v":1},null,null,null,null,"=",{"$f":"IF(OR(H24=\"\",ISTEXT(K24)),\"\",H24*K24)","v":""},"sf"]
[null,null,null,null,null,null,null,{"$f":"IF(H24<>\"\",\"Note: Confirm flow paths can be achieved, See Section 4.4.3 of Vol. 3\",\"\")","v":""}]
[]
["Infiltration and Reuse Facilities",null,null,null,null,"Facility Size",null,null,null,null,"Sizing Factor",null,null,null,null,null,"Area Mitigated"]
["Infiltrating Facilities"]
["Bioretention Cell (without Underdrain)"]
[1,"Contributing Area",null,"sf",null,"Bioretention Bottom Area",null,null,"sf",{"$f":"IF(OR(ISERROR(H30/K30),Q30=\"\"),\"\",IF(ROUND(Q30,0)=ROUND(H30/K30,0),\"÷\",\"\"))","v":""},{"$f":"IF(Q3=\"\",\"Select Project Type\",IF(C30=\"\", \"Enter Contributing Area\", IF(C31=\"\",\"Select Depth\",IF(C32=\"\",\"Select Infilt Rate\",IF(Q3=\"Single Family\",K34,K33)))))","v":"Select Project Type"},null,null,null,null,{"$f":"IF(OR(ISERROR(H30/K30),Q30=\"\"),\"\",IF(ROUND(Q30,0)=ROUND(H30/K30,0),\"=\",\"\"))","v":""},{"$f":"IF(OR(H30=\"\",ISTEXT(K30)),\"\",IF(H30<4,\"\",IF(C30>2*H30/K30,\"\",MIN(H30/K30,C30))))","v":""},"sf"]
[null,"Ponding Depth",null,"in",null,{"$f":"IF(OR(C30=\"\",C31=\"\",C32=\"\",ISTEXT(K30),C33=\"NO\"),\"\",\"Note: Contributing area can be\")","v":""},null,null,null,null,{"$f":"IF(OR(H30=\"\",ISTEXT(K30)),\"\",IF(H30<4,\"Note: Minimum bottom area is 4 sf\",IF(C30<ROUND(H30/K30,1),\"Note: A contributing area of up to \"&ROUND(H30/K30,1)&\" sf\", IF(C30>ROUND(H30/K30*2,1),\"Note: Contributing area may not exceed \",\"\"))))","v":""}]
[null,"Design Infiltration Rate",null,"in/hr",null,{"$f":"IF(OR(C30=\"\",C31=\"\",C32=\"\",ISTEXT(K30),C33=\"NO\"),\"\",\"mitigated with a bottom area of \"&ROUND(C30*K30,1)&\" sf\")","v":""},null,null,null,null,{"$f":"IF(OR(H30=\"\",ISTEXT(K30)),\"\",IF(H30<4,\"\",IF(C30<ROUND(H30/K30,1),\"may be mitigated by a facility of this size\", IF(C30>ROUND(H30/K30*2,1),\"twice the area mitigated (\"&ROUND(2*H30/K30,1)&\" sf)\",\"\"))))","v":""}]
[null,"Show optimize note=",{"$f":"IF(ISERROR(K33),\"NO\",IF(ISBLANK(H30),\"YES\",IF(OR(ROUND(H30,0)=ROUND(C30*K30,0),AND(ROUND(C30*K30,0)<4,H30<=4,H30>ROUND(C30*K30,2))),\"NO\",\"YES\")))","v":"NO"},null,null,"SF for nonSFR",null,null,"=",null,{"$f":"VLOOKUP(C32,IF(C31=2,X!D18:H20,IF(C31=4,X!D21:H23,IF(C31=6,X!D24:H26,IF(C31=8,X!D27:H29,IF(C31=10,X!D30:H32,IF(C31=12,X!D33:H36)))))),4)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"SF for SFR",null,null,"=",null,{"$f":"VLOOKUP(C32,IF(C31=2,X!D18:I20,IF(C31=4,X!D21:I23,IF(C31=6,X!D24:I26,IF(C31=8,X!D27:I29,IF(C31=10,X!D30:I32,IF(C31=12,X!D33:I36)))))),6)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"IF(C32>0.25, \"Note:  Inflitration rates greater than 0.25 in/hr require infiltration testing\",\"\")","v":""}]
[2,"Contributing Area",null,"sf",null,"Bioretention Bottom Area",null,null,"sf",{"$f":"IF(OR(ISERROR(H36/K36),Q36=\"\"),\"\",IF(ROUND(Q36,0)=ROUND(H36/K36,0),\"÷\",\"\"))","v":""},{"$f":"IF(Q3=\"\",\"Select Project Type\",IF(C36=\"\", \"Enter Contributing Area\", IF(C37=\"\",\"Select Depth\",IF(C38=\"\",\"Select Infilt Rate\",IF(Q3=\"Single Family\",K40,K39)))))","v":"Select Project Type"},null,null,null,null,{"$f":"IF(OR(ISERROR(H36/K36),Q36=\"\"),\"\",IF(ROUND(Q36,0)=ROUND(H36/K36,0),\"=\",\"\"))","v":""},{"$f":"IF(OR(H36=\"\",ISTEXT(K36)),\"\",IF(H36<4,\"\",IF(C36>2*H36/K36,\"\",MIN(H36/K36,C36))))","v":""},"sf"]
[null,"Ponding Depth",null,"in",null,{"$f":"IF(OR(C36=\"\",C37=\"\",C38=\"\",ISTEXT(K36),C39=\"NO\"),\"\",\"Note: Contributing area can be\")","v":""},null,null,null,null,{"$f":"IF(OR(H36=\"\",ISTEXT(K36)),\"\",IF(H36<4,\"Note: Minimum bottom area is 4 sf\",IF(C36<ROUND(H36/K36,1),\"Note: A contributing area of up to \"&ROUND(H36/K36,1)&\" sf\", IF(C36>ROUND(H36/K36*2,1),\"Note: Contributing area may not exceed \",\"\"))))","v":""}]
[null,"Design Infiltration Rate",null,"in/hr",null,{"$f":"IF(OR(C36=\"\",C37=\"\",C38=\"\",ISTEXT(K36),C39=\"NO\"),\"\",\"mitigated with a bottom area of \"&ROUND(C36*K36,1)&\" sf\")","v":""},null,null,null,null,{"$f":"IF(OR(H36=\"\",ISTEXT(K36)),\"\",IF(H36<4,\"\",IF(C36<ROUND(H36/K36,1),\"may be mitigated by a facility of this size\", IF(C36>ROUND(H36/K36*2,1),\"twice the area mitigated (\"&ROUND(2*H36/K36,1)&\" sf)\",\"\"))))","v":""}]
[null,"Show optimize note=",{"$f":"IF(ISERROR(K39),\"NO\",IF(ISBLANK(H36),\"YES\",IF(OR(ROUND(H36,0)=ROUND(C36*K36,0),AND(ROUND(C36*K36,0)<4,H36<=4,H36>ROUND(C36*K36,2))),\"NO\",\"YES\")))","v":"NO"},null,null,"SF for nonSFR",null,null,"=",null,{"$f":"VLOOKUP(C38,IF(C37=2,X!D18:H20,IF(C37=4,X!D21:H23,IF(C37=6,X!D24:H26,IF(C37=8,X!D27:H29,IF(C37=10,X!D30:H32,IF(C37=12,X!D33:H36)))))),4)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"SF for SFR",null,null,"=",null,{"$f":"VLOOKUP(C38,IF(C37=2,X!D18:I20,IF(C37=4,X!D21:I23,IF(C37=6,X!D24:I26,IF(C37=8,X!D27:I29,IF(C37=10,X!D30:I32,IF(C37=12,X!D33:I36)))))),6)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"IF(C38>0.25, \"Note:  Inflitration rates greater than 0.25 in/hr require infiltration testing\",\"\")","v":""}]
[3,"Contributing Area",null,"sf",null,"Bioretention Bottom Area",null,null,"sf",{"$f":"IF(OR(ISERROR(H42/K42),Q42=\"\"),\"\",IF(ROUND(Q42,0)=ROUND(H42/K42,0),\"÷\",\"\"))","v":""},{"$f":"IF(Q3=\"\",\"Select Project Type\",IF(C42=\"\", \"Enter Contributing Area\", IF(C43=\"\",\"Select Depth\",IF(C44=\"\",\"Select Infilt Rate\",IF(Q3=\"Single Family\",K46,K45)))))","v":"Select Project Type"},null,null,null,null,{"$f":"IF(OR(ISERROR(H42/K42),Q42=\"\"),\"\",IF(ROUND(Q42,0)=ROUND(H42/K42,0),\"=\",\"\"))","v":""},{"$f":"IF(OR(H42=\"\",ISTEXT(K42)),\"\",IF(H42<4,\"\",IF(C42>2*H42/K42,\"\",MIN(H42/K42,C42))))","v":""},"sf"]
[null,"Ponding Depth",null,"in",null,{"$f":"IF(OR(C42=\"\",C43=\"\",C44=\"\",ISTEXT(K42),C45=\"NO\"),\"\",\"Note: Contributing area can be\")","v":""},null,null,null,null,{"$f":"IF(OR(H42=\"\",ISTEXT(K42)),\"\",IF(H42<4,\"Note: Minimum bottom area is 4 sf\",IF(C42<ROUND(H42/K42,1),\"Note: A contributing area of up to \"&ROUND(H42/K42,1)&\" sf\", IF(C42>ROUND(H42/K42*2,1),\"Note: Contributing area may not exceed \",\"\"))))","v":""}]
[null,"Design Infiltration Rate",null,"in/hr",null,{"$f":"IF(OR(C42=\"\",C43=\"\",C44=\"\",ISTEXT(K42),C45=\"NO\"),\"\",\"mitigated with a bottom area of \"&ROUND(C42*K42,1)&\" sf\")","v":""},null,null,null,null,{"$f":"IF(OR(H42=\"\",ISTEXT(K42)),\"\",IF(H42<4,\"\",IF(C42<ROUND(H42/K42,1),\"may be mitigated by a facility of this size\", IF(C42>ROUND(H42/K42*2,1),\"twice the area mitigated (\"&ROUND(2*H42/K42,1)&\" sf)\",\"\"))))","v":""}]
[null,"Show optimize note=",{"$f":"IF(ISERROR(K45),\"NO\",IF(ISBLANK(H42),\"YES\",IF(OR(ROUND(H42,0)=ROUND(C42*K42,0),AND(ROUND(C42*K42,0)<4,H42<=4,H42>ROUND(C42*K42,2))),\"NO\",\"YES\")))","v":"NO"},null,null,"SF for nonSFR",null,null,"=",null,{"$f":"VLOOKUP(C44,IF(C43=2,X!D18:H20,IF(C43=4,X!D21:H23,IF(C43=6,X!D24:H26,IF(C43=8,X!D27:H29,IF(C43=10,X!D30:H32,IF(C43=12,X!D33:H36)))))),4)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"SF for SFR",null,null,"=",null,{"$f":"VLOOKUP(C44,IF(C43=2,X!D18:I20,IF(C43=4,X!D21:I23,IF(C43=6,X!D24:I26,IF(C43=8,X!D27:I29,IF(C43=10,X!D30:I32,IF(C43=12,X!D33:I36)))))),6)","v":{"$error":"#N/A"}}]
[null,null,{"$f":"IF(C44>0.25, \"Note:  Inflitration rates greater than 0.25 in/hr require infiltration testing\",\"\")","v":""}]
["Detention Cistern to Bioretention Cell (BC) (without Underdrain) 2"]
[null,"Contributing Area",null,"sf",null,"Bioretention Bottom Area",null,null,"sf",{"$f":"IF(OR(ISERROR(H49/K49),Q49=\"\"),\"\",IF(ROUND(Q49,0)=ROUND(H49/K49,0),\"÷\",\"\"))","v":""},{"$f":"IF(Q3=\"\",\"Select Project Type\",IF(Q3<>\"Single Family\",\"Only for SFR\", IF(C49=\"\",\"Enter Contributing Area\",IF(C50=\"\",\"Select Number Cisterns\",IF(C51=\"\",\"Select Depth\",IF(C52=\"\",\"Select Infilt Rate\",K59))))))","v":"Select Project Type"},null,null,null,null,{"$f":"IF(OR(ISERROR(H49/K49),Q49=\"\"),\"\",IF(ROUND(Q49,0)=ROUND(H49/K49,0),\"=\",\"\"))","v":""},{"$f":"IF(OR(H49=\"\",ISTEXT(K49)),\"\",IF(H49<4,\"\",MIN(H49/K49,C49)))","v":""},"sf"]
[null,"Number Cisterns",null,null,null,{"$f":"IF(OR(C49=\"\",C50=\"\",C51=\"\",ISTEXT(K49),C54=\"NO\"),\"\",\"Note: Contributing area can be\")","v":""},null,null,null,null,{"$f":"IF(OR(H49=\"\",ISTEXT(K49)),\"\",IF(H49<4,\"Note: Minimum bottom area is 4 sf\",IF(AND(C49<ROUND(H49/K49,1),H49<>4),\"Note: The facility need not be greater than\",\"\")))","v":""}]
[null,"BC Ponding Depth",null,"in",null,{"$f":"IF(OR(C49=\"\",C50=\"\",C51=\"\",ISTEXT(K49),C54=\"NO\"),\"\",\"mitigated with a bottom area of \"&ROUND(C49*K49,1)&\" sf\")","v":""},null,null,null,null,{"$f":"IF(OR(H49=\"\",ISTEXT(K49)),\"\",IF(H49<4,\"\",IF(AND(C49<ROUND(H49/K49,1),H49<>4),\"\"&MAX(4,ROUND(C49*K49,1))&\" sf for this contributing area\",\"\")))","v":""}]
[null,"BC Design Infilt Rate",null,"in/hr",null,null,null,null,null,null,{"$f":"IF(OR(H49=\"\",ISTEXT(K49)),\"\",IF(AND(C49<ROUND(H49/K49,1),C49<>2000),\"Note: A contributing area of up to \"&MIN(ROUND(H49/K49,1),2000)&\" sf\",\"\"))","v":""}]
[null,null,{"$f":"IF(C52>0.25, \"Note:  Inflitration rates greater than 0.25 in/hr require infiltration testing\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(OR(H49=\"\",ISTEXT(K49)),\"\",IF(AND(C49<ROUND(H49/K49,1),C49<>2000),\"may be mitigated by a facility of this size\",\"\"))","v":""}]
[null,"Show optimize note=",{"$f":"IF(ISERROR(F56),\"NO\",IF(ISBLANK(H49),\"YES\",IF(OR(ROUND(H49,0)=ROUND(C49*K49,0),AND(ROUND(C49*K49,0)<4,H49<=4,H49>ROUND(C49*K49,2))),\"NO\",\"YES\")))","v":"NO"},null,null,null,null,null,null,null,"1 cistern-6\"",null,"1 cistern-12\"",null,"2 cisterns-6\"",null,"2 cisterns-12\""]
[null,null,null,null,null,null,null,"0.25 in/hr","=",null,{"$f":"IF(AND($C$49>=200,$C$49<=500),X!F100,IF(AND($C$49>500,$C$49<=1000),X!F101,IF(AND($C$49>=1000,$C$49<=1500),X!F102, IF(AND($C$49>1500,$C$49<=2000),X!F103,\"\"))))","v":""},null,{"$f":"IF(AND($C$49>=200,$C$49<=500),X!F112,IF(AND($C$49>500,$C$49<=1000),X!F113,IF(AND($C$49>=1000,$C$49<=1500),X!F114, IF(AND($C$49>1500,$C$49<=2000),X!F115,\"\"))))","v":""},{"$f":"IF(AND($C$49>=200,$C$49<=500),X!F124,IF(AND($C$49>500,$C$49<=1000),X!F125,IF(AND($C$49>=1000,$C$49<=1500),X!F126, IF(AND($C$49>1500,$C$49<=2000),X!F127,\"\"))))","v":""},null,null,{"$f":"IF(AND($C$49>=200,$C$49<=500),X!F136,IF(AND($C$49>500,$C$49<=1000),X!F137,IF(AND($C$49>=1000,$C$49<=1500),X!F138, IF(AND($C$49>1500,$C$49<=2000),X!F139,\"\"))))","v":""}]
[null,"Bioretention area needed (sf)=",null,null,null,{"$f":"C49*K49","v":{"$error":"#VALUE!"}},null,"0.5 in/hr","=",null,{"$f":"IF(AND($C$49>=200,$C$49<=500),X!F104,IF(AND($C$49>500,$C$49<=1000),X!F105,IF(AND($C$49>=1000,$C$49<=1500),X!F106, IF(AND($C$49>1500,$C$49<=2000),X!F107,\"\"))))","v":""},null,{"$f":"IF(AND($C$49>=200,$C$49<=500),X!F116,IF(AND($C$49>500,$C$49<=1000),X!F117,IF(AND($C$49>=1000,$C$49<=1500),X!F118, IF(AND($C$49>1500,$C$49<=2000),X!F119,\"\"))))","v":""},{"$f":"IF(AND($C$49>=200,$C$49<=500),X!F128,IF(AND($C$49>500,$C$49<=1000),X!F129,IF(AND($C$49>=1000,$C$49<=1500),X!F130, IF(AND($C$49>1500,$C$49<=2000),X!F131,\"\"))))","v":""},null,null,{"$f":"IF(AND($C$49>=200,$C$49<=500),X!F140,IF(AND($C$49>500,$C$49<=1000),X!F141,IF(AND($C$49>=1000,$C$49<=1500),X!F142, IF(AND($C$49>1500,$C$49<=2000),X!F143,\"\"))))","v":""}]
[null,null,null,null,null,null,null,"1.0 in/hr","=",null,{"$f":"IF(AND($C$49>=200,$C$49<=500),X!F108,IF(AND($C$49>500,$C$49<=1000),X!F109,IF(AND($C$49>=1000,$C$49<=1500),X!F110, IF(AND($C$49>1500,$C$49<=2000),X!F111,\"\"))))","v":""},null,{"$f":"IF(AND($C$49>=200,$C$49<=500),X!F120,IF(AND($C$49>500,$C$49<=1000),X!F121,IF(AND($C$49>=1000,$C$49<=1500),X!F122, IF(AND($C$49>1500,$C$49<=2000),X!F123,\"\"))))","v":""},{"$f":"IF(AND($C$49>=200,$C$49<=500),X!F132,IF(AND($C$49>500,$C$49<=1000),X!F133,IF(AND($C$49>=1000,$C$49<=1500),X!F134, IF(AND($C$49>1500,$C$49<=2000),X!F135,\"\"))))","v":""},null,null,{"$f":"IF(AND($C$49>=200,$C$49<=500),X!F144,IF(AND($C$49>500,$C$49<=1000),X!F145,IF(AND($C$49>=1000,$C$49<=1500),X!F146, IF(AND($C$49>1500,$C$49<=2000),X!F147,\"\"))))","v":""}]
[null,null,null,null,null,null,null,"selected rate","=",null,{"$f":"IF($C$52=0.25,K55,IF($C$52=0.5,K56,IF($C$52=1,K57,\"\")))","v":""},null,{"$f":"IF($C$52=0.25,M55,IF($C$52=0.5,M56,IF($C$52=1,M57,\"\")))","v":""},{"$f":"IF($C$52=0.25,N55,IF($C$52=0.5,N56,IF($C$52=1,N57,\"\")))","v":""},null,null,{"$f":"IF($C$52=0.25,Q55,IF($C$52=0.5,Q56,IF($C$52=1,Q57,\"\")))","v":""}]
[null,null,null,null,null,null,null,"current SF","=",null,{"$f":"IF(AND(C50=\"1 cistern\",C51=6),K58,IF(AND(C50=\"1 cistern\",C51=12),M58,IF(AND(C50=\"2 cisterns\",C51=6),N58,IF(AND(C50=\"2 cisterns\",C51=12),Q58,\"\"))))","v":""}]
[]
["Permeable Pavement Facility (may receive run-on)3"]
[null,"Contributing Area",null,"sf",null,"Permeable Pavement Area",null,null,"sf",{"$f":"IF(OR(ISERROR(H62/K62),Q62=\"\"),\"\",IF(ROUND(Q62,0)=ROUND(H62/K62,0),\"÷\",\"\"))","v":""},{"$f":"IF(C62=\"\", \"Enter Contributing Area\", IF(C63=\"\",\"Select Depth\",IF(C64=\"\",\"Select Infilt Rate\",VLOOKUP(C64,IF(C63=\"≥6\",X!D37:H39,IF(C63=8,X!D40:H42,IF(C63=10,X!D43:H45,IF(C63=12,X!D46:H48)))),5))))","v":"Enter Contributing Area"},null,null,null,null,{"$f":"IF(OR(ISERROR(H62/K62),Q62=\"\"),\"\",IF(ROUND(Q62,0)=ROUND(H62/K62,0),\"=\",\"\"))","v":""},{"$f":"IF(OR(H62=\"\",ISTEXT(K62)),\"\",IF(C62>3*H62,\"\",MIN(H62/K62,C62)))","v":""},"sf"]
[null,"Ponding Depth 4",null,"in",null,null,null,null,null,null,"Plus Permeable Pavement Facility Area ",null,null,null,null,"=",{"$f":"IF(H62=\"\",\"\",H62)","v":""},"sf"]
[null,"Design Infiltration Rate",null,"in/hr"]
[null,null,{"$f":"IF(C64>0.25, \"Note:  Inflitration rates greater than 0.25 in/hr require infiltration testing\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(OR(H62=\"\",ISTEXT(K62)),\"\",IF(C62<ROUND(H62/K62,0),\"Note: A contributing area of up to \"&ROUND(H62/K62,0)&\" sf\", IF(C62>ROUND(H62*3,0),\"Note: Contributing area may not exceed\",\"\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H62=\"\",ISTEXT(K62)),\"\",IF(C62<ROUND(H62/K62,0),\"may be mitigated by a facility of this size\", IF(C62>ROUND(H62*3,0),\"three times the pavement area (\"&3*H62&\" sf)\",\"\")))","v":""}]
["Reuse Facilities 1"]
[null,"Rainwater Harvesting",null,null,null,"Applicant must provide documentation of area mitigated by rainwater harvesting",null,null,null,null,null,null,null,null,null,null,null,"sf"]
[]
["Impervious Surface Reduction Methods",null,null,null,null,"Facility Size",null,null,null,null,"Credit",null,null,null,null,null,"Area Mitigated"]
["Alternative Pavement Surfaces"]
["Permeable Pavement Surface (Subgrade Slope ≤2%)",null,null,null,null,"Permeable Pavement Area",null,null,"sf","x",{"$f":"X!F10","v":1},null,null,null,null,"=",{"$f":"IF(OR(H72=\"\",ISTEXT(K72)),\"\",H72*K72)","v":""},"sf"]
["Permeable Pavement Surface (Subgrade Slope >2-5%)",null,null,null,null,"Permeable Pavement Area",null,null,"sf","x",{"$f":"X!F11","v":0.55000000000000004},null,null,null,null,"=",{"$f":"IF(OR(H73=\"\",ISTEXT(K73)),\"\",H73*K73)","v":""},"sf"]
["Alternative Roof Surfaces  1"]
["Green Roof (Single/Multi-Course / 4\" Growth Medium)",null,null,null,null,"Green Roof Area",null,null,"sf","x",{"$f":"X!F12","v":0.55000000000000004},null,null,null,null,"=",{"$f":"IF(OR(H75=\"\",ISTEXT(K75)),\"\",H75*K75)","v":""},"sf"]
["Green Roof (Multi-Course / 8\" Growth Medium)",null,null,null,null,"Green Roof Area",null,null,"sf","x",{"$f":"X!F13","v":0.84},null,null,null,null,"=",{"$f":"IF(OR(H76=\"\",ISTEXT(K76)),\"\",H76*K76)","v":""},"sf"]
["Partial Infiltration  1"]
["Bioretention Cell with Detention (without Underdrain)"]
[null,"Contributing Area",null,"sf"]
[null,"Ponding Depth",null,"in",null,"Bioretention Bottom Area",null,null,"sf",null,{"$f":"IF(Q3=\"\",\"Select Project Type\",IF(Q3=\"Single Family\",\"Not Applicable for SFR\",IF(C79=\"\",\"Enter Contributing Area\",IF(C80=\"\",\"Select Depth\",IF(C84=\"\",\"Select Infilt Rate\",IF(H80=\"\",\"Select Bioretention Area\",IF(OR(C79<1500,J83=\"ERROR\"),\"\",IF(C84=0.25,X!K68,IF(C84=0.5,X!K69,IF(C84=1,X!K70,\"\"))))))))))","v":"Select Project Type"},null,null,null,null,"à",{"$f":"IF(OR(C79=\"\",ISTEXT(K80)),\"\",K80*MIN(H82,C79))","v":""},"sf"]
[null,"Show optimize note=",null,null,null,"Rqd BR Area for entered Contrib Area",null,{"$f":"IF(OR(C79=\"\",C79<1500),\"\",(VLOOKUP(C84,X!D68:J70,7)*C79)+VLOOKUP(C84,X!D68:J70,6))","v":""},"sf",null,null,null,null,null," "]
[null,null,null,null,null,"Max Contrib Area for entered BR Area",null,{"$f":"IF(OR(C79=\"\",C79<1500),\"\",(H80-VLOOKUP(C84,X!D68:J70,6))/(VLOOKUP(C84,X!D68:J70,7)))","v":""},"sf"]
[null,null,null,null,null,"Min BR Area @ infilt rate=",null,{"$f":"IF(OR(C79=\"\",C79<1500),\"\",(VLOOKUP(C84,X!D68:J70,7)*1500)+VLOOKUP(C84,X!D68:J70,6))","v":""},null,{"$f":"IF(H80<H83,\"ERROR\",\"\")","v":""}]
[null,"Design Infiltration Rate",null,"in/hr",null,{"$f":"IF(OR(C79=\"\",C80=\"\",C84=\"\",ISTEXT(K80),C81=\"NO\"),\"\",\"Note: Contributing area can be\")","v":""},null,null,null,null,{"$f":"IF(OR(K80=\"Select Project Type\",K80=\"Single Family\",K80=\"Not Applicable for SFR\",K80=\"Enter Contributing Area\",K80=\"Select Depth\",K80=\"Select Infilt Rate\",K80=\"Select Bioretention Area\"),\"\",IF(C79<1500,\"Note: Minimum contributing area is 1,500 sf\",IF(H80<H83,\"Note: Minimum allowable facility area is\",IF(C79<ROUND(H82,1),\"Note: A contributing area of up to \"&ROUND(H82,1)&\" sf\", IF(C79>2*ROUND(H82,1),\"Note: Contributing area may not exceed \",\"\")))))","v":""},null,null,null,null,null,{"$f":"IF(Q80=\"min. contributing\",\"area is 1,500 sf\",\"\")","v":""}]
[null,null,{"$f":"IF(C84>0.25, \"Note:  Inflitration rates greater than 0.25 in/hr require infiltration testing\",\"\")","v":""}]
[]
[]
["Non-Infiltrating Facilities",null,null,null,null,"Facility Size",null,null,null,null,"Credit",null,null,null,null,null,"Area Mitigated"]
["Non Infiltrating Facilities"]
["Bioretention Planter (with underdrain)"]
[null,"Contributing Area",null,"sf"]
[null,"Ponding Depth",null,"in",null,"Bioretention Bottom Area",null,{"$f":"IF(OR(C91=\"\",ISTEXT(K92)),\"\",VLOOKUP(C92,X!B49:H51,6)*C91)","v":""},"sf",null,{"$f":"IF(Q3=\"\",\"Select Project Type\", IF(C91=\"\", \"Enter Contributing Area\",IF(C92=\"\",\"Select Depth\",IF(C92=6,X!I49,IF(C92=9,X!I50,IF(C92=12,X!I51,\"\"))))))","v":"Select Project Type"},null,null,null,null,{"$f":"IF(OR(C91=\"\",ISTEXT(K92)),\"\",\"à\")","v":""},{"$f":"IF(OR(C91=\"\",ISTEXT(K92)),\"\",C91*K92)","v":""},"sf"]
[null,null,null,null,null,{"$f":"IF(H92=\"\",\"\", \"       Note: \"&H92&\"sf is the optimal size for this contributing area.  No additional credit given for larger planter.\")","v":""}]
["Detention Cistern with Harvesting Capacity 5, 6"]
[null,"Contributing Area",null,"sf",null,"Min Cistern Area",null,{"$f":"IF(OR(C95=\"\",ISTEXT(K95),C95<150),\"\",H97)","v":""},"sf",null,{"$f":"IF(Q3=\"\",\"Select Project Type\",IF(Q3<>\"Single Family\",\"Only Applicable for SFR\", IF(C95=\"\", \"Enter Contributing Area\", IF(C95<150, \"\", IF(K97>100%,100%,K97)))))","v":"Select Project Type"},null,null,null,null,{"$f":"IF(OR(C95=\"\",ISTEXT(K95)),\"\",\"à\")","v":""},{"$f":"IF(OR(C95=\"\",ISTEXT(K95)),\"\",IF(C95<150,\"\",C95*K95))","v":""},"sf"]
[null,null,null,null,null,"Min Live Cistern Volume",null,{"$f":"IF(H95=\"\",\"\",H95*3/0.1337)","v":""},"gal"]
[null,"Sized/Credited based on:",{"$f":"IF(AND(C95>=150,C95<=317),C95,IF(MOD(C95,100)=0,C95+100,ROUNDUP(C95,-2)))","v":100},"sf","SF=",{"$f":"H95/C95","v":{"$error":"#VALUE!"}},null,{"$f":"IF(C95<150, \"\",IF(AND(C95>=150,C95<317),X!C92,(X!C94*C97^X!D94)*C95/C97))","v":""},"sf",null,{"$f":"IF(C95<150, \"\",IF(AND(C95>=150,C95<=317),X!F92,X!F94*LN(C97)+X!G94))","v":""},null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(K95=\"Select Project Type\",K95=\"Only Applicable for SFR\",K95=\"Enter Contributing Area\"),\"\",IF(C95<150,\"Note: Minimum contributing area is 150 sf\",IF(C95>10000,\"Note: Maximum contributing area is 10,000 sf\",\"\")))","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Area Mitigated",null,null,null,null,{"$f":"SUM(Q15:Q96)","v":0},"sf"]
[]
[null,null,null,null,null,null,null,null,null,null,"Area Requiring Mitigation",null,null,null,null,null,{"$f":"Q11","v":""},"sf"]
[]
[null,null,null,null,null,null,null,null,null,null,"% Impervious Area Mitigated",null,null,null,null,null,{"$f":"IF(OR(Q103=\"\",Q103=0),\"\",100*Q101/Q103)","v":""},"%"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"GSI to MEF Target Achieved?",null,null,{"$f":"IF(OR(Q11=0,Q11=\"\"),\"\",IF(AND(Q11<>0,Q101>=Q11),\"YES\",\"NO\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q108=\"\",\"\",IF(Q101<Q11,\"Mitigate More Area  \",\"\"))","v":""}]
["Notes:"]
["GSI - Green Stormwater Infrastructure",null,null,"sf - square feet",null,"in - inch","eqn - equation",null,null,"BC - bioretention cell"]
["min - minimum",null,null,"ft - feet",null,"in/hr - inch per hour","gal - gallons",null,null,"infilt - infiltration"]
["1. Single family residential projects and trail/sidewalk projects are not required to evaluate this BMP.  "]
["2. Each above ground cistern must have 6.68 sf minimum bottom area, a 0.25 inch orifice and a minimum of 3 feet of live storage above the orifice.  If using two cisterns they must be connected "]
[null,"and have only one orifice. Flow from cistern orifice must be routed to bioretention cell."]
["3. The area contributing runoff to a facility shall be no larger than 3 times the permeable pavement facility area corresponding to a minimum sizing factor of 33.3%. "]
["4. Average subsurface ponding depth in aggregate storage reservoir.  "]
["5. Cistern must be above ground. Cistern area must be rounded up to next commercially available product.  Cistern need not have more than 3 feet of live storage volume above orifice.  "]
["6. Water collected using the detention cistern may be used for non-potable uses only (e.g., irrigation).  For additional uses of harvested water consider the \"Rainwater Harvesting\"  BMP.  "]
["This calculator does not provide conveyance flow calculations."]
["Applicant is responsible to ensure system overflow conveyance is provided per Section 4.2.5 of the Stormwater Manual Volume 3."]

{"sheet":"Pre-Sized Flow Control","index":3,"n_rows":117,"n_cols":20,"rows_kept":117,"cut":false,"hidden":true,"merged":[[48,0,48,3],[56,0,56,3],[50,0,50,3],[51,0,51,3],[96,13,96,14],[52,13,52,14],[71,0,71,3],[95,0,95,3],[82,0,82,3],[68,0,68,14],[72,0,72,3],[84,13,84,14],[111,0,111,14],[66,0,66,14],[83,0,83,1],[89,0,89,1],[77,0,77,3],[107,0,107,14],[67,0,67,14],[70,0,70,3],[90,13,90,14],[106,0,106,14],[103,0,103,14],[2,14,2,17],[2,0,2,10],[46,0,46,3],[45,0,45,3],[40,0,40,3],[15,0,15,3],[22,10,22,14],[8,0,8,14],[7,0,7,14],[19,0,19,3],[18,0,18,3],[6,0,6,14],[14,0,14,3],[20,0,20,3],[34,0,34,3],[24,0,24,3],[4,9,4,17],[4,0,4,7],[23,11,23,17],[9,0,9,14],[109,0,109,14],[57,0,57,3],[58,0,58,3],[26,0,26,3],[27,0,27,3],[28,0,28,3],[23,0,23,3],[41,5,41,8],[47,0,47,3],[44,0,44,3],[43,0,43,3],[49,0,49,3]]}
["City of Seattle Pre-Sized Flow Control Calculator (08-04-11)"]
[]
["Project Type",null,null,null,null,null,null,null,null,null,null,null,null,null,"Roadway Project"]
[]
["Flow Control Standard(s)",null,null,null,null,null,null,null,null,"Pre-developed Pasture Standard"]
[]
["New plus Replaced Impervious Area",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sf"]
["Area Requiring Mitigation if Only GSI Used (70% Impervious Area)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.7*R7","v":0},"sf"]
["Area Requiring Mitigation if Traditional Facilities Used (100% Impervious Area)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R7","v":0},"sf"]
["Area Requiring Mitigation (Based on Selected BMPs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R104=0,R8,R9)","v":0},"sf"]
[]
[{"$f":"IF(R7>10000,\"Error: New and replaced impervious surface may not\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Flow Control Standard Achieved?",null,null,{"$f":"IF(R10=0,\"\",IF(AND(R10<>0,R107>=R10),\"YES\",\"NO\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GSI to MEF Target Achieved?",null,null,{"$f":"IF(R11=0,\"\",IF(AND(R11<>0,R108>=R11),\"YES\",\"NO\"))","v":""},null,"Not sure of the criteria"]
[{"$f":"IF(R7>10000,\"be greater than 10,000 square feet to use the pre-sized approach\",\"\")","v":""}]
["GSI Runoff Reduction Methods",null,null,null,null,"Facility Size",null,null,null,null,"Credit",null,null,null,null,null,null,"Area Mitigated"]
["Retained Trees"]
["Existing Evergreen",null,"# Trees",1,null,"Total Canopy Area of Trees",null,null,"sf","x","20% Canopy (or min 100 sf/tree) =",null,null,null,{"$f":"IF(AND(H17=\"\",D17=\"\"),\"\",MAX(H17*X!D7, D17*X!G5))","v":100}]
["Existing Deciduous",null,"# Trees",null,null,"Total Canopy Area of Trees",null,null,"sf","x","10% Canopy (or min 50 sf/tree) =",null,null,null,{"$f":"IF(AND(H18=\"\",D18=\"\"),\"\",MAX(H18*X!D8, D18*X!G6))","v":""}]
["New Trees"]
["New Evergreen",null,null,null,null,"# Trees",null,null,null,"x","50 sf/tree =",null,null,null,{"$f":"IF(H20=\"\",\"\",H20*X!D7)","v":""}]
["New Deciduous",null,null,null,null,"# Trees",null,null,null,"x","20 sf/tree =",null,null,null,{"$f":"IF(H21=\"\",\"\",H21*X!D8)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,"Total Area Mitigated by Trees",null,null,null,null,null,"=",{"$f":"IF(R7=\"\",\"\",IF(AND(O17=\"\",O18=\"\",O20=\"\",O21=\"\"),\"\",IF(SUM(O17:O21)>0.25*R10,0.25*R10,SUM(O17:O21))))","v":""},"sf"]
["Dispersion",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(O17:O21)>0.25*R10,\"Note: Maximum tree credit is 25% of impervious area requiring mitigation\",\"\")","v":"Note: Maximum tree credit is 25% of impervious area requiring mitigation"}]
["Downspout or Sheet Flow Dispersion",null,null,null,null,"Dispersed Impervious Area",null,null,"sf","x",{"$f":"IF($J$5=\"\",\"Select Standard\",IF($J$5=\"Pre-developed Pasture and Peak Flow Control Standards\",MIN(X!D9:E9),IF($J$5=\"Pre-developed Pasture Standard\",X!D9,IF($J$5=\"Peak Flow Control Standard\",X!E9,\"\"))))","v":0.9},null,null,null,null,null,"=",{"$f":"IF(OR(H25=\"\",ISTEXT(K25)),\"\",H25*K25)","v":""},"sf"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H25<>\"\",\"Note: Confirm flow paths can be achieved\",\"\")","v":""}]
["GSI Infiltration and Reuse Facilities",null,null,null,null,"Facility Size",null,null,null,null,"Sizing Factor",null,null,null,null,null,null,"Area Mitigated",null,"Confirm that this varries with area requiring mitigation (i.e., of traditional BMPs area selecvted)"]
["Infiltrating Facilities"]
["Bioretention Cell (without underdrain)"]
[null,"Contributing Area",1000,"sf",null,"Bioretention Bottom Area",null,10,"sf","÷",{"$f":"IF($J$5=\"\",\"Select Standard\",IF(C30=\"\",\"Enter Contributing Area\",IF(C31=\"\",\"Select Depth\",IF(C32=\"\",\"Select Infilt Rate\",K33))))","v":0.14599999999999999},null,null,null,null,null,"=",{"$f":"IF(OR(H30=\"\",ISTEXT(K30)),\"\",IF(C30>2*H30/K30, \"\",MIN(H30/K30,C30)))","v":""},"sf"]
[null,"Ponding Depth",6,"in",null,{"$f":"IF(OR(C32=\"\",C32=0.25),\"\",\"Note: Infitlration test required\")","v":""},null,null,null,null,{"$f":"IF(OR(H30=\"\",ISTEXT(K30)),\"\",IF(C30<ROUND(H30/K30,1),\"Note: A contributing area of up to \"&ROUND(H30/K30,1)&\" sf\", IF(C30>ROUND(H30/K30*2,1),\"Note: Contributing area may not exceed \",\"\")))","v":"Note: Contributing area may not exceed "}]
[null,"Design Infiltration Rate",0.25,"in/hr",null,{"$f":"IF(OR(C32=\"\",C32=0.25),\"\",\"for infiltration rate > 0.25 in/hr\")","v":""},null,null,null,null,{"$f":"IF(OR(H30=\"\",ISTEXT(K30)),\"\",IF(C30<ROUND(H30/K30,1),\"may be mitigated by a facility of this size\", IF(C30>ROUND(H30/K30*2,1),\"twice the area mitigated (\"&ROUND(2*H30/K30,1)&\" sf)\",\"\")))","v":"twice the area mitigated (137 sf)"}]
[null,null,null,null,null,null,null,null,"Sizing Factor=",null,{"$f":"VLOOKUP(C32,IF(C31=2,X!D18:F20,IF(C31=4,X!D21:H23,IF(C31=6,X!D24:F26,IF(C31=8,X!D27:H29,IF(C31=10,X!D30:H32,IF(C31=12,X!D33:F36)))))),IF($J$5=\"Pre-developed Pasture and Peak Flow Control Standards\",3,IF($J$5=\"Pre-developed Pasture Standard\",2,IF(J5=\"Peak Flow Control Standard\",3))))","v":0.14599999999999999}]
[]
["Permeable Pavement Facility (may receive run-on)"]
[null,"Contributing Area",50000,"sf",null,"Permeable Pavement Area",null,1000,"sf","÷",{"$f":"IF($J$5=\"\",\"Select Standard\",IF(C36=\"\",\"Enter Contributing Area\",IF(C37=\"\",\"Select Depth\",IF(C38=\"\",\"Select Infilt Rate\",K40))))","v":0.34100000000000003},null,null,null,null,null,"=",{"$f":"IF(OR(H36=\"\",ISTEXT(K36)),\"\",IF(C36>3*H36,\"\",MIN(H36/K36,C36)))","v":""},"sf"]
[null,"Ponding Depth 1",8,"in",null,{"$f":"IF(OR(C38=\"\",C38=0.25),\"\",\"Note: Infitlration test required\")","v":"Note: Infitlration test required"},null,null,null,null,null,null,null,null,"Plus Permeable Pavement Facility Area ",null,"=",{"$f":"IF(H36=\"\",\"\",H36)","v":1000},"sf"]
[null,"Design Infiltration Rate",0.5,"in/hr",null,{"$f":"IF(OR(C38=\"\",C38=0.25),\"\",\"for infiltration rate > 0.25 in/hr\")","v":"for infiltration rate > 0.25 in/hr"},null,null,null,null,{"$f":"IF(OR(H36=\"\",ISTEXT(K36)),\"\",IF(C36<ROUND(H36/K36,0),\"Note: A contributing area of up to \"&ROUND(H36/K36,0)&\" sf\", IF(C36>ROUND(H36*3,0),\"Note: Contributing area may not exceed\",\"\")))","v":"Note: Contributing area may not exceed"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H36=\"\",ISTEXT(K36)),\"\",IF(C36<ROUND(H36/K36,0),\"may be mitigated by a facility of this size\", IF(C36>ROUND(H36*3,0),\"three times the pavement area (\"&3*H36&\" sf)\",\"\")))","v":"three times the pavement area (3000 sf)"}]
[null,null,null,null,null,null,null,null,"Sizing Factor=",null,{"$f":"VLOOKUP(C38,IF(C37=6,X!D37:F39,IF(C37=8,X!D40:H42,IF(C37=10,X!D43:H45,IF(C37=12,X!D46:F48)))),IF($J$5=\"Pre-developed Pasture and Peak Flow Control Standards\",3,IF($J$5=\"Pre-developed Pasture Standard\",2,IF($J$5=\"Peak Flow Control Standard\",3))))","v":0.34100000000000003}]
["Reuse Facilities"]
[null,"Rainwater Harvesting",null,null,null,"Applicant must provide documentation of mitigation",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H42=\"\",ISTEXT(K42)),\"\",H42/K42)","v":""},"sf"]
[]
["GSI Impervious Surface Reduction Methods",null,null,null,null,"Facility Size",null,null,null,null,"Credit",null,null,null,null,null,null,"Area Mitigated"]
["Alternative Pavement Surfaces"]
["Permeable Pavement Surface (Subgrade Slope ≤2%)",null,null,null,null,"Permeable Pavement Area",null,null,"sf","x",{"$f":"IF($J$5=\"\",\"Select Standard\",IF($J$5=\"Pre-developed Pasture and Peak Flow Control Standards\",MIN(X!D10,X!E10),IF($J$5=\"Pre-developed Pasture Standard\",X!D10,IF($J$5=\"Peak Flow Control Standard\",X!E10,\"\"))))","v":1},null,null,null,null,null,"=",{"$f":"IF(OR(H46=\"\",ISTEXT(K46)),\"\",H46*K46)","v":""},"sf"]
["Permeable Pavement Surface (Subgrade Slope >2-5%)",null,null,null,null,"Permeable Pavement Area",null,null,"sf","x",{"$f":"IF($J$5=\"\",\"Select Standard\",IF($J$5=\"Pre-developed Pasture and Peak Flow Control Standards\",MIN(X!D11,X!E11),IF($J$5=\"Pre-developed Pasture Standard\",X!D11,IF($J$5=\"Peak Flow Control Standard\",X!E11,\"\"))))","v":0.45},null,null,null,null,null,"=",{"$f":"IF(OR(H47=\"\",ISTEXT(K47)),\"\",H47*K47)","v":""},"sf"]
["Alternative Roof Surfaces"]
["Green Roof (Single/Multi-Course / 4\" Growth Medium)",null,null,null,null,"Green Roof Area",null,null,"sf","x",{"$f":"IF($J$5=\"\",\"Select Standard\",IF($J$5=\"Pre-developed Pasture and Peak Flow Control Standards\",MIN(X!D12:E12),IF($J$5=\"Pre-developed Pasture Standard\",X!D12,IF($J$5=\"Peak Flow Control Standard\",X!E12,\"\"))))","v":0.46},null,null,null,null,null,"=",{"$f":"IF(OR(H49=\"\",ISTEXT(K49)),\"\",H49*K49)","v":""},"sf"]
["Green Roof (Multi-Course / 8\" Growth Medium)",null,null,null,null,"Green Roof Area",null,null,"sf","x",{"$f":"IF($J$5=\"\",\"Select Standard\",IF($J$5=\"Pre-developed Pasture and Peak Flow Control Standards\",MIN(X!D13:E13),IF($J$5=\"Pre-developed Pasture Standard\",X!D13,IF($J$5=\"Peak Flow Control Standard\",X!E13,\"\"))))","v":0.54},null,null,null,null,null,"=",{"$f":"IF(OR(H50=\"\",ISTEXT(K50)),\"\",H50*K50)","v":""},"sf"]
["Partial Infiltration"]
["Bioretention Cell with Detention (without underdrain)"]
[null,"Contributing Area",1500,"sf",null,"Bioretention Bottom Area","(",20,"sf","-",{"$f":"IF($J$5=\"\",\"\",IF(C54=\"\",\"\",IF(C55=\"\",\"\",VLOOKUP(C55,X!D68:J70,IF($J$5=\"Pre-developed Pasture and Peak Flow Control Standards\",4,IF($J$5=\"Peak Flow Control Standard\",6,IF($J$5=\"Pre-developed Pasture Standard\",4)))))))","v":"NA"},")","÷",{"$f":"IF($J$5=\"\",\"Select Standard\",IF(C54=\"\",\"Select Depth\",IF(C55=\"\",\"Select Infilt Rate\",VLOOKUP(C55,X!D68:J70,IF($J$5=\"Pre-developed Pasture and Peak Flow Control Standards\",5,IF($J$5=\"Pre-developed Pasture Standard\",5,IF($J$5=\"Peak Flow Control Standard\",7)))))))","v":"NA for Pasture Std"},null,null,"=",{"$f":"IF(OR(H53=\"\",ISTEXT(N53)),\"\",(H53-K53)/N53)","v":""},"sf","make consistent with GSI to MEF changes"]
[null,"Ponding Depth",12,"in",null,{"$f":"IF(OR(C55=\"\",C55=0.25),\"\",\"Note: Infitlration test required for\")","v":""},null,null,null,null,{"$f":"IF(OR(H53=\"\",ISTEXT(K53)),\"\",IF(C53<ROUND((H53-K53)/N53,1),\"Note: A contributing area of up to \"&ROUND((H53-K53)/N53,1)&\" sf\", IF(C53>ROUND((H53-K53)/N53*2,1),\"Note: Contributing area may not exceed \",\"\")))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(R53=\"min. contributing\",\"area is 1,500 sf\",\"\")","v":""}]
[null,"Design Infiltration Rate",0.25,"in/hr",null,{"$f":"IF(F54<>\"\",\"infiltration rate > 0.25 in/hr\",\"\")","v":""},null,null,null,null,{"$f":"IF(OR(H53=\"\",ISTEXT(K53)),\"\",IF(C53<ROUND((H53-K53)/N53,1),\"may be mitigated by a facility of this size\", IF(C53>ROUND((H53-K53)/N53*2,1),\"twice the area mitigated (\"&ROUND(2*(H53-K53)/N53,1)&\" sf)\",\"\")))","v":""}]
[]
["GSI Non-Infiltrating Facilities",null,null,null,null,"Facility Size",null,null,null,null,"Sizing Credit/Factor/Eqn",null,null,null,null,null,null,"Area Mitigated"]
["Non Infiltrating Facilities"]
["Bioretention Planter (with underdrain)"]
[null,"Contributing Area",4500,"sf",null,"Bioretention Bottom Area",null,25,"sf","÷",{"$f":"IF($J$5=\"\",\"Select Standard\",IF(C60=\"\",\"Enter Contributing Area\",IF(C61=\"\",\"Select Depth\",K63)))","v":"NA for Pasture Standard"},null,null,null,null,null,"=",{"$f":"IF(OR(H60=\"\",ISTEXT(K60)),\"\",IF(C60>2*H60/K60, \"\",MIN(H60/K60,C60)))","v":""},"sf"]
[null,"Ponding Depth",12,"in",null,null,null,null,null,null,{"$f":"IF(OR(H60=\"\",ISTEXT(K60)),\"\",IF(C60<ROUND(H60/K60,1),\"Note: A contributing area of up to \"&ROUND(H60/K60,1)&\" sf\", IF(C60>ROUND(H60/K60*2,1),\"Note: Contributing area may not exceed \",\"\")))","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H60=\"\",ISTEXT(K60)),\"\",IF(C60<ROUND(H60/K60,1),\"may be mitigated by a facility of this size\", IF(C60>ROUND(H60/K60*2,1),\"twice the area mitigated (\"&ROUND(2*H60/K60,1)&\" sf)\",\"\")))","v":""}]
[null,null,null,null,null,null,null,null,"Sizing Factor=",null,{"$f":"VLOOKUP(C61,X!B49:H51,IF($J$5=\"Pre-developed Pasture and Peak Flow Control Standards\",4,IF($J$5=\"Pre-developed Pasture Standard\",4,IF($J$5=\"Peak Flow Control Standard\",5))))","v":"NA for Pasture Standard"}]
[]
[]
[]
["Area Mitigated by GSI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R17:R60)","v":1000},"sf"]
["Percent Area Mitigated by GSI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R7=0,\"\",100*R67/R7)","v":""},"%"]
["If area is at least 70% impervious area, no more mitigation is required"]
[]
["Traditional Facilities",null,null,null,null,"Facility Size",null,null,null,null,"Sizing Factor/Eqn",null,null,null,null,null,null,"Area Mitigated"]
["Infiltrating Facilities"]
["Infiltration Trench"]
[null,"Contributing Area",2,"sf",null,"Trench Area",null,{"$f":"IF(H75*H76=0,\"\",H75*H76)","v":25},"sf","÷",{"$f":"IF($J$5=\"\",\"Select Standard\",IF(C75=\"\",\"Select Depth\",IF(C76=\"\",\"Select Infilt Rate\",VLOOKUP(C76,IF(C75=1.5,X!D52:F54,IF(C75=3,X!D55:F57)),IF($J$5=\"Pre-developed Pasture and Peak Flow Control Standards\",3,IF($J$5=\"Pre-developed Pasture Standard\",2,IF($J$5=\"Peak Flow Control Standard\",3)))))))","v":0.16800000000000001},null,null,null,null,null,"=",{"$f":"IF(OR(H74=\"\",ISTEXT(K74)),\"\",IF(C74>2*H74/K74, \"\",MIN(H74/K74,C74)))","v":2},"sf"]
[null,"Trench Depth",1.5,"ft",null,"Width",null,5,"ft",null,{"$f":"IF(OR(H74=\"\",ISTEXT(K74)),\"\",IF(C74<ROUND(H74/K74,1),\"Note: A contributing area of up to \"&ROUND(H74/K74,1)&\" sf\", \"\"))","v":"Note: A contributing area of up to 148.8 sf"}]
[null,"Design Infiltration Rate",0.5,"in/hr",null,"Length",null,5,"ft",null,{"$f":"IF(OR(H74=\"\",ISTEXT(K74)),\"\",IF(C74<ROUND(H74/K74,1),\"may be mitigated by a facility of this size\",\"\"))","v":"may be mitigated by a facility of this size"}]
[]
["Dry Well"]
[null,"Contributing Area",5,"sf",null,"Well Area",null,25,"sf","÷",{"$f":"IF($J$5=\"\",\"Select Standard\",IF(C80=\"\",\"Select Depth\",IF(C81=\"\",\"Select Infilt Rate\",VLOOKUP(C81,IF(C80=4,X!D58:F60,IF(C80=6,X!D61:F63)),IF($J$5=\"Pre-developed Pasture and Peak Flow Control Standards\",3,IF($J$5=\"Pre-developed Pasture Standard\",2,IF($J$5=\"Peak Flow Control Standard\",3)))))))","v":0.10100000000000001},null,null,null,null,null,"=",{"$f":"IF(OR(H79=\"\",ISTEXT(K79)),\"\",IF(C79>2*H79/K79, \"\",MIN(H79/K79,C79)))","v":5},"sf"]
[null,"Well Depth",4,"ft",null,null,null,null,null,null,{"$f":"IF(OR(H79=\"\",ISTEXT(K79)),\"\",IF(C79<ROUND(H79/K79,1),\"Note: A contributing area of up to \"&ROUND(H79/K79,1)&\" sf\", \"\"))","v":"Note: A contributing area of up to 247.5 sf"}]
[null,"Design Infiltration Rate",0.5,"in/hr",null,null,null,null,null,null,{"$f":"IF(OR(H79=\"\",ISTEXT(K79)),\"\",IF(C79<ROUND(H79/K79,1),\"may be mitigated by a facility of this size\",\"\"))","v":"may be mitigated by a facility of this size"}]
[]
["Detention Facilities"]
["Detention Pipe"]
[null,"Contributing Area",380,"sf",null,"Pipe Length",{"$f":"IF(OR(AND(C86=24,H88=\"5,000sf\"),AND(C86=36,H89=\"5,000sf\"),ISTEXT(N85)),\"\",\"(\")","v":"("},100,"ft",{"$f":"IF(OR(AND(C86=24,H88=\"5,000sf\"),AND(C86=36,H89=\"5,000sf\"),ISTEXT(N85)),\"\",IF(OR(AND(C86=24,H88=\"5,000 - 10,000sf\"),AND(C86=36,H89=\"5,000 - 10,000sf\")),\"-\",\"÷\"))","v":"÷"},{"$f":"IF($J$5=\"\",\"\",IF(C86=\"\",\"\",IF(H85=\"\",\"\",IF(C86=24,K88,IF(C86=36,K89)))))","v":2.6299999999999999E-5},{"$f":"IF(OR(AND(C86=24,H88=\"5,000sf\"),AND(C86=36,H89=\"5,000sf\"),ISTEXT(N85)),\"\",IF(OR(AND(C86=24,H88=\"5,000 - 10,000sf\"),AND(C86=36,H89=\"5,000 - 10,000sf\")),\")\",\")^\"))","v":")^"},{"$f":"IF(OR(AND(C86=24,H88=\"5,000sf\"),AND(C86=36,H89=\"5,000sf\"),ISTEXT(N85)),\"\",IF(OR(AND(C86=24,H88=\"5,000 - 10,000sf\"),AND(C86=36,H89=\"5,000 - 10,000sf\")),\"÷\",\"(1/\"))","v":"(1/"},{"$f":"IF($J$5=\"\",\"Select Standard\",IF(C86=\"\",\"Select Max Head\",IF(H85=\"\",\"Enter Length\",IF(C86=24,O88,IF(C86=36,O89)))))","v":1.94},null,{"$f":"IF(OR(AND(C86=24,H88=\"5,000sf\"),AND(C86=36,H89=\"5,000sf\"),ISTEXT(N85)),\"\",IF(OR(AND(C86=24,H88=\"5,000 - 10,000sf\"),AND(C86=36,H89=\"5,000 - 10,000sf\")),\"\",\")\"))","v":")"},"=",{"$f":"IF(OR(H85=\"\",ISTEXT(N85)),\"\",IF(OR(AND(C86=24,H88=\"5,000sf\"),AND(C86=36,H89=\"5,000sf\")),5000,IF(OR(AND(C86=24,H88=\"5,000 - 10,000sf\"),AND(C86=36,H89=\"5,000 - 10,000sf\")),(H85-K85)/N85,POWER(H85/K85,1/N85))))","v":2464.7642568993024},"sf"]
[null,"Max Head Above Orifice",24,"in",null,null,null,null,null,null,{"$f":"IF(OR(H85=\"\",ISTEXT(K85)),\"\",IF(C85<ROUND(H85/K85,1),\"Note: A contributing area of up to \"&R88&\" sf\", \"\"))","v":"Note: A contributing area of up to 2464.8 sf"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H85=\"\",ISTEXT(K85)),\"\",IF(C85<ROUND(H85/K85,1),\"may be mitigated by a facility of this size\",\"\"))","v":"may be mitigated by a facility of this size"}]
[null,null,24,"in diameter",null,"Contributing Area =",null,{"$f":"IF(AND(OR($J$5=\"Pre-developed Pasture Standard\",$J$5=\"Pre-developed Pasture and Peak Flow Control Standards\"),H85<X!E72),\"<5,000sf\",IF(AND($J$5=\"Peak Flow Control Standard\",H85<X!F71),\"<5,000sf\",IF(AND(OR($J$5=\"Pre-developed Pasture Standard\",$J$5=\"Pre-developed Pasture and Peak Flow Control Standards\"),H85>=X!E72,H85<X!E71),\"5,000sf\",IF(AND($J$5=\"Peak Flow Control Standard\",H85>=X!F71, H85<X!F72),\"5,000sf\",\"5,000 - 10,000sf\"))))","v":"<5,000sf"},null,null,{"$f":"IF(H88=\"5,000sf\",\"--->\",VLOOKUP(H88,X!D71:J72,IF(OR($J$5=\"Pre-developed Pasture Standard\",$J$5=\"Pre-developed Pasture and Peak Flow Control Standards\"),4,6)))","v":2.6299999999999999E-5},null,null,null,{"$f":"IF(H88=\"5,000sf\",5000,VLOOKUP(H88,X!D71:J72,IF(OR($J$5=\"Pre-developed Pasture Standard\",$J$5=\"Pre-developed Pasture and Peak Flow Control Standards\"),5,7)))","v":1.94},null,null,{"$f":"ROUND((H85/K88)^(1/O88),1)","v":2464.8000000000002}]
[null,null,36,"in diameter",null,"Contributing Area =",null,{"$f":"IF(AND(OR($J$5=\"Pre-developed Pasture Standard\",$J$5=\"Pre-developed Pasture and Peak Flow Control Standards\"),H85<X!E74),\"<5,000sf\",IF(AND(OR($J$5=\"Pre-developed Pasture Standard\",$J$5=\"Pre-developed Pasture and Peak Flow Control Standards\"),H85>=X!E74,H85<X!E73),\"5,000sf\",IF(AND($J$5=\"Peak Flow Control Standard\",H85<X!F74),\"<5,000sf\",IF(AND($J$5=\"Peak Flow Control Standard\",H85=X!F74),\"5,000sf\",\"5,000 - 10,000sf\"))))","v":"<5,000sf"},null,null,{"$f":"IF(H89=\"5,000sf\",\"--->\",VLOOKUP(H89,X!D73:J74,IF(OR($J$5=\"Pre-developed Pasture Standard\",$J$5=\"Pre-developed Pasture and Peak Flow Control Standards\"),4,6)))","v":2.1899999999999999E-7},null,null,null,{"$f":"IF(H89=\"5,000sf\",5000,VLOOKUP(H89,X!D73:J74,IF(OR($J$5=\"Pre-developed Pasture Standard\",$J$5=\"Pre-developed Pasture and Peak Flow Control Standards\"),5,7)))","v":2.4},null,null,{"$f":"ROUND((H85/K89)^(1/O89),1)","v":4056.5}]
["Detention Vault"]
[null,"Contributing Area",2000,"sf",null,"Vault Area",{"$f":"IF(OR(AND(C92=3,H94=\"5,000sf\"),AND(C92=4,H95=\"5,000sf\"),AND(C92=4,H95=\"NA\"),ISTEXT(N91)),\"\",\"(\")","v":"("},100,"sf",{"$f":"IF(OR(AND(C92=3,H94=\"5,000sf\"),AND(C92=4,H95=\"5,000sf\"),AND(C92=4,H95=\"NA\"),ISTEXT(N91)),\"\",IF(OR(AND(C92=3,H94=\"5,000 - 10,000sf\"),AND(C92=4,H95=\"5,000 - 10,000sf\")),\"-\",\"÷\"))","v":"÷"},{"$f":"IF($J$5=\"\",\"\",IF(C92=\"\",\"\",IF(H91=\"\",\"\",IF(C92=3,K94,IF(C92=4,K95)))))","v":4.2799999999999997E-5},{"$f":"IF(OR(AND(C92=3,H94=\"5,000sf\"),AND(C92=4,H95=\"5,000sf\"),AND(C92=4,H95=\"NA\"),ISTEXT(N91)),\"\",IF(OR(AND(C92=3,H94=\"5,000 - 10,000sf\"),AND(C92=4,H95=\"5,000 - 10,000sf\")),\")\",\")^\"))","v":")^"},{"$f":"IF(OR(AND(C92=3,H94=\"5,000sf\"),AND(C92=4,H95=\"5,000sf\"),AND(C92=4,H95=\"NA\"),ISTEXT(N91)),\"\",IF(OR(AND(C92=3,H94=\"5,000 - 10,000sf\"),AND(C92=4,H95=\"5,000 - 10,000sf\")),\"÷\",\"(1/\"))","v":"(1/"},{"$f":"IF($J$5=\"\",\"Select Standard\",IF(C92=\"\",\"Select Max Head\",IF(H91=\"\",\"Enter Length\",IF(C92=3,O94,IF(C92=4,O95)))))","v":1.87},null,{"$f":"IF(OR(AND(C92=3,H94=\"5,000sf\"),AND(C92=4,H95=\"5,000sf\"),AND(C92=4,H95=\"NA\"),ISTEXT(N91)),\"\",IF(OR(AND(C92=3,H94=\"5,000 - 10,000sf\"),AND(C92=4,H95=\"5,000 - 10,000sf\")),\"\",\")\"))","v":")"},"=",{"$f":"IF(OR(H91=\"\",ISTEXT(N91)),\"\",IF(OR(AND(C92=3,H94=\"5,000sf\"),AND(C92=4,H95=\"5,000sf\")),5000,IF(OR(AND(C92=3,H94=\"5,000 - 10,000sf\"),AND(C92=4,H95=\"5,000 - 10,000sf\")),(H91-K91)/N91,POWER(H91/K91,1/N91))))","v":2544.749532831479},"sf"]
[null,"Max Head Above Orifice",3,"ft",null,null,null,null,null,null,{"$f":"IF(OR(H91=\"\",ISTEXT(K91)),\"\",IF(C91<ROUND(H91/K91,1),\"Note: A contributing area of up to \"&ROUND(H91/K91,1)&\" sf\", \"\"))","v":"Note: A contributing area of up to 2336448.6 sf"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H91=\"\",ISTEXT(K91)),\"\",IF(C91<ROUND(H91/K91,1),\"may be mitigated by a facility of this size\",\"\"))","v":"may be mitigated by a facility of this size"}]
[null,null,3,"ft head",null,"Contributing Area =",null,{"$f":"IF(AND(OR($J$5=\"Pre-developed Pasture Standard\",$J$5=\"Pre-developed Pasture and Peak Flow Control Standards\"),H91<X!E76),\"<5,000sf\",IF(AND($J$5=\"Peak Flow Control Standard\",H91<X!F75),\"<5,000sf\",IF(AND(OR($J$5=\"Pre-developed Pasture Standard\",$J$5=\"Pre-developed Pasture and Peak Flow Control Standards\"),H91>=X!E76,H91<X!E75),\"5,000sf\",IF(AND($J$5=\"Peak Flow Control Standard\",H91>=X!F75, H91<X!F76),\"5,000sf\",\"5,000 - 10,000sf\"))))","v":"<5,000sf"},null,null,{"$f":"IF(H94=\"5,000sf\",\"--->\",VLOOKUP(H94,X!D75:J76,IF(OR($J$5=\"Pre-developed Pasture Standard\",$J$5=\"Pre-developed Pasture and Peak Flow Control Standards\"),4,6)))","v":4.2799999999999997E-5},null,null,null,{"$f":"IF(H94=\"5,000sf\",5000,VLOOKUP(H94,X!D75:J76,IF(OR($J$5=\"Pre-developed Pasture Standard\",$J$5=\"Pre-developed Pasture and Peak Flow Control Standards\"),5,7)))","v":1.87}]
[null,null,4,"ft head",null,"Contributing Area =",null,{"$f":"IF(OR($J$5=\"Pre-developed Pasture Standard\",$J$5=\"Pre-developed Pasture and Peak Flow Control Standards\"),\"NA\",IF(AND($J$5=\"Peak Flow Control Standard\",H91<X!F77),\"<5,000sf\",IF(AND($J$5=\"Peak Flow Control Standard\",H91>=X!F77,H91<X!F78),\"5,000sf\",\"5,000 - 10,000sf\")))","v":"NA"},null,null,{"$f":"IF(H95=\"5,000sf\",\"--->\",VLOOKUP(H95,X!D77:J78,IF(OR($J$5=\"Pre-developed Pasture Standard\",$J$5=\"Pre-developed Pasture and Peak Flow Control Standards\"),4,6)))","v":"NA"},null,null,null,{"$f":"IF(H95=\"5,000sf\",5000,VLOOKUP(H95,X!D77:J78,IF(OR($J$5=\"Pre-developed Pasture Standard\",$J$5=\"Pre-developed Pasture and Peak Flow Control Standards\"),5,7)))","v":"NA for Pasture Std"}]
["Aboveground Cistern"]
[null,"Contributing Area",2,"sf",null,"Cistern Area",{"$f":"IF(ISTEXT(N97),\"\",IF(OR($J$5=\"Peak Flow Control Standard\",AND(C98=3,H100=\"<6,140sf\")),\"(\",IF(AND(C98=3,H100=\">8,000sf\"),\"(\",\"\")))","v":""},null,"sf",{"$f":"IF(ISTEXT(N97),\"\",IF(OR($J$5=\"Peak Flow Control Standard\",AND(C98=3,H100=\"<6,140sf\")),\"÷\",IF(AND(C98=3,H100=\">8,000sf\"),\"-\",\"\")))","v":""},{"$f":"IF($J$5=\"\",\"\",IF(C98=\"\",\"\",IF(H97=\"\",\"\",IF(C98=3,K100,IF(C98=4,K101)))))","v":""},{"$f":"IF(ISTEXT(N97),\"\",IF(OR($J$5=\"Peak Flow Control Standard\",AND(C98=3,H100=\"<6,140sf\")),\")^\",IF(AND(C98=3,H100=\">8,000sf\"),\")\",\"\")))","v":""},{"$f":"IF(ISTEXT(N97),\"\",IF(OR($J$5=\"Peak Flow Control Standard\",AND(C98=3,H100=\"<6,140sf\")),\"(1/\",IF(AND(C98=3,H100=\">8,000sf\"),\"÷\",\"\")))","v":""},{"$f":"IF($J$5=\"\",\"Select Standard\",IF(C98=\"\",\"Select Max Head\",IF(H97=\"\",\"Enter Area\",IF(C98=3,O100,IF(C98=4,O101)))))","v":"Enter Area"},null,{"$f":"IF(ISTEXT(N97),\"\",IF(OR($J$5=\"Peak Flow Control Standard\",AND(C98=3,H100=\"<6,140sf\")),\")\",IF(AND(C98=3,H100=\">8,000sf\"),\"\",\"\")))","v":""},"=",{"$f":"IF(OR(H97=\"\",ISTEXT(N97)),\"\",IF(AND(OR($J$5=\"Pre-developed Pasture Standard\",$J$5=\"Pre-developed Pasture and Peak Flow Control Standards\"),C98=3,H97=760),8000,IF(OR($J$5=\"Peak Flow Control Standard\",AND(C98=3,H100=\"<6,140sf\")),POWER((H97/K97),(1/N97)),IF(AND(C98=3,H100=\">8,000sf\"),(H97-K97)/N97,\"\"))))","v":""},"sf"]
[null,"Max Head Above Orifice",3,"ft",null,null,null,null,null,null,{"$f":"IF(OR(H97=\"\",ISTEXT(K97)),\"\",IF(C97<ROUND(H97/K97,1),\"Note: A contributing area of up to \"&ROUND(H97/K97,1)&\" sf\", \"\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(H97=\"\",ISTEXT(K97)),\"\",IF(C97<ROUND(H97/K97,1),\"may be mitigated by a facility of this size\",\"\"))","v":""}]
[null,null,3,"ft head",null,"Contributing Area =",null,{"$f":"IF($J$5=\"Peak Flow Control Standard\",\"NA\",IF(AND(OR($J$5=\"Pre-developed Pasture Standard\",$J$5=\"Pre-developed Pasture and Peak Flow Control Standards\"),C98=4),\"NA\",IF(AND(OR($J$5=\"Pre-developed Pasture Standard\",$J$5=\"Pre-developed Pasture and Peak Flow Control Standards\"),C98=3),IF(H97<760,\"<6,140sf\",IF(H97=760,\"6,140 - 8,000sf\",IF(H97>760,\">8,000sf\",\"\"))))))","v":"<6,140sf"},null,null,{"$f":"IF(H100=\"NA\",X!I79,IF(H100=\"6,140 - 8,000sf\",\"--->\",VLOOKUP(H100,X!D79:H82,4)))","v":5.9899999999999997E-3},null,null,null,{"$f":"IF(H100=\"NA\",X!J79,VLOOKUP(H100,X!D79:H82,5))","v":1.347}]
[null,null,4,"ft head",null,"Contributing Area =",null,"NA",null,null,{"$f":"IF(AND(OR($J$5=\"Pre-developed Pasture Standard\",$J$5=\"Pre-developed Pasture and Peak Flow Control Standards\"),C98=4),VLOOKUP(H101,X!D79:J82,4),VLOOKUP(H101,X!D79:J82,6))","v":4.17E-4},null,null,null,{"$f":"IF(AND(OR($J$5=\"Pre-developed Pasture Standard\",$J$5=\"Pre-developed Pasture and Peak Flow Control Standards\"),C98=4),VLOOKUP(H101,X!D79:J82,5),VLOOKUP(H101,X!D79:J82,7))","v":1.58}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K97=\"NA\",\"Must use 3 ft Head\",\"\")","v":""}]
[]
["Area Mitigated by Traditional Facilities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R74:R101)","v":11537.813789730782},"sf"]
[]
[]
["Total Area Mitigated ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R67,R104)","v":12537.813789730782},"sf"]
["Percent Area Mitigated by GSI ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R68","v":""},"%"]
[]
["Flow Control Standard Achieved?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R12","v":""}]
[]
["Notes:"]
["GSI - Green Stormwater Infrastructure",null,null,"sf - square feet",null,"in - inch",null,"NA - not applicable"]
["min -minimum",null,null,"ft - feet",null,"in/hr - inch per hour",null,"std - standard"]
["1. Average subsurface ponding depth in aggregate storage reservoir.  "]
["This calculator does not provide conveyance flow calculations."]
["Applicant is responsible to ensure system overflow conveyance is provided per Section 4.2.5 of the Stormwater Manual Volume 3."]

{"sheet":"Feasibility Checklist-RW","index":4,"n_rows":81,"n_cols":4,"rows_kept":81,"cut":false,"hidden":false,"merged":[[15,0,16,0],[15,3,16,3],[18,0,30,0],[31,0,35,0],[3,0,7,0],[3,3,7,3],[12,0,14,0],[12,3,14,3],[8,0,11,0],[8,3,11,3],[36,3,37,3],[38,3,45,3],[18,3,30,3],[31,3,35,3],[59,0,61,0],[36,0,37,0],[38,0,45,0],[46,0,48,0],[62,3,68,3],[69,3,70,3],[72,0,80,0],[72,3,80,3],[46,3,48,3],[59,3,61,3],[62,0,68,0],[69,0,70,0],[50,0,58,0],[50,3,58,3]]}
["GSI to MEF Requirement Feasibility Checklist for Roadway, Trail and Sidewalk Projects (2013-03-01)"]
["BMP","Feasibility Considerations","√","Additional information from applicant"]
["Category 1: Runoff Reduction Methods"]
["Retain Existing Trees","● No existing trees in project area."]
[null,"● SDOT Urban Forestry has required and/or approved street tree removal (Street Trees will not be required to be removed for the purpose of installing other GSI BMPs)."]
[null,"● New and/or replaced ground level impervious surface not proposed within 20 feet of existing tree (defer to SDOT Urban Forestry regarding Street Tree retention).",""]
[null,"● For tree(s) with a diameter greater than or equal to 6”, significant grading within the dripline is unavoidable or otherwise does not meet standards (per COS Standard Plans and Specifications) required for retention (defer to SDOT Urban Forestry regarding Street Tree retention)."]
[null,"● For tree(s) with a diameter between 4-6”: significant grading is unavoidable within 5 feet of tree trunk or otherwise does not meet standards (per COS Standard Plans and Specifications) required for retention (defer to SDOT Urban Forestry regarding Street Tree retention)."]
["All Dispersion BMPs","● Design cannot accommodate dispersion due to infiltration restrictions and setbacks (identify from list below):"]
[null,"1.  Geotechnical evaluation determines infiltration not be used anywhere within project area due to reasonable concerns of erosion, slope failure, or down-gradient flooding (submit a signed and stamped geotechnical report)."]
[null,"2.  Project within a landslide hazard area defined by the Regulations for Environmental Critical Areas."]
[null,"3.  Project area in or within 100 feet of a known contaminated site or abandoned landfill."]
["Sheet Flow Dispersion","● Positive drainage for sheet flow runoff is unachievable."]
[null,"● Dispersion area cannot be graded to have less than a 15% slope."]
[null,"● At least a 10-foot wide vegetation buffer for dispersion of the adjacent 20 feet of impervious surface is unachievable."]
["New Trees","● SDOT Urban Forestry does not allow installation of Street Trees."]
[null,"● Space necessary for the mature height, size, and/or rooting depth for tree planting per the current COS Recommended Tree List (defer to SDOT Urban Forestry regarding Street Tree installation) is unachievable."]
["Category 2:  Infiltrating and Reuse Facilities "]
["All Infiltrating Facilities (including permeable paving facilities bioretention without impermeable liner, and bioretention with detention.)","● Infiltration restrictions and setbacks per Stormwater Manual Vol. 3, Chapter 4.3 must be considered. “Infiltration Feasibility Flowchart” is provided in Appendix C for initial screening purposes. Infiltrating facilities may not be sited within:"]
[null,"1.  Landslide prone critical areas"]
[null,"2.  Setbacks from steep slope areas"]
[null,"3.  100 feet of a known contaminated site or abandoned landfill"]
[null,"4.  Other setbacks presented in the Stormwater Manual Vol. 3 (e.g., setbacks from structures)."]
[null,"● The minimum vertical separation of three feet from the facility bottom to the seasonal high groundwater elevation, bedrock, or other impermeable layer cannot be achieved and where the area tributary to the facility to an individual facility meets or exceeds any of the following limitations:"]
[null,"1.  5,000 sf of pollution generating impervious surface (PGIS)"]
[null,"2.  10,000 sf of impervious area"]
[null,"3.  3/4 acres of lawn and landscaped area."]
[null,"● The tributary area to an individual facility does not exceed the area limitations above but the minimum vertical separation of one foot from the facility bottom to the underlying water table, bedrock, or other impermeable layer cannot be achieved."]
[null,"● Geotechnical evaluation determines infiltration NOT be used anywhere within the project area due to reasonable concerns of erosion, slope failure, or down-gradient flooding (submit signed and stamped geotechnical report)."]
[null,"● Pilot infiltration test (PIT) results demonstrate that the design soil infiltration rate is less than 0.25 inches/hr (testing shall be per Appendix E of Stormwater Manual Vol. 3)."]
[null,"● Minimum vertical and horizontal clearance from utilities is unachievable as required by utility owner."]
["Bioretention Facilities (without impermeable liner)","● Bioretention facility evaluation is not required if the project site meets all of the following:"]
[null,"1.  Discharges through a piped component of the public drainage system to a designated receiving water (SMC 22.801.050), and"]
[null,"2.  Does not discharge to a capacity constrained system, and"]
[null,"3.  Does not include new plus replaced PGIS areas. (Note: if the project meets criteria 1 and 2 above, but not criteria 3, bioretention facility evaluation is only required for the new plus replaced PGIS areas.)"]
[null,"● This is a right-of-way application and the project area does not have an approved location for bioretention facility use per the Right-of-Way Improvement Manual."]
["Bioretention Facilities (without impermeable liner) \n\n(continued)","● Project site design cannot accommodate bioretention areas because site’s longitudinal surface slopes parallel to bioretention area cannot be graded to less than 7 percent."]
[null,"● For projects within the right-of-way, total required bioretention surface area (top area including side slopes and bottom) is less than 500 sf. Minimum facility size cannot be met due to such examples as:  encroachment within the critical root zone of an existing tree(s); minimum utility setbacks cannot be met; required pedestrian access; project limits are too small; directing runoff from impervious surfaces to meet minimum bioretention cell size in right-of-way not feasible due to longitudinal slope of project; amount of new plus replaced impervious surface area does not warrant installation of a bioretention cell with a 500 sf surface area.The minimum bottom cell width of the bioretention facility cannot be met due to site constraints (e.g. setbacks, planting strip width.)"]
["Permeable Pavement Facilities","● Permeable pavement facility evaluation is not required if the project site meets all of the following:"]
[null,"1.  Discharges through a piped component of the public drainage system to a designated receiving water (SMC 22.801.050), and"]
[null,"2.  Does not discharge to a capacity constrained system, and"]
[null,"3.  Does not include new or replaced PGIS areas. (Note: if the project meets criteria 1 and 2 above, but not criteria 3, permeable pavement evaluation is only required for the new plus replaced PGIS areas.)"]
[null,"● This is a right-of-way application and the project area does not have an approved location for permeable pavement use per the Right-of-Way Improvement Manual. See CAM #2215 for reference."]
[null,"● Site has high potential for concentrated pollutant spills."]
[null,"● A permeable pavement wearing course of 5 percent or less slope is unachievable."]
[null,"● A contributing tributary of less than 3 times the permeable pavement facility is unachievable."]
["Rainwater Harvesting","● Rainwater harvesting evaluation is not required if project site is one of the following:"]
[null,"1.  Trail or Sidewalk Project"]
[null,"2.  Roadway Project"]
["Category 3:  Impervious Surface Reduction Methods"]
["Permeable Pavement Surface","● Permeable Pavement Surface evaluation is not required if the project site meets all of the following:"]
[null,"1.  Discharges through a piped component of the public drainage system to a designated receiving water (SMC 22.801.050), and"]
[null,"2.  Does not discharge to a capacity constrained system, and"]
[null,"3.  Does not include new or replaced PGIS areas. (Note:  if the project meets criteria 1 and 2 above, but not criteria 3, permeable pavement evaluation is only required for the new plus replaced PGIS areas.)"]
[null,"● This is a right-of-way application and the project area does not have an approved location for permeable pavement use per the Right-of-Way Improvement Manual. See CAM #2215 for reference."]
[null,"● A permeable pavement wearing course of 2 percent or less slope is unachievable and the project includes greater than 5,000 sf of new plus replaced PGIS (Water Quality trigger).  Rationale: permeable pavement surfaces slope with greater than 2 percent slope do not fully meet the treatment standard for water quality."]
[null,"● Site has high potential for concentrated pollutant spills."]
[null,"● A permeable pavement wearing course of 5 percent or less slope is unachievable.  "]
[null,"● Run-on from an impervious surface area of 10 percent or less of the permeable pavement surface area is unachievable."]
["Green Roof","● Green roof evaluation is not required if project site is one of the following:"]
[null,"1.  Trail or Sidewalk Project"]
[null,"2.  Roadway Project"]
["Bioretention with Detention","● Bioretention with detention evaluation is not required if project site is one of the following:"]
[null,"1.  Project is a Trail or Sidewalk Project."]
[null,"2.  Project discharges through a piped component of the public drainage system to a designated receiving water (SMC 22.801.050), and does not discharge to a capacity constrained system."]
[null,"3.  Site does not have runoff concentrated from over 1,500 sf impervious surface.  Rationale:  for smaller contributing areas, bioretention cells without detention require less area."]
[null,"4.  Does not include new or replaced PGIS areas. (Note: if the project meets criteria 1 and 2 above, but not criteria 3, bioretention with detention evaluation is only required for the new plus replaced PGIS areas if the new plus replaced PGIS is over1,500 sf.)"]
[null,"● This is a right-of-way application and the project area does not have an approved location for bioretention facility use per the Right-of-Way Improvement Manual."]
[null,"● Project site cannot accommodate bioretention areas because site’s longitudinal surface slopes parallel to bioretention area cannot be graded to less than 7 percent."]
["Bioretention with Detention\n\n(continued)","● For projects within the right-of-way, total required bioretention surface area (top area including side slopes and bottom) is less than 500 sf. Minimum facility size cannot be met due to such examples as:  encroachment within the critical root zone of an existing tree(s); minimum utility setbacks cannot be met; required pedestrian access; project limits are too small; directing runoff from impervious surfaces to meet minimum bioretention cell size in right-of-way not feasible due to longitudinal slope of project; amount of new plus replaced impervious surface area does not warrant installation of a bioretention cell with a 500 sf surface area."]
[null,"● The minimum bottom cell width of the bioretention facility cannot be met due to site constraints (e.g. setbacks, planting strip width.)"]
["Category 4: Non-Infiltrating BMPs"]
["Bioretention Planter","● Bioretention Planter evaluation is not required if the project site meets all of the following:"]
[null,"1.  Project is a Trail or Sidewalk Project."]
[null,"2.  Discharges through a piped component of the public drainage system to a designated receiving water (SMC 22.801.050), and"]
[null,"3.  Does not discharge to a capacity constrained system, and"]
[null,"4.  Does not include new or replaced PGIS areas. (Note: if the project meets criteria 1 and 2 above, but not criteria 3, bioretention planter evaluation is only required for the new plus replaced PGIS areas.)"]
[null,"● Project site cannot accommodate bioretention areas because site’s longitudinal surface slopes parallel to bioretention area cannot be graded to less than 7 percent."]
[null,"● For projects within the right-of-way, total required bioretention surface area (top area including side slopes and bottom) is less than 500 sf. Minimum facility size cannot be met due to such examples as:  encroachment within the critical root zone of an existing tree(s); minimum utility setbacks cannot be met; required pedestrian access; project limits are too small; directing runoff from impervious surfaces to meet minimum bioretention cell size in right-of-way not feasible due to longitudinal slope of project; amount of new plus replaced impervious surface area does not warrant installation of a bioretention cell with a 500 sf surface area."]
[null,"● The minimum bottom cell width of the bioretention facility cannot be met due to site constraints (e.g. setbacks, planting strip width.)"]
[null,"● This is a right-of-way application and the project area does not have an approved location for bioretention facility use per the Right-of-Way Improvement Manual."]

{"sheet":"Feasibility Checklist-SFRParcel","index":5,"n_rows":72,"n_cols":4,"rows_kept":72,"cut":false,"hidden":false,"merged":[[7,3,11,3],[12,3,13,3],[68,0,69,0],[70,0,71,0],[52,0,59,0],[60,0,66,0],[0,0,0,3],[34,0,36,0],[37,0,39,0],[40,0,45,0],[47,0,51,0],[3,0,6,0],[12,0,13,0],[14,0,15,0],[16,0,18,0],[21,0,33,0],[3,3,6,3],[7,0,11,0]]}
["GSI to MEF Requirement Feasibility Checklist for Single-Family Residential and Parcel-Based Projects (2013-03-01)"]
["BMP","Feasibility Considerations","√","Additional information from applicant"]
["Category 1: Runoff Reduction Methods"]
["Retain Existing Trees","● No existing trees in project area."]
[null,"● New and/or replaced ground level impervious surface not proposed within 20 feet of existing tree."]
[null,"● For tree(s) with a diameter greater than or equal to 6”, significant grading is unavoidable within the dripline or otherwise does not meet standards (per COS Standard Plans and Specifications) required for retention."]
[null,"● For tree(s) with a diameter between 4-6”: significant grading is unavoidable within 5 feet of tree trunk or otherwise does not meet standards (per COS Standard Plans and Specifications) required for retention."]
["All Dispersion BMPs","● Dispersion evaluation is not required if site is Single-Family Residential Project."]
[null,"● Design cannot accommodate dispersion due to infiltration restrictions and setbacks (identify from list below):"]
[null,"1.  Geotechnical evaluation determines infiltration not be used anywhere within project area due to reasonable concerns of erosion, slope failure, or down-gradient flooding (submit a signed and stamped geotechnical report)."]
[null,"2.  Project within a landslide hazard area defined by the Regulations for Environmental Critical Areas."]
[null,"3.  Project area in or within 100 feet of a known contaminated site or abandoned landfill."]
["Downspout Dispersion - Splash Block","● There are no downspouts."]
[null,"● A 50-foot minimum flow path for the dispersion area or a maximum of 700 sf drainage area to any dispersion area is unachievable."]
["Downspout Dispersion- Gravel Filled Trench","● There are no downspouts."]
[null,"● A minimum 10 ft length of trench for every 700 sf of drainage area followed by 25-foot minimum flow path (or 50-feet above a steep slope) is unachievable."]
["Sheet Flow Dispersion","● Positive drainage for sheet flow runoff is unachievable."]
[null,"● Dispersion area cannot be graded to have less than a 15% slope."]
[null,"● At least a 10-foot wide vegetation buffer for dispersion of the adjacent 20 feet of impervious surface is unachievable."]
["New Trees","● Space necessary for the mature height, size, and/or rooting depth for tree planting per the current COS Recommended Tree List is unachievable."]
["Category 2:  Infiltrating and Reuse Facilities "]
["All Infiltrating Facilities (including permeable paving facilities bioretention without impermeable liner, and bioretention with detention.)","● Infiltration restrictions and setbacks per Stormwater Manual Vol. 3, Chapter 4.3 must be considered. “Infiltration Feasibility Flowchart” is provided in Appendix C for initial screening purposes. Infiltrating facilities may not be sited within:"]
[null,"1.  Landslide prone critical areas"]
[null,"2.  Setbacks from steep slope areas"]
[null,"3.  100 feet of a known contaminated site or abandoned landfill"]
[null,"4.  Other setbacks presented in the Stormwater Manual Vol. 3 (e.g., setbacks from structures)."]
[null,"● The minimum vertical separation of three feet from the facility bottom to the seasonal high groundwater elevation, bedrock, or other impermeable layer cannot be achieved and where the area tributary to the facility to an individual facility meets or exceeds any of the following limitations:"]
[null,"1.  5,000 sf of pollution generating impervious surface (PGIS)"]
[null,"2.  10,000 sf of impervious area"]
[null,"3.  3/4 acres of lawn and landscaped area."]
[null,"● The tributary area to an individual facility does not exceed the area limitations above but the minimum vertical separation of one foot from the facility bottom to the underlying water table, bedrock, or other impermeable layer cannot be achieved."]
[null,"● Geotechnical evaluation determines infiltration not be used anywhere within the project area based on reasonable concerns of erosion, slope failure, or down-gradient flooding (submit a signed and stamped geotechnical report)."]
[null,"● Minimum vertical and horizontal clearance from utilities is unachievable as required by utility owner."]
[null,"● Pilot infiltration test (PIT) results demonstrate that the design soil infiltration rate is less than 0.25 inches/hr (testing shall be per Appendix E of Stormwater Manual Vol. 3)."]
["Bioretention Facilities (without impermeable liner)","● Project site cannot accommodate bioretention areas because site’s longitudinal surface slopes parallel to bioretention area cannot be graded to less than 7 percent."]
[null,"● The minimum bottom cell width of the bioretention facility cannot be met due to site constraints (e.g. setbacks, planting strip width.)"]
[null,"● The minimum 1% fall from the building to the facility and from the facility to the point of connection to the public system is unachievable."]
["Permeable Pavement Facilities","● Site has high potential for concentrated pollutant spills."]
[null,"● A permeable pavement wearing course of 5 percent or less slope is unachievable."]
[null,"● A contributing tributary area of less than 3 times the permeable pavement facility area is unachievable."]
["Rainwater Harvesting","● Rainwater harvesting evaluation is not required if project site is one of the following:"]
[null,"1.  Single Family Residential Project."]
[null,"2.  Project discharges through a piped component of the public drainage system to a designated receiving water (SMC 22.801.050), and does not discharge to a capacity constrained system."]
[null,"3.  Parcel-Based project with less than 10,000 sf new plus replaced rooftop surface."]
[null,"4.  Non-potable water demand is insufficient to use the harvested rainwater."]
[null,"● Project does not include a roof from which to harvest rainwater."]
["Category 3:  Impervious Surface Reduction Methods"]
["Permeable Pavement Surface","● A permeable pavement wearing course of 2 percent or less slope is unachievable and the project includes greater than 5,000 sf of new plus replaced PGIS (Water Quality trigger).  Rationale:  permeable pavement surfaces with greater than 2 percent slope do not fully meet the treatment standard for water quality."]
[null,"● Site has high potential for concentrated pollutant spills."]
[null,"● A permeable pavement wearing course of 5 percent or less slope is unachievable."]
[null,"● Run-on from an impervious area of 10 percent or less of the permeable pavement surface area is unachievable."]
[null,"● Geotechnical evaluation recommends permeable pavement cannot be used anywhere within the project area due to reasonable concerns of erosion, slope failure, or down-gradient flooding (attach geotechnical report)."]
["Green Roof","● Green roof evaluation is not required if project site is one of the following:"]
[null,"1.  Single-Family Residential Project"]
[null,"2.  Parcel-Based Project with less than 5,000 sf new plus replaced rooftop surface."]
[null,"3.  Project discharges through a piped component of the public drainage system to a designated receiving water (SMC 22.801.050), and does not discharge to a capacity constrained system."]
[null,"● Roof design has a slope greater than"]
[null,"2.5-inch:12-inch (20%)."]
[null,"● Building cannot feasibly be designed to accommodate structural load of green roofs."]
[null,"● Project does not include a roof."]
["Bioretention with Detention","● Bioretention with detention evaluation is not required if project site is one of the following:"]
[null,"1.  Project is a Single-Family Residential Project."]
[null,"2.  Project discharges through a piped component of the public drainage system to a designated receiving water (SMC 22.801.050), and does not discharge to a capacity constrained system."]
[null,"3.  Site does not have runoff concentrated from over 1,500 sf impervious surface Rationale:  for smaller contributing areas, bioretention cells without detention require less area."]
[null,"4.  Does not include new or replaced PGIS areas. (Note: if the project meets criteria 1 and 2 above, but not criteria 3, bioretention with detention evaluation is only required for the new plus replaced PGIS areas if the  new plus replaced PGIS is over 1,500 sf.)"]
[null,"● Project site cannot accommodate bioretention areas because site’s longitudinal surface slopes parallel to bioretention area cannot be graded to less than 7 percent."]
[null,"● The minimum bottom cell width of the bioretention facility cannot be met due to site constraints (e.g. setbacks.)"]
["Category 4: Non-Infiltrating BMPs"]
["Bioretention Planter","● Project site cannot accommodate bioretention areas because site’s longitudinal surface slope parallel to bioretention area cannot be graded to less than 7 percent."]
[null,"● The minimum bottom cell width of the bioretention facility cannot be met due to site constraints (e.g. setbacks.)"]
["Detention Cistern for Single-Family Residential Projects","● Detention cistern evaluation is not required (or allowed) because site is a Parcel-Based project."]
[null,"● Project site cannot accommodate above ground detention cisterns.  Below ground detention cisterns are not considered GSI."]

{"sheet":"GSI BMP Design Requirements","index":6,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":true,"merged":[[13,0,13,1],[14,0,14,1]]}
["BMP","Design Requirements1"]
["Category 1: Runoff Reduction Methods"]
["Retaining Tree \n(Evergreen & Deciduous)","• Trees must be on the development site and within 20 feet of new and/or replaced ground level impervious surfaces (e.g., driveway, patio, or parking lot). Distance from impervious surfaces is measured from the edge of the surface to the center of the tree at ground level.\n• Retained trees shall have a minimum 6 inches diameter at breast height (DBH). DBH is defined as the outside bark diameter at 4.5 feet above the ground on the uphill side of a tree.  For existing trees smaller than this, the newly planted tree credit may be applied.\n• The retained tree canopy area shall be measured at the time of permit application as the area within the tree drip line. A drip line is the line encircling the base of a tree, which is delineated by a vertical line extending from the outer limit of a tree's branch tips down to the ground. If trees are clustered, overlapping canopies are not double counted.\n• Trees must be viable for long-term retention (i.e., in good health and compatible with proposed construction).\n• The existing tree roots, trunk, and canopy shall be fenced and protected during construction activities. \n• Trees planted in planter boxes are not eligible for flow control credit.\n• The total tree credit for retained and newly planted trees shall not exceed 25 percent of impervious surface requiring mitigation.\n• Tree credits are not applicable to trees in native vegetation areas used for flow dispersion or other flow control credit.\n• Trees shall be retained, maintained and protected on the site after construction and for the life of the development or until any approved redevelopment occurs\n in the future. Trees that are removed or die shall be replaced with like species during the next planting season (typically in fall). \n• Trees shall be pruned according to industry standards."]
["Planting New Tree \n(Evergreen & Deciduous)","• Trees must be on the development site and within 20 feet of new and/or replaced ground level impervious surfaces (e.g., driveway, patio, or parking lot). Distance from impervious surfaces is measured from the edge of the surface to the center of the tree at ground level.\n• New deciduous trees shall be at least 1.5 inches in diameter measured 6 inches above the ground. New evergreen trees shall be at least 4 feet tall.\n• Approved tree species are listed in the Seattle Green Factor Tree List, available via link from the SPU GSI web site (http://www.seattle.gov/util/greeninfrastructure). Trees must be “Medium/Small” or larger.\n• Mature tree height, size, and rooting depth must be considered to ensure that the tree location is appropriate given adjacent and above- and below-ground infrastructure. \n• To help ensure tree survival and canopy coverage, the minimum tree spacing for newly planted trees shall accommodate mature tree spread (maximum tree density is 10 feet on center spacing). \n• Provisions shall be made for supplemental irrigation during the first three growing seasons after installation to help ensure tree survival.\n• Trees planted in planter boxes are not eligible for flow control credit.\n• The total tree credit for retained and newly planted trees shall not exceed 25 percent of impervious surface requiring mitigation.\n• Tree credits are not applicable to trees in native vegetation areas used for flow dispersion or other flow control credit.\n• Trees shall be retained, maintained and protected on the site after construction and for the life of the development or until any approved redevelopment occurs\n in the future. Trees that are removed or die shall be replaced with like species during the next planting season (typically in fall). \n• Trees shall be pruned according to industry standards."]
["Partial Dispersion ","• Downspout or sheet flow dispersion BMP must be designed per the requirements (e.g., minimum vegetated flow paths) presented in the Pierce County Manual (see “downspout dispersion” in Volumes I & VI, and “concentrated flow dispersion” and “sheet flow dispersion” in Volume VI."]
["Category 2: Infiltrating and Reuse Facilities"]
["Bioretention \n(2-, 6- & 12-inch Ponding Depth)\n","• Bioretention bottom area shall be sized using the sizing tool and subject to a minimum of 4 square feet.\n• Top area (total facility footprint) will be larger than the bottom area and can be calculated as a function of the bottom area, the side slopes (4H:1V), and the total facility depth (e.g., ponding and freeboard depth).\n• The drainage area contributing runoff to an individual bioretention facility shall be no larger than 5,000 square feet of impervious surface.2\n• Bottom area shall be flat (0 percent slope).\n• Side slopes within the ponded area shall be no steeper than 4H (horizontal):1V (vertical).\n• Imported bioretention soil per City of Seattle specifications shall be used (design infiltration rate of 3 inches per hour and 40 percent porosity). \nSee: http://www.seattle.gov/util/greeninfrastructure\n• Because imported bioretention soil is used, the design infiltration rate of the underlying native soil does not require a correction factor (i.e., the design, or “long-term” infiltration rate is the same as the “initial” infiltration rate). \n• Bioretention soil depth shall be a minimum of 12 inches for flow control, and minimum of 18 inches for treatment. \n• No underdrain or impermeable layer shall be used if designed for flow control.\n• Minimum ponding depth shall be as specified (2, 6 or 12 inches)."]
["Permeable Pavement Facility (may receive run-on from area up to 200% size \nof the facility)","• The average subsurface ponding depth within the aggregate storage reservoir shall be sized using the sizing tool.\n• For areas where the subgrade has a slope of 2 percent or more, the average subsurface ponding depth shall be controlled to achieve the minimum ponding depth. Ponding must be accommodated using design features such as terracing berms (e.g., check dams).\n• For areas where the subgrade has a slope of less than 2 percent, at least one low permeability check dam should be installed at the downslope end to contain water in the facility.\n• In addition, to the ponding depth requirements above, the depth of aggregate below the wearing course shall be at least:\n     a) 3 inches for permeable pavement installations that are not subject to vehicular traffic or other significant loads (e.g., sidewalks, pathways, patios). \n     b) 6 inches for permeable pavement installations that are subject to vehicular traffic or other significant loads.\n     Depths may need to be greater depending upon anticipated loading and all roadway design must be prepared by a professional engineer. \n• The infiltration rate used to determine the sizing equation shall be the design, or “long-term”, rate and must be calculated using correction factors (safety factors) per the Pierce County Manual. \n• The area contributing runoff to the permeable pavement facility shall not be greater than 200 percent of the facility area. \n• If a design includes directing run-on from other areas to the permeable pavement facility from other areas, careful consideration must be given to ensure that sediment is not introduced to the pavement surface or subgrade, and that the additional flows do not exceed the long-term infiltration capability of the pavement surface or subgrade.\n• Aggregate shall have a minimum void space of 20 percent.\n• Slope of the subgrade underlying the permeable pavement surface shall be less than 5 percent.\n• No underdrain or impermeable layer shall be used."]
["Category 3: Impervious Surface Reduction Methods"]
["Permeable Pavement Surface (may not receive run-on)","• The depth of aggregate below the wearing course shall be the greater of the depth reported by the sizing tool or the minimum aggregate required for the design loading:\n     a) 3 inches for permeable pavement installations that are not subject to vehicular traffic or other significant loads (e.g., sidewalks, pathways, patios). \n     b) 6 inches for permeable pavement installations that are subject to vehicular traffic or other significant loads.\n     Depths may need to be greater depending upon anticipated loading and all roadway design must be prepared by a professional engineer. \n• The infiltration rate used to determine the sizing equation shall be the design, or “long-term”, rate and must be calculated using correction factors (safety factors) per the Pierce County Manual.\n• For subgrade slopes greater than 2 percent the flow control standard is not achieved and the mitigated area shall be calculated using the flow control credit.\n• The pavement surface shall not receive runoff from other areas.\n• Aggregate shall have a minimum void space of 20 percent.\n• Slope of the subgrade underlying the permeable pavement surface shall be less than 5 percent.\n• No underdrain or impermeable layer shall be used."]
["Vegetated Roof (at least 4- inches Growth Media)","• Growth media depth shall be at least 4 inches deep.\n• Establishing additional design requirements for vegetated roofs was outside of the scope of this study. "]
["Category 4: Non Infiltrating Facilities"]
[]
["1  To use the sizing tool, the BMPs must be designed per the design requirements listed in this table. Additional requirements (including infiltration rate testing methods, infiltration rate correction factors, setbacks, and vertical separation from the bottom of the facility to the underlying water table) are presented in the Pierce County Stormwater Management and Site Development Manual (Pierce County 2008) and the Washington State Department of Ecology (Ecology) Stormwater Management Manual for Western Washington (Ecology 2005).  Supplemental design resources for LID BMPs (e.g., recommended construction specifications) are available in the City of Seattle Stormwater Flow Control and Water Quality Treatment Technical Requirements Manual (Seattle 2009). "]
["2 Contributing drainage area limitations are applicable to individual bioretention facilities sized using the tool.  The infiltration rate correction factor applied to City of Seattle standard bioretention soil mix (i.e., factor of 2) is based on contributing areas that do not exceed these limits (see Ecology Manual Volume III, Appendix C).  For larger contributing areas, the designer may split the area into multiple drainages (less than 5,000 square feet) routed to separate facilities or size a single facility with  an approved continuous hydrologic model using a lower design infiltration rate (i.e., calculated using a higher correction factor).  "]