{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Hydrology","Swale Design","Deletic Method from Ryan","Rational C Ref.","Manning's n","Output","Calculations (Hidden From User)"],"not_rendered":{"charts":7,"images":4,"macros":1,"external_links":1,"defined_names":58,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Hydrology","index":0,"n_rows":43,"n_cols":18,"rows_kept":43,"cut":false,"hidden":false,"merged":[[6,2,6,4],[16,1,16,3],[2,1,2,5],[14,6,15,7],[19,6,19,14],[9,10,10,14],[27,7,27,8],[16,4,16,9],[21,1,21,2],[26,1,26,2],[25,1,25,2],[24,1,24,2],[23,1,23,2],[22,1,22,2]]}
[]
[]
[null,"HYDROLOGY CALCULATIONS FOR CONVEYANCE"]
[]
[null,"Time of concentration calculator",null,null,null,null,"Rational Method Flow Calculation Summary"]
[]
[null,"Method",null,null,null,null,"Drainage Area",{"$f":"SUM(C37:C40)*(1/43560)","v":0},"ac."]
[null,null,null,null,null,null,"Rational C",{"$f":"D41","v":{"$error":"#DIV/0!"}}]
[null,"Time of concentration inputs",null,null,null,null,"Intensity",null,"in/h",null,"Choose intensity based on time of concencentration"]
[null,null,null,null,null,null,"Tc ",{"$f":"D30","v":false},"min",null,"NOAA Atlas 14 Precipitation Frequency Lookup"]
[null,"Variable","Description","Value"]
[null,"L","Length of main channel",null,"ft",null,"Peak Flow, Q",{"$f":"H7*H8*H9","v":{"$error":"#DIV/0!"}},"cfs"]
[null,"h","relief along main channel",null,"ft"]
[null,"S","overland flow slope",null,"ft/ft"]
[null,null,null,null,null,null,"Rational C Table"]
[null,"Land use type for Kerby-Hatheway Equation only"]
[null,null,null,null,{"$f":"IF(AND(C7=\"Kerby-Hatheway Equation\",B17=\"\")=TRUE, \"Must enter Kerby roughness land use\",\"\")","v":""}]
[]
[null,"Do not use if electing to use Kerby-Hatheway or Kirpich Equations"]
[null,"TR-55 Time of Concentration Calculation",null,null,null,null,"TR-55 Time of Concentration Equations:"]
[null,null,null,"Time (min)",null,null,"Time of concentration is the sum of travel times along each flow segment:"]
[null,"Sheet Flow 1",null,null,null,null,"Tc = Tt,sheet + Tt,shallow + Tt,channel"]
[null,"Sheet Flow 2"]
[null,"Shallow Concentrated Flow 1",null,null,null,null,"For sheet flow less than 300 ft:"]
[null,"Shallow Concentrated Flow 2"]
[null,"Channel Flow 1"]
[null,"Channel Flow 2"]
[null,null,null,null,null,null,"T,sheet","= travel time",null,"(hr)"]
[null,null,null,null,null,null,"n","= Manning's n"]
[null,"tc","Time of concentration",{"$f":"IF(C7=\"Kirpich Equation\",0.0078*(((D12^3)/D13)^0.385), IF(C7=\"Kerby-Hatheway Equation\", ((0.67*VLOOKUP(B17,'Calculations (Hidden From User)'!W9:X14,2,FALSE)*Hydrology!D12)/SQRT(Hydrology!D14))^0.467,IF(C7=\"TR-55\",SUM(D22:D27))))","v":false},"min",null,"L","= Flow length",null,"(ft)"]
[null,null,null,null,null,null,"P2","= 2-yr, 24-hr P",null,"(in.)"]
[null,null,null,null,null,null,"S","= land slope",null,"(ft/ft)"]
[]
[null,"Rational C Calculator",null,null,null,null,"For shallow concentrated flow:"]
[]
[null,"Area ID","Land use area (sf)","Raitonal C"]
[null,1,null,null,null,null,"For unpaved shallow flow",null,null,null,null,null,null,null,null,null,null,{"$f":"(C37*D37)","v":0}]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(C38*D38)","v":0}]
[null,3,null,null,null,null,"For channelized flow:",null,null,null,null,null,null,null,null,null,null,0]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Area-weighted composite C",{"$f":"SUM(R37:R40)/SUM(C37:C40)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,"Solve for velocity using Manning's equation: "]

{"sheet":"Swale Design","index":1,"n_rows":35,"n_cols":32,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,13,2,15],[19,16,19,17],[20,15,21,15],[20,17,21,17],[11,17,12,18],[21,20,21,23],[5,1,5,3],[34,1,34,8],[19,6,19,10],[21,6,21,10],[17,6,18,10],[20,6,20,10],[5,6,5,10],[16,6,16,10],[10,6,10,10],[5,14,5,17],[6,14,6,17],[7,14,7,17],[20,14,21,14],[20,16,21,16],[2,1,2,2],[11,6,11,10],[13,6,13,10],[15,6,15,10],[3,6,3,10],[14,6,14,10],[4,6,4,10],[6,6,6,10],[7,6,7,10],[8,6,8,10],[9,6,9,10],[3,19,3,24],[4,14,4,17],[14,14,15,14],[14,15,15,15],[11,13,11,14],[12,13,12,14]]}
[]
[]
[null,"SWALE DESIGN INPUTS",null,null,null,null,null,null,null,null,null,null,null,"COVER AND FLOW DYNAMICS",null,null,null,null,null,null,null,null,null,null,null,null,null,"Q",{"$f":"Hydrology!H7*Hydrology!H8*1","v":{"$error":"#DIV/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,"n",0.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Description","Value"]
[null,"Swale Geometry",null,null,null,null,"Comments",null,null,null,null,null,null,"Underlying soil type "]
[null,"Variable","Description","Value",null,null,null,null,null,null,null,null,null,"Swale Material",null,null,null,null,null,null,null,null,null,null,null,null,null,"LEFT SIDE",{"$f":"AC3*AC4*(1/(1.486*SQRT(D11)))","v":{"$error":"#DIV/0!"}}]
[null,"wb","Bottom Width",null,"ft",null,null,null,null,null,null,null,null,"Material",null,null,null,null,null,null,null,null,null,null,null,null,null,"RIGHT SIDE",{"$f":"((($D$8*$D$18)+($D$9*($D$18^2)))^(5/3))*((($D$8*$D$18)+(2*$D$18*SQRT(($D$9^2)+1)))^(-2/3))","v":0}]
[null,"z","Side slope (e:H)",null,"ft/ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Squared Error",{"$f":"(AC7-AC8)^2","v":{"$error":"#DIV/0!"}},null,null,0]
[null,"L","Swale Length",null,"ft"]
[null,"S","Longitudinal Slope",null,"ft/ft"]
[null,"G","Grass Height",null,"in",null,null,null,null,null,null,null,null,"Manning's n (WQ flow depth)",null,0.35,null,"Manning's n Nomograph"]
[null,"F","Freeboard",null,"ft",null,null,null,null,null,null,null,null,"Manning's n (flood conveyance)",null,2.1999999999999999E-2]
[null,"H","Swale depth",null,"ft"]
[null,"ymax","Flow depth (conveyance storm)",null,"ft",null,{"$f":"IF(D15<D18,\"Cannot have conveyance flow depth < WQ flow depth\",\"\")","v":"Cannot have conveyance flow depth < WQ flow depth"},null,null,null,null,null,null,null,"Hydraulic Radius (ft)","XS Area (sf)"]
[]
[null,"wt","Top width ",{"$f":"(2*D9*D14)+D8","v":0},"ft",null,null,null,null,null,null,null,null,"Water Quality Flow",{"$f":"P17/($D$8+2*SQRT(($D$18^2)+($D$9*$D$18)^2))","v":0},{"$f":"(((2*D18*D9)+(D8))+D8)*0.5*D18","v":0}]
[null,"yWQ","Depth of Flow (WQ)",0.28778504715766062,"ft",null,{"$f":"IF(D18*12>D12,\"WARNING: Flow Depth Exceeds Grass Height.    Re-design to meet flow height criterion\",\"Depth check: OK\")","v":"WARNING: Flow Depth Exceeds Grass Height.    Re-design to meet flow height criterion"},null,null,null,null,null,null,"Flood Conveyance Flow",{"$f":"P18/($D$8+2*SQRT(($D$15^2)+($D$9*$D$15)^2))","v":{"$error":"#DIV/0!"}},{"$f":"(D8+(2*D9*D15+D8))*0.5*D15","v":0}]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(Hydrology!H12=\"\",Hydrology!H12=0)=TRUE,\"Error: Please Calculate Peak Flow\",\"\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"Water Quality","Max Allowable","Flow Conveyance","Max Allowable"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"USDA Soil Texture Classification Triangle"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Velocity (ft/s)",{"$f":"(1.4859/P12)*(((0.5*('Swale Design'!$D$8+(2*'Swale Design'!$D$9*'Swale Design'!$D$18+'Swale Design'!$D$8))*'Swale Design'!$D$18)/('Swale Design'!$D$8+(2*SQRT(('Swale Design'!$D$18^2)+(('Swale Design'!$D$9*'Swale Design'!$D$18)^2)))))^(2/3))*SQRT('Swale Design'!$D$11)","v":0},{"$f":"VLOOKUP($O$8,'Calculations (Hidden From User)'!$AG$8:$AI$33, 2, FALSE)","v":{"$error":"#N/A"}},{"$f":"(1.4859/P13)*(((0.5*((2*D8)+(2*D9*D15))*D15)/(D8+2*SQRT((D15^2)+((D9*D15)^2))))^(2/3))*(SQRT(D11))","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($O$8,'Calculations (Hidden From User)'!$AG$8:$AI$33, 2, FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Shear stress (lb/ft2)",{"$f":"62.4*$D$18*$D$11","v":0},{"$f":"VLOOKUP($O$8,'Calculations (Hidden From User)'!$AG$8:$AI$33, 3, FALSE)","v":{"$error":"#N/A"}},{"$f":"62.4*'Swale Design'!$D$14*'Swale Design'!$D$11","v":0},{"$f":"VLOOKUP($O$8,'Calculations (Hidden From User)'!$AG$8:$AI$33, 3, FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Q (from Manning's)",{"$f":"Q23*P18","v":{"$error":"#DIV/0!"}},"cfs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Q(peak)",{"$f":"Hydrology!H12","v":{"$error":"#DIV/0!"}},"cfs",{"$f":"O27/O28","v":{"$error":"#DIV/0!"}},"Current Safety Factor"]
[]
[]
[]
[]
[]
[]
[null,"Swale Cross-Section Diagram"]

{"sheet":"Deletic Method from Ryan","index":2,"n_rows":120,"n_cols":35,"rows_kept":120,"cut":false,"hidden":true,"merged":[[1,1,1,2],[1,4,1,9]]}
[]
[null,"Accumulated Percentage (v/v)",null,null,"Deletic Method Settling Prediction",null,null,null,null,null,null,"TSS removal for water quality swale of 25 ft length ",null,null,null,null,"TSS removal for water quality swale of 25 ft length ",null,null,null,null,null,"TSS Removal Efficiency for 2% slope and 5:1 Side Slopes",null,null,null,null,null,null,null,null,"TSS removal for water quality swale of 25 ft length "]
[null,"Channel (um)","Average Event",null,"PSD: d_","Size (m)","Vs (m/s)","Nf","Trs","Trs*Mass",null," Slope (%)","Side Slope","Flow Depth (cm)","TSS Removal Efficiency (%)",null," Slope (%)","Side Slope","Flow Depth (ft)","TSS Removal Efficiency (%)",null,7.5,null,null,null,null,null,null,null,null,null," Slope (%)","Side Slope","Flow Depth (ft)","TSS Removal Efficiency (%)"]
[null,3.9989999999999998E-2,99.998743376184464,null,100,2E-3,{"$f":"$F$15/(18*$F$14)*($F$16-$F$17)*F4^2","v":3.5861610113107121},{"$f":"$F$18*G4/($F$21*$F$23)","v":61862.79403375378},{"$f":"H4^0.69/(H4^0.69+4.95)","v":0.99755961873012644},"-",null,0.5,"5:1",7,60.7,null,0.5,"8:1",null,null,null,15,null,null,null,null,null,null,null,null,null,0.5,"3:1"]
[null,4.3900000000000002E-2,99.998092237036289,null,90,3.9305396368110034E-4,{"$f":"$F$15/(18*$F$14)*($F$16-$F$17)*F5^2","v":0.13850777528104358},2389.3176985806736,0.97742236336026289,{"$f":"(E4-E5)*AVERAGE(I4:I5)","v":9.8749099104519473},null,1,"5:1",6.1,59.3,null,1,"8:1",null,null,null,30,null,null,null,null,null,null,null,null,null,1,"3:1"]
[null,4.8190999999999998E-2,99.997215409962237,null,75,1.4452161779753692E-4,1.8725586207302976E-2,323.02428113240035,0.91584943887867498,14.199538516792034,null,1.5,"5:1",5.8,58.5,null,1.5,"8:1",null,null,null,60,null,null,null,null,null,null,null,null,null,1.5,"3:1"]
[null,5.2902999999999999E-2,99.995612330480725,null,50,5.5662562437001008E-5,2.7777693645235969E-3,47.917696257588858,0.74470282533376397,20.756903302655488,null,2,"5:1",5.5,57.9,null,2,"8:1",null,null,null,90,null,null,null,null,null,null,null,null,null,2,"3:1"]
[null,5.8075000000000002E-2,99.992113271948128,null,25,3.017585003428293E-5,8.1637334952118501E-4,14.082785523792273,0.55616943515279793,16.260903256082024,null,3,"5:1",4.9000000000000004,57.1,null,3,"8:1",null,null,null,152.5,null,null,null,null,null,null,null,null,null,3,"3:1"]
[null,6.3753000000000004E-2,99.985202154351839,null,10,1.463654014193019E-5,1.9206430081319684E-4,3.3131904130821739,0.31586754651300825,6.5402773624935469,null,4,"5:1",4.9000000000000004,56.4,null,4,"8:1",null,null,null,305,null,null,null,null,null,null,null,null,null,4,"3:1"]
[null,6.9985000000000006E-2,99.973362338000001,null,0,3.9990000000000003E-8,1.4337472619760484E-9,2.473274660126462E-5,1.3387348735683215E-4,1.5800071000018254,null,5,"5:1",4.5999999999999996,56,null,5,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,5,"3:1"]
[null,7.6827000000000006E-2,99.95607674027778,null,null,null,null,null,"Cumulative Removal Efficiency = ",{"$f":"SUM(J5:J10)","v":69.212539448476861},null,7.5,"5:1",4,55.2,null,7.5,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,7.5,"3:1"]
[null,8.4337999999999996E-2,99.933687916944436,null,null,null,null,null,null,null,null,10,"5:1",4,54.6,null,10,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,10,"3:1"]
[null,9.2584E-2,99.906283341944473,null,"Constants",null,null,"Assume 6\" grass height"]
[null,0.10163999999999999,99.873647328055569,null,"μ = ",1.0020000000000001E-3,null,"Depth of Flow:",null,null,null,"TSS removal for water quality swale of 50 ft length ",null,null,null,null,"TSS removal for water quality swale of 50 ft length ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TSS removal for water quality swale of 50 ft length "]
[null,0.11157,99.835701817129632,null,"g = ",9.8000000000000007,null,0.5,"ft",null,null," Slope (%)","Side Slope","Flow Depth (cm)","TSS Removal Efficiency (%)",null," Slope (%)","Side Slope","Flow Depth (ft)","TSS Removal Efficiency (%)",null,null,null,null,null,null,null,null,null,null,null," Slope (%)","Side Slope","Flow Depth (ft)","TSS Removal Efficiency (%)"]
[null,0.12248000000000001,99.792824118981457,null,"ρs =",2650,null,null,null,null,null,0.5,"5:1",9,63.4,null,0.5,"8:1",null,null,null,null,"Removal Efficiency for 50 ft swale length",null,null,null,null,null,null,null,null,0.5,"3:1"]
[null,0.13444999999999999,99.745051906018546,null,"ρ = ",1000,null,null,null,null,null,1,"5:1",8,62.1,null,1,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,1,"3:1"]
[null,0.14760000000000001,99.692526085648169,null,"X = ",304.8,"m","<----Length of Swale",null,null,null,1.5,"5:1",7.3,61.3,null,1.5,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,"3:1"]
[null,0.16203000000000001,99.635285863425921,null,"S = ",10,"%",null,null,null,null,2,"5:1",7,60.7,null,2,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,2,"3:1"]
[null,0.17787,99.57328709120371,null,"n =",0.35,null,null,null,null,null,3,"5:1",6.4,59.9,null,3,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,3,"3:1"]
[null,0.19525999999999999,99.506396372685174,null,"d =",{"$f":"I34","v":0.15895489573016849},"m",null,null,null,null,4,"5:1",6.1,59.3,null,4,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,4,"3:1"]
[null,0.21435000000000001,99.433990400462974,null,"A=",{"$f":"5*F21^2","v":0.12633329438294369},"m2","<----assuming 5:1 side slopes",null,null,null,5,"5:1",5.8,58.8,null,5,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,5,"3:1"]
[null,0.23530000000000001,99.35572259675925,null,"V=",{"$f":"F28/1000/F22","v":0.11115814936357361},"m/s",null,null,null,null,7.5,"5:1",5.5,58,null,7.5,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,7.5,"3:1"]
[null,0.25830999999999998,99.271294054166631,null,null,null,null,null,null,null,null,10,"5:1",5.2,57.4,null,10,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,10,"3:1"]
[null,0.28355999999999998,99.180555209722229,null,null,"Qp (cfs)","C","I (in/hr)","A (acres)"]
[null,0.31128,99.084015174537029,null,null,{"$f":"G26*H26*I26","v":0.49586776859504134},0.9,1,{"$f":"F18*24/0.3048/43560","v":0.55096418732782371},null,null,"TSS removal for water quality swale of 100 ft length ",null,null,null,null,"TSS removal for water quality swale of 100 ft length ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TSS removal for water quality swale of 100 ft length "]
[null,0.34172000000000002,98.982285489351838,null,null,"Qp (L/s)",null,null,null,null,null," Slope (%)","Side Slope","Flow Depth (cm)","TSS Removal Efficiency (%)",null," Slope (%)","Side Slope","Flow Depth (ft)","TSS Removal Efficiency (%)",null,null,null,null,null,null,null,null,null,null,null," Slope (%)","Side Slope","Flow Depth (ft)","TSS Removal Efficiency (%)"]
[null,0.37512000000000001,98.876487563425925,null,null,{"$f":"F26*28.32","v":14.042975206611571},null,null,null,null,null,0.5,"5:1",11.9,66.2,null,0.5,"8:1",0.32,69.099999999999994,null,null,null,null,null,null,null,null,null,null,null,0.5,"3:1"]
[null,0.4118,98.76800805601853,null,null,null,null,null,null,null,null,1,"5:1",10.4,64.8,null,1,"8:1",0.28000000000000003,67.8,null,null,null,null,null,null,null,null,null,null,null,1,"3:1"]
[null,0.45206000000000002,98.657838817129658,null,null,"Q=1/n*s^(1/2)*A*R^(2/3)",null,null,null,null,null,1.5,"5:1",9.4,64,null,1.5,"8:1",0.26,67,null,null,"Removal Efficiency as a function of length",null,null,null,null,null,null,null,null,1.5,"3:1"]
[null,0.49625000000000002,98.547378380092596,null,null,{"$f":"F26*F20/(F19/100)^(0.5)","v":0.54882504845897495},{"$f":"G34*F34^2*(G34*F34/(2*(1+G34^2)^(1/2)))^(2/3)","v":0.54780931954141532},null,null,null,null,2,"5:1",9.1,63.5,null,2,"8:1",0.25,66.5,null,null,null,null,null,null,null,null,null,null,null,2,"3:1"]
[null,0.54476999999999998,98.437387870833334,null,null,null,null,null,null,null,null,3,"5:1",8.1999999999999993,62.7,null,3,"8:1",0.23,65.7,null,null,null,null,null,null,null,null,null,null,null,3,"3:1"]
[null,0.59802999999999995,98.328441652314808,null,null,"Flow Depth (ft)","Side Slope",null,"Flow Depth (m)",null,null,4,"5:1",7.9,62.1,null,4,"8:1",0.22,65.2,null,null,null,null,null,null,null,null,null,null,null,4,"3:1"]
[null,0.65649000000000002,98.22029339675926,null,null,0.52150556341918797,5,":1",{"$f":"F34*0.3048","v":0.15895489573016849},null,null,5,"5:1",7.6,61.6,null,5,"8:1",0.21,64.7,null,null,null,null,null,null,null,null,null,null,null,5,"3:1"]
[null,0.72067999999999999,98.112347361574066,null,null,null,null,null,null,null,null,7.5,"5:1",7,60.9,null,7.5,"8:1",0.19,63.9,null,null,null,null,null,null,null,null,null,null,null,7.5,"3:1"]
[null,0.79113,98.003595733796303,null,null,null,null,null,null,null,null,10,"5:1",6.7,60.3,null,10,"8:1",0.18,63.4,null,null,null,null,null,null,null,null,null,null,null,10,"3:1"]
[null,0.86848000000000003,97.892990920833327]
[null,0.95338000000000001,97.779179748611099,null,null,null,null,null,null,null,null,"TSS removal for water quality swale of 200 ft length ",null,null,null,null,"TSS removal for water quality swale of 200 ft length ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TSS removal for water quality swale of 200 ft length "]
[null,1.0466,97.660809322685211,null,null,null,null,null,null,null,null," Slope (%)","Side Slope","Flow Depth (cm)","TSS Removal Efficiency (%)",null," Slope (%)","Side Slope","Flow Depth (ft)","TSS Removal Efficiency (%)",null,null,null,null,null,null,null,null,null,null,null," Slope (%)","Side Slope","Flow Depth (ft)","TSS Removal Efficiency (%)"]
[null,1.1489,97.537420343055572,null,null,null,null,null,null,null,null,0.5,"5:1",15.2,68.8,null,0.5,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,"3:1"]
[null,1.2612000000000001,97.408613665277812,null,null,null,null,null,null,null,null,1,"5:1",13.4,67.5,null,1,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,1,"3:1"]
[null,1.3845000000000001,97.274197635648136,null,null,null,null,null,null,null,null,1.5,"5:1",12.5,66.7,null,1.5,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,"3:1"]
[null,1.5199,97.134807244907407,null,null,null,null,null,null,null,null,2,"5:1",11.9,66.2,null,2,"8:1",null,null,null,null,"Effect of Side Slopes on removal efficiency",null,null,null,null,null,null,null,null,2,"3:1"]
[null,1.6685000000000001,96.991671631944456,null,null,null,null,null,null,null,null,3,"5:1",11,65.400000000000006,null,3,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,3,"3:1"]
[null,1.8315999999999999,96.845430452314787,null,null,null,null,null,null,null,null,4,"5:1",10.4,64.900000000000006,null,4,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,4,"3:1"]
[null,2.0106999999999999,96.697594720833365,null,null,null,null,null,null,null,null,5,"5:1",9.8000000000000007,64.400000000000006,null,5,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,5,"3:1"]
[null,2.2071999999999998,96.547920867129619,null,null,null,null,null,null,null,null,7.5,"5:1",9.1,63.6,null,7.5,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,7.5,"3:1"]
[null,2.423,96.396066126388874,null,null,null,null,null,null,null,null,10,"5:1",8.5,63,null,10,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,10,"3:1"]
[null,2.6598999999999999,96.239476346759275]
[null,2.92,96.074875524537021,null,null,null,null,null,null,null,null,"TSS removal for water quality swale of 300 ft length ",null,null,null,null,"TSS removal for water quality swale of 300 ft length ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TSS removal for water quality swale of 300 ft length "]
[null,3.2054,95.897278046759254,null,null,null,null,null,null,null,null," Slope (%)","Side Slope","Flow Depth (cm)","TSS Removal Efficiency (%)",null," Slope (%)","Side Slope","Flow Depth (ft)","TSS Removal Efficiency (%)",null,null,null,null,null,null,null,null,null,null,null," Slope (%)","Side Slope","Flow Depth (ft)","TSS Removal Efficiency (%)"]
[null,3.5188000000000001,95.702051868981471,null,null,null,null,null,null,null,null,0.5,"5:1",17.7,70.3,null,0.5,"8:1",0.57999999999999996,68,null,null,null,null,null,null,null,null,null,null,null,0.5,"3:1"]
[null,3.8628,95.48361895601856,null,null,null,null,null,null,null,null,1,"5:1",15.5,69,null,1,"8:1",0.51,66.7,null,null,null,null,null,null,null,null,null,null,null,1,"3:1"]
[null,4.2404999999999999,95.237182841203676,null,null,null,null,null,null,null,null,1.5,"5:1",14.3,68.3,null,1.5,"8:1",0.47,66,null,null,null,null,null,null,null,null,null,null,null,1.5,"3:1"]
[null,4.6551,94.958764570833296,null,null,null,null,null,null,null,null,2,"5:1",13.7,67.7,null,2,"8:1",null,62.3,null,null,null,null,null,null,null,null,null,null,null,2,"3:1"]
[null,5.1101999999999999,94.645348339351841,null,null,null,null,null,null,null,null,3,"5:1",12.5,67,null,3,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,3,"3:1"]
[null,5.6097999999999999,94.295218870833381,null,null,null,null,null,null,null,null,4,"5:1",11.9,66.400000000000006,null,4,"8:1",null,null,null,null,"Effect of Side Slopes on removal efficiency",null,null,null,null,null,null,null,null,4,"3:1"]
[null,6.1581999999999999,93.905369006018518,null,null,null,null,null,null,null,null,5,"5:1",11.6,66,null,5,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,5,"3:1"]
[null,6.7603,93.47208533935185,null,null,null,null,null,null,null,null,7.5,"5:1",10.7,65.2,null,7.5,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,7.5,"3:1"]
[null,7.4211999999999998,92.990299006018518,null,null,null,null,null,null,null,null,10,"5:1",10,64.599999999999994,null,10,"8:1",0.33,62.2,null,null,null,null,null,null,null,null,null,null,null,10,"3:1"]
[null,8.1466999999999992,92.453192654166671]
[null,8.9431999999999992,91.851232302314827,null,null,null,null,null,null,null,null,"TSS removal for water quality swale of 500 ft length ",null,null,null,null,"TSS removal for water quality swale of 500 ft length ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TSS removal for water quality swale of 500 ft length "]
[null,9.8175000000000008,91.174614857870367,null,null,null,null,null,null,null,null," Slope (%)","Side Slope","Flow Depth (cm)","TSS Removal Efficiency",null," Slope (%)","Side Slope","Flow Depth (ft)","TSS Removal Efficiency",null,null,null,null,null,null,null,null,null,null,null," Slope (%)","Side Slope","Flow Depth (ft)","TSS Removal Efficiency"]
[null,10.776999999999999,90.413091524537037,null,null,null,null,null,null,null,null,0.5,"5:1",21.3,72.099999999999994,null,0.5,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,"3:1"]
[null,11.831,89.55684543194441,null,null,null,null,null,null,null,null,1,"5:1",18.899999999999999,70.900000000000006,null,1,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,1,"3:1"]
[null,12.988,88.596267357870389,null,null,null,null,null,null,null,null,1.5,"5:1",17.399999999999999,70.099999999999994,null,1.5,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,"3:1"]
[null,14.257,87.525517320833316,null,null,null,null,null,null,null,null,2,"5:1",16.5,69.599999999999994,null,2,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,2,"3:1"]
[null,15.651,86.338220376388861,null,null,null,null,null,null,null,null,3,"5:1",15.2,68.900000000000006,null,3,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,3,"3:1"]
[null,17.181000000000001,85.023296135648167,null,null,null,null,null,null,null,null,4,"5:1",14.6,68.3,null,4,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,4,"3:1"]
[null,18.861000000000001,83.558938209722243,null,null,null,null,null,null,null,null,5,"5:1",14,67.900000000000006,null,5,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,5,"3:1"]
[null,20.704999999999998,81.909991043055555,null,null,null,null,null,null,null,null,7.5,"5:1",12.8,67.2,null,7.5,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,7.5,"3:1"]
[null,22.728999999999999,80.034385450462977,null,null,null,null,null,null,null,null,10,"5:1",12.2,66.599999999999994,null,10,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,10,"3:1"]
[null,24.951000000000001,77.898281135648148]
[null,27.390999999999998,75.487436154166687,null,null,null,null,null,null,null,null,"TSS removal for water quality swale of 1000 ft length ",null,null,null,null,"TSS removal for water quality swale of 1000 ft length ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TSS removal for water quality swale of 1000 ft length "]
[null,30.068000000000001,72.805275950462956,null,null,null,null,null,null,null,null," Slope (%)","Side Slope","Flow Depth (cm)","TSS Removal Efficiency",null," Slope (%)","Side Slope","Flow Depth (ft)","TSS Removal Efficiency",null,null,null,null,null,null,null,null,null,null,null," Slope (%)","Side Slope","Flow Depth (ft)","TSS Removal Efficiency"]
[null,33.008000000000003,69.852730524537023,null,null,null,null,null,null,null,null,0.5,"5:1",28,74.400000000000006,null,0.5,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,"3:1"]
[null,36.234999999999999,66.631047394907426,null,null,null,null,null,null,null,null,1,"5:1",24.4,73.3,null,1,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,1,"3:1"]
[null,39.777999999999999,63.174434913425891,null,null,null,null,null,null,null,null,1.5,"5:1",22.9,72.599999999999994,null,1.5,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,"3:1"]
[null,43.667000000000002,59.561078765277792,null,null,null,null,null,null,null,null,2,"5:1",21.3,72.099999999999994,null,2,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,2,"3:1"]
[null,47.936,55.839782117129623,null,null,null,null,null,null,null,null,3,"5:1",19.8,71.400000000000006,null,3,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,3,"3:1"]
[null,52.622,52.006902857870372,null,null,null,null,null,null,null,null,4,"5:1",18.899999999999999,70.900000000000006,null,4,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,4,"3:1"]
[null,57.767000000000003,48.07177878379629,null,null,null,null,null,null,null,null,5,"5:1",18,70.5,null,5,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,5,"3:1"]
[null,63.414000000000001,44.131154709722239,null,null,null,null,null,null,null,null,7.5,"5:1",16.8,69.7,null,7.5,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,7.5,"3:1"]
[null,69.614000000000004,40.341796006018527,null,null,null,null,null,null,null,null,10,"5:1",15.8,69.2,null,10,"8:1",null,null,null,null,null,null,null,null,null,null,null,null,null,10,"3:1"]
[null,76.42,36.806431376388893]
[null,83.891000000000005,33.553913968981483]
[null,92.091999999999999,30.577876931944438]
[null,101.1,27.855604543055549]
[null,110.98,25.342905061574083]
[null,121.83,22.989177191203709]
[null,133.74,20.766509561574072]
[null,146.81,18.685813913425925]
[null,161.16999999999999,16.777668283796302]
[null,176.92,15.044654459722222]
[null,194.22,13.510963604722221]
[null,213.21,12.203398638055553]
[null,234.05,11.140675855]
[null,256.94,10.32910688698148]
[null,282.06,9.7230744350370379]
[null,309.63,9.2426701709629633]
[null,339.9,8.8158508515000022]
[null,373.13,8.3754840959444454]
[null,409.61,7.855921581407407]
[null,449.66,7.2006175443703704]
[null,493.62,6.4352064517777761]
[null,541.88,5.7112923654629633]
[null,594.85,5.0830326710185192]
[null,653.01,4.5183559691666666]
[null,716.85,3.9825836897222224]
[null,786.93,3.433890315833334]
[null,863.87,2.8560122762962967]
[null,948.32,2.2646642207407415]
[null,1041,1.6982908096296296]
[null,1142.8,1.2228624220370372]
[null,1254.5,0.87745615722222225]
[null,1377.2,0.64178394833333319]
[null,1511.8,0.45573064259259255]
[null,1659.6,0.29040580555555562]
[null,1821.9,0.13812829999999998]
[null,2000]

{"sheet":"Rational C Ref.","index":3,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Rational Coefficient"]

{"sheet":"Manning's n","index":4,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,1,1,8],[5,1,5,16]]}
[]
[null,"Manning's roughness (n) for Open Channel Flow"]
[]
[]
[null,"USE THE FOLLOWING NOMOGRAPH TO DETERMINE MANNING'S N FOR AVERAGE STANDS OF GRASS, BASED ON HYDRAULIC RADIUS AND CHANNEL SLOPE"]
[null,"Source: Federal Highway Adminstration (FHWA), Design of Roadside Channels with Flexible Linings. Hydraulic Engineering Circular Number 15 (HEC-15), 3rd ed."]
[null,"From your design:"]
[null,"Hydraulic Radius, R (ft)",null,null,{"$f":"'Swale Design'!O18","v":{"$error":"#DIV/0!"}}]
[null,"Channel Slope (ft/ft)",null,null,{"$f":"'Swale Design'!D11","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Nomograph for Manning's n versus hydraulic radius, R, for Class D Vegetation"]
[null,null,"Class D Vegetation: \"Uncut grass, good to excellent stand, average of 3.6 to 6 inches tall, or cut grass, good to very good stand, 2.4 inches tall"]

{"sheet":"Output","index":5,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[16,6,16,8],[12,1,12,3],[12,4,12,5],[13,1,13,3],[13,4,13,5],[38,1,38,3],[38,4,38,5],[7,1,8,5],[9,1,9,3],[9,4,9,5],[10,1,10,3],[10,4,10,5],[11,1,11,3],[11,4,11,5],[21,4,21,5],[35,1,35,7],[36,1,36,5],[26,4,26,5],[27,4,27,5],[30,1,32,3],[19,4,19,5],[21,1,21,3],[30,4,32,5],[25,4,25,5],[24,4,24,5],[23,4,23,5],[22,4,22,5],[37,1,37,3],[37,4,37,5],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[2,1,2,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[18,4,18,5],[16,1,17,5],[20,4,20,5]]}
[]
[]
[null,"OUTPUT SHEET"]
[]
[null,"DESIGN SUMMARY TABLE"]
[]
[]
[null,"Hydrology "]
[]
[null,"Drainage area (ac.)",null,null,{"$f":"Hydrology!H7","v":0}]
[null,"Design Q (WQ, cfs)",null,null,{"$f":"1*Hydrology!H7*Hydrology!H8","v":{"$error":"#DIV/0!"}}]
[null,"Design Q (Flow conveyance, cfs)",null,null,{"$f":"Hydrology!H12","v":{"$error":"#DIV/0!"}}]
[null,"Q maximum (cfs)",null,null,{"$f":"'Swale Design'!O27","v":{"$error":"#DIV/0!"}}]
[null,"Does conveyance swale handle design Q?",null,null,{"$f":"IF(E13>=E12,\"YES\",\"NO\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Swale Properties",null,null,null,null,"Meets Current NCDENR Design Criteria?"]
[null,null,null,null,null,null,"Curb Outlet","\"For-Credit\"","Conveyance"]
[null,"Length (ft)",null,null,{"$f":"'Swale Design'!D10","v":0},null,{"$f":"IF(E19>=100,\"X\",\"\")","v":""},{"$f":"IF(E19>=150,\"X\",\"\")","v":""}]
[null,"Bottom width",null,null,{"$f":"'Swale Design'!D8","v":0}]
[null,"Side slopes (e:H)",null,null,{"$f":"'Swale Design'!D9","v":0},null,{"$f":"IF($E$21>=5,\"X\",\"\")","v":""},{"$f":"IF($E$21>=5,\"X\",\"\")","v":""},{"$f":"IF(E21>=3,\"X\",\"\")","v":""}]
[null,"Longitudinal slope (ft/ft)",null,null,{"$f":"'Swale Design'!D11","v":0},null,{"$f":"IF($E$22<=0.05,\"X\",\"\")","v":"X"},{"$f":"IF($E$22<=0.05,\"X\",\"\")","v":"X"},{"$f":"IF($E$22<=0.05,\"X\",\"\")","v":"X"}]
[null,"WQ depth (ft)",null,null,{"$f":"'Swale Design'!D18","v":0.28778504715766062}]
[null,"Flow conveyance depth (ft)",null,null,{"$f":"'Swale Design'!D15","v":0}]
[null,"Top width (ft)",null,null,{"$f":"'Swale Design'!D17","v":0}]
[null,"Freeboard (ft)",null,null,{"$f":"'Swale Design'!D13","v":0},null,{"$f":"IF($E$26>=0.5,\"X\",\"\")","v":""},{"$f":"IF($E$26>=0.5,\"X\",\"\")","v":""},{"$f":"IF($E$26>=0.5,\"X\",\"\")","v":""}]
[null,"Max velocity (within WQ area)",null,null,{"$f":"'Swale Design'!O23","v":0},null,{"$f":"IF(G39=\"YES\",\"X\",\"\")","v":{"$error":"#N/A"}},{"$f":"IF(AND(E27<=1,G38=\"YES\")=TRUE,\"X\",\"\")","v":{"$error":"#N/A"}},{"$f":"IF(G39=\"YES\",\"X\",\"\")","v":{"$error":"#N/A"}}]
[null,"Underlying soil type",null,null,{"$f":"'Swale Design'!O6","v":0}]
[]
[]
[null,"Cumulative Sediment Removal Efficiency",null,null,{"$f":"IF('Swale Design'!O6=\"Sandy loam\",'Calculations (Hidden From User)'!G12, IF('Swale Design'!O6=\"Silt loam\", 'Calculations (Hidden From User)'!N12,))","v":0}]
[]
[]
[]
[]
[null,"Hydraulic Design"]
[null,null,null,null,null,null,"v < vmax?","τ < τmax?"]
[null,"Water Quality Design Flow",null,null,{"$f":"'Swale Design'!O8","v":0},null,{"$f":"IF('Swale Design'!P23>='Swale Design'!O23,\"YES\",\"NO\")","v":{"$error":"#N/A"}},{"$f":"IF('Swale Design'!P24>='Swale Design'!O24,\"YES\",\"NO\")","v":{"$error":"#N/A"}}]
[null,"Conveyance-Only Design Flow",null,null,{"$f":"'Swale Design'!O8","v":0},null,{"$f":"IF('Swale Design'!R23>='Swale Design'!Q23,\"YES\",\"NO\")","v":{"$error":"#N/A"}},{"$f":"IF('Swale Design'!R24>='Swale Design'!Q24,\"YES\",\"NO\")","v":{"$error":"#N/A"}}]

{"sheet":"Calculations (Hidden From User)","index":6,"n_rows":67,"n_cols":35,"rows_kept":67,"cut":false,"hidden":true,"merged":[[2,1,2,6],[2,8,2,13],[18,2,18,3],[18,4,18,5]]}
[]
[null,"Sandy loam",null,null,null,null,null,null,"Silt loam"]
[null,"Deletic Method Settling Prediction",null,null,null,null,null,null,"Deletic Method Settling Prediction",null,null,null,null,null,null,null,null,null,"Sandy loam",null,null,null,"Kirpich Equation"]
["d (mm)","PSD: d_","Median Size (m)","Vs (m/s)","Nf","Trs","Trs*Mass","d (mm)","PSD: d_","Median Size (m)","Vs (m/s)","Nf","Trs","Trs*Mass",null,null,null,null,"Silt loam",null,null,null,"Kerby-Hatheway Equation"]
[{"$f":"C5*1000","v":2},100,2E-3,{"$f":"$C$34/(18*$C$33)*($C$35-$C$36)*C5^2","v":3.5861610113107121},{"$f":"$E$22*D5/($E$31*$E$32)","v":{"$error":"#DIV/0!"}},{"$f":"E5^0.69/(E5^0.69+4.95)","v":{"$error":"#DIV/0!"}},"-",{"$f":"J5*1000","v":2},100,2E-3,{"$f":"$C$34/(18*$C$33)*($C$35-$C$36)*J5^2","v":3.5861610113107121},{"$f":"$E$22*K5/($E$31*$E$32)","v":{"$error":"#DIV/0!"}},{"$f":"L5^0.69/(L5^0.69+4.95)","v":{"$error":"#DIV/0!"}},"-",null,null,null,null,null,null,null,null,"TR-55"]
[{"$f":"C6*1000","v":0.35804999999999998},90,3.5805E-4,{"$f":"$C$34/(18*$C$33)*($C$35-$C$36)*C6^2","v":0.1149362833458084},{"$f":"$E$22*D6/($E$31*$E$32)","v":{"$error":"#DIV/0!"}},{"$f":"E6^0.69/(E6^0.69+4.95)","v":{"$error":"#DIV/0!"}},{"$f":"(B5-B6)*AVERAGE(F5:F6)","v":{"$error":"#DIV/0!"}},{"$f":"J6*1000","v":0.25},90,{"$f":"0.25/1000","v":2.5000000000000001E-4},{"$f":"$C$34/(18*$C$33)*($C$35-$C$36)*J6^2","v":5.6033765801729876E-2},{"$error":"#DIV/0!"},{"$f":"L6^0.69/(L6^0.69+4.95)","v":{"$error":"#DIV/0!"}},{"$f":"(I5-I6)*AVERAGE(M5:M6)","v":{"$error":"#DIV/0!"}}]
[0.13164999999999999,75,1.3165E-4,1.553858687208916E-2,{"$f":"$E$22*D7/($E$31*$E$32)","v":{"$error":"#DIV/0!"}},{"$f":"E7^0.69/(E7^0.69+4.95)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},5.5E-2,75,{"$f":"0.055/1000","v":5.5000000000000002E-5},2.7120342648037266E-3,{"$error":"#DIV/0!"},{"$f":"L7^0.69/(L7^0.69+4.95)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LL vmax","tallow"]
[5.0709999999999998E-2,50,5.0710000000000001E-5,2.3054569359614108E-3,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},2.5000000000000001E-2,50,{"$f":"0.025/1000","v":2.5000000000000001E-5},5.603376580172988E-4,{"$f":"$E$22*K8/($E$31*$E$32)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"Kerby Roughness Parameter",null,null,null,"Lining Type",{"$f":"AA9","v":"Vegetation"},{"$f":"AA10","v":"Rolled_Erosion_Control_Products"},{"$f":"AA11","v":"Turf_Reinforcement_Matting"},null,null,"Bermuda grass",6,1]
[2.7490000000000001E-2,25,2.7489999999999999E-5,6.7751555871590162E-4,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1.2999999999999999E-2,25,{"$f":"0.013/1000","v":1.2999999999999999E-5},1.5151530272787758E-4,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"Pavement",0.02,null,null,"Vegetation","Bermuda grass","Straw, no nets","NAG, SC250; bare soil",null,null,"Rye grain",3,0.6]
[1.333E-2,10,1.3329999999999999E-5,1.5930525133067201E-4,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},5.0000000000000001E-3,10,{"$f":"0.005/1000","v":5.0000000000000004E-6},2.2413506320691957E-5,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"Smooth, bare packed soil",0.1,null,null,"Rolled_Erosion_Control_Products","Rye grain","Straw, 1 net","NAG, C350; bare soil",null,null,"Hard fescue",3,1]
[3.9990000000000002E-5,0,3.9990000000000003E-8,1.4337472619760484E-9,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},3.9990000000000002E-5,0,3.9990000000000003E-8,1.4337472619760484E-9,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"Poor grass, cultivated row crops or moderately rough bare surfaces",0.2,null,null,"Turf_Reinforcement_Matting","Hard fescue","Straw, 2 nets","NAG, P550; bare soil",null,null,"Bluegrass",5.5,1]
[null,null,null,null,null,"Cumulative Removal Efficiency = ",{"$f":"SUM(G6:G11)/100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Cumulative Removal Efficiency = ",{"$f":"SUM(N6:N11)/100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Pasture, average grass",0.4,null,null,null,"Bluegrass","Straw (70) and Coir (30)","Pro/Enka II; bare soil",null,null,"Tall fescue",5.5,1]
[null,"Data source: Winston and Hunt DOT data",null,null,null,null,null,null,"Data from Rahn, 1996 (Engineering Geology: An Environmental Approach); soil type = Mikovna loess (image here:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Deciduous forest",0.6,null,null,null,"Tall fescue","Excelsio, 2 nets","Pro/Enka, 7220, BFM, vegetated",null,null,"Straw, no nets",3,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"http://myweb.cwpost.liu.edu/vdivener/notes/soil_props.htm",null,null,null,null,null,null,null,null,"Dense grass, coniferous forest, or dec. forest with deep litter",0.8,null,null,null,null,"Polypropylene, 2 nets","NAG, C350vegetated",null,null,"Straw, 1 net",3.5,1.25]
[null,"d50",{"$f":"C8","v":5.0710000000000001E-5},null,null,null,null,null,"d50",{"$f":"J8","v":2.5000000000000001E-5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coir netting, 900 g","NAG, P550; vegetated",null,null,"Straw, 2 nets",4.5,1.5]
[null,"Interp. D60",{"$f":"(((C7-C8)/(B7/B8))*(60-B8))+C8","v":5.9031000000000003E-4},null,null,null,null,null,"Interp. D60",{"$f":"(((J7-J8)/(I7/I8))*(60-I8))+J8","v":2.2500000000000002E-4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Straw (70) and Coir (30)",8,2]
[null,"UC",{"$f":"C16/C10","v":44.284321080270075},null,null,null,null,null,"UC",{"$f":"J16/J10","v":45},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Excelsio, 2 nets",8.5,2.2999999999999998]
[null,"C,c (d25 for d30)",{"$f":"(C9^2)/(C10*C16)","v":9.6037133743465342E-2},null,null,null,null,null,"C,c (d25 for d30)",{"$f":"(J9^2)/(J10*J16)","v":0.1502222222222222},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polypropylene, 2 nets",9,3.2]
[null,"Variable","English Units",null,"Metric Units",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,"Coir netting, 900 g",15,4.5999999999999996]
[null,"z",{"$f":"'Swale Design'!D9","v":0},"ft/ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Side slope values","Grass height",null,null,null,null,null,null,null,null,"NAG, SC250; bare soil",9.5,2.5]
[null,"wb",{"$f":"'Swale Design'!D8","v":0},"ft",{"$f":"C21*0.3048","v":0},"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3,null,null,null,null,null,null,null,null,"NAG, C350; bare soil",10.5,3]
[null,"L",{"$f":"'Swale Design'!D10","v":0},"ft",{"$f":"C22*0.3048","v":0},"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,4,null,null,null,null,null,null,null,null,"NAG, P550; bare soil",12.5,3.25]
[null,"S",{"$f":"'[1]DESIGN INPUTS'!D10","v":7.4999999999999997E-2},"ft/ft",null,null,"LEFT SIDE",{"$f":"C30*C26*(1/(1.486*SQRT(C23)))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5,null,null,null,null,null,null,null,null,"Pro/Enka II; bare soil",13,10]
[null,"G",{"$f":"'Swale Design'!D12","v":0},"in",{"$f":"(C24/12)*0.3048","v":0},"m","RIGHT SIDE",{"$f":"((($C$21*$C$31)+($C$20*($C$31^2)))^(5/3))*((($C$21*$C$31)+(2*$C$31*SQRT(($C$20^2)+1)))^(-2/3))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,6,null,null,null,null,null,null,null,null,"Pro/Enka, 7220, BFM, vegetated",14,8]
[null,"XSec Area",{"$f":"(((2*C20*C31)+C21)/2)*C31","v":0},"ft^2",{"$f":"C25*0.09290304","v":0},"m^2","Squared Error",{"$f":"(H23-H24)^2","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,"NAG, C350vegetated",20,10]
[null,"n",0.35,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,"NAG, P550; vegetated",25,12.5]
[null,"A",{"$f":"Hydrology!H7","v":0},"acres"]
[null,"C",{"$f":"Hydrology!H8","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",1]
[null,"i",{"$f":"Hydrology!H9","v":0},"in/hr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",2]
[null,"Q",{"$f":"Hydrology!H7*Hydrology!H8*1","v":{"$error":"#DIV/0!"}},"cfs",{"$f":"C30*28.32","v":{"$error":"#DIV/0!"}},"L/s","<- Based on 1 in/h only",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",3]
[null,"y",{"$f":"'Swale Design'!D18","v":0.28778504715766062},"ft",{"$f":"C31*0.3048","v":8.7716882373654964E-2},"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D",4]
[null,"V",null,null,{"$f":"E30/1000/E25","v":{"$error":"#DIV/0!"}},"m/s"]
[null,"μ ",1.0020000000000001E-3]
[null,"g ",9.8000000000000007]
[null,"ρs",2650]
[null,"ρ ",1000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TESTING CONTINUITY ITERATION VS MANNING'S CALCULATION FOR DESIGN"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"wb",2]
[null,"USDA Classification","Clay/silt line","Silt/VFS line","VFS/FS line","FS/MS line","MS/CS line","CS/VCS line",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"z",4]
[null,null,2E-3,0.05,0.1,0.25,0.5,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"S",2.5000000000000001E-2]
[null,null,2E-3,0.05,0.1,0.25,0.5,1,100,null,null,null,null,null,null,null,null,null,null,null,null,null,"n",2.1999999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q",5.8]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"flowd","A"," v","WP","Rh","v","Q (manning)","Q (continuity only)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,{"$f":"V46*0.5*(2*$X$39+2*$X$40*V46)","v":2},{"$f":"$X$43/W46","v":2.9},{"$f":"$X$39+(2*SQRT((V46^2)+($X$40*V46)^2))","v":6.1231056256176606},{"$f":"W46/Y46","v":0.32663163471040929},{"$f":"(1.4859/$X$42)*(Z46^(2/3))*SQRT($X$41)","v":5.0649566870092766},{"$f":"AA46*W46","v":10.129913374018553},{"$f":"$X$43/W46","v":2.9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,{"$f":"V47*0.5*(2*$X$39+2*$X$40*V47)","v":2.64},{"$f":"$X$43/W47","v":2.1969696969696968},{"$f":"$X$39+(2*SQRT((V47^2)+($X$40*V47)^2))","v":6.9477267507411931},{"$f":"W47/Y47","v":0.37998040146273188},{"$f":"(1.4859/$X$42)*(Z47^(2/3))*SQRT($X$41)","v":5.6024463247263352},{"$f":"AA47*W47","v":14.790458297277526},{"$f":"$X$43/W47","v":2.1969696969696968}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.7,3.36,1.7261904761904763,7.7723478758647238,0.43230180296403398,6.1055989043998373,20.514812318783452,1.7261904761904763]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,4.16,1.3942307692307692,8.596969000988258,0.48389147378823755,{"$f":"(1.4859/$X$42)*(Z49^(2/3))*SQRT($X$41)","v":6.582166837693106},27.38181404480332,1.3942307692307692]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.9,5.04,1.1507936507936507,9.4215901261117896,0.53494154729059151,7.0373279873792987,35.468133056391665,1.1507936507936507]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,6,0.96666666666666667,10.246211251235321,0.5855823048033113,7.4747304506609522,{"$f":"AA51*W51","v":44.848382703965711},0.96666666666666667]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1000000000000001,7.0400000000000009,0.82386363636363624,11.070832376358855,0.63590521115950849,7.8970549906379537,55.595267134091202,0.82386363636363624]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2,8.16,0.71078431372549011,11.895453501482386,0.6859763689533247,8.3063394704890623,67.779730079190756,0.71078431372549011]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3,9.3600000000000012,0.61965811965811957,12.720074626605918,0.73584473949721774,8.7041767064753088,81.471093972608898,0.61965811965811957]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4,10.639999999999999,0.54511278195488722,13.544695751729448,0.7855473607549609,9.0918407910744996,96.73718601703267,0.54511278195488722]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,12,0.48333333333333334,14.369316876852981,0.83511276860560935,9.4703709152549873,113.64445098305984,0.48333333333333334]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.6,13.440000000000001,0.43154761904761901,15.193938001976516,0.88456330401319583,9.8406288461104729,132.25805169172477,0.43154761904761901]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.7,14.96,0.38770053475935823,16.018559127100048,0.93391670757020917,10.203339471772408,152.64195849771522,0.38770053475935823]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.8,16.559999999999999,0.35024154589371981,16.843180252223579,0.98318724563989657,10.559120115818551,174.8590291179552,0.35024154589371981]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.9,18.239999999999998,0.31798245614035092,17.667801377347111,1.0323865211314032,10.908502195618992,198.97108004809039,0.31798245614035092]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,20,0.28999999999999998,18.492422502470642,1.0815240673485553,11.251947533295994,225.03895066591986,0.28999999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.1,21.840000000000003,0.26556776556776551,19.317043627594174,1.1306077897345439,11.589860850448375,253.12256097379253,0.26556776556776551]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2000000000000002,23.760000000000005,0.24410774410774405,20.141664752717709,1.1796442991036318,11.92259948638525,283.28096379651362,0.24410774410774405]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2999999999999998,{"$f":"V64*0.5*(2*$X$39+2*$X$40*V64)","v":25.759999999999998},0.2251552795031056,20.966285877841237,1.2286391662352139,12.250481061036124,315.57239213229053,0.2251552795031056]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4,27.84,0.20833333333333331,21.790907002964772,1.2775971186611101,12.573789592390153,350.05430225214184,0.20833333333333331]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5,30,0.19333333333333333,22.615528128088304,1.3265221944005916,12.892780435221033,386.78341305663099,0.19333333333333333]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.6,32.24,0.17990074441687343,23.440149253211835,{"$f":"W67/Y67","v":1.3754178632451493},13.207684309113912,425.81574212583251,0.17990074441687343]