{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["V-SHAPED"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"V-SHAPED","index":0,"n_rows":56,"n_cols":14,"rows_kept":56,"cut":false,"hidden":false,"merged":[[55,7,55,8],[29,0,29,5],[46,7,46,8],[48,0,48,5],[50,0,50,6],[33,0,33,4],[51,7,51,8],[52,1,54,4],[43,0,43,5],[45,0,45,5],[7,0,7,8],[23,0,23,4],[3,10,3,13],[9,0,9,2],[11,7,11,8],[21,3,21,4]]}
["Click the START button or enter values in the blue highlighted cells."]
["Verify computed values highlighted in gold meet design values."]
[]
[null,null,null,null,null,null,null,null,null,null,"Support Data"]
[null,null,null,null,null,null,null,null,null,null,"NCSA No.","D50","D100","Max. Vel."]
[null,null,null," ",null,null,null,null,null,null,"R-3","3\"","6\"","6.5 ft/s"]
[null,null,null,null,null,null,null,null,null,null,"R-4","6\"","12\"","9.0 ft/s"]
["V-SHAPED ROCK LINED WATERWAY DESIGN",null,null,null,null,null,null,null,null,null,"R-5","9\"","18\"","11.5 ft/s"]
[null,null,null,null,null,null,null,null,null,null,"R-6","12\"","24\"","13.0 ft/s"]
["STATE - Pennsylvania",null,null,"PROJECT:","TRIAL",null,null,null,null,null,"R-7","15\"","30\"","14.5 ft/s"]
["DESIGN BY:","GLM","   DATE:","2008-02-06","CHECK BY:",null,null,"DATE:"]
["SUBJECT - V-Shaped Waterway No.",null,null,1,"REACH:","0+00 - 1+00",null,"SHEET ____ of ____"]
[]
["GIVEN:","Qr =",50,"CFS",null,null,null,null,null,null,"Qr = Required Flow"]
[null," S =",8,"%",null,null,null,null,null,null,"S = Waterway Slope"]
[null," L =",100,"FT",null,null,null,null,null,null,"L = Waterway Length"]
[null,null,null,null,null,null,null,null,null,null,"D = Waterway Depth"]
["DESIGN:"," D =",1.8,"FT",null,null,null,null,null,null,"TW = Waterway Top Width"]
[null,"TW =",{"$f":"2*C18*C22","v":5.4},"FT",null,null,null,null,null,null,"D50 = Average NCSA Rock Size"]
[null,"   D50 =",9,"IN    NCSA","R-5",null," ",null,null,null,"D100 = Maximum NCSA Rock Size"]
[null,"T =",1.5,null," ",null,null,null,null,null,"T = Rock Thickness (Minimum T = D100)"]
[null,"     Z =",1.5,"RATIO",null,null,null,null,null,null,"Z = Side Slope Ratio"]
[]
["    n = 0.047 x (D50 x (S/100))0.147 =",null,null,null,null,null,{"$f":" 0.047*(C20*(C15/100))^0.147","v":4.4784294280754207E-2}]
[" "]
["    CROSS SECTIONAL AREA (A) = Z x D2 =",null,null,null,null,null,{"$f":"C22*C18^2","v":4.8600000000000003},"FT2"]
[" "]
["    WETTED PERIMETER (WP) = 2 x D x (Z2 + 1)0.5 =",null,null,null,null,null,{"$f":"2*C18*((C22^2+1)^0.5)","v":6.4899922958351803},"FT"]
[null,null," ",null," "]
["    HYDRAULIC RADIUS (R) = A / WP =",null,null,null,null,null,{"$f":"G26/G28","v":0.74884526490405945}]
[null,null," "]
["    VELOCITY (V) = (1.486 x R2/3 x S1/2)/n =",null,null,null,null,null,{"$f":"(1.486/G24)*G30^(2/3)*(C15/100)^0.5","v":7.7392604100434479},"FT/S"]
[]
["    DESIGN FLOW (Q) = A x V =",null,null,null,null,{"$f":"G26*G32","v":37.612805592811156},"CFS        >",{"$f":"C14","v":50},"CFS"]
[null,null,null,null,null," "]
["    CHECK ROCK SIZE - (USING ISBASH CURVE - EXHIBIT 16-1, EFM)"]
[]
["    DESIGN D50 = 2.032 x e(0.1883 x V) =",null,null,null,null,null,{"$f":"2.032*2.718281828^(0.1883*G32)","v":8.7261412749082155},"IN "]
[]
["    LB D50 = (165 LBS/CU.FT) x 4/3 x 3.14 x (10/9 x D50)3 =",null,null,null,null,null,{"$f":"165*4/3*3.1415927*(10/9*G38/24)^3","v":45.569894809632274},"LBS"]
[]
["    D100 =  9/10 x (2 x (LB D50) x 3/(3.14 x 4 x 165))1/3  =",null,null,null,null,null,{"$f":"9/10*(2*G40*3/(3.1415927*4*165))^(1/3)*24","v":10.994249076613348},"IN"]
[null,null," "]
["    VOLUME ROCK (Vr) = T x WP x L = ",null,null,null,null,null,{"$f":"C21*G28*C16","v":973.49884437527714},"CU FT"]
[]
["    TONS = Vr x (1.6 TON/CU.YD.) / (27 CU.FT./CU.YD.) =",null,null,null,null,null,null,{"$f":"G44*1.6/27","v":57.688820407423833},"TONS"]
[null,null,null,null,null,null,null,"*************************"]
[]
["     BEDDING VOLUME (Vb) = 6\" THICK  x WP x L =",null,null,null,null,null,{"$f":"0.5*G28*C16","v":324.49961479175903},"CU FT"]
[]
["     TONS = ( Vb x (1.7 TON/CU.YD.)/(27 CU.FT./CU.YD.) = ",null,null,null,null,null,null,{"$f":"G49*1.7/27","v":20.43145722762927},"TONS"]
[null,null,null,null,null,null,null,"*************************"]
[null,"Note: Geotextile may be used in place of stone bedding if the design velocity is less than the erodible velocity of the soil."]
[]
[null,null,null,null,null,null,"TOTAL =",{"$f":"H51+H46","v":78.1202776350531},"TONS"]
[null,null,null,null,null,null,null,"*************************"]