{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Criteria Key","Scoring Key","1-Matrix-fill","2-Matrix Sort","Print Table"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"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":"Criteria Key","index":0,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[14,1,15,1],[9,1,13,1],[7,1,8,1],[17,1,22,1]]}
[null,"Indian Brook Flow Restoration Plan(FRP) Project"]
[null,"BMP Ranking Criteria Key"]
[null,"January 26th, 2015"]
[]
[null,"Table A-5-1 BMP Ranking Criteria Key"]
[]
["#","Category","ID","Criteria","Technical Description ","Description "]
[6,"Cost/Operations","A","Project Cost ","The project costs were grouped into categories from >$50,000 to >$1,000,000 based on the range of projects proposed. Cost estimates were developed using the latest unit costs from VTrans as well as local experience. More expensive projects are ranked lower.","Project Costs include additional engineering, permitting, and construction. Transportation and utility conflicts, as well as overall constructability is also reflected in the cost."]
[9,null,"B","Ease of O/M","This criteria is based on experience with the general ease of operation and maintenance for specific categories of practices.","This criteria is based on general knowledge of the ease of operation and maintenance for specific categories of practices. Most stormwater facilities require some amount of annual maintenance, with some BMP's requiring significantly more operational resources than others. "]
[2,"Project Design Metrics","C","Impervious Acres Managed (ac)","Natural groupings within the range of impervious managed for the proposed projects were identified. More impervious managed receives a higher score.","The more impervious managed by a project, the higher the potential pollutant reduction. Additionally, the goal of the FRP is to manage existing impervious surfaces."]
[3,null,"D","Channel Protection Volume (CPv) Mitigated, (i.e.. 1-year Storm)","Groupings within the range of CPv volume storage were identified. The largest grouping receives the highest score.  The CPv was estimated in HydroCAD, using local rainfall data. ","The Channel Protection Volume (CPv) is the volume of stormwater runoff generated from the 1-year design storm (1.96\" in Essex). A BMP which provides CPv storage was determined to reduce the High-flow (Q0.3%), which is the flow rate exceeded 0.3% of the time (output from the State's BMPDSS model). Mitigating the CPv reduces channel erosion and excessive pollutant loading from streams. "]
[4,null,"E","Volume Infiltrated (ac-ft)","Natural groupings within the range of volumes infiltrated for the BMPs were identified to which relative points were be assigned. The largest volume infiltrated was assigned the highest score. Volumes were calculated in HydroCAD.","The Volume Infiltrated indicates the amount of stormwater runoff that is infiltrated into the groundwater, and provides baseflow for the stream. The TMDL flow targets include a low-flow target, which is addressed by an infiltration-based BMP."]
[5,null,"F","Water Quality (WQ) Volume Mitigated","The WQ volume mitigated is defined as the runoff volume generated from the 0.9\" rainfall  that is stored in the BMP's permanent pool. Three categories were identified for the WQ volume 1) 100% WQ volume control which is the best-case standard for the EFA procedure. 2)  >= 20% WQ volume  as required for redevelopment projects, and 3) less than 20% WQ volume.","The WQ volume mitigated is an indicator of the reduction in pollutant runoff from 90% of annual storm events, approximated to be an 80% removal of the Total Suspended Solids (TSS) and 40% total phosphorus (TP) load."]
[7,null,"G","Primary or Secondary  BMP","Primary BMP is the main control practice, whereas a secondary BMP drains to a primary BMP. Primary BMPs have a higher weighting.","A primary BMP is the main control practice, like a large end-of-pipe detention pond. A secondary BMP is located within the drainage area of a primary BMP, providing additional flow control and treatment. Secondary BMPs are weighted less than primary BMPs in terms of reducing stormwater runoff. "]
[12,"Project Implementation","H","Permitabilty ","Permitabilty is simplified into two categories to reflect the common scenarios in permitting, as 1) minimal permitting 2) Complex permitting issues. ","Permitabilty is a measure of the expected level of effort to permit the project, based on knowledge that each type of permit takes varying amounts of time. Some common permits include Stormwater Construction, Local Zoning, Act 250 amendments, VTRANS ROW, etc. "]
[8,null,"I","Land Availability ","Public land is preferred, followed by regulated private land, and private land where the owners are known to be open to participate. Private land, in which participation of the owner is unknown is lower priority.","Land availability is critical for BMPs requiring open space for detention and access for the Municipality involved. Properties owned by the Municipality (Public) are ranked the highest, followed by privately owned land with an expired permit, which provides leverage to retrofit the BMP. The next priority is private land with a land owner who is known to be cooperative. If a land owner is known to not be cooperative, points were subtracted from the ranking."]
["#","Category","ID","Criteria","Technical Description ","Description "]
[14,"Other Project Benefits/Constraints ","J","Flood Mitigation","Flood mitigation is categorized by the scale of the impact.  A neighborhood flooding issue is weighed more heavily than a localized drainage issue. ","Flood mitigation is categorized by the scale of the impact. A neighborhood flooding issue is weighed more heavily than a localized drainage issue. "]
[1,null,"K","TMDL Flow Target Addressed (Q03, Q95)","More weight is on BMPs that address both TMDL targets- the high-flow (Q0.3%) and low-flow targets (Q95%). The high-flow target is addressed by detention BMPs which provide storage of the CP volume (1-year storm). The low-flow target is addressed by BMPs which infiltrate the 1-year storm volume. ","The goal of the FRP is to implement projects which address the TMDL flow targets. The high-flow target is measured as a reduction in the stream flow rate exceeded 0.3% of the time, while the low-flow target is an increase in the stream flow rate exceeded 95% of the time (baseflow). Projects which address both targets through storage or infiltration  of the 1-year design storm are weighted the highest, followed by projects which address just the high-flow. Projects which do not address the full 1-year storm volume are weighted the lowest. "]
[null,null,"L","Lake Champlain Phosphorus TMDL","Yes or no whether the proposed practice will provide benefit toward the Lake Champlain Phosphorus TMDL. This will be determined once the TMDL compliance metrics are released.","The Lake Champlain Phosphorus TMDL has been developed in the effort to reduce nutrient loading and consequential toxic algal blooms in Lake Champlain. The TMDL will require stormwater BMPs to meet a certain level of Total Phosphorus reduction. Each BMP will be evaluated against the TMDL compliance metrics, and scored yes or no if the project meets the TMDL standards. "]
[null,null,"M","Other Project Benefits/Constraints","This criteria is to account for indirect project benefits  (+) like infrastructure improvements (e.g. aging infrastructure replacement, wetlands enhancement, and if it addresses an expired permit). This criteria also accounts for specific project constraints (-) due to potential erodible soils and bank destabilization. ","This criteria is to account for indirect project benefits like infrastructure improvements, community benefits, habitat creation, etc., as well as additional project constraints like potential erodible soils causing bank destabilization concerns."]
[null,null,"N","Annual Total Suspended Solids (TSS) Yield Mitigated (lbs.) *WinSLAMM Model result","The annual TSS Yield mitigated by the proposed BMP was estimated with the Source Loading and Management Model (WinSLAMM), a continuous simulation urban runoff and water quality model. This criteria provides a metric for the WQ benefit of the project. ","The annual TSS Yield mitigated by the proposed BMP was estimated with the Source Loading and Management Model (WinSLAMM), a continuous simulation urban runoff and water quality model. This criteria provides a metric for the WQ benefit of the project. "]
[null,null,"O","Annual Total Phosphorus (TP) Yield Mitigated (lbs.) *WinSLAMM Model result","The annual TP Yield mitigated by the proposed BMP was estimated with the Source Loading and Management Model (WinSLAMM), a continuous simulation urban runoff and water quality model. This criteria provides a metric for the WQ benefit of the project. ","The annual TP Yield mitigated by the proposed BMP was estimated with the Source Loading and Management Model (WinSLAMM), a continuous simulation urban runoff and water quality model. This criteria provides a metric for the WQ benefit of the project. "]

{"sheet":"Scoring Key","index":1,"n_rows":74,"n_cols":7,"rows_kept":74,"cut":false,"hidden":false,"merged":[[4,1,4,3],[35,1,42,1],[14,1,34,1],[26,3,29,4],[30,3,32,4],[35,3,36,4],[37,3,42,4],[33,3,34,4],[7,3,10,4],[6,3,6,4],[14,0,20,0],[14,3,20,4],[21,3,25,4],[7,1,13,1],[11,3,13,4],[43,1,72,1],[61,3,66,4],[67,3,72,4],[73,2,74,6],[75,2,75,6],[43,3,46,4],[47,3,49,4],[50,3,51,4],[52,3,60,4]]}
[null,"Indian Brook Flow Restoration Plan(FRP) Project"]
[null,"BMP Ranking Score Key"]
[null,"January 26th, 2015"]
[]
[null,"Table A-5-2: Ranking Score Key"]
[]
["#","Category","ID","Criteria",null,"Quality","Score"]
[7,"Cost/Operations","A","Relative Project Cost",null,"Under $50,000",4]
[null,null,null,null,null,"$50,000-100,000",3]
[null,null,null,null,null,"$100,000-1,000,000",2]
[null,null,null,null,null,"Over $1,000,000",1]
[10,null,"B","Ease of O/M",null,"Underground Storage/ Swirl Separator",2]
[null,null,null,null,null,"Bioretention/Rain Gardens/Tree Box Filters",1]
[null,null,null,null,null,"Ponds/Constructed Wetlands",0]
[2,"Project Design Metrics","C","Impervious Acres Managed (ac)",null,"> 10  acres",7]
[null,null,null,null,null,"5-10 acres",6]
[null,null,null,null,null,"4-5 acres",5]
[null,null,null,null,null,"2-4 acres",4]
[null,null,null,null,null,"1-2 acres",3]
[null,null,null,null,null,"0.5-1 acres",2]
[null,null,null,null,null,"< 0.5 acre",1]
[3,null,"D","Channel Protection Volume (CPv) Mitigated, (ie. 1-year Storm)",null,"0.6-1.0 ac-ft",5]
[null,null,null,null,null,"0.4-0.6 ac-ft",4]
[null,null,null,null,null,"0.2-0.4 ac-ft",3]
[null,null,null,null,null,"0.05-0.2 ac-ft",2]
[null,null,null,null,null,">0-0.05 ac-ft",1]
[4,null,"E","Volume Infiltrated (ac-ft)",null,">1 ac-ft",4]
[null,null,null,null,null,"0.5-1 ac-ft",3]
[null,null,null,null,null,"0.1- 0.5 ac-ft",2]
[null,null,null,null,null,"no infiltration",0]
[5,null,"F","Water Quality (WQ) Volume Control",null,">= 100% WQ volume controlled in permanent pool",2]
[null,null,null,null,null,">= 20 % WQ volume controlled in permanent pool",1]
[null,null,null,null,null,"Under 20% WQ volume controlled in permanent pool",0]
[8,null,"G","Primary or Secondary BMP",null,"Primary",2]
[null,null,null,null,null,"Secondary (Routed to Primary Control)",0]
[12,"Project Implementation","H","Permitabilty",null,"Minimal Issues/Concerns or no permits",2]
[null,null,null,null,null,"Complex issues/Potential permit denial",0]
[null,null,"I","Land Availability ",null,"MS4 owned",4]
[null,null,null,null,null,"Public",3]
[null,null,null,null,null,"Non MS4 owned regulated (expired permit)",3]
[null,null,null,null,null,"Non MS4 owned/Participatory Owner",2]
[null,null,null,null,null,"Unknown",0]
[null,null,null,null,null,"Not MS4 owned/Non participatory owner",-2]
[13,"Other Project Benefits/Constraints ","J","Flood Mitigation (Is existing flooding issue mitigated by project?)",null,"Neighborhood Wide Flooding Issue",3]
[null,null,null,null,null,"Infrastructure damage (e.g. Wet Basement)/Single Property",2]
[null,null,null,null,null,"Nuisance Issue (ie. ponding, puddles, etc).",1]
[null,null,null,null,null,"None",0]
[1,null,"K","TMDL Flow Target Addressed (Q03, Q95)",null,"High  and Low Flow Targets",3]
[null,null,null,null,null,"High Flow Target",2]
[null,null,null,null,null,"No target addressed in BMPDSS (just WQ treatment)",1]
[6,null,"L","Lake Champlain Phosphorus TMDL*",null,"Addressed TMDL",1]
[null,null,null,null,null,"Does not address TMDL",0]
[15,null,"M","Other Project Benefits (+) / Constraints (-)",null,"Infrastructure Improvement (e.g. Culvert Replacement) (+)",1]
[null,null,null,null,null,"Educational/Functional Benefit (+)",1]
[null,null,null,null,null,"Recreational Benefit (+)",1]
[null,null,null,null,null,"Expired permit on site (+)",1]
[null,null,null,null,null,"Outfall Erosion Control (+)",1]
[null,null,null,null,null,"Potential Erodible soils/Bank Destabilization issues (-)",-1]
[null,null,null,null,null,"Access Issues (-)",-1]
[null,null,null,null,null,"Uncertainty in groundwater table/feasibility for infiltration (-)",-3]
[null,null,null,null,null,"Loss of Habitat (-)",-1]
[null,null,"N","Annual Total Suspended Solids (TSS) Yield Mitigated (lbs.) *WinSLAMM Model result",null,">2000",5]
[null,null,null,null,null,"1500-2000",4]
[null,null,null,null,null,"1000-1500",3]
[null,null,null,null,null,"500-1000",2]
[null,null,null,null,null,"<500",1]
[null,null,null,null,null,"<50",0]
[null,null,"O","Annual Total Phosphorus (TP) Yield Mitigated (lbs.) *WinSLAMM Model result",null,"<5",6]
[null,null,null,null,null,"4-5",5]
[null,null,null,null,null,"3-4",4]
[null,null,null,null,null,"2-3",3]
[null,null,null,null,null,"1-2",2]
[null,null,null,null,null,"<1",1]
[null,null,"*Lake Champlain Phosphorus TMDL compliance metrics TBD. All projects which address > 20%of the WQ volume are considered meeting this standard."]

{"sheet":"1-Matrix-fill","index":2,"n_rows":40,"n_cols":38,"rows_kept":40,"cut":false,"hidden":false,"merged":[[24,1,34,2],[38,19,42,20],[38,6,42,6],[33,13,33,14],[33,15,33,16],[5,37,7,37],[6,9,6,10],[6,11,6,12],[7,9,7,10],[7,11,7,12],[6,35,6,36],[7,35,7,36],[5,25,5,36],[6,31,6,32],[6,33,6,34],[7,33,7,34],[7,31,7,32],[33,26,33,27],[33,28,33,30],[6,4,6,5],[6,13,6,14],[6,29,6,30],[6,7,6,8],[6,17,6,18],[7,19,7,20],[6,25,6,26],[6,27,6,28],[7,25,7,26],[7,27,7,28],[7,29,7,30],[7,21,7,22],[33,7,33,8],[5,1,7,1],[5,2,7,2],[5,3,7,3],[6,15,6,16],[6,19,6,20],[7,7,7,8],[7,17,7,18],[5,19,5,24],[5,9,5,18],[5,4,5,8],[6,21,6,22],[6,23,6,24],[7,23,7,24],[7,4,7,5],[7,13,7,14],[7,15,7,16]]}
[null,"Indian Brook Flow Restoration Plan(FRP) Project"]
[null,"BMP Ranking Matrix"]
[]
[]
[]
[null,"Site ID","BMP Type","Retrofit Description","Cost/Operations",null,null,null,null,"Project Design Metrics",null,null,null,null,null,null,null,null,null,"Project Implementation",null,null,null,null,null,"Other Project Benefits/Constraints",null,null,null,null,null,null,null,null,null,null,null,"Total Score"]
[null,null,null,null,"A",null,"A-intermediate","B",null,"C",null,"D",null,"E",null,"F",null,"G",null,"H- intermediate*",null,"H",null,"I",null,"J",null,"K",null,"L",null,"M",null,"N",null,"O"]
["#",null,null,null,"Project Cost",null,"Cost/ Impervious Acre Managed","Ease of O/M",null,"Impervious Acres Managed (ac)",null,"Channel Protection Volume (CPv)",null,"Volume Infiltrated        (ac-ft)",null,"WQ Volume controlled (%)",null,"Primary or Secondary BMP",null,"Permit List",null,"Permitting Restrictions ",null,"Land Availability  where BMP is located ",null,"Flood Mitigation ",null,"TMDL Flow Target Addressed (Q03, Q95)",null,"Lake Champlain P TMDL addressed?",null,"Other Benefits/Constraints ",null,"Annual Total Suspended Solids (TSS) Yield Mitigated (lbs.)",null,"Annual Total Phosphorus (TP) Yield Mitigated (lbs.)"]
["#",null,null,null,"Value","Score","Value","Value","Score","Value","Score","Value","Score","Value","Score","Value","Score","Value","Score","Value","Score","Value","Score","Value","Score","Value","Score","Value","Score","Value","Score","Value","Score","Value","Score","Value","Score"]
[1,"Church LDS  North P2 (Option 5)","USC","Retrofit existing Detention Pond in front of LDS Church. Convert pond to underground detention chamber system. Route Essex Way and Inn at Essex runoff to retrofit.",1100000,1,null,"Underground Storage/ Swirl Separator/Infiltration Basin",2,12,7,1.02,5,null,null,">= 100% WQ volume ",2,"Primary",2,"No wetlands",null,"Minimal Issues/Concerns or no permits",2,"Non City owned regulated (expired permit)",3,null,null,"High",2,"Addressed TMDL",1,"Functional Benefit (1), Expired Permit on-site (1)",2,576,2,2.69,3,{"$f":"SUM(K10,M10,F10,O10,Q10,AI10,AK10,U10,AA10,AC10,AE10,AG10,I10,S10,W10,Y10)","v":34}]
[2,"Fairview Dr./Main St.","GW","Regrade existing detention area and add riser. Stabilize eroded outfall on North side of Fairfield Dr.",244400,2,null,"Ponds/Constructed Wetlands",0,3.94,5,0.45,4,null,null,">= 100% WQ volume ",2,"Primary",2,"No wetlands",null,"Minimal Issues/Concerns or no permits",2,"MS4 owned",4,null,null,"High",2,"Addressed TMDL",1,"Outfall Erosion Control (1), Expired Permit on-site (1)",2,{"$f":"3040-2153","v":887},2,{"$f":"13.18-9.972","v":3.2080000000000002},4,{"$f":"SUM(K11,M11,F11,O11,Q11,AI11,AK11,U11,AA11,AC11,AE11,AG11,I11,S11,W11,Y11)","v":32}]
[3,"Fairview Dr./Main St. with Add-On","GW","Regrade existing detention area and add riser. Route outfall on North side of Fairfield Dr. to retrofit.",290000,2,null,"Ponds/Constructed Wetlands",0,5.24,6,0.67,5,null,null,">= 100% WQ volume ",2,"Primary",2,"No wetlands",null,"Minimal Issues/Concerns or no permits",2,"MS4 owned",4,null,null,"High",2,"Addressed TMDL",1,"Infrastructure Improvement (1),Outfall Erosion Control (1), Expired Permit on-site (1)",3,1847,4,4.01,5,38]
[4,"Woodlands (Detention Pond 139)","UIB","Retrofit existing detention pond to an infiltration practice if determined feasible.",200400,2,null,"Underground Storage/ Swirl Separator",2,4.0409600000000001,5,0.36,3,null,null,">= 100% WQ volume ",2,"Primary",2,"No wetlands",null,"Minimal Issues/Concerns or no permits",2,"MS4 owned",4,null,null,"High",2,"Addressed TMDL",1,"Potential recreational path (1), Expired Permit on-site (1)",3,1502,4,5.79,6,38]
[5,"East Creek Condominiums","DB","Expand Existing Detention Pond and retrofit outlet structure for CPv control.",80000,3,null,"Ponds/Constructed Wetlands",0,14.400327000000001,6,0.31499999999999995,3,null,null,">= 100% WQ volume ",2,"Primary",2,"No wetlands",null,"Minimal Issues/Concerns or no permits",2,"Non MS4 owned regulated (expired permit)",3,null,null,"High",2,"Addressed TMDL",1,"Expired Permit on-site (1)",1,0,0,0,0,25]
[6,"Brickyard/North, South, East Creek Condos","DB","Retrofit  existing detention area",130000,2,null,"Ponds/Constructed Wetlands",0,4.6813437000000002,5,0.56999999999999995,4,null,null,">= 100% WQ volume ",2,"Primary",2,"Possible VT General Permit",null,"Minimal Issues/Concerns or no permits",2,"Non MS4 owned regulated (expired permit)",3,null,null,"High",2,"Addressed TMDL",1,"HOA willingness to participate (1), Expired Permit On-site (1)",2,234,1,0.49,1,27]
[7,"I-289/Route 15 North","MF","Retrofit existing median swale with CPv volume control sand filter.",34000,4,null,"Underground Storage/ Swirl Separator/Infiltration Basin",2,0.89700000000000002,2,0.121,2,null,null,">= 100% WQ volume ",2,"Primary",2,"VTRANS",null,"Minimal Issues/Concerns or no permits",2,"MS4 owned",4,null,null,"High",2,"Addressed TMDL",1,null,null,879,2,1.99,2,27]
[8,"I-289/Route 15 South","MF","Retrofit existing median swale with CPv volume control sand filter.",29000,4,null,"Underground Storage/ Swirl Separator/Infiltration Basin",2,0.96099999999999997,2,0.10199999999999999,2,null,null,">= 100% WQ volume ",2,"Primary",2,"VTRANS",null,"Minimal Issues/Concerns or no permits",2,"MS4 owned",4,null,null,"High",2,"Addressed TMDL",1,null,null,649.9,2,1.82,2,27]
[9,"Essex Union High School-Rain Garden- Regrade Parking Lot","GSI","Regrade parking lot to increase capture. Garden has capacity for more runoff without expansion.",72600,3,null,"Bioretention/Rain Gardens/Tree Box Filters",1,{"$f":"1.79-1.07","v":0.72},2,5.1000000000000004E-2,1,null,null,">= 100% WQ volume ",2,"Primary",2,"No wetlands",null,"Minimal Issues/Concerns or no permits",2,"Public ",3,null,null,"High",2,"Addressed TMDL",1,null,null,13.34,0,0.04,0,19]
[10,"Densmore Dr. ","UIB","StormTech Chamber System on Densmore Dr. Verify high groundwater elevation.",241900,2,null,"Underground Storage/ Swirl Separator",2,11.73,6,0.34399999999999997,3,0.34399999999999997,1,">= 100% WQ volume ",2,"Primary",2,"No wetlands",null,"Minimal Issues/Concerns or no permits",2,"Unknown",0,null,null,"High/Low",3,"Addressed TMDL",1,"GW Table Uncertainty (-3), ROW utility conflicts(-1) Expired permit (+1)",-3,2126,5,6.29,6,32]
[11,"Grove St.","UIB","StormTech Chamber System in Grove St ROW. High groundwater table 323'.",119600,2,null,"Underground Storage/ Swirl Separator",2,8.7127750000000006,6,0.128,2,0.128,1,">= 100% WQ volume ",2,"Primary",2,"No wetlands",null,"Minimal Issues/Concerns or no permits",2,"MS4 owned",4,null,null,"High/Low",3,"Addressed TMDL",1,"GW Table Uncertainty (-3), ROW utility conflicts(-1) Expired permit (+1)",-3,1595,4,2.34,3,31]
[12,"Countryside Dr Intersection","USC/GSI","Underground detention chamber at bottom of Countryside Dr is an option. Stabilize outfall and bank. ",263000,2,null,"Bioretention/Rain Gardens/Tree Box Filters",1,1.947225,3,0.11,2,null,null,">= 100% WQ volume ",2,"Primary",2,"No wetlands",null,"Minimal Issues/Concerns or no permits",2,"MS4 owned",4,null,null,"High",2,"Addressed TMDL",1,"Outfall Erosion Stabilization (1), Expired permit on site (1)",2,411.31,1,1.86,2,26]
[13,"Briar Lane Cul-de-sac Impervious Removal ","No Practice","Eliminate Round-about to reduce Plowing needs. Small impact.",277600,4,null,"Decreased Plowing requirements ",2,0.107,1,1.6E-2,1,null,null,">= 100% WQ volume ",2,"Secondary",0,"No wetlands",null,"Minimal Issues/Concerns or no permits",2,"MS4 owned",4,null,null,"WQ",1,"Addressed TMDL",1,"Functional Benefit (Decrease Plowing requirements) (1)",1,"<20",0,0,0,19]
[14,"Church LDS South P1","USC","Convert to underground detention system.",135400,2,null,"Underground Storage/ Swirl Separator",2,1.01,3,0.10100000000000001,2,null,null,">= 100% WQ volume ",2,"Primary",2,"No wetlands",null,"Minimal Issues/Concerns or no permits",2,"Non MS4 owned regulated (expired permit)",3,null,null,"High",2,"Addressed TMDL",1,"Access issues (-1), Loss of Habitat (-1), Expired Permit (1)",-1,494.07,2,{"$f":"0.7144-0.06196","v":0.65244000000000002},1,23]
[15,"The Commons North Pond (P1)","USC","Convert existing detention pond to a Storm-Tech chamber system.",348500,2,null,"Underground Storage/ Swirl Separator",2,2.0699999999999998,3,0.19900000000000001,2,null,null,">= 100% WQ volume ",2,"Primary",2,"No wetlands",null,"Minimal Issues/Concerns or no permits",2,"Non MS4 owned regulated (expired permit)",3,null,null,"High",2,"Addressed TMDL",1,"Access issues (-1), Expire Permit (1)",0,680.89,2,{"$f":"3.088-0.4156","v":2.6724000000000001},3,26]
[null,"BMP Type: DB: Detention Basin, USC: Underground/Covered Storage Chamber, UIB= Underground Infiltration Basin, IB= Vegetated Infiltration Basin  GSI = Smaller-scale GSI practice DW= Dry Wells, GW= Gravel Wetland    *WQ = Addresses WQ issue (i.e. excessive erosion but not flow targets)"]
[null,null,null,null,"< $50",4,null,"Underground Storage/ Swirl Separator/Infiltration Basin",2,">10 acres",7,"0.6-1.0 ac-ft.",5,">1 ac-ft.",3,">= 100% WQ volume controlled in permanent pool",2,"Primary",2,"Stormwater Operational (INDS)",-0.25,"Minimal Issues/Concerns or no permits",2,"MS4 owned",4,"Neighborhood Wide Flooding Issue",3,"High/Low",3,"Addressed TMDL",1,"Infrastructure Improvement (e.g. Culvert Replacement)",1,">2000",5,"<5",6]
[null,null,null,null,"$50-100",3,null,"Bioretention/Rain Gardens/Tree Box Filters",1,"5-10 acres",6,"0.4-0.6 ac-ft",4,"0.5-1 ac-ft",2,">= 20 % WQ volume controlled in permanent pool",1,"Secondary",0,"Stormwater Construction (9020)",-0.25,"Complex issues/Potential permit denial",0,"Public ",3,"Infrastructure damage (e.g. Wet Basement)/Single Property",2,"High",2,"Does not address TMDL",0,"Provides treatment for site covered under expired permit",1,"1500-2000",4,"4-5",5]
[null,null,null,null,"$100-1000",2,null,"Ponds/Constructed Wetlands",0,"4-5 acres",5,"0.2-0.4 ac-ft",3,"0.1- 0.5 ac-ft",1,"Under 20% WQ volume controlled in permanent pool",0,null,null,"Railway ",-0.5,null,null,"Non MS4 owned regulated (expired permit)",3,"Nuisance Issue (ie. ponding, puddles, etc).",1,"WQ",1,null,null,"Educational/Functional Benefit",1,"1000-1500",3,"3-4",4]
[null,null,null,null,"> $1000",1,null,null,null,"2-4 acres",4,">0.05-0.2 ac-ft",2,0,0,null,null,null,null,"Vtrans",-1,null,null,"Non MS4 owned/Participatory Owner",2,"None",0,null,null,null,null,"Community Willingness to Participate",1,"500-1000",2,"2-3",3]
[null,null,null,null,null,null,null,null,null,"1-2 acres",3,">0-0.05 ac-ft",1,null,null,null,null,null,null,"Dam Safety",-0.5,null,null,"Unknown",0,null,null,null,null,null,null,"Recreational ",1,"<500",1,"1-2",2]
[null,null,null,null,null,null,null,null,null,"0.5- 1 acre",2,0,0,null,null,null,null,null,null,"Local Zoning",-0.5,null,null,"Not City owned/Non participatory owner",-2,null,null,null,null,null,null,"Natural Habitat Creation/Protection",1,"<50",0,"<1",1]
[null,null,null,null,null,null,null,null,null,"< 0.5 acre",1,null,null,null,null,null,null,null,null,"Agriculture Soils Mitigation",-0.5,null,null,null,null,null,null,null,null,null,null,"Outfall Erosion Control",1]
[null,null,null,null,"*in 1,000ths",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Act250 Amendment",-0.5,null,null,null,null,null,null,null,null,null,null,"Erodible Soil concern",-1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ACOE Wetland",-1,null,null,null,null,null,null,null,null,null,null,"Uncertainty of GW table/feasibility  for infiltration ",-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State Wetland",-1,null,null,null,null,null,null,null,null,null,null,"High Likelihood of Utility conflicts",-1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"State River Management",-1,null,null,null,null,null,null,null,null,null,null,"Access Issues",-1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Habitat loss",-1]
[]
[null,null,null,null,null,null,"*These Intermediate metrics are to show a normalized quantity but are not used in the ranking.",null,null,null,null,null,null,null,null,null,null,null,null,"*The intermediate criteria is to outline the potential permits to inform the score of \"Minimal Issues-2, or \"Complex Issues\"-3"]
[null,"flow co"]

{"sheet":"2-Matrix Sort","index":3,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Ascending","Select Order","Select Order","Select Order","Decending","<<"]
["ID #","Site ID","BMP Type","Retrofit Description","Total Score"]
[{"$f":"'1-Matrix-fill'!A12","v":3},{"$f":"'1-Matrix-fill'!B12","v":"Fairview Dr./Main St. with Add-On"},{"$f":"'1-Matrix-fill'!C12","v":"GW"},{"$f":"'1-Matrix-fill'!D12","v":"Regrade existing detention area and add riser. Route outfall on North side of Fairfield Dr. to retrofit."},{"$f":"'1-Matrix-fill'!AL12","v":38}]
[{"$f":"'1-Matrix-fill'!A13","v":4},{"$f":"'1-Matrix-fill'!B13","v":"Woodlands (Detention Pond 139)"},{"$f":"'1-Matrix-fill'!C13","v":"UIB"},{"$f":"'1-Matrix-fill'!D13","v":"Retrofit existing detention pond to an infiltration practice if determined feasible."},{"$f":"'1-Matrix-fill'!AL13","v":38}]
[{"$f":"'1-Matrix-fill'!A10","v":1},{"$f":"'1-Matrix-fill'!B10","v":"Church LDS  North P2 (Option 5)"},{"$f":"'1-Matrix-fill'!C10","v":"USC"},{"$f":"'1-Matrix-fill'!D10","v":"Retrofit existing Detention Pond in front of LDS Church. Convert pond to underground detention chamber system. Route Essex Way and Inn at Essex runoff to retrofit."},{"$f":"'1-Matrix-fill'!AL10","v":34}]
[{"$f":"'1-Matrix-fill'!A11","v":2},{"$f":"'1-Matrix-fill'!B11","v":"Fairview Dr./Main St."},{"$f":"'1-Matrix-fill'!C11","v":"GW"},{"$f":"'1-Matrix-fill'!D11","v":"Regrade existing detention area and add riser. Stabilize eroded outfall on North side of Fairfield Dr."},{"$f":"'1-Matrix-fill'!AL11","v":32}]
[{"$f":"'1-Matrix-fill'!A19","v":10},{"$f":"'1-Matrix-fill'!B19","v":"Densmore Dr. "},{"$f":"'1-Matrix-fill'!C19","v":"UIB"},{"$f":"'1-Matrix-fill'!D19","v":"StormTech Chamber System on Densmore Dr. Verify high groundwater elevation."},{"$f":"'1-Matrix-fill'!AL19","v":32}]
[{"$f":"'1-Matrix-fill'!A20","v":11},{"$f":"'1-Matrix-fill'!B20","v":"Grove St."},{"$f":"'1-Matrix-fill'!C20","v":"UIB"},{"$f":"'1-Matrix-fill'!D20","v":"StormTech Chamber System in Grove St ROW. High groundwater table 323'."},{"$f":"'1-Matrix-fill'!AL20","v":31}]
[{"$f":"'1-Matrix-fill'!A15","v":6},{"$f":"'1-Matrix-fill'!B15","v":"Brickyard/North, South, East Creek Condos"},{"$f":"'1-Matrix-fill'!C15","v":"DB"},{"$f":"'1-Matrix-fill'!D15","v":"Retrofit  existing detention area"},{"$f":"'1-Matrix-fill'!AL15","v":27}]
[{"$f":"'1-Matrix-fill'!A16","v":7},{"$f":"'1-Matrix-fill'!B16","v":"I-289/Route 15 North"},{"$f":"'1-Matrix-fill'!C16","v":"MF"},{"$f":"'1-Matrix-fill'!D16","v":"Retrofit existing median swale with CPv volume control sand filter."},{"$f":"'1-Matrix-fill'!AL16","v":27}]
[{"$f":"'1-Matrix-fill'!A17","v":8},{"$f":"'1-Matrix-fill'!B17","v":"I-289/Route 15 South"},{"$f":"'1-Matrix-fill'!C17","v":"MF"},{"$f":"'1-Matrix-fill'!D17","v":"Retrofit existing median swale with CPv volume control sand filter."},{"$f":"'1-Matrix-fill'!AL17","v":27}]
[{"$f":"'1-Matrix-fill'!A24","v":15},{"$f":"'1-Matrix-fill'!B24","v":"The Commons North Pond (P1)"},{"$f":"'1-Matrix-fill'!C24","v":"USC"},{"$f":"'1-Matrix-fill'!D24","v":"Convert existing detention pond to a Storm-Tech chamber system."},{"$f":"'1-Matrix-fill'!AL24","v":26}]
[{"$f":"'1-Matrix-fill'!A21","v":12},{"$f":"'1-Matrix-fill'!B21","v":"Countryside Dr Intersection"},{"$f":"'1-Matrix-fill'!C21","v":"USC/GSI"},{"$f":"'1-Matrix-fill'!D21","v":"Underground detention chamber at bottom of Countryside Dr is an option. Stabilize outfall and bank. "},{"$f":"'1-Matrix-fill'!AL21","v":26}]
[{"$f":"'1-Matrix-fill'!A14","v":5},{"$f":"'1-Matrix-fill'!B14","v":"East Creek Condominiums"},{"$f":"'1-Matrix-fill'!C14","v":"DB"},{"$f":"'1-Matrix-fill'!D14","v":"Expand Existing Detention Pond and retrofit outlet structure for CPv control."},{"$f":"'1-Matrix-fill'!AL14","v":25}]
[{"$f":"'1-Matrix-fill'!A23","v":14},{"$f":"'1-Matrix-fill'!B23","v":"Church LDS South P1"},{"$f":"'1-Matrix-fill'!C23","v":"USC"},{"$f":"'1-Matrix-fill'!D23","v":"Convert to underground detention system."},{"$f":"'1-Matrix-fill'!AL23","v":23}]
[{"$f":"'1-Matrix-fill'!A18","v":9},{"$f":"'1-Matrix-fill'!B18","v":"Essex Union High School-Rain Garden- Regrade Parking Lot"},{"$f":"'1-Matrix-fill'!C18","v":"GSI"},{"$f":"'1-Matrix-fill'!D18","v":"Regrade parking lot to increase capture. Garden has capacity for more runoff without expansion."},{"$f":"'1-Matrix-fill'!AL18","v":19}]
[{"$f":"'1-Matrix-fill'!A22","v":13},{"$f":"'1-Matrix-fill'!B22","v":"Briar Lane Cul-de-sac Impervious Removal "},{"$f":"'1-Matrix-fill'!C22","v":"No Practice"},{"$f":"'1-Matrix-fill'!D22","v":"Eliminate Round-about to reduce Plowing needs. Small impact."},{"$f":"'1-Matrix-fill'!AL22","v":19}]

{"sheet":"Print Table","index":4,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,0,24,4]]}
["Indian Brook Flow Restoration Plan(FRP) Project"]
["Task 4: Ranked BMPs Table"]
["BMPs Ranked watershed-wide based on matrix of criteria"]
[]
[]
["ID #","Site ID","BMP Type","Retrofit Description","Total Score"]
[{"$f":"'2-Matrix Sort'!A3","v":3},{"$f":"'2-Matrix Sort'!B3","v":"Fairview Dr./Main St. with Add-On"},{"$f":"'2-Matrix Sort'!C3","v":"GW"},{"$f":"'2-Matrix Sort'!D3","v":"Regrade existing detention area and add riser. Route outfall on North side of Fairfield Dr. to retrofit."},{"$f":"'2-Matrix Sort'!E3","v":38}]
[{"$f":"'2-Matrix Sort'!A4","v":4},{"$f":"'2-Matrix Sort'!B4","v":"Woodlands (Detention Pond 139)"},{"$f":"'2-Matrix Sort'!C4","v":"UIB"},{"$f":"'2-Matrix Sort'!D4","v":"Retrofit existing detention pond to an infiltration practice if determined feasible."},{"$f":"'2-Matrix Sort'!E4","v":38}]
[{"$f":"'2-Matrix Sort'!A5","v":1},{"$f":"'2-Matrix Sort'!B5","v":"Church LDS  North P2 (Option 5)"},{"$f":"'2-Matrix Sort'!C5","v":"USC"},{"$f":"'2-Matrix Sort'!D5","v":"Retrofit existing Detention Pond in front of LDS Church. Convert pond to underground detention chamber system. Route Essex Way and Inn at Essex runoff to retrofit."},{"$f":"'2-Matrix Sort'!E5","v":34}]
[{"$f":"'2-Matrix Sort'!A6","v":2},{"$f":"'2-Matrix Sort'!B6","v":"Fairview Dr./Main St."},{"$f":"'2-Matrix Sort'!C6","v":"GW"},{"$f":"'2-Matrix Sort'!D6","v":"Regrade existing detention area and add riser. Stabilize eroded outfall on North side of Fairfield Dr."},{"$f":"'2-Matrix Sort'!E6","v":32}]
[{"$f":"'2-Matrix Sort'!A7","v":10},{"$f":"'2-Matrix Sort'!B7","v":"Densmore Dr. "},{"$f":"'2-Matrix Sort'!C7","v":"UIB"},{"$f":"'2-Matrix Sort'!D7","v":"StormTech Chamber System on Densmore Dr. Verify high groundwater elevation."},{"$f":"'2-Matrix Sort'!E7","v":32}]
[{"$f":"'2-Matrix Sort'!A8","v":11},{"$f":"'2-Matrix Sort'!B8","v":"Grove St."},{"$f":"'2-Matrix Sort'!C8","v":"UIB"},{"$f":"'2-Matrix Sort'!D8","v":"StormTech Chamber System in Grove St ROW. High groundwater table 323'."},{"$f":"'2-Matrix Sort'!E8","v":31}]
[{"$f":"'2-Matrix Sort'!A9","v":6},{"$f":"'2-Matrix Sort'!B9","v":"Brickyard/North, South, East Creek Condos"},{"$f":"'2-Matrix Sort'!C9","v":"DB"},{"$f":"'2-Matrix Sort'!D9","v":"Retrofit  existing detention area"},{"$f":"'2-Matrix Sort'!E9","v":27}]
[{"$f":"'2-Matrix Sort'!A10","v":7},{"$f":"'2-Matrix Sort'!B10","v":"I-289/Route 15 North"},{"$f":"'2-Matrix Sort'!C10","v":"MF"},{"$f":"'2-Matrix Sort'!D10","v":"Retrofit existing median swale with CPv volume control sand filter."},{"$f":"'2-Matrix Sort'!E10","v":27}]
[{"$f":"'2-Matrix Sort'!A11","v":8},{"$f":"'2-Matrix Sort'!B11","v":"I-289/Route 15 South"},{"$f":"'2-Matrix Sort'!C11","v":"MF"},{"$f":"'2-Matrix Sort'!D11","v":"Retrofit existing median swale with CPv volume control sand filter."},{"$f":"'2-Matrix Sort'!E11","v":27}]
[{"$f":"'2-Matrix Sort'!A12","v":15},{"$f":"'2-Matrix Sort'!B12","v":"The Commons North Pond (P1)"},{"$f":"'2-Matrix Sort'!C12","v":"USC"},{"$f":"'2-Matrix Sort'!D12","v":"Convert existing detention pond to a Storm-Tech chamber system."},{"$f":"'2-Matrix Sort'!E12","v":26}]
[{"$f":"'2-Matrix Sort'!A13","v":12},{"$f":"'2-Matrix Sort'!B13","v":"Countryside Dr Intersection"},{"$f":"'2-Matrix Sort'!C13","v":"USC/GSI"},{"$f":"'2-Matrix Sort'!D13","v":"Underground detention chamber at bottom of Countryside Dr is an option. Stabilize outfall and bank. "},{"$f":"'2-Matrix Sort'!E13","v":26}]
[{"$f":"'2-Matrix Sort'!A14","v":5},{"$f":"'2-Matrix Sort'!B14","v":"East Creek Condominiums"},{"$f":"'2-Matrix Sort'!C14","v":"DB"},{"$f":"'2-Matrix Sort'!D14","v":"Expand Existing Detention Pond and retrofit outlet structure for CPv control."},{"$f":"'2-Matrix Sort'!E14","v":25}]
[{"$f":"'2-Matrix Sort'!A15","v":14},{"$f":"'2-Matrix Sort'!B15","v":"Church LDS South P1"},{"$f":"'2-Matrix Sort'!C15","v":"USC"},{"$f":"'2-Matrix Sort'!D15","v":"Convert to underground detention system."},{"$f":"'2-Matrix Sort'!E15","v":23}]
[{"$f":"'2-Matrix Sort'!A16","v":9},{"$f":"'2-Matrix Sort'!B16","v":"Essex Union High School-Rain Garden- Regrade Parking Lot"},{"$f":"'2-Matrix Sort'!C16","v":"GSI"},{"$f":"'2-Matrix Sort'!D16","v":"Regrade parking lot to increase capture. Garden has capacity for more runoff without expansion."},{"$f":"'2-Matrix Sort'!E16","v":19}]
[{"$f":"'2-Matrix Sort'!A17","v":13},{"$f":"'2-Matrix Sort'!B17","v":"Briar Lane Cul-de-sac Impervious Removal "},{"$f":"'2-Matrix Sort'!C17","v":"No Practice"},{"$f":"'2-Matrix Sort'!D17","v":"Eliminate Round-about to reduce Plowing needs. Small impact."},{"$f":"'2-Matrix Sort'!E17","v":19}]
["BMP Type: DB: Detention Basin, USC: Underground/Covered Storage Chamber, UIB= Underground Infiltration Basin, IB= Vegetated Infiltration Basin  GSI = Smaller-scale GSI practice DW= Dry Wells, GW= Gravel Wetland    *WQ = Addresses WQ issue (i.e. excessive erosion but not flow targets)"]