{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Preface","STU Selection Tool"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Preface","index":0,"n_rows":92,"n_cols":3,"rows_kept":92,"cut":false,"hidden":false,"merged":[[80,0,86,9],[88,2,88,7],[89,2,89,7],[90,2,90,7],[91,2,94,7],[69,2,69,7],[70,2,70,7],[71,2,71,7],[72,2,72,7],[73,2,76,7],[68,2,68,7],[4,0,31,9],[53,0,63,9],[65,2,65,7],[66,2,66,7],[67,2,67,7]]}
["STU SELECTION TOOL"]
[]
["General Information\n"]
[]
["This spreadsheet provides a tool to help designers select STUs for specific sites within the project area and is intended to be used as a guide to designers to improve consistency in STU selection as well as to document compliance with Step 4.3 and 4.4 of the MEP process.   A range of site conditions are presented in the spreadsheet in order to identify the STUs that have the best potential to meet treatment goals for that site.\n\nBoth Tier 1 and Tier 2 STUs as described in the Linear Stormwater Manual are included. Some of these Tier 1 STUs can be modified with a liner to overcome some site challenges to be used as a Tier 2 STU and thereby may not be practicable as a Tier 1 STU but would be available as a Tier 2 STU.  \n \nSome important designer notes about this STU selection tool:\n \n1) Always consider site specific constraints for each STU as described in the linear manual in addition to using professional judgment.  This tool is only provided as a guide and to provide documentation of the decision-making process.\n2) Land acquisition for siting of an STU shall be practicable if the project requires land acquisition for other purposes.\n3) Several STUs may be practicable with a liner to overcome site challenges such as high groundwater.  Incorporation of a liner in a STU may only be used when Tier 2 practices are required.\n \nThis tool must be completed for each potential STU site in order to meet the treatment goals for the project (Steps 4.3 and 4.4. of the MEP process if required).  Once treatment goals are met, no additional sites need to be considered. It is the designer’s responsibility to consider the most cost-effective sites first.  Additional space is provided in the spreadsheet to explain why a site may not be practicable.\n \n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["STU SELECTION TOOL"]
[]
["Tier 1 Practices\n"]
[]
["Tier 1 Practices are the practices that can be designed to provide water quality treatment and infiltrate the water quality volume (WQV), and include practices such as infiltration basins, unlined bioretention cells, and other practices that treat and infiltrate stormwater runoff.  These practices, when properly constructed and maintained, are expected to achieve the highest pollutant removal and runoff reduction of all the practices identified in the 2017 VSMM; generally exceeding 80% TP and 98% TSS (USEPA BMP Performance Curves, National Stormwater Database, International Stormwater Database). In addition, Tv credit towards the Hydrologic Condition Method (HCM) under the Channel Protection Standard  is equivalent to the volume of stormwater infiltrated, which can exceed the WQv when designed to accommodate larger volumes.  Infiltration feasibility and soil testing requirements for practices designed for infiltration are specified in Section 4.3.3.  The STU Selection Matrix, included in this workbook, provides the framework for evaluating the feasibility of Tier 1 Practices."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Tier 1 Practices1"]
[null,null,"Infiltration Basins, Trenches, Chambers"]
[null,null,"Dry Wells"]
[null,null,"Bioretention (designed for infiltration)"]
[null,null,"Dry Swales (designed for infiltration)"]
[null,null,"Filtering Systems (designed for infiltration)"]
[null,null,"Simple Disconnection"]
[null,null,"Disconnection to Filter Strip or Vegetated Buffer"]
[null,null,"1 These STUs generally exceed 80% TP removal and generally achieve 98% TSS removal, and the Tv credit equivalent to volume infiltrated. (USEPA BMP Performance Curves, National Stormwater Database, International Stormwater Database)"]
[]
[]
[]
[]
["Tier 2 Practices\n"]
[]
["When infiltration is infeasible, a designer shall evaluate use of Tier 2 Practices to meet the WQTS, as listed in the table below.  Tier 2 Practices include high performance practices, such as gravel wetlands and practices such as bioretention cells that may provide a sump with stormwater storage at the base of the practice.  These practices may in some cases be lined and underdrained due to high seasonal high groundwater table, contributing hotspot land use, or other design limitations.  These practices, when properly constructed and maintained, are expected to achieve a high pollutant removal rate ranging from 60%-80% TP and 80-97% TSS (USEPA BMP Performance Curves, National Stormwater Database, International Stormwater Database.\n"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Tier 2 Practices2"]
[null,null,"Bioretention (not designed for infiltration)"]
[null,null,"Gravel Wetlands"]
[null,null,"2 These STUs generally meet 60-80% TP removal and generally achieve 80-97% TSS removal, and the Tv credit equivalent to volume stored below the sump/underdrain. (USEPA BMP Performance Curves, National Stormwater Database, International Stormwater Database)"]

{"sheet":"STU Selection Tool","index":1,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,8,0,9],[2,11,3,11],[0,11,1,11],[0,14,1,14],[3,8,3,9],[2,8,2,9],[1,8,1,9],[2,12,2,13],[2,14,2,15],[0,12,1,13],[0,15,1,15],[5,0,5,2],[18,0,18,1],[16,0,16,1],[17,0,17,1],[15,0,15,1],[11,0,11,1],[10,0,10,1],[21,0,21,15],[22,0,28,15],[8,4,8,15],[7,0,7,2],[6,0,6,2],[20,0,20,1],[9,0,9,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[19,0,19,1],[8,0,8,1]]}
["STU Selection & Practicability Assessment",null,null,null,null,null,null,"STU ID ","Enter here. ",null,null,"Project Name","Enter here. ",null,"Project ID","Enter here. "]
[null,null,null,null,null,null,null,"Selected STU Type"]
[null,null,null,null,null,null,null,"Waterbody ID (WBID)","Enter here. ",null,null,"Project Location","Enter here. ",null,"Enter here. "]
[null,null,null,null,null,null,null,"Is WBID impaired? ",null,null,null,null,"Street & Highway Route Number",null,"Municipality"]
["Table Formatted to Print at 11 x 17 Landscape"]
[null,null,null,null,"Infiltration Basin & Trench \n(Tier 1 STU)","Bioretention Basin, Curb Inlet Planter & Swale (Tier 1 STU)","Tree Filter & Tree  Filter with Storage  \n(Tier 1 STU)","Filter Strip \n(Tier 1 STU)","Sand Filter \n(Tier 1 STU)","Porous Pavement \nwith Storage \n(Tier 1 STU)","Underground Infiltration, Infiltration Gutter & Leaching Basin (Tier 2 STU)","Bioretention Parking Lane Adjacent & Curb Extension Planter\n(Tier 2 STU)","Gravel Wetland (WVTS) \n(Tier 2 STU)","Porous Pavement \n(Tier 2 STU)","Intentionally Left Blank","Intentionally Left Blank"]
["If the project is within a non-impaired WBID, use the Tier 1 STUs designated as \"Available\" in this row",null,null,null,{"$f":"IF(COUNTIF(E$10:E$11,\"Available*\")+COUNTIF(E$13:E$21,\"Available*\")+COUNTIF(E$12,\"Available\")=12,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF(COUNTIF(F$10:F$11,\"Available*\")+COUNTIF(F$12,\"Available\")+COUNTIF(F$14:F$16,\"Available*\")+COUNTIF(F$18,\"Available*\")+COUNTIF(F$19,\"Available\")+COUNTIF(F$20:F$21,\"Available*\")+IF($D13=1,0,1)+IF($D17=1,0,1)=12,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF(COUNTIF(G$10:G$11,\"Available*\")+COUNTIF(G$12,\"Available\")+COUNTIF(G$14:G$16,\"Available*\")+COUNTIF(G$18,\"Available*\")+COUNTIF(G$19,\"Available\")+COUNTIF(G$20:G$21,\"Available*\")++IF($D13=1,0,1)+IF($D17=1,0,1)=12,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF(COUNTIF(H$10:H$17,\"Available*\")+COUNTIF(H$18:H$21,\"Available*\")=12,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF(COUNTIF(I$10:I$11,\"Available*\")+COUNTIF(I$12,\"Available\")+COUNTIF(I$14:I$16,\"Available*\")+COUNTIF(I$18,\"Available*\")+COUNTIF(I$19,\"Available\")+COUNTIF(I$20:I$21,\"Available*\")++IF($D13=1,0,1)+IF($D17=1,0,1)=12,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF(COUNTIF(J$10:J$11,\"Available*\")+COUNTIF(J$12,\"Available\")+COUNTIF(J$13:J$21,\"Available*\")=12,\"Available\",\"Not Practicable\")","v":"Available"},"Not Practicable","Not Practicable","Not Practicable","Not Practicable"]
["If the project is in an impaired WBID use the Tier 1 & Tier 2 STUs designated as \"Available\" in this row",null,null,null,{"$f":"IF(COUNTIF(E$10:E$13,\"Available*\")+COUNTIF(E$15:E$21,\"Available*\")+IF($D14=1,1,1)=12,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF(COUNTIF(F$10:F$12,\"Available*\")+COUNTIF(F$14:F$16,\"Available*\")+COUNTIF(F$18:F$21,\"Available*\")+IF($D13=1,1,1)+IF($D17=1,1,1)=12,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF(COUNTIF(G$10:G$12,\"Available*\")+COUNTIF(G$14:G$16,\"Available*\")+COUNTIF(G$18:G$21,\"Available*\")+IF($D13=1,1,1)+IF($D17=1,1,1)=12,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF(COUNTIF(H$10:H$16,\"Available*\")+COUNTIF(H$18:H$21,\"Available*\")+IF($D17=1,1,1)=12,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF(COUNTIF(I$10:I$12,\"Available*\")+COUNTIF(I$14:I$16,\"Available*\")+COUNTIF(I$18:I$21,\"Available*\")+IF($D13=1,1,1)+IF($D17=1,1,1)=12,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF(COUNTIF(J$10:J$21,\"Available*\")=12,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF(COUNTIF(K$9:K$21,\"Available*\")=12,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF(COUNTIF(L$9:L$21,\"Available*\")=12,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF(COUNTIF(M$9:M$21,\"Available*\")=12,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF(COUNTIF(N$9:N$21,\"Available*\")=12,\"Available\",\"Not Practicable\")","v":"Available"}]
["Practicability Constraints",null,"Response",null,"Availability and Conditions"]
["Tight Soils - Do underlying soils have an infiltration rate < 0.5 inch/hour, or are they classified by the NRCS Soil Survey as Hydrologic Soil Group D?",null,null,2,{"$f":"IF($D10=2,\"Available\", \"Not Practicable\")","v":"Available"},{"$f":"IF($D10=2,\"Available\",\"Available\" & CHAR(10)&\"with Underdrain\")","v":"Available"},{"$f":"IF($D10=2,\"Available\",\"Available\" & CHAR(10)&\"with Underdrain\")","v":"Available"},{"$f":"IF($D10=2,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF($D10=2,\"Available\",\"Available\" & CHAR(10)&\"with Underdrain\")","v":"Available"},{"$f":"IF($D10=2,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF($D10=2,\"Available\", \"Not Practicable\")","v":"Available"},{"$f":"IF($D10=2,\"Available\",\"Available\" & CHAR(10)&\"with Underdrain\")","v":"Available"},{"$f":"IF($D10=2,\"Available\",\"Available\")","v":"Available"},{"$f":"IF($D10=2,\"Available\",\"Available\"&CHAR(10)&\"with Underdrain &\"&CHAR(10)&\"18-in. Filter Course\")","v":"Available"}]
["Highly Permeable Soils - Do underlying soils have an infiltration rate > 8.3 inches/hour?",null,null,2,{"$f":"IF($D11=2,\"Available\", \"Not Practicable\")","v":"Available"},{"$f":"IF($D11=2,\"Available\",\"Available\")","v":"Available"},{"$f":"IF($D11=2,\"Available\",\"Available\")","v":"Available"},{"$f":"IF($D11=2,\"Available\",\"Available\")","v":"Available"},{"$f":"IF($D11=2,\"Available\",\"Available\")","v":"Available"},"Available",{"$f":"IF($D11=2,\"Available\", \"Not Practicable\")","v":"Available"},{"$f":"IF($D11=2,\"Available\",\"Available\")","v":"Available"},{"$f":"IF($D11=2,\"Available\",\"Available\")","v":"Available"},{"$f":"IF($D11=2,\"Available\",\"Available with\"&CHAR(10)&\"18-in. Filter\"&CHAR(10)&\"Course\")","v":"Available"}]
["Permitting - Does the STU require a permit not already required for the project?  ",null,null,2,{"$f":"IF($D12=2,\"Available\", \"Available as Tier 2\")","v":"Available"},{"$f":"IF($D12=2,\"Available\", \"Available as Tier 2\")","v":"Available"},{"$f":"IF($D12=2,\"Available\", \"Available as Tier 2\")","v":"Available"},{"$f":"IF($D12=2,\"Available\",\"Available\" & CHAR(10)&\"Only If No Site Improvements Req'd\"& CHAR(10)&\"  or as Tier 2\")","v":"Available"},{"$f":"IF($D12=2,\"Available\", \"Available as Tier 2\")","v":"Available"},{"$f":"IF($D12=2,\"Available\", \"Available as Tier 2\")","v":"Available"},{"$f":"IF($D12=2,\"Available\",\"Available\")","v":"Available"},{"$f":"IF($D12=2,\"Available\",\"Available\")","v":"Available"},"Available","Available"]
["LUHPPL - Will run-on include discharge from a LUHPPL?",null,null,2,{"$f":"IF($D13=2,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF($D13=2,\"Available\",\"Available\" & CHAR(10)&\"as Tier 2 with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D13=2,\"Available\",\"Available\" & CHAR(10)&\"as Tier 2 with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D13=2,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF($D13=2,\"Available\",\"Available\" & CHAR(10)&\"as Tier 2 with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D13=2,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF($D13=2,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF($D13=2,\"Available\",\"Available\" & CHAR(10)&\"as Tier 2 with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D13=2,\"Available\",\"Available\")","v":"Available"},{"$f":"IF($D13=2,\"Available\",\"Available\" & CHAR(10)&\"as Tier 2 with Liner & Underdrain\")","v":"Available"}]
["Contamination - Is the STU site regulated by RIDEM’s Office of Waste Management?",null,null,2,{"$f":"IF($D14=2,\"Available\",\"Available\" & CHAR(10)&\"with RIDEM OWM Approval\")","v":"Available"},{"$f":"IF($D14=2,\"Available\",\"Available with RIDEM OWM Approval or as Tier 2 with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D14=2,\"Available\",\"Available with RIDEM OWM Approval or as Tier 2 with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D14=2,\"Available\",\"Available\" & CHAR(10)&\"with RIDEM OWM Approval\")","v":"Available"},{"$f":"IF($D14=2,\"Available\",\"Available with RIDEM OWM Approval or as Tier 2 with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D14=2,\"Available\",\"Available with RIDEM OWM Approval or as Tier 2 with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D14=2,\"Available\",\"Available\" & CHAR(10)&\"with RIDEM OWM Approval\")","v":"Available"},{"$f":"IF($D14=2,\"Available\",\"Available with RIDEM OWM Approval or as Tier 2 with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D14=2,\"Available\",\"Available\")","v":"Available"},{"$f":"IF($D14=2,\"Available\",\"Available with RIDEM OWM Approval or as Tier 2 with Liner & Underdrain\")","v":"Available"}]
["Limited Access - Does the site fail to meet the maintenance access requirements specified in the Linear Manual?",null,null,2,{"$f":"IF($D15=2,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF($D15=2,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF($D15=2,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF($D15=2,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF($D15=2,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF($D15=1,\"Available\",\"Available\")","v":"Available"},{"$f":"IF($D15=2,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF($D15=2,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF($D15=2,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF($D15=2,\"Available\",\"Available\")","v":"Available"}]
["Steep Slopes - Are slopes at the STU site greater than 15%?",null,null,2,{"$f":"IF($D16=2,\"Available\",\"Not Practicable\")","v":"Available"},"Available","Available","Available","Available","Available","Available","Available","Available","Available"]
["High Water Table - Does the STU site result in inadequate vertical separation distances from the top of the filter to SHGT and bedrock?",null,null,2,{"$f":"IF($D17=2,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF($D17=2,\"Available\",\"Available\" & CHAR(10)&\"as Tier 2 with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D17=2,\"Available\",\"Available\" & CHAR(10)&\"as Tier 2 with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D17=2,\"Available\",\"Available\" & CHAR(10)&\"with at least 18 inches of Separation\")","v":"Available"},{"$f":"IF($D17=2,\"Available\",\"Available\" & CHAR(10)&\"as Tier 2 with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D17=2,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF($D17=2,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF($D17=2,\"Available\",\"Available\" & CHAR(10)&\"as Tier 2 with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D17=2,\"Available\",\"Available\" & CHAR(10)&\"as Tier 2 with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D17=2,\"Available\",\"Available\" & CHAR(10)&\"as Tier 2 with Liner & Underdrain\")","v":"Available"}]
["Residential Impacts - Is the STU site within a homeowner's maintained lawn?",null,null,2,{"$f":"IF($D18=2,\"Available\",\"Not Practicable\")","v":"Available"},"Available",{"$f":"IF($D18=2,\"Available\",\"Available\")","v":"Available"},{"$f":"IF($D18=2,\"Available\",\"Available\")","v":"Available"},{"$f":"IF($D18=2,\"Available\",\"Not Practicable\")","v":"Available"},"Available",{"$f":"IF($D18=2,\"Available\",\"Available\")","v":"Available"},"Available",{"$f":"IF($D18=2,\"Available\",\"Not Practicable\")","v":"Available"},{"$f":"IF($D18=2,\"Available\",\"NotPracticable\")","v":"Available"}]
["Inadequate Setbacks - Is the STU site within the RI Infiltration STU Setbacks (Table 1.2.2) ?",null,null,2,"Available",{"$f":"IF($D19=2,\"Available\",\"Available\" & CHAR(10)&\"as Tier 2 Practice with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D19=2,\"Available\",\"Available\" & CHAR(10)&\"as Tier 2 Practice with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D19=2,\"Available\",\"Available\")","v":"Available"},{"$f":"IF($D19=2,\"Available\",\"Available\" & CHAR(10)&\"as Tier 2 Practice with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D19=2,\"Available\",\"Not Practicable\")","v":"Available"},"Available",{"$f":"IF($D19=2,\"Available\",\"Available\" & CHAR(10)&\"as Tier 2 Practice with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D19=2,\"Available\",\"Available\")","v":"Available"},{"$f":"IF($D19=2,\"Available\",\"Available\" & CHAR(10)&\"as Tier 2 with Liner & Underdrain\")","v":"Available"}]
["New Fill - Does the STU site comprise new or recently placed fill material? ",null,null,2,"Available",{"$f":"IF($D20=2,\"Available\",\"Available\" & CHAR(10)&\"as Tier 2 with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D20=2,\"Available\",\"Available\" & CHAR(10)&\"as Tier 2 with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D20=2,\"Available\",\"Available\")","v":"Available"},{"$f":"IF($D20=2,\"Available\",\"Available\" & CHAR(10)&\"as Tier 2 with Liner & Underdrain\")","v":"Available"},"Available","Available",{"$f":"IF($D20=2,\"Available\",\"Available\" & CHAR(10)&\"as Tier 2 with Liner & Underdrain\")","v":"Available"},{"$f":"IF($D20=2,\"Available\",\"Available\")","v":"Available"},{"$f":"IF($D20=2,\"Available\",\"Available\"&CHAR(10)&\"as Tier 2 with Liner & Underdrain\")","v":"Available"}]
["Tree Clearing - Does the STU and its maintenance path require clearing > 0.25-acre of dense mature tree growth? ",null,null,2,"Available","Available","Available","Available","Available","Available","Available","Available","Available","Available"]
["Other feasibility constraints for remaining Tier 1 and Tier 2 practices (if the use of a STU identified by the STU Selection Tool is still not practicable, a designer may submit additional site specific detailed feasibility justification)"]
["Enter here. "]