{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Temp Sed Trap Calculations","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":"Temp Sed Trap Calculations","index":0,"n_rows":72,"n_cols":14,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
["Temporary Sediment Trap Rock Stage Discharge ",null,null,null,null,null,null,null,"Stage Area-Storage Calculations (user input area are shaded in Gray)"]
["Graphical Method (user input area are shaded in Gray)"]
["Governing Equation:  dh/dl = aq^b",null,null,null,null,null,null,null,null,null,"Trapping Area Height (ft)=",5]
[null,null,null,null,null,null,null,null,null,null,"Stage Area-Storage Increments (ft)=",0.25]
[null,null,null,null,"Metric "]
[null,null,"Dam Height (ft)",5,{"$f":"D6*0.3048","v":1.524},"Max dam height = 5.0 feet",null,null,null,"Side Slopes (x:1)"]
[null,null,"Top Dam Flow Length (ft)",3.3,{"$f":"D7*0.3048","v":1.0058400000000001},"Minimum = 2.0 feet",null,null,null,"Left  =",2]
[null,null,"Rock Side Slopes (x:1)",1,null,null,null,null,null,"Right =",2]
[null,null,"Rock Diameter D50 (inches)",6,{"$f":"(D9/12)*0.3048","v":0.15240000000000001},null,null,null,null,"Front Slope  =",2]
[null,null,null,null,null,null,null,null,null,"Back slope =",3]
[null,null,"Bottom Dam Width (ft)",10,{"$f":"(D11)*0.3048","v":3.048}]
[null,null,"Soil-Rock Side Slope (x:1)",1,null,null,null,null,null,"Bottom Dimension (ft)"]
[null,null,null,null,null,null,null,null,null,"Length =",40]
["Depth","Depth","Flow Length dl (m)","Coefficient","Exponent","Flow ","Flow Width","Total Flow",null,"Width =",20]
["(ft)","(m)","(m)"," a"," b","(m^2 / sec)","(ft)","cfs"]
[0,{"$f":"A16*0.3048","v":0},{"$f":"($D$7+2*($D$8*($D$6-A16)))*0.3048","v":4.0538400000000001},{"$f":"FindCoef_a($E$9,C16)","v":{"$error":"#NAME?"}},{"$f":"FindCoef_b($E$9)","v":{"$error":"#NAME?"}},{"$f":"(B16/(D16*C16))^(1/E16)","v":{"$error":"#NAME?"}},{"$f":"D11","v":10},{"$f":"(F16*10.764)*G16","v":{"$error":"#NAME?"}},null,"Stage (ft)","Area (ft^2)","Area (acres)","Storage (ft^3)","Storage (acre-ft)"]
[{"$f":"IF(A16<$D$6,A16+0.25,IF(A16=$D$6,0))","v":0.25},{"$f":"A17*0.3048","v":7.6200000000000004E-2},3.9014400000000005,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"((B17-B16)/(D17*C17))^(1/E17)","v":{"$error":"#NAME?"}},{"$f":"$D$11+2*($D$12*A17)","v":10.5},{"$f":"(F17*10.764)*G17","v":{"$error":"#NAME?"}},null,0,{"$f":"K13*K14","v":800},{"$f":"K17/43560","v":1.8365472910927456E-2},0,0]
[{"$f":"IF(A17=0,0,(IF(A17=$D$6,0,IF(A17<$D$6,A17+0.25))))","v":0.5},{"$f":"A18*0.3048","v":0.15240000000000001},3.7490400000000004,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"(B18/(D18*C18))^(1/E18)","v":{"$error":"#NAME?"}},11,{"$f":"(F18*10.764)*G18","v":{"$error":"#NAME?"}},null,{"$f":"IF(J17<$L$3,J17+$L$4,\"Over top\")","v":0.25},{"$f":"IF(J17<$L$3,($K$13+$K$9*(J18-$J$17)+$K$10*(J18-$J$17))*($K$14+$K$7*(J18-$J$17)+$K$8*(J18-$J$17)),\" \")","v":866.25},{"$f":"IF(J17<$L$3,K18/43560,\" \")","v":1.9886363636363636E-2},{"$f":"IF(J17<$L$3,M17+(K17+K18)/2*(J18-J17),\" \")","v":208.28125},{"$f":"IF(J17<$L$3,M18/43560,\" \")","v":4.7814795684113865E-3}]
[{"$f":"IF(A18=0,0,(IF(A18=$D$6,0,IF(A18<$D$6,A18+0.25))))","v":0.75},0.22860000000000003,3.5966400000000003,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},11.5,{"$error":"#NAME?"},null,0.5,935,2.1464646464646464E-2,433.4375,9.9503558310376494E-3]
[1,0.30480000000000002,3.4442400000000002,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},12,{"$error":"#NAME?"},null,0.75,1006.25,2.310032139577594E-2,676.09375,1.5520976813590451E-2]
[1.25,0.38100000000000001,3.2918400000000005,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},12.5,{"$error":"#NAME?"},null,1,1080,2.4793388429752067E-2,936.875,2.1507690541781452E-2]
[1.5,0.45720000000000005,3.1394400000000005,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},13,{"$error":"#NAME?"},null,1.25,1156.25,2.6543847566574838E-2,1216.40625,2.7924845041322314E-2]
[1.75,0.53339999999999999,2.9870400000000004,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},13.5,{"$error":"#NAME?"},null,1.5,1235,2.835169880624426E-2,1515.3125,{"$f":"IF(J22<$L$3,M23/43560,\" \")","v":3.4786788337924701E-2}]
[2,0.60960000000000003,2.8346400000000003,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},14,{"$error":"#NAME?"},null,1.75,1316.25,3.0216942148760331E-2,1834.21875,4.2107868457300274E-2]
[2.25,0.68580000000000008,{"$f":"($D$7+2*($D$8*($D$6-A25)))*0.3048","v":2.6822400000000002},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"(B25/(D25*C25))^(1/E25)","v":{"$error":"#NAME?"}},{"$f":"$D$11+2*($D$12*A25)","v":14.5},{"$f":"(F25*10.764)*G25","v":{"$error":"#NAME?"}},null,2,1400,3.2139577594123052E-2,2173.75,4.9902433425160701E-2]
[2.5,0.76200000000000001,2.5298400000000005,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},15,{"$error":"#NAME?"},null,2.25,1486.25,3.4119605142332414E-2,2534.53125,5.8184831267217629E-2]
[2.75,0.83820000000000006,2.37744,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},15.5,{"$error":"#NAME?"},null,2.5,1575,3.6157024793388427E-2,{"$f":"IF(J26<$L$3,M26+(K26+K27)/2*(J27-J26),\" \")","v":2917.1875},6.6969410009182731E-2]
[3,0.9144000000000001,2.2250399999999999,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},16,{"$error":"#NAME?"},null,{"$f":"IF(J27<$L$3,J27+$L$4,\"Overtop\")","v":2.75},1666.25,3.8251836547291092E-2,3322.34375,7.627051767676768E-2]
[3.25,0.99060000000000004,2.0726400000000003,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},16.5,{"$error":"#NAME?"},null,{"$f":"IF(J28<$L$3,J28+$L$4,\"Overtop\")","v":3},1760,{"$f":"IF(J28<$L$3,K29/43560,\" \")","v":4.0404040404040407E-2},{"$f":"IF(J28<$L$3,M28+(K28+K29)/2*(J29-J28),\" \")","v":3750.625},{"$f":"IF(J28<$L$3,M29/43560,\" \")","v":8.6102502295684114E-2}]
[3.5,1.0668,1.9202399999999999,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},17,{"$error":"#NAME?"},null,3.25,1856.25,4.261363636363636E-2,4202.65625,9.6479711891643713E-2]
[3.75,1.143,1.7678400000000001,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},17.5,{"$error":"#NAME?"},null,3.5,1955,4.4880624426078972E-2,4679.0625,0.10741649449035813]
[4,1.2192000000000001,1.61544,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},18,{"$error":"#NAME?"},null,3.75,2056.25,4.7205004591368227E-2,5180.46875,0.11892719811753903]
[{"$f":"IF(A32=0,0,(IF(A32=$D$6,0,IF(A32<$D$6,A32+0.25))))","v":4.25},1.2954000000000001,{"$f":"($D$7+2*($D$8*($D$6-A33)))*0.3048","v":1.4630400000000001},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"(B33/(D33*C33))^(1/E33)","v":{"$error":"#NAME?"}},{"$f":"$D$11+2*($D$12*A33)","v":18.5},{"$f":"(F33*10.764)*G33","v":{"$error":"#NAME?"}},null,4,2160,4.9586776859504134E-2,5707.5,0.13102617079889808]
[{"$f":"IF(A33=0,0,(IF(A33=$D$6,0,IF(A33<$D$6,A33+0.25))))","v":4.5},1.3716000000000002,{"$f":"($D$7+2*($D$8*($D$6-A34)))*0.3048","v":1.31064},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"(B34/(D34*C34))^(1/E34)","v":{"$error":"#NAME?"}},{"$f":"$D$11+2*($D$12*A34)","v":19},{"$f":"(F34*10.764)*G34","v":{"$error":"#NAME?"}},null,4.25,2266.25,5.2025941230486684E-2,6260.78125,0.14372776056014691]
[{"$f":"IF(A34=0,0,(IF(A34=$D$6,0,IF(A34<$D$6,A34+0.25))))","v":4.75},1.4478,{"$f":"($D$7+2*($D$8*($D$6-A35)))*0.3048","v":1.1582399999999999},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"(B35/(D35*C35))^(1/E35)","v":{"$error":"#NAME?"}},{"$f":"$D$11+2*($D$12*A35)","v":19.5},{"$f":"(F35*10.764)*G35","v":{"$error":"#NAME?"}},null,4.5,2375,5.4522497704315886E-2,6840.9375,0.15704631542699724]
[{"$f":"IF(A35=0,0,(IF(A35=$D$6,0,IF(A35<$D$6,A35+0.25))))","v":5},1.524,{"$f":"($D$7+2*($D$8*($D$6-A36)))*0.3048","v":1.0058400000000001},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"(B36/(D36*C36))^(1/E36)","v":{"$error":"#NAME?"}},{"$f":"$D$11+2*($D$12*A36)","v":20},{"$f":"(F36*10.764)*G36","v":{"$error":"#NAME?"}},null,4.75,2486.25,5.7076446280991733E-2,7448.59375,0.17099618342516071]
[null,null,null,null,null,null,null,null,null,5,2600,5.968778696051423E-2,8084.375,0.18559171258034896]
[null,null,null,null,null,null,null,null,null,"Overtop"," "," "," "," "]
[null,null,null,null,null,null,null,null,null,"Overtop"," "," "," "," "]
[null,null,null,null,null,null,null,null,null,"Overtop"," "," "," "," "]
[null,null,null,null,null,null,null,null,null,"Overtop"," "," "," "," "]
[null,null,null,null,null,null,null,null,null,"Overtop"," "," "," "," "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Stage","Discharge","Storage "]
[null,null,null,null,null,null,null,null,null,"(ft)","(cfs)","acre-ft"]
[null,null,null,null,null,null,null,null,null,{"$f":"A16","v":0},0,{"$f":"N17","v":0}]
[null,null,null,null,null,null,null,null,null,0.25,{"$f":"H17","v":{"$error":"#NAME?"}},{"$f":"N18","v":4.7814795684113865E-3}]
[null,null,null,null,null,null,null,null,null,0.5,{"$error":"#NAME?"},9.9503558310376494E-3]
[null,null,null,null,null,null,null,null,null,0.75,{"$error":"#NAME?"},1.5520976813590451E-2]
[null,null,null,null,null,null,null,null,null,1,{"$error":"#NAME?"},2.1507690541781452E-2]
[null,null,null,null,null,null,null,null,null,1.25,{"$error":"#NAME?"},2.7924845041322314E-2]
[null,null,null,null,null,null,null,null,null,1.5,{"$error":"#NAME?"},3.4786788337924701E-2]
[null,null,null,null,null,null,null,null,null,1.75,{"$error":"#NAME?"},4.2107868457300274E-2]
[null,null,null,null,null,null,null,null,null,2,{"$error":"#NAME?"},4.9902433425160701E-2]
[null,null,null,null,null,null,null,null,null,2.25,{"$error":"#NAME?"},5.8184831267217629E-2]
[null,null,null,null,null,null,null,null,null,2.5,{"$error":"#NAME?"},6.6969410009182731E-2]
[null,null,null,null,null,null,null,null,null,2.75,{"$error":"#NAME?"},7.627051767676768E-2]
[null,null,null,null,null,null,null,null,null,3,{"$error":"#NAME?"},8.6102502295684114E-2]
[null,null,null,null,null,null,null,null,null,3.25,{"$error":"#NAME?"},9.6479711891643713E-2]
[null,null,null,null,null,null,null,null,null,3.5,{"$error":"#NAME?"},0.10741649449035813]
[null,null,null,null,null,null,null,null,null,3.75,{"$error":"#NAME?"},0.11892719811753903]
[null,null,null,null,null,null,null,null,null,4,{"$error":"#NAME?"},0.13102617079889808]
[null,null,null,null,null,null,null,null,null,4.25,{"$error":"#NAME?"},0.14372776056014691]
[null,null,null,null,null,null,null,null,null,4.5,{"$error":"#NAME?"},0.15704631542699724]
[null,null,null,null,null,null,null,null,null,4.75,{"$error":"#NAME?"},0.17099618342516071]
[null,null,null,null,null,null,null,null,null,5,{"$error":"#NAME?"},0.18559171258034896]

{"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"]