{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["CalculationsCircle","CalculationsTriangle","CalculationsTrapezoid","Calculator","Solver","Test Calculator","Images","CalculationsRectangle","Units","Parameters","Types"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":35,"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":"CalculationsCircle","index":0,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":true,"merged":[[22,0,22,1],[7,0,7,6],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1]]}
[]
[]
[]
[]
[]
[]
[]
["Open Channel Flow Canal Sizing"]
[]
["Solve for Flow Velocity and Flow Discharge"]
[]
["Given"]
["Channel Slope (S)",null,"="]
["Velocity (V)",null,"="]
["Discharge (Q)",null,"="]
["Water Depth (y)",null,"="]
[]
[]
[]
["Product"]
[null,null,"="]
[null,null,"="]
["Wetted Perimeter (P)",null,"=",null,"ft"]
["Flow Area (A)",null,"=",null,"ft2"]
["Specific Energy (E)",null,"=",null,"ft"]
["Top Width (T)",null,"=",null,"ft"]
["Froude Number (F)",null,"="]
["Flow Status",null,"="]
[]
["Solution"]

{"sheet":"CalculationsTriangle","index":1,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":true,"merged":[[22,0,22,1],[7,0,7,6],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1]]}
[]
[]
[]
[]
[]
[]
[]
["Open Channel Flow Canal Sizing"]
[]
["Solve for Flow Velocity and Flow Discharge"]
[]
["Given"]
["Channel Slope (S)",null,"="]
["Velocity (V)",null,"="]
["Discharge (Q)",null,"="]
["Water Depth (y)",null,"="]
[]
[]
[]
["Product"]
[null,null,"="]
[null,null,"="]
["Wetted Perimeter (P)",null,"=",null,"ft"]
["Flow Area (A)",null,"=",null,"ft2"]
["Specific Energy (E)",null,"=",null,"ft"]
["Top Width (T)",null,"=",null,"ft"]
["Froude Number (F)",null,"="]
["Flow Status",null,"="]
[]
["Solution"]

{"sheet":"CalculationsTrapezoid","index":2,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":true,"merged":[[22,0,22,1],[7,0,7,6],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1]]}
[]
[]
[]
[]
[]
[]
[]
["Open Channel Flow Canal Sizing"]
[]
["Solve for Flow Velocity and Flow Discharge"]
[]
["Given"]
["Channel Slope (S)",null,"="]
["Velocity (V)",null,"="]
["Discharge (Q)",null,"="]
["Water Depth (y)",null,"="]
[]
[]
[]
["Product"]
[null,null,"="]
[null,null,"="]
["Wetted Perimeter (P)",null,"=",null,"ft"]
["Flow Area (A)",null,"=",null,"ft2"]
["Specific Energy (E)",null,"=",null,"ft"]
["Top Width (T)",null,"=",null,"ft"]
["Froude Number (F)",null,"="]
["Flow Status",null,"="]
[]
["Solution"]

{"sheet":"Calculator","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Solver","index":4,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Solve for Depth from Q for Any Shape through form"]
["Q eqn","A","P","n","b","So","y","Q","Lslope","Rslope","Theta"]
[{"$f":"(1.486/D3)*B3*(B3/C3)^(2/3)*F3^(1/2)","v":500.00000051081673},{"$f":"G3*(E3+(0.5*(I3+J3)*G3))","v":383.94113229030495},{"$f":"E3+G3*((J3^2+1)^(1/2)+(I3^2+1)^(1/2))","v":98.382378997051035},4,56.788226458060983,2,5,500,2,6]
["Solve for Depth from Q for Trapezoid"]
["Q eqn","A","P","n","b","So","y","Q","Lslope","Rslope"]
[{"$f":"(1.486/D6)*B6*(B6/C6)^(2/3)*F6^(1/2)","v":27.999999719949681},{"$f":"G6*(E6+(0.5*(I6+J6)*G6))","v":6.0374076019528191},{"$f":"E6+G6*((J6^2+1)^(1/2)+(I6^2+1)^(1/2))","v":11.207481520390564},0.03,10,0.02,0.60374076019528189]
["Solve for Depth from Q for Triangle"]
["Q eqn","A","P","n","b","So","y","Q","Lslope","Rslope"]
[{"$f":"(1.486/D9)*B9*(B9/C9)^(2/3)*F9^(1/2)","v":0},{"$f":"(((G9)^2)/2)*(I9+J9)","v":0},{"$f":"G9*((J9^2+1)^(1/2)+(I9^2+1)^(1/2))","v":1.2609115708067482},0.03,10,0.02,0.6304557854033741]
["Solve for Depth from Q for Circle"]
["Q eqn","A","P","n","r","So","y","Q",null,null,"Theta"]
[{"$f":"(1.486/D12)*B12*(B12/C12)^(2/3)*F12^(1/2)","v":{"$error":"#DIV/0!"}},{"$f":"(1/2)*((K12-SIN(K12))*E12^2)","v":0},{"$f":"K12*E12","v":0},0.03,10,0.02,0.6304557854033741]
[]
["Solve for Depth from Q for Rectangle"]
["Q eqn","A","P","n","b","So","y","Q"]
[{"$f":"(1.486/D16)*B16*(B16/C16)^(2/3)*F16^(1/2)","v":3.0000000546399672},{"$f":"E16*G16","v":5.0103391504922978},{"$f":"E16+2*G16","v":6.3402261003281986},3,3,2,1.6701130501640993,3]

{"sheet":"Test Calculator","index":5,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":true,"merged":[[0,0,1,0]]}
["Select Channel Type:",2]
[null,null,null,"t"]
[]
[null,3]
[]
[]
["Channel Slope:",null,"ft/ft","Water Depth (y):",null,"ft"]
[]
["Velocity (V):",null,"ft/s","Mannings n:",null,"ft/ft"]
[]
["Discharge (Q):",null,"ft3/s","Bottom Width (b):",null,"ft"]
[]
["Left Slope (Z1):",null,"ft/ft","Right Slope (Z2):",null,"ft/ft"]

{"sheet":"Images","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"CalculationsRectangle","index":7,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":true,"merged":[[26,0,26,1],[27,0,27,1],[7,0,7,6],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1]]}
[]
[]
[]
[]
[]
[]
[]
["Open Channel Flow Canal Sizing"]
[]
["Solve for Flow Velocity and Flow Discharge"]
[]
["Given"]
["Channel Slope (S)",null,"="]
["Velocity (V)",null,"="]
["Discharge (Q)",null,"="]
["Water Depth (y)",null,"="]
[]
[]
[]
["Product"]
[null,null,"="]
[null,null,"="]
["Wetted Perimeter (P)",null,"=",null,"ft"]
["Flow Area (A)",null,"=",null,"ft2"]
["Specific Energy (E)",null,"=",null,"ft"]
["Top Width (T)",null,"=",null,"ft"]
["Froude Number (F)",null,"="]
["Flow Status",null,"="]
[]
["Solution"]

{"sheet":"Units","index":8,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Feet (ft)","ft^2","ft^3/s"]
["Meter (m)","m^2","m^3/s"]

{"sheet":"Parameters","index":9,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Velocity(V) & Discharge(Q)"]
["Channel Slope from V"]
["Channel Slope from Q"]
["Manning Coefficient from V"]
["Manning Coefficient from Q"]
["Depth from Q"]
["Bottom Width from Q"]

{"sheet":"Types","index":10,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Channel Types"]
["Trapezoid"]
["Rectangle"]
["Triangle"]
["Circle"]