{"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":10,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Criteria Key","index":0,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[13,1,14,1],[8,1,12,1],[6,1,7,1],[16,1,21,1]]}
[null,"Sunderland Brook Flow Restoration Plan (FRP)"]
[null,{"$f":"TODAY()","v":"2015-04-23"}]
[]
[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 >$400,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":72,"n_cols":7,"rows_kept":72,"cut":false,"hidden":false,"merged":[[73,2,73,6],[23,3,27,4],[28,3,30,4],[33,3,34,4],[35,3,40,4],[41,3,44,4],[45,3,47,4],[48,3,49,4],[31,3,32,4],[71,2,72,6],[50,3,58,4],[13,0,17,0],[13,3,17,4],[18,3,22,4],[6,1,12,1],[33,1,40,1],[13,1,32,1],[10,3,12,4],[41,1,70,1],[59,3,64,4],[65,3,70,4],[6,3,9,4],[5,3,5,4]]}
[null,"Sunderland Brook Flow Restoration Plan (FRP)"]
[null,{"$f":"TODAY()","v":"2015-04-23"}]
[]
[null,"Table A-5-2 BMP Ranking Scoring 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-400,000",2]
[null,null,null,null,null,"Over $400,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,"> 5 acres",5]
[null,null,null,null,null,"4-5 acres",4]
[null,null,null,null,null,"2-4 acres",3]
[null,null,null,null,null,"1-2 acres",2]
[null,null,null,null,null,"< 1 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,"0.01-0.1 ac-ft",1]
[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,">10,000",5]
[null,null,null,null,null,"3000-10,000",4]
[null,null,null,null,null,"1500-3000",3]
[null,null,null,null,null,"1000-1500",2]
[null,null,null,null,null,"50-1000",1]
[null,null,null,null,null,"<50",0]
[null,null,"O","Annual Total Phosphorus (TP) Yeild 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":33,"n_cols":35,"rows_kept":33,"cut":false,"hidden":false,"merged":[[6,30,6,31],[6,32,6,33],[5,34,8,34],[7,26,7,27],[7,28,7,29],[7,30,7,31],[7,32,7,33],[6,28,6,29],[5,22,5,33],[7,22,7,23],[7,24,7,25],[6,22,6,23],[6,24,6,25],[6,26,6,27],[26,23,26,24],[26,25,26,27],[18,2,35,2],[5,8,5,17],[6,8,6,9],[6,10,6,11],[6,12,6,13],[7,6,7,7],[6,6,6,7],[6,16,6,17],[7,8,7,9],[7,10,7,11],[7,12,7,13],[7,14,7,15],[5,18,5,21],[6,18,6,19],[5,1,7,1],[5,2,7,2],[5,3,7,3],[6,14,6,15],[6,4,6,5],[7,4,7,5],[5,4,5,7],[6,20,6,21],[26,6,26,7],[7,16,7,17],[7,20,7,21],[7,18,7,19],[26,12,26,13],[26,14,26,15]]}
[null,"Sunderland Brook Flow Restoration Plan (FRP)"]
[null,"BMP Ranking Matrix"]
[null,{"$f":"TODAY()","v":"2015-04-23"}]
[]
[]
[null,"Site ID","BMP Type","Retrofit Description","Cost/Operations",null,null,null,"Project Design Metrics",null,null,null,null,null,null,null,null,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,"B",null,"C",null,"D",null,"E",null,"F",null,"G",null,"H",null,"I",null,"J",null,"K",null,"L",null,"M",null,"N",null,"O"]
["#",null,null,null,"Project Cost",null,"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,"Permitting Restrictions ",null,"Land Availabilty  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) Yeild Mitigated (lbs.)"]
["#",null,null,null,"Value","Score","Value","Score","Value","Score","Value","Score","Value","Score","Value","Score","Value","Score","Value","Score","Value","Score","Value","Score",null,"Value","Score","Value","Score","Value","Score","Value","Score","Value"]
[1,"Tracy Rd. -Fort Ethan Allen","IB","Long Infiltration Trench/Bioretention",134750,2,"Underground Storage/ Swirl Separator",2,3.9402159999999995,4,0.42499999999999999,3,0.42499999999999999,2,">= 100% WQ volume controlled in permanent pool",2,"Primary",2,"Minimal Issues/Concerns or no permits",2,"MS4 owned",4,null,null,"High/Low",3,"Addressed TMDL",1,null,null,370,1.1000000000000001,1.71,2.1,{"$f":"SUM(J10,L10,F10,N10,P10,AF10,AH10,X10,Z10,AB10,AD10,H10,R10,T10,V10)","v":30.2}]
[2,"Outfall 126: Fort Ethan Allen","UIB","Excessively eroded outfall and channel. Constrained by UVM property. Proposed infiltration basin with perforated pipe within existing terraced area just upslope of the channel.",201266,2,"Underground Storage/ Swirl Separator",2,9.8403980000000004,5,0.57699999999999996,3,0.57699999999999996,3,">= 100% WQ volume controlled in permanent pool",2,"Primary",2,"Minimal Issues/Concerns or no permits",2,"MS4 owned",4,null,null,"High/Low",3,"Addressed TMDL",1," Erosion mitigated at outfall. Stabilize bank. ",1,2517,3,3.87,4,{"$f":"SUM(J11,L11,F11,N11,P11,AF11,AH11,X11,Z11,AB11,AD11,H11,R11,T11,V11)","v":37}]
[3,"Outfall 31- Morse Dr.","UIB","Infiltration stone gallery at end of pipe. ",130000,2,"Underground Storage/ Swirl Separator",2,3.5602020000000003,4,0.29699999999999999,3,0.29699999999999999,2,">= 100% WQ volume controlled in permanent pool",2,"Primary",2,"Minimal Issues/Concerns or no permits",2,{"$f":"U22","v":"Non MS4 owned/Participatory Owner"},2,null,null,"High/Low",3,"Addressed TMDL",1,null,null,7390,4,3.92,4,33]
[4,"Outfall 199-Morse Dr. ","UIB","Retrofit roundabout upslope from outfall with infiltration practice in ROW. Wetlands near outfall. ",36173,4,"Underground Storage/ Swirl Separator",2,5.18,5,0.13600000000000001,2,0.13600000000000001,2,">= 100% WQ volume controlled in permanent pool",2,"Primary",2,"Minimal Issues/Concerns or no permits",2,"Unknown Participation",0,null,null,"High/Low",3,"Addressed TMDL",1,null,null,1013.16,2,1.45,2,29]
[5,"Route 15/Pearl St.","UIB","Redirect Route 15 Stormline to underground infiltration chambers. ",55469,3,"Underground Storage/ Swirl Separator",2,2.3162500000000001,3,8.8999999999999996E-2,2,8.8999999999999996E-2,1,">= 100% WQ volume controlled in permanent pool",2,"Primary",2,"Minimal Issues/Concerns or no permits",2,"Unknown Private Participation",0,null,null,"High/Low",3,"Addressed TMDL",1,"Provides treatment for site covered under expired permit",1,1163.54,2,1.29,2,26]
[6,"Forman Dr. Roundabout","IB","Retrofit grassed circular median with bioretention practice.",71860,3,"Bioretention/Rain Gardens/Tree Box Filters",1,1.34,2,4.7E-2,1,4.7E-2,1,">= 100% WQ volume controlled in permanent pool",2,"Primary",2,"Minimal Issues/Concerns or no permits",2,"MS4 owned",4,null,null,"High/Low",3,"Addressed TMDL",1,null,null,309.60000000000002,1,1.03,2,25]
[7,"Kimberly Drive (O3, O4)","UIB","StormTech infiltration chamber system at end of Parizo Dr. ",467794,1,"Underground Storage/ Swirl Separator",2,7.9013400000000003,5,0.23,2,0.23,2,">= 100% WQ volume controlled in permanent pool",2,"Primary",2,"Minimal Issues/Concerns or no permits",2,"Unknown Private Participation",0,null,null,"High/Low",3,"Addressed TMDL",1,"Provides treatment for site covered under expired permit",1,1498,2,5.2,5,30]
[8,"David Dr. Outfall","UIB","StormTech infiltration Chamber system at end of David Dr. ",800395,1,"Underground Storage/ Swirl Separator",2,15.96,5,1.4,4,1.4,4,">= 100% WQ volume controlled in permanent pool",2,"Primary",2,"Minimal Issues/Concerns or no permits",2,"Unknown Private Participation",0,null,null,"High/Low",3,"Addressed TMDL",1,"Erosion mitigated at outfall. Stabilize bank. , Provides treatment for site with Expired permit",2,27957,5,15.56,6,39]
[]
[null,null,"BMP Type: DB: Detention Basin, USC: Underground/Covered Storage Chamber, UIB= Underground Infiltration Basin, IB= Vegetated Infiltration Basin ",null,"< $50",4,"Underground Storage/ Swirl Separator",2,"> 5 acres",5,"0.6-1.0 ac-ft",5,">1 ac-ft",4,">= 100% WQ volume controlled in permanent pool",2,"Primary",2,"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,">10,000",5,"<5",6]
[null,null,null,null,"$50-100",3,"Bioretention/Rain Gardens/Tree Box Filters",1,"4-5 acres",4,"0.4-0.6 ac-ft",4,"0.5-1 ac-ft",3,">= 20 % WQ volumen controlled in permanent pool",1,"Secondary",0,"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,"3000-10,000",4,"4-5",5]
[null,null,null,null,"$100-400",2,"Ponds/Constructed Wetlands",0,"2-4 acres",3,"0.2-0.4 ac-ft",3,"0.1- 0.5 ac-ft",2,"Under 20% WQ volume controlled in permanent pool",0,null,null,null,null,"Non MS4 owned regulated (expired permit)",3,"Nuisance Issue (ie. ponding, puddles, etc).",1,"WQ",1,null,null,"Educational/Functional Benefit",1,"1500-3000",3,"3-4",4]
[null,null,null,null,"> $400",1,null,null,"1-2 acres",2,"0.05-0.2 ac-ft",2,"0.01-0.1",1,null,null,null,null,null,null,"Non MS4 owned/Participatory Owner",2,"None",0,null,null,null,null,"Recreational ",1,"1000-1500",2,"2-3",3]
[null,null,null,null,null,null,null,null,"< 1 acre",1,">0.1-0.05 ac-ft",1,0,0,null,null,null,null,null,null,"Unknown",0,null,null,null,null,null,null,"Natural Habitat Creation/Protection",1,"50-1000",1,"1-2",2]
[null,null,null,null,null,null,null,null,0,0,0,0,null,null,null,null,null,null,null,null,"Not City owned/Non participatory owner",-2,null,null,null,null,null,null,"Outfall Erosion Control",1,"<50",0,"<1",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,"Erodible Soil concern",-1]
[null,null,null,null,"*in 1,000ths"]
[]
[]
[]
[]
[]
[]
[null,"flow co"]

{"sheet":"2-Matrix Sort","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"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'!A17","v":8},{"$f":"'1-Matrix-fill'!B17","v":"David Dr. Outfall"},{"$f":"'1-Matrix-fill'!C17","v":"UIB"},{"$f":"'1-Matrix-fill'!D17","v":"StormTech infiltration Chamber system at end of David Dr. "},{"$f":"'1-Matrix-fill'!AI17","v":39}]
[{"$f":"'1-Matrix-fill'!A11","v":2},{"$f":"'1-Matrix-fill'!B11","v":"Outfall 126: Fort Ethan Allen"},{"$f":"'1-Matrix-fill'!C11","v":"UIB"},{"$f":"'1-Matrix-fill'!D11","v":"Excessively eroded outfall and channel. Constrained by UVM property. Proposed infiltration basin with perforated pipe within existing terraced area just upslope of the channel."},{"$f":"'1-Matrix-fill'!AI11","v":37}]
[{"$f":"'1-Matrix-fill'!A12","v":3},{"$f":"'1-Matrix-fill'!B12","v":"Outfall 31- Morse Dr."},{"$f":"'1-Matrix-fill'!C12","v":"UIB"},{"$f":"'1-Matrix-fill'!D12","v":"Infiltration stone gallery at end of pipe. "},{"$f":"'1-Matrix-fill'!AI12","v":33}]
[{"$f":"'1-Matrix-fill'!A10","v":1},{"$f":"'1-Matrix-fill'!B10","v":"Tracy Rd. -Fort Ethan Allen"},{"$f":"'1-Matrix-fill'!C10","v":"IB"},{"$f":"'1-Matrix-fill'!D10","v":"Long Infiltration Trench/Bioretention"},{"$f":"'1-Matrix-fill'!AI10","v":30.2}]
[{"$f":"'1-Matrix-fill'!A16","v":7},{"$f":"'1-Matrix-fill'!B16","v":"Kimberly Drive (O3, O4)"},{"$f":"'1-Matrix-fill'!C16","v":"UIB"},{"$f":"'1-Matrix-fill'!D16","v":"StormTech infiltration chamber system at end of Parizo Dr. "},{"$f":"'1-Matrix-fill'!AI16","v":30}]
[{"$f":"'1-Matrix-fill'!A13","v":4},{"$f":"'1-Matrix-fill'!B13","v":"Outfall 199-Morse Dr. "},{"$f":"'1-Matrix-fill'!C13","v":"UIB"},{"$f":"'1-Matrix-fill'!D13","v":"Retrofit roundabout upslope from outfall with infiltration practice in ROW. Wetlands near outfall. "},{"$f":"'1-Matrix-fill'!AI13","v":29}]
[{"$f":"'1-Matrix-fill'!A14","v":5},{"$f":"'1-Matrix-fill'!B14","v":"Route 15/Pearl St."},{"$f":"'1-Matrix-fill'!C14","v":"UIB"},{"$f":"'1-Matrix-fill'!D14","v":"Redirect Route 15 Stormline to underground infiltration chambers. "},{"$f":"'1-Matrix-fill'!AI14","v":26}]
[{"$f":"'1-Matrix-fill'!A15","v":6},{"$f":"'1-Matrix-fill'!B15","v":"Forman Dr. Roundabout"},{"$f":"'1-Matrix-fill'!C15","v":"IB"},{"$f":"'1-Matrix-fill'!D15","v":"Retrofit grassed circular median with bioretention practice."},{"$f":"'1-Matrix-fill'!AI15","v":25}]

{"sheet":"Print Table","index":4,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Sunderland 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":8},{"$f":"'2-Matrix Sort'!B3","v":"David Dr. Outfall"},{"$f":"'2-Matrix Sort'!C3","v":"UIB"},{"$f":"'2-Matrix Sort'!D3","v":"StormTech infiltration Chamber system at end of David Dr. "},{"$f":"'2-Matrix Sort'!E3","v":39}]
[{"$f":"'2-Matrix Sort'!A4","v":2},{"$f":"'2-Matrix Sort'!B4","v":"Outfall 126: Fort Ethan Allen"},{"$f":"'2-Matrix Sort'!C4","v":"UIB"},{"$f":"'2-Matrix Sort'!D4","v":"Excessively eroded outfall and channel. Constrained by UVM property. Proposed infiltration basin with perforated pipe within existing terraced area just upslope of the channel."},{"$f":"'2-Matrix Sort'!E4","v":37}]
[{"$f":"'2-Matrix Sort'!A5","v":3},{"$f":"'2-Matrix Sort'!B5","v":"Outfall 31- Morse Dr."},{"$f":"'2-Matrix Sort'!C5","v":"UIB"},{"$f":"'2-Matrix Sort'!D5","v":"Infiltration stone gallery at end of pipe. "},{"$f":"'2-Matrix Sort'!E5","v":33}]
[{"$f":"'2-Matrix Sort'!A6","v":1},{"$f":"'2-Matrix Sort'!B6","v":"Tracy Rd. -Fort Ethan Allen"},{"$f":"'2-Matrix Sort'!C6","v":"IB"},{"$f":"'2-Matrix Sort'!D6","v":"Long Infiltration Trench/Bioretention"},{"$f":"'2-Matrix Sort'!E6","v":30.2}]
[{"$f":"'2-Matrix Sort'!A7","v":7},{"$f":"'2-Matrix Sort'!B7","v":"Kimberly Drive (O3, O4)"},{"$f":"'2-Matrix Sort'!C7","v":"UIB"},{"$f":"'2-Matrix Sort'!D7","v":"StormTech infiltration chamber system at end of Parizo Dr. "},{"$f":"'2-Matrix Sort'!E7","v":30}]
[{"$f":"'2-Matrix Sort'!A8","v":4},{"$f":"'2-Matrix Sort'!B8","v":"Outfall 199-Morse Dr. "},{"$f":"'2-Matrix Sort'!C8","v":"UIB"},{"$f":"'2-Matrix Sort'!D8","v":"Retrofit roundabout upslope from outfall with infiltration practice in ROW. Wetlands near outfall. "},{"$f":"'2-Matrix Sort'!E8","v":29}]
[{"$f":"'2-Matrix Sort'!A9","v":5},{"$f":"'2-Matrix Sort'!B9","v":"Route 15/Pearl St."},{"$f":"'2-Matrix Sort'!C9","v":"UIB"},{"$f":"'2-Matrix Sort'!D9","v":"Redirect Route 15 Stormline to underground infiltration chambers. "},{"$f":"'2-Matrix Sort'!E9","v":26}]