{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Riffle Sizing","Cascade Sizing"],"not_rendered":{"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Riffle Sizing","index":0,"n_rows":49,"n_cols":5,"rows_kept":49,"merged":[[3,1,3,4],[4,1,4,4],[5,1,5,4],[7,1,7,4],[32,2,32,4],[33,2,33,4],[42,1,42,2]]}
[null,"SPSC Sizing Spreadsheet"]
[null,"(Based on Anne Arundel County SPSC Guidelines, Revised 07/2022)"]
[]
[null,"Designer must select/input "]
[null,"Calculated value/Designer shall not change"]
[null,"Default values provided. Advanced designer may change to customize to site specific design"]
[]
[null,"Riffle Weir Sizing"]
[null,null,"Q100","Q10","Q2"]
[null,"Design Flow (cfs)",{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[null,"Width (ft)",{"v":10,"d":"10.0"},{"$f":"C11","v":{"v":10,"d":"10.0"}},{"$f":"C11","v":{"v":10,"d":"10.0"}}]
[null,"L, Length (ft)",{"v":10,"d":"10.0"},{"v":10,"d":"10.0"},{"v":10,"d":"10.0"}]
[null,"H, Height (ft)",{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"}]
[null,"Design Depth of flow (ft)",{"$f":"C16","v":{"v":0.6666666666666666,"d":"0.67"}},{"v":0.6666666666666666,"d":"0.67"},{"v":0.6666666666666666,"d":"0.67"}]
[null,"D50 (in)",{"$f":"IF(C10<=B45,C45,IF(C10<=B46,C46,IF(C10<=B47,C47,IF(C10<=B48,C48,IF(C10<=B49,C49,IF(C10>B49,C49))))))","v":6},6,6]
[null,"PD, Parabolic Depth (ft)",{"$f":"C11/C17","v":{"v":0.6666666666666666,"d":"0.67"}},{"v":0.6666666666666666,"d":"0.67"},{"v":0.6666666666666666,"d":"0.67"}]
[null,"Width Depth Ratio (W/PD)",{"v":15,"d":"15.0"},{"$f":"D11/D16","v":{"v":15,"d":"15.0"}},{"$f":"E11/E16","v":{"v":15,"d":"15.0"}}]
[null,"Manning's n Value",{"$f":"C14^(1/6)/(21.6*LOG(C14/(C15/12))+14)","v":{"v":0.055971816292662895,"d":"0.056"}},{"$f":"D14^(1/6)/(21.6*LOG(D14/(D15/12))+14)","v":{"v":0.055971816292662895,"d":"0.056"}},{"$f":"E14^(1/6)/(21.6*LOG(E14/(E15/12))+14)","v":{"v":0.055971816292662895,"d":"0.056"}}]
[null,"Slope (ft/ft)",{"$f":"C13/C12","v":{"v":0.1,"d":"10.00%"}},{"$f":"D13/D12","v":{"v":0.1,"d":"10.00%"}},{"$f":"E13/E12","v":{"v":0.1,"d":"10.00%"}}]
[null,"Rock Unit Weight (lbs/cf)",{"v":165,"d":"165.0"},{"v":165,"d":"165.0"},{"v":165,"d":"165.0"}]
[null,"Top Width at Depth",{"$f":"C11/(C16/C14)^0.5","v":{"v":10,"d":"10.0"}},{"$f":"D11/(D16/D14)^0.5","v":{"v":10,"d":"10.0"}},{"$f":"E11/(E16/E14)^0.5","v":{"v":10,"d":"10.0"}}]
[null,"Flow area (sf)",{"$f":"2/3*C14*C21","v":{"v":4.444444444444445,"d":"4.4"}},{"$f":"2/3*D14*D21","v":{"v":4.444444444444445,"d":"4.4"}},{"$f":"2/3*E14*E21","v":{"v":4.444444444444445,"d":"4.4"}}]
[null,"Hydraulic Radius",{"$f":"2*C21^2*C14/(3*C21^2+8*C14^2)","v":{"v":0.4392386530014641,"d":"0.44"}},{"$f":"2*D21^2*D14/(3*D21^2+8*D14^2)","v":{"v":0.4392386530014641,"d":"0.44"}},{"v":0.4392386530014641,"d":"0.44"}]
[null,"Froude",{"$f":"C29/SQRT(32.2*C14)","v":{"v":1.049868557905381,"d":"1.05"}},{"$f":"D29/SQRT(32.2*D14)","v":{"v":1.049868557905381,"d":"1.05"}},{"$f":"E29/SQRT(32.2*E14)","v":{"v":1.049868557905381,"d":"1.05"}}]
[null,"Isbash Maximum Velocity (ft/s)",{"$f":"IF(C24<=1,1.2*(2*32.2*(C20-62.4)/(62.4))^0.5*(C15/12)^0.5,0.86*(2*32.2*(C20-62.4)/(62.4))^0.5*(C15/12)^0.5)","v":{"v":6.257599625808852,"d":"6.26"}},{"$f":"IF(D24<=1,1.2*(2*32.2*(D20-62.4)/(62.4))^0.5*(D15/12)^0.5,0.86*(2*32.2*(D20-62.4)/(62.4))^0.5*(D15/12)^0.5)","v":{"v":6.257599625808852,"d":"6.26"}},{"$f":"IF(E24<=1,1.2*(2*32.2*(E20-62.4)/(62.4))^0.5*(E15/12)^0.5,0.86*(2*32.2*(E20-62.4)/(62.4))^0.5*(E15/12)^0.5)","v":{"v":6.257599625808852,"d":"6.26"}}]
[null,"Depth (\"A\") at TW/4 offset from centerline",{"$f":"3/4*C16","v":{"v":0.5,"d":"0.50"}},{"$f":"3/4*D16","v":{"v":0.5,"d":"0.50"}},{"v":0.5,"d":"0.50"}]
[]
[null,"Calculated Flow at Design Depth (cfs)",{"$f":"1.49/C18*C22*C23^(2/3)*C19^0.5","v":{"v":21.618955999167028,"d":"21.6"}},{"$f":"1.49/D18*D22*D23^(2/3)*D19^0.5","v":{"v":21.618955999167028,"d":"21.6"}},{"v":21.618955999167028,"d":"21.6"}]
[null,"Calculated Velocity (ft/s)",{"$f":"C28/C22","v":{"v":4.864265099812581,"d":"4.86"}},{"$f":"D28/D22","v":{"v":4.864265099812581,"d":"4.86"}},{"v":4.864265099812581,"d":"4.86"}]
[null,"Does the proposed section provide adequate conveyance?",{"$f":"IF(C28>=C10,\"YES\",\"NO\")","v":"YES"},{"$f":"IF(D28>=D10,\"YES\",\"NO\")","v":"YES"},"YES"]
[null,"Is the proposed velocity less than the maximum allowable velocity?",{"$f":"IF(C29<C25,\"YES\",\"NO\")","v":"YES"},{"$f":"IF(D29<D25,\"YES\",\"NO\")","v":"YES"},{"$f":"IF(E29<E25,\"YES\",\"NO\")","v":"YES"}]
[]
[null,"Width Depth Ratio note",{"$f":"IF(C17<=10, \"W/D <= 10, Note: Designers are encouraged to customize results to site specific dimensions. In general, the County prefers a width-depth ratio greater than 10 when site conditions allow.\",\"W/D>10\")","v":"W/D>10"}]
[null,"Parabolic Depth note",{"$f":"IF(C16>2,\"PD>2.0, Note: Designers are strongly encouraged to customize results to site specific dimensions. Parabolic depths exceeding 2.0 feet are discouraged as excessively high berms may be required to tie-in structures. Consider increasing W/D ratio.\",\"PD<=2.0\")","v":"PD<=2.0"}]
{"$rows_empty":8}
[null,"Recommended riffle stone size for a given Q100"]
[null,"Q100, cfs ≤","Max D50, inches"]
[null,15,6]
[null,125,9]
[null,500,12]
[null,1500,18]
[null,2000,24]

{"sheet":"Cascade Sizing","index":1,"n_rows":43,"n_cols":5,"rows_kept":43,"merged":[[3,1,3,4],[4,1,4,4],[5,1,5,4],[7,1,7,4],[32,1,32,2]]}
[null,"SPSC Sizing Spreadsheet"]
[null,"(Based on Anne Arundel County SPSC Guidelines, 2022)"]
[]
[null,"Designer must select/input "]
[null,"Calculated value/Designer shall not change"]
[null,"Default values provided. Advanced designer may change to customize to site specific design"]
[]
[null,"Cascade Weir Sizing"]
[null,null,"Q100","Q10","Q2"]
[null,"Design Flow (cfs)",{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[null,"Width (ft)",{"v":10,"d":"10.0"},{"$f":"C11","v":{"v":10,"d":"10.0"}},{"$f":"C11","v":{"v":10,"d":"10.0"}}]
[null,"L, Length (ft)",{"v":6,"d":"6.0"},{"v":6,"d":"6.0"},{"v":6,"d":"6.0"}]
[null,"H, Height (ft)",{"v":3,"d":"3.0"},{"v":3,"d":"3.0"},{"v":3,"d":"3.0"}]
[null,"Design Depth of flow (ft)",{"v":0.8,"d":"0.80"},{"v":0.8,"d":"0.80"},{"v":0.8,"d":"0.80"}]
[null,"D50 (in)",30,30,30]
[null,"PD, Parabolic Depth (ft)",{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"}]
[null,"Manning's n Value",{"v":0.05,"d":"0.050"},{"v":0.05,"d":"0.050"},{"v":0.05,"d":"0.050"}]
[null,"Slope (ft/ft)",{"$f":"C13/C12","v":{"v":0.5,"d":"50.00%"}},{"$f":"D13/D12","v":{"v":0.5,"d":"50.00%"}},{"$f":"E13/E12","v":{"v":0.5,"d":"50.00%"}}]
[null,"Rock Unit Weight (lbs/cf)",{"v":165,"d":"165.0"},{"v":165,"d":"165.0"},{"v":165,"d":"165.0"}]
[null,"Top Width at Depth",{"$f":"C11/(C16/C14)^0.5","v":{"v":6.324555320336758,"d":"6.3"}},{"$f":"D11/(D16/D14)^0.5","v":{"v":6.324555320336758,"d":"6.3"}},{"$f":"E11/(E16/E14)^0.5","v":{"v":6.324555320336758,"d":"6.3"}}]
[null,"Flow area (sf)",{"$f":"2/3*C14*C20","v":{"v":3.373096170846271,"d":"3.4"}},{"$f":"2/3*D14*D20","v":{"v":3.373096170846271,"d":"3.4"}},{"$f":"2/3*E14*E20","v":{"v":3.373096170846271,"d":"3.4"}}]
[null,"Hydraulic Radius",{"$f":"2*C20^2*C14/(3*C20^2+8*C14^2)","v":{"v":0.5115089514066496,"d":"0.51"}},{"$f":"2*D20^2*D14/(3*D20^2+8*D14^2)","v":{"v":0.5115089514066496,"d":"0.51"}},{"$f":"2*E20^2*E14/(3*E20^2+8*E14^2)","v":{"v":0.5115089514066496,"d":"0.51"}}]
[null,"Froude",{"$f":"C28/SQRT(32.2*C14)","v":{"v":2.6554033312246474,"d":"2.66"}},{"$f":"D28/SQRT(32.2*D14)","v":{"v":2.6554033312246474,"d":"2.66"}},{"$f":"E28/SQRT(32.2*E14)","v":{"v":2.6554033312246474,"d":"2.66"}}]
[null,"Isbash Maximum Velocity (ft/s)",{"$f":"IF(C23<=1,1.2*(2*32.2*(C19-62.4)/(62.4))^0.5*(C15/12)^0.5,0.86*(2*32.2*(C19-62.4)/(62.4))^0.5*(C15/12)^0.5)","v":{"v":13.992418139285839,"d":"13.99"}},{"$f":"IF(D23<=1,1.2*(2*32.2*(D19-62.4)/(62.4))^0.5*(D15/12)^0.5,0.86*(2*32.2*(D19-62.4)/(62.4))^0.5*(D15/12)^0.5)","v":{"v":13.992418139285839,"d":"13.99"}},{"$f":"IF(E23<=1,1.2*(2*32.2*(E19-62.4)/(62.4))^0.5*(E15/12)^0.5,0.86*(2*32.2*(E19-62.4)/(62.4))^0.5*(E15/12)^0.5)","v":{"v":13.992418139285839,"d":"13.99"}}]
[null,"Depth (\"A\") at TW/4 offset from centerline",{"$f":"3/4*C16","v":{"v":1.5,"d":"1.50"}},{"$f":"3/4*D16","v":{"v":1.5,"d":"1.50"}},{"$f":"3/4*E16","v":{"v":1.5,"d":"1.50"}}]
[]
[null,"Calculated Flow at Design Depth (cfs)",{"$f":"1.49/C17*C21*C22^(2/3)*C18^0.5","v":{"v":45.46028443577686,"d":"45.5"}},{"$f":"1.49/D17*D21*D22^(2/3)*D18^0.5","v":{"v":45.46028443577686,"d":"45.5"}},{"v":45.46028443577686,"d":"45.5"}]
[null,"Calculated Velocity (ft/s)",{"$f":"C27/C21","v":{"v":13.477316427764762,"d":"13.5"}},{"$f":"D27/D21","v":{"v":13.477316427764762,"d":"13.5"}},{"v":13.477316427764762,"d":"13.5"}]
[null,"Does the proposed section provide adequate conveyance?",{"$f":"IF(C27>=C10,\"YES\",\"NO\")","v":"YES"},{"$f":"IF(D27>=D10,\"YES\",\"NO\")","v":"YES"},{"$f":"IF(E27>=E10,\"YES\",\"NO\")","v":"YES"}]
[null,"Is the proposed velocity less than the maximum allowable velocity?",{"$f":"IF(C28<C24,\"YES\",\"NO\")","v":"YES"},{"$f":"IF(D28<D24,\"YES\",\"NO\")","v":"YES"},{"$f":"IF(E28<E24,\"YES\",\"NO\")","v":"YES"}]
[null,"Does the proposed cascade have a slope of <= 0.5 ft/ft?",{"$f":"IF(C18<=0.5, \"YES\", \"NO\")","v":"YES"}]
[]
[null,"Scour Depth - pools downstream of cascades"]
[null,"Q100, cfs",{"$f":"C10","v":{"v":0,"d":"0.0"}}]
[null,"Pool Max Depth, ft",1.5]
[null,"H, Height of upstream grade control structure, ft",{"$f":"C13","v":{"v":3,"d":"3.0"}}]
[null,"TW, Top width of the upstream grade control structure, ft",{"$f":"C11","v":{"v":10,"d":"10.0"}}]
[null,"y, depth of Q100 in downstream/receiving structure",0]
[null,"K, coefficient",1.32]
[]
[null,"pd, Calculated scour depth, ft",{"$f":"C39*C36^0.225*(C34/C37)^0.54-C38","v":{"v":0,"d":"0.0"}}]
[null,"Potential depth of scour below design pool bottom, ft",{"$f":"C41-C35","v":-1.5}]
[null,"Minimum footer boulder depth below pool bottom, ft",{"$f":"IF(C42<2,2,C42+1)","v":{"v":2,"d":"2.0"}}]