{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Stilling_Basin_Volume","Methodology","Std_Drawing_1630.04"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":23,"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":"Stilling_Basin_Volume","index":0,"n_rows":31,"n_cols":27,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,"STILLING BASIN DIMENSIONS",null,null,"TIP:",{"$f":"TIP","v":" "},null,null,null,null,"Station:",{"$f":"station","v":" "},null,null,null,null,null,null,"Calculated by:",{"$f":"userName","v":" "}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"STILLING BASIN PLAN VIEW"]
[null,"DIMENSIONS FOR BASIN VOLUME",null,null,null,null,null,null,null,null,null,{"$f":"lengthBasinExterior","v":35},null,null,null,null,null,null,null,null,null,null,null,null,"VariableName","CurrentValue","ResetValue"]
[null,"Culvert Length + Access =",{"$f":"lengthTotal","v":21},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TIP"," ","SPACE"]
[null,"Culvert Width + Access =",{"$f":"widthTotal","v":11},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"station"," ","SPACE"]
[null,"Normal Water Surface Depth =",{"$f":"nws","v":0},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"userName"," ","SPACE"]
[]
[null,"INSIDE BASIN DIMENSIONS",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"lengthWaterBottom","v":12},null,null,null,null,null,null,null,null,null,"lengthInput",null,"NULL"]
[null,"Length =",{"$f":"lengthWaterBottom","v":12},"ft",null,null,null,null,null,null,null,null,null,{"$f":"widthWaterBottom","v":6},null,null,null,null,null,null,null,null,null,null,"lengthBuffer",20,20]
[null,"Width =",{"$f":"widthWaterBottom","v":6},"ft",null,null,null,{"$f":"widthBasinExterior","v":29},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"widthInput",null,"NULL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"widthBuffer",10,10]
[null,"OUTSIDE BASIN DIMENSIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"embToeWidth",11.5,11.5]
[null,"Length =",{"$f":"lengthBasinExterior","v":35},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"embToeWidth","v":11.5},null,null,null,null,"freeboard",0.5,0.5]
[null,"Width =",{"$f":"widthBasinExterior","v":29},"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"embTopWidth",1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"embSideSlope",1.5,1.5]
[null,"STILLING BASIN WATER VOLUME [Vb]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"embToeWidth","v":11.5},null,null,null,null,null,null,"hsb",3.5,3.5]
[null,"Vb =",{"$f":"volumeCuYd","v":18},"cu yd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hwsb",3,3]
[]
[null,"SEDIMENT BASIN VOLUME [Vsb]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lengthTotal",21,21]
[null,"Vst =",{"$f":"volumeSedTrap","v":1.7777777777777777},"cu yd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"widthTotal",11,11]
[null,null,null,null,null,null,null,null,null,{"$f":"embTopWidth","v":1},null,null,null,"STILLING BASIN PROFILE VIEW",null,null,null,{"$f":"embTopWidth","v":1},null,null,null,null,null,null,"nws",null,"NULL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lengthWaterBottom",12,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Freeboard =",{"$f":"freeboard","v":0.5},null,null,null,null,null,null,null,null,null,"widthWaterBottom",6,6]
[null,null,null,null,null,null,"Stilling Basin Height =",{"$f":"hsb","v":3.5},null,null,null,null,null,null,null,null,null,null,null,"Side Slope =",{"$f":"embSideSlope","v":1.5},":1",null,null,"lengthBasinExterior",35,35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Depth above the sediment basin  (h)=",{"$f":"hwsb","v":3},null,null,null,null,null,null,null,null,"widthBasinExterior",29,29]
[null,null,null,null,null,null,null,null,null,"1.0 [fixed depth]",null,null,null,"Sediment Basin*",null,null,null,{"$f":"embToeWidth","v":11.5},null,null,null,null,null,null,"volumeCuYd",18,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"volumeSedTrap",1.7777777777777777,1.78]
[null,null,null,null,null,null,null,null,null,null,null,"All dimensions are in units of feet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Figures Not To Scale"]

{"sheet":"Methodology","index":1,"n_rows":58,"n_cols":3,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Methodology"]
[]
[null,"The volume (Vb) of water in the stilling basin is"]
[]
[]
[]
[null,"where"]
[null,"Vb =","Volume (cu yd)"]
[null,"L =","user entered longitudinal distance + end access distance on both ends (ft)"]
[null,"W =","user entered width + side access distance on both ends (ft)"]
[null,"NWS =","user entered Normal Water Surface depth (ft)"]
[null,"B = ","Base excavation allowance (ft) [set to 1 ft]"]
[]
[null,"Given this volume (Vb) and the user-specified height of water above the sediment trap (shown as 'h' in figure below)"]
[null," the dimensions of a trapezoidal prism are iteratively computed."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Figure source: http://www.had2know.com/academics/rectangular-trapezoid-trough-volume.html"]
[]
[null,"The formula for a trapezoidal prism is"]
[]
[]
[]
[null,"which reduces to"]
[]
[]
[]
[null,"where:"]
[]
[]
[]
[]
[null,null,"              [set ratio]"]
[]
[null,"The value for \"a\" is iteratively adjusted until \"V\" equals the previously calculated value of \"Vb\" from the formula above."]
[]
[null,"Finally, the outer dimensions of the stilling basin are"]
[]
[]
[]
[]
[]
[null,"where"]

{"sheet":"Std_Drawing_1630.04","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Roadway Standard Drawing 1630.04"]