{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["SatBuffer Design","Stability","Example Design","Stability Example","References","Modifications"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":4,"comments":4,"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":"SatBuffer Design","index":0,"n_rows":51,"n_cols":38,"rows_kept":51,"cut":false,"hidden":false,"merged":[[1,6,1,7],[11,2,11,3],[10,13,10,19],[2,8,2,9],[3,8,3,9],[2,5,2,6],[3,5,3,6],[12,5,12,8],[13,8,15,8],[15,11,17,11],[38,1,38,2],[51,1,61,9]]}
[]
[null,"USDA- Natural Resources Conservation Service",null,null,{"$f":"Modifications!C1","v":"IaSaturatedBuffer.xlsb"},null,{"$f":"Modifications!C2","v":"Iowa Version 3.0"},null,{"$f":"Modifications!B1","v":"2023-06-05"}]
[null,"Project Name",null,null,"Designed by:",null,null,"Date:"]
[null,"Site Location",null,null,"Checked by:",null,null,"Date:"]
[null,"County",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"AE6-1","v":1},null,null,null,{"$f":"IF(OR(D14=0,D14=\"\"),10000, D14*0.05)","v":10000},null,{"$f":"IF(D14>0,D14,10000)","v":""}]
[null,"Determine System Capacity:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"CPT",null,null,{"$f":"IF(I11=\"\",10000, I11*0.05)","v":10000},null,{"$f":"IF(I11>0,I11,10000)","v":""}]
[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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Clay or Concrete"]
[null,"Mainline tile grade (%)",null,null,null,"Drainage coefficient (inches/day)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(AJ6:AJ9)","v":10000},null,{"$f":"MIN(AL6:AL8)","v":10000}]
[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":""}]
[null,null,{"$f":"IF(AF6=2,0.012,IF(AF6=3, 0.013,AI13))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"selected","n","tile size"]
[null,"Peak velocity in mainline given size and grade",null,{"$f":"IF(AJ13=0,\"\",1.49*(D10/100)^0.5*((AJ13/12/4)^(2/3))/C12)","v":""},null,"Option 3 - Saturated Buffer design flow rate (Based on DRAINMOD Model or other source)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CPT",null,1,{"$f":"IF(AJ13=0,\"\", INDEX(AH18:AH27,AH13))","v":""},{"$f":"INDEX(AF18:AF27,AH13)","v":0}]
[null,"Peak flow from mainline size and grade",null,{"$f":"IF(AJ13=0,\"\",D13*PI()*(AJ13/2/12)^2)","v":""},null,"(Optional user-defined flow rate)"]
[null,null,null,null,null,null,null,"Enter design flow rate:"]
[null,"Minimum Design Capacity:",null,{"$f":"IF(OR(AJ10=10000,AJ10=0),\"\",AJ10)","v":""},null,"Source:"]
[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,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,null,{"$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,null,null,null,null,null,null,null,null,null,null,null,null,4,null,1.4999999999999999E-2,null,{"$f":"(AF19^(8/3))*($AG$31)^0.5/(1631.7*AH19)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,1.4999999999999999E-2,null,0]
[null,"Distribution Pipe Length:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,1.4999999999999999E-2,null,0]
[null,"Distribution pipe min. grade (%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,1.6E-2,null,0]
[null,"Design distribution pipe diameter (in)",null,{"$f":"IF(ISNUMBER(D22),AK30,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,1.7000000000000001E-2,null,0]
[null,"Distance from dist. pipe to outlet channel, L (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,1.7999999999999999E-2,null,0]
[null,"Ground surface elevation at WCS (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,null,1.7999999999999999E-2,null,0]
[null,"Depth of impervious layer (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,null,0.02,null,0]
[null,"Design water control weir elevation (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,null,0.02,null,0]
[null,"Baseflow water elevation in ditch or outlet (ft)"]
[null,"Head at WCS, h1",null,{"$f":"IF($D$26 <>\"\",D$26-(D$25-D27),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CPT distribution pipe",null,null,null,"match Q",{"$f":"MATCH(AG32,AJ19:AJ27,1)","v":{"$error":"#N/A"}}]
[null,"Head at outlet, h2",null,{"$f":"IF(D26<>\"\",D$26-(D$25-D28),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"min dia",4,"in",null,"min dia",{"$f":"MAX(AK31,IF(AND(ISNUMBER(AK29),$D$22>0),INDEX(AF19:AF27,1+AK29),AK31))","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"grade, ft/ft",{"$f":"D22/100","v":0},"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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"flow req (cfs)",{"$f":"IF(D19>0,D19,D16)","v":""}]
[null,null,null,{"$f":"IF(D32<>\"\",D32/1000000*3.28*60*60,\"\")","v":""}]
[null,"Unit flow from distribution pipe, q (ft3/hr per ft)",null,{"$f":"IF(D29<>\"\",IF(D29-D30>0,D33/(2*D24)*(D29^2-D30^2),\"\"),\"\")","v":""}]
[]
[null,"Distribution pipe length for min. design capacity",null,{"$f":"IF(ISNUMBER(D34),IF(D19<>\"\",ROUNDUP(D19*3600/D34,0),ROUNDUP(D16*3600/D34,0)),\"\")","v":""}]
[null,"Selected distribution pipe length (ft)"]
[null,"Distribution pipe flow rate (ft3/hr)",null,{"$f":"IF(ISNUMBER(D34),D34*D37,\"\")","v":""}]
[null,"% of drainage system capacity handled by saturated buffer design",null,{"$f":"IF(ISNUMBER(D34),D34*D37/3600/(D16/0.05),\"\")","v":""}]
[]
[]
[null,"Retention Time:"]
[null,"Soil water content, 1/3 bar (%)"]
[null,"Soil bulk density, 1/3 bar (g/cc)"]
[null,"Soil drainable porosity ",null,{"$f":"1-D44/2.65-D43/100","v":1}]
[]
[null,"Hydraulic retention volume (cubic feet)",null,{"$f":"IF(D37<>\"\",D37*D24*(D29-D30)*0.5*D45,\"\")","v":""}]
[null,"Hydraulic retention time",null,{"$f":"IF(D38<>\"\",D47/D38,\"\")","v":""}]
[]
[]
[null,"Notes:"]

{"sheet":"Stability","index":1,"n_rows":26,"n_cols":21,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Slope stability inputs:"]
["L: Distance from dist. pipe to outlet channel (ft)",{"$f":"IF(ISNUMBER('SatBuffer Design'!D24), 'SatBuffer Design'!D24, \"\")","v":""}]
["Egr: Ground surface elevation at streambank (ft)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check if any entries are blank"]
["Ew: Control weir elevation (ft)",{"$f":"IF(ISNUMBER('SatBuffer Design'!D27), 'SatBuffer Design'!D27, \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(B5), ISBLANK(B8), ISBLANK(B9), ISBLANK(B11), ISBLANK(B12), ISBLANK(B13)), 1, 2)","v":1}]
["Estr: Base flow water surface elevation (ft)",{"$f":"IF(ISNUMBER('SatBuffer Design'!D28), 'SatBuffer Design'!D28, \"\")","v":""}]
["Ebed: Channel bed flowline elevation (ft)"]
["L2: Horizontal distance from streambank to bottom of bank toe (ft)"]
["θbank: Slope angle of streambank (degrees)",{"$f":"IF(OR(ISBLANK(B5), ISBLANK(B8), ISBLANK(B9)), \"\", DEGREES(ATAN((B5-B8)/B9)))","v":""}]
["c': Soil cohesion (kPa)"]
["φ': Soil friction angle (degrees)"]
["ɣs: Soil unit weight (kN/m3)"]
[]
[]
["h0 (m)",{"$f":"IF(OR(B6 = \"\", ISBLANK(B8)), \"\", (B6-B8)/3.28084)","v":""}]
["hb: Height of the bank (m)",{"$f":"IF(OR(ISBLANK(B5), ISBLANK(B8)), \"\", (B5-B8)/3.28084)","v":""}]
["hwstr: Depth of water (m)",{"$f":"IF(OR(B7 = \"\", ISBLANK(B8)), \"\", (B7-B8)/3.28084)","v":""}]
["hgwt: Approximation of groundwater table head at start of slope (m)",{"$f":"IF(OR(B4 = \"\", B10 = \"\", B16 = \"\", B17 = \"\", B18 = \"\"), \"\", SQRT((B16^2)+((B18^2)-(B16^2))*((B4/3.28084)/((B4/3.28084)+((B17-B18)/TAN(RADIANS(B10)))))))","v":""}]
["hd (m)     design head",{"$f":"IF(OR(B6 = \"\", B7 = \"\"), \"\", (B6-B7)/3.28084)","v":""}]
["Lx  (m)     length of buffer",{"$f":"IF(OR(B4 = \"\", B10 = \"\", B17 = \"\", B18 = \"\"), \"\", (B4/3.28084)+((B17-B18)/TAN(RADIANS(B10))))","v":""}]
["P1",{"$f":"IF(OR(B10 = \"\", ISBLANK(B12)), \"\", TAN(RADIANS(B12))/TAN(RADIANS(B10)))","v":""}]
["P2",{"$f":"IF(OR(B10=\"\", ISBLANK(B11), ISBLANK(B13), B17 = \"\"), \"\", B11/(B13*B17*SIN(RADIANS(B10))))","v":""}]
["P3",{"$f":"IF(OR(B10 = \"\", ISBLANK(B12), ISBLANK(B13), B17 = \"\", B18 = \"\", B19 = \"\"), \"\", (9.81*(B19-B18)*TAN(RADIANS(B12)))/((B13-9.81)*B17*SIN(RADIANS(B10))))","v":""}]
["P4",{"$f":"IF(OR(B4 = \"\", B21 = \"\"), \"\", (B4/3.28084)/B21)","v":""}]
["Estimated factor of safety",{"$f":"IF(OR(B22 = \"\", B23 = \"\", B24 = \"\", B25 = \"\"), \"\", IF(U6=1, \"\", 0.4974*B22+6.4594*B23-0.4536*B24+0.3255*B25))","v":""}]

{"sheet":"Example Design","index":2,"n_rows":50,"n_cols":38,"rows_kept":50,"cut":false,"hidden":false,"merged":[[10,13,10,19],[15,11,17,11],[38,1,38,2],[1,6,1,7],[2,5,2,6],[2,8,2,9],[3,5,3,6],[3,8,3,9],[49,1,64,10],[11,2,11,3],[12,5,12,8],[13,5,15,7],[13,8,15,8]]}
[]
[null,"USDA- Natural Resources Conservation Service",null,null,null,null,"NRCS Version 1.2 - 3/17/2017"]
[null,"Project Name","EXAMPLE ONLY",null,"Designed by:","R.Book",null,"Date:","2017-02-16"]
[null,"Site Location",null,null,"Checked by:",null,null,"Date:"]
[null,"County",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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":1.0903097863802799E-2},null,{"$f":"IF(D14>0,D14,10000)","v":0.21806195727605596}]
[null,"Determine System Capacity:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"CPT",null,null,{"$f":"IF(I11=\"\",10000, I11*0.05)","v":1.9300130208333335E-2},null,{"$f":"IF(I11>0,I11,10000)","v":0.38600260416666665}]
[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,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,24.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Clay or Concrete"]
[null,"Mainline tile grade (%)",null,0.2,null,"Drainage coefficient (inches/day)",null,null,0.375,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(AJ6:AJ9)","v":1.0903097863802799E-2},null,{"$f":"MIN(AL6:AL8)","v":0.21806195727605596}]
[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":0.38600260416666665}]
[null,null,{"$f":"IF(AF6=2,0.012,IF(AF6=3, 0.013,AI13))","v":1.4999999999999999E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"selected","n","tile size"]
[null,"Peak velocity in mainline given size and grade",null,{"$f":"IF(AJ13=0,\"\",1.49*(D10/100)^0.5*((AJ13/12/4)^(2/3))/C12)","v":1.1105804288248959},null,"Option 3 - Saturated Buffer design flow rate (Based on DRAINMOD Model or other source)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CPT",null,4,{"$f":"IF(AJ13=0,\"\", INDEX(AH18:AH27,AH13))","v":1.4999999999999999E-2},{"$f":"INDEX(AF18:AF27,AH13)","v":6}]
[null,"Peak flow from mainline size and grade",null,{"$f":"IF(AJ13=0,\"\",D13*PI()*(AJ13/2/12)^2)","v":0.21806195727605596},null,"Describe Value Used and source"]
[]
[null,"Minimum Design Capacity:",null,{"$f":"IF(OR(AJ10=10000,AJ10=0),\"\",AJ10)","v":1.0903097863802799E-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,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,1.0999999999999999E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,1.4999999999999999E-2,null,{"$f":"(AF19^(8/3))*($AG$31)^0.5/(1631.7*AH19)","v":7.3667636324594693E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,1.4999999999999999E-2,null,0.13356831178237724]
[null,"Size Distribution Pipe:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,1.4999999999999999E-2,null,0.21719680192056626]
[null,"Distribution pipe min. grade (%)",null,0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,1.6E-2,null,0.43852531274127099]
[null,"Design distribution pipe diameter (in)",null,{"$f":"IF(D22>0,AK30,\"\")","v":6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,1.7000000000000001E-2,null,0.74832874811633776]
[null,"Distance from dist. pipe to outlet channel, L (ft)",null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,1.7999999999999999E-2,null,1.1492614395094525]
[null,"Ground surface elevation at WCS (ft)",null,100.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,null,1.7999999999999999E-2,null,2.0837496345815709]
[null,"Depth of impervious layer (ft)",null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,null,0.02,null,3.0495659901316552]
[null,"Design water control weir elevation (ft)",null,99.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,null,0.02,null,4.6000527081175155]
[null,"Baseflow water elevation in ditch or outlet (ft)",null,93.3]
[null,"Head at WCS, h1",null,{"$f":"D$26-(D$25-D27)","v":9},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CPT distribution pipe",null,null,null,"match Q",{"$f":"MATCH(AG32,AJ19:AJ27,1)","v":{"$error":"#N/A"}}]
[null,"Head at outlet, h2",null,{"$f":"D$26-(D$25-D28)","v":3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"min dia",4,"in",null,"min dia",{"$f":"MAX(AK31,IF(ISNUMBER(AK29),INDEX(AF19:AF27,1+AK29),AK31))","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"grade, ft/ft",{"$f":"D22/100","v":2E-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,9.17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"flow req (cfs)",{"$f":"IF(D19>0,D19,D16)","v":1.0999999999999999E-2}]
[null,null,null,{"$f":"D32/1000000*3.28*60*60","v":0.10827935999999999}]
[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.12993523199999998}]
[]
[null,"Distribution pipe length for min. design capacity",null,{"$f":"IF(ISNUMBER(D34),ROUNDUP(D16*3600/D34,0),\"\")","v":303}]
[null,"Selected distribution pipe length (ft)",null,310]
[null,"Distribution pipe flow rate (ft3/hr)",null,{"$f":"IF(ISNUMBER(D34),D34*D37,\"\")","v":40.279921919999992}]
[null,"% of drainage system capacity handled by saturated buffer design",null,{"$f":"IF(ISNUMBER(D34),D34*D37/3600/(D16/0.05),\"\")","v":5.1310496061609819E-2}]
[]
[null,"Retention Time:"]
[null,"Soil water content, 1/3 bar (%)"]
[null,"Soil bulk density, 1/3 bar (g/cc)"]
[null,"Soil drainable porosity ",null,{"$f":"1-D43/2.65-D42/100","v":1}]
[]
[null,"Hydraulic retention volume (cubic feet)",null,{"$f":"IF(D36<>\"\",D36*D23*(D28-D29)*0.5*D44,\"\")","v":76628.7}]
[null,"Hydraulic retention time",null,{"$f":"IF(D37<>\"\",D46/D37,\"\")","v":247.18935483870968}]
[]
[null,"Notes:"]
[null,"In this example, we entered information for Options 1 and 2; Option 1 yielded a lower number and represents the drainage system capacity.  The design is based on 5% of the drainage system capacity.\n\nIf we make sure that the distribution pipe is laid on a grade at least 0.2% or steeper, a 6 inch distribution pipe diameter will suffice (it will have adequate capacity for the design flow).  For this example, the spreadsheet automatically limited the minimum distribution pipe diameter to 6 inches.\n\nThe receiving channel (ditch, in this case) is approximately 7 feet deep as measured from the proposed water control structure location to the baseflow.  This is close to the 8 foot threshold in CPS 604, beyond which a slope stability analysis is needed.  In this case, we determined that the ditch bank is not at risk of saturated bank failure."]

{"sheet":"Stability Example","index":3,"n_rows":26,"n_cols":21,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Slope stability inputs:"]
["L: Distance from dist. pipe to outlet channel (ft)",30]
["Egr: Ground surface elevation at streambank (ft)",1206.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check if any entries are blank"]
["Ew: Control weir elevation (ft)",1206,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(B5), ISBLANK(B8), ISBLANK(B9), ISBLANK(B11), ISBLANK(B12), ISBLANK(B13)), 1, 2)","v":2}]
["Estr: Base flow water surface elevation (ft)",1200]
["Ebed: Channel bed flowline elevation (ft)",1198]
["L2: Horizontal distance from streambank to bottom of bank toe (ft)",10]
["θbank: Slope angle of streambank (degrees)",40.364536573097361]
["c': Soil cohesion (kPa)",8]
["φ': Soil friction angle (degrees)",28]
["ɣs: Soil unit weight (kN/m3)",19.100000000000001]
[]
[]
["h0 (m)",2.4383999219712025]
["hb: Height of the bank (m)",2.5907999170944027]
["hwstr: Depth of water (m)",0.60959998049280062]
["hgwt: Approximation of groundwater table head at start of slope (m)",1.2263229035423153]
["hd (m)     design head",1.828799941478402]
["Lx  (m)     length of buffer",11.474823162217422]
["P1",0.62554050783703385]
["P2",0.24962233127274094]
["P3",0.2063690493671361]
["P4",0.796875]
["Estimated factor of safety",2.0893281469283504]

{"sheet":"References","index":4,"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":5,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,5,0,13],[11,2,11,9],[27,1,33,1],[36,1,37,1],[36,0,37,0]]}
[null,{"$f":"MAX(A:A)","v":"2023-06-05"},"IaSaturatedBuffer.xlsb",null,null,"Development Notes"]
[null,null,"Iowa Version 3.0"]
[]
[null,null,null,null,"State Abreviation:","IA",null,null,null,"National Technical Contact: ","Clare Prestwich"]
[null,null,null,null,"State Contact: ","State Conservation Engineer",null,null,null,"USDA Center: ","WNTSC"]
[null,null,null,null,"USDA-Service Center/Office: ","210 Walnut Rm 693, Des Moines, IA",null,null,null,"Phone: ",5034143075]
[null,null,null,null,"Phone:","515-284-4135",null,null,null,"Email: ","clarence.prestwich@por.usda.gov"]
[]
[]
[]
[]
["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-24",null,"Updated graphics added Disclaimer screen"]
["2017-05-02",null,"Added formating to match Illinois sheet"]
["2017-05-03",null,"additional formating issues."]
["2017-08-04",null,"Added comments several input cell and enhanced cross section drawing to improve explaination of terms"]
["2017-08-23",null,"formula corrections"]
["2017-11-16",null,"Added Retention time"]
["2018-01-02",2,"Finalized version 2.0 for Iowa use"]
[null,null,"Minimum diameter for distribution pipe set at 6 inches. "]
["2023-06-05",3,"Revised to allow user to set water table level to align with CPS 604 change."]
[null,null,"Added Stability tab to calculate slope stability."]