{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["断面係数の算出（任意）","断面係数の算出の手順","断面係数一覧表（排水フリューム）","断面係数一覧表（大型フリューム）"],"not_rendered":{"charts":1,"images":4,"macros":0,"external_links":0,"defined_names":78,"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":"断面係数の算出（任意）","index":0,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["1 河道流定数の計算",null,null,"※適当な水深を与えて、QとWの近似曲線を作成する。"]
["【手順】"]
["1 　対象水路の諸元を緑色のセルに入力する"]
["2　２割～１０割水深時の流量と流積の相関を累乗近似式で表すと、特性曲線式で必要となる河道流定数（K,P値）がグラフに表示される。"]
["3   グラフ中のK,P値をK12,L12セルに入力し、N16の値が流積の10％未満となるか確認する。"]
[]
[null,"水路幅\n（天端）\nmm","水路高\n\nmm","水路\n側壁勾配\n１：x","水路\n底幅\nmm","水路底\n勾配\n1:n","粗度係数"]
[null,null,null,null,{"$f":"B8-(C8*D8*2)","v":0}]
[]
[]
[null,"B【a】","H","B1【b】","h【ｈ】","A1","P1","V1","Q1","W","K","P","A2","ΔA=A1-A2"]
["２割水深",{"$f":"$B$8","v":0},{"$f":"$C$8","v":0},{"$f":"B12-C12*$D$8*2","v":0},{"$f":"E15*0.2","v":0},{"$f":"((B12/1000)+(D12/1000)+E12*$D$8*2)*E12*0.5","v":0},{"$f":"(D12/1000)+(1+$D$8^2)^0.5*E12*2","v":0},{"$f":"(1/$G$8)*(F12/G12)^(2/3)*(1/$F$8)^0.5","v":{"$error":"#DIV/0!"}},{"$f":"F12*H12","v":{"$error":"#DIV/0!"}},{"$f":"F12","v":0},0.70809999999999995,0.74070000000000003,{"$f":"K12*I12^L12","v":{"$error":"#DIV/0!"}},{"$f":"ABS(F12-M12)","v":{"$error":"#DIV/0!"}}]
["５割水深",{"$f":"B12","v":0},{"$f":"C12","v":0},{"$f":"B13-C13*$D$8*2","v":0},{"$f":"E15*0.5","v":0},{"$f":"((B13/1000)+(D13/1000)+E13*$D$8*2)*E13*0.5","v":0},{"$f":"(D13/1000)+(1+$D$8^2)^0.5*E13*2","v":0},{"$f":"(1/$G$8)*(F13/G13)^(2/3)*(1/$F$8)^0.5","v":{"$error":"#DIV/0!"}},{"$f":"F13*H13","v":{"$error":"#DIV/0!"}},{"$f":"F13","v":0},{"$f":"K12","v":0.70809999999999995},{"$f":"L12","v":0.74070000000000003},{"$f":"K13*I13^L13","v":{"$error":"#DIV/0!"}},{"$f":"ABS(F13-M13)","v":{"$error":"#DIV/0!"}}]
["８割水深",{"$f":"B13","v":0},{"$f":"C13","v":0},{"$f":"B14-C14*$D$8*2","v":0},{"$f":"E15*0.8","v":0},{"$f":"((B14/1000)+(D14/1000)+E14*$D$8*2)*E14*0.5","v":0},{"$f":"(D14/1000)+(1+$D$8^2)^0.5*E14*2","v":0},{"$f":"(1/$G$8)*(F14/G14)^(2/3)*(1/$F$8)^0.5","v":{"$error":"#DIV/0!"}},{"$f":"F14*H14","v":{"$error":"#DIV/0!"}},{"$f":"F14","v":0},{"$f":"K13","v":0.70809999999999995},{"$f":"L13","v":0.74070000000000003},{"$error":"#DIV/0!"},{"$f":"ABS(F14-M14)","v":{"$error":"#DIV/0!"}}]
["１０割水深",0,0,{"$f":"B15-C15*$D$8*2","v":0},{"$f":"C8/1000","v":0},{"$f":"((B15/1000)+(D15/1000)+E15*$D$8*2)*E15*0.5","v":0},{"$f":"(D15/1000)+(1+$D$8^2)^0.5*E15*2","v":0},{"$f":"(1/$G$8)*(F15/G15)^(2/3)*(1/$F$8)^0.5","v":{"$error":"#DIV/0!"}},{"$f":"F15*H15","v":{"$error":"#DIV/0!"}},{"$f":"F15","v":0},0.70809999999999995,0.74070000000000003,{"$error":"#DIV/0!"},{"$f":"ABS(F15-M15)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(SUM(N12:N15))","v":{"$error":"#DIV/0!"}}]

{"sheet":"断面係数の算出の手順","index":1,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["〇断面係数の算出"]
[]
["解析に使用する河道流定数を算出する。"]
["（適当な水深を与えたときの、流量（Q）と流積（W）の関係式から特性曲線式の係数K,Pを求める。）"]
[]
["1 　対象水路の諸元を緑色のセルに入力する"]
[]
[null,"水路幅\n（天端）\nmm","水路高\n\nmm","水路\n側壁勾配\n１：x","水路\n底幅\nmm","水路底\n勾配\n1:n","粗度係数"]
[null,1000,1000,3.5000000000000003E-2,{"$f":"B9-(C9*D9*2)","v":930},500,1.4E-2]
[]
["2　２割～１０割水深時の流量と流積の相関を累乗近似式で表すと、"]
["　　特性曲線式で必要となる河道流定数（K,P値）がグラフに表示される。"]
[]
[]
[]
[]
[]
[]
[]
["3   グラフ中のK,P値をK15,L15セルに入力し、N19の値が流積の10％未満となるか確認する。"]

{"sheet":"断面係数一覧表（排水フリューム）","index":2,"n_rows":23,"n_cols":19,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,13,2,14],[2,15,2,16],[2,17,2,18],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,2,10],[2,11,2,12]]}
["排水フリュームの断面係数一覧表"]
[null,"H【A】"]
[null,400,null,{"$f":"B3+100","v":500},null,{"$f":"D3+100","v":600},null,{"$f":"F3+100","v":700},null,{"$f":"H3+100","v":800},null,{"$f":"J3+100","v":900},null,{"$f":"L3+100","v":1000},null,{"$f":"N3+100","v":1100},null,{"$f":"P3+100","v":1200}]
[null,"1:X X=",3.6999999999999998E-2,"1:X X=",0.03,"1:X X=",2.8000000000000001E-2,"1:X X=",null,"1:X X=",3.7499999999999999E-2,"1:X X=",3.3500000000000002E-2,"1:X X=",3.4500000000000003E-2,"1:X X=",3.4500000000000003E-2,"1:X X=",3.4500000000000003E-2]
["B","K","P","K","P","K","P","K","P","K","P","K","P","K","P","K","P","K","P"]
[400,0.69210000000000005,0.7409,0.73429999999999995,0.76049999999999995,0.76780000000000004,0.7782]
[{"$f":"A6+100","v":500},null,null,0.6966,0.74019999999999997,0.72330000000000005,0.7571,0.73970000000000002,0.77780000000000005,0.7571,0.79110000000000003,0.77880000000000005,0.79590000000000005]
[{"$f":"A7+100","v":600},null,null,0.6774,0.72450000000000003,0.69950000000000001,0.74050000000000005,0.71089999999999998,0.75990000000000002,0.72489999999999999,0.77300000000000002,0.74460000000000004,0.77829999999999999]
[700,null,null,null,null,0.68700000000000006,0.72709999999999997,0.69489999999999996,0.74519999999999997,0.70630000000000004,0.75790000000000002,0.72440000000000004,0.76359999999999995]
[800,null,null,null,null,0.68140000000000001,0.71609999999999996,0.68669999999999998,0.73299999999999998,0.69610000000000005,0.74519999999999997,0.7127,0.75119999999999998]
[900,null,null,null,null,0.68010000000000004,0.70689999999999997,0.6835,0.72260000000000002,0.69130000000000003,0.73440000000000005,0.70660000000000001,0.74060000000000004]
[1000,null,null,null,null,0.68169999999999997,0.69899999999999995,0.68369999999999997,0.71379999999999999,0.69010000000000005,0.72509999999999997,0.70420000000000005,0.73129999999999995]
[1100,null,null,null,null,null,null,0.68610000000000004,0.70620000000000005,0.69140000000000001,0.71699999999999997,0.70450000000000002,0.72330000000000005]
[1200,null,null,null,null,null,null,0.69020000000000004,0.69950000000000001,0.69450000000000001,0.70989999999999998,0.70669999999999999,0.71609999999999996]
[1300,null,null,null,null,null,null,null,null,0.69889999999999997,0.7036,0.71030000000000004,0.70979999999999999]
[1400,null,null,null,null,null,null,null,null,null,null,0.71489999999999998,0.70409999999999995]
[1500]
[1600]
[1700]
[1800]
[1900]
[2000]
[2100]

{"sheet":"断面係数一覧表（大型フリューム）","index":3,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,13,3,14],[3,15,3,16],[3,17,3,18],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12]]}
[]
["大型フリュームの断面係数一覧表"]
[null,"H【ｈ】"]
[null,700,null,800,null,900,null,1000,null,1100,null,1200,null,1300,null,1400,null,1500]
[null,"1:X X=",3.5999999999999997E-2,"1:X X=",3.1E-2,"1:X X=",2.8000000000000001E-2,"1:X X=",3.5000000000000003E-2,"1:X X=",3.5000000000000003E-2,"1:X X=",3.3500000000000002E-2,"1:X X=",3.4500000000000003E-2,"1:X X=",3.4500000000000003E-2,"1:X X=",3.4500000000000003E-2]
["B【a】","K","P","K","P","K","P","K","P","K","P","K","P","K","P","K","P","K","P"]
[1000,0.69079999999999997,0.71079999999999999,0.69910000000000005,0.72119999999999995,0.70550000000000002,0.73080000000000001,0.70809999999999995,0.74070000000000003]
[{"$f":"A7+100","v":1100},0.69310000000000005,0.70350000000000001,0.70040000000000002,0.71350000000000002,0.70579999999999998,0.7228,0.70750000000000002,0.73229999999999995,0.71050000000000002,0.74039999999999995]
[{"$f":"A8+100","v":1200},0.69710000000000005,0.69720000000000004,0.70340000000000003,0.70669999999999999,0.70789999999999997,0.7157,0.70889999999999997,0.72489999999999999,7113,0.73280000000000001,0.7117,0.74060000000000004]
[1300,0.70220000000000005,0.6915,0.7077,0.70069999999999999,0.71150000000000002,0.70940000000000003,0.71179999999999999,0.71830000000000005,0.71360000000000001,0.72589999999999999,0.71350000000000002,0.73350000000000004,0.71279999999999999,0.74070000000000003]
[1400,0.70809999999999995,0.6865,0.71289999999999998,0.69540000000000002,0.71609999999999996,0.70379999999999998,0.71589999999999998,0.71240000000000003,0.71699999999999997,0.7198,0.71650000000000003,0.72719999999999996,0.71540000000000004,0.73409999999999997,0.71489999999999998,0.74039999999999995]
[1500,0.7147,0.68200000000000005,0.71879999999999999,0.69059999999999999,0.72140000000000004,0.69869999999999999,0.7208,0.70699999999999996,0.72160000000000002,0.71419999999999995,0.72050000000000003,0.72140000000000004,0.71899999999999997,0.72819999999999996,0.71819999999999995,0.73429999999999995]
[1600,0.72170000000000001,0.67800000000000005,0.72529999999999994,0.68630000000000002,0.72740000000000005,0.69410000000000005,0.72629999999999995,0.70209999999999995,0.72670000000000001,0.70920000000000005,0.72529999999999994,0.71609999999999996,0.72340000000000004,0.7228,0.72219999999999995,0.7288]
[1700,0.72899999999999998,0.67430000000000001,0.73209999999999997,0.68230000000000002,0.73380000000000001,0.69,0.73240000000000005,0.69769999999999999,0.73240000000000005,0.70450000000000002,0.73060000000000003,0.71130000000000004,0.72850000000000004,0.71779999999999999,0.72699999999999998,0.72370000000000001,0.72389999999999999,0.72960000000000003]
[1800,0.73660000000000003,0.67100000000000004,0.73929999999999996,0.67879999999999996,0.74060000000000004,0.68610000000000004,0.73880000000000001,0.69359999999999999,0.73839999999999995,0.70030000000000003,0.73640000000000005,0.70689999999999997,0.73399999999999999,0.71319999999999995,0.73219999999999996,0.71899999999999997,0.72889999999999999,0.7248]
[1900,0.74439999999999995,0.66800000000000004,0.74660000000000004,0.67549999999999999,0.74760000000000004,0.68259999999999998,0.74550000000000005,0.68989999999999996,0.74480000000000002,0.69640000000000002,0.74260000000000004,0.70279999999999998,0.7399,0.70899999999999996,0.73780000000000001,0.71460000000000001,0.73429999999999995,0.72030000000000005]
[2000,0.75229999999999997,0.66520000000000001,0.75419999999999998,0.67249999999999999,0.75480000000000003,0.6794,0.75239999999999996,0.6865,0.75149999999999995,0.69279999999999997,0.749,0.69899999999999995,0.74609999999999999,0.70499999999999996,0.74380000000000002,0.71060000000000001,0.74,0.71609999999999996]
[2100,null,null,null,null,null,null,null,null,0.75839999999999996,0.68940000000000001,0.75560000000000005,0.69550000000000001,0.75249999999999995,0.70140000000000002,0.75,0.70679999999999998,0.74609999999999999,0.71230000000000004]
[2200,null,null,null,null,null,null,null,null,null,null,0.76239999999999997,0.69230000000000003,0.7591,0.69799999999999995,0.75639999999999996,0.70330000000000004,0.75229999999999997,0.70860000000000001]
[2300,null,null,null,null,null,null,null,null,null,null,null,null,0.76590000000000003,0.69479999999999997,0.76300000000000001,0.7,0.75880000000000003,0.70520000000000005]
[2400,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.76970000000000005,0.69689999999999996,0.76539999999999997,0.70199999999999996]
[2500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.77200000000000002,0.69899999999999995]
[2600,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.77880000000000005,0.69620000000000004]
[2700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.78559999999999997,0.69359999999999999]