{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["PARABOLI"],"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":"PARABOLI","index":0,"n_rows":58,"n_cols":14,"rows_kept":58,"cut":false,"hidden":false,"merged":[[57,7,57,8],[26,0,26,5],[49,7,49,8],[54,7,54,8],[44,3,44,4],[55,1,57,4],[22,0,22,4],[3,10,3,13],[7,0,7,8],[9,0,9,2],[10,5,10,6]]}
["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"]
["PARABOLIC 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,"R-7","15\"","30\"","14.5 ft/s"]
["DESIGN BY:","GLM","   DATE:","2008-02-06","CHECK BY:",null,null,"DATE:"]
["SUBJECT- Parabolic Waterway No.",null,null,1,"REACH NO.","0+00 - 1+00",null,"SHEET        of "]
[null,null," "," "," "," "," "," "]
["   GIVEN:"," Qr =",50,"CFS"," "," "," "," ",null,null,"Qr = Required Flow"]
[" "," S =",10,"%"," ",null," "," ",null,null,"S = Waterway Slope"]
[" "," L =",100,"FT"," "," "," "," ",null,null,"L = Waterway Length"]
[" "," "," "," "," "," ",null," ",null,null,"D = Waterway Depth"]
["  DESIGN:"," D =",1,"FT"," "," "," "," ",null,null,"TW = Waterway Top Width"]
[" ","    TW =",10,"FT"," "," "," "," ",null,null,"D50 = Average NCSA Rock Size"]
[" ","       D50 =",6,"IN     NCSA","R-4"," "," "," "," ",null,"D100 = Maximum NCSA Rock Size"]
[null,"T =",1,"FT",null,null,null,null,null,null,"T = Rock Thickness (Minimum T = D100)"]
[" ",null,null,null,null," "," "," "," "]
["    n = 0.047 x (D50 x (S/100))0.147 =",null,null,null,null," ",{"$f":"0.047*(C20*(C15/100))^0.14715","v":4.3596619422725927E-2}," "]
[" "," ",null," "," "," "," "," "]
["    CROSS SECTIONAL AREA (A) = 2/3 x D x TW =",null,null,null,null,null,{"$f":"2/3*$C$18*$C$19","v":6.6666666666666661},"FT2"]
[" "," "," "," "," "," "," "," "]
["    WETTED PERIMETER (WP) = TW + (8 x D2)/(3 x TW) =",null,null,null,null,null,{"$f":"$C$19+8*$C$18^2/(3*$C$19)","v":10.266666666666667},"FT"]
[" "]
["    HYDRAULIC RADIUS (R) = A / WP =",null,null,null,null,null,{"$f":"G25/G27","v":0.64935064935064923}]
[" "]
["    VELOCITY (V) = (1.486 x R2/3 x S1/2)/n =",null,null,null,null,null,{"$f":"(1.486/G23)*($G$29)^(2/3)*($C$15/100)^0.5","v":8.0826203711977858},"FT/S"]
[]
["    DESIGN FLOW (Q) = A x V =",null,null,null,null,{"$f":"G25*G31","v":53.884135807985231},"CFS      >",{"$f":"C14","v":50},"CFS"]
[null,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*G31)","v":9.3089652888647976},"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":55.324250519204732},"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":11.728561320181468},"IN"]
[]
[]
["    COMPUTE ROCK QUANTITY",null,null,"T =",null,{"$f":" C21","v":1},"FT"]
[]
["    ROCK VOLUME (Vr) = T x WP x (L) =",null,null,null,null,null,{"$f":"C21*G27*C16","v":1026.6666666666667},"CU FT"]
[]
["    TONS = (Vr x 1.6 TON/CU.YD.) / (27 CU.FT./CU.YD.) =",null,null,null,null,null,null,{"$f":"G47*1.6/27","v":60.839506172839521},"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*G27*C16","v":513.33333333333337},"CU FT"]
[]
["    TONS = (Vb x 1.7 TON/CU.YD.) / (27 CU.FT./CU.YD.) = ",null,null,null,null,null,null,{"$f":"G52*1.7/27","v":32.320987654320987},"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":" H54+H49","v":93.160493827160508},"TONS"]
[null,null,null,null,null,null,null,"*************************"]