{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Notes","SatBuffer Design","Elevations","survey","Soil Investigation","Bank Stability","References","Modifications"],"not_rendered":{"charts":0,"images":5,"macros":0,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Notes","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"SatBuffer Design","index":1,"n_rows":44,"n_cols":26,"rows_kept":44,"cut":false,"hidden":false,"merged":[[12,5,12,8],[1,6,1,7],[11,2,11,3],[2,8,2,9],[3,8,3,9],[2,5,2,6],[3,5,3,6],[4,5,4,6],[4,8,4,9],[13,8,15,8],[13,5,15,7],[15,11,17,11],[38,1,38,2],[44,1,59,10]]}
[]
[null,"USDA- Natural Resources Conservation Service",null,null,null,null,"Maryland NRCS Version 2.2 - 4/13/2020"]
[null,"Project Name",null,null,"Designed by:",null,null,"Date:"]
[null,"Site Location",null,null,"Checked by:",null,null,"Date:"]
[null,"County",null,null,"Approved by:",null,null,"Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SATBUFF capacity",null,"Drain capacity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,{"$f":"IF(OR(D14=0,D14=\"\"),10000, D14*0.05)","v":8.158875707414423E-2},null,{"$f":"IF(D14>0,D14,10000)","v":1.6317751414828845}]
[null,"Determine System Capacity:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"CPT",null,null,{"$f":"IF(I11=\"\",10000, I11*0.05)","v":0.1558715277777778},null,{"$f":"IF(I11>0,I11,10000)","v":3.1174305555555555}]
[null,"Option 1 - Mainline Configuration",null,null,null,"Option 2 - Drainage Coefficient",null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Dual Wall",null,null,{"$f":"IF(I14>0,I14*0.05,10000)","v":10000},null,{"$f":"IF(I14>0,I14,10000)","v":10000}]
[null,"Mainline tile size (in)",null,null,null,"Drainage area of tile system (ac)",null,null,14.84,null,null,null,null,null,null,null,null,null,null,3,"Clay or Concrete"]
[null,"Mainline tile grade (%)",null,0.4,null,"Drainage coefficient (inches/day)",null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(X6:X9)","v":8.158875707414423E-2},null,{"$f":"MIN(Z6:Z8)","v":1.6317751414828845}]
[null,"Mainline tile material",null,null,null,"Capacity of drainage system ",null,null,{"$f":"IF(OR(I9=\"\",I10=\"\"),\"\", I9*I10*43560/12/24/3600)","v":3.1174305555555555}]
[null,null,{"$f":"IF(T6=2,0.012,IF(T6=3, 0.013,W13))","v":1.7999999999999999E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"selected","n","tile size"]
[null,"Peak velocity in mainline given size and grade",null,{"$f":"IF(X13=0,\"\",1.49*(D10/100)^0.5*((X13/12/4)^(2/3))/C12)","v":2.0776406382518235},null,"Option 3 - Saturated Buffer system flow rate (Based on DRAINMOD Model or other source)",null,null,null,null,null,null,null,null,null,null,null,null,null,"CPT",null,7,{"$f":"IF(X13=0,\"\", INDEX(V18:V27,V13))","v":1.7999999999999999E-2},{"$f":"INDEX(T18:T27,V13)","v":12}]
[null,"Peak flow from mainline size and grade",null,{"$f":"IF(X13=0,\"\",D13*PI()*(X13/2/12)^2)","v":1.6317751414828845},null,"Describe Value Used and source"]
[]
[null,"Minimum Design Capacity:",null,{"$f":"IF(OR(X10=10000,X10=0),\"\",X10)","v":8.158875707414423E-2}]
[null,"(5% of Option 1, 2, or 3; whichever is lower)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tile Dia. (in.)",null,"n",null,"Q @ dist line grade"]
[]
[null,"Selected Design Capacity",null,8.2000000000000003E-2,{"$f":"IF(AND(ISNUMBER(D16),ISNUMBER(D19),D19<D16),\"Design capacity must equal or exceed the minimum requirement\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,1.4999999999999999E-2,null,{"$f":"(T19^(8/3))*($U$31)^0.5/(1631.7*V19)","v":0.1164787603133372}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,1.4999999999999999E-2,null,0.21119004422790821]
[null,"Size Distribution Pipe:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,1.4999999999999999E-2,null,0.34341829728671164]
[null,"Distribution pipe min. grade (%)",null,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,1.6E-2,null,0.69336939995003655]
[null,"Design distribution pipe diameter (in)",null,{"$f":"IF(ISNUMBER(D22),Y30,\"\")","v":6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,1.7000000000000001E-2,null,1.1832116413150324]
[null,"Distance from dist. pipe to outlet channel, L (ft)",null,70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,1.7999999999999999E-2,null,1.8171418879268473]
[null,"Ground surface elevation at WCS (ft)",null,49.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,null,1.7999999999999999E-2,null,3.2946974594106631]
[null,"Depth of impervious layer (ft)",null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,null,0.02,null,4.8217872019012997]
[null,"Design water control weir elevation (ft)",null,49.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,null,0.02,null,7.2733219572385366]
[null,"Baseflow water elevation in ditch or outlet (ft)",null,43]
[null,"Head at WCS, h1",null,{"$f":"D$26-(D$25-D27)","v":7},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CPT distribution pipe",null,null,null,"match Q",{"$f":"MATCH(U32,X19:X27,1)","v":{"$error":"#N/A"}}]
[null,"Head at outlet, h2",null,{"$f":"D$26-(D$25-D28)","v":0.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"min dia",4,"in",null,"min dia",{"$f":"MAX(Y31,IF(AND(ISNUMBER(Y29),D22>0),INDEX(T19:T27,1+Y29),Y31))","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"grade, ft/ft",{"$f":"D22/100","v":5.0000000000000001E-3},"ft/ft",null,"Min dia Allow",6,"enter minimum allowed saturated buffer lateral size in cell AK31"]
[null,"Soil saturated hydraulic conductivity, Ksat (μm/sec)",null,43.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"flow req (cfs)",{"$f":"IF(D19>0,D19,D16)","v":8.2000000000000003E-2}]
[null,null,null,{"$f":"D32/1000000*3.28*60*60","v":0.50892479999999995}]
[null,"Unit flow from distribution pipe, q (ft3/hr per ft)",null,{"$f":"IF(D29-D30>0,D33/(2*D24)*(D29^2-D30^2),\"\")","v":0.1772148857142857}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Depth of impervious layer >10 ft?",null,null,{"$f":"IF(D26>10,1,0)","v":0}]
[null,"Distribution pipe length for min. design capacity",null,{"$f":"IF(AND(ISNUMBER(D34),ISNUMBER(D32)),ROUNDUP(D16*3600/D34,0),\"\")","v":1658},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Impervious layer < channel bottom?",{"$f":"IF(D25-D26<D28-2,1,0)","v":0},"(This alert assumes that the baseflow water depth is 2 ft)"]
[null,"Selected distribution pipe length (ft)",null,1675,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Channel depth > 8 ft?",{"$f":"IF(D25-D28>8,1,0)","v":0}]
[null,"Distribution pipe flow rate (ft3/hr)",null,{"$f":"IF(ISNUMBER(D34),D34*D37,\"\")","v":296.83493357142856}]
[null,"% of drainage system capacity handled by saturated buffer design",null,{"$f":"IF(ISNUMBER(D34),D34*D37/3600/(D16/0.05),\"\")","v":5.053033724938049E-2}]
[]
[null,{"$f":"IF(X37=1,\"CAUTION: channel may be incised deeper than 8 feet\",\"\")","v":""}]
[null,{"$f":"IF(X35=1,\"CAUTION: depth to impervious layer > 10 ft\",\"\")","v":""}]
[null,{"$f":"IF(X36=1,\"CAUTION: impervious layer more than 2 ft below channel bottom\",\"\")","v":""}]
[null,"Notes:"]

{"sheet":"Elevations","index":2,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,1],[11,0,11,1]]}
["INPUTS"]
["Inputs","Value"]
["Ground Surface (ft)"]
["Tile Depth (ft)"]
["Growing season boards, field (ft. below ground surface)"]
["Growing season boards, buffer (ft. below ground surface)"]
["Fallow season boards, field (ft. below ground surface)"]
["Fallow season boards, buffer (ft. below ground surface)"]
["Structure height (ft)"]
["Lowest Crop Elevation (ft)"]
[]
["CALCULATIONS"]
["Elevation Calculations"]
["Base Contour",{"$f":"B3","v":0}]
["Growing season field",{"$f":"B14-B5","v":0}]
["Growing season buffer",{"$f":"B3-B6","v":0}]
["Fallow season field",{"$f":"B3-B7","v":0}]
["Fallow season buffer",{"$f":"B3-B8","v":0}]
["Flowline of main pipe",{"$f":"B3-B4","v":0}]
["Top of Structure",{"$f":"B19+B9","v":0}]
[]
["Board Depth Calculations (in)"]
["Fallow - field",{"$f":"(B20-B17)*12","v":0}]
["Fallow - buffer",{"$f":"(B20-B18)*12","v":0}]
["Crop - field",{"$f":"(B20-B15)*12","v":0}]
["Crop - buffer",{"$f":"(B20-B16)*12","v":0}]

{"sheet":"survey","index":3,"n_rows":162,"n_cols":22,"rows_kept":162,"cut":false,"hidden":false,"merged":[]}
["FID","PT_ID","NORTHING","EASTING","ELEVATION","DESCRIPTION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Full Description","Description Format","Grid Easting","Grid Northing","Longitude","Latitude","Scale Factor","Convergence","Style","Point Label Style","Point Layer","Project Version","X-Y Scale","Z Scale","Marker Rotation","Label Rotation"]
[null,null,null,null,null,null,"BNKL",null,"4984.1273'","5440.5710'","W81° 30' 46.59\"","N37° 35' 34.29\"",1,"-2° 49' 56.92\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"BNKL",null,"5083.8119'","5154.4213'","W81° 30' 45.18\"","N37° 35' 31.52\"",1,"-2° 49' 56.03\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"BNKL",null,"5050.0152'","5032.5917'","W81° 30' 45.53\"","N37° 35' 30.30\"",1,"-2° 49' 56.25\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"BNKL",null,"5066.2247'","4943.2152'","W81° 30' 45.27\"","N37° 35' 29.42\"",1,"-2° 49' 56.09\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"BNKL",null,"5093.5701'","4860.2266'","W81° 30' 44.88\"","N37° 35' 28.62\"",1,"-2° 49' 55.84\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"BNKL",null,"4796.8892'","5471.9707'","W81° 30' 48.94\"","N37° 35' 34.51\"",1,"-2° 49' 58.39\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"EFLD",null,"4958.5120'","5373.3207'","W81° 30' 46.87\"","N37° 35' 33.62\"",1,"-2° 49' 57.09\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"EFLD",null,"5010.1033'","5310.2342'","W81° 30' 46.19\"","N37° 35' 33.02\"",1,"-2° 49' 56.66\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"EFLD",null,"5014.0278'","5178.6721'","W81° 30' 46.06\"","N37° 35' 31.72\"",1,"-2° 49' 56.58\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"EFLD",null,"5000.5118'","5109.6138'","W81° 30' 46.19\"","N37° 35' 31.03\"",1,"-2° 49' 56.66\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"EFLD",null,"4992.4299'","5046.0780'","W81° 30' 46.25\"","N37° 35' 30.40\"",1,"-2° 49' 56.70\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"EFLD",null,"5204.4960'","4717.4999'","W81° 30' 43.42\"","N37° 35' 27.26\"",1,"-2° 49' 54.92\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"EFLD",null,"5083.0303'","4780.5307'","W81° 30' 44.96\"","N37° 35' 27.82\"",1,"-2° 49' 55.89\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"EFLD",null,"5023.3340'","4844.8259'","W81° 30' 45.74\"","N37° 35' 28.43\"",1,"-2° 49' 56.38\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"EFLD",null,"4991.0195'","4932.3790'","W81° 30' 46.20\"","N37° 35' 29.28\"",1,"-2° 49' 56.67\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"EFLD",null,"4990.1667'","5027.7200'","W81° 30' 46.27\"","N37° 35' 30.22\"",1,"-2° 49' 56.71\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"EFLD",null,"4800.6260'","5410.2553'","W81° 30' 48.85\"","N37° 35' 33.90\"",1,"-2° 49' 58.33\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4925.9573'","4933.7070'","W81° 30' 47.00\"","N37° 35' 29.26\"",1,"-2° 49' 57.17\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4885.0846'","4850.3580'","W81° 30' 47.46\"","N37° 35' 28.42\"",1,"-2° 49' 57.46\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4846.1568'","4767.1074'","W81° 30' 47.89\"","N37° 35' 27.58\"",1,"-2° 49' 57.73\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4810.3414'","4690.3806'","W81° 30' 48.29\"","N37° 35' 26.80\"",1,"-2° 49' 57.98\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4708.4912'","4680.3466'","W81° 30' 49.55\"","N37° 35' 26.65\"",1,"-2° 49' 58.77\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4625.4218'","4721.2892'","W81° 30' 50.60\"","N37° 35' 27.02\"",1,"-2° 49' 59.43\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4556.7030'","4781.8415'","W81° 30' 51.49\"","N37° 35' 27.58\"",1,"-2° 49' 59.99\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4418.5834'","4898.3842'","W81° 30' 53.28\"","N37° 35' 28.66\"",1,"-2° 50' 01.11\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4357.5049'","4967.4307'","W81° 30' 54.08\"","N37° 35' 29.32\"",1,"-2° 50' 01.61\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4567.8999'","4699.5676'","W81° 30' 51.30\"","N37° 35' 26.77\"",1,"-2° 49' 59.87\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4541.8258'","4612.4547'","W81° 30' 51.57\"","N37° 35' 25.90\"",1,"-2° 50' 00.04\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4503.2452'","4524.0868'","W81° 30' 52.00\"","N37° 35' 25.01\"",1,"-2° 50' 00.31\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4454.7842'","4426.4322'","W81° 30' 52.54\"","N37° 35' 24.02\"",1,"-2° 50' 00.65\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4497.4430'","4385.3390'","W81° 30' 51.98\"","N37° 35' 23.64\"",1,"-2° 50' 00.30\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4531.4446'","4472.5985'","W81° 30' 51.62\"","N37° 35' 24.52\"",1,"-2° 50' 00.07\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4553.2707'","4531.2021'","W81° 30' 51.38\"","N37° 35' 25.10\"",1,"-2° 49' 59.92\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4587.6927'","4620.8124'","W81° 30' 51.01\"","N37° 35' 26.01\"",1,"-2° 49' 59.69\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4671.2498'","4604.2761'","W81° 30' 49.96\"","N37° 35' 25.88\"",1,"-2° 49' 59.03\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4646.2249'","4514.7397'","W81° 30' 50.22\"","N37° 35' 24.99\"",1,"-2° 49' 59.19\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4624.4519'","4421.1478'","W81° 30' 50.43\"","N37° 35' 24.05\"",1,"-2° 49' 59.32\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4623.5040'","4323.2922'","W81° 30' 50.38\"","N37° 35' 23.09\"",1,"-2° 49' 59.29\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4705.4121'","4364.0977'","W81° 30' 49.39\"","N37° 35' 23.53\"",1,"-2° 49' 58.67\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4733.2367'","4450.6973'","W81° 30' 49.10\"","N37° 35' 24.40\"",1,"-2° 49' 58.49\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4759.4926'","4537.8419'","W81° 30' 48.83\"","N37° 35' 25.27\"",1,"-2° 49' 58.32\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"GS",null,"4785.7812'","4621.2839'","W81° 30' 48.55\"","N37° 35' 26.11\"",1,"-2° 49' 58.15\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"PVC",null,"4941.9120'","4932.2854'","W81° 30' 46.81\"","N37° 35' 29.25\"",1,"-2° 49' 57.05\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"STA",null,"5000.0000'","5000.0000'","W81° 30' 46.13\"","N37° 35' 29.95\"",1,"-2° 49' 56.62\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"TBM_CHK",null,"4999.9572'","5464.8975'","W81° 30' 46.41\"","N37° 35' 34.54\"",1,"-2° 49' 56.80\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"TBM_NAIL_IN_TREE",null,"5000.0000'","5464.9176'","W81° 30' 46.41\"","N37° 35' 34.54\"",1,"-2° 49' 56.80\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"TOP",null,"5081.4359'","5037.6081'","W81° 30' 45.14\"","N37° 35' 30.36\"",1,"-2° 49' 56.00\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"WELL",null,"4795.1878'","4658.5130'","W81° 30' 48.46\"","N37° 35' 26.48\"",1,"-2° 49' 58.09\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"WELL",null,"4483.5534'","4842.0133'","W81° 30' 52.44\"","N37° 35' 28.14\"",1,"-2° 50' 00.58\"",null,null,"SURV-POINTS"]
[null,null,null,null,null,null,"WL",null,"5100.4983'","5035.1169'","W81° 30' 44.90\"","N37° 35' 30.35\"",1,"-2° 49' 55.85\"",null,null,"SURV-POINTS"]

{"sheet":"Soil Investigation","index":4,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Insert soils information"]

{"sheet":"Bank Stability","index":5,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Insert comments on bank stability and pictures of banks verifying visual stability"]

{"sheet":"References","index":6,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["References"]
[]
[]
["USDA – Natural Resources Conservation Service.  National Engineering Handbook, Part 650 Engineering Field Handbook, Chapter 3 Hydraulics."]
[]
["USDA – Natural Resources Conservation Service.  National Engineering Handbook, Part 650 Engineering Field Handbook, Chapter 19 Hydrology Tools for Wetland Identification and Analysis."]
[]
["USDA - Natural Resources Conservation Service. 2016. Field Office Technical Guide - Illinois.  Conservation Practice Standard 604 - Saturated Buffer."]
[]
["USDA - Natural Resources Conservation Service. 2016. Field Office Technical Guide - Illinois.  Conservation Practice Guidance 604 - Saturated Buffer."]
[]
["Utt, Nathan, D. Jaynes, J. Albertsen, S. Baker.  2015.  Demonstrate and Evaluate Saturated Buffers at Field Scale to Reduce Nitrates and Phosphorus from Subsurface Field Drainage Systems.  NRCS Conservation Innovation Grant 69-3A75-11-205 and FSA Order Number AG-3151-P-15-0168."]

{"sheet":"Modifications","index":7,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Date","Version","Description"]
[null,null,"Initial development by Matt Helmers and Laura Christianson, Iowa State University, for use in designing Denitrifying Bioreactors.  Adjusted by Bruce Atherton and Jerry Walker, NRCS."]
["2016-05-02",null,"Formatted for potential field use, and repurposed for the saturated buffer design, using criteria from draft CPS 604\nAdded adjustable Manning's 'n' for CPT based on tile size (ASAE EP260.5)\nAdded inputs for Ksat and drainable porosity\nAdded computation for hydraulic retention time"]
["2016-06-09",null,"Corrected units conversion errors. "]
[null,null,"Added inputs for drainage area and drainage coefficient; calculation for system flow using these inputs"]
[null,null,"Computation for saturated buffer design flow based on 15% of whichever is lower: capacity of mainline given grade and size, or system flow given drainage area and drainage coefficient"]
["2016-08-09",null,"Corrected design % of drainage capacity to use the capacity computed in the 6/9/16 update"]
["2016-08-11",null,"Added input for system capacity from a model or other source"]
["2016-08-18","1.0","Finalized version 1.0 for Illinois use"]
["2017-01-12","1.1","Updated References"]
[null,null,"Added user input alerts and warnings"]
[null,null,"Added guidance in cell notes on information expected"]
[null,null,"Added Example Design tab as a reference EXAMPLE ONLY"]
[null,null,"Added distribution pipe diameter sizing"]
["2017-03-17","1.2","Updated to national version and to meet March, 2017 pen-and-ink changes to CPS 604."]
[null,null,"This includes: buffer capacity 5% rather than 15% of drainage system capacity"]
[null,null,"Hydraulic retention time calculation no longer needed: removed."]
["2017-04-10","2.0","Finalized version 2.0 for Illinois use (formatting, etc)"]
["2017-04-10","2.1","Added warnings for potential data entry errors"]
["2020-04-13",2.2000000000000002,"Adapted for use in Maryland"]