{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cover Sheet","Design","Instructions","Info"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"Cover Sheet","index":0,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
[{"$f":"Info!A1","v":"Trapezoidal Riprap-Lined Waterway Design.xlsm"}]
[]
[null,null,null,null,{"$f":"Info!H1","v":"V1.02"}]
[null,null,null,null,{"$f":"Info!I1","v":"2013-02-11"}]

{"sheet":"Design","index":1,"n_rows":45,"n_cols":25,"rows_kept":45,"cut":false,"hidden":false,"merged":[[41,0,44,0],[33,1,34,1],[34,7,36,8],[2,4,2,5],[1,4,1,5],[23,3,23,7],[24,6,24,7],[24,4,24,5],[2,7,2,8],[0,0,0,8],[1,1,1,2],[2,1,2,2],[3,1,3,2],[3,4,3,5]]}
[{"$f":"Info!A1","v":"Trapezoidal Riprap-Lined Waterway Design.xlsm"}]
["Landowner","Sample Landowner",null,"County","Washington",null,null,{"$f":"Info!H1","v":"V1.02"}]
["Computed By","JLS",null,"Date","2012-10-02",null,null,{"$f":"Info!I1","v":"2013-02-11"},null,null,null,null,null,null,null,null,null,null,"Formulas and data used in computations:"]
["Checked by",null,null,"Date"]
["Note:  Macros must be enabled in this spreadsheet in order for the \"Solve\" button to work."]
["Design flow, Q=",160," cfs",{"$f":"IF(B6>200,\"Q>200 cfs!\",\"\")","v":""},null,null,"WW horiz. Length=",100,"ft",null,null,null,null,null,null,null,null,null,null,"Angular"]
["Slope, S=",0.1," ft/ft     =",{"$f":"1/B7","v":10},":1",null,"U/S WW F.L. elev=",997,"ft",null,null,null,null,null,null,null,null,null,null,"Rounded"]
["Bottom Width, W=",28,"ft",null,null,null,"D/S WW F.L. elev=",{"$f":"H7-H9","v":987},"ft"]
["Side slope, Z=",2,":1",null,null,null,"Waterway drop=",{"$f":"H6*B7","v":10},"ft"]
["Safety factor=",1.2,null,null,null,null,"WW length along slope=",{"$f":"(H9^2+H6^2)^0.5","v":100.4987562112089},"ft"]
["Rock shape =","Angular",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Basic D50=",{"$f":"IF(B7<0.1,(B6*B7^1.5/(0.00475*B8))^0.53,(B6*B7^0.58/(0.0393*B8))^0.53)","v":6.8986130003244428},"in"]
["Min. req'd D50=",{"$f":"ROUND(IF(B11=\"Angular\",U11*B10,U11*B10*1.4),2)","v":8.2799999999999994},"in",null,null,"Spreadsheet formatting key:"]
["D50 used=",8.3000000000000007,"in",{"$f":"IF(B13<B12,\"Select larger D50!\",\"\")","v":""},null,"XXX","=Input cells",null,null,null,null,null,null,null,null,null,null,null,"For normal flow:",null,{"$f":"B8*B17+B9*B17^2","v":20.509094080346618}," A=Flow Area for normal flow"]
["n=",{"$f":"IF(B11=\"Angular\",0.047*(B13*B7)^0.147,0.047*(B13/1.4*B7)^0.147)","v":4.5730119631937557E-2},null,null,null,"X.XX","=Output from \"Solve\" button",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B8+2*B17*(B9^2+1)^0.5","v":31.120198144792592},"WP=Wetted Perimeter"]
["Freeboard=",0.25,"ft",null,null,"X.XX","=Other computed output",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U13/U14","v":0.65902839001616209},"R= Hydraulic Radius"]
[null,null,null,null,null,"Red text","=Instructions, warnings, info",null,null,null,null,null,null,null,null,null,null,null,null,"Velocity, V =",{"$f":"1.49/B14*U15^0.667*B7^0.5","v":7.8017670990696635},"Manning's eqn",null,{"$f":"U16/U17","v":1.0000448464235789},"(Goal Seek P16=1"]
["Flow depth, d=",0.69769751550249659,"ft",{"$f":"IF($S$28=1,\"Calculated\",\"Please click Solve.\")","v":"Calculated"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Velocity, V =",{"$f":"B6/U13","v":7.8014172334078973},"Q/A",null,null,"by varying B17)"]
["Critical depth, dc=",0.9808467177199286,"ft"]
["Critical slope, Sc=",{"$f":"(B6*B14/(1.49*U19*U22^0.667))^2","v":3.1785342773098184E-2},"ft/ft","0.7Sc =",{"$f":"B19*0.7","v":2.2249739941168727E-2}," ft/ft",null,null,null,null,null,null,null,null,null,null,null,null,"For critical flow:",null,{"$f":"B8*B18+B9*B18^2","v":29.387828663481915},"A=Flow Area for critical flow"]
[null,null,null,"1.3Sc = ",{"$f":"B19*1.3","v":4.1320945605027644E-2}," ft/ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B8+2*B9*B18","v":31.923386870879714},"T=Top width of flow"]
["Design slope, S=",{"$f":"B7","v":0.1},"ft/ft",{"$f":"IF(B7<=E19,\"Design slope OK. Flow is Subcritical.\",IF(B7>=E20,\"Design slope OK. Flow is Supercritical.\",\"0.7Sc<S<1.3Sc. Select a different slope or bottom width.\"))","v":"Design slope OK. Flow is Supercritical."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B8+2*B18*(1+B9^2)^0.5","v":32.386479872658619},"WP=Wetted Perimeter"]
["Velocity=",{"$f":"U17","v":7.8014172334078973}," fps",null,null,null,"Est. riprap unit wt=",1.4,"Tons/CY",null,null,null,null,null,null,null,null,null,null,null,{"$f":"U19/U21","v":0.9074104002359259},"R=Hydraulic Radius"]
[null,null,null,{"$f":"CONCATENATE(\"Rock shape = \",B11)","v":"Rock shape = Angular"},null,null,"Rock Gs =",2.65,null,null,null,null,null,null,null,null,null,null,null,"Q2/g =",{"$f":"B6^2/32.2","v":795.03105590062103},null,null,{"$f":"U23/U24","v":0.9999782573180015},"(Goal Seek P23=1"]
["Riprap thickness:",null,null,"Required riprap gradation for D50 selected",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A3/T =",{"$f":"U19^3/U20","v":795.04834238390288},null,null,null,"by varying B18)"]
["Minimum=",{"$f":"ROUND(F27/12,2)","v":1.38},"ft","%","Rock dia., inches",null,"Rock weight, lb"]
["Provided=",1.5,"ft","Smaller","min.","max.","min.","max."]
[null,{"$f":"IF(B26<B25,\"Select larger riprap thickness\",\"\")","v":""},null,100,{"$f":"1.5*B13","v":12.450000000000001},{"$f":"2*B13","v":16.600000000000001},{"$f":"IF($B$11=\"Angular\",0.0275*$H$23*E27^3,0.0233*$H$23*E27^3)","v":140.63279948437503},333.35182100000009]
["Sideslope height:",null,null,85,{"$f":"1.3*B13","v":10.790000000000001},{"$f":"1.8*B13","v":14.940000000000001},91.546743842125025,243.01347750900007,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ABS(X16-1)<0.001,ABS(X23-1)<0.001),1,0)","v":1},null,null,null,"Quantity formulas:"]
["Minimum=",{"$f":"ROUND(B17+B15,2)","v":0.95},"ft",50,{"$f":"1*B13","v":8.3000000000000007},{"$f":"1.5*B13","v":12.450000000000001},41.668977625000011,140.63279948437503,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total riprap vertical height=",{"$f":"B26+B30","v":2.5},"ft"]
["Provided=",1,"ft",10,{"$f":"0.8*B13","v":6.6400000000000006},{"$f":"1.3*B13","v":10.790000000000001},21.334516544000003,91.546743842125025,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"riprap sideslope horiz length=",{"$f":"B30*B9","v":2},"ft"]
[null,{"$f":"IF(B30<B29,\"Select taller riprap sideslopes\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"trapezoidal flow area=",{"$f":"B30*(B8+X30)","v":30},"SF"]
[null,null,null,null,{"$f":"X30","v":2},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"excav. channel bottom width bottom=",{"$f":"B8+2*B26*TAN(0.5*ATAN(1/B9))","v":28.708203932499369},"ft"]
[null,null,null,null,null,{"$f":"TEXT(B8,\"0.0\")&\" ft \"","v":"28.0 ft "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"riprap x-sectional area=",{"$f":"X29*(X32+B9*X29)-X31","v":54.270509831248432},"SF"]
[null,{"$f":"TEXT(X29,\"0.0\")&\" ft\"","v":"2.5 ft"},null,null,null,null,{"$f":"TEXT(B30,\"0.0\")&\" ft\"","v":"1.0 ft"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"riprap sideslope length bottom=",{"$f":"((B30+B26)^2+(B9*(B30+B26))^2)^0.5","v":5.5901699437494745},"ft"]
[null,null,null,null,null,"Riprap",null,{"$f":"TEXT(X34,\"0.0\")&\" ft\"","v":"5.6 ft"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WW length=",{"$f":"H10","v":100.4987562112089},"ft"]
["Quantities:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"riprap horiz top end width=",{"$f":"(B26^2+(B9*B26)^2)^0.5","v":3.3541019662496847},"ft"]
["Riprap volume=",{"$f":"X33*X35/27","v":202.00439766624638},"CY",null,null,{"$f":"TEXT(X32,\"0.0\")&\" ft\"","v":"28.7 ft"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"geotextile length=",{"$f":"H10+2*B26","v":103.4987562112089},"ft"]
["Approx. weight=",{"$f":"B37*H22","v":282.80615673274491},"Tons","Geotextile",null,"WW CROSS SECTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"geotextile width=",{"$f":"X32+2*X34+2*X36","v":46.596747752497691},"ft"]
["Geotextile area=",{"$f":"X37*X38/9","v":535.85615954121715},"SY*"]
[]
[null,null,null,null,null,{"$f":"TEXT(H10,\"0.0\")&\" ft\"","v":"100.5 ft"}]
["*Geotextile area includes actual covered surfaces only (no extra for laps or anchorage)"]
[null,null,{"$f":"TEXT(B26,\"0.0\")&\" ft\"","v":"1.5 ft"},1]
[null,null,"Riprap",null,{"$f":"D7","v":10}]
[null,null,"Geotextile",null,null,"WW PROFILE"]

{"sheet":"Instructions","index":2,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,7,0,8]]}
[{"$f":"Info!A1","v":"Trapezoidal Riprap-Lined Waterway Design.xlsm"},null,null,null,null,null,{"$f":"Info!H1","v":"V1.02"},{"$f":"Info!I1","v":"2013-02-11"}]

{"sheet":"Info","index":3,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,8,0,9]]}
["Trapezoidal Riprap-Lined Waterway Design.xlsm",null,null,null,null,null,null,"V1.02","2013-02-11"]
[]
["Trapezoidal riprap-lined waterway hydraulic design spreadsheet"]
[]
["Developed by:",null,null,"Jean Sandstrom, PE"]
[null,null,null,null,"Civil Engineer, NRCS, Des Moines, IA"]
[null,null,null,"Neal Struthers"]
[null,null,null,null,"Civil Engineer, NRCS, West Union, IA"]
["Reviewed by:",null,null,"Jon Fripp, PE"]
[null,null,null,null,"Civil Engineer, Stream Mechanics, NRCS, NDCSMC, Ft. Worth, TX"]
[]
["Program support:",null,null,"State Conservation Engineer"]
[null,null,null,"USDA Natural Resources Conservation Service"]
[null,null,null,"210 Walnut St, Room 693"]
[null,null,null,"Des Moines, Iowa 50309-2180"]
[null,null,null,"(515) 284-4357"]
[]
["References:",null,1,"NRCS Conservation Practice Standard 468, Lined Waterway or Outlet"]
[null,null,null,null,"September 2010"]
[null,null,2,"NRCS National Engineering Handbook Part 654, Technical Supplement"]
[null,null,null,null,"14C, Stone Sizing Critera, August 2007"]
[null,null,3,"Soil Conservation Service, Minnesota Technical Release 3,"]
[null,null,null,null,"Loose Riprap Protection, July 1989"]
[null,null,4,"Abt, S.R. and T.L. Johnson (1991), Riprap Design for Overtopping Flow"]
[null,null,null,null,"J. Hydr. Engng., ASCE 117(8):959-972"]
[null,null,5,"Lorenz, E.A. and M.N. Lobrecht (2000), An Excel Program to Design Rock"]
[null,null,null,null,"Chutes for Grade Stabilization, ASAE Paper No. 002008"]
[null,null,6,"Robinson, K.M.,  C.E. Rice, and K.C. Kadavy (1998), Design of Rock Chutes"]
[null,null,null,null,"Transactions of the ASAE, Vol. 41(3):621-626"]
[]
["Updates:",null,"V1.02",null,"Corrected error in equation for critical slope."]