{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["水路"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"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":56,"n_cols":21,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[null,"水路断面の検討"]
[]
[null,"1）流出量"]
[]
[null,"　Ｑ＝",1,"(m3/sec)"]
[]
[null,"2）通水能力"]
[]
[]
[null,"　右図のような断面を仮定し、通水断面は８割で検討する。"]
[]
[]
[null,null,null,null,null,"--------　マニング式"]
[]
[]
[]
[null,"　Ｖ　：　平均流速(m/sec)"]
[null,"　Ｑｃ：　排水量  (m3/sec)",null,null,null,null,"Ｑｃ＞Ｑでなければならない。"]
[null,"　Ａ　：　通水断面積(m2)",null,null,null,"A=","B・H・0.8"]
[null,"　ｎ　：　粗度係数",null,null,null,"n=",1.2999999999999999E-2,null," "]
[null,"　Ｒ　：  径　深(m)",null,null,null,"R=","A / P"]
[null,"　Ｐ　：  潤辺長(m)",null,null,null,"P=","B + 2・H・0.8"]
[null,"　Ｉ　：　流路勾配  ",null,null,null,"I=",0.5,"%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"左",null,null,"右"]
[null,"Ｂ","Ｈ","Ｖ"," Ｑｃ","  Ｑ"," 判定","Ｂ","Ｈ","Ｖ"," Ｑｃ","  Ｑ"," 判定",null,null,"面積","径深","潤辺","面積","径深","潤辺"]
[null,150,150,{"$f":"ROUND(マニング($G$20,$G$23,$B27,$C27),3)","v":0.7},{"$f":"ROUND(流量($G$20,$G$23,$B27,$C27),3)","v":1.2999999999999999E-2},{"$f":"$C$5","v":1},{"$f":"IF((E27)>=F27,\"  ○  \",\"  ×\")","v":"  ×"},450,450,{"$f":"ROUND(マニング($G$20,$G$23,$H27,$I27),3)","v":1.456},{"$f":"ROUND(流量($G$20,$G$23,$H27,$I27),3)","v":0.23599999999999999},{"$f":"$C$5","v":1},{"$f":"IF((K27)>=L27,\"  ○  \",\"  ×\")","v":"  ×"},null,null,{"$f":"ROUND((B27/1000)*(C27/1000),3)","v":2.3E-2},{"$f":"ROUND(P27/R27,3)","v":5.0999999999999997E-2},{"$f":"ROUND((B27/1000)+(C27/1000)*2,3)","v":0.45},{"$f":"ROUND((H27/1000)*(I27/1000),3)","v":0.20300000000000001},{"$f":"ROUND(S27/U27,3)","v":0.15},{"$f":"ROUND((H27/1000)+(I27/1000)*2,3)","v":1.35}]
[null,180,180,{"$f":"ROUND(マニング($G$20,$G$23,$B28,$C28),3)","v":0.79},{"$f":"ROUND(流量($G$20,$G$23,$B28,$C28),3)","v":0.02},1,"  ×",500,500,{"$f":"ROUND(マニング($G$20,$G$23,$H28,$I28),3)","v":1.5620000000000001},{"$f":"ROUND(流量($G$20,$G$23,$H28,$I28),3)","v":0.312},1,"  ×",null,null,{"$f":"ROUND((B28/1000)*(C28/1000),3)","v":3.2000000000000001E-2},{"$f":"ROUND(P28/R28,3)","v":5.8999999999999997E-2},{"$f":"ROUND((B28/1000)+(C28/1000)*2,3)","v":0.54},{"$f":"ROUND((H28/1000)*(I28/1000),3)","v":0.25},{"$f":"ROUND(S28/U28,3)","v":0.16700000000000001},{"$f":"ROUND((H28/1000)+(I28/1000)*2,3)","v":1.5}]
[null,240,240,{"$f":"ROUND(マニング($G$20,$G$23,$B29,$C29),3)","v":0.95699999999999996},{"$f":"ROUND(流量($G$20,$G$23,$B29,$C29),3)","v":4.3999999999999997E-2},1,"  ×",500,600,{"$f":"ROUND(マニング($G$20,$G$23,$H29,$I29),3)","v":1.6319999999999999},{"$f":"ROUND(流量($G$20,$G$23,$H29,$I29),3)","v":0.39200000000000002},1,"  ×",null,null,5.8000000000000003E-2,8.1000000000000003E-2,0.72,0.3,0.17599999999999999,1.7]
[null,300,300,{"$f":"ROUND(マニング($G$20,$G$23,$B30,$C30),3)","v":1.111},{"$f":"ROUND(流量($G$20,$G$23,$B30,$C30),3)","v":0.08},1,"  ×",500,700,{"$f":"ROUND(マニング($G$20,$G$23,$H30,$I30),3)","v":1.6879999999999999},{"$f":"ROUND(流量($G$20,$G$23,$H30,$I30),3)","v":0.47299999999999998},1,"  ×",null,null,0.09,0.1,0.9,0.35,0.184,1.9]
[null,300,400,{"$f":"ROUND(マニング($G$20,$G$23,$B31,$C31),3)","v":1.1879999999999999},{"$f":"ROUND(流量($G$20,$G$23,$B31,$C31),3)","v":0.114},1,"  ×",500,800,{"$f":"ROUND(マニング($G$20,$G$23,$H31,$I31),3)","v":1.7330000000000001},{"$f":"ROUND(流量($G$20,$G$23,$H31,$I31),3)","v":0.55400000000000005},1,"  ×",null,null,0.12,0.109,1.1000000000000001,0.4,0.19,2.1]
[null,300,500,{"$f":"ROUND(マニング($G$20,$G$23,$B32,$C32),3)","v":1.242},{"$f":"ROUND(流量($G$20,$G$23,$B32,$C32),3)","v":0.14899999999999999},1,"  ×",500,900,{"$f":"ROUND(マニング($G$20,$G$23,$H32,$I32),3)","v":1.77},{"$f":"ROUND(流量($G$20,$G$23,$H32,$I32),3)","v":0.63700000000000001},1,"  ×",null,null,0.15,0.115,1.3,0.45,0.19600000000000001,2.2999999999999998]
[null,300,600,{"$f":"ROUND(マニング($G$20,$G$23,$B33,$C33),3)","v":1.2809999999999999},{"$f":"ROUND(流量($G$20,$G$23,$B33,$C33),3)","v":0.184},1,"  ×",500,1000,{"$f":"ROUND(マニング($G$20,$G$23,$H33,$I33),3)","v":1.8009999999999999},{"$f":"ROUND(流量($G$20,$G$23,$H33,$I33),3)","v":0.72},1,"  ×",null,null,0.18,0.12,1.5,0.5,0.2,2.5]
[null,300,700,{"$f":"ROUND(マニング($G$20,$G$23,$B34,$C34),3)","v":1.3109999999999999},{"$f":"ROUND(流量($G$20,$G$23,$B34,$C34),3)","v":0.22},1,"  ×",500,1100,{"$f":"ROUND(マニング($G$20,$G$23,$H34,$I34),3)","v":1.827},{"$f":"ROUND(流量($G$20,$G$23,$H34,$I34),3)","v":0.80400000000000005},1,"  ×",null,null,0.21,0.124,1.7,0.55000000000000004,0.20399999999999999,2.7]
[null,300,800,{"$f":"ROUND(マニング($G$20,$G$23,$B35,$C35),3)","v":1.3340000000000001},{"$f":"ROUND(流量($G$20,$G$23,$B35,$C35),3)","v":0.25600000000000001},1,"  ×",500,1200,{"$f":"ROUND(マニング($G$20,$G$23,$H35,$I35),3)","v":1.85},{"$f":"ROUND(流量($G$20,$G$23,$H35,$I35),3)","v":0.88800000000000001},1,"  ×",null,null,0.24,0.126,1.9,0.6,0.20699999999999999,2.9]
[null,300,900,{"$f":"ROUND(マニング($G$20,$G$23,$B36,$C36),3)","v":1.3540000000000001},{"$f":"ROUND(流量($G$20,$G$23,$B36,$C36),3)","v":0.29199999999999998},1,"  ×",500,1300,{"$f":"ROUND(マニング($G$20,$G$23,$H36,$I36),3)","v":1.87},{"$f":"ROUND(流量($G$20,$G$23,$H36,$I36),3)","v":0.97199999999999998},1,"  ×",null,null,0.27,0.129,2.1,0.65,0.21,3.1]
[null,300,1000,{"$f":"ROUND(マニング($G$20,$G$23,$B37,$C37),3)","v":1.369},{"$f":"ROUND(流量($G$20,$G$23,$B37,$C37),3)","v":0.32900000000000001},1,"  ×",500,1400,{"$f":"ROUND(マニング($G$20,$G$23,$H37,$I37),3)","v":1.887},{"$f":"ROUND(流量($G$20,$G$23,$H37,$I37),3)","v":1.0569999999999999},1,"  ○  ",null,null,0.3,0.13,2.2999999999999998,0.7,0.21199999999999999,3.3]
[null,300,1100,{"$f":"ROUND(マニング($G$20,$G$23,$B38,$C38),3)","v":1.383},{"$f":"ROUND(流量($G$20,$G$23,$B38,$C38),3)","v":0.36499999999999999},1,"  ×",500,1500,{"$f":"ROUND(マニング($G$20,$G$23,$H38,$I38),3)","v":1.903},{"$f":"ROUND(流量($G$20,$G$23,$H38,$I38),3)","v":1.1419999999999999},1,"  ○  ",null,null,0.33,0.13200000000000001,2.5,0.75,0.214,3.5]
[null,300,1200,{"$f":"ROUND(マニング($G$20,$G$23,$B39,$C39),3)","v":1.3939999999999999},{"$f":"ROUND(流量($G$20,$G$23,$B39,$C39),3)","v":0.40100000000000002},1,"  ×",500,1600,{"$f":"ROUND(マニング($G$20,$G$23,$H39,$I39),3)","v":1.917},{"$f":"ROUND(流量($G$20,$G$23,$H39,$I39),3)","v":1.2270000000000001},1,"  ○  ",null,null,0.36,0.13300000000000001,2.7,0.8,0.216,3.7]
[null,300,1300,{"$f":"ROUND(マニング($G$20,$G$23,$B40,$C40),3)","v":1.4039999999999999},{"$f":"ROUND(流量($G$20,$G$23,$B40,$C40),3)","v":0.438},1,"  ×",600,600,{"$f":"ROUND(マニング($G$20,$G$23,$H40,$I40),3)","v":1.764},{"$f":"ROUND(流量($G$20,$G$23,$H40,$I40),3)","v":0.50800000000000001},1,"  ×",null,null,0.39,0.13400000000000001,2.9,0.36,0.2,1.8]
[null,300,1400,{"$f":"ROUND(マニング($G$20,$G$23,$B41,$C41),3)","v":1.4119999999999999},{"$f":"ROUND(流量($G$20,$G$23,$B41,$C41),3)","v":0.47399999999999998},1,"  ×",600,700,{"$f":"ROUND(マニング($G$20,$G$23,$H41,$I41),3)","v":1.831},{"$f":"ROUND(流量($G$20,$G$23,$H41,$I41),3)","v":0.61499999999999999},1,"  ×",null,null,0.42,0.13500000000000001,3.1,0.42,0.21,2]
[null,300,1500,{"$f":"ROUND(マニング($G$20,$G$23,$B42,$C42),3)","v":1.42},{"$f":"ROUND(流量($G$20,$G$23,$B42,$C42),3)","v":0.51100000000000001},1,"  ×",600,800,{"$f":"ROUND(マニング($G$20,$G$23,$H42,$I42),3)","v":1.887},{"$f":"ROUND(流量($G$20,$G$23,$H42,$I42),3)","v":0.72399999999999998},1,"  ×",null,null,0.45,0.13600000000000001,3.3,0.48,0.218,2.2000000000000002]
[null,300,1600,{"$f":"ROUND(マニング($G$20,$G$23,$B43,$C43),3)","v":1.4259999999999999},{"$f":"ROUND(流量($G$20,$G$23,$B43,$C43),3)","v":0.54800000000000004},1,"  ×",600,900,{"$f":"ROUND(マニング($G$20,$G$23,$H43,$I43),3)","v":1.9319999999999999},{"$f":"ROUND(流量($G$20,$G$23,$H43,$I43),3)","v":0.83499999999999996},1,"  ×",null,null,0.48,0.13700000000000001,3.5,0.54,0.22500000000000001,2.4]
[null,400,400,{"$f":"ROUND(マニング($G$20,$G$23,$B44,$C44),3)","v":1.3460000000000001},{"$f":"ROUND(流量($G$20,$G$23,$B44,$C44),3)","v":0.17199999999999999},1,"  ×",600,1000,{"$f":"ROUND(マニング($G$20,$G$23,$H44,$I44),3)","v":1.9710000000000001},{"$f":"ROUND(流量($G$20,$G$23,$H44,$I44),3)","v":0.94599999999999995},1,"  ×",null,null,0.16,0.13300000000000001,1.2,0.6,0.23100000000000001,2.6]
[null,400,500,{"$f":"ROUND(マニング($G$20,$G$23,$B45,$C45),3)","v":1.42},{"$f":"ROUND(流量($G$20,$G$23,$B45,$C45),3)","v":0.22700000000000001},1,"  ×",600,1100,{"$f":"ROUND(マニング($G$20,$G$23,$H45,$I45),3)","v":2.0049999999999999},{"$f":"ROUND(流量($G$20,$G$23,$H45,$I45),3)","v":1.0580000000000001},1,"  ○  ",null,null,0.2,0.14299999999999999,1.4,0.66,0.23599999999999999,2.8]
[null,400,600,{"$f":"ROUND(マニング($G$20,$G$23,$B46,$C46),3)","v":1.4750000000000001},{"$f":"ROUND(流量($G$20,$G$23,$B46,$C46),3)","v":0.28299999999999997},1,"  ×",600,1200,{"$f":"ROUND(マニング($G$20,$G$23,$H46,$I46),3)","v":2.0329999999999999},{"$f":"ROUND(流量($G$20,$G$23,$H46,$I46),3)","v":1.171},1,"  ○  ",null,null,0.24,0.15,1.6,0.72,0.24,3]
[null,400,700,{"$f":"ROUND(マニング($G$20,$G$23,$B47,$C47),3)","v":1.518},{"$f":"ROUND(流量($G$20,$G$23,$B47,$C47),3)","v":0.34},1,"  ×",600,1300,{"$f":"ROUND(マニング($G$20,$G$23,$H47,$I47),3)","v":2.0590000000000002},{"$f":"ROUND(流量($G$20,$G$23,$H47,$I47),3)","v":1.2849999999999999},1,"  ○  ",null,null,0.28000000000000003,0.156,1.8,0.78,0.24399999999999999,3.2]
[null,400,800,{"$f":"ROUND(マニング($G$20,$G$23,$B48,$C48),3)","v":1.552},{"$f":"ROUND(流量($G$20,$G$23,$B48,$C48),3)","v":0.39700000000000002},1,"  ×",600,1400,{"$f":"ROUND(マニング($G$20,$G$23,$H48,$I48),3)","v":2.081},{"$f":"ROUND(流量($G$20,$G$23,$H48,$I48),3)","v":1.3979999999999999},1,"  ○  ",null,null,0.32,0.16,2,0.84,0.247,3.4]
[null,400,900,{"$f":"ROUND(マニング($G$20,$G$23,$B49,$C49),3)","v":1.58},{"$f":"ROUND(流量($G$20,$G$23,$B49,$C49),3)","v":0.45500000000000002},1,"  ×",600,1500,{"$f":"ROUND(マニング($G$20,$G$23,$H49,$I49),3)","v":2.101},{"$f":"ROUND(流量($G$20,$G$23,$H49,$I49),3)","v":1.512},1,"  ○  ",null,null,0.36,0.16400000000000001,2.2000000000000002,0.9,0.25,3.6]
[null,400,1000,{"$f":"ROUND(マニング($G$20,$G$23,$B50,$C50),3)","v":1.603},{"$f":"ROUND(流量($G$20,$G$23,$B50,$C50),3)","v":0.51300000000000001},1,"  ×",600,1600,{"$f":"ROUND(マニング($G$20,$G$23,$H50,$I50),3)","v":2.1179999999999999},{"$f":"ROUND(流量($G$20,$G$23,$H50,$I50),3)","v":1.627},1,"  ○  ",null,null,0.4,0.16700000000000001,2.4,0.96,0.253,3.8]
[null,400,1100,{"$f":"ROUND(マニング($G$20,$G$23,$B51,$C51),3)","v":1.623},{"$f":"ROUND(流量($G$20,$G$23,$B51,$C51),3)","v":0.57099999999999995},1,"  ×",700,700,{"$f":"ROUND(マニング($G$20,$G$23,$H51,$I51),3)","v":1.954},{"$f":"ROUND(流量($G$20,$G$23,$H51,$I51),3)","v":0.76600000000000001},1,"  ×",null,null,0.44,0.16900000000000001,2.6,0.49,0.23300000000000001,2.1]
[null,400,1200,{"$f":"ROUND(マニング($G$20,$G$23,$B52,$C52),3)","v":1.64},{"$f":"ROUND(流量($G$20,$G$23,$B52,$C52),3)","v":0.63},1,"  ×",800,800,{"$f":"ROUND(マニング($G$20,$G$23,$H52,$I52),3)","v":2.1360000000000001},{"$f":"ROUND(流量($G$20,$G$23,$H52,$I52),3)","v":1.0940000000000001},1,"  ○  ",null,null,0.48,0.17100000000000001,2.8,0.64,0.26700000000000002,2.4]
[null,400,1300,{"$f":"ROUND(マニング($G$20,$G$23,$B53,$C53),3)","v":1.6539999999999999},{"$f":"ROUND(流量($G$20,$G$23,$B53,$C53),3)","v":0.68799999999999994},1,"  ×",900,900,{"$f":"ROUND(マニング($G$20,$G$23,$H53,$I53),3)","v":2.3109999999999999},{"$f":"ROUND(流量($G$20,$G$23,$H53,$I53),3)","v":1.4970000000000001},1,"  ○  ",null,null,0.52,0.17299999999999999,3,0.81,0.3,2.7]
[null,400,1400,{"$f":"ROUND(マニング($G$20,$G$23,$B54,$C54),3)","v":1.667},{"$f":"ROUND(流量($G$20,$G$23,$B54,$C54),3)","v":0.747},1,"  ×",1000,1000,{"$f":"ROUND(マニング($G$20,$G$23,$H54,$I54),3)","v":2.4790000000000001},{"$f":"ROUND(流量($G$20,$G$23,$H54,$I54),3)","v":1.9830000000000001},1,"  ○  ",null,null,0.56000000000000005,0.17499999999999999,3.2,1,0.33300000000000002,3]
[null,400,1500,{"$f":"ROUND(マニング($G$20,$G$23,$B55,$C55),3)","v":1.679},{"$f":"ROUND(流量($G$20,$G$23,$B55,$C55),3)","v":0.80600000000000005},1,"  ×",1100,1100,{"$f":"ROUND(マニング($G$20,$G$23,$H55,$I55),3)","v":2.6419999999999999},{"$f":"ROUND(流量($G$20,$G$23,$H55,$I55),3)","v":2.5569999999999999},1,"  ○  ",null,null,0.6,0.17599999999999999,3.4,1.21,0.36699999999999999,3.3]
[null,400,1600,{"$f":"ROUND(マニング($G$20,$G$23,$B56,$C56),3)","v":1.6890000000000001},{"$f":"ROUND(流量($G$20,$G$23,$B56,$C56),3)","v":0.86499999999999999},1,"  ×",1200,1200,{"$f":"ROUND(マニング($G$20,$G$23,$H56,$I56),3)","v":2.7989999999999999},{"$f":"ROUND(流量($G$20,$G$23,$H56,$I56),3)","v":3.2250000000000001},1,"  ○  ",null,null,0.64,0.17799999999999999,3.6,1.44,0.4,3.6]