{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Rock stage-flow","lookup_table"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Rock stage-flow","index":0,"n_rows":40,"n_cols":8,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Project Name",null,"Example Project"]
["Stage Discharge for Rock Ditch Checks"]
["Stone Type",null,"Washed Stone"]
["Graphical Method (user input area are shaded in Gray)"]
["Governing Equation:  dh/dl = aq^b"]
[]
[null,null,null,null,"Metric "]
[null,null,"Dam Height (ft)",2,{"$f":"D8*0.3048","v":0.60960000000000003},"*Max dam height = 2ft"]
[null,null,"Top Dam Flow Length (ft)",4,{"$f":"D9*0.3048","v":1.2192000000000001},"*Minimum top flow length = 2 ft"]
[null,null,"Rock Side Slopes (x:1)",4,null,"*Maximum Side slopes = 1:1"]
[null,null,"Rock Diameter D50 (inches)",6,{"$f":"(D11/12)*0.3048","v":0.15240000000000001}]
[]
[null,null,"Bottom Dam Width (ft)",3,{"$f":"(D13)*0.3048","v":0.9144000000000001}]
[null,null,"Soil-Rock Side Slope (x:1)",3]
[]
["Depth","Depth dh","Flow Length dl (m)","Coefficient","Exponent","Flow q","Flow Width","Total Flow"]
["(ft)","(m)","(m)"," a"," b","(m^2 / sec)","(ft)","cfs"]
[0,{"$f":"A18*0.3048","v":0},{"$f":"($D$9+2*($D$10*($D$8-A18)))*0.3048","v":6.0960000000000001},{"$f":"FindCoef_a($E$11,C18)","v":{"$error":"#NAME?"}},{"$f":"FindCoef_b($E$11)","v":{"$error":"#NAME?"}},{"$f":"(B18/(D18*C18))^(1/E18)","v":{"$error":"#NAME?"}},{"$f":"D13","v":3},{"$f":"(F18*10.764)*G18","v":{"$error":"#NAME?"}}]
[{"$f":"IF(A18<$D$8,A18+0.25,\"\")","v":0.25},{"$f":"A19*0.3048","v":7.6200000000000004E-2},{"$f":"IF(A19=0,0.001,($D$9+2*($D$10*($D$8-A19)))*0.3048)","v":5.4864000000000006},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"(B19/(D19*C19))^(1/E19)","v":{"$error":"#NAME?"}},{"$f":"IF(A19=0,0,(IF(A19>0,$D$13+2*($D$14*A19))))","v":4.5},{"$f":"(F19*10.764)*G19","v":{"$error":"#NAME?"}}]
[{"$f":"IF(A19=0,0,(IF(A19=$D$8,0,IF(A19<$D$8,A19+0.25))))","v":0.5},{"$f":"A20*0.3048","v":0.15240000000000001},{"$f":"IF(A20=0,0.001,($D$9+2*($D$10*($D$8-A20)))*0.3048)","v":4.8768000000000002},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"(B20/(D20*C20))^(1/E20)","v":{"$error":"#NAME?"}},{"$f":"IF(A20=0,0,(IF(A20>0,$D$13+2*($D$14*A20))))","v":6},{"$f":"(F20*10.764)*G20","v":{"$error":"#NAME?"}}]
[0.75,0.22860000000000003,4.2671999999999999,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},7.5,{"$error":"#NAME?"}]
[1,0.30480000000000002,3.6576000000000004,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},9,{"$error":"#NAME?"}]
[1.25,0.38100000000000001,3.048,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},10.5,{"$error":"#NAME?"}]
[1.5,0.45720000000000005,2.4384000000000001,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},12,{"$error":"#NAME?"}]
[1.75,0.53339999999999999,1.8288000000000002,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},13.5,{"$error":"#NAME?"}]
[1.8,0.54864000000000002,{"$f":"IF(A26=0,0.001,($D$9+2*($D$10*($D$8-A26)))*0.3048)","v":1.70688},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"(B26/(D26*C26))^(1/E26)","v":{"$error":"#NAME?"}},{"$f":"IF(A26=0,0,(IF(A26>0,$D$13+2*($D$14*A26))))","v":13.8},{"$f":"(F26*10.764)*G26","v":{"$error":"#NAME?"}}]
[{"$f":"IF(A25=0,0,(IF(A25=$D$8,0,IF(A25<$D$8,A25+0.25))))","v":2},0.60960000000000003,1.2192000000000001,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},15,{"$error":"#NAME?"}]
[]
[]
[null,"Stage","Discharge Q"]
[null,"(ft)","(cfs)"]
[null,{"$f":"A18","v":0},0]
[null,0.25,{"$f":"H19","v":{"$error":"#NAME?"}}]
[null,0.5,{"$error":"#NAME?"}]
[null,0.75,{"$error":"#NAME?"}]
[null,1,{"$error":"#NAME?"}]
[null,1.25,{"$error":"#NAME?"}]
[null,1.5,{"$error":"#NAME?"}]
[null,1.75,{"$error":"#NAME?"}]
[null,{"$f":"A27","v":2},{"$f":"H27","v":{"$error":"#NAME?"}}]

{"sheet":"lookup_table","index":1,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,null,"dl= 1m","dl = 2m","dl = 3m"]
["Stone D50 (m)","Exponent b","Coefficient a ","Coefficient a","Coefficient a"]
[null,null,1,2,3]
[0.01,0.6371,9.4,6.05,4.5999999999999996]
[0.02,0.65400000000000003,7.4,4.6500000000000004,3.55]
[0.03,0.65890000000000004,6.4,4.08,3.08]
[0.04,0.66090000000000004,5.85,3.65,2.8]
[0.05,0.66239999999999999,5.4,3.35,2.6]
[0.06,0.66349999999999998,5.05,3.15,2.4]
[0.08,0.66439999999999999,4.5,2.85,2.2000000000000002]
[0.09,0.66479999999999995,4.28,2.7,2.1]
[0.1,0.66510000000000002,4.13,2.6,2.0499999999999998]
[0.2,0.66620000000000001,3.2,2.0499999999999998,1.57]
[0.3,0.66639999999999999,2.8,1.75,1.3]
[0.4,0.66649999999999998,2.5,1.55,1.1599999999999999]
[0.5,0.66659999999999997,2.2999999999999998,1.4,1.08]
[]
[]
[]
[1E-3,"d15",{"$f":"FindCoef_a(A20,A21)","v":{"$error":"#NAME?"}},"coef_a"]
[3.5,"L",{"$f":"FindCoef_b(A20)","v":{"$error":"#NAME?"}},"coef_b"]