{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["Disclaimer","Soil Loss ","Drainage Areas","Climate","Soils","BMPs - 1","BMPs - 2","BMPs - 3","BMPs - 4","BMPs - 5","BMPs - 6","Risk","3 - BMPs","4 - BMPs","5 - BMPs","6 - BMPs","7 - BMPs","8 - BMPs","9 - BMPs","10 - BMPs","11 - BMPs","12 - BMPs","13 - BMPs","14 - BMPs","References"],"not_rendered":{"charts":0,"images":62,"macros":1,"external_links":0,"defined_names":205,"comments":6,"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":"Disclaimer","index":0,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,1,6,9],[7,1,13,9],[14,1,17,9],[1,1,1,9],[18,1,20,9]]}
[]
[null,"DISCLAIMER"]
[null,"The information is licensed \"as is\", and the Information Provider excludes all representations, warranties, obligations, and liabilities, whether expressed or implied, to the maximum extent permitted by law. Please note that the tooll has its own limitations, and the original document(s) should be followed.The tool output value should not be considered absolute, and should only be used on a comparitive basis between site conditions. Documentation on the USLE tool and input factors can be found in the \"References\" tab along the bottom pane and should be consulted prior to use."]
[]
[]
[]
[]
[null,"The Information Provider is not liable for any errors or omissions in the information, and will not under any circumstances be liable for any direct, indirect, special, incidental, consequential, or other loss, injury or damage caused by its use or otherwise arising in connection with this information, even if specifically advised of the possibility of such loss, injury, or damage. Please refer to the original documentation or speak with an expert in this area before using the information for decision making purposes."]
[]
[]
[]
[]
[]
[]
[null,"By using this tool document you accept the terms and conditions outlined above."]
[]
[]
[]
[null,"This tool was developed by TRCA and Azimuth Environmental Consulting, Inc.:"]
[]
[]
[null,"Toronto and Region Conservation Authority",null,null,null,null,"Azimuth Environmental Consulting, Inc."]
[null,"Earth Rangers Centre"]
[null,"9520 Pine Valley Drive",null,null,null,null,"85 Bayfield Street, Suite 400"]
[null,"Woodbridge, Ontario",null,null,null,null,"Barrie, Ontario"]
[null,"L4L 1A6",null,null,null,null,"L4M 3A7"]
[]
[null,"289-268-3901",null,null,null,null,"(705) 721-8451"]
[null,"gmacmillan@trca.on.ca",null,null,null,null,"jthompson@azimuthenvironmental.com"]

{"sheet":"Soil Loss ","index":1,"n_rows":48,"n_cols":24,"rows_kept":48,"cut":false,"hidden":false,"merged":[[4,1,4,5],[5,1,5,5],[7,22,8,22],[7,5,8,5],[7,6,8,6],[7,21,8,21],[7,20,8,20],[7,7,8,7],[7,8,8,8],[7,15,8,15],[7,16,8,16],[7,13,8,13],[7,23,8,23],[1,1,2,23],[15,1,15,2],[15,5,15,11],[19,11,19,17],[7,4,8,4],[4,6,4,8],[5,6,5,8],[7,12,8,12],[7,1,8,1],[7,9,8,9],[7,11,8,11],[7,10,8,10],[7,2,8,2],[7,19,8,19],[7,3,8,3]]}
[]
[null,"Soil Loss Worksheet for Construction Sites in Ontario "]
[]
[]
[null,"City or Weather Station:",null,null,null,null,null,null,null,null,"User Input"]
[null,"R Factor:",null,null,null,null,{"$f":"IF(G5=\"\",\"\",VLOOKUP(G5,CityTable,2,0))","v":""},null,null,null,"RESULTS"]
[]
[null,"Parcel ID","Land Type"," Area (ha)","Percent of Total Area (%)","Slope (%)","Slope Length (m)","NN","LS Factor","Soil Texture Class:","OM Content","K factor (t/ha):","Bare Soil Loss (t/ha/year)","Bare Soil Erosion Risk",null,"C Factor","P Factor",null,null,"Soil Loss with BMP (t/ha/year)",null,null,null,"Soil Erosion Risk"]
[]
[null,1,null,null,{"$f":"IF(ISBLANK(D10),0,(D10/$D$16*100))","v":0},null,null,{"$f":"IF(F10=\"\",\"\",IF(F10<1,\"0.2\",IF(F10<3,\"0.3\",IF(F10<5,\"0.4\",\"0.5\"))))","v":""},{"$f":"IF(G10=\"\",\"\",(0.065+0.0456*F10 +0.006541*F10^2)*(G10/22.1)^H10)","v":""},null,null,{"$f":"IF(K10=\"Average OMC\",VLOOKUP(J10,KFACTORBIGTABLE,2,0),IF(K10=\"Less than 2% OMC\",VLOOKUP(J10,KFACTORBIGTABLE,3,0),IF(K10=\"More than 2% OMC\",VLOOKUP(J10,KFACTORBIGTABLE,4,0),\"\")))","v":""},{"$f":"IF(ISBLANK(D10),0,$G$6*I10*L10)","v":0},{"$f":"IF(M10=\"\",\"\",IF(M10<6.7,\"Very Low\", IF(M10<11.2,\"Low\", IF(M10<22.4,\" Moderate\", IF(M10<33.6, \"High\",\" Very High\")))))","v":"Very Low"},null,{"$f":"'BMPs - 1'!$K$27","v":1},{"$f":"'BMPs - 1'!$X$21","v":1},null,null,{"$f":"IF(M10=0,0,(IF(D10=\"\",\"\",$G$6*I10*L10*(P10)*(Q10))))","v":0},{"$f":"T10*$E10/100","v":0},{"$f":"#REF!*$E10/100","v":{"$error":"#REF!"}},{"$f":"#REF!*$E10/100","v":{"$error":"#REF!"}},{"$f":"IF(T10=\"\",\"\",IF(T10<6.7,\"Very Low\", IF(T10<11.2,\"Low\", IF(T10<22.4,\" Moderate\", IF(T10<33.6, \"High\",\" Very High\")))))","v":"Very Low"}]
[null,2,null,null,{"$f":"IF(ISBLANK(D11),0,(D11/$D$16*100))","v":0},null,null,"","",null,null,"",{"$f":"IF(ISBLANK(D11),0,$G$6*I11*L11)","v":0},{"$f":"IF(M11=\"\",\"\",IF(M11<6.7,\"Very Low\", IF(M11<11.2,\"Low\", IF(M11<22.4,\" Moderate\", IF(M11<33.6, \"High\",\" Very High\")))))","v":"Very Low"},null,{"$f":"'BMPs - 2'!$K$27","v":1},{"$f":"'BMPs - 2'!$X$21","v":1},null,null,{"$f":"IF(M11=0,0,(IF(D11=\"\",\"\",$G$6*I11*L11*(P11)*(Q11))))","v":0},0,{"$f":"#REF!*$E11/100","v":{"$error":"#REF!"}},{"$f":"#REF!*$E11/100","v":{"$error":"#REF!"}},{"$f":"IF(T11=\"\",\"\",IF(T11<6.7,\"Very Low\", IF(T11<11.2,\"Low\", IF(T11<22.4,\" Moderate\", IF(T11<33.6, \"High\",\" Very High\")))))","v":"Very Low"}]
[null,3,null,null,0,null,null,"","",null,null,"",{"$f":"IF(ISBLANK(D12),0,$G$6*I12*L12)","v":0},"Very Low",null,{"$f":"'BMPs - 3'!$K$27","v":1},{"$f":"'BMPs - 3'!$X$21","v":1},null,null,{"$f":"IF(M12=0,0,(IF(D12=\"\",\"\",$G$6*I12*L12*(P12)*(Q12))))","v":0},0,{"$f":"#REF!*$E12/100","v":{"$error":"#REF!"}},{"$f":"#REF!*$E12/100","v":{"$error":"#REF!"}},"Very Low"]
[null,4,null,null,0,null,null,"","",null,null,"",0,"Very Low",null,{"$f":"'BMPs - 4'!$K$27","v":1},{"$f":"'BMPs - 4'!$X$21","v":1},null,null,0,null,null,null,"Very Low"]
[null,5,null,null,0,null,null,"","",null,null,"",0,"Very Low",null,{"$f":"'BMPs - 5'!$K$27","v":1},{"$f":"'BMPs - 5'!$X$21","v":1},null,null,0,0,{"$f":"#REF!*$E14/100","v":{"$error":"#REF!"}},{"$f":"#REF!*$E14/100","v":{"$error":"#REF!"}},"Very Low"]
[null,6,null,null,0,null,null,"","",null,null,"",0,"Very Low",null,{"$f":"'BMPs - 6'!$K$27","v":1},{"$f":"'BMPs - 6'!$X$21","v":1},null,null,0,0,{"$f":"#REF!*$E15/100","v":{"$error":"#REF!"}},{"$f":"#REF!*$E15/100","v":{"$error":"#REF!"}},"Very Low"]
[null,"Total",null,{"$f":"SUM(D10:D15)","v":0},{"$f":"SUM(E10:E15)","v":0},"Mean Annual Sediment Yield of the Site (t/ha/year)",null,null,null,null,null,null,{"$f":"SUM(M10:M15)","v":0},"Very Low",null,null,null,null,null,{"$f":"SUM(T10:T15)","v":0},null,null,null,"Very Low"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Reduction:",null,null,null,null,null,null,null,{"$f":"IF(M16=0,0,(M16-T16)/M16)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,1,null,null,"Average OMC",null,"Land Disturbing Phases"]
[null,null,2,null,null,"Less than 2% OMC",null,"Pre-Development "]
[null,null,3,null,null,"More than 2% OMC",null,"Exposed Soil"]
[null,null,4,null,null,null,null,"Stabilized by Vegetation "]
[null,null,5,null,null,null,null,"Paved Surface"]
[null,null,6]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]

{"sheet":"Drainage Areas","index":2,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[7,10,7,11],[30,10,30,11],[1,1,3,47],[37,2,40,9],[31,11,33,21],[34,11,34,21],[35,11,35,21],[17,10,17,13],[17,14,17,18]]}
[]
[null,"Drainage Area Map and Information"]

{"sheet":"Climate","index":3,"n_rows":66,"n_cols":5,"rows_kept":66,"cut":false,"hidden":false,"merged":[[1,1,1,16],[3,1,3,2]]}
[]
[null,"Climate Information"]
[]
[null,"Table 1: R Factor and Background Sediment Values by City (Stone & Hilborn, 2012)",null,null,"Figure 1: Map of R Values for Ontario and Quebec (Wall et al, 2002)"]
[null,"City/Area","R Factor"]
[null,"Attawapiskat",90]
[null,"Barrie",90]
[null,"Bearskin Lake",90]
[null,"Brantford",90]
[null,"Chatham-Kent",110]
[null,"City of Simcoe ",120]
[null,"Clarington",90]
[null,"Cobalt",90]
[null,"Cochrane",90]
[null,"Delhi",100]
[null,"Dryden",90]
[null,"Englehart",90]
[null,"Essex",110]
[null,"Fergus/Orangeville",120]
[null,"Glen Allen",130]
[null,"Guelph",100]
[null,"Hamilton",100]
[null,"Iroquois Falls",90]
[null,"Kapuskasing",90]
[null,"Kenora",90]
[null,"Kingston",90]
[null,"Kirkland Lake",90]
[null,"Kitchener",110]
[null,"London",100]
[null,"Midland",90]
[null,"Moosone",90]
[null,"Niagara",90]
[null,"Oshawa",90]
[null,"Ottawa",90]
[null,"Owen Sound",90]
[null,"Pickle Lake",90]
[null,"Prospect Hill",120]
[null,"Red Lake",90]
[null,"South River",90]
[null,"St. Catherines",100]
[null,"St. Thomas",90]
[null,"Sudbury",100]
[null,"Timmins",90]
[null,"Toronto",90]
[null,"Windsor",110]
[null,"Other","**"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"http://www.omafra.gov.on.ca/english/engineer/facts/12-051.htm"]

{"sheet":"Soils","index":4,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,2,4,4],[4,1,5,1],[1,1,1,18]]}
[]
[null,"Soil Information"]
[]
[null,"Table 1: Summary of K Factor Values (Stone & Hilborn, 2012)",null,null,null,null,"Figure 1: USDA Soil Textural Triangle (USDA, 2014)"]
[null,"Textural Class   ","K factor"]
[null,null,"Average OMC","Less than 2% OM","More than 2% OM"]
[null,"Clay   ",0.49,0.54,0.47]
[null,"Clay Loam   ",0.67,0.74,0.63]
[null,"Coarse Sandy Loam  ",0.16,"-",0.16]
[null,"Fine Sand  ",0.18,0.2,0.13]
[null,"Fine Sandy Loam   ",0.4,0.49,0.38]
[null,"Heavy Clay ",0.38,0.43,0.34]
[null,"Loam   ",0.67,0.76,0.57999999999999996]
[null,"Loamy Fine Sand  ",0.25,0.34,0.2]
[null,"Loamy Sand   ",0.09,0.11,0.09]
[null,"Loamy Very Fine Sand   ",0.87,0.99,0.56000000000000005]
[null,"Sand  ",0.04,7.0000000000000007E-2,0.02]
[null,"Sandy Clay Loam  ",0.45,"-",0.45]
[null,"Sandy Loam  ",0.28999999999999998,0.31,0.27]
[null,"Silt Loam  ",0.85,0.92,0.83]
[null,"Silty Clay   ",0.57999999999999996,0.61,0.57999999999999996]
[null,"Silty Clay Loam   ",0.72,0.79,0.67]
[null,"Very Fine Sand ",0.96,1.03,0.83]
[null,"Very Fine Sandy Loam   ",0.79,0.92,0.74]
[null,"Other","***","***","***"]

{"sheet":"BMPs - 1","index":5,"n_rows":162,"n_cols":24,"rows_kept":162,"cut":false,"hidden":false,"merged":[[1,1,1,23],[4,13,6,13],[4,21,4,23],[3,13,3,23],[20,21,20,22],[4,14,6,14],[4,16,6,16],[5,22,6,22],[5,21,6,21],[4,20,6,20],[4,19,6,19],[4,18,6,18],[4,17,6,17],[18,14,18,19],[18,21,18,23],[5,23,6,23],[99,14,99,19],[101,1,101,4],[3,1,3,10],[86,14,86,19],[102,16,102,21],[98,1,99,2],[78,13,78,16],[90,15,90,20],[27,1,27,10],[25,13,25,23],[4,15,6,15],[68,2,68,3],[26,1,26,9],[161,1,161,4],[65,6,65,10],[88,6,88,10],[86,6,86,10],[101,6,102,10]]}
[]
[null,"BMP Efficiency"]
[]
[null,"C Factor",null,null,null,null,null,null,null,null,null,null,null,"P Factor"]
[null,"Erosion Control BMP ","Sediment Removal Design Efficiency Range*","Chosen Efficiency ","Design Quality ","Instalation Quality","Maintenance Quality","Net Efficiency ","Individual C Factor","Percent Area Protected  (%)","Proportional C Factor",null,null,"Sediment Control BMP ","Sediment Removal Design Efficiency Range*","Chosen Efficiency","Design Quality","Instalation Quality","Maintenance  Quality ","Net Efficiency ","Individual P Factor","Number of BMPs In Each Sub Catchment "]
[null,"Bare soil ",1,null,1,1,1,{"$f":"D6*E6*F6*G6","v":0},{"$f":"1-H6","v":1},100,{"$f":"J6/100*I6","v":1},null,null,null,null,null,null,null,null,null,null,"C1","C2","C3"]
[null,"Asphalt/concrete pavement",0.01,null,1,1,1,{"$f":"D7*E7*F7*G7","v":0},{"$f":"1-H7","v":1},0,{"$f":"J7/100*I7","v":0}]
[null,"Hydroseeding-hydromulching","0.55 - 0.75",null,1,1,1,{"$f":"D8*E8*F8*G8","v":0},{"$f":"1-H8","v":1},0,{"$f":"J8/100*I8","v":0},null,null,"Vegetated buffer","0.20 - 0.80",null,1,1,1,{"$f":"P8*Q8*R8*S8","v":0},{"$f":"1-T8","v":1},0,0,0]
[null,"Mulching (see below Table 1)","0.00 - 1.00",null,1,1,1,0,1,0,0,null,null,"Rock check dam",0.8,null,1,1,1,{"$f":"P9*Q9*R9*S9","v":0},1,0,0,0]
[null,"Crushed stone or riprap","0.95 - 0.98",null,1,1,1,0,1,0,0,null,null,"Compost filter sock","0.20 - 0.50",null,1,1,1,0,1,0,0,0]
[null,"Chemical stabilization","0.70 - 0.90",null,1,1,1,{"$f":"D11*E11*F11*G11","v":0},{"$f":"1-H11","v":1},0,{"$f":"J11/100*I11","v":0},null,null,"Straw bale barrier","0.00 - 0.90",null,1,1,1,{"$f":"P11*Q11*R11*S11","v":0},{"$f":"1-T11","v":1},0,0,0]
[null,"Slope texturing / roughening ","0.10 - 0.75",null,1,1,1,0,1,0,0,null,null,"Silt fence (see below Table 5)","0.00 - 1.00",null,1,1,1,{"$f":"P12*Q12*R12*S12","v":0},{"$f":"1-T12","v":1},0,0,0]
[null,"Sodding","0.98 - 0.99",null,1,1,1,0,1,0,0,null,null,"Terracing","0.82 - 0.90",null,1,1,1,{"$f":"P13*Q13*R13*S13","v":0},{"$f":"1-T13","v":1},0,0,0]
[null,"Erosion control blanket/ RECP","0.70 - 1.00",null,null,null,null,null,1,null,null,null,null,"Sediment traps ","0.00 - 1.00",null,1,1,1,0,1,0,0,0]
[null,"Straw blanket","0.80 - 0.90",null,1,1,1,0,1,0,0,null,null,"Sediment pond","0.10 - 0.90",null,1,1,1,{"$f":"P15*Q16*R15*S15","v":0},1,0,0,0]
[null,"Compost blanket","0.60 - 0.80",null,1,1,1,{"$f":"D16*E16*F16*G16","v":0},{"$f":"1-H16","v":1},0,{"$f":"J16/100*I16","v":0},null,null,null,null,null,1,1,1,{"$f":"P16*Q17*R16*S16","v":0},1,0,0,0]
[null,"Permanent pasture, range, and idle land (see below Table 2)","0.55 - 1.00",null,1,1,1,{"$f":"D17*E17*F17*G17","v":0},{"$f":"1-H17","v":1},0,{"$f":"J17/100*I17","v":0},null,null,null,null,null,1,1,1,0,1,0,0,0]
[null,"Disturbed soil stabilized by vegetation","0.50 - 1.00",null,1,1,1,0,1,0,0,null,null,null,null,null,1,1,1,0,1,0,0,0]
[null,"Orchard / fruit trees","0.60 - 1.00",null,1,1,1,0,1,0,0,null,null,"None"," ---------------------------------------- NA ----------------------------------------",null,null,null,null,null,1," -------------------- NA --------------------"]
[null,"Grain corn","0.55 - 0.60",null,1,1,1,0,1,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"($U$8^V8)*($U$9^V9)*($U$10^V10)*($U$13^V13)*($U$15^V15)*($U$14^V14)*($U$12^V12)*($U$11^V11)*($U$19)*($U$16^V16)*($U$17^V17)*($U$18^V18)","v":1},{"$f":"($U$8^W8)*($U$9^W9)*($U$10^W10)*($U$13^W13)*($U$15^W15)*($U$14^W14)*($U$12^W12)*($U$11^W11)*($U$19)*($U$16^W16)*($U$17^W17)*($U$18^W18)","v":1},1]
[null,"Grass (see below Table 3)","0.70 - 1.00",null,1,1,1,0,1,0,0,null,null,"Sub Catchment ID","Area (ha)",null,null,"Total Area (ha):",{"$f":"'Soil Loss '!D10","v":0},null,null,"Area Weighted P Factor",null,{"$f":"IF((SUM(V8:X15)=0),U19, (O22/O25*V20) +(O23/O25*W20)+(O24/O25*X20))","v":1}]
[null,"Hay","0.70 -0.90",null,1,1,1,0,1,0,0,null,null,"C1",0]
[null,"Undisturbed forest (see below Table 4)","0.99 - 1.00",null,1,1,1,{"$f":"D23*E23*F23*G23","v":0},{"$f":"1-H23","v":1},0,{"$f":"J23/100*I23","v":0},null,null,"C2",0]
[null,"Silage corn, beans & canola","0.45 - 0.85",null,1,1,1,{"$f":"D24*E24*F24*G24","v":0},{"$f":"1-H24","v":1},0,{"$f":"J24/100*I24","v":0},null,null,"C3",0]
[null,null,null,null,1,1,1,{"$f":"D25*E25*F25*G25","v":0},{"$f":"1-H25","v":1},0,{"$f":"J25/100*I25","v":0},null,null,"TOTAL",{"$f":"SUM(O22:O24)","v":0}]
[null,null,null,null,1,1,1,0,1,0,0,null,null,"* BMP efficiency depends on many site specific conditions (particle size, slope, climate, etc.) which should be considered when assigning this value. This range is given as a suggestion only. Your BMP efficiency may not be within the provided range. Supporting documentation should be consulted to ensure an adequate BMP efficiency value is assigned.Efficiency values obtained may be rounded down to the nearest 0.05. Other BMPs can be used but should be supported by documentation."]
[null,"Area-Weighted C Factor",null,null,null,null,null,null,null,null,{"$f":"SUM(K6:K26)","v":1},null,null,"Notes"]
[null,"* BMP efficiency depends on many site specific conditions (particle size, slope, climate, etc.) which should be considered when assigning this value. This range is given as a suggestion only. Your BMP efficiency may not be within the provided range. Supporting documentation should be consulted to ensure an adequate BMP efficiency value is assigned. Efficiency values obtained may be rounded down to the nearest 0.05. Other BMPs can be used but should be supported by documentation.",null,null,null,null,null,null,null,null,null,null,null," - Different subcatchments can be used to seperate areas that have the same ground cover (C Factor) but have different sediment erosion BMPs (P Factors)"]
[null,"Notes",null,null,null,null,null,null,null,null,null,null,null," - Net efficiency for individual BMP must be consistent over entire P Factor calculation"]
[null," - You can not have more than one surface cover per unit area eg. surface roughening with seeding",null,null,null,null,null,null,null,null,null,null,null," - If there are no ubcatchments in the Parcel ID, enter the entire area within \"C1\""]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[]
[]
[]
[null,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.95,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.9,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.85,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.7,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.65,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.55000000000000004,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.45,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.35,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,20]
[null,"Table 1: Mulch efficiency values from USEPA (1993)",null,null,null,null,"Table 3: Grass or weed C factor determination. Figure from Fifield (2011) based on data  from Wischmeier & Smith (1978)",null,null,null,null,null,null,"Table 4: Silt Fence efficiency values from USEPA (1993)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"The efficiency of the silt fence material can be selected from the range that corresponds to the dominant soil type of the site."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," The above Table 3 is given as the C Factor, not the efficiency. Find the corresponding value for your site conditions, and subtract this from 1 to get the efficiency value to input in the above \"Chosen Efficiency\" column."]
[]
[null,null,null,null,null,null,"Table 4: Undisturbed forest land C factor determination  from Wischmeier & Smith (1978)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"An efficiency value can be obtained from Table 1 by selecting the corresponding soil, slope, and mulch type that most accurately correspond to your site conditions. If no exact match is available, extrapolate from the information available."]
[]
[]
[null,"Table 2: C Factor values for permanent pasture, range and idle land from Wischmeier & Smith (1978)",null,null,null,null," The above Table 4 is given as the C Factor, not the efficiency. Find the corresponding value for your site conditions, and subtract this from 1 to get the efficiency value to input in the above \"Chosen Efficiency\" column."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," The above Table 2 is given as the C Factor, not the efficiency. Find the corresponding value for your site conditions, and subtract this from 1 to get the efficiency value to input in the above \"Chosen Efficiency\" column."]

{"sheet":"BMPs - 2","index":6,"n_rows":162,"n_cols":24,"rows_kept":162,"cut":false,"hidden":false,"merged":[[1,1,1,23],[3,1,3,10],[3,13,3,23],[4,13,6,13],[4,14,6,14],[4,15,6,15],[4,16,6,16],[4,17,6,17],[4,18,6,18],[4,19,6,19],[68,2,68,3],[4,20,6,20],[4,21,4,23],[5,21,6,21],[5,22,6,22],[5,23,6,23],[18,14,18,19],[18,21,18,23],[20,21,20,22],[25,13,25,23],[26,1,26,9],[27,1,27,10],[65,6,65,10],[101,1,101,4],[101,6,102,10],[102,16,102,21],[161,1,161,4],[78,13,78,16],[86,6,86,10],[86,14,86,19],[88,6,88,10],[90,15,90,20],[98,1,99,2],[99,14,99,19]]}
[]
[null,"BMP Efficiency "]
[]
[null,"C Factor",null,null,null,null,null,null,null,null,null,null,null,"P Factor"]
[null,"Erosion Control BMP ","Sediment Removal Design Efficiency Range*","Chosen Efficiency ","Design Quality ","Instalation Quality","Maintenance Quality","Net Efficiency ","Individual C Factor","Percent Area Protected  (%)","Proportional C Factor",null,null,"Sediment Control BMP ","Sediment Removal Design Efficiency Range*","Chosen Efficiency","Design Quality","Instalation Quality","Maintenance  Quality ","Net Efficiency ","Individual P Factor","Number of BMPs In Each Sub Catchment "]
[null,"Bare soil ",1,null,1,1,1,{"$f":"D6*E6*F6*G6","v":0},{"$f":"1-H6","v":1},100,{"$f":"J6/100*I6","v":1},null,null,null,null,null,null,null,null,null,null,"C1","C2","C3"]
[null,"Asphalt/concrete pavement",0.01,null,1,1,1,{"$f":"D7*E7*F7*G7","v":0},{"$f":"1-H7","v":1},0,{"$f":"J7/100*I7","v":0}]
[null,"Hydroseeding-hydromulching","0.55 - 0.75",null,1,1,1,{"$f":"D8*E8*F8*G8","v":0},{"$f":"1-H8","v":1},0,{"$f":"J8/100*I8","v":0},null,null,"Vegetated buffer","0.20 - 0.80",null,1,1,1,{"$f":"P8*Q8*R8*S8","v":0},{"$f":"1-T8","v":1},0,0,0]
[null,"Mulching (see below Table 1)","0.00 - 1.00",null,1,1,1,0,1,0,0,null,null,"Rock check dam",0.8,null,1,1,1,{"$f":"P9*Q9*R9*S9","v":0},1,0,0,0]
[null,"Crushed stone or riprap","0.95 - 0.98",null,1,1,1,0,1,0,0,null,null,"Compost filter sock","0.20 - 0.50",null,1,1,1,0,1,0,0,0]
[null,"Chemical stabilization","0.70 - 0.90",null,1,1,1,{"$f":"D11*E11*F11*G11","v":0},{"$f":"1-H11","v":1},0,{"$f":"J11/100*I11","v":0},null,null,"Straw bale barrier","0.00 - 0.90",null,1,1,1,{"$f":"P11*Q11*R11*S11","v":0},{"$f":"1-T11","v":1},0,0,0]
[null,"Slope texturing / roughening ","0.10 - 0.75",null,1,1,1,0,1,0,0,null,null,"Silt fence (see below Table 5)","0.00 - 1.00",null,1,1,1,{"$f":"P12*Q12*R12*S12","v":0},{"$f":"1-T12","v":1},0,0,0]
[null,"Sodding","0.98 - 0.99",null,1,1,1,0,1,0,0,null,null,"Terracing","0.82 - 0.90",null,1,1,1,{"$f":"P13*Q13*R13*S13","v":0},{"$f":"1-T13","v":1},0,0,0]
[null,"Erosion control blanket/ RECP","0.70 - 1.00",null,null,null,null,null,1,null,null,null,null,"Sediment traps ","0.00 - 1.00",null,1,1,1,0,1,0,0,0]
[null,"Straw blanket","0.80 - 0.90",null,1,1,1,0,1,0,0,null,null,"Sediment pond","0.10 - 0.90",null,1,1,1,{"$f":"P15*Q16*R15*S15","v":0},1,0,0,0]
[null,"Compost blanket","0.60 - 0.80",null,1,1,1,{"$f":"D16*E16*F16*G16","v":0},{"$f":"1-H16","v":1},0,{"$f":"J16/100*I16","v":0},null,null,null,null,null,1,1,1,{"$f":"P16*Q17*R16*S16","v":0},1,0,0,0]
[null,"Permanent pasture, range, and idle land (see below Table 2)","0.55 - 1.00",null,1,1,1,{"$f":"D17*E17*F17*G17","v":0},{"$f":"1-H17","v":1},0,{"$f":"J17/100*I17","v":0},null,null,null,null,null,1,1,1,0,1,0,0,0]
[null,"Disturbed soil stabilized by vegetation","0.50 - 1.00",null,1,1,1,0,1,0,0,null,null,null,null,null,1,1,1,0,1,0,0,0]
[null,"Orchard / fruit trees","0.60 - 1.00",null,1,1,1,0,1,0,0,null,null,"None"," ---------------------------------------- NA ----------------------------------------",null,null,null,null,null,1," -------------------- NA --------------------"]
[null,"Grain corn","0.55 - 0.60",null,1,1,1,0,1,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"($U$8^V8)*($U$9^V9)*($U$10^V10)*($U$13^V13)*($U$15^V15)*($U$14^V14)*($U$12^V12)*($U$11^V11)*($U$19)*($U$16^V16)*($U$17^V17)*($U$18^V18)","v":1},{"$f":"($U$8^W8)*($U$9^W9)*($U$10^W10)*($U$13^W13)*($U$15^W15)*($U$14^W14)*($U$12^W12)*($U$11^W11)*($U$19)*($U$16^W16)*($U$17^W17)*($U$18^W18)","v":1},1]
[null,"Grass (see below Table 3)","0.70 - 1.00",null,1,1,1,0,1,0,0,null,null,"Sub Catchment ID","Area (ha)",null,null,"Total Area (ha):",{"$f":"'Soil Loss '!D10","v":0},null,null,"Area Weighted P Factor",null,{"$f":"IF((SUM(V8:X15)=0),U19, (O22/O25*V20) +(O23/O25*W20)+(O24/O25*X20))","v":1}]
[null,"Hay","0.70 -0.90",null,1,1,1,0,1,0,0,null,null,"C1",0]
[null,"Undisturbed forest (see below Table 4)","0.99 - 1.00",null,1,1,1,{"$f":"D23*E23*F23*G23","v":0},{"$f":"1-H23","v":1},0,{"$f":"J23/100*I23","v":0},null,null,"C2",0]
[null,"Silage corn, beans & canola","0.45 - 0.85",null,1,1,1,{"$f":"D24*E24*F24*G24","v":0},{"$f":"1-H24","v":1},0,{"$f":"J24/100*I24","v":0},null,null,"C3",0]
[null,null,null,null,1,1,1,{"$f":"D25*E25*F25*G25","v":0},{"$f":"1-H25","v":1},0,{"$f":"J25/100*I25","v":0},null,null,"TOTAL",{"$f":"SUM(O22:O24)","v":0}]
[null,null,null,null,1,1,1,0,1,0,0,null,null,"* BMP efficiency depends on many site specific conditions (particle size, slope, climate, etc.) which should be considered when assigning this value. This range is given as a suggestion only. Your BMP efficiency may not be within the provided range. Supporting documentation should be consulted to ensure an adequate BMP efficiency value is assigned.Efficiency values obtained may be rounded down to the nearest 0.05. Other BMPs can be used but should be supported by documentation."]
[null,"Area-Weighted C Factor",null,null,null,null,null,null,null,null,{"$f":"SUM(K6:K26)","v":1},null,null,"Notes"]
[null,"* BMP efficiency depends on many site specific conditions (particle size, slope, climate, etc.) which should be considered when assigning this value. This range is given as a suggestion only. Your BMP efficiency may not be within the provided range. Supporting documentation should be consulted to ensure an adequate BMP efficiency value is assigned. Efficiency values obtained may be rounded down to the nearest 0.05. Other BMPs can be used but should be supported by documentation.",null,null,null,null,null,null,null,null,null,null,null," - Different subcatchments can be used to seperate areas that have the same ground cover (C Factor) but have different sediment erosion BMPs (P Factors)"]
[null,"Notes",null,null,null,null,null,null,null,null,null,null,null," - Net efficiency for individual BMP must be consistent over entire P Factor calculation"]
[null," - You can not have more than one surface cover per unit area eg. surface roughening with seeding",null,null,null,null,null,null,null,null,null,null,null," - If there are no ubcatchments in the Parcel ID, enter the entire area within \"C1\""]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[]
[]
[]
[null,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.95,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.9,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.85,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.7,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.65,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.55000000000000004,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.45,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.35,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,20]
[null,"Table 1: Mulch efficiency values from USEPA (1993)",null,null,null,null,"Table 3: Grass or weed C factor determination. Figure from Fifield (2011) based on data  from Wischmeier & Smith (1978)",null,null,null,null,null,null,"Table 4: Silt Fence efficiency values from USEPA (1993)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"The efficiency of the silt fence material can be selected from the range that corresponds to the dominant soil type of the site."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," The above Table 3 is given as the C Factor, not the efficiency. Find the corresponding value for your site conditions, and subtract this from 1 to get the efficiency value to input in the above \"Chosen Efficiency\" column."]
[]
[null,null,null,null,null,null,"Table 4: Undisturbed forest land C factor determination  from Wischmeier & Smith (1978)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"An efficiency value can be obtained from Table 1 by selecting the corresponding soil, slope, and mulch type that most accurately correspond to your site conditions. If no exact match is available, extrapolate from the information available."]
[]
[]
[null,"Table 2: C Factor values for permanent pasture, range and idle land from Wischmeier & Smith (1978)",null,null,null,null," The above Table 4 is given as the C Factor, not the efficiency. Find the corresponding value for your site conditions, and subtract this from 1 to get the efficiency value to input in the above \"Chosen Efficiency\" column."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," The above Table 2 is given as the C Factor, not the efficiency. Find the corresponding value for your site conditions, and subtract this from 1 to get the efficiency value to input in the above \"Chosen Efficiency\" column."]

{"sheet":"BMPs - 3","index":7,"n_rows":162,"n_cols":24,"rows_kept":162,"cut":false,"hidden":false,"merged":[[1,1,1,23],[3,1,3,10],[3,13,3,23],[4,13,6,13],[4,14,6,14],[4,15,6,15],[4,16,6,16],[4,17,6,17],[4,18,6,18],[4,19,6,19],[68,2,68,3],[4,20,6,20],[4,21,4,23],[5,21,6,21],[5,22,6,22],[5,23,6,23],[18,14,18,19],[18,21,18,23],[20,21,20,22],[25,13,25,23],[26,1,26,9],[27,1,27,10],[65,6,65,10],[101,1,101,4],[101,6,102,10],[102,16,102,21],[161,1,161,4],[78,13,78,16],[86,6,86,10],[86,14,86,19],[88,6,88,10],[90,15,90,20],[98,1,99,2],[99,14,99,19]]}
[]
[null,"BMP Efficiency "]
[]
[null,"C Factor",null,null,null,null,null,null,null,null,null,null,null,"P Factor"]
[null,"Erosion Control BMP ","Sediment Removal Design Efficiency Range*","Chosen Efficiency ","Design Quality ","Instalation Quality","Maintenance Quality","Net Efficiency ","Individual C Factor","Percent Area Protected  (%)","Proportional C Factor",null,null,"Sediment Control BMP ","Sediment Removal Design Efficiency Range*","Chosen Efficiency","Design Quality","Instalation Quality","Maintenance  Quality ","Net Efficiency ","Individual P Factor","Number of BMPs In Each Sub Catchment "]
[null,"Bare soil ",1,null,1,1,1,{"$f":"D6*E6*F6*G6","v":0},{"$f":"1-H6","v":1},100,{"$f":"J6/100*I6","v":1},null,null,null,null,null,null,null,null,null,null,"C1","C2","C3"]
[null,"Asphalt/concrete pavement",0.01,null,1,1,1,{"$f":"D7*E7*F7*G7","v":0},{"$f":"1-H7","v":1},0,{"$f":"J7/100*I7","v":0}]
[null,"Hydroseeding-hydromulching","0.55 - 0.75",null,1,1,1,{"$f":"D8*E8*F8*G8","v":0},{"$f":"1-H8","v":1},0,{"$f":"J8/100*I8","v":0},null,null,"Vegetated buffer","0.20 - 0.80",null,1,1,1,{"$f":"P8*Q8*R8*S8","v":0},{"$f":"1-T8","v":1},0,0,0]
[null,"Mulching (see below Table 1)","0.00 - 1.00",null,1,1,1,0,1,0,0,null,null,"Rock check dam",0.8,null,1,1,1,{"$f":"P9*Q9*R9*S9","v":0},1,0,0,0]
[null,"Crushed stone or riprap","0.95 - 0.98",null,1,1,1,0,1,0,0,null,null,"Compost filter sock","0.20 - 0.50",null,1,1,1,0,1,0,0,0]
[null,"Chemical stabilization","0.70 - 0.90",null,1,1,1,{"$f":"D11*E11*F11*G11","v":0},{"$f":"1-H11","v":1},0,{"$f":"J11/100*I11","v":0},null,null,"Straw bale barrier","0.00 - 0.90",null,1,1,1,{"$f":"P11*Q11*R11*S11","v":0},{"$f":"1-T11","v":1},0,0,0]
[null,"Slope texturing / roughening ","0.10 - 0.75",null,1,1,1,0,1,0,0,null,null,"Silt fence (see below Table 5)","0.00 - 1.00",null,1,1,1,{"$f":"P12*Q12*R12*S12","v":0},{"$f":"1-T12","v":1},0,0,0]
[null,"Sodding","0.98 - 0.99",null,1,1,1,0,1,0,0,null,null,"Terracing","0.82 - 0.90",null,1,1,1,{"$f":"P13*Q13*R13*S13","v":0},{"$f":"1-T13","v":1},0,0,0]
[null,"Erosion control blanket/ RECP","0.70 - 1.00",null,null,null,null,null,1,null,null,null,null,"Sediment traps ","0.00 - 1.00",null,1,1,1,0,1,0,0,0]
[null,"Straw blanket","0.80 - 0.90",null,1,1,1,0,1,0,0,null,null,"Sediment pond","0.10 - 0.90",null,1,1,1,{"$f":"P15*Q16*R15*S15","v":0},1,0,0,0]
[null,"Compost blanket","0.60 - 0.80",null,1,1,1,{"$f":"D16*E16*F16*G16","v":0},{"$f":"1-H16","v":1},0,{"$f":"J16/100*I16","v":0},null,null,null,null,null,1,1,1,{"$f":"P16*Q17*R16*S16","v":0},1,0,0,0]
[null,"Permanent pasture, range, and idle land (see below Table 2)","0.55 - 1.00",null,1,1,1,{"$f":"D17*E17*F17*G17","v":0},{"$f":"1-H17","v":1},0,{"$f":"J17/100*I17","v":0},null,null,null,null,null,1,1,1,0,1,0,0,0]
[null,"Disturbed soil stabilized by vegetation","0.50 - 1.00",null,1,1,1,0,1,0,0,null,null,null,null,null,1,1,1,0,1,0,0,0]
[null,"Orchard / fruit trees","0.60 - 1.00",null,1,1,1,0,1,0,0,null,null,"None"," ---------------------------------------- NA ----------------------------------------",null,null,null,null,null,1," -------------------- NA --------------------"]
[null,"Grain corn","0.55 - 0.60",null,1,1,1,0,1,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"($U$8^V8)*($U$9^V9)*($U$10^V10)*($U$13^V13)*($U$15^V15)*($U$14^V14)*($U$12^V12)*($U$11^V11)*($U$19)*($U$16^V16)*($U$17^V17)*($U$18^V18)","v":1},{"$f":"($U$8^W8)*($U$9^W9)*($U$10^W10)*($U$13^W13)*($U$15^W15)*($U$14^W14)*($U$12^W12)*($U$11^W11)*($U$19)*($U$16^W16)*($U$17^W17)*($U$18^W18)","v":1},1]
[null,"Grass (see below Table 3)","0.70 - 1.00",null,1,1,1,0,1,0,0,null,null,"Sub Catchment ID","Area (ha)",null,null,"Total Area (ha):",{"$f":"'Soil Loss '!D10","v":0},null,null,"Area Weighted P Factor",null,{"$f":"IF((SUM(V8:X15)=0),U19, (O22/O25*V20) +(O23/O25*W20)+(O24/O25*X20))","v":1}]
[null,"Hay","0.70 -0.90",null,1,1,1,0,1,0,0,null,null,"C1",0]
[null,"Undisturbed forest (see below Table 4)","0.99 - 1.00",null,1,1,1,{"$f":"D23*E23*F23*G23","v":0},{"$f":"1-H23","v":1},0,{"$f":"J23/100*I23","v":0},null,null,"C2",0]
[null,"Silage corn, beans & canola","0.45 - 0.85",null,1,1,1,{"$f":"D24*E24*F24*G24","v":0},{"$f":"1-H24","v":1},0,{"$f":"J24/100*I24","v":0},null,null,"C3",0]
[null,null,null,null,1,1,1,{"$f":"D25*E25*F25*G25","v":0},{"$f":"1-H25","v":1},0,{"$f":"J25/100*I25","v":0},null,null,"TOTAL",{"$f":"SUM(O22:O24)","v":0}]
[null,null,null,null,1,1,1,0,1,0,0,null,null,"* BMP efficiency depends on many site specific conditions (particle size, slope, climate, etc.) which should be considered when assigning this value. This range is given as a suggestion only. Your BMP efficiency may not be within the provided range. Supporting documentation should be consulted to ensure an adequate BMP efficiency value is assigned.Efficiency values obtained may be rounded down to the nearest 0.05. Other BMPs can be used but should be supported by documentation."]
[null,"Area-Weighted C Factor",null,null,null,null,null,null,null,null,{"$f":"SUM(K6:K26)","v":1},null,null,"Notes"]
[null,"* BMP efficiency depends on many site specific conditions (particle size, slope, climate, etc.) which should be considered when assigning this value. This range is given as a suggestion only. Your BMP efficiency may not be within the provided range. Supporting documentation should be consulted to ensure an adequate BMP efficiency value is assigned. Efficiency values obtained may be rounded down to the nearest 0.05. Other BMPs can be used but should be supported by documentation.",null,null,null,null,null,null,null,null,null,null,null," - Different subcatchments can be used to seperate areas that have the same ground cover (C Factor) but have different sediment erosion BMPs (P Factors)"]
[null,"Notes",null,null,null,null,null,null,null,null,null,null,null," - Net efficiency for individual BMP must be consistent over entire P Factor calculation"]
[null," - You can not have more than one surface cover per unit area eg. surface roughening with seeding",null,null,null,null,null,null,null,null,null,null,null," - If there are no ubcatchments in the Parcel ID, enter the entire area within \"C1\""]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[]
[]
[]
[null,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.95,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.9,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.85,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.7,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.65,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.55000000000000004,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.45,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.35,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,20]
[null,"Table 1: Mulch efficiency values from USEPA (1993)",null,null,null,null,"Table 3: Grass or weed C factor determination. Figure from Fifield (2011) based on data  from Wischmeier & Smith (1978)",null,null,null,null,null,null,"Table 4: Silt Fence efficiency values from USEPA (1993)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"The efficiency of the silt fence material can be selected from the range that corresponds to the dominant soil type of the site."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," The above Table 3 is given as the C Factor, not the efficiency. Find the corresponding value for your site conditions, and subtract this from 1 to get the efficiency value to input in the above \"Chosen Efficiency\" column."]
[]
[null,null,null,null,null,null,"Table 4: Undisturbed forest land C factor determination  from Wischmeier & Smith (1978)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"An efficiency value can be obtained from Table 1 by selecting the corresponding soil, slope, and mulch type that most accurately correspond to your site conditions. If no exact match is available, extrapolate from the information available."]
[]
[]
[null,"Table 2: C Factor values for permanent pasture, range and idle land from Wischmeier & Smith (1978)",null,null,null,null," The above Table 4 is given as the C Factor, not the efficiency. Find the corresponding value for your site conditions, and subtract this from 1 to get the efficiency value to input in the above \"Chosen Efficiency\" column."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," The above Table 2 is given as the C Factor, not the efficiency. Find the corresponding value for your site conditions, and subtract this from 1 to get the efficiency value to input in the above \"Chosen Efficiency\" column."]

{"sheet":"BMPs - 4","index":8,"n_rows":162,"n_cols":24,"rows_kept":162,"cut":false,"hidden":false,"merged":[[1,1,1,23],[3,1,3,10],[3,13,3,23],[4,13,6,13],[4,14,6,14],[4,15,6,15],[4,16,6,16],[4,17,6,17],[4,18,6,18],[4,19,6,19],[68,2,68,3],[4,20,6,20],[4,21,4,23],[5,21,6,21],[5,22,6,22],[5,23,6,23],[18,14,18,19],[18,21,18,23],[20,21,20,22],[25,13,25,23],[26,1,26,9],[27,1,27,10],[65,6,65,10],[101,1,101,4],[101,6,102,10],[102,16,102,21],[161,1,161,4],[78,13,78,16],[86,6,86,10],[86,14,86,19],[88,6,88,10],[90,15,90,20],[98,1,99,2],[99,14,99,19]]}
[]
[null,"BMP Efficiency "]
[]
[null,"C Factor",null,null,null,null,null,null,null,null,null,null,null,"P Factor"]
[null,"Erosion Control BMP ","Sediment Removal Design Efficiency Range*","Chosen Efficiency ","Design Quality ","Instalation Quality","Maintenance Quality","Net Efficiency ","Individual C Factor","Percent Area Protected  (%)","Proportional C Factor",null,null,"Sediment Control BMP ","Sediment Removal Design Efficiency Range*","Chosen Efficiency","Design Quality","Instalation Quality","Maintenance  Quality ","Net Efficiency ","Individual P Factor","Number of BMPs In Each Sub Catchment "]
[null,"Bare soil ",1,null,1,1,1,{"$f":"D6*E6*F6*G6","v":0},{"$f":"1-H6","v":1},100,{"$f":"J6/100*I6","v":1},null,null,null,null,null,null,null,null,null,null,"C1","C2","C3"]
[null,"Asphalt/concrete pavement",0.01,null,1,1,1,{"$f":"D7*E7*F7*G7","v":0},{"$f":"1-H7","v":1},0,{"$f":"J7/100*I7","v":0}]
[null,"Hydroseeding-hydromulching","0.55 - 0.75",null,1,1,1,{"$f":"D8*E8*F8*G8","v":0},{"$f":"1-H8","v":1},0,{"$f":"J8/100*I8","v":0},null,null,"Vegetated buffer","0.20 - 0.80",null,1,1,1,{"$f":"P8*Q8*R8*S8","v":0},{"$f":"1-T8","v":1},0,0,0]
[null,"Mulching (see below Table 1)","0.00 - 1.00",null,1,1,1,0,1,0,0,null,null,"Rock check dam",0.8,null,1,1,1,{"$f":"P9*Q9*R9*S9","v":0},1,0,0,0]
[null,"Crushed stone or riprap","0.95 - 0.98",null,1,1,1,0,1,0,0,null,null,"Compost filter sock","0.20 - 0.50",null,1,1,1,0,1,0,0,0]
[null,"Chemical stabilization","0.70 - 0.90",null,1,1,1,{"$f":"D11*E11*F11*G11","v":0},{"$f":"1-H11","v":1},0,{"$f":"J11/100*I11","v":0},null,null,"Straw bale barrier","0.00 - 0.90",null,1,1,1,{"$f":"P11*Q11*R11*S11","v":0},{"$f":"1-T11","v":1},0,0,0]
[null,"Slope texturing / roughening ","0.10 - 0.75",null,1,1,1,0,1,0,0,null,null,"Silt fence (see below Table 5)","0.00 - 1.00",null,1,1,1,{"$f":"P12*Q12*R12*S12","v":0},{"$f":"1-T12","v":1},0,0,0]
[null,"Sodding","0.98 - 0.99",null,1,1,1,0,1,0,0,null,null,"Terracing","0.82 - 0.90",null,1,1,1,{"$f":"P13*Q13*R13*S13","v":0},{"$f":"1-T13","v":1},0,0,0]
[null,"Erosion control blanket/ RECP","0.70 - 1.00",null,null,null,null,null,1,null,null,null,null,"Sediment traps ","0.00 - 1.00",null,1,1,1,0,1,0,0,0]
[null,"Straw blanket","0.80 - 0.90",null,1,1,1,0,1,0,0,null,null,"Sediment pond","0.10 - 0.90",null,1,1,1,{"$f":"P15*Q16*R15*S15","v":0},1,0,0,0]
[null,"Compost blanket","0.60 - 0.80",null,1,1,1,{"$f":"D16*E16*F16*G16","v":0},{"$f":"1-H16","v":1},0,{"$f":"J16/100*I16","v":0},null,null,null,null,null,1,1,1,{"$f":"P16*Q17*R16*S16","v":0},1,0,0,0]
[null,"Permanent pasture, range, and idle land (see below Table 2)","0.55 - 1.00",null,1,1,1,{"$f":"D17*E17*F17*G17","v":0},{"$f":"1-H17","v":1},0,{"$f":"J17/100*I17","v":0},null,null,null,null,null,1,1,1,0,1,0,0,0]
[null,"Disturbed soil stabilized by vegetation","0.50 - 1.00",null,1,1,1,0,1,0,0,null,null,null,null,null,1,1,1,0,1,0,0,0]
[null,"Orchard / fruit trees","0.60 - 1.00",null,1,1,1,0,1,0,0,null,null,"None"," ---------------------------------------- NA ----------------------------------------",null,null,null,null,null,1," -------------------- NA --------------------"]
[null,"Grain corn","0.55 - 0.60",null,1,1,1,0,1,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"($U$8^V8)*($U$9^V9)*($U$10^V10)*($U$13^V13)*($U$15^V15)*($U$14^V14)*($U$12^V12)*($U$11^V11)*($U$19)*($U$16^V16)*($U$17^V17)*($U$18^V18)","v":1},{"$f":"($U$8^W8)*($U$9^W9)*($U$10^W10)*($U$13^W13)*($U$15^W15)*($U$14^W14)*($U$12^W12)*($U$11^W11)*($U$19)*($U$16^W16)*($U$17^W17)*($U$18^W18)","v":1},1]
[null,"Grass (see below Table 3)","0.70 - 1.00",null,1,1,1,0,1,0,0,null,null,"Sub Catchment ID","Area (ha)",null,null,"Total Area (ha):",{"$f":"'Soil Loss '!D10","v":0},null,null,"Area Weighted P Factor",null,{"$f":"IF((SUM(V8:X15)=0),U19, (O22/O25*V20) +(O23/O25*W20)+(O24/O25*X20))","v":1}]
[null,"Hay","0.70 -0.90",null,1,1,1,0,1,0,0,null,null,"C1",0]
[null,"Undisturbed forest (see below Table 4)","0.99 - 1.00",null,1,1,1,{"$f":"D23*E23*F23*G23","v":0},{"$f":"1-H23","v":1},0,{"$f":"J23/100*I23","v":0},null,null,"C2",0]
[null,"Silage corn, beans & canola","0.45 - 0.85",null,1,1,1,{"$f":"D24*E24*F24*G24","v":0},{"$f":"1-H24","v":1},0,{"$f":"J24/100*I24","v":0},null,null,"C3",0]
[null,null,null,null,1,1,1,{"$f":"D25*E25*F25*G25","v":0},{"$f":"1-H25","v":1},0,{"$f":"J25/100*I25","v":0},null,null,"TOTAL",{"$f":"SUM(O22:O24)","v":0}]
[null,null,null,null,1,1,1,0,1,0,0,null,null,"* BMP efficiency depends on many site specific conditions (particle size, slope, climate, etc.) which should be considered when assigning this value. This range is given as a suggestion only. Your BMP efficiency may not be within the provided range. Supporting documentation should be consulted to ensure an adequate BMP efficiency value is assigned.Efficiency values obtained may be rounded down to the nearest 0.05. Other BMPs can be used but should be supported by documentation."]
[null,"Area-Weighted C Factor",null,null,null,null,null,null,null,null,{"$f":"SUM(K6:K26)","v":1},null,null,"Notes"]
[null,"* BMP efficiency depends on many site specific conditions (particle size, slope, climate, etc.) which should be considered when assigning this value. This range is given as a suggestion only. Your BMP efficiency may not be within the provided range. Supporting documentation should be consulted to ensure an adequate BMP efficiency value is assigned. Efficiency values obtained may be rounded down to the nearest 0.05. Other BMPs can be used but should be supported by documentation.",null,null,null,null,null,null,null,null,null,null,null," - Different subcatchments can be used to seperate areas that have the same ground cover (C Factor) but have different sediment erosion BMPs (P Factors)"]
[null,"Notes",null,null,null,null,null,null,null,null,null,null,null," - Net efficiency for individual BMP must be consistent over entire P Factor calculation"]
[null," - You can not have more than one surface cover per unit area eg. surface roughening with seeding",null,null,null,null,null,null,null,null,null,null,null," - If there are no ubcatchments in the Parcel ID, enter the entire area within \"C1\""]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[]
[]
[]
[null,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.95,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.9,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.85,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.7,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.65,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.55000000000000004,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.45,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.35,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,20]
[null,"Table 1: Mulch efficiency values from USEPA (1993)",null,null,null,null,"Table 3: Grass or weed C factor determination. Figure from Fifield (2011) based on data  from Wischmeier & Smith (1978)",null,null,null,null,null,null,"Table 4: Silt Fence efficiency values from USEPA (1993)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"The efficiency of the silt fence material can be selected from the range that corresponds to the dominant soil type of the site."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," The above Table 3 is given as the C Factor, not the efficiency. Find the corresponding value for your site conditions, and subtract this from 1 to get the efficiency value to input in the above \"Chosen Efficiency\" column."]
[]
[null,null,null,null,null,null,"Table 4: Undisturbed forest land C factor determination  from Wischmeier & Smith (1978)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"An efficiency value can be obtained from Table 1 by selecting the corresponding soil, slope, and mulch type that most accurately correspond to your site conditions. If no exact match is available, extrapolate from the information available."]
[]
[]
[null,"Table 2: C Factor values for permanent pasture, range and idle land from Wischmeier & Smith (1978)",null,null,null,null," The above Table 4 is given as the C Factor, not the efficiency. Find the corresponding value for your site conditions, and subtract this from 1 to get the efficiency value to input in the above \"Chosen Efficiency\" column."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," The above Table 2 is given as the C Factor, not the efficiency. Find the corresponding value for your site conditions, and subtract this from 1 to get the efficiency value to input in the above \"Chosen Efficiency\" column."]

{"sheet":"BMPs - 5","index":9,"n_rows":162,"n_cols":24,"rows_kept":162,"cut":false,"hidden":false,"merged":[[1,1,1,23],[3,1,3,10],[3,13,3,23],[4,13,6,13],[4,14,6,14],[4,15,6,15],[4,16,6,16],[4,17,6,17],[4,18,6,18],[4,19,6,19],[68,2,68,3],[4,20,6,20],[4,21,4,23],[5,21,6,21],[5,22,6,22],[5,23,6,23],[18,14,18,19],[18,21,18,23],[20,21,20,22],[25,13,25,23],[26,1,26,9],[27,1,27,10],[65,6,65,10],[101,1,101,4],[101,6,102,10],[102,16,102,21],[161,1,161,4],[78,13,78,16],[86,6,86,10],[86,14,86,19],[88,6,88,10],[90,15,90,20],[98,1,99,2],[99,14,99,19]]}
[]
[null,"BMP Efficiency "]
[]
[null,"C Factor",null,null,null,null,null,null,null,null,null,null,null,"P Factor"]
[null,"Erosion Control BMP ","Sediment Removal Design Efficiency Range*","Chosen Efficiency ","Design Quality ","Instalation Quality","Maintenance Quality","Net Efficiency ","Individual C Factor","Percent Area Protected  (%)","Proportional C Factor",null,null,"Sediment Control BMP ","Sediment Removal Design Efficiency Range*","Chosen Efficiency","Design Quality","Instalation Quality","Maintenance  Quality ","Net Efficiency ","Individual P Factor","Number of BMPs In Each Sub Catchment "]
[null,"Bare soil ",1,null,1,1,1,{"$f":"D6*E6*F6*G6","v":0},{"$f":"1-H6","v":1},100,{"$f":"J6/100*I6","v":1},null,null,null,null,null,null,null,null,null,null,"C1","C2","C3"]
[null,"Asphalt/concrete pavement",0.01,null,1,1,1,{"$f":"D7*E7*F7*G7","v":0},{"$f":"1-H7","v":1},0,{"$f":"J7/100*I7","v":0}]
[null,"Hydroseeding-hydromulching","0.55 - 0.75",null,1,1,1,{"$f":"D8*E8*F8*G8","v":0},{"$f":"1-H8","v":1},0,{"$f":"J8/100*I8","v":0},null,null,"Vegetated buffer","0.20 - 0.80",null,1,1,1,{"$f":"P8*Q8*R8*S8","v":0},{"$f":"1-T8","v":1},0,0,0]
[null,"Mulching (see below Table 1)","0.00 - 1.00",null,1,1,1,0,1,0,0,null,null,"Rock check dam",0.8,null,1,1,1,{"$f":"P9*Q9*R9*S9","v":0},1,0,0,0]
[null,"Crushed stone or riprap","0.95 - 0.98",null,1,1,1,0,1,0,0,null,null,"Compost filter sock","0.20 - 0.50",null,1,1,1,0,1,0,0,0]
[null,"Chemical stabilization","0.70 - 0.90",null,1,1,1,{"$f":"D11*E11*F11*G11","v":0},{"$f":"1-H11","v":1},0,{"$f":"J11/100*I11","v":0},null,null,"Straw bale barrier","0.00 - 0.90",null,1,1,1,{"$f":"P11*Q11*R11*S11","v":0},{"$f":"1-T11","v":1},0,0,0]
[null,"Slope texturing / roughening ","0.10 - 0.75",null,1,1,1,0,1,0,0,null,null,"Silt fence (see below Table 5)","0.00 - 1.00",null,1,1,1,{"$f":"P12*Q12*R12*S12","v":0},{"$f":"1-T12","v":1},0,0,0]
[null,"Sodding","0.98 - 0.99",null,1,1,1,0,1,0,0,null,null,"Terracing","0.82 - 0.90",null,1,1,1,{"$f":"P13*Q13*R13*S13","v":0},{"$f":"1-T13","v":1},0,0,0]
[null,"Erosion control blanket/ RECP","0.70 - 1.00",null,null,null,null,null,1,null,null,null,null,"Sediment traps ","0.00 - 1.00",null,1,1,1,0,1,0,0,0]
[null,"Straw blanket","0.80 - 0.90",null,1,1,1,0,1,0,0,null,null,"Sediment pond","0.10 - 0.90",null,1,1,1,{"$f":"P15*Q16*R15*S15","v":0},1,0,0,0]
[null,"Compost blanket","0.60 - 0.80",null,1,1,1,{"$f":"D16*E16*F16*G16","v":0},{"$f":"1-H16","v":1},0,{"$f":"J16/100*I16","v":0},null,null,null,null,null,1,1,1,{"$f":"P16*Q17*R16*S16","v":0},1,0,0,0]
[null,"Permanent pasture, range, and idle land (see below Table 2)","0.55 - 1.00",null,1,1,1,{"$f":"D17*E17*F17*G17","v":0},{"$f":"1-H17","v":1},0,{"$f":"J17/100*I17","v":0},null,null,null,null,null,1,1,1,0,1,0,0,0]
[null,"Disturbed soil stabilized by vegetation","0.50 - 1.00",null,1,1,1,0,1,0,0,null,null,null,null,null,1,1,1,0,1,0,0,0]
[null,"Orchard / fruit trees","0.60 - 1.00",null,1,1,1,0,1,0,0,null,null,"None"," ---------------------------------------- NA ----------------------------------------",null,null,null,null,null,1," -------------------- NA --------------------"]
[null,"Grain corn","0.55 - 0.60",null,1,1,1,0,1,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"($U$8^V8)*($U$9^V9)*($U$10^V10)*($U$13^V13)*($U$15^V15)*($U$14^V14)*($U$12^V12)*($U$11^V11)*($U$19)*($U$16^V16)*($U$17^V17)*($U$18^V18)","v":1},{"$f":"($U$8^W8)*($U$9^W9)*($U$10^W10)*($U$13^W13)*($U$15^W15)*($U$14^W14)*($U$12^W12)*($U$11^W11)*($U$19)*($U$16^W16)*($U$17^W17)*($U$18^W18)","v":1},1]
[null,"Grass (see below Table 3)","0.70 - 1.00",null,1,1,1,0,1,0,0,null,null,"Sub Catchment ID","Area (ha)",null,null,"Total Area (ha):",{"$f":"'Soil Loss '!D10","v":0},null,null,"Area Weighted P Factor",null,{"$f":"IF((SUM(V8:X15)=0),U19, (O22/O25*V20) +(O23/O25*W20)+(O24/O25*X20))","v":1}]
[null,"Hay","0.70 -0.90",null,1,1,1,0,1,0,0,null,null,"C1",0]
[null,"Undisturbed forest (see below Table 4)","0.99 - 1.00",null,1,1,1,{"$f":"D23*E23*F23*G23","v":0},{"$f":"1-H23","v":1},0,{"$f":"J23/100*I23","v":0},null,null,"C2",0]
[null,"Silage corn, beans & canola","0.45 - 0.85",null,1,1,1,{"$f":"D24*E24*F24*G24","v":0},{"$f":"1-H24","v":1},0,{"$f":"J24/100*I24","v":0},null,null,"C3",0]
[null,null,null,null,1,1,1,{"$f":"D25*E25*F25*G25","v":0},{"$f":"1-H25","v":1},0,{"$f":"J25/100*I25","v":0},null,null,"TOTAL",{"$f":"SUM(O22:O24)","v":0}]
[null,null,null,null,1,1,1,0,1,0,0,null,null,"* BMP efficiency depends on many site specific conditions (particle size, slope, climate, etc.) which should be considered when assigning this value. This range is given as a suggestion only. Your BMP efficiency may not be within the provided range. Supporting documentation should be consulted to ensure an adequate BMP efficiency value is assigned.Efficiency values obtained may be rounded down to the nearest 0.05. Other BMPs can be used but should be supported by documentation."]
[null,"Area-Weighted C Factor",null,null,null,null,null,null,null,null,{"$f":"SUM(K6:K26)","v":1},null,null,"Notes"]
[null,"* BMP efficiency depends on many site specific conditions (particle size, slope, climate, etc.) which should be considered when assigning this value. This range is given as a suggestion only. Your BMP efficiency may not be within the provided range. Supporting documentation should be consulted to ensure an adequate BMP efficiency value is assigned. Efficiency values obtained may be rounded down to the nearest 0.05. Other BMPs can be used but should be supported by documentation.",null,null,null,null,null,null,null,null,null,null,null," - Different subcatchments can be used to seperate areas that have the same ground cover (C Factor) but have different sediment erosion BMPs (P Factors)"]
[null,"Notes",null,null,null,null,null,null,null,null,null,null,null," - Net efficiency for individual BMP must be consistent over entire P Factor calculation"]
[null," - You can not have more than one surface cover per unit area eg. surface roughening with seeding",null,null,null,null,null,null,null,null,null,null,null," - If there are no ubcatchments in the Parcel ID, enter the entire area within \"C1\""]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[]
[]
[]
[null,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.95,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.9,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.85,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.7,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.65,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.55000000000000004,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.45,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.35,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,20]
[null,"Table 1: Mulch efficiency values from USEPA (1993)",null,null,null,null,"Table 3: Grass or weed C factor determination. Figure from Fifield (2011) based on data  from Wischmeier & Smith (1978)",null,null,null,null,null,null,"Table 4: Silt Fence efficiency values from USEPA (1993)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"The efficiency of the silt fence material can be selected from the range that corresponds to the dominant soil type of the site."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," The above Table 3 is given as the C Factor, not the efficiency. Find the corresponding value for your site conditions, and subtract this from 1 to get the efficiency value to input in the above \"Chosen Efficiency\" column."]
[]
[null,null,null,null,null,null,"Table 4: Undisturbed forest land C factor determination  from Wischmeier & Smith (1978)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"An efficiency value can be obtained from Table 1 by selecting the corresponding soil, slope, and mulch type that most accurately correspond to your site conditions. If no exact match is available, extrapolate from the information available."]
[]
[]
[null,"Table 2: C Factor values for permanent pasture, range and idle land from Wischmeier & Smith (1978)",null,null,null,null," The above Table 4 is given as the C Factor, not the efficiency. Find the corresponding value for your site conditions, and subtract this from 1 to get the efficiency value to input in the above \"Chosen Efficiency\" column."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," The above Table 2 is given as the C Factor, not the efficiency. Find the corresponding value for your site conditions, and subtract this from 1 to get the efficiency value to input in the above \"Chosen Efficiency\" column."]

{"sheet":"BMPs - 6","index":10,"n_rows":162,"n_cols":24,"rows_kept":162,"cut":false,"hidden":false,"merged":[[1,1,1,23],[3,1,3,10],[3,13,3,23],[4,13,6,13],[4,14,6,14],[4,15,6,15],[4,16,6,16],[4,17,6,17],[4,18,6,18],[4,19,6,19],[68,2,68,3],[4,20,6,20],[4,21,4,23],[5,21,6,21],[5,22,6,22],[5,23,6,23],[18,14,18,19],[18,21,18,23],[20,21,20,22],[25,13,25,23],[26,1,26,9],[27,1,27,10],[65,6,65,10],[101,1,101,4],[101,6,102,10],[102,16,102,21],[161,1,161,4],[78,13,78,16],[86,6,86,10],[86,14,86,19],[88,6,88,10],[90,15,90,20],[98,1,99,2],[99,14,99,19]]}
[]
[null,"BMP Efficiency "]
[]
[null,"C Factor",null,null,null,null,null,null,null,null,null,null,null,"P Factor"]
[null,"Erosion Control BMP ","Sediment Removal Design Efficiency Range*","Chosen Efficiency ","Design Quality ","Instalation Quality","Maintenance Quality","Net Efficiency ","Individual C Factor","Percent Area Protected  (%)","Proportional C Factor",null,null,"Sediment Control BMP ","Sediment Removal Design Efficiency Range*","Chosen Efficiency","Design Quality","Instalation Quality","Maintenance  Quality ","Net Efficiency ","Individual P Factor","Number of BMPs In Each Sub Catchment "]
[null,"Bare soil ",1,null,1,1,1,{"$f":"D6*E6*F6*G6","v":0},{"$f":"1-H6","v":1},100,{"$f":"J6/100*I6","v":1},null,null,null,null,null,null,null,null,null,null,"C1","C2","C3"]
[null,"Asphalt/concrete pavement",0.01,null,1,1,1,{"$f":"D7*E7*F7*G7","v":0},{"$f":"1-H7","v":1},0,{"$f":"J7/100*I7","v":0}]
[null,"Hydroseeding-hydromulching","0.55 - 0.75",null,1,1,1,{"$f":"D8*E8*F8*G8","v":0},{"$f":"1-H8","v":1},0,{"$f":"J8/100*I8","v":0},null,null,"Vegetated buffer","0.20 - 0.80",null,1,1,1,{"$f":"P8*Q8*R8*S8","v":0},{"$f":"1-T8","v":1},0,0,0]
[null,"Mulching (see below Table 1)","0.00 - 1.00",null,1,1,1,0,1,0,0,null,null,"Rock check dam",0.8,null,1,1,1,{"$f":"P9*Q9*R9*S9","v":0},1,0,0,0]
[null,"Crushed stone or riprap","0.95 - 0.98",null,1,1,1,0,1,0,0,null,null,"Compost filter sock","0.20 - 0.50",null,1,1,1,0,1,0,0,0]
[null,"Chemical stabilization","0.70 - 0.90",null,1,1,1,{"$f":"D11*E11*F11*G11","v":0},{"$f":"1-H11","v":1},0,{"$f":"J11/100*I11","v":0},null,null,"Straw bale barrier","0.00 - 0.90",null,1,1,1,{"$f":"P11*Q11*R11*S11","v":0},{"$f":"1-T11","v":1},0,0,0]
[null,"Slope texturing / roughening ","0.10 - 0.75",null,1,1,1,0,1,0,0,null,null,"Silt fence (see below Table 5)","0.00 - 1.00",null,1,1,1,{"$f":"P12*Q12*R12*S12","v":0},{"$f":"1-T12","v":1},0,0,0]
[null,"Sodding","0.98 - 0.99",null,1,1,1,0,1,0,0,null,null,"Terracing","0.82 - 0.90",null,1,1,1,{"$f":"P13*Q13*R13*S13","v":0},{"$f":"1-T13","v":1},0,0,0]
[null,"Erosion control blanket/ RECP","0.70 - 1.00",null,null,null,null,null,1,null,null,null,null,"Sediment traps ","0.00 - 1.00",null,1,1,1,0,1,0,0,0]
[null,"Straw blanket","0.80 - 0.90",null,1,1,1,0,1,0,0,null,null,"Sediment pond","0.10 - 0.90",null,1,1,1,{"$f":"P15*Q16*R15*S15","v":0},1,0,0,0]
[null,"Compost blanket","0.60 - 0.80",null,1,1,1,{"$f":"D16*E16*F16*G16","v":0},{"$f":"1-H16","v":1},0,{"$f":"J16/100*I16","v":0},null,null,null,null,null,1,1,1,{"$f":"P16*Q17*R16*S16","v":0},1,0,0,0]
[null,"Permanent pasture, range, and idle land (see below Table 2)","0.55 - 1.00",null,1,1,1,{"$f":"D17*E17*F17*G17","v":0},{"$f":"1-H17","v":1},0,{"$f":"J17/100*I17","v":0},null,null,null,null,null,1,1,1,0,1,0,0,0]
[null,"Disturbed soil stabilized by vegetation","0.50 - 1.00",null,1,1,1,0,1,0,0,null,null,null,null,null,1,1,1,0,1,0,0,0]
[null,"Orchard / fruit trees","0.60 - 1.00",null,1,1,1,0,1,0,0,null,null,"None"," ---------------------------------------- NA ----------------------------------------",null,null,null,null,null,1," -------------------- NA --------------------"]
[null,"Grain corn","0.55 - 0.60",null,1,1,1,0,1,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"($U$8^V8)*($U$9^V9)*($U$10^V10)*($U$13^V13)*($U$15^V15)*($U$14^V14)*($U$12^V12)*($U$11^V11)*($U$19)*($U$16^V16)*($U$17^V17)*($U$18^V18)","v":1},{"$f":"($U$8^W8)*($U$9^W9)*($U$10^W10)*($U$13^W13)*($U$15^W15)*($U$14^W14)*($U$12^W12)*($U$11^W11)*($U$19)*($U$16^W16)*($U$17^W17)*($U$18^W18)","v":1},1]
[null,"Grass (see below Table 3)","0.70 - 1.00",null,1,1,1,0,1,0,0,null,null,"Sub Catchment ID","Area (ha)",null,null,"Total Area (ha):",{"$f":"'Soil Loss '!D10","v":0},null,null,"Area Weighted P Factor",null,{"$f":"IF((SUM(V8:X15)=0),U19, (O22/O25*V20) +(O23/O25*W20)+(O24/O25*X20))","v":1}]
[null,"Hay","0.70 -0.90",null,1,1,1,0,1,0,0,null,null,"C1",0]
[null,"Undisturbed forest (see below Table 4)","0.99 - 1.00",null,1,1,1,{"$f":"D23*E23*F23*G23","v":0},{"$f":"1-H23","v":1},0,{"$f":"J23/100*I23","v":0},null,null,"C2",0]
[null,"Silage corn, beans & canola","0.45 - 0.85",null,1,1,1,{"$f":"D24*E24*F24*G24","v":0},{"$f":"1-H24","v":1},0,{"$f":"J24/100*I24","v":0},null,null,"C3",0]
[null,null,null,null,1,1,1,{"$f":"D25*E25*F25*G25","v":0},{"$f":"1-H25","v":1},0,{"$f":"J25/100*I25","v":0},null,null,"TOTAL",{"$f":"SUM(O22:O24)","v":0}]
[null,null,null,null,1,1,1,0,1,0,0,null,null,"* BMP efficiency depends on many site specific conditions (particle size, slope, climate, etc.) which should be considered when assigning this value. This range is given as a suggestion only. Your BMP efficiency may not be within the provided range. Supporting documentation should be consulted to ensure an adequate BMP efficiency value is assigned.Efficiency values obtained may be rounded down to the nearest 0.05. Other BMPs can be used but should be supported by documentation."]
[null,"Area-Weighted C Factor",null,null,null,null,null,null,null,null,{"$f":"SUM(K6:K26)","v":1},null,null,"Notes"]
[null,"* BMP efficiency depends on many site specific conditions (particle size, slope, climate, etc.) which should be considered when assigning this value. This range is given as a suggestion only. Your BMP efficiency may not be within the provided range. Supporting documentation should be consulted to ensure an adequate BMP efficiency value is assigned. Efficiency values obtained may be rounded down to the nearest 0.05. Other BMPs can be used but should be supported by documentation.",null,null,null,null,null,null,null,null,null,null,null," - Different subcatchments can be used to seperate areas that have the same ground cover (C Factor) but have different sediment erosion BMPs (P Factors)"]
[null,"Notes",null,null,null,null,null,null,null,null,null,null,null," - Net efficiency for individual BMP must be consistent over entire P Factor calculation"]
[null," - You can not have more than one surface cover per unit area eg. surface roughening with seeding",null,null,null,null,null,null,null,null,null,null,null," - If there are no ubcatchments in the Parcel ID, enter the entire area within \"C1\""]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N"]
[]
[]
[]
[null,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.95,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.9,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.85,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.7,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.65,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.55000000000000004,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.45,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.35,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.25,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.15,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,20]
[null,"Table 1: Mulch efficiency values from USEPA (1993)",null,null,null,null,"Table 3: Grass or weed C factor determination. Figure from Fifield (2011) based on data  from Wischmeier & Smith (1978)",null,null,null,null,null,null,"Table 4: Silt Fence efficiency values from USEPA (1993)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"The efficiency of the silt fence material can be selected from the range that corresponds to the dominant soil type of the site."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," The above Table 3 is given as the C Factor, not the efficiency. Find the corresponding value for your site conditions, and subtract this from 1 to get the efficiency value to input in the above \"Chosen Efficiency\" column."]
[]
[null,null,null,null,null,null,"Table 4: Undisturbed forest land C factor determination  from Wischmeier & Smith (1978)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"An efficiency value can be obtained from Table 1 by selecting the corresponding soil, slope, and mulch type that most accurately correspond to your site conditions. If no exact match is available, extrapolate from the information available."]
[]
[]
[null,"Table 2: C Factor values for permanent pasture, range and idle land from Wischmeier & Smith (1978)",null,null,null,null," The above Table 4 is given as the C Factor, not the efficiency. Find the corresponding value for your site conditions, and subtract this from 1 to get the efficiency value to input in the above \"Chosen Efficiency\" column."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," The above Table 2 is given as the C Factor, not the efficiency. Find the corresponding value for your site conditions, and subtract this from 1 to get the efficiency value to input in the above \"Chosen Efficiency\" column."]

{"sheet":"Risk","index":11,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Risk Information"]
[]
[null,"Table 1: Basic Soil Loss Tolerance (Stone & Hilborn, 2012)"]
[null,"Soil Erosion Class","Potential Soil Loss (t/ha/year)"]
[null,"Very low (tolerable)","< 6.7"]
[null,"Low","6.7 - 11.2"]
[null,"Moderate","11.2 - 22.4"]
[null,"High","22.4 - 33.6"]
[null,"Severe","> 33.6"]

{"sheet":"3 - BMPs","index":12,"n_rows":80,"n_cols":20,"rows_kept":80,"cut":false,"hidden":true,"merged":[[1,1,1,17],[3,19,3,26],[15,14,15,15]]}
[]
[null,"BMP Efficiency "]
[]
[null,"Erosion Control BMP Efficiency","Maximum Efficiency ","Design Quality ","Instalation Quality","Maintenance Quality","Efficiency ","Percent Area Protected  (%)",null,null,"Sediment Control BMP Efficiency","Maximum Efficiency","Design Quality","Instalation Quality","Maintenance  Quality ","Number of BMPs","Net Efficiency ","Percent Runoff Treated (%)",null,"Table Mulching- Measured reductions in soil loss for different mulch treatments (Source: Harding, 1990, as \ncited in USEPA, 1993)"]
[null,"Chemical Stabilization",0.9,1,1,1,{"$f":"C5*D5*E5*F5","v":0.9},0,null,null,"Compost Filter Berm",0.88,1,1,1,0,{"$f":"1-((1-L5*M5*N5*O5)^P5)","v":0},0]
[null,"Compost Blankets",0.95,1,1,1,{"$f":"C6*D6*E6*F6","v":0.95},0,null,null,"Check Dam",0.8,1,1,1,0,{"$f":"1-((1-L6*M6*N6*O6)^P6)","v":0},0]
[null,"Hydroseeding-Hydromulching",0.9,1,1,1,0.9,0,null,null,"Compost Filter Socks",0.92,1,1,1,0,{"$f":"1-((1-L7*M7*N7*O7)^P7)","v":0},0]
[null,"Mulching (Table)",0.93,1,1,1,0.93,0,null,null,"Drain Inlet Sediment Barrier",0.7,1,1,1,0,0,0]
[null,"Riprap Armouring",0.95,1,1,1,0.95,0,null,null,"Fiber Rolls and Wattles",0.6,1,1,1,0,0,0]
[null,"Seeding",0.95,1,1,1,0.95,0,null,null,"Rock Filter Berm",0.95,1,1,1,0,0,0]
[null,"Slope Texturing / Roughening ",0.6,1,1,1,0.6,0,null,null,"Sandbag Barrier",0.65,1,1,1,0,0,0]
[null,"Sodding",0.95,1,1,1,0.95,0,null,null,"Sediment Pond",0.65,1,1,1,0,0,0]
[null,"Soil Retention",0.95,1,1,1,0.95,0,null,null,"Sediment Traps (Basins)",0.65,1,1,1,0,0,0]
[null,"Vegetated Buffer",0.74,1,1,1,0.74,0,null,null,"Silt Fence",0.75,1,1,1,0,0,0]
[null,"Bare Soil (Exposed Soil)",0,1,1,1,0,0,null,null,"Straw Bale Barrier",0.75,1,1,1,0,0,0]
[null,"Completed Construction Area",0.99,1,1,1,0.99,0,null,null,"Area-Weighted Average Efficiency ",null,null,null,null,null,{"$f":"IF(R16=0,\"0\",(R5/100*Q5+R6/100*Q6+R7/100*Q7+R8/100*Q8+R9/100*Q9+R10/100*Q10+R11/100*Q11+R12/100*Q12+R13/100*Q13+R14/100*Q14+R15/100*Q15))","v":"0"},{"$f":"SUM(R5:R15)","v":0}]
[null,"Disturbed Soil Stabilized by Vegetation",0.9,1,1,1,0.9,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,"Fruit Trees",0.9,1,1,1,0.9,0]
[null,"Grain Corn",0.6,1,1,1,0.6,0]
[null,"Grassland",0.97,1,1,1,0.97,0]
[null,"Hay and Pasture",0.98,1,1,1,0.98,0]
[null,"Orchard",0.84,1,1,1,0.84,0]
[null,"Planted Forest",0.62,1,1,1,{"$f":"C26*D26*E26*F26","v":0.62},0]
[null,"Silage corn, beans & canola",0.5,1,1,1,{"$f":"C27*D27*E27*F27","v":0.5},0]
[null,"Undisturbed Natural Vegetation",0.99,1,1,1,{"$f":"C28*D28*E28*F28","v":0.99},0]
[null,"Area-Weighted Average Efficiency ",null,null,null,null,{"$f":"IF(H29=0,\"0\",(H5/100*G5+H6/100*G6+H7/100*G7+H8/100*G8+H9/100*G9+H10/100*G10+H11/100*G11+H12/100*G12+H13/100*G13+H14/100*G14+H15/100*G15+H16/100*G16+H17/100*G17+H21/100*G21+H22/100*G22+H23/100*G23+H24/100*G24+H25/100*G25+H26/100*G26+H27/100*G27+H28/100*G28))","v":"0"},{"$f":"SUM(H5:H28)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"C31*D31*E31*F31","v":0}]
[null,null,null,null,null,null,{"$f":"C32*D32*E32*F32","v":0}]
[]
[]
[1,"( http://archive.chesapeakebay.net/pubs/calendar/USWG_05-21-07_Handout_6_8505.pdf)"]
[null,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[null,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[2,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[3,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[4," https://mail.uoguelph.ca/service/home/~/New%20Guidelines%20for%20TMDL%27s%20per%20ADEM_7_14_2011.pdf?auth=co&loc=en_US&id=14561&part=2"]
[5,"http://www.marionindiana.us/?q=filebrowser/download/1969"]
[6,"http://www.edenhydroseeding.com/why.shtml"]
[7,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4"]
[8,"Universal soil Loss Factsheet Ministry of Agriculture"]
[9,"http://www.ldd.go.th/efiles_project/ldd_plannig/flood/flood_coverFactor.html"]
[null,"https://mail.uoguelph.ca/service/home/~/ELC_PWP54.pdf?auth=co&loc=en_US&id=14823&part=3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4",null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,0.95,1]
[null,null,null,null,null,null,null,null,null,null,0.9,2]
[null,null,null,null,null,null,null,null,null,null,0.85,3]
[null,null,null,null,null,null,null,null,null,null,0.8,4]
[null,null,null,null,null,null,null,null,null,null,0.75,5]
[null,null,null,null,null,null,null,null,null,null,0.7,6]
[null,null,null,null,null,null,null,null,null,null,0.65,7]
[null,null,null,null,null,null,null,null,null,null,0.6,8]
[null,null,null,null,null,null,null,null,null,null,0.55000000000000004,9]
[null,null,null,null,null,null,null,null,null,null,0.5,10]
[null,null,null,null,null,null,null,null,null,null,0.45,11]
[null,null,null,null,null,null,null,null,null,null,0.4,12]
[null,null,null,null,null,null,null,null,null,null,0.35,13]
[null,null,null,null,null,null,null,null,null,null,0.3,14]
[null,null,null,null,null,null,null,null,null,null,0.25,15]
[null,null,null,null,null,null,null,null,null,null,0.2,16]
[null,null,null,null,null,null,null,null,null,null,0.15,17]
[null,null,null,null,null,null,null,null,null,null,0.1,18]
[null,null,null,null,null,null,null,null,null,null,0.05,19]
[null,null,null,null,null,null,null,null,null,null,0,20]

{"sheet":"4 - BMPs","index":13,"n_rows":80,"n_cols":20,"rows_kept":80,"cut":false,"hidden":true,"merged":[[1,1,1,17],[3,19,3,26],[15,14,15,15]]}
[]
[null,"BMP Efficiency "]
[]
[null,"Erosion Control BMP Efficiency","Maximum Efficiency ","Design Quality ","Instalation Quality","Maintenance Quality","Efficiency ","Percent Area Protected  (%)",null,null,"Sediment Control BMP Efficiency","Maximum Efficiency","Design Quality","Instalation Quality","Maintenance  Quality ","Number of BMPs","Net Efficiency ","Percent Runoff Treated (%)",null,"Table Mulching- Measured reductions in soil loss for different mulch treatments (Source: Harding, 1990, as \ncited in USEPA, 1993)"]
[null,"Chemical Stabilization",0.9,1,1,1,{"$f":"C5*D5*E5*F5","v":0.9},0,null,null,"Compost Filter Berm",0.88,1,1,1,0,{"$f":"1-((1-L5*M5*N5*O5)^P5)","v":0},0]
[null,"Compost Blankets",0.95,1,1,1,{"$f":"C6*D6*E6*F6","v":0.95},0,null,null,"Check Dam",0.8,1,1,1,0,{"$f":"1-((1-L6*M6*N6*O6)^P6)","v":0},0]
[null,"Hydroseeding-Hydromulching",0.9,1,1,1,0.9,0,null,null,"Compost Filter Socks",0.92,1,1,1,0,{"$f":"1-((1-L7*M7*N7*O7)^P7)","v":0},0]
[null,"Mulching (Table)",0.93,1,1,1,0.93,0,null,null,"Drain Inlet Sediment Barrier",0.7,1,1,1,0,0,0]
[null,"Riprap Armouring",0.95,1,1,1,0.95,0,null,null,"Fiber Rolls and Wattles",0.6,1,1,1,0,0,0]
[null,"Seeding",0.95,1,1,1,0.95,0,null,null,"Rock Filter Berm",0.95,1,1,1,0,0,0]
[null,"Slope Texturing / Roughening ",0.6,1,1,1,0.6,0,null,null,"Sandbag Barrier",0.65,1,1,1,0,0,0]
[null,"Sodding",0.95,1,1,1,0.95,0,null,null,"Sediment Pond",0.65,1,1,1,0,0,0]
[null,"Soil Retention",0.95,1,1,1,0.95,0,null,null,"Sediment Traps (Basins)",0.65,1,1,1,0,0,0]
[null,"Vegetated Buffer",0.74,1,1,1,0.74,0,null,null,"Silt Fence",0.75,1,1,1,0,0,0]
[null,"Bare Soil (Exposed Soil)",0,1,1,1,0,0,null,null,"Straw Bale Barrier",0.75,1,1,1,0,0,0]
[null,"Completed Construction Area",0.99,1,1,1,0.99,0,null,null,"Area-Weighted Average Efficiency ",null,null,null,null,null,{"$f":"IF(R16=0,\"0\",(R5/100*Q5+R6/100*Q6+R7/100*Q7+R8/100*Q8+R9/100*Q9+R10/100*Q10+R11/100*Q11+R12/100*Q12+R13/100*Q13+R14/100*Q14+R15/100*Q15))","v":"0"},{"$f":"SUM(R5:R15)","v":0}]
[null,"Disturbed Soil Stabilized by Vegetation",0.9,1,1,1,0.9,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,"Fruit Trees",0.9,1,1,1,0.9,0]
[null,"Grain Corn",0.6,1,1,1,0.6,0]
[null,"Grassland",0.97,1,1,1,0.97,0]
[null,"Hay and Pasture",0.98,1,1,1,0.98,0]
[null,"Orchard",0.84,1,1,1,0.84,0]
[null,"Planted Forest",0.62,1,1,1,{"$f":"C26*D26*E26*F26","v":0.62},0]
[null,"Silage corn, beans & canola",0.5,1,1,1,{"$f":"C27*D27*E27*F27","v":0.5},0]
[null,"Undisturbed Natural Vegetation",0.99,1,1,1,{"$f":"C28*D28*E28*F28","v":0.99},0]
[null,"Area-Weighted Average Efficiency ",null,null,null,null,{"$f":"IF(H29=0,\"0\",(H5/100*G5+H6/100*G6+H7/100*G7+H8/100*G8+H9/100*G9+H10/100*G10+H11/100*G11+H12/100*G12+H13/100*G13+H14/100*G14+H15/100*G15+H16/100*G16+H17/100*G17+H21/100*G21+H22/100*G22+H23/100*G23+H24/100*G24+H25/100*G25+H26/100*G26+H27/100*G27+H28/100*G28))","v":"0"},{"$f":"SUM(H5:H28)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"C31*D31*E31*F31","v":0}]
[null,null,null,null,null,null,{"$f":"C32*D32*E32*F32","v":0}]
[]
[]
[1,"( http://archive.chesapeakebay.net/pubs/calendar/USWG_05-21-07_Handout_6_8505.pdf)"]
[null,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[null,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[2,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[3,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[4," https://mail.uoguelph.ca/service/home/~/New%20Guidelines%20for%20TMDL%27s%20per%20ADEM_7_14_2011.pdf?auth=co&loc=en_US&id=14561&part=2"]
[5,"http://www.marionindiana.us/?q=filebrowser/download/1969"]
[6,"http://www.edenhydroseeding.com/why.shtml"]
[7,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4"]
[8,"Universal soil Loss Factsheet Ministry of Agriculture"]
[9,"http://www.ldd.go.th/efiles_project/ldd_plannig/flood/flood_coverFactor.html"]
[null,"https://mail.uoguelph.ca/service/home/~/ELC_PWP54.pdf?auth=co&loc=en_US&id=14823&part=3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4",null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,0.95,1]
[null,null,null,null,null,null,null,null,null,null,0.9,2]
[null,null,null,null,null,null,null,null,null,null,0.85,3]
[null,null,null,null,null,null,null,null,null,null,0.8,4]
[null,null,null,null,null,null,null,null,null,null,0.75,5]
[null,null,null,null,null,null,null,null,null,null,0.7,6]
[null,null,null,null,null,null,null,null,null,null,0.65,7]
[null,null,null,null,null,null,null,null,null,null,0.6,8]
[null,null,null,null,null,null,null,null,null,null,0.55000000000000004,9]
[null,null,null,null,null,null,null,null,null,null,0.5,10]
[null,null,null,null,null,null,null,null,null,null,0.45,11]
[null,null,null,null,null,null,null,null,null,null,0.4,12]
[null,null,null,null,null,null,null,null,null,null,0.35,13]
[null,null,null,null,null,null,null,null,null,null,0.3,14]
[null,null,null,null,null,null,null,null,null,null,0.25,15]
[null,null,null,null,null,null,null,null,null,null,0.2,16]
[null,null,null,null,null,null,null,null,null,null,0.15,17]
[null,null,null,null,null,null,null,null,null,null,0.1,18]
[null,null,null,null,null,null,null,null,null,null,0.05,19]
[null,null,null,null,null,null,null,null,null,null,0,20]

{"sheet":"5 - BMPs","index":14,"n_rows":80,"n_cols":20,"rows_kept":80,"cut":false,"hidden":true,"merged":[[1,1,1,17],[3,19,3,26],[15,14,15,15]]}
[]
[null,"BMP Efficiency "]
[]
[null,"Erosion Control BMP Efficiency","Maximum Efficiency ","Design Quality ","Instalation Quality","Maintenance Quality","Efficiency ","Percent Area Protected  (%)",null,null,"Sediment Control BMP Efficiency","Maximum Efficiency","Design Quality","Instalation Quality","Maintenance  Quality ","Number of BMPs","Net Efficiency ","Percent Runoff Treated (%)",null,"Table Mulching- Measured reductions in soil loss for different mulch treatments (Source: Harding, 1990, as \ncited in USEPA, 1993)"]
[null,"Chemical Stabilization",0.9,1,1,1,{"$f":"C5*D5*E5*F5","v":0.9},0,null,null,"Compost Filter Berm",0.88,1,1,1,0,{"$f":"1-((1-L5*M5*N5*O5)^P5)","v":0},0]
[null,"Compost Blankets",0.95,1,1,1,{"$f":"C6*D6*E6*F6","v":0.95},0,null,null,"Check Dam",0.8,1,1,1,0,{"$f":"1-((1-L6*M6*N6*O6)^P6)","v":0},0]
[null,"Hydroseeding-Hydromulching",0.9,1,1,1,0.9,0,null,null,"Compost Filter Socks",0.92,1,1,1,0,{"$f":"1-((1-L7*M7*N7*O7)^P7)","v":0},0]
[null,"Mulching (Table)",0.93,1,1,1,0.93,0,null,null,"Drain Inlet Sediment Barrier",0.7,1,1,1,0,0,0]
[null,"Riprap Armouring",0.95,1,1,1,0.95,0,null,null,"Fiber Rolls and Wattles",0.6,1,1,1,0,0,0]
[null,"Seeding",0.95,1,1,1,0.95,0,null,null,"Rock Filter Berm",0.95,1,1,1,0,0,0]
[null,"Slope Texturing / Roughening ",0.6,1,1,1,0.6,0,null,null,"Sandbag Barrier",0.65,1,1,1,0,0,0]
[null,"Sodding",0.95,1,1,1,0.95,0,null,null,"Sediment Pond",0.65,1,1,1,0,0,0]
[null,"Soil Retention",0.95,1,1,1,0.95,0,null,null,"Sediment Traps (Basins)",0.65,1,1,1,0,0,0]
[null,"Vegetated Buffer",0.74,1,1,1,0.74,0,null,null,"Silt Fence",0.75,1,1,1,0,0,0]
[null,"Bare Soil (Exposed Soil)",0,1,1,1,0,0,null,null,"Straw Bale Barrier",0.75,1,1,1,0,0,0]
[null,"Completed Construction Area",0.99,1,1,1,0.99,0,null,null,"Area-Weighted Average Efficiency ",null,null,null,null,null,{"$f":"IF(R16=0,\"0\",(R5/100*Q5+R6/100*Q6+R7/100*Q7+R8/100*Q8+R9/100*Q9+R10/100*Q10+R11/100*Q11+R12/100*Q12+R13/100*Q13+R14/100*Q14+R15/100*Q15))","v":"0"},{"$f":"SUM(R5:R15)","v":0}]
[null,"Disturbed Soil Stabilized by Vegetation",0.9,1,1,1,0.9,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,"Fruit Trees",0.9,1,1,1,0.9,0]
[null,"Grain Corn",0.6,1,1,1,0.6,0]
[null,"Grassland",0.97,1,1,1,0.97,0]
[null,"Hay and Pasture",0.98,1,1,1,0.98,0]
[null,"Orchard",0.84,1,1,1,0.84,0]
[null,"Planted Forest",0.62,1,1,1,{"$f":"C26*D26*E26*F26","v":0.62},0]
[null,"Silage corn, beans & canola",0.5,1,1,1,{"$f":"C27*D27*E27*F27","v":0.5},0]
[null,"Undisturbed Natural Vegetation",0.99,1,1,1,{"$f":"C28*D28*E28*F28","v":0.99},0]
[null,"Area-Weighted Average Efficiency ",null,null,null,null,{"$f":"IF(H29=0,\"0\",(H5/100*G5+H6/100*G6+H7/100*G7+H8/100*G8+H9/100*G9+H10/100*G10+H11/100*G11+H12/100*G12+H13/100*G13+H14/100*G14+H15/100*G15+H16/100*G16+H17/100*G17+H21/100*G21+H22/100*G22+H23/100*G23+H24/100*G24+H25/100*G25+H26/100*G26+H27/100*G27+H28/100*G28))","v":"0"},{"$f":"SUM(H5:H28)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"C31*D31*E31*F31","v":0}]
[null,null,null,null,null,null,{"$f":"C32*D32*E32*F32","v":0}]
[]
[]
[1,"( http://archive.chesapeakebay.net/pubs/calendar/USWG_05-21-07_Handout_6_8505.pdf)"]
[null,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[null,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[2,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[3,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[4," https://mail.uoguelph.ca/service/home/~/New%20Guidelines%20for%20TMDL%27s%20per%20ADEM_7_14_2011.pdf?auth=co&loc=en_US&id=14561&part=2"]
[5,"http://www.marionindiana.us/?q=filebrowser/download/1969"]
[6,"http://www.edenhydroseeding.com/why.shtml"]
[7,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4"]
[8,"Universal soil Loss Factsheet Ministry of Agriculture"]
[9,"http://www.ldd.go.th/efiles_project/ldd_plannig/flood/flood_coverFactor.html"]
[null,"https://mail.uoguelph.ca/service/home/~/ELC_PWP54.pdf?auth=co&loc=en_US&id=14823&part=3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4",null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,0.95,1]
[null,null,null,null,null,null,null,null,null,null,0.9,2]
[null,null,null,null,null,null,null,null,null,null,0.85,3]
[null,null,null,null,null,null,null,null,null,null,0.8,4]
[null,null,null,null,null,null,null,null,null,null,0.75,5]
[null,null,null,null,null,null,null,null,null,null,0.7,6]
[null,null,null,null,null,null,null,null,null,null,0.65,7]
[null,null,null,null,null,null,null,null,null,null,0.6,8]
[null,null,null,null,null,null,null,null,null,null,0.55000000000000004,9]
[null,null,null,null,null,null,null,null,null,null,0.5,10]
[null,null,null,null,null,null,null,null,null,null,0.45,11]
[null,null,null,null,null,null,null,null,null,null,0.4,12]
[null,null,null,null,null,null,null,null,null,null,0.35,13]
[null,null,null,null,null,null,null,null,null,null,0.3,14]
[null,null,null,null,null,null,null,null,null,null,0.25,15]
[null,null,null,null,null,null,null,null,null,null,0.2,16]
[null,null,null,null,null,null,null,null,null,null,0.15,17]
[null,null,null,null,null,null,null,null,null,null,0.1,18]
[null,null,null,null,null,null,null,null,null,null,0.05,19]
[null,null,null,null,null,null,null,null,null,null,0,20]

{"sheet":"6 - BMPs","index":15,"n_rows":80,"n_cols":20,"rows_kept":80,"cut":false,"hidden":true,"merged":[[1,1,1,17],[3,19,3,26],[15,14,15,15]]}
[]
[null,"BMP Efficiency "]
[]
[null,"Erosion Control BMP Efficiency","Maximum Efficiency ","Design Quality ","Instalation Quality","Maintenance Quality","Efficiency ","Percent Area Protected  (%)",null,null,"Sediment Control BMP Efficiency","Maximum Efficiency","Design Quality","Instalation Quality","Maintenance  Quality ","Number of BMPs","Net Efficiency ","Percent Runoff Treated (%)",null,"Table Mulching- Measured reductions in soil loss for different mulch treatments (Source: Harding, 1990, as \ncited in USEPA, 1993)"]
[null,"Chemical Stabilization",0.9,1,1,1,{"$f":"C5*D5*E5*F5","v":0.9},0,null,null,"Compost Filter Berm",0.88,1,1,1,0,{"$f":"1-((1-L5*M5*N5*O5)^P5)","v":0},0]
[null,"Compost Blankets",0.95,1,1,1,{"$f":"C6*D6*E6*F6","v":0.95},0,null,null,"Check Dam",0.8,1,1,1,0,{"$f":"1-((1-L6*M6*N6*O6)^P6)","v":0},0]
[null,"Hydroseeding-Hydromulching",0.9,1,1,1,0.9,0,null,null,"Compost Filter Socks",0.92,1,1,1,0,{"$f":"1-((1-L7*M7*N7*O7)^P7)","v":0},0]
[null,"Mulching (Table)",0.93,1,1,1,0.93,0,null,null,"Drain Inlet Sediment Barrier",0.7,1,1,1,0,0,0]
[null,"Riprap Armouring",0.95,1,1,1,0.95,0,null,null,"Fiber Rolls and Wattles",0.6,1,1,1,0,0,0]
[null,"Seeding",0.95,1,1,1,0.95,0,null,null,"Rock Filter Berm",0.95,1,1,1,0,0,0]
[null,"Slope Texturing / Roughening ",0.6,1,1,1,0.6,0,null,null,"Sandbag Barrier",0.65,1,1,1,0,0,0]
[null,"Sodding",0.95,1,1,1,0.95,0,null,null,"Sediment Pond",0.65,1,1,1,0,0,0]
[null,"Soil Retention",0.95,1,1,1,0.95,0,null,null,"Sediment Traps (Basins)",0.65,1,1,1,0,0,0]
[null,"Vegetated Buffer",0.74,1,1,1,0.74,0,null,null,"Silt Fence",0.75,1,1,1,0,0,0]
[null,"Bare Soil (Exposed Soil)",0,1,1,1,0,0,null,null,"Straw Bale Barrier",0.75,1,1,1,0,0,0]
[null,"Completed Construction Area",0.99,1,1,1,0.99,0,null,null,"Area-Weighted Average Efficiency ",null,null,null,null,null,{"$f":"IF(R16=0,\"0\",(R5/100*Q5+R6/100*Q6+R7/100*Q7+R8/100*Q8+R9/100*Q9+R10/100*Q10+R11/100*Q11+R12/100*Q12+R13/100*Q13+R14/100*Q14+R15/100*Q15))","v":"0"},{"$f":"SUM(R5:R15)","v":0}]
[null,"Disturbed Soil Stabilized by Vegetation",0.9,1,1,1,0.9,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,"Fruit Trees",0.9,1,1,1,0.9,0]
[null,"Grain Corn",0.6,1,1,1,0.6,0]
[null,"Grassland",0.97,1,1,1,0.97,0]
[null,"Hay and Pasture",0.98,1,1,1,0.98,0]
[null,"Orchard",0.84,1,1,1,0.84,0]
[null,"Planted Forest",0.62,1,1,1,{"$f":"C26*D26*E26*F26","v":0.62},0]
[null,"Silage corn, beans & canola",0.5,1,1,1,{"$f":"C27*D27*E27*F27","v":0.5},0]
[null,"Undisturbed Natural Vegetation",0.99,1,1,1,{"$f":"C28*D28*E28*F28","v":0.99},0]
[null,"Area-Weighted Average Efficiency ",null,null,null,null,{"$f":"IF(H29=0,\"0\",(H5/100*G5+H6/100*G6+H7/100*G7+H8/100*G8+H9/100*G9+H10/100*G10+H11/100*G11+H12/100*G12+H13/100*G13+H14/100*G14+H15/100*G15+H16/100*G16+H17/100*G17+H21/100*G21+H22/100*G22+H23/100*G23+H24/100*G24+H25/100*G25+H26/100*G26+H27/100*G27+H28/100*G28))","v":"0"},{"$f":"SUM(H5:H28)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"C31*D31*E31*F31","v":0}]
[null,null,null,null,null,null,{"$f":"C32*D32*E32*F32","v":0}]
[]
[]
[1,"( http://archive.chesapeakebay.net/pubs/calendar/USWG_05-21-07_Handout_6_8505.pdf)"]
[null,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[null,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[2,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[3,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[4," https://mail.uoguelph.ca/service/home/~/New%20Guidelines%20for%20TMDL%27s%20per%20ADEM_7_14_2011.pdf?auth=co&loc=en_US&id=14561&part=2"]
[5,"http://www.marionindiana.us/?q=filebrowser/download/1969"]
[6,"http://www.edenhydroseeding.com/why.shtml"]
[7,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4"]
[8,"Universal soil Loss Factsheet Ministry of Agriculture"]
[9,"http://www.ldd.go.th/efiles_project/ldd_plannig/flood/flood_coverFactor.html"]
[null,"https://mail.uoguelph.ca/service/home/~/ELC_PWP54.pdf?auth=co&loc=en_US&id=14823&part=3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4",null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,0.95,1]
[null,null,null,null,null,null,null,null,null,null,0.9,2]
[null,null,null,null,null,null,null,null,null,null,0.85,3]
[null,null,null,null,null,null,null,null,null,null,0.8,4]
[null,null,null,null,null,null,null,null,null,null,0.75,5]
[null,null,null,null,null,null,null,null,null,null,0.7,6]
[null,null,null,null,null,null,null,null,null,null,0.65,7]
[null,null,null,null,null,null,null,null,null,null,0.6,8]
[null,null,null,null,null,null,null,null,null,null,0.55000000000000004,9]
[null,null,null,null,null,null,null,null,null,null,0.5,10]
[null,null,null,null,null,null,null,null,null,null,0.45,11]
[null,null,null,null,null,null,null,null,null,null,0.4,12]
[null,null,null,null,null,null,null,null,null,null,0.35,13]
[null,null,null,null,null,null,null,null,null,null,0.3,14]
[null,null,null,null,null,null,null,null,null,null,0.25,15]
[null,null,null,null,null,null,null,null,null,null,0.2,16]
[null,null,null,null,null,null,null,null,null,null,0.15,17]
[null,null,null,null,null,null,null,null,null,null,0.1,18]
[null,null,null,null,null,null,null,null,null,null,0.05,19]
[null,null,null,null,null,null,null,null,null,null,0,20]

{"sheet":"7 - BMPs","index":16,"n_rows":80,"n_cols":20,"rows_kept":80,"cut":false,"hidden":true,"merged":[[1,1,1,17],[3,19,3,26],[15,14,15,15]]}
[]
[null,"BMP Efficiency "]
[]
[null,"Erosion Control BMP Efficiency","Maximum Efficiency ","Design Quality ","Instalation Quality","Maintenance Quality","Efficiency ","Percent Area Protected  (%)",null,null,"Sediment Control BMP Efficiency","Maximum Efficiency","Design Quality","Instalation Quality","Maintenance  Quality ","Number of BMPs","Net Efficiency ","Percent Runoff Treated (%)",null,"Table Mulching- Measured reductions in soil loss for different mulch treatments (Source: Harding, 1990, as \ncited in USEPA, 1993)"]
[null,"Chemical Stabilization",0.9,1,1,1,{"$f":"C5*D5*E5*F5","v":0.9},0,null,null,"Compost Filter Berm",0.88,1,1,1,0,{"$f":"1-((1-L5*M5*N5*O5)^P5)","v":0},0]
[null,"Compost Blankets",0.95,1,1,1,{"$f":"C6*D6*E6*F6","v":0.95},0,null,null,"Check Dam",0.8,1,1,1,0,{"$f":"1-((1-L6*M6*N6*O6)^P6)","v":0},0]
[null,"Hydroseeding-Hydromulching",0.9,1,1,1,0.9,0,null,null,"Compost Filter Socks",0.92,1,1,1,0,{"$f":"1-((1-L7*M7*N7*O7)^P7)","v":0},0]
[null,"Mulching (Table)",0.93,1,1,1,0.93,0,null,null,"Drain Inlet Sediment Barrier",0.7,1,1,1,0,0,0]
[null,"Riprap Armouring",0.95,1,1,1,0.95,0,null,null,"Fiber Rolls and Wattles",0.6,1,1,1,0,0,0]
[null,"Seeding",0.95,1,1,1,0.95,0,null,null,"Rock Filter Berm",0.95,1,1,1,0,0,0]
[null,"Slope Texturing / Roughening ",0.6,1,1,1,0.6,0,null,null,"Sandbag Barrier",0.65,1,1,1,0,0,0]
[null,"Sodding",0.95,1,1,1,0.95,0,null,null,"Sediment Pond",0.65,1,1,1,0,0,0]
[null,"Soil Retention",0.95,1,1,1,0.95,0,null,null,"Sediment Traps (Basins)",0.65,1,1,1,0,0,0]
[null,"Vegetated Buffer",0.74,1,1,1,0.74,0,null,null,"Silt Fence",0.75,1,1,1,0,0,0]
[null,"Bare Soil (Exposed Soil)",0,1,1,1,0,0,null,null,"Straw Bale Barrier",0.75,1,1,1,0,0,0]
[null,"Completed Construction Area",0.99,1,1,1,0.99,0,null,null,"Area-Weighted Average Efficiency ",null,null,null,null,null,{"$f":"IF(R16=0,\"0\",(R5/100*Q5+R6/100*Q6+R7/100*Q7+R8/100*Q8+R9/100*Q9+R10/100*Q10+R11/100*Q11+R12/100*Q12+R13/100*Q13+R14/100*Q14+R15/100*Q15))","v":"0"},{"$f":"SUM(R5:R15)","v":0}]
[null,"Disturbed Soil Stabilized by Vegetation",0.9,1,1,1,0.9,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,"Fruit Trees",0.9,1,1,1,0.9,0]
[null,"Grain Corn",0.6,1,1,1,0.6,0]
[null,"Grassland",0.97,1,1,1,0.97,0]
[null,"Hay and Pasture",0.98,1,1,1,0.98,0]
[null,"Orchard",0.84,1,1,1,0.84,0]
[null,"Planted Forest",0.62,1,1,1,{"$f":"C26*D26*E26*F26","v":0.62},0]
[null,"Silage corn, beans & canola",0.5,1,1,1,{"$f":"C27*D27*E27*F27","v":0.5},0]
[null,"Undisturbed Natural Vegetation",0.99,1,1,1,{"$f":"C28*D28*E28*F28","v":0.99},0]
[null,"Area-Weighted Average Efficiency ",null,null,null,null,{"$f":"IF(H29=0,\"0\",(H5/100*G5+H6/100*G6+H7/100*G7+H8/100*G8+H9/100*G9+H10/100*G10+H11/100*G11+H12/100*G12+H13/100*G13+H14/100*G14+H15/100*G15+H16/100*G16+H17/100*G17+H21/100*G21+H22/100*G22+H23/100*G23+H24/100*G24+H25/100*G25+H26/100*G26+H27/100*G27+H28/100*G28))","v":"0"},{"$f":"SUM(H5:H28)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"C31*D31*E31*F31","v":0}]
[null,null,null,null,null,null,{"$f":"C32*D32*E32*F32","v":0}]
[]
[]
[1,"( http://archive.chesapeakebay.net/pubs/calendar/USWG_05-21-07_Handout_6_8505.pdf)"]
[null,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[null,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[2,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[3,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[4," https://mail.uoguelph.ca/service/home/~/New%20Guidelines%20for%20TMDL%27s%20per%20ADEM_7_14_2011.pdf?auth=co&loc=en_US&id=14561&part=2"]
[5,"http://www.marionindiana.us/?q=filebrowser/download/1969"]
[6,"http://www.edenhydroseeding.com/why.shtml"]
[7,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4"]
[8,"Universal soil Loss Factsheet Ministry of Agriculture"]
[9,"http://www.ldd.go.th/efiles_project/ldd_plannig/flood/flood_coverFactor.html"]
[null,"https://mail.uoguelph.ca/service/home/~/ELC_PWP54.pdf?auth=co&loc=en_US&id=14823&part=3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4",null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,0.95,1]
[null,null,null,null,null,null,null,null,null,null,0.9,2]
[null,null,null,null,null,null,null,null,null,null,0.85,3]
[null,null,null,null,null,null,null,null,null,null,0.8,4]
[null,null,null,null,null,null,null,null,null,null,0.75,5]
[null,null,null,null,null,null,null,null,null,null,0.7,6]
[null,null,null,null,null,null,null,null,null,null,0.65,7]
[null,null,null,null,null,null,null,null,null,null,0.6,8]
[null,null,null,null,null,null,null,null,null,null,0.55000000000000004,9]
[null,null,null,null,null,null,null,null,null,null,0.5,10]
[null,null,null,null,null,null,null,null,null,null,0.45,11]
[null,null,null,null,null,null,null,null,null,null,0.4,12]
[null,null,null,null,null,null,null,null,null,null,0.35,13]
[null,null,null,null,null,null,null,null,null,null,0.3,14]
[null,null,null,null,null,null,null,null,null,null,0.25,15]
[null,null,null,null,null,null,null,null,null,null,0.2,16]
[null,null,null,null,null,null,null,null,null,null,0.15,17]
[null,null,null,null,null,null,null,null,null,null,0.1,18]
[null,null,null,null,null,null,null,null,null,null,0.05,19]
[null,null,null,null,null,null,null,null,null,null,0,20]

{"sheet":"8 - BMPs","index":17,"n_rows":80,"n_cols":20,"rows_kept":80,"cut":false,"hidden":true,"merged":[[1,1,1,17],[3,19,3,26],[15,14,15,15]]}
[]
[null,"BMP Efficiency "]
[]
[null,"Erosion Control BMP Efficiency","Maximum Efficiency ","Design Quality ","Instalation Quality","Maintenance Quality","Efficiency ","Percent Area Protected  (%)",null,null,"Sediment Control BMP Efficiency","Maximum Efficiency","Design Quality","Instalation Quality","Maintenance  Quality ","Number of BMPs","Net Efficiency ","Percent Runoff Treated (%)",null,"Table Mulching- Measured reductions in soil loss for different mulch treatments (Source: Harding, 1990, as \ncited in USEPA, 1993)"]
[null,"Chemical Stabilization",0.9,1,1,1,{"$f":"C5*D5*E5*F5","v":0.9},0,null,null,"Compost Filter Berm",0.88,1,1,1,0,{"$f":"1-((1-L5*M5*N5*O5)^P5)","v":0},0]
[null,"Compost Blankets",0.95,1,1,1,{"$f":"C6*D6*E6*F6","v":0.95},0,null,null,"Check Dam",0.8,1,1,1,0,{"$f":"1-((1-L6*M6*N6*O6)^P6)","v":0},0]
[null,"Hydroseeding-Hydromulching",0.9,1,1,1,0.9,0,null,null,"Compost Filter Socks",0.92,1,1,1,0,{"$f":"1-((1-L7*M7*N7*O7)^P7)","v":0},0]
[null,"Mulching (Table)",0.93,1,1,1,0.93,0,null,null,"Drain Inlet Sediment Barrier",0.7,1,1,1,0,0,0]
[null,"Riprap Armouring",0.95,1,1,1,0.95,0,null,null,"Fiber Rolls and Wattles",0.6,1,1,1,0,0,0]
[null,"Seeding",0.95,1,1,1,0.95,0,null,null,"Rock Filter Berm",0.95,1,1,1,0,0,0]
[null,"Slope Texturing / Roughening ",0.6,1,1,1,0.6,0,null,null,"Sandbag Barrier",0.65,1,1,1,0,0,0]
[null,"Sodding",0.95,1,1,1,0.95,0,null,null,"Sediment Pond",0.65,1,1,1,0,0,0]
[null,"Soil Retention",0.95,1,1,1,0.95,0,null,null,"Sediment Traps (Basins)",0.65,1,1,1,0,0,0]
[null,"Vegetated Buffer",0.74,1,1,1,0.74,0,null,null,"Silt Fence",0.75,1,1,1,0,0,0]
[null,"Bare Soil (Exposed Soil)",0,1,1,1,0,0,null,null,"Straw Bale Barrier",0.75,1,1,1,0,0,0]
[null,"Completed Construction Area",0.99,1,1,1,0.99,0,null,null,"Area-Weighted Average Efficiency ",null,null,null,null,null,{"$f":"IF(R16=0,\"0\",(R5/100*Q5+R6/100*Q6+R7/100*Q7+R8/100*Q8+R9/100*Q9+R10/100*Q10+R11/100*Q11+R12/100*Q12+R13/100*Q13+R14/100*Q14+R15/100*Q15))","v":"0"},{"$f":"SUM(R5:R15)","v":0}]
[null,"Disturbed Soil Stabilized by Vegetation",0.9,1,1,1,0.9,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,"Fruit Trees",0.9,1,1,1,0.9,0]
[null,"Grain Corn",0.6,1,1,1,0.6,0]
[null,"Grassland",0.97,1,1,1,0.97,0]
[null,"Hay and Pasture",0.98,1,1,1,0.98,0]
[null,"Orchard",0.84,1,1,1,0.84,0]
[null,"Planted Forest",0.62,1,1,1,{"$f":"C26*D26*E26*F26","v":0.62},0]
[null,"Silage corn, beans & canola",0.5,1,1,1,{"$f":"C27*D27*E27*F27","v":0.5},0]
[null,"Undisturbed Natural Vegetation",0.99,1,1,1,{"$f":"C28*D28*E28*F28","v":0.99},0]
[null,"Area-Weighted Average Efficiency ",null,null,null,null,{"$f":"IF(H29=0,\"0\",(H5/100*G5+H6/100*G6+H7/100*G7+H8/100*G8+H9/100*G9+H10/100*G10+H11/100*G11+H12/100*G12+H13/100*G13+H14/100*G14+H15/100*G15+H16/100*G16+H17/100*G17+H21/100*G21+H22/100*G22+H23/100*G23+H24/100*G24+H25/100*G25+H26/100*G26+H27/100*G27+H28/100*G28))","v":"0"},{"$f":"SUM(H5:H28)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"C31*D31*E31*F31","v":0}]
[null,null,null,null,null,null,{"$f":"C32*D32*E32*F32","v":0}]
[]
[]
[1,"( http://archive.chesapeakebay.net/pubs/calendar/USWG_05-21-07_Handout_6_8505.pdf)"]
[null,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[null,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[2,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[3,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[4," https://mail.uoguelph.ca/service/home/~/New%20Guidelines%20for%20TMDL%27s%20per%20ADEM_7_14_2011.pdf?auth=co&loc=en_US&id=14561&part=2"]
[5,"http://www.marionindiana.us/?q=filebrowser/download/1969"]
[6,"http://www.edenhydroseeding.com/why.shtml"]
[7,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4"]
[8,"Universal soil Loss Factsheet Ministry of Agriculture"]
[9,"http://www.ldd.go.th/efiles_project/ldd_plannig/flood/flood_coverFactor.html"]
[null,"https://mail.uoguelph.ca/service/home/~/ELC_PWP54.pdf?auth=co&loc=en_US&id=14823&part=3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4",null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,0.95,1]
[null,null,null,null,null,null,null,null,null,null,0.9,2]
[null,null,null,null,null,null,null,null,null,null,0.85,3]
[null,null,null,null,null,null,null,null,null,null,0.8,4]
[null,null,null,null,null,null,null,null,null,null,0.75,5]
[null,null,null,null,null,null,null,null,null,null,0.7,6]
[null,null,null,null,null,null,null,null,null,null,0.65,7]
[null,null,null,null,null,null,null,null,null,null,0.6,8]
[null,null,null,null,null,null,null,null,null,null,0.55000000000000004,9]
[null,null,null,null,null,null,null,null,null,null,0.5,10]
[null,null,null,null,null,null,null,null,null,null,0.45,11]
[null,null,null,null,null,null,null,null,null,null,0.4,12]
[null,null,null,null,null,null,null,null,null,null,0.35,13]
[null,null,null,null,null,null,null,null,null,null,0.3,14]
[null,null,null,null,null,null,null,null,null,null,0.25,15]
[null,null,null,null,null,null,null,null,null,null,0.2,16]
[null,null,null,null,null,null,null,null,null,null,0.15,17]
[null,null,null,null,null,null,null,null,null,null,0.1,18]
[null,null,null,null,null,null,null,null,null,null,0.05,19]
[null,null,null,null,null,null,null,null,null,null,0,20]

{"sheet":"9 - BMPs","index":18,"n_rows":80,"n_cols":20,"rows_kept":80,"cut":false,"hidden":true,"merged":[[1,1,1,17],[3,19,3,26],[15,14,15,15]]}
[]
[null,"BMP Efficiency "]
[]
[null,"Erosion Control BMP Efficiency","Maximum Efficiency ","Design Quality ","Instalation Quality","Maintenance Quality","Efficiency ","Percent Area Protected  (%)",null,null,"Sediment Control BMP Efficiency","Maximum Efficiency","Design Quality","Instalation Quality","Maintenance  Quality ","Number of BMPs","Net Efficiency ","Percent Runoff Treated (%)",null,"Table Mulching- Measured reductions in soil loss for different mulch treatments (Source: Harding, 1990, as \ncited in USEPA, 1993)"]
[null,"Chemical Stabilization",0.9,1,1,1,{"$f":"C5*D5*E5*F5","v":0.9},0,null,null,"Compost Filter Berm",0.88,1,1,1,0,{"$f":"1-((1-L5*M5*N5*O5)^P5)","v":0},0]
[null,"Compost Blankets",0.95,1,1,1,{"$f":"C6*D6*E6*F6","v":0.95},0,null,null,"Check Dam",0.8,1,1,1,0,{"$f":"1-((1-L6*M6*N6*O6)^P6)","v":0},0]
[null,"Hydroseeding-Hydromulching",0.9,1,1,1,0.9,0,null,null,"Compost Filter Socks",0.92,1,1,1,0,{"$f":"1-((1-L7*M7*N7*O7)^P7)","v":0},0]
[null,"Mulching (Table)",0.93,1,1,1,0.93,0,null,null,"Drain Inlet Sediment Barrier",0.7,1,1,1,0,0,0]
[null,"Riprap Armouring",0.95,1,1,1,0.95,0,null,null,"Fiber Rolls and Wattles",0.6,1,1,1,0,0,0]
[null,"Seeding",0.95,1,1,1,0.95,0,null,null,"Rock Filter Berm",0.95,1,1,1,0,0,0]
[null,"Slope Texturing / Roughening ",0.6,1,1,1,0.6,0,null,null,"Sandbag Barrier",0.65,1,1,1,0,0,0]
[null,"Sodding",0.95,1,1,1,0.95,0,null,null,"Sediment Pond",0.65,1,1,1,0,0,0]
[null,"Soil Retention",0.95,1,1,1,0.95,0,null,null,"Sediment Traps (Basins)",0.65,1,1,1,0,0,0]
[null,"Vegetated Buffer",0.74,1,1,1,0.74,0,null,null,"Silt Fence",0.75,1,1,1,0,0,0]
[null,"Bare Soil (Exposed Soil)",0,1,1,1,0,0,null,null,"Straw Bale Barrier",0.75,1,1,1,0,0,0]
[null,"Completed Construction Area",0.99,1,1,1,0.99,0,null,null,"Area-Weighted Average Efficiency ",null,null,null,null,null,{"$f":"IF(R16=0,\"0\",(R5/100*Q5+R6/100*Q6+R7/100*Q7+R8/100*Q8+R9/100*Q9+R10/100*Q10+R11/100*Q11+R12/100*Q12+R13/100*Q13+R14/100*Q14+R15/100*Q15))","v":"0"},{"$f":"SUM(R5:R15)","v":0}]
[null,"Disturbed Soil Stabilized by Vegetation",0.9,1,1,1,0.9,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,"Fruit Trees",0.9,1,1,1,0.9,0]
[null,"Grain Corn",0.6,1,1,1,0.6,0]
[null,"Grassland",0.97,1,1,1,0.97,0]
[null,"Hay and Pasture",0.98,1,1,1,0.98,0]
[null,"Orchard",0.84,1,1,1,0.84,0]
[null,"Planted Forest",0.62,1,1,1,{"$f":"C26*D26*E26*F26","v":0.62},0]
[null,"Silage corn, beans & canola",0.5,1,1,1,{"$f":"C27*D27*E27*F27","v":0.5},0]
[null,"Undisturbed Natural Vegetation",0.99,1,1,1,{"$f":"C28*D28*E28*F28","v":0.99},0]
[null,"Area-Weighted Average Efficiency ",null,null,null,null,{"$f":"IF(H29=0,\"0\",(H5/100*G5+H6/100*G6+H7/100*G7+H8/100*G8+H9/100*G9+H10/100*G10+H11/100*G11+H12/100*G12+H13/100*G13+H14/100*G14+H15/100*G15+H16/100*G16+H17/100*G17+H21/100*G21+H22/100*G22+H23/100*G23+H24/100*G24+H25/100*G25+H26/100*G26+H27/100*G27+H28/100*G28))","v":"0"},{"$f":"SUM(H5:H28)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"C31*D31*E31*F31","v":0}]
[null,null,null,null,null,null,{"$f":"C32*D32*E32*F32","v":0}]
[]
[]
[1,"( http://archive.chesapeakebay.net/pubs/calendar/USWG_05-21-07_Handout_6_8505.pdf)"]
[null,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[null,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[2,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[3,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[4," https://mail.uoguelph.ca/service/home/~/New%20Guidelines%20for%20TMDL%27s%20per%20ADEM_7_14_2011.pdf?auth=co&loc=en_US&id=14561&part=2"]
[5,"http://www.marionindiana.us/?q=filebrowser/download/1969"]
[6,"http://www.edenhydroseeding.com/why.shtml"]
[7,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4"]
[8,"Universal soil Loss Factsheet Ministry of Agriculture"]
[9,"http://www.ldd.go.th/efiles_project/ldd_plannig/flood/flood_coverFactor.html"]
[null,"https://mail.uoguelph.ca/service/home/~/ELC_PWP54.pdf?auth=co&loc=en_US&id=14823&part=3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4",null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,0.95,1]
[null,null,null,null,null,null,null,null,null,null,0.9,2]
[null,null,null,null,null,null,null,null,null,null,0.85,3]
[null,null,null,null,null,null,null,null,null,null,0.8,4]
[null,null,null,null,null,null,null,null,null,null,0.75,5]
[null,null,null,null,null,null,null,null,null,null,0.7,6]
[null,null,null,null,null,null,null,null,null,null,0.65,7]
[null,null,null,null,null,null,null,null,null,null,0.6,8]
[null,null,null,null,null,null,null,null,null,null,0.55000000000000004,9]
[null,null,null,null,null,null,null,null,null,null,0.5,10]
[null,null,null,null,null,null,null,null,null,null,0.45,11]
[null,null,null,null,null,null,null,null,null,null,0.4,12]
[null,null,null,null,null,null,null,null,null,null,0.35,13]
[null,null,null,null,null,null,null,null,null,null,0.3,14]
[null,null,null,null,null,null,null,null,null,null,0.25,15]
[null,null,null,null,null,null,null,null,null,null,0.2,16]
[null,null,null,null,null,null,null,null,null,null,0.15,17]
[null,null,null,null,null,null,null,null,null,null,0.1,18]
[null,null,null,null,null,null,null,null,null,null,0.05,19]
[null,null,null,null,null,null,null,null,null,null,0,20]

{"sheet":"10 - BMPs","index":19,"n_rows":80,"n_cols":20,"rows_kept":80,"cut":false,"hidden":true,"merged":[[1,1,1,17],[3,19,3,26],[15,14,15,15]]}
[]
[null,"BMP Efficiency "]
[]
[null,"Erosion Control BMP Efficiency","Maximum Efficiency ","Design Quality ","Instalation Quality","Maintenance Quality","Efficiency ","Percent Area Protected  (%)",null,null,"Sediment Control BMP Efficiency","Maximum Efficiency","Design Quality","Instalation Quality","Maintenance  Quality ","Number of BMPs","Net Efficiency ","Percent Runoff Treated (%)",null,"Table Mulching- Measured reductions in soil loss for different mulch treatments (Source: Harding, 1990, as \ncited in USEPA, 1993)"]
[null,"Chemical Stabilization",0.9,1,1,1,{"$f":"C5*D5*E5*F5","v":0.9},0,null,null,"Compost Filter Berm",0.88,1,1,1,0,{"$f":"1-((1-L5*M5*N5*O5)^P5)","v":0},0]
[null,"Compost Blankets",0.95,1,1,1,{"$f":"C6*D6*E6*F6","v":0.95},0,null,null,"Check Dam",0.8,1,1,1,0,{"$f":"1-((1-L6*M6*N6*O6)^P6)","v":0},0]
[null,"Hydroseeding-Hydromulching",0.9,1,1,1,0.9,0,null,null,"Compost Filter Socks",0.92,1,1,1,0,{"$f":"1-((1-L7*M7*N7*O7)^P7)","v":0},0]
[null,"Mulching (Table)",0.93,1,1,1,0.93,0,null,null,"Drain Inlet Sediment Barrier",0.7,1,1,1,0,0,0]
[null,"Riprap Armouring",0.95,1,1,1,0.95,0,null,null,"Fiber Rolls and Wattles",0.6,1,1,1,0,0,0]
[null,"Seeding",0.95,1,1,1,0.95,0,null,null,"Rock Filter Berm",0.95,1,1,1,0,0,0]
[null,"Slope Texturing / Roughening ",0.6,1,1,1,0.6,0,null,null,"Sandbag Barrier",0.65,1,1,1,0,0,0]
[null,"Sodding",0.95,1,1,1,0.95,0,null,null,"Sediment Pond",0.65,1,1,1,0,0,0]
[null,"Soil Retention",0.95,1,1,1,0.95,0,null,null,"Sediment Traps (Basins)",0.65,1,1,1,0,0,0]
[null,"Vegetated Buffer",0.74,1,1,1,0.74,0,null,null,"Silt Fence",0.75,1,1,1,0,0,0]
[null,"Bare Soil (Exposed Soil)",0,1,1,1,0,0,null,null,"Straw Bale Barrier",0.75,1,1,1,0,0,0]
[null,"Completed Construction Area",0.99,1,1,1,0.99,0,null,null,"Area-Weighted Average Efficiency ",null,null,null,null,null,{"$f":"IF(R16=0,\"0\",(R5/100*Q5+R6/100*Q6+R7/100*Q7+R8/100*Q8+R9/100*Q9+R10/100*Q10+R11/100*Q11+R12/100*Q12+R13/100*Q13+R14/100*Q14+R15/100*Q15))","v":"0"},{"$f":"SUM(R5:R15)","v":0}]
[null,"Disturbed Soil Stabilized by Vegetation",0.9,1,1,1,0.9,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,"Fruit Trees",0.9,1,1,1,0.9,0]
[null,"Grain Corn",0.6,1,1,1,0.6,0]
[null,"Grassland",0.97,1,1,1,0.97,0]
[null,"Hay and Pasture",0.98,1,1,1,0.98,0]
[null,"Orchard",0.84,1,1,1,0.84,0]
[null,"Planted Forest",0.62,1,1,1,{"$f":"C26*D26*E26*F26","v":0.62},0]
[null,"Silage corn, beans & canola",0.5,1,1,1,{"$f":"C27*D27*E27*F27","v":0.5},0]
[null,"Undisturbed Natural Vegetation",0.99,1,1,1,{"$f":"C28*D28*E28*F28","v":0.99},0]
[null,"Area-Weighted Average Efficiency ",null,null,null,null,{"$f":"IF(H29=0,\"0\",(H5/100*G5+H6/100*G6+H7/100*G7+H8/100*G8+H9/100*G9+H10/100*G10+H11/100*G11+H12/100*G12+H13/100*G13+H14/100*G14+H15/100*G15+H16/100*G16+H17/100*G17+H21/100*G21+H22/100*G22+H23/100*G23+H24/100*G24+H25/100*G25+H26/100*G26+H27/100*G27+H28/100*G28))","v":"0"},{"$f":"SUM(H5:H28)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"C31*D31*E31*F31","v":0}]
[null,null,null,null,null,null,{"$f":"C32*D32*E32*F32","v":0}]
[]
[]
[1,"( http://archive.chesapeakebay.net/pubs/calendar/USWG_05-21-07_Handout_6_8505.pdf)"]
[null,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[null,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[2,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[3,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[4," https://mail.uoguelph.ca/service/home/~/New%20Guidelines%20for%20TMDL%27s%20per%20ADEM_7_14_2011.pdf?auth=co&loc=en_US&id=14561&part=2"]
[5,"http://www.marionindiana.us/?q=filebrowser/download/1969"]
[6,"http://www.edenhydroseeding.com/why.shtml"]
[7,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4"]
[8,"Universal soil Loss Factsheet Ministry of Agriculture"]
[9,"http://www.ldd.go.th/efiles_project/ldd_plannig/flood/flood_coverFactor.html"]
[null,"https://mail.uoguelph.ca/service/home/~/ELC_PWP54.pdf?auth=co&loc=en_US&id=14823&part=3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4",null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,0.95,1]
[null,null,null,null,null,null,null,null,null,null,0.9,2]
[null,null,null,null,null,null,null,null,null,null,0.85,3]
[null,null,null,null,null,null,null,null,null,null,0.8,4]
[null,null,null,null,null,null,null,null,null,null,0.75,5]
[null,null,null,null,null,null,null,null,null,null,0.7,6]
[null,null,null,null,null,null,null,null,null,null,0.65,7]
[null,null,null,null,null,null,null,null,null,null,0.6,8]
[null,null,null,null,null,null,null,null,null,null,0.55000000000000004,9]
[null,null,null,null,null,null,null,null,null,null,0.5,10]
[null,null,null,null,null,null,null,null,null,null,0.45,11]
[null,null,null,null,null,null,null,null,null,null,0.4,12]
[null,null,null,null,null,null,null,null,null,null,0.35,13]
[null,null,null,null,null,null,null,null,null,null,0.3,14]
[null,null,null,null,null,null,null,null,null,null,0.25,15]
[null,null,null,null,null,null,null,null,null,null,0.2,16]
[null,null,null,null,null,null,null,null,null,null,0.15,17]
[null,null,null,null,null,null,null,null,null,null,0.1,18]
[null,null,null,null,null,null,null,null,null,null,0.05,19]
[null,null,null,null,null,null,null,null,null,null,0,20]

{"sheet":"11 - BMPs","index":20,"n_rows":80,"n_cols":20,"rows_kept":80,"cut":false,"hidden":true,"merged":[[1,1,1,17],[3,19,3,26],[15,14,15,15]]}
[]
[null,"BMP Efficiency "]
[]
[null,"Erosion Control BMP Efficiency","Maximum Efficiency ","Design Quality ","Instalation Quality","Maintenance Quality","Efficiency ","Percent Area Protected  (%)",null,null,"Sediment Control BMP Efficiency","Maximum Efficiency","Design Quality","Instalation Quality","Maintenance  Quality ","Number of BMPs","Net Efficiency ","Percent Runoff Treated (%)",null,"Table Mulching- Measured reductions in soil loss for different mulch treatments (Source: Harding, 1990, as \ncited in USEPA, 1993)"]
[null,"Chemical Stabilization",0.9,1,1,1,{"$f":"C5*D5*E5*F5","v":0.9},0,null,null,"Compost Filter Berm",0.88,1,1,1,0,{"$f":"1-((1-L5*M5*N5*O5)^P5)","v":0},0]
[null,"Compost Blankets",0.95,1,1,1,{"$f":"C6*D6*E6*F6","v":0.95},0,null,null,"Check Dam",0.8,1,1,1,0,{"$f":"1-((1-L6*M6*N6*O6)^P6)","v":0},0]
[null,"Hydroseeding-Hydromulching",0.9,1,1,1,0.9,0,null,null,"Compost Filter Socks",0.92,1,1,1,0,{"$f":"1-((1-L7*M7*N7*O7)^P7)","v":0},0]
[null,"Mulching (Table)",0.93,1,1,1,0.93,0,null,null,"Drain Inlet Sediment Barrier",0.7,1,1,1,0,0,0]
[null,"Riprap Armouring",0.95,1,1,1,0.95,0,null,null,"Fiber Rolls and Wattles",0.6,1,1,1,0,0,0]
[null,"Seeding",0.95,1,1,1,0.95,0,null,null,"Rock Filter Berm",0.95,1,1,1,0,0,0]
[null,"Slope Texturing / Roughening ",0.6,1,1,1,0.6,0,null,null,"Sandbag Barrier",0.65,1,1,1,0,0,0]
[null,"Sodding",0.95,1,1,1,0.95,0,null,null,"Sediment Pond",0.65,1,1,1,0,0,0]
[null,"Soil Retention",0.95,1,1,1,0.95,0,null,null,"Sediment Traps (Basins)",0.65,1,1,1,0,0,0]
[null,"Vegetated Buffer",0.74,1,1,1,0.74,0,null,null,"Silt Fence",0.75,1,1,1,0,0,0]
[null,"Bare Soil (Exposed Soil)",0,1,1,1,0,0,null,null,"Straw Bale Barrier",0.75,1,1,1,0,0,0]
[null,"Completed Construction Area",0.99,1,1,1,0.99,0,null,null,"Area-Weighted Average Efficiency ",null,null,null,null,null,{"$f":"IF(R16=0,\"0\",(R5/100*Q5+R6/100*Q6+R7/100*Q7+R8/100*Q8+R9/100*Q9+R10/100*Q10+R11/100*Q11+R12/100*Q12+R13/100*Q13+R14/100*Q14+R15/100*Q15))","v":"0"},{"$f":"SUM(R5:R15)","v":0}]
[null,"Disturbed Soil Stabilized by Vegetation",0.9,1,1,1,0.9,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,"Fruit Trees",0.9,1,1,1,0.9,0]
[null,"Grain Corn",0.6,1,1,1,0.6,0]
[null,"Grassland",0.97,1,1,1,0.97,0]
[null,"Hay and Pasture",0.98,1,1,1,0.98,0]
[null,"Orchard",0.84,1,1,1,0.84,0]
[null,"Planted Forest",0.62,1,1,1,{"$f":"C26*D26*E26*F26","v":0.62},0]
[null,"Silage corn, beans & canola",0.5,1,1,1,{"$f":"C27*D27*E27*F27","v":0.5},0]
[null,"Undisturbed Natural Vegetation",0.99,1,1,1,{"$f":"C28*D28*E28*F28","v":0.99},0]
[null,"Area-Weighted Average Efficiency ",null,null,null,null,{"$f":"IF(H29=0,\"0\",(H5/100*G5+H6/100*G6+H7/100*G7+H8/100*G8+H9/100*G9+H10/100*G10+H11/100*G11+H12/100*G12+H13/100*G13+H14/100*G14+H15/100*G15+H16/100*G16+H17/100*G17+H21/100*G21+H22/100*G22+H23/100*G23+H24/100*G24+H25/100*G25+H26/100*G26+H27/100*G27+H28/100*G28))","v":"0"},{"$f":"SUM(H5:H28)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"C31*D31*E31*F31","v":0}]
[null,null,null,null,null,null,{"$f":"C32*D32*E32*F32","v":0}]
[]
[]
[1,"( http://archive.chesapeakebay.net/pubs/calendar/USWG_05-21-07_Handout_6_8505.pdf)"]
[null,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[null,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[2,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[3,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[4," https://mail.uoguelph.ca/service/home/~/New%20Guidelines%20for%20TMDL%27s%20per%20ADEM_7_14_2011.pdf?auth=co&loc=en_US&id=14561&part=2"]
[5,"http://www.marionindiana.us/?q=filebrowser/download/1969"]
[6,"http://www.edenhydroseeding.com/why.shtml"]
[7,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4"]
[8,"Universal soil Loss Factsheet Ministry of Agriculture"]
[9,"http://www.ldd.go.th/efiles_project/ldd_plannig/flood/flood_coverFactor.html"]
[null,"https://mail.uoguelph.ca/service/home/~/ELC_PWP54.pdf?auth=co&loc=en_US&id=14823&part=3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4",null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,0.95,1]
[null,null,null,null,null,null,null,null,null,null,0.9,2]
[null,null,null,null,null,null,null,null,null,null,0.85,3]
[null,null,null,null,null,null,null,null,null,null,0.8,4]
[null,null,null,null,null,null,null,null,null,null,0.75,5]
[null,null,null,null,null,null,null,null,null,null,0.7,6]
[null,null,null,null,null,null,null,null,null,null,0.65,7]
[null,null,null,null,null,null,null,null,null,null,0.6,8]
[null,null,null,null,null,null,null,null,null,null,0.55000000000000004,9]
[null,null,null,null,null,null,null,null,null,null,0.5,10]
[null,null,null,null,null,null,null,null,null,null,0.45,11]
[null,null,null,null,null,null,null,null,null,null,0.4,12]
[null,null,null,null,null,null,null,null,null,null,0.35,13]
[null,null,null,null,null,null,null,null,null,null,0.3,14]
[null,null,null,null,null,null,null,null,null,null,0.25,15]
[null,null,null,null,null,null,null,null,null,null,0.2,16]
[null,null,null,null,null,null,null,null,null,null,0.15,17]
[null,null,null,null,null,null,null,null,null,null,0.1,18]
[null,null,null,null,null,null,null,null,null,null,0.05,19]
[null,null,null,null,null,null,null,null,null,null,0,20]

{"sheet":"12 - BMPs","index":21,"n_rows":80,"n_cols":20,"rows_kept":80,"cut":false,"hidden":true,"merged":[[1,1,1,17],[3,19,3,26],[15,14,15,15]]}
[]
[null,"BMP Efficiency "]
[]
[null,"Erosion Control BMP Efficiency","Maximum Efficiency ","Design Quality ","Instalation Quality","Maintenance Quality","Efficiency ","Percent Area Protected  (%)",null,null,"Sediment Control BMP Efficiency","Maximum Efficiency","Design Quality","Instalation Quality","Maintenance  Quality ","Number of BMPs","Net Efficiency ","Percent Runoff Treated (%)",null,"Table Mulching- Measured reductions in soil loss for different mulch treatments (Source: Harding, 1990, as \ncited in USEPA, 1993)"]
[null,"Chemical Stabilization",0.9,1,1,1,{"$f":"C5*D5*E5*F5","v":0.9},0,null,null,"Compost Filter Berm",0.88,1,1,1,0,{"$f":"1-((1-L5*M5*N5*O5)^P5)","v":0},0]
[null,"Compost Blankets",0.95,1,1,1,{"$f":"C6*D6*E6*F6","v":0.95},0,null,null,"Check Dam",0.8,1,1,1,0,{"$f":"1-((1-L6*M6*N6*O6)^P6)","v":0},0]
[null,"Hydroseeding-Hydromulching",0.9,1,1,1,0.9,0,null,null,"Compost Filter Socks",0.92,1,1,1,0,{"$f":"1-((1-L7*M7*N7*O7)^P7)","v":0},0]
[null,"Mulching (Table)",0.93,1,1,1,0.93,0,null,null,"Drain Inlet Sediment Barrier",0.7,1,1,1,0,0,0]
[null,"Riprap Armouring",0.95,1,1,1,0.95,0,null,null,"Fiber Rolls and Wattles",0.6,1,1,1,0,0,0]
[null,"Seeding",0.95,1,1,1,0.95,0,null,null,"Rock Filter Berm",0.95,1,1,1,0,0,0]
[null,"Slope Texturing / Roughening ",0.6,1,1,1,0.6,0,null,null,"Sandbag Barrier",0.65,1,1,1,0,0,0]
[null,"Sodding",0.95,1,1,1,0.95,0,null,null,"Sediment Pond",0.65,1,1,1,0,0,0]
[null,"Soil Retention",0.95,1,1,1,0.95,0,null,null,"Sediment Traps (Basins)",0.65,1,1,1,0,0,0]
[null,"Vegetated Buffer",0.74,1,1,1,0.74,0,null,null,"Silt Fence",0.75,1,1,1,0,0,0]
[null,"Bare Soil (Exposed Soil)",0,1,1,1,0,0,null,null,"Straw Bale Barrier",0.75,1,1,1,0,0,0]
[null,"Completed Construction Area",0.99,1,1,1,0.99,0,null,null,"Area-Weighted Average Efficiency ",null,null,null,null,null,{"$f":"IF(R16=0,\"0\",(R5/100*Q5+R6/100*Q6+R7/100*Q7+R8/100*Q8+R9/100*Q9+R10/100*Q10+R11/100*Q11+R12/100*Q12+R13/100*Q13+R14/100*Q14+R15/100*Q15))","v":"0"},{"$f":"SUM(R5:R15)","v":0}]
[null,"Disturbed Soil Stabilized by Vegetation",0.9,1,1,1,0.9,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,"Fruit Trees",0.9,1,1,1,0.9,0]
[null,"Grain Corn",0.6,1,1,1,0.6,0]
[null,"Grassland",0.97,1,1,1,0.97,0]
[null,"Hay and Pasture",0.98,1,1,1,0.98,0]
[null,"Orchard",0.84,1,1,1,0.84,0]
[null,"Planted Forest",0.62,1,1,1,{"$f":"C26*D26*E26*F26","v":0.62},0]
[null,"Silage corn, beans & canola",0.5,1,1,1,{"$f":"C27*D27*E27*F27","v":0.5},0]
[null,"Undisturbed Natural Vegetation",0.99,1,1,1,{"$f":"C28*D28*E28*F28","v":0.99},0]
[null,"Area-Weighted Average Efficiency ",null,null,null,null,{"$f":"IF(H29=0,\"0\",(H5/100*G5+H6/100*G6+H7/100*G7+H8/100*G8+H9/100*G9+H10/100*G10+H11/100*G11+H12/100*G12+H13/100*G13+H14/100*G14+H15/100*G15+H16/100*G16+H17/100*G17+H21/100*G21+H22/100*G22+H23/100*G23+H24/100*G24+H25/100*G25+H26/100*G26+H27/100*G27+H28/100*G28))","v":"0"},{"$f":"SUM(H5:H28)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"C31*D31*E31*F31","v":0}]
[null,null,null,null,null,null,{"$f":"C32*D32*E32*F32","v":0}]
[]
[]
[1,"( http://archive.chesapeakebay.net/pubs/calendar/USWG_05-21-07_Handout_6_8505.pdf)"]
[null,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[null,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[2,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[3,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[4," https://mail.uoguelph.ca/service/home/~/New%20Guidelines%20for%20TMDL%27s%20per%20ADEM_7_14_2011.pdf?auth=co&loc=en_US&id=14561&part=2"]
[5,"http://www.marionindiana.us/?q=filebrowser/download/1969"]
[6,"http://www.edenhydroseeding.com/why.shtml"]
[7,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4"]
[8,"Universal soil Loss Factsheet Ministry of Agriculture"]
[9,"http://www.ldd.go.th/efiles_project/ldd_plannig/flood/flood_coverFactor.html"]
[null,"https://mail.uoguelph.ca/service/home/~/ELC_PWP54.pdf?auth=co&loc=en_US&id=14823&part=3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4",null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,0.95,1]
[null,null,null,null,null,null,null,null,null,null,0.9,2]
[null,null,null,null,null,null,null,null,null,null,0.85,3]
[null,null,null,null,null,null,null,null,null,null,0.8,4]
[null,null,null,null,null,null,null,null,null,null,0.75,5]
[null,null,null,null,null,null,null,null,null,null,0.7,6]
[null,null,null,null,null,null,null,null,null,null,0.65,7]
[null,null,null,null,null,null,null,null,null,null,0.6,8]
[null,null,null,null,null,null,null,null,null,null,0.55000000000000004,9]
[null,null,null,null,null,null,null,null,null,null,0.5,10]
[null,null,null,null,null,null,null,null,null,null,0.45,11]
[null,null,null,null,null,null,null,null,null,null,0.4,12]
[null,null,null,null,null,null,null,null,null,null,0.35,13]
[null,null,null,null,null,null,null,null,null,null,0.3,14]
[null,null,null,null,null,null,null,null,null,null,0.25,15]
[null,null,null,null,null,null,null,null,null,null,0.2,16]
[null,null,null,null,null,null,null,null,null,null,0.15,17]
[null,null,null,null,null,null,null,null,null,null,0.1,18]
[null,null,null,null,null,null,null,null,null,null,0.05,19]
[null,null,null,null,null,null,null,null,null,null,0,20]

{"sheet":"13 - BMPs","index":22,"n_rows":80,"n_cols":20,"rows_kept":80,"cut":false,"hidden":true,"merged":[[1,1,1,17],[3,19,3,26],[15,14,15,15]]}
[]
[null,"BMP Efficiency "]
[]
[null,"Erosion Control BMP Efficiency","Maximum Efficiency ","Design Quality ","Instalation Quality","Maintenance Quality","Efficiency ","Percent Area Protected  (%)",null,null,"Sediment Control BMP Efficiency","Maximum Efficiency","Design Quality","Instalation Quality","Maintenance  Quality ","Number of BMPs","Net Efficiency ","Percent Runoff Treated (%)",null,"Table Mulching- Measured reductions in soil loss for different mulch treatments (Source: Harding, 1990, as \ncited in USEPA, 1993)"]
[null,"Chemical Stabilization",0.9,1,1,1,{"$f":"C5*D5*E5*F5","v":0.9},0,null,null,"Compost Filter Berm",0.88,1,1,1,0,{"$f":"1-((1-L5*M5*N5*O5)^P5)","v":0},0]
[null,"Compost Blankets",0.95,1,1,1,{"$f":"C6*D6*E6*F6","v":0.95},0,null,null,"Check Dam",0.8,1,1,1,0,{"$f":"1-((1-L6*M6*N6*O6)^P6)","v":0},0]
[null,"Hydroseeding-Hydromulching",0.9,1,1,1,0.9,0,null,null,"Compost Filter Socks",0.92,1,1,1,0,{"$f":"1-((1-L7*M7*N7*O7)^P7)","v":0},0]
[null,"Mulching (Table)",0.93,1,1,1,0.93,0,null,null,"Drain Inlet Sediment Barrier",0.7,1,1,1,0,0,0]
[null,"Riprap Armouring",0.95,1,1,1,0.95,0,null,null,"Fiber Rolls and Wattles",0.6,1,1,1,0,0,0]
[null,"Seeding",0.95,1,1,1,0.95,0,null,null,"Rock Filter Berm",0.95,1,1,1,0,0,0]
[null,"Slope Texturing / Roughening ",0.6,1,1,1,0.6,0,null,null,"Sandbag Barrier",0.65,1,1,1,0,0,0]
[null,"Sodding",0.95,1,1,1,0.95,0,null,null,"Sediment Pond",0.65,1,1,1,0,0,0]
[null,"Soil Retention",0.95,1,1,1,0.95,0,null,null,"Sediment Traps (Basins)",0.65,1,1,1,0,0,0]
[null,"Vegetated Buffer",0.74,1,1,1,0.74,0,null,null,"Silt Fence",0.75,1,1,1,0,0,0]
[null,"Bare Soil (Exposed Soil)",0,1,1,1,0,0,null,null,"Straw Bale Barrier",0.75,1,1,1,0,0,0]
[null,"Completed Construction Area",0.99,1,1,1,0.99,0,null,null,"Area-Weighted Average Efficiency ",null,null,null,null,null,{"$f":"IF(R16=0,\"0\",(R5/100*Q5+R6/100*Q6+R7/100*Q7+R8/100*Q8+R9/100*Q9+R10/100*Q10+R11/100*Q11+R12/100*Q12+R13/100*Q13+R14/100*Q14+R15/100*Q15))","v":"0"},{"$f":"SUM(R5:R15)","v":0}]
[null,"Disturbed Soil Stabilized by Vegetation",0.9,1,1,1,0.9,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,"Fruit Trees",0.9,1,1,1,0.9,0]
[null,"Grain Corn",0.6,1,1,1,0.6,0]
[null,"Grassland",0.97,1,1,1,0.97,0]
[null,"Hay and Pasture",0.98,1,1,1,0.98,0]
[null,"Orchard",0.84,1,1,1,0.84,0]
[null,"Planted Forest",0.62,1,1,1,{"$f":"C26*D26*E26*F26","v":0.62},0]
[null,"Silage corn, beans & canola",0.5,1,1,1,{"$f":"C27*D27*E27*F27","v":0.5},0]
[null,"Undisturbed Natural Vegetation",0.99,1,1,1,{"$f":"C28*D28*E28*F28","v":0.99},0]
[null,"Area-Weighted Average Efficiency ",null,null,null,null,{"$f":"IF(H29=0,\"0\",(H5/100*G5+H6/100*G6+H7/100*G7+H8/100*G8+H9/100*G9+H10/100*G10+H11/100*G11+H12/100*G12+H13/100*G13+H14/100*G14+H15/100*G15+H16/100*G16+H17/100*G17+H21/100*G21+H22/100*G22+H23/100*G23+H24/100*G24+H25/100*G25+H26/100*G26+H27/100*G27+H28/100*G28))","v":"0"},{"$f":"SUM(H5:H28)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"C31*D31*E31*F31","v":0}]
[null,null,null,null,null,null,{"$f":"C32*D32*E32*F32","v":0}]
[]
[]
[1,"( http://archive.chesapeakebay.net/pubs/calendar/USWG_05-21-07_Handout_6_8505.pdf)"]
[null,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[null,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[2,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[3,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[4," https://mail.uoguelph.ca/service/home/~/New%20Guidelines%20for%20TMDL%27s%20per%20ADEM_7_14_2011.pdf?auth=co&loc=en_US&id=14561&part=2"]
[5,"http://www.marionindiana.us/?q=filebrowser/download/1969"]
[6,"http://www.edenhydroseeding.com/why.shtml"]
[7,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4"]
[8,"Universal soil Loss Factsheet Ministry of Agriculture"]
[9,"http://www.ldd.go.th/efiles_project/ldd_plannig/flood/flood_coverFactor.html"]
[null,"https://mail.uoguelph.ca/service/home/~/ELC_PWP54.pdf?auth=co&loc=en_US&id=14823&part=3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4",null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,0.95,1]
[null,null,null,null,null,null,null,null,null,null,0.9,2]
[null,null,null,null,null,null,null,null,null,null,0.85,3]
[null,null,null,null,null,null,null,null,null,null,0.8,4]
[null,null,null,null,null,null,null,null,null,null,0.75,5]
[null,null,null,null,null,null,null,null,null,null,0.7,6]
[null,null,null,null,null,null,null,null,null,null,0.65,7]
[null,null,null,null,null,null,null,null,null,null,0.6,8]
[null,null,null,null,null,null,null,null,null,null,0.55000000000000004,9]
[null,null,null,null,null,null,null,null,null,null,0.5,10]
[null,null,null,null,null,null,null,null,null,null,0.45,11]
[null,null,null,null,null,null,null,null,null,null,0.4,12]
[null,null,null,null,null,null,null,null,null,null,0.35,13]
[null,null,null,null,null,null,null,null,null,null,0.3,14]
[null,null,null,null,null,null,null,null,null,null,0.25,15]
[null,null,null,null,null,null,null,null,null,null,0.2,16]
[null,null,null,null,null,null,null,null,null,null,0.15,17]
[null,null,null,null,null,null,null,null,null,null,0.1,18]
[null,null,null,null,null,null,null,null,null,null,0.05,19]
[null,null,null,null,null,null,null,null,null,null,0,20]

{"sheet":"14 - BMPs","index":23,"n_rows":80,"n_cols":20,"rows_kept":80,"cut":false,"hidden":true,"merged":[[1,1,1,17],[3,19,3,26],[15,14,15,15]]}
[]
[null,"BMP Efficiency "]
[]
[null,"Erosion Control BMP Efficiency","Maximum Efficiency ","Design Quality ","Instalation Quality","Maintenance Quality","Efficiency ","Percent Area Protected  (%)",null,null,"Sediment Control BMP Efficiency","Maximum Efficiency","Design Quality","Instalation Quality","Maintenance  Quality ","Number of BMPs","Net Efficiency ","Percent Runoff Treated (%)",null,"Table Mulching- Measured reductions in soil loss for different mulch treatments (Source: Harding, 1990, as \ncited in USEPA, 1993)"]
[null,"Chemical Stabilization",0.9,1,1,1,{"$f":"C5*D5*E5*F5","v":0.9},0,null,null,"Compost Filter Berm",0.88,1,1,1,0,{"$f":"1-((1-L5*M5*N5*O5)^P5)","v":0},0]
[null,"Compost Blankets",0.95,1,1,1,{"$f":"C6*D6*E6*F6","v":0.95},0,null,null,"Check Dam",0.8,1,1,1,0,{"$f":"1-((1-L6*M6*N6*O6)^P6)","v":0},0]
[null,"Hydroseeding-Hydromulching",0.9,1,1,1,0.9,0,null,null,"Compost Filter Socks",0.92,1,1,1,0,{"$f":"1-((1-L7*M7*N7*O7)^P7)","v":0},0]
[null,"Mulching (Table)",0.93,1,1,1,0.93,0,null,null,"Drain Inlet Sediment Barrier",0.7,1,1,1,0,0,0]
[null,"Riprap Armouring",0.95,1,1,1,0.95,0,null,null,"Fiber Rolls and Wattles",0.6,1,1,1,0,0,0]
[null,"Seeding",0.95,1,1,1,0.95,0,null,null,"Rock Filter Berm",0.95,1,1,1,0,0,0]
[null,"Slope Texturing / Roughening ",0.6,1,1,1,0.6,0,null,null,"Sandbag Barrier",0.65,1,1,1,0,0,0]
[null,"Sodding",0.95,1,1,1,0.95,0,null,null,"Sediment Pond",0.65,1,1,1,0,0,0]
[null,"Soil Retention",0.95,1,1,1,0.95,0,null,null,"Sediment Traps (Basins)",0.65,1,1,1,0,0,0]
[null,"Vegetated Buffer",0.74,1,1,1,0.74,0,null,null,"Silt Fence",0.75,1,1,1,0,0,0]
[null,"Bare Soil (Exposed Soil)",0,1,1,1,0,0,null,null,"Straw Bale Barrier",0.75,1,1,1,0,0,0]
[null,"Completed Construction Area",0.99,1,1,1,0.99,0,null,null,"Area-Weighted Average Efficiency ",null,null,null,null,null,{"$f":"IF(R16=0,\"0\",(R5/100*Q5+R6/100*Q6+R7/100*Q7+R8/100*Q8+R9/100*Q9+R10/100*Q10+R11/100*Q11+R12/100*Q12+R13/100*Q13+R14/100*Q14+R15/100*Q15))","v":"0"},{"$f":"SUM(R5:R15)","v":0}]
[null,"Disturbed Soil Stabilized by Vegetation",0.9,1,1,1,0.9,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,null,null,1,1,1,0]
[null,"Fruit Trees",0.9,1,1,1,0.9,0]
[null,"Grain Corn",0.6,1,1,1,0.6,0]
[null,"Grassland",0.97,1,1,1,0.97,0]
[null,"Hay and Pasture",0.98,1,1,1,0.98,0]
[null,"Orchard",0.84,1,1,1,0.84,0]
[null,"Planted Forest",0.62,1,1,1,{"$f":"C26*D26*E26*F26","v":0.62},0]
[null,"Silage corn, beans & canola",0.5,1,1,1,{"$f":"C27*D27*E27*F27","v":0.5},0]
[null,"Undisturbed Natural Vegetation",0.99,1,1,1,{"$f":"C28*D28*E28*F28","v":0.99},0]
[null,"Area-Weighted Average Efficiency ",null,null,null,null,{"$f":"IF(H29=0,\"0\",(H5/100*G5+H6/100*G6+H7/100*G7+H8/100*G8+H9/100*G9+H10/100*G10+H11/100*G11+H12/100*G12+H13/100*G13+H14/100*G14+H15/100*G15+H16/100*G16+H17/100*G17+H21/100*G21+H22/100*G22+H23/100*G23+H24/100*G24+H25/100*G25+H26/100*G26+H27/100*G27+H28/100*G28))","v":"0"},{"$f":"SUM(H5:H28)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"C31*D31*E31*F31","v":0}]
[null,null,null,null,null,null,{"$f":"C32*D32*E32*F32","v":0}]
[]
[]
[1,"( http://archive.chesapeakebay.net/pubs/calendar/USWG_05-21-07_Handout_6_8505.pdf)"]
[null,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[null,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[2,"http://cfpub.epa.gov/npdes/stormwater/menuofbmps/"]
[3,"http://www.epa.gov/npdes/pubs/compostblankets.pdf"]
[4," https://mail.uoguelph.ca/service/home/~/New%20Guidelines%20for%20TMDL%27s%20per%20ADEM_7_14_2011.pdf?auth=co&loc=en_US&id=14561&part=2"]
[5,"http://www.marionindiana.us/?q=filebrowser/download/1969"]
[6,"http://www.edenhydroseeding.com/why.shtml"]
[7,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4"]
[8,"Universal soil Loss Factsheet Ministry of Agriculture"]
[9,"http://www.ldd.go.th/efiles_project/ldd_plannig/flood/flood_coverFactor.html"]
[null,"https://mail.uoguelph.ca/service/home/~/ELC_PWP54.pdf?auth=co&loc=en_US&id=14823&part=3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"https://mail.uoguelph.ca/service/home/~/BMP_Effectiveness_Review_Final_Report_12May2010.pdf?auth=co&loc=en_US&id=15381&part=4",null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,0.95,1]
[null,null,null,null,null,null,null,null,null,null,0.9,2]
[null,null,null,null,null,null,null,null,null,null,0.85,3]
[null,null,null,null,null,null,null,null,null,null,0.8,4]
[null,null,null,null,null,null,null,null,null,null,0.75,5]
[null,null,null,null,null,null,null,null,null,null,0.7,6]
[null,null,null,null,null,null,null,null,null,null,0.65,7]
[null,null,null,null,null,null,null,null,null,null,0.6,8]
[null,null,null,null,null,null,null,null,null,null,0.55000000000000004,9]
[null,null,null,null,null,null,null,null,null,null,0.5,10]
[null,null,null,null,null,null,null,null,null,null,0.45,11]
[null,null,null,null,null,null,null,null,null,null,0.4,12]
[null,null,null,null,null,null,null,null,null,null,0.35,13]
[null,null,null,null,null,null,null,null,null,null,0.3,14]
[null,null,null,null,null,null,null,null,null,null,0.25,15]
[null,null,null,null,null,null,null,null,null,null,0.2,16]
[null,null,null,null,null,null,null,null,null,null,0.15,17]
[null,null,null,null,null,null,null,null,null,null,0.1,18]
[null,null,null,null,null,null,null,null,null,null,0.05,19]
[null,null,null,null,null,null,null,null,null,null,0,20]

{"sheet":"References","index":24,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,23]]}
[]
[null,"BMP References"]
[]
[]
[null,"Atlanta Regional Commission (ARC), 2001. Georgia Stormwater Management Manual Volume 2 Technical Handbook. 844 pp."]
[null,"Faucette, L.B., L.M. Risse, M.A. Nearing, J.W. Gaskin, and L.T. West, 2004. Runoff, erosion, and nutrient losses from compost and mulch blankets under simulated rainfall. Journal of Soil and Water Conservation, 59(4):154-160."]
[null,"Faucette, L.B.J. Governo, C.F. Jordan, B.G. Lockaby, H.F. Carino, and R. Governo. 2007. Erosion control and storm water quality from straw with PAM, mulch, and compost blankets of varying particle sizes. Journal of Soil and Water Conservation, 62(6):404-413."]
[null,"Faucette, L.B., J. Governo, R. Tyler, G. Gigley, C.F. Jordan, and B.G. Lockaby. 2009. Performance of compost filter socks and conventional sediment control barriers used for perimeter control on construction sites. Journal of Soil and Water Conservation, 64(1):81-88."]
[null,"Fifield, J.S., 2011. Designing and Reviewing Effective Sediment and Erosion Control Plans. "]
[null,"Gharabaghi, B., A. Fata, T. Van Seters, R.P. Rudra, G. Macmillan, D. Smith, J.Y. Li, A. Bradford, and G. Tesa, 2006. Evaluation of sediment control pond performance at construction sites in the Greater Toronto Area. Canadian Journal of Civil Engineering. 33:1336-1344."]
[null,"Government of Alberta (GOA), 2011. Field Guide For Erosion and Sediment Control Version 2. 237 pp."]
[null,"Keener, H.M., B. Faucette, and M.H. Klingman. 2007. Flow-Through Rates and Evaluation of Solids Separation of Compost Filter Socks versus Silt Fence ion Sediment Control Applications. Jounral of Environmental Quality. 36:742-752."]
[null,"Stone, R.P., Hilborn, D. 2012. Universal Soil Loss Equation (USLE) Factsheet, Ministry of Agriculture, Food and Rural Affairs, Ontario."]
[null,"Toy, T.J., and G.R. Foster (co-editors), J.R. Galetovic (publishing editor). 1998. Guidelines for the Use of the Revised Universal Soil Loss Equation (RUSLE) Version 1.06 on Mined Lands, Construction Sites, and Reclaimed Lands."]
[null,"Tyner, J.S., D.C. Yoder, B.J. Chomicki, and A. Tyagi. 2011. A Review of Construction Site Best Management Practices for Erosion Control.Transactions of the ASABE. 54(2):441-450."]
[null,"United States Environmental Protection Agency (USEPA).1993. Guidance Specifying Management Measures for Sources of Nonpoint Pollution in Coastal Waters EPA 840-B-92-002: Chapter 4 Management Measures for Urban Areas.182 pp."]
[null,"United States Environmental Protection Agency (USEPA).2014.Construction Site Stormwater Runoff Control. BMP Fact Sheets. Obtained from: http://water.epa.gov/polwaste/npdes /swbmp/Construction-Site-Stormwater-Run-Off-Control.cfm in February 2015."]
[null,"United States Department of Agriculture (USDA). 2014. Soil Texture Calculator, Natural Resource Conservation Service Soils"]
[null,"Wall,G.J., D.R. Coote, E.A. Pringle and I.J. Shelton (editors). 2002. RUSLEFAC — Revised Universal Soil Loss Equation for Application in Canada: A Handbook for Estimating Soil Loss from Water Erosion in Canada. Research Branch, Agriculture and Agri-Food Canada. Ottawa. Contribution No. AAFC/AAC2244E."]
[null,"Wischmeier, W.H., and  Smith, D.D. 1978. Predicting rainfall erosion losses –a guide to conservation planning. USDA, Agriculture Handbook No. 537."]