{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Step 1 - Channel Geometry","Step 2 - Flow Geometry","Step 3 - Flow Type","Equations"],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":0,"defined_names":7,"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":"Step 1 - Channel Geometry","index":0,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,13],[19,0,19,2],[21,1,21,8],[30,1,30,8],[31,1,31,8],[20,1,20,8],[22,1,22,8],[23,1,23,8],[24,1,24,8],[28,1,28,8],[29,1,29,8],[27,0,27,3],[33,15,33,19],[34,15,34,19],[36,6,37,7],[34,0,34,13],[32,1,32,8],[28,15,28,19],[29,15,29,19],[30,15,30,19],[31,15,31,19],[32,15,32,19]]}
["Open Channel Flow - Trapezoidal Cross Section - Step 1: Channel Geometry"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Known Values"]
["Ξ","Top width – the top width of the channel (if it was closed).",null,null,null,null,null,null,null,null,null,null,null,"m"]
["Ο","Base width – the bottom width of the channel.",null,null,null,null,null,null,null,null,null,null,null,"m"]
["Ρ","Heigth – the height of the channel (from the bottom till the top surface).",null,null,null,null,null,null,null,null,null,null,null,"m"]
["Π","Bevel side – the bevel side of the channel.",null,null,null,null,null,null,null,null,null,null,null,"m"]
["x","Section slope - the horizontal distance for 1 m vertical distance.",null,null,null,null,null,null,null,null,null,null,null,"-"]
[]
[]
["Unknown Values"]
["Ξ","Top width – the top width of the channel (if it was closed).",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(M22=\"\",\"-\",M22+2*M25*M23),\"-\")","v":"-"},"m",null,"Open Channel Flow - Trapezoidal Cross Section"]
["Ο","Base width – the bottom width of the channel.",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(M21=\"\",\"-\",M21-2*(SQRT((M24^2)-(M23^2)))),\"-\")","v":"-"},"m",null,"© Christos Samaras"]
["Ρ","Height – the height of the channel (from the bottom till the top surface).",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(M21=\"\",\"-\",(M21-M22)/(2*M25)),\"-\")","v":"-"},"m",null,"Mechanical Engineer"]
["Π","Bevel side – the bevel side of the channel.",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(M21=\"\",\"-\",SQRT((((M21-M22)/2)^2)+M23^2)),\"-\")","v":"-"},"m",null,"tel.: +306973513308"]
["x","Section slope - the horizontal distance for 1 m vertical distance.",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(M21=\"\",\"-\",(M21-M22)/(2*M23)),\"-\")","v":"-"},"-",null,"e-mail: xristos.samaras@gmail.com"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"site: http://www.myengineeringworld.net"]
["At least 3 of 5 unknowns must be known in order to calculate the rest unknown values. Sometimes there is more than one way to calculate these values.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thessaloniki, Greece,11/05/2011"]
[]
[null,null,null,null,null,null,"Control Buttons"]

{"sheet":"Step 2 - Flow Geometry","index":1,"n_rows":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,13],[14,1,14,9],[16,1,16,9],[15,1,15,9],[13,0,13,2],[37,6,38,7],[33,15,33,19],[34,15,34,19],[19,0,19,2],[20,1,20,8],[23,1,23,8],[26,1,26,8],[30,1,30,8],[34,1,34,8],[29,15,29,19],[30,15,30,19],[31,15,31,19],[32,15,32,19],[35,15,35,19]]}
["Open Channel Flow - Trapezoidal Cross Section - Step 2: Uniform Flow Geometry"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Input"]
["x","Section slope - the horizontal distance for 1 m vertical distance.",null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Step 1 - Channel Geometry'!M25=\"\",\"-\",'Step 1 - Channel Geometry'!M25)","v":"-"},"-"]
["b","Base width – the bottom width of channel.",null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Step 1 - Channel Geometry'!M22=\"\",\"-\",'Step 1 - Channel Geometry'!M22)","v":"-"},"m"]
["y","Depth – the vertical distance from the lowest point of the channel section to the free surface.",null,null,null,null,null,null,null,null,null,null,null,"m"]
[]
[]
["Output"]
["A","Area – the cross-sectional area of flow, normal to the direction of flow.",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(M17=\"\",\"-\",(M16+M15*M17)*M17),\"-\")","v":"-"},"m2"]
[]
[]
["P","Wetted perimeter – the length of the wetted surface measured normal to the direction of flow.",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(M17=\"\",\"-\",M16+2*M17*SQRT(1+(M15^2))),\"-\")","v":"-"},"m"]
[]
[]
["B","Surface width – width of the channel section at the free surface (in that is not given).",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(M17=\"\",\"-\",M16+2*M15*M17),\"-\")","v":"-"},"m"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Open Channel Flow - Trapezoidal Cross Section"]
["R","Hydraulic radius – the ratio of area to wetted perimeter (A/P).",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(M21=\"-\",\"-\",M21/M24),\"-\")","v":"-"},"m",null,"© Christos Samaras"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mechanical Engineer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tel.: +306973513308"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e-mail: xristos.samaras@gmail.com"]
["Dm","Hydraulic mean depth – the ratio of area to surface width (A/B).",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(M21=\"-\",\"-\",M21/M27),\"-\")","v":"-"},"m",null,"site: http://www.myengineeringworld.net"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Thessaloniki, Greece,11/05/2011"]
[]
[null,null,null,null,null,null,"Control Buttons"]

{"sheet":"Step 3 - Flow Type","index":2,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[[2,15,2,16],[18,15,18,16],[15,1,15,9],[19,1,19,9],[18,1,18,9],[7,11,7,13],[8,11,8,13],[9,11,9,13],[10,11,10,13],[5,7,5,10],[6,7,6,10],[7,7,7,10],[2,11,2,13],[3,11,3,13],[4,11,4,13],[5,11,5,13],[6,11,6,13],[7,5,8,6],[10,5,11,6],[33,8,33,10],[31,3,31,6],[11,1,11,3],[11,7,11,10],[33,3,33,6],[22,1,22,7],[26,1,26,7],[30,1,30,7],[32,3,32,6],[0,0,0,13],[13,0,13,2],[14,1,14,9],[21,0,21,2],[2,7,2,10],[3,7,3,10],[4,7,4,10],[11,11,11,13],[9,5,9,6],[16,1,16,9],[17,1,17,9],[8,7,8,10],[9,7,9,10],[10,7,10,10],[2,5,2,6],[3,5,6,6],[35,6,36,7],[32,15,32,16],[27,15,27,16],[28,15,28,16],[29,15,29,16],[30,15,30,16],[31,15,31,16],[33,15,33,16]]}
["Open Channel Flow - Trapezoidal Cross Section - Step 3: Uniform Flow Type"]
[]
[null,null,null,null,null,"Channel Type",null,"Surface Material And Form",null,null,null,"Manning’s \"n\" Range ",null,null,null,"Water Dynamic Viscosity"]
[null,null,null,null,null,"River",null,"Earth, Straight",null,null,null,"0,02 - 0,025 ",null,null,null,"Temperature (oC)","Dynamic Viscosity (Ns/m2)"]
[null,null,null,null,null,null,null,"Earth, Meandering",null,null,null,"0,03 - 0,05 ",null,null,null,0,1.787E-3]
[null,null,null,null,null,null,null,"Gravel (75-150mm), Straight",null,null,null,"0,03 - 0,04",null,null,null,5,1.519E-3]
[null,null,null,null,null,null,null,"Gravel (75-150mm), Winding",null,null,null,"0,04 - 0,08",null,null,null,10,1.307E-3]
[null,null,null,null,null,"Unlined Canal",null,"Earth, Straight",null,null,null,"0,018 - 0,025",null,null,null,20,1.0020000000000001E-3]
[null,null,null,null,null,null,null,"Rock, Straight",null,null,null,"0,025 - 0,045 ",null,null,null,30,7.980000000000001E-4]
[null,null,null,null,null,"Lined Canal",null,"Concrete",null,null,null,"0,012 - 0,017",null,null,null,40,6.5300000000000004E-4]
[null,null,null,null,null,"Laboratory Models",null,"Mortar",null,null,null,"0,011 - 0,013",null,null,null,50,5.4700000000000007E-4]
[null,"Velocity distribution - trapezoid cross section",null,null,null,null,null,"Perspex",null,null,null,8.9999999999999993E-3,null,null,null,60,4.6700000000000002E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,4.0400000000000001E-4]
["Input",null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,3.5500000000000001E-4]
["A","Area – the cross-sectional area of flow, normal to the direction of flow.",null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Step 2 - Flow Geometry'!M21=\"\",\"-\",'Step 2 - Flow Geometry'!M21)","v":"-"},"m2",null,90,3.1500000000000001E-4]
["P","Wetted perimeter – the length of the wetted surface measured normal to the direction of flow.",null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Step 2 - Flow Geometry'!M24=\"\",\"-\",'Step 2 - Flow Geometry'!M24)","v":"-"},"m",null,100,2.8199999999999997E-4]
["n","Mannining's parameter – see the table above.",null,null,null,null,null,null,null,null,null,null,null,"-",null,"Desired T (oC)","Corresponding μ (Ns/m2)"]
["S0","Bed slope – bed's vertical distance to horizontal distance (for example 1:1000).",null,null,null,null,null,null,null,null,null,null,null,"-",null,15,{"$f":" 2.414*10^-5*10^(247.8/(P18+133 ))","v":1.1404115051629189E-3}]
["ρ","Density – the density of working fluid (usually for water).",null,null,null,null,null,null,null,null,null,null,null,"Kg/m3",null,"Using linear interpolation (not accurate)"]
["μ","Dynamic viscosity – the dynamic viscosity of working fluid (usually for water).",null,null,null,null,null,null,null,null,null,null,null,"Ns/m2",null,{"$f":"P18","v":15},{"$f":"FORECAST(P20,OFFSET(Knownμ,MATCH(P20,KnownT,1)-1,0,2),OFFSET(KnownT,MATCH(P20,KnownT,1)-1,0,2))","v":1.1545000000000001E-3}]
[]
["Output"]
["Q","Discharge – the flow discharge at the cross section.",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((1/M17)*((M15^(5/3))/(M16^(2/3)))*(M18^(1/2)),\"-\")","v":"-"},"m3/s"]
[]
[]
[]
["V","Mean velocity – the mean velocity of the flow at the cross section.",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(M23/M15,\"-\")","v":"-"},"m/s"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Open Channel Flow - Trapezoidal Cross Section"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© Christos Samaras"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mechanical Engineer"]
["Re","Reynolds number – it determines the type of flow in the channel.",null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR((M19*M27*M15)/(M20*M16),\"-\")","v":"-"},"-",null,"tel.: +306973513308"]
[null,null,null,"Laminar: Rechannel < 500",null,null,null,null,null,null,null,null,null,null,null,"e-mail: xristos.samaras@gmail.com"]
[null,null,null,"Transitional: 500 < Rechannel < 2000",null,null,null,null,null,null,null,null,null,null,null,"site: http://www.myengineeringworld.net"]
[null,null,null,"Turbulent: Rechannel > 2000",null,null,null,null,"Type of flow in the channel:",null,null,null,{"$f":"IFERROR(IF(M31=\"-\",\"-\",IF(M31<0,\"Error\",IF(M31<500,\"Laminar\",IF(M31>2000,\"Turbulent\",\"Transitional\")))),\"-\")","v":"-"},"-",null,"Thessaloniki, Greece,11/05/2013"]
[]
[null,null,null,null,null,null,"Control Buttons"]

{"sheet":"Equations","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[[39,0,39,1],[43,0,43,1],[39,3,39,4],[43,3,43,4]]}