{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["TRAPAZOIDAL"],"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":"TRAPAZOIDAL","index":0,"n_rows":62,"n_cols":14,"rows_kept":62,"cut":false,"hidden":false,"merged":[[61,7,61,8],[28,0,28,5],[52,7,52,8],[57,7,57,8],[47,3,47,4],[3,10,3,13],[24,0,24,4],[9,0,9,2],[22,3,22,4],[58,1,60,4],[11,0,11,2],[7,0,7,8],[10,5,10,6],[10,7,10,8]]}
["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,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"]
["TRAPAZOIDAL 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-28","CHECK BY:",null,null,"DATE:"]
["SUBJECT - Trapazoid Waterway No.",null,null,1,"Reach:","0+00 - 1+00",null,"SHEET        of "]
[null,null," "," "," "," "," "," ",null,null,null," "]
["   GIVEN:","  Qr =",50,"CFS "," "," "," "," ",null,null,"Qr = Required Flow"]
[" "," S =",10,"%"," "," "," "," ",null,null,"S = Waterway Slope"]
[" "," L =",100,"FT"," "," "," "," ",null,null,"L = Waterway Length"]
[" "," "," "," "," "," ",null," ",null,null,"D = Waterway Depth"]
["  DESIGN:"," D =",0.7,"FT"," "," "," "," ",null,null,"BW = Waterway Bottom Width"]
[" ","    BW =",8,"FT"," "," "," "," ",null,null,"TW = Waterway Top Width"]
[null,"TW  =",{"$f":"C19+2*C18*C23","v":10.8},"FT",null,null,null,null,null,null,"D50 = Average NCSA Rock Size"]
[" ","   D50 =",6,"IN       NCSA","R-4"," "," "," "," ",null,"D100 = Maximum NCSA Rock Size"]
[null,"T =",0.75,"FT",null,null,null,null,null,null,"T = Rock Thickness (Minimum T = D100)"]
[" ","Z =",2,"RATIO",null," "," "," "," ",null,"Z = Side Slope Ratio"]
[null,null," "]
["    n = 0.047 x (D50 x (S/100))0.147 =",null,null,null,null,null,{"$f":" 0.047*(C21*(C15/100))^0.147","v":4.3599960091258327E-2}]
[" "," "," "," "," "," "," "," "," "]
["    CROSS SECTIONAL AREA (A) = (BW x D) + (Z x D2) =",null,null,null,null,null,{"$f":"(C19*C18)+(C23*C18^2)","v":6.5799999999999992}," FT2"]
[" "," "," "," "," "," "," "," "," "]
["    WETTED PERIMETER (WP) = BW + (2 x D x (Z2+1)0.5) = ",null,null,null,null,null,{"$f":"C19+(2*C18*(C23^2+1)^0.5)","v":11.130495168499706}," FT"]
[" "]
["    HYDRAULIC RADIUS (R) = A / WP =",null,null,null,null,null,{"$f":"G27/G29","v":0.59116866773564447}]
[" "]
["    VELOCITY (V) = (1.486 x R2/3 x S1/2)/n =",null,null,null,null,null,{"$f":"(1.486/G25)*(G31)^(2/3)*(C15/100)^0.5","v":7.5917224678289017},"FT/S"]
[]
["    DESIGN FLOW (Q) = A x V =",null,null,null,null,{"$f":"G27*G33","v":49.953533838314165},"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*G33)","v":8.487053376434007},"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*G40/24)^3","v":41.925872287878526},"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*G42*3/(3.1415927*4*165))^(1/3)*24","v":10.693017200550562},"IN"]
[]
[]
[]
["    COMPUTE ROCK QUANTITY",null,null,"T =",null,{"$f":" C22","v":0.75},"FT"]
[]
["    ROCK VOLUME (Vr) = T x WP x L =",null,null,null,null,null,{"$f":"C22*G29*C16","v":834.78713763747794},"CU FT"]
[]
["    TONS = Vr x (1.6 TON/CU.YD.) / (27 CU.FT./CU.YD.) =",null,null,null,null,null,null,{"$f":"G50*1.6/27","v":49.468867415554257},"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*G29*C16","v":556.52475842498529},"CU FT"]
[]
["    TONS = (Vb x 1.7 TON/CU.YD.)/(27 CU.FT./CU.YD.) = ",null,null,null,null,null,null,{"$f":"G55*1.7/27","v":35.040447752684258},"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":"H57+H52","v":84.509315168238516},"TONS"]
[null,null,null,null,null,null,null,"*************************"]