{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["説明","5.2 津波の波力","5.3 被覆石及びブロックの所要質量","5.4 上部工に作用する波圧"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":0,"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":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[8,1,8,7],[8,8,8,14],[10,1,10,11],[11,1,11,10],[12,1,12,10],[7,1,7,7],[7,8,7,11],[7,12,7,14],[5,1,5,7],[5,8,5,11],[5,12,5,14],[6,1,6,7],[6,8,6,11],[6,12,6,14],[1,1,1,7],[2,1,4,7],[2,8,4,11],[2,12,2,14],[3,12,3,14],[4,12,4,14]]}
[]
[null,"【目次】"]
[null,"項　　　目",null,null,null,null,null,null,"計算ツールの場所（シート名）",null,null,null,"参　　　照"]
[null,null,null,null,null,null,null,null,null,null,null,null,"「漁港・漁場の施設の設計参考図書」"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ページ"]
[null,"津波波力の算定 （谷本式、水工研式）",null,null,null,null,null,null,"5.2 津波の波力",null,null,null,"104-108"]
[null,"津波の流れの作用に対する被覆石及びブロックの所要質量の算定",null,null,null,null,null,null,"5.3 被覆石及びブロックの所要質量",null,null,null,"108-110"]
[null,"直立消波ブロック式係船岸における上部工に作用する波圧の算定",null,null,null,null,null,null,"5.4 上部工に作用する波圧",null,null,null,"110-112"]
[null,null,null,null,null,null,null,null,"　※下線部分をクリックすると各計算ツールの場所に移動します"]
[]
[null,"【使用方法】"]
[null,"①計算ツール内の黄色のセルに各パラメータを入力すると、算定値が出力されます。"]
[null,"②計算ツール内の緑色のセルには係数または定数が入力されています。必要に応じて変更してください。"]

{"sheet":"5.2 津波の波力","index":1,"n_rows":72,"n_cols":13,"rows_kept":72,"cut":false,"hidden":false,"merged":[[24,12,24,16],[2,2,2,9],[3,2,3,9],[4,2,4,9],[18,12,18,16],[22,12,22,16],[21,12,21,16],[20,12,20,16],[19,12,19,16],[1,1,1,9],[7,2,7,9],[15,3,15,8],[21,3,21,8],[22,3,22,9],[16,6,17,6],[16,5,17,5],[16,4,17,4],[16,3,17,3],[61,12,61,16],[60,12,60,16],[71,12,71,16],[70,12,70,16],[69,12,69,16],[68,12,68,16],[67,12,67,16],[66,12,66,16],[65,12,65,16],[64,12,64,16],[63,12,63,16],[62,12,62,16],[45,6,46,6],[45,5,46,5],[45,4,46,4],[45,3,46,3],[23,12,23,16],[36,2,36,10],[30,11,32,16],[29,12,29,16],[28,12,28,16],[27,12,27,16],[26,12,26,16],[23,3,24,3],[23,4,24,4],[23,5,24,5],[23,6,24,6],[25,12,25,16]]}
[]
[null,"津波波力の算定 (pp.104-108)"]
[null,null,"[使用方法]"]
[null,null,"・ 黄色のセルに算定条件を入力すると、波圧および波圧合力等が算定されます。"]
[null,null,"・ 緑色のセルは補正係数です。必要に応じて変更してください。"]
[]
[]
[null,null,"谷本式による津波波力の算定 (pp.105-106、式 2-5-1、式 2-5-2、式2-5-3)"]
[]
[null,null,null,"h (m)","T/2 (s)","aI (m)","h' (m)","hc (m)","B (m)","ρ0 (t/m3)"]
[null,null,null,10,120,3,4.5,5,11,1.03]
[]
[null,null,null,"L (m)","h/L"]
[null,null,null,{"$f":"ROUND((9.81*D11)^0.5*E11*2,2)","v":2377.09},{"$f":"ROUND(D11/D14,4)","v":4.1999999999999997E-3}]
[]
[null,null,null,"① h/L ＜ 0.005 の場合"]
[null,null,null,"η*","p1","p2 ※1)","pu","前面波圧合力","揚圧力合力"]
[null,null,null,null,null,null,null,"PI","PU"]
[null,null,null,"(m)","(kN/m2)","(kN/m2)","(kN/m2)","(kN/m)","(kN/m)",null,null,"η*"," ： 静水面上の波圧作用高さ (m)"]
[null,null,null,{"$f":"IF( E14<0.005, ROUND(3*F11,3), \"-\" )","v":9},{"$f":"IF( E14<0.005, ROUND(2.2*J11*9.81*F11,3), \"-\" )","v":66.688000000000002},{"$f":"IF( E14<0.005, ROUND(E20*(D20-MIN(D20,H11))/D20,3), \"-\" )","v":29.638999999999999},{"$f":"IF( E14<0.005, ROUND(E20,3), \"-\" )","v":66.688000000000002},{"$f":"IF( E14<0.005, ROUND((E20+F20)*MIN(D20,H11)/2+(E20*G11),3), \"-\" )","v":540.91399999999999},{"$f":"IF( E14<0.005, ROUND(G20*I11/2,3), \"-\" )","v":366.78399999999999},null,null,"aI"," ： 進行波としての津波高さ (m)"]
[null,null,null,null,null,null,null,null,null,null,null,"h"," ： 堤体の前面における水深 (m)"]
[null,null,null,"② h/L ≧ 0.005 の場合",null,null,null,null,null,null,null,"h'"," ： 堤体の底面の水深 (m)"]
[null,null,null,"　（ソリトン分裂が発生し分裂波による波圧の増加が考えられるような条件下）",null,null,null,null,null,null,null,"hc"," ： 静水面上天端高 (m)"]
[null,null,null,"η*","p1","p2 ※1)","pu","前面波圧合力","揚圧力合力",null,null,"p1"," ： 静水面における波圧強度 (kN/m2)"]
[null,null,null,null,null,null,null,"PI","PU",null,null,"p2"," ： 堤体上端部における波圧強度 (kN/m2)"]
[null,null,null,"(m)","(kN/m2)","(kN/m2)","(kN/m2)","(kN/m)","(kN/m)",null,null,"pu"," ： 前面下端における揚圧力強度 (kN/m2)"]
[null,null,null,{"$f":"IF( E14>=0.005, ROUND(3*F11,3), \"-\" )","v":"-"},{"$f":"IF( E14>=0.005, ROUND(3*J11*9.81*F11,3), \"-\" )","v":"-"},{"$f":"IF( E14>=0.005, ROUND(E27*(D27-MIN(D27,H11))/D27,3), \"-\" )","v":"-"},{"$f":"IF( E14>=0.005, ROUND(E27,3), \"-\" )","v":"-"},{"$f":"IF( E14>=0.005, ROUND((E27+F27)*MIN(D27,H11)/2+(E27*G11),3), \"-\" )","v":"-"},{"$f":"IF( E14>=0.005, ROUND(G27*I11/2,3), \"-\" )","v":"-"},null,null,"B"," ： 堤体幅 (m)"]
[null,null,null,null,null,null,null,null,null,null,null,"ρ0"," ： 海水の密度 (通常は1.03t/m3)"]
[null,null,null,"※1) 堤体上端部における波圧強度 p2 は次式で算定した。",null,null,null,null,null,null,null,"L"," ： 波長 (m) "]
[null,null,null,null,null,null,null,null,null,null,null,"T/2"," ： 半周期 (s)　※）"]
[null,null,null,null,null,null,null,null,null,null,null,"※）　【参照】 「平成 23 年東日本大震災を踏まえた漁港施設の\n                 地震・津波対策の基本的な考え方」\n                 （平成26年1月23日）　水産庁"]
[]
[]
[]
[]
[]
[null,null,"水工研式による津波波力の算定 (pp.106-108、式 2-5-4、式 2-5-5、式2-5-6、式2-5-7)"]
[]
[null,null,null,"η (m)","ηB (m)","h' (m)","hc (m)","B (m)","ρ0 (t/m3)"]
[null,null,null,6,5,4.5,4.5,11,1.03]
[]
[null,null,null,"a1","aB"]
[null,null,null,1.1000000000000001,0.9]
[]
[null,null,null,"越流判定：",{"$f":"IF( D40>G40, \"越流\", \"非越流\" )","v":"越流"}]
[null,null,null,"p1","p2","p3","p4","前面波圧合力","後面波圧合力","揚圧力合力"]
[null,null,null,null,null,null,null,"PI","PB","PU"]
[null,null,null,"(kN/m2)","(kN/m2)","(kN/m2)","(kN/m2)","(kN/m)","(kN/m)","(kN/m)"]
[null,null,null,{"$f":"ROUND(I40*9.81*(F40+D40)*D43,3)","v":116.705},{"$f":"IF( E45=\"越流\", ROUND(D49*(D40-MIN(D40,G40))/(F40+D40),3), IF( E45=\"非越流\", 0, \"\" ) )","v":16.672000000000001},{"$f":"ROUND(I40*9.81*(F40+E40)*E43,3)","v":86.391999999999996},{"$f":"IF( E45=\"越流\", ROUND(F49*(E40-MIN(E40,G40))/(F40+E40),3), IF( E45=\"非越流\", 0, \"\" ) )","v":4.5469999999999997},{"$f":"ROUND(0.5*(D49+E49)*(F40+MIN(D40,G40)),3)","v":600.197},{"$f":"ROUND(0.5*(F49+G49)*(F40+MIN(E40,G40)),3)","v":409.226},{"$f":"ROUND(0.5*(D49+F49)*H40-0.5*(E49+G49)*H40,3)","v":1000.329}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"η"," ： 静水面上の前面の津波高さ (m)"]
[null,null,null,null,null,null,null,null,null,null,null,"ηB"," ： 静水面上の背面の津波高さ (m)"]
[null,null,null,null,null,null,null,null,null,null,null,"h'"," ： 堤体の前面における水深 (m)"]
[null,null,null,null,null,null,null,null,null,null,null,"ρ0"," ： 海水の密度 (t/m3)"]
[null,null,null,null,null,null,null,null,null,null,null,"p1"," ： 堤体下端部における前面波圧強度 (kN/m2)"]
[null,null,null,null,null,null,null,null,null,null,null,"p2"," ： 堤体上端部における前面波圧強度 (kN/m2)"]
[null,null,null,null,null,null,null,null,null,null,null,"p3"," ： 堤体下端部における背面波圧強度 (kN/m2)"]
[null,null,null,null,null,null,null,null,null,null,null,"p4"," ： 堤体上端部における背面波圧強度 (kN/m2)"]
[null,null,null,null,null,null,null,null,null,null,null,"B"," ： 堤体幅 (m)"]
[null,null,null,null,null,null,null,null,null,null,null,"hc"," ： 堤体の静水面上の高さ (m)"]
[null,null,null,null,null,null,null,null,null,null,null,"a1"," ： 前面の静水圧補正係数"]
[null,null,null,null,null,null,null,null,null,null,null,"aB"," ： 背面の静水圧補正係数"]

{"sheet":"5.3 被覆石及びブロックの所要質量","index":2,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,1,1,9],[7,2,7,7],[8,3,8,7],[21,2,21,6],[2,2,2,8],[3,2,3,8],[4,2,4,8],[17,3,18,7],[41,11,41,15],[40,11,40,15],[39,11,39,15],[38,11,38,15],[36,11,36,15],[29,3,29,8],[22,3,22,6],[9,3,9,8],[13,3,13,8],[37,11,37,15],[35,11,35,15],[14,11,14,15],[12,11,12,15],[13,11,13,15],[34,11,34,15],[33,11,33,15],[32,11,32,15],[17,11,17,15],[18,11,18,15],[16,11,16,15],[15,11,15,15]]}
[]
[null,"津波の流れの作用に対する被覆石及びブロックの所要質量の算定 (pp.108-110)"]
[null,null,"[使用方法]"]
[null,null,"・ 黄色のセルに算定条件を入力すると、安定質量等が算定されます。"]
[null,null,"・ 緑色のセルは定数です。必要に応じて変更してください。"]
[]
[]
[null,null,"非越流時"]
[null,null,null,"イスバッシュ式 (式 2-5-8)"]
[null,null,null,"①斜面の傾斜角θ（°）を用いる場合"]
[null,null,null,"ρr (t/m3)","U (m/s)","Sr","θ (°) ※1）","y","M (t)"]
[null,null,null,2.2999999999999998,3,2.2999999999999998,30,1.08,{"$f":"ROUND(PI()*D12*E12^6/(48*9.81^3*H12^6*((F12-1)^3)*(COS(RADIANS(G12))-SIN(RADIANS(G12)))^3),3)","v":0.68}]
[null,null,null,null,null,null,null,null,null,null,"M"," ： 安定質量 (t)"]
[null,null,null,"②斜面の法勾配1：nを用いる場合",null,null,null,null,null,null,"ρr"," ： 捨石等の密度 (t/m3)"]
[null,null,null,"ρr (t/m3)","U (m/s)","Sr","n ※1）","y","M (t)",null,"U"," ： 捨石等の上面における水の流れの速度 (m/s)"]
[null,null,null,2.2999999999999998,3,2.2999999999999998,{"$f":"SQRT(3)","v":1.7320508075688772},1.08,{"$f":"ROUND(PI()*D16*E16^6/(48*9.81^3*H16^6*((F16-1)^3)*(COS(ATAN(1/G16))-SIN(ATAN(1/G16)))^3),3)","v":0.68},null,"y"," ： イスバッシュの定数"]
[null,null,null,null,null,null,null,null,null,null,"Sr"," ： 捨石等の海水に対する比重"]
[null,null,null,"※1）　適用できる捨石法面の角度は、θ=45°よりも緩い場合\n      （法勾配 1：1.0 よりも緩い勾配）に限られる。",null,null,null,null,null,null,"θ"," ： 流れ方向の捨石等の斜面の傾斜角 (°)"]
[null,null,null,null,null,null,null,null,null,null,"n"," ： 法勾配 1：n"]
[]
[]
[null,null,"越流時"]
[null,null,null,"三井らによる安定数 (式 2-5-9)"]
[null,null,null,"h1 (m)","ρr (t/m3)","Sr","N"]
[null,null,null,2,2.2999999999999998,2.2999999999999998,0.6]
[]
[null,null,null,"Dn (m)","V (m3) ※2)","M (t) ※2)"]
[null,null,null,{"$f":"ROUND(D25/(F25-1)/G25,3)","v":2.5640000000000001},{"$f":"ROUND(D28^3,3)","v":16.856000000000002},{"$f":"ROUND(E25*D25^3/(G25^3*(F25-1)^3),3)","v":38.773000000000003}]
[]
[null,null,null,"※2）　ブロック体積Vおよび安定質量Mは次式で算定した。"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"N"," ： 安定数"]
[null,null,null,null,null,null,null,null,null,null,"h1"," ： 越流水深 (m)"]
[null,null,null,null,null,null,null,null,null,null,"ρr"," ： ブロック等の密度 (t/m3)"]
[null,null,null,null,null,null,null,null,null,null,"Sr"," ： コンクリートの海水に対する比重"]
[null,null,null,null,null,null,null,null,null,null,"V"," ： ブロック体積 (m3)"]
[null,null,null,null,null,null,null,null,null,null,"Dn"," ： ブロック代表長さ (m)　( = ブロック体積Vの3乗根 )"]
[null,null,null,null,null,null,null,null,null,null,"H"," ： 被覆材天端上堤体高"]
[null,null,null,null,null,null,null,null,null,null,"d"," ： 被覆材天端上水深"]
[null,null,null,null,null,null,null,null,null,null,"B"," ： 港内側マウンド天端幅"]
[null,null,null,null,null,null,null,null,null,null,"L"," ： 打ち込み位置の堤体からの距離"]

{"sheet":"5.4 上部工に作用する波圧","index":3,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,12,52,16],[1,1,1,9],[7,2,7,7],[30,2,30,7],[31,2,31,7],[42,2,42,7],[46,5,46,6],[48,12,48,16],[49,12,49,16],[50,12,50,16],[45,12,45,16],[51,12,51,16],[23,12,23,16],[24,12,24,16],[47,3,48,3],[47,6,48,6],[47,5,49,5],[43,12,43,16],[44,12,44,16],[46,12,46,16],[47,12,47,16],[35,4,36,4],[35,3,36,3],[27,12,27,16],[26,12,26,16],[25,12,25,16],[18,12,18,16],[19,12,19,16],[20,12,20,16],[21,12,21,16],[22,12,22,16],[2,2,2,8],[11,7,12,7],[11,6,12,6],[11,5,12,5],[11,4,12,4],[11,3,12,3],[3,2,3,9],[4,2,4,9]]}
[]
[null,"直立消波ブロック式係船岸における上部工に作用する波圧の算定 (pp.110-112)"]
[null,null,"[使用方法]"]
[null,null,"・ 黄色のセルに算定条件を入力すると、波圧および波圧合力等が算定されます。"]
[null,null,"・ 緑色のセルは係数です。必要に応じて変更してください。"]
[]
[]
[null,null,"①非越流時 (式 2-5-10 ～ 式 2-5-15)"]
[null,null,null,"aI (m)","hc (m)","ℓ (m)","B (m)","ρ0 (t/m3)"]
[null,null,null,1,0.3,0.2,4.5,1.03]
[]
[null,null,null,"η*","p1","p2","p3","pu","前面波圧合力","揚圧力合力"]
[null,null,null,null,null,null,null,null,"PI","PU"]
[null,null,null,"(m)","(kN/m2)","(kN/m2)","(kN/m2)","(kN/m2)","(kN/m)","(kN/m)"]
[null,null,null,{"$f":"ROUND(3*D10,3)","v":3},{"$f":"ROUND(2.2*H10*9.81*D10,3)","v":22.228999999999999},{"$f":"ROUND((1-MIN(E10,D15)/D15)*E15,3)","v":20.006},{"$f":"ROUND(E15+H10*9.81*F10,3)","v":24.25},{"$f":"ROUND(G15,3)","v":24.25},{"$f":"ROUND((E15+G15)*F10/2+(E15+F15)*MIN(D15,E10)/2,3)","v":10.983000000000001},{"$f":"ROUND(H15*G10,3)","v":109.125}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"aI"," ： 進行波としての津波高さ (m)"]
[null,null,null,null,null,null,null,null,null,null,null,"hc"," ： 静水面上天端高 (m)"]
[null,null,null,null,null,null,null,null,null,null,null,"ℓ"," ： 上部工の底面の水深 (m)"]
[null,null,null,null,null,null,null,null,null,null,null,"B"," ： 上部工の幅 (m)"]
[null,null,null,null,null,null,null,null,null,null,null,"ρ0"," ： 海水の密度 (通常は1.03t/m3)"]
[null,null,null,null,null,null,null,null,null,null,null,"η*"," ： 静水面上の波圧作用高さ (m)"]
[null,null,null,null,null,null,null,null,null,null,null,"p1"," ： 静水面における波圧強度 (kN/m2)"]
[null,null,null,null,null,null,null,null,null,null,null,"p2"," ： 上部工上端部における波圧強度 (kN/m2)"]
[null,null,null,null,null,null,null,null,null,null,null,"p3"," ： 上部工下端部における波圧強度 (kN/m2)"]
[null,null,null,null,null,null,null,null,null,null,null,"pu"," ： 上部工下面に作用する揚圧力 (kN/m2)"]
[]
[]
[null,null,"②越流時"]
[null,null,"　上部工の前面波圧分布（水工研式より算定）"]
[null,null,null,"η (m)","ℓ (m)","hc (m)","ρ0 (t/m3)","a1"]
[null,null,null,2,0.5,0.3,1.03,1.1000000000000001]
[]
[null,null,null,"p1","p2","前面波圧合力"]
[null,null,null,null,null,"PI"]
[null,null,null,"(kN/m2)","(kN/m2)","(kN/m)"]
[null,null,null,{"$f":"ROUND(G34*9.81*(D34+E34-F34)*H34,3)","v":24.452000000000002},{"$f":"ROUND(G34*9.81*(D34-F34)*H34,3)","v":18.895},{"$f":"ROUND(0.5*(D39+E39)*E34,3)","v":10.837}]
[]
[]
[]
[null,null,"　上部工下面に作用する揚圧力 (式 2-5-16、式2-5-17)"]
[null,null,null,"U (m/s)","B (m)","ρ0 (t/m3)","CL",null,null,null,null,"η"," ： 静水面上の前面の津波高さ (m)"]
[null,null,null,3,4.5,1.03,2.4,null,null,null,null,"ℓ"," ：上部工の高さ (m)"]
[null,null,null,null,null,null,null,null,null,null,null,"B"," ： 上部工の幅 (m)"]
[null,null,null,null,null,"※矩形上部工の場合",null,null,null,null,null,"ρ0"," ： 海水の密度 (t/m3)"]
[null,null,null,"浮力除く\n揚圧力合力",null,"浮力","浮力含む\n揚圧力合力",null,null,null,null,"p1"," ： 堤体下端部における前面波圧強度 (kN/m2)"]
[null,null,null,null,null,null,null,null,null,null,null,"p2"," ： 堤体上端部における前面波圧強度 (kN/m2)"]
[null,null,null,"PU",null,null,"PU",null,null,null,null,"pu"," ： 上部工下面に作用する揚力 (kN/m2)"]
[null,null,null,"(kN/m)",null,"(kN/m)","(kN/m)",null,null,null,null,"U"," ： 上部工上の流速 (m/s)"]
[null,null,null,{"$f":"ROUND(E45*G45*0.5*F45*D45^2,3)","v":50.058},null,{"$f":"ROUND(E45*F45*9.81*E34,3)","v":22.734999999999999},{"$f":"ROUND(D52+F52,3)","v":72.793000000000006},null,null,null,null,"a1"," ： 前面の静水圧補正係数"]
[null,null,null,null,null,null,null,null,null,null,null,"CL"," ： 揚力係数"]