{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["jikkou","kouzoukeisan","colliding_force（車両）","colliding_force（船舶）","collision_energy (池野式)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"jikkou","index":0,"n_rows":49,"n_cols":35,"rows_kept":49,"cut":false,"hidden":false,"merged":[[4,13,5,19],[13,11,13,13],[13,14,13,15],[13,16,13,18],[39,15,39,17],[16,34,16,35],[27,11,27,13],[27,14,27,15],[27,16,27,18],[26,21,27,26],[8,29,8,30],[8,31,8,33],[19,32,19,33],[19,34,19,36],[12,11,12,13],[12,14,12,15],[12,16,12,18],[18,1,18,19],[10,14,10,18],[14,32,14,33],[14,34,14,36],[15,32,15,33],[15,34,15,36],[13,2,13,4],[9,2,9,4],[9,5,9,6],[9,7,9,9],[10,2,10,4],[10,5,10,6],[10,7,10,9],[24,23,24,26],[14,2,14,4],[14,5,14,6],[14,7,14,9],[9,11,9,13],[9,14,9,15],[9,16,9,18],[38,13,38,14],[38,15,38,17],[12,2,12,4],[12,5,12,6],[42,13,42,14],[42,15,42,17],[26,9,26,12],[13,5,13,6],[13,7,13,9],[11,2,11,4],[11,5,11,6],[11,7,11,9],[25,9,25,12],[25,13,25,15],[24,15,24,17],[14,11,14,13],[14,14,14,15],[14,16,14,18],[12,7,12,9],[23,1,23,19],[19,2,22,18],[24,13,24,14],[47,28,47,30],[43,15,43,16],[43,17,43,19],[45,23,45,25],[45,26,45,27],[16,30,16,33],[44,15,44,17],[41,13,41,15],[46,13,46,14],[46,15,46,17],[24,27,24,28],[45,28,45,30],[46,27,46,28],[46,29,46,31],[26,13,26,15],[35,23,35,26],[35,27,35,28],[37,1,37,19],[32,23,32,24],[32,25,32,27],[31,23,31,24],[31,25,31,27],[40,9,40,12],[40,13,40,15],[38,25,38,27],[60,1,60,3],[47,23,47,25],[60,4,60,5],[60,6,60,8],[47,26,47,27],[43,23,43,26],[54,1,54,3],[54,4,54,5],[54,6,54,8],[45,13,45,14],[45,15,45,17],[53,1,53,3],[53,4,53,5],[53,6,53,8],[58,11,58,13],[58,14,58,15],[58,16,58,18],[55,4,55,5],[55,6,55,8],[49,4,49,5],[49,6,49,8],[44,10,44,12],[42,10,42,12],[46,10,46,12],[0,21,1,26],[43,27,43,28],[59,4,59,5],[59,6,59,8],[59,14,59,15],[59,16,59,18],[0,0,0,20],[7,1,7,19],[48,23,48,25],[48,26,48,27],[48,28,48,30],[24,9,24,12],[38,9,38,12],[6,1,6,19],[31,1,31,19],[28,13,30,19],[32,2,36,18],[16,13,17,19],[41,9,41,12],[44,13,44,14],[33,23,33,24],[33,25,33,27],[38,23,38,24]]}
["■試行錯誤法による中間支柱（単杭）の検討実行フロー",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STEP-1"]
[]
[]
[]
[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,"Fmax＝",null,{"$f":"kouzoukeisan!H81","v":113.38573888229747}]
[null,null,"杭の材質",null,null,"ＳＴＫ",null,400,null,null,null,"横地盤反力係数",null,null,"kh＝",null,30000]
[null,null,"ヤング率",null,null,"Ｅ＝",null,200000000,null,null,null,null,null,null,"（※N値15相当の砂地盤）"]
[null,null,"管径",null,null,"Ｄ＝",null,406.4,null,null,null,"③津波の諸元（漂流物のエネルギー）"]
[null,null,"肉厚",null,null,"ｔ＝",null,8,null,null,null,"衝突エネルギー",null,null,"Ｅｄ＝",null,0.66800000000000004]
[null,null,"腐食代",null,null,"⊿ｔ＝",null,3,null,null,null,"衝突力",null,null,"F1＝",null,1.423]
[null,null,"衝突力の負担本数",null,null,"n＝",null,2,null,null,null,"衝突位置",null,null,"ｈ＝",null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ｍmax＝",null,{"$f":"kouzoukeisan!H93","v":252.00700000000001}]
[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,{"$f":"kouzoukeisan!H77","v":254.536}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"計算条件を入力したらSTEP-1へ進む！",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ＭＲ／Ｍmax＝",null,null,null,{"$f":"kouzoukeisan!H100","v":1.01}]
[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,{"$f":"IF(AI17>=1,\"≧1.0・・・OK!\",\"＜1.0・・・NG!\")","v":"≧1.0・・・OK!"}]
[null,"STEP-1：部材の確定"]
[null,null,"　漂流物の衝突エネルギーを吸収できる杭の諸元を確定する。\n　杭に発生する曲げ応力が杭の曲げ耐力に等しくなるような反力Fmaxを求め、この反力が作用するときの杭の吸収エネルギーが衝突エネルギーを上回ることを確認して杭の断面諸元を決定する。",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,{"$f":"kouzoukeisan!H119","v":9.298}]
[]
[]
[]
[null,"↓　上記①②③の条件を入力したら下のボタンをクリックする。"]
[null,null,null,null,null,null,null,null,null,"衝突荷重",null,null,null,"Fmax＝",null,{"$f":"kouzoukeisan!H81","v":113.38573888229747},null,null,null,null,null,null,null,"Ｅｎ／Ｅｄ＝",null,null,null,{"$f":"kouzoukeisan!H129","v":13.919}]
[null,null,null,null,null,null,null,null,null,"ＭＲ／Ｍmax＝",null,null,null,{"$f":"kouzoukeisan!H100","v":1.01},null,null,{"$f":"IF(N26>=1,\"≧1.0・・・OK!\",\"＜1.0・・・NG!\")","v":"≧1.0・・・OK!"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AB25>=1,\"≧1.0・・・OK!\",\"＜1.0・・・NG!\")","v":"≧1.0・・・OK!"}]
[null,null,null,null,null,null,null,null,null,"Ｅｎ／Ｅｄ＝",null,null,null,{"$f":"kouzoukeisan!H129","v":13.919},null,null,{"$f":"IF(N27>=1,\"≧1.0・・・OK!\",\"＜1.0・・・NG!\")","v":"≧1.0・・・OK!"},null,null,null,null,"STEP-2"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N26>=1,IF(N27>=1,\"STEP-1の所要を満足したのでSTEP-2へ進む！\",\"※反力F作用時の吸収エネルギーが衝突エネルギーを下回るので、計算条件を入力し直すこと！\"),\"\")","v":"STEP-1の所要を満足したのでSTEP-2へ進む！"}]
[]
[]
[null,"STEP-2：作用荷重の決定、杭の挙動解析（発生応力、所要根入れ長）",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F＝",null,{"$f":"kouzoukeisan!H140","v":30.697100472440678}]
[null,null,"　STEP-1で確定した断面諸元を有する杭部材に漂流物が衝突した場合の挙動を解析する。\n　杭が吸収するエネルギーが衝突エネルギーに等しくなるような衝突力Fを求める。この衝突力が作用するときの杭の断面応力及び所要根入れ長を計算するとともに、杭の吸収エネルギーが衝突エネルギーに等しいことを説明する。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ｍmax＝",null,{"$f":"kouzoukeisan!H151","v":68.225999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ＭＲ＝",null,{"$f":"kouzoukeisan!H77","v":254.536}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ＭＲ／Ｍmax＝",null,null,null,{"$f":"kouzoukeisan!H158","v":3.73}]
[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,{"$f":"IF(AB36>=1,\"≧1.0・・・OK!\",\"＜1.0・・・NG!\")","v":"≧1.0・・・OK!"}]
[null,"↓　STEP-1の所要を満足したら下のボタンをクリックする。"]
[null,null,null,null,null,null,null,null,null,"衝突荷重",null,null,null,"F＝",null,{"$f":"kouzoukeisan!H140","v":30.697100472440678},null,null,null,null,null,null,null,"Ｅｎ＝",null,{"$f":"kouzoukeisan!H190","v":0.67500000000000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P39<=P40,\"＜\",\"≧\")","v":"≧"},{"$f":"Q14","v":1.423},null,null,"=F1"]
[null,null,null,null,null,null,null,null,null,"ＭＲ／Ｍmax＝",null,null,null,{"$f":"kouzoukeisan!H158","v":3.73},null,null,{"$f":"IF(N41>=1,\"≧1.0・・・OK!\",\"＜1.0・・・NG!\")","v":"≧1.0・・・OK!"}]
[null,null,null,null,null,null,null,null,null,"Ｅｎ／Ｅｄ＝",null,null,null,{"$f":"kouzoukeisan!H193","v":1.01},null,null,{"$f":"IF(N42>=1,\"≧1.0・・・OK!\",\"＜1.0・・・NG!\")","v":"≧1.0・・・OK!"}]
[null,null,null,null,null,null,null,null,null,null,"頭部変形",null,null,"ｙｔｏｐ＝",null,{"$f":"kouzoukeisan!H171","v":2.1999999999999999E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P43<=R44,\"≦δ15＝\",\"＞δ15＝\")","v":"≦δ15＝"},null,{"$f":"kouzoukeisan!H175","v":1.0209999999999999},null,null,null,null,null,"Ｅｎ／Ｅｄ＝",null,null,null,{"$f":"kouzoukeisan!H193","v":1.01},null,{"$f":"IF(AB44>=1,\"≧1.0・・・OK!\",\"＜1.0・・・NG!\")","v":"≧1.0・・・OK!"}]
[null,null,null,null,null,null,null,null,null,null,"発生応力",null,null,"Ｍmax＝",null,{"$f":"kouzoukeisan!H151","v":68.225999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"σmax＝",null,{"$f":"kouzoukeisan!H155","v":112770.24800000001},null,null,null,null,null,null,null,"頭部変形",null,null,"ｙｔｏｐ＝",null,{"$f":"kouzoukeisan!H171","v":2.1999999999999999E-2}]
[null,null,null,null,null,null,null,null,null,null,"所要根入れ長",null,null,"ｌｍ１＝",null,{"$f":"kouzoukeisan!H203","v":5.0599999999999996},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC46<=AD47,\"≦δ15＝\",\"＞δ15＝\")","v":"≦δ15＝"},null,{"$f":"kouzoukeisan!H175","v":1.0209999999999999}]
[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,{"$f":"kouzoukeisan!H203","v":5.0599999999999996}]
[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,"σmax＝",null,{"$f":"kouzoukeisan!H155","v":112770.24800000001}]

{"sheet":"kouzoukeisan","index":1,"n_rows":203,"n_cols":22,"rows_kept":203,"cut":false,"hidden":false,"merged":[[183,7,183,8],[183,10,183,11],[183,5,183,6],[183,13,183,14],[184,2,184,19],[182,2,182,4],[178,9,179,9],[178,10,178,11],[179,10,179,11],[178,12,179,13],[178,15,178,16],[178,18,178,19],[179,15,179,16],[179,18,179,19],[180,10,180,11],[173,8,173,9],[173,11,173,12],[173,14,173,15],[174,7,174,8],[176,5,177,9],[176,11,177,12],[176,13,176,15],[177,13,177,15],[23,11,23,12],[24,11,24,12],[25,11,25,12],[114,9,114,10],[118,9,118,10],[125,9,125,10],[128,7,128,8],[31,11,31,12],[35,11,35,12],[34,11,34,12],[70,9,70,10],[73,9,73,10],[76,9,76,10],[80,9,80,10],[96,9,96,10],[80,7,80,8],[69,7,69,8],[70,7,70,8],[86,8,86,9],[100,2,101,19],[12,11,12,12],[13,11,13,12],[15,11,15,12],[16,11,16,12],[17,11,17,12],[18,11,18,12],[19,11,19,12],[20,11,20,12],[22,11,22,12],[15,7,15,8],[16,7,16,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[17,7,17,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[17,2,18,4],[6,14,6,15],[7,14,7,15],[8,14,8,15],[5,11,5,12],[6,11,6,12],[7,11,7,12],[8,11,8,12],[10,11,10,12],[11,11,11,12],[11,13,11,14],[8,2,8,4],[7,2,7,4],[6,2,6,4],[5,2,5,4],[4,2,4,4],[4,7,4,8],[5,7,5,8],[6,7,6,8],[7,7,7,8],[8,7,8,8],[10,2,10,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[10,7,10,8],[11,7,11,8],[12,7,12,8],[13,7,13,8],[15,2,15,6],[19,2,19,4],[20,2,20,4],[198,2,198,4],[116,5,116,6],[67,2,67,4],[71,2,71,4],[27,7,27,8],[28,7,28,8],[67,5,67,6],[71,5,71,6],[34,7,34,8],[35,7,35,8],[62,1,65,19],[67,7,67,8],[68,7,68,8],[68,10,68,11],[68,13,68,14],[69,9,69,10],[98,3,98,6],[87,11,87,12],[171,3,171,20],[34,2,34,4],[35,2,35,4],[25,9,25,10],[27,9,27,10],[157,7,157,8],[28,9,28,10],[31,9,31,10],[31,2,31,4],[31,7,31,8],[143,13,143,20],[144,7,145,7],[144,8,144,9],[144,10,144,11],[144,13,144,14],[144,15,144,16],[145,11,145,12],[145,14,145,15],[156,3,156,6],[156,7,156,8],[94,7,94,8],[95,7,95,8],[34,9,34,10],[35,9,35,10],[73,7,73,8],[76,7,76,8],[72,10,72,11],[74,7,74,8],[192,7,192,8],[133,1,136,19],[92,7,92,8],[114,7,114,8],[118,7,118,8],[125,7,125,8],[139,7,139,8],[79,2,79,19],[81,2,81,19],[85,13,85,20],[86,5,87,6],[86,7,87,7],[140,3,140,20],[141,2,141,4],[172,5,172,6],[141,7,142,7],[141,8,141,10],[141,11,142,12],[141,13,142,14],[141,15,141,16],[141,17,142,19],[142,8,142,10],[154,7,154,8],[142,15,142,16],[15,9,15,10],[16,9,16,10],[17,9,17,10],[18,9,18,10],[19,9,19,10],[20,9,20,10],[22,9,22,10],[23,9,23,10],[24,9,24,10],[75,7,75,8],[75,10,75,11],[71,7,71,8],[72,7,72,8],[80,2,80,4],[80,5,80,6],[74,5,74,6],[82,3,82,20],[112,6,113,6],[112,7,112,8],[112,9,112,10],[112,12,112,13],[112,14,112,15],[113,12,113,13],[113,9,113,10],[112,16,113,16],[104,2,105,19],[109,7,109,10],[110,7,110,10],[87,14,87,15],[88,7,89,8],[88,9,89,10],[89,13,89,14],[95,10,95,11],[4,9,4,10],[5,9,5,10],[6,9,6,10],[7,9,7,10],[8,9,8,10],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[202,9,202,10],[202,7,202,8],[83,7,84,7],[83,8,83,10],[83,15,83,16],[84,8,84,10],[84,15,84,16],[83,11,84,12],[83,13,84,14],[86,13,86,14],[86,15,86,16],[123,14,123,15],[124,13,124,14],[124,16,124,17],[121,12,122,13],[147,13,147,14],[147,16,147,17],[148,7,149,7],[148,8,149,9],[148,10,149,10],[148,11,149,12],[129,2,130,19],[150,9,150,10],[151,3,151,20],[170,7,170,8],[189,7,189,8],[92,9,92,10],[99,7,99,8],[121,2,121,4],[94,5,94,6],[96,7,96,8],[86,10,86,11],[121,9,121,11],[123,6,124,6],[123,7,124,8],[123,9,124,9],[124,10,124,11],[152,5,152,6],[152,7,152,8],[153,7,153,8],[153,10,153,11],[154,9,154,10],[146,7,147,8],[146,9,147,10],[146,11,146,17],[147,11,147,12],[155,2,155,19],[141,5,142,6],[99,9,99,19],[97,2,97,19],[90,11,91,12],[83,17,84,19],[83,5,84,6],[89,16,89,17],[89,11,89,12],[88,11,88,17],[90,7,91,7],[83,2,83,4],[93,3,93,20],[117,13,117,14],[119,2,119,19],[120,3,120,20],[121,5,122,6],[121,7,122,8],[122,9,122,11],[112,17,113,18],[111,13,111,20],[106,2,107,19],[115,3,115,20],[108,3,108,20],[109,5,110,6],[139,9,139,10],[164,3,164,20],[165,5,166,6],[165,7,165,10],[165,11,166,11],[166,7,166,10],[167,13,167,20],[168,6,169,6],[168,7,168,8],[168,9,168,10],[168,12,168,13],[168,14,168,15],[168,16,169,16],[168,17,169,18],[150,7,150,8],[29,9,29,10],[188,8,188,9],[126,2,126,19],[127,7,127,8],[98,7,98,8],[98,10,98,11],[90,8,91,9],[90,10,91,10],[127,10,127,11],[128,9,128,19],[127,2,127,6],[123,19,124,20],[117,8,117,9],[117,10,117,11],[170,9,170,10],[186,3,186,20],[187,5,187,6],[188,13,188,14],[156,10,156,11],[157,9,157,19],[158,2,159,19],[138,2,138,19],[139,2,139,4],[139,5,139,6],[188,10,188,11],[189,9,189,10],[169,9,169,10],[169,12,169,13],[12,13,13,20],[200,6,201,6],[200,7,200,8],[201,7,201,8],[144,6,145,6],[109,11,110,12],[38,5,38,6],[59,0,59,20],[192,9,192,19],[193,2,194,19],[162,2,163,19],[197,2,197,19],[198,5,199,6],[198,7,198,8],[199,7,199,8],[190,2,190,19],[191,2,191,6],[191,7,191,8],[191,10,191,11],[29,11,29,12]]}
["中間支柱の構造計算（頭部自由杭の計算）"]
["■計算条件"]
[null,"①杭基礎部材の条件"]
[null,"・杭の規格及び形状"]
[null,null,"杭の材質",null,null,null,null,"ＳＴＫ",null,{"$f":"jikkou!H10","v":400}]
[null,null,"ヤング率",null,null,null,null,"Ｅ＝",null,{"$f":"jikkou!H11","v":200000000},null,"kN/㎡"]
[null,null,"管径",null,null,null,null,"Ｄ＝",null,{"$f":"jikkou!H12","v":406.4},null,"mm",null,"（",{"$f":"ROUND(J7/1000,6)","v":0.40639999999999998},null,"m）"]
[null,null,"肉厚",null,null,null,null,"ｔ＝",null,{"$f":"jikkou!H13","v":8},null,"mm",null,"（",{"$f":"ROUND(J8/1000,6)","v":8.0000000000000002E-3},null,"m）"]
[null,null,"腐食代",null,null,null,null,"⊿ｔ＝",null,{"$f":"jikkou!H14","v":3},null,"mm",null,"（",{"$f":"ROUND(J9/1000,6)","v":3.0000000000000001E-3},null,"m）"]
[null,"・杭の諸元"]
[null,null,"初期断面積",null,null,null,null,"Ａ＝",null,{"$f":"ROUND(PI()/4*(O7^2-J14^2),3)","v":0.01},null,"㎡"]
[null,null,"腐食後肉厚",null,null,null,null,"tp＝",null,{"$f":"ROUND(O8-O9,3)","v":5.0000000000000001E-3},null,"m",null,"（Ｄ／tp＝",null,{"$f":"ROUND(J13/J12,1)","v":80},null,{"$f":"IF(P12>8,IF(P12<110,\"・・・8<D/tp<110より、\",\">110より、\"),\"<8より、\")","v":"・・・8<D/tp<110より、"}]
[null,null,"腐食後外径",null,null,null,null,"Ｄ＝",null,{"$f":"ROUND(O7-2*O9,3)","v":0.4},null,"m",null,{"$f":"IF(P12>8,IF(P12<110,\"鋼材の加工硬化を考慮した静的降伏応力の算定式の適用範囲であるものとして検討する。）\",\"鋼管支柱の基部に局部座屈が発生する時の塑性変形を考慮して検討する。）\"),\"鋼管支柱の基部に局部座屈が発生する時の塑性変形を考慮して検討する。）\")","v":"鋼材の加工硬化を考慮した静的降伏応力の算定式の適用範囲であるものとして検討する。）"},null,null,null,null,null,null,null,{"$f":"IF(P12>8,IF(P12<110,\"\",\"本プログラム適用範囲外！\"),\"本プログラム適用範囲外！\")","v":""}]
[null,null,"内径",null,null,null,null,"ｄ＝",null,{"$f":"ROUND(O7-2*O8,3)","v":0.39},null,"m"]
[null,"・杭の断面性能"]
[null,null,"断面二次モーメント",null,null,null,null,"Ｉo＝",null,{"$f":"ROUND(PI()*(O7^4-O8^4)/64,6)","v":1.3389999999999999E-3},null,"m4",null,"（腐食前）"]
[null,null,null,null,null,null,null,"Ｉ＝",null,{"$f":"ROUND(PI()*(J13^4-J14^4)/64,6)","v":1.21E-4},null,"m4",null,"（腐食後）"]
[null,null,"ＥＩの計算",null,null,null,null,"ＥＩo＝",null,{"$f":"ROUND(J6*J16,0)","v":267800},null,"kN・㎡",null,"（腐食前）"]
[null,null,null,null,null,null,null,"ＥＩ＝",null,{"$f":"ROUND(J6*J17,0)","v":24200},null,"kN・㎡",null,"（腐食後）"]
[null,null,"断面係数",null,null,null,null,"Ｚ＝",null,{"$f":"ROUND(J17*2/J13,6)","v":6.0499999999999996E-4},null,"m3",null,"（腐食後）"]
[null,null,"塑性断面係数",null,null,null,null,"Ｚp＝",null,{"$f":"ROUND((J13^3-J14^3)/6,6)","v":7.7999999999999999E-4},null,"m3"]
[null,"・杭・地盤の特性値"]
[null,null,"杭幅",null,null,null,null,"B＝",null,{"$f":"J13","v":0.4},null,"m"]
[null,null,null,null,null,null,null,"B・kh＝",null,{"$f":"ROUND(J32*J23,0)","v":12000},null,"kN/m3"]
[null,null,"特性値",null,null,null,null,"βo＝",null,{"$f":"ROUND((J24/4/J18)^(1/4),4)","v":0.32529999999999998},null,"m-1",null,"（腐食前）"]
[null,null,null,null,null,null,null,"β＝",null,{"$f":"ROUND((J24/4/J19)^(1/4),4)","v":0.59340000000000004},null,"m-1",null,"（腐食後）"]
[null,"・計算定数"]
[null,null,null,null,null,null,null,"材質係数：",null,{"$f":"IF(J5=400,527.5,IF(#REF!=490,703.3,\"指定ERR\"))","v":527.5}]
[null,null,null,null,null,null,null,"衝撃係数：",null,1.2,null,null,null,"（固定値）"]
[null,null,null,null,null,null,null,null,"衝突力の負担本数：",{"$f":"jikkou!H15","v":2},null,"本"]
[null,"②地盤条件"]
[null,null,"横地盤反力係数",null,null,null,null,"kh＝",null,{"$f":"jikkou!Q10","v":30000},null,"kN/m4",null,{"$f":"jikkou!O11","v":"（※N値15相当の砂地盤）"}]
[]
[null,"③津波の諸元"]
[null,null,"衝突エネルギー",null,null,null,null,"Ｅｄ＝",null,{"$f":"jikkou!Q13","v":0.66800000000000004},null,"kN・m"]
[null,null,"衝突位置",null,null,null,null,"ｈ＝",null,{"$f":"jikkou!Q15","v":2},null,"m"]
[]
[]
[null,null,null,null,null,"ytop"]
[]
[]
[]
[null,"F"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"δL"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D"]
[null,null,null,"h"]
[]
[]
[]
[]
[]
[]
[null,null,null,"lm1"]
[]
[]
[]
[]
[]
["検討モデル図"]
[]
["■STEP-1：部材の確定"]
[null,"　漂流物の衝突エネルギーを吸収できる杭の諸元を確定する。\n　杭に発生する曲げ応力が杭の曲げ耐力に等しくなるような反力Fmaxを求め、この反力が作用するときの杭の吸収エネルギーが衝突エネルギーを上回ることを確認して杭の断面諸元を決定する。"]
[]
[]
[]
[null,"・杭の降伏応力"]
[null,null,"加工硬化",null,null,"σy＝",null,{"$f":"$J$28","v":527.5},null,"×（D／tp）-0.104"]
[null,null,null,null,null,null,"＝",{"$f":"$J$28","v":527.5},null,"×（",{"$f":"$O$7","v":0.40639999999999998},null,"／",{"$f":"$O$8","v":8.0000000000000002E-3},null,"）-0.104"]
[null,null,null,null,null,null,"＝",{"$f":"ROUND($J$28*($O$7/$O$8)^-0.104,3)","v":350.601},null,"N/mm3"]
[null,null,null,null,null,null,"＝",{"$f":"ROUND(1000*$J$28*($O$7/$O$8)^-0.104,0)","v":350601},null,"kN/m3"]
[null,null,"衝撃割増",null,null,"σyd＝",null,{"$f":"$J$29","v":1.2},null,"×σy"]
[null,null,null,null,null,null,"＝",{"$f":"$J$29","v":1.2},null,"×",{"$f":"H71","v":350601}]
[null,null,null,null,null,null,"＝",{"$f":"ROUND($J$29*H71,0)","v":420721},null,"kN/m3"]
[null,null,null,null,null,"ＭＲ＝",null,"Z×σdy"]
[null,null,null,null,null,null,"＝",{"$f":"$J$20","v":6.0499999999999996E-4},null,"×",{"$f":"H74","v":420721}]
[null,null,null,null,null,null,"＝",{"$f":"ROUND($J$20*H74,3)","v":254.536},null,"kN・m"]
[]
[null,"・杭に発生する反力"]
[null,null,"　杭に発生する曲げ応力が杭の曲げ耐力に等しくなるような反力Fmaxを求める。"]
[null,null,"　ここで、",null,null,"Fmax＝",null,113.38573888229747,null,"kN",null,"と仮定する。"]
[null,null,"　これに対する杭の曲げ応力は、チャンの方法により下式を用いて算定する。"]
[null,null,null,"（杭の最大曲げモーメント）"]
[null,null,null,null,null,"Ｍmax＝",null,"－","（1+2βh）2+1",null,null,"・exp",null,"-tan-1",null,1,null,"・Fmax・h"]
[null,null,null,null,null,null,null,null,"2βh",null,null,null,null,null,null,"1+2βh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"（漁港漁場の施設の設計参考図書（2015年版）,p.266より）"]
[null,null,null,null,null,"＝",null,"－","（1+2×",null,{"$f":"$J$26","v":0.59340000000000004},null,"×",{"$f":"$J$36","v":2},null,"）2+1"]
[null,null,null,null,null,null,null,null,null,null,"2×",{"$f":"$J$26","v":0.59340000000000004},null,"×",{"$f":"$J$36","v":2}]
[null,null,null,null,null,null,null,"×exp",null,"-tan-1",null,1]
[null,null,null,null,null,null,null,null,null,null,null,"1+2×",null,{"$f":"$J$26","v":0.59340000000000004},null,"×",{"$f":"$J$36","v":2}]
[null,null,null,null,null,null,null,"×",{"$f":"H81","v":113.38573888229747},null,"×",{"$f":"$J$36","v":2}]
[]
[null,null,null,null,null,null,"＝",{"$f":"ROUND((((1+2*$J$26*$J$36)^2+1)^(1/2)/(2*$J$26*$J$36)*EXP(-ATAN(1/(1+2*$J$26*$J$36))))*H81*$J$36,3)","v":252.00700000000001},null,"kN・m"]
[null,null,null,"（杭の最大曲げ応力）"]
[null,null,null,null,null,"σmax＝",null,"Ｍmax／Z"]
[null,null,null,null,null,null,"＝",{"$f":"H93","v":252.00700000000001},null,"／",{"$f":"$J$20","v":6.0499999999999996E-4}]
[null,null,null,null,null,null,"＝",{"$f":"ROUND(H93/$J$20,3)","v":416540.49599999998},null,"kN/㎡"]
[null,null,"　ここで、"]
[null,null,null,"ＭＲ／Ｍmax＝",null,null,null,{"$f":"$H$77","v":254.536},null,"／",{"$f":"H93","v":252.00700000000001}]
[null,null,null,null,null,null,"＝",{"$f":"ROUNDDOWN($H$77/H93,3)","v":1.01},null,{"$f":"IF(H100>=1,\"≧1.0　となり、\",\"＜1.0　となり、\")","v":"≧1.0　となり、"}]
[null,null,{"$f":"IF(H100>=1,\"　杭に発生する曲げ応力が曲げ耐力に概ね等しくなるので、上記Fmax値に対する吸収エネルギーの照査を行う。\",\"　杭に発生する曲げ応力が曲げ耐力を上回るので、計算条件を再設定する必要がある。\")","v":"　杭に発生する曲げ応力が曲げ耐力に概ね等しくなるので、上記Fmax値に対する吸収エネルギーの照査を行う。"}]
[]
[]
[null,"・吸収エネルギー"]
[null,null,"　衝突エネルギーは、支柱の梁変形と衝突点の支柱断面の局部変形（凹み）で吸収するものとする。"]
[]
[null,null,"　梁変形による吸収エネルギーは、荷重Fmaxと変位量から以下のように求める。変位量は、チャンの方法による杭頭変位量の算定式から求める。"]
[]
[null,null,null,"（杭の変位量）"]
[null,null,null,null,null,"ｙｔｏｐ＝",null,"2（1＋βh）3+1",null,null,null,"・Fmax"]
[null,null,null,null,null,null,null,"6EIβ3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"（漁港漁場の施設の設計参考図書（2015年版）,p.266より）"]
[null,null,null,null,null,null,"＝","2×（1+",null,{"$f":"$J$26","v":0.59340000000000004},null,"×",{"$f":"$J$36","v":2},null,"）3+1",null,"×",{"$f":"H81","v":113.38573888229747}]
[null,null,null,null,null,null,null,null,"6×",{"$f":"$J$19","v":24200},null,"×",{"$f":"$J$26","v":0.59340000000000004},null,3]
[null,null,null,null,null,null,"＝",{"$f":"ROUND((2*(1+$J$26*$J$36)^3+1)/(6*$J$19*$J$26^3)*H81,3)","v":8.2000000000000003E-2},null,"m"]
[null,null,null,"（梁変形による吸収エネルギー）"]
[null,null,null,null,null,"Ｅｎ＝",null,"n×1/2×Po×ytop"]
[null,null,null,null,null,null,"＝",{"$f":"$J$30","v":2},"×1/2×",null,{"$f":"H81","v":113.38573888229747},null,"×",{"$f":"H115","v":8.2000000000000003E-2}]
[null,null,null,null,null,null,"＝",{"$f":"ROUND($J$30*1/2*H81*H115,3)","v":9.298},null,"kN・m"]
[null,null,"　局部変形による吸収エネルギーは、荷重Fmaxとそれに対する凹み量から求める。"]
[null,null,null,"（荷重Fmaxに対する凹み量）"]
[null,null,null,null,null,"δＬ０＝",null,"D×",null,"4Fmax",null,null,1.25]
[null,null,null,null,null,null,null,null,null,"K・σyd・tp2"]
[null,null,null,null,null,null,"＝",{"$f":"$J$13","v":0.4},null,"×",null,null,null,"4×",{"$f":"H81","v":113.38573888229747},null,null,null,null,1.25]
[null,null,null,null,null,null,null,null,null,null,185,null,"×",{"$f":"$H$74","v":420721},null,"×",{"$f":"$J$12","v":5.0000000000000001E-3},null,2]
[null,null,null,null,null,null,"＝",{"$f":"ROUND($J$13*(4*H81/185/$H$74/$J$12^2)^1.25,3)","v":6.5000000000000002E-2},null,"m",null,null,null,"（ここに、K：実験定数（=185））"]
[null,null,"　ここで、"]
[null,null,"Ｅｎ／Ｅｄ＝",null,null,null,null,{"$f":"H119","v":9.298},null,"／",{"$f":"$J$35","v":0.66800000000000004}]
[null,null,null,null,null,null,"＝",{"$f":"ROUNDDOWN(H119/$J$35,3)","v":13.919},null,{"$f":"IF(H129>=1,\"≧1.0　となり、\",\"＜1.0　となり、\")","v":"≧1.0　となり、"}]
[null,null,{"$f":"IF(H129>=1,\"　杭の吸収エネルギーが衝突エネルギーを上回るので、本条件により杭の諸元を確定する。\",\"　杭の吸収エネルギーが衝突エネルギーを下回るので、計算条件を再設定する必要がある。\")","v":"　杭の吸収エネルギーが衝突エネルギーを上回るので、本条件により杭の諸元を確定する。"}]
[]
[]
["■STEP-2：作用荷重の決定、杭の挙動解析（発生応力、所要根入れ長）"]
[null,"　STEP-1で確定した断面諸元を有する杭部材に漂流物が衝突した場合の挙動を解析する。\n　杭が吸収するエネルギーが衝突エネルギーに等しくなるような衝突力Fを求める。この衝突力が作用するときの杭の断面応力及び所要根入れ長を計算するとともに、杭の吸収エネルギーが衝突エネルギーに等しいことを説明する。"]
[]
[]
[]
[null,"・杭に発生する反力"]
[null,null,"　杭に発生する曲げ応力が杭の曲げ耐力に等しくなるような反力Fを求める。"]
[null,null,"　ここで、",null,null,"F＝",null,30.697100472440678,null,"kN",null,"と仮定する。"]
[null,null,null,"（杭の最大曲げモーメント）"]
[null,null,null,null,null,"Ｍmax＝",null,"－","（1+2βh）2+1",null,null,"・exp",null,"-tan-1",null,1,null,"・F・h"]
[null,null,null,null,null,null,null,null,"2βh",null,null,null,null,null,null,"1+2βh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"（漁港漁場の施設の設計参考図書（2015年版）,p.266より）"]
[null,null,null,null,null,null,"＝","－","（1+2×",null,{"$f":"$J$26","v":0.59340000000000004},null,"×",{"$f":"$J$36","v":2},null,"）2+1"]
[null,null,null,null,null,null,null,null,null,null,"2×",{"$f":"$J$26","v":0.59340000000000004},null,"×",{"$f":"$J$36","v":2}]
[null,null,null,null,null,null,null,"×exp",null,"-tan-1",null,1]
[null,null,null,null,null,null,null,null,null,null,null,"1+2×",null,{"$f":"$J$26","v":0.59340000000000004},null,"×",{"$f":"$J$36","v":2}]
[null,null,null,null,null,null,null,"×",{"$f":"H140","v":30.697100472440678},null,"×",{"$f":"$J$36","v":2}]
[]
[null,null,null,null,null,null,"＝",{"$f":"ROUND((((1+2*$J$26*$J$36)^2+1)^(1/2)/(2*$J$26*$J$36)*EXP(-ATAN(1/(1+2*$J$26*$J$36))))*H140*$J$36,3)","v":68.225999999999999},null,"kN・m"]
[null,null,null,"（杭の最大曲げ応力）"]
[null,null,null,null,null,"σmax＝",null,"Ｍmax／Z"]
[null,null,null,null,null,null,"＝",{"$f":"H151","v":68.225999999999999},null,"／",{"$f":"$J$20","v":6.0499999999999996E-4}]
[null,null,null,null,null,null,"＝",{"$f":"ROUND(H151/$J$20,3)","v":112770.24800000001},null,"kN/㎡"]
[null,null,"　ここで、"]
[null,null,null,"ＭＲ／Ｍmax＝",null,null,null,{"$f":"$H$77","v":254.536},null,"／",{"$f":"H151","v":68.225999999999999}]
[null,null,null,null,null,null,"＝",{"$f":"ROUNDDOWN($H$77/H151,3)","v":3.73},null,{"$f":"IF(H157>=1,\"≧1.0　となり、\",\"＜1.0　となり、\")","v":"≧1.0　となり、"}]
[null,null,{"$f":"IF(H158>=1,\"　杭の曲げ耐力が曲げ応力を上回ることを確認した。\",\"　杭に発生する曲げ応力が杭の曲げ耐力を上回るので、計算条件を再設定する必要がある。\")","v":"　杭の曲げ耐力が曲げ応力を上回ることを確認した。"}]
[]
[]
[null,"・吸収エネルギー"]
[null,null,"　梁変形による吸収エネルギーは、荷重Fと変位量から以下のように求める。変位量は、チャンの方法による杭頭変位量の算定式から求める。"]
[]
[null,null,null,"（杭の変位量）"]
[null,null,null,null,null,"ｙｔｏｐ＝",null,"2（1＋βh）3+1",null,null,null,"・F"]
[null,null,null,null,null,null,null,"6EIβ3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"（漁港漁場の施設の設計参考図書（2015年版）,p.266より）"]
[null,null,null,null,null,null,"＝","2×（1+",null,{"$f":"$J$26","v":0.59340000000000004},null,"×",{"$f":"$J$36","v":2},null,"）3+1",null,"×",{"$f":"H140","v":30.697100472440678}]
[null,null,null,null,null,null,null,null,"6×",{"$f":"$J$19","v":24200},null,"×",{"$f":"$J$26","v":0.59340000000000004},null,3]
[null,null,null,null,null,null,"＝",{"$f":"ROUND((2*(1+$J$26*$J$36)^3+1)/(6*$J$19*$J$26^3)*H140,3)","v":2.1999999999999999E-2},null,"m"]
[null,null,null,"（杭の許容変位量）"]
[null,null,null,null,null,"δ15＝",null,"（h＋ly1）×tan15°"]
[null,null,null,null,null,null,"＝","（",{"$f":"$J$36","v":2},null,"＋",{"$f":"K181","v":1.8089999999999999},null,"）×","tan15°"]
[null,null,null,null,null,null,"＝",{"$f":"ROUND(($J$36+K181)*TAN(PI()/180*15),3)","v":1.0209999999999999},null,"m"]
[null,null,null,null,null,"ここに、"]
[null,null,null,null,null,"ly1（第１不動点）＝",null,null,null,null,1,"・tan-1",null,"（1＋βh）"]
[null,null,null,null,null,null,null,null,null,null,"β",null,null,"βh"]
[null,null,null,null,null,null,null,null,null,"＝",1,null,"×tan-1",null,"（1+",{"$f":"$J$26","v":0.59340000000000004},null,"×",{"$f":"$J$36","v":2},null,"）"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"$J$26","v":0.59340000000000004},null,null,null,null,{"$f":"$J$26","v":0.59340000000000004},null,"×",{"$f":"$J$36","v":2}]
[null,null,null,null,null,null,null,null,null,"＝",{"$f":"ROUND(1/$J$26*ATAN((1+$J$26*$J$36)/($J$26*$J$36)),3)","v":1.8089999999999999},null,"m"]
[]
[null,null,"　ここで、"]
[null,null,null,null,null,"ｙｔｏｐ＝",null,{"$f":"H171","v":2.1999999999999999E-2},null,{"$f":"IF(H184<=K184,\"≦\",\"＞\")","v":"≦"},{"$f":"H175","v":1.0209999999999999},null,"＝","δ15",null,"となり、"]
[null,null,{"$f":"IF(H184<=K184,\"　杭の変位量が許容値以下となる。\",\"　杭の変位量が許容値を上回るので計算条件を再設定する必要がある。\")","v":"　杭の変位量が許容値以下となる。"}]
[]
[null,null,null,"（梁変形による吸収エネルギー）"]
[null,null,null,null,null,"Ｅｎ＝",null,"n×1/2×F×ytop"]
[null,null,null,null,null,null,"＝",{"$f":"$J$30","v":2},"×1/2×",null,{"$f":"H140","v":30.697100472440678},null,"×",{"$f":"H171","v":2.1999999999999999E-2}]
[null,null,null,null,null,null,"＝",{"$f":"ROUND($J$30*1/2*H140*H171,3)","v":0.67500000000000004},null,"kN・m"]
[null,null,"　ここで、"]
[null,null,"Ｅｎ／Ｅｄ＝",null,null,null,null,{"$f":"H190","v":0.67500000000000004},null,"／",{"$f":"$J$35","v":0.66800000000000004}]
[null,null,null,null,null,null,"＝",{"$f":"ROUNDDOWN(H190/$J$35,3)","v":1.01},null,{"$f":"IF(H193>=1,\"≧1.0　となり、\",\"＜1.0　となり、\")","v":"≧1.0　となり、"}]
[null,null,{"$f":"IF(H193>=1,\"　杭の吸収エネルギーが衝突エネルギーと概ね等しくなる。\",\"　杭の吸収エネルギーが衝突エネルギーを下回るので、計算条件を再設定する必要がある。\")","v":"　杭の吸収エネルギーが衝突エネルギーと概ね等しくなる。"}]
[]
[]
[null,"・根入れ長の決定"]
[null,null,"　杭の所要根入れ長は、チャンの式により算定する。"]
[null,null,null,null,null,"ｌｍ１＝",null,3]
[null,null,null,null,null,null,null,"β"]
[null,null,null,null,null,null,"＝",3]
[null,null,null,null,null,null,null,{"$f":"$J$26","v":0.59340000000000004}]
[null,null,null,null,null,null,"＝",{"$f":"ROUND(3/$J$26,2)","v":5.0599999999999996},null,"m"]

{"sheet":"colliding_force（車両）","index":2,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,5,35,6],[35,7,35,8],[29,1,29,19],[30,1,30,19],[31,3,32,4],[33,4,34,4],[33,5,33,6],[33,8,33,9],[34,5,34,6],[34,8,34,9],[25,5,25,6],[25,7,25,8],[26,3,26,19],[27,4,27,5],[27,6,27,10],[27,11,27,12],[22,1,22,19],[23,3,23,4],[23,5,23,19],[24,5,24,6],[24,7,24,8],[24,10,24,11],[24,13,24,14],[24,16,24,17],[19,2,19,4],[19,7,19,8],[19,9,19,10],[19,11,19,12],[10,2,10,4],[10,7,10,8],[10,9,10,10],[10,11,10,12],[14,1,16,19],[18,2,18,4],[18,7,18,8],[18,9,18,10],[18,11,18,12],[10,13,11,20],[11,2,11,4],[11,7,11,8],[11,9,11,10],[11,11,11,12],[8,2,8,4],[8,7,8,8],[8,9,8,10],[8,11,8,12],[9,2,9,4],[9,7,9,8],[9,9,9,10],[9,11,9,12],[3,1,4,19],[6,2,6,4],[6,9,6,11],[7,2,7,4],[7,7,7,8],[7,9,7,10],[7,11,7,12]]}
["漂流物（車両）の衝突エネルギーの計算"]
["■計算条件"]
[null,"①漂流物の諸元"]
[null,"　設計漂流物として、吃水が浸水深位内となる対象漂流物の中で重量が最大となる以下を用いる。"]
[]
[null,"・漂流物諸元"]
[null,null,"名称",null,null,null,null,null,null,"普通乗用車"]
[null,null,"全長",null,null,null,null,"L＝",null,5,null,"m"]
[null,null,"車幅",null,null,null,null,"B＝",null,2,null,"m"]
[null,null,"重量",null,null,null,null,"Wo＝",null,24.5,null,"kN"]
[null,null,"空荷吃水",null,null,null,null,"Do＝",null,{"$f":"ROUND((J10/10.1)/(J8*J9),2)","v":0.24},null,"m",null,"※車両の吃水＝（カタログ重量÷海水の単位体積重量）／（車両の長さ×幅）"]
[null,null,"重力加速度",null,null,null,null,"g＝",null,9.81,null,"m2/sec"]
[]
[null,"②津波の諸元"]
[null,"　津波の諸元については、津波漂流物対策施設を整備する●●漁港における当該箇所の津波シミュレーション結果から、現実的な対策レベルから大きく外れていないと推定される範囲の外力値を設定する。"]
[]
[]
[null,"・津波諸元"]
[null,null,"浸水深",null,null,null,null,"h＝",null,2,null,"m"]
[null,null,"流速",null,null,null,null,"VH＝",null,0.71,null,"m/sec"]
[]
["■衝突エネルギーの計算"]
[null,"（車両の仮想重量）"]
[null,null,null,"W＝",null,"Wo＋（π/4）Do2×L×γw"]
[null,null,null,null,"＝",{"$f":"$J$10","v":24.5},null,"＋（π/4）",null,"×",{"$f":"$J$11","v":0.24},null,"2×",{"$f":"$J$8","v":5},null,"×",10.1]
[null,null,null,null,"＝",{"$f":"ROUND($J$10+(PI()/4)*$J$11^2*$J$8*10.1,3)","v":26.785},null,"kN"]
[null,null,null,"　ここに、"]
[null,null,null,null,"γw：",null,"海水の単位体積重量",null,null,null,null,"（kN/m3）"]
[]
[null,"（車両の衝突エネルギー）"]
[null,"　衝突エネルギーは以下のとおり算定する。"]
[null,null,null,"Ed＝",null,"W","×","VH2"]
[null,null,null,null,null,null,"2g"]
[null,null,null,null,"＝",{"$f":"F26","v":26.785},null,"×",{"$f":"$J$20","v":0.71},null,2]
[null,null,null,null,null,2,null,"×",{"$f":"$J$12","v":9.81}]
[null,null,null,null,"＝",{"$f":"ROUND(F26*$J$20^2/2/$J$12,3)","v":0.68799999999999994},null,"kN・m"]

{"sheet":"colliding_force（船舶）","index":3,"n_rows":37,"n_cols":17,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,5,36,6],[36,7,36,8],[29,1,29,19],[30,1,31,19],[32,3,33,4],[34,4,35,4],[34,5,34,6],[34,8,34,9],[35,5,35,6],[35,8,35,9],[25,5,25,6],[25,7,25,8],[26,3,26,19],[27,4,27,5],[27,6,27,10],[27,11,27,12],[18,11,18,12],[22,1,22,19],[23,3,23,4],[23,5,23,19],[24,5,24,6],[24,7,24,8],[24,10,24,11],[24,13,24,14],[24,16,24,17],[19,2,19,4],[19,7,19,8],[19,9,19,10],[19,11,19,12],[10,2,10,4],[10,7,10,8],[10,9,10,10],[10,11,10,12],[11,2,11,4],[11,7,11,8],[11,9,11,10],[11,11,11,12],[14,1,16,19],[18,2,18,4],[18,7,18,8],[18,9,18,10],[8,2,8,4],[8,7,8,8],[8,9,8,10],[8,11,8,12],[9,2,9,4],[9,7,9,8],[9,9,9,10],[9,11,9,12],[3,1,4,19],[6,2,6,4],[6,9,6,11],[7,2,7,4],[7,7,7,8],[7,9,7,10],[7,11,7,12]]}
["漂流物（船舶）の衝突エネルギーの計算"]
["■計算条件"]
[null,"①漂流物の諸元"]
[null,"　設計漂流物として、吃水が浸水深位内となる対象漂流物の中で重量が最大となる以下を用いる。"]
[]
[null,"・漂流物諸元"]
[null,null,"名称",null,null,null,null,null,null,"漁船●●G.T."]
[null,null,"全長",null,null,null,null,"L＝",null,21.4,null,"m"]
[null,null,"車幅",null,null,null,null,"B＝",null,5.0999999999999996,null,"m"]
[null,null,"排水トン数",null,null,null,null,"Wo＝",null,600,null,"kN"]
[null,null,"空荷吃水",null,null,null,null,"Do＝",null,1,null,"m"]
[null,null,"重力加速度",null,null,null,null,"g＝",null,9.81,null,"m2/sec"]
[]
[null,"②津波の諸元"]
[null,"　津波の諸元については、津波漂流物対策施設を整備する●●漁港における当該箇所の津波シミュレーション結果から、現実的な対策レベルから大きく外れていないと推定される範囲の外力値を設定する。"]
[]
[]
[null,"・津波諸元"]
[null,null,"浸水深",null,null,null,null,"h＝",null,1.5,null,"m"]
[null,null,"流速",null,null,null,null,"VH＝",null,1.1000000000000001,null,"m/sec"]
[]
["■衝突エネルギーの計算"]
[null,"（船舶の仮想重量）"]
[null,null,null,"W＝",null,"Wo＋（π/4）Do2×L×γw"]
[null,null,null,null,"＝",{"$f":"$J$10","v":600},null,"＋（π/4）",null,"×",{"$f":"$J$11","v":1},null,"2×",{"$f":"$J$8","v":21.4},null,"×",10.1]
[null,null,null,null,"＝",{"$f":"ROUND($J$10+(PI()/4)*$J$11^2*$J$8*10.1,3)","v":769.75599999999997},null,"kN"]
[null,null,null,"　ここに、"]
[null,null,null,null,"γw：",null,"海水の単位体積重量",null,null,null,null,"（kN/m3）"]
[]
[null,"（船舶の衝突エネルギー）"]
[null,"　衝突エネルギーは、1/4点衝突（船の回転により衝突エネルギーが消費されるもの）として、以下のとおり算定する。"]
[]
[null,null,null,"Ed＝",null,"W","×","VH2"]
[null,null,null,null,null,null,"4g"]
[null,null,null,null,"＝",{"$f":"F26","v":769.75599999999997},null,"×",{"$f":"$J$20","v":1.1000000000000001},null,2]
[null,null,null,null,null,4,null,"×",{"$f":"$J$12","v":9.81}]
[null,null,null,null,"＝",{"$f":"ROUND(F26*$J$20^2/4/$J$12,3)","v":23.736000000000001},null,"kN・m"]

{"sheet":"collision_energy (池野式)","index":4,"n_rows":31,"n_cols":24,"rows_kept":31,"cut":false,"hidden":false,"merged":[[26,17,27,18],[28,6,29,6],[28,7,29,7],[28,8,29,8],[28,9,29,9],[30,5,30,6],[30,7,30,8],[25,10,25,11],[26,4,27,4],[26,5,27,5],[26,6,27,6],[26,7,27,7],[26,8,27,8],[26,9,26,16],[24,3,25,4],[24,5,25,7],[24,13,25,14],[24,15,25,16],[25,8,25,9],[20,2,20,4],[20,7,20,8],[20,9,20,10],[20,11,20,12],[23,1,23,19],[12,2,12,4],[12,7,12,8],[12,9,12,10],[15,1,17,19],[19,2,19,4],[19,7,19,8],[19,9,19,10],[19,11,19,12],[10,2,10,4],[10,7,10,8],[10,9,10,10],[10,12,10,19],[11,2,11,4],[11,7,11,8],[11,9,11,10],[11,11,11,12],[8,2,8,4],[8,7,8,8],[8,9,8,10],[8,11,8,12],[9,2,9,4],[9,7,9,8],[9,9,9,10],[9,11,9,12],[3,1,4,19],[6,2,6,4],[6,9,6,11],[7,2,7,4],[7,7,7,8],[7,9,7,10],[7,11,7,12]]}
["池野らの式による漂流物の衝突力の計算"]
["■計算条件"]
[null,"①漂流物の諸元"]
[null,"　設計漂流物として、吃水が浸水深位内となる対象漂流物の中で重量が最大となる以下を用いる。"]
[]
[null,"・漂流物諸元"]
[null,null,"名称",null,null,null,null,null,null,"普通乗用車"]
[null,null,"漂流物の高さ",null,null,null,null,"D＝",null,2,null,"m"]
[null,null,"全長",null,null,null,null,"L＝",null,5,null,"m"]
[null,null,"質量",null,null,null,null,"M＝",null,2.5,null,"t"]
[null,null,"付加質量係数",null,null,null,null,"CMA＝",null,{"$f":"IF(M11=X11,W11,IF(M11=X12,W12,IF(M11=X13,W13,IF(M11=X14,W14,IF(M11=X15,W15,IF(M11=X16,W16,IF(M11=X17,W17,IF(M11=X18,W18,IF(M11=X19,W19,IF(M11=X20,W20))))))))))","v":2},null,null,"（円柱横向き（二次元））",null,null,null,null,null,null,null,null,null,2,"（円柱横向き（二次元））"]
[null,null,"重力加速度",null,null,null,null,"g＝",null,9.81,null,"m2/sec",null,null,null,null,null,null,null,null,null,null,1.5,"（円柱横向き（三次元））"]
[null,null,"係数",null,null,null,null,"S＝",null,5,null,null,null,null,null,null,null,null,null,null,null,null,2,"（角柱横向き（二次元）①）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5,"（角柱横向き（二次元）②）"]
[null,"②津波の諸元",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"（角柱横向き（二次元）③）"]
[null,"　津波の諸元については、津波漂流物対策施設を整備する●●漁港における当該箇所の津波シミュレーション結果から、現実的な対策レベルから大きく外れていないと推定される範囲の外力値を設定する。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5,"（角柱横向き（二次元）④）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"（角柱横向き（二次元）⑤）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.5,"（角柱横向き（三次元））"]
[null,"・津波諸元",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"（円柱縦向き）"]
[null,null,"浸水深",null,null,null,null,"h＝",null,2,null,"m",null,null,null,null,null,null,null,null,null,null,0.8,"（球）"]
[null,null,"流速",null,null,null,null,"VH＝",null,0.71,null,"m/sec"]
[]
["■衝突力の計算"]
[null,"　漂流物の衝突力は、池野らの式を用いて算定する。"]
[null,null,null,"F1＝",null,"S×CMA×",null,null,null,null,"VH",null,null,0.25,null,"×g×M"]
[null,null,null,null,null,null,null,null,"g0.5・",null,"D0.25・",null,"L0.25"]
[null,null,null,null,"＝",{"$f":"J13","v":5},"×",{"$f":"J11","v":2},"×",{"$f":"$J$21","v":0.71},null,null,null,null,null,null,null,2.5]
[null,null,null,null,null,null,null,null,null,{"$f":"$J$12","v":9.81},0.5,"×",{"$f":"$J$8","v":2},0.25,"×",{"$f":"$J$9","v":5},0.25]
[null,null,null,null,null,null,"×",{"$f":"$J$12","v":9.81},"×",{"$f":"$J$10","v":2.5}]
[]
[null,null,null,null,"＝",{"$f":"ROUND($J$13*$J$11*($J$21/($J$12^0.5)/($J$8^0.25)/($J$9^0.25))^2.5*$J$12*J$10,3)","v":1.423},null,"kN"]