{"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":[[0,21,1,26],[43,29,43,30],[59,4,59,5],[59,6,59,8],[60,14,60,15],[60,16,60,18],[0,0,0,20],[7,1,7,19],[47,25,47,27],[48,26,48,27],[48,28,48,30],[24,9,24,12],[38,9,38,12],[47,11,47,13],[47,14,47,15],[47,16,47,18],[6,1,6,19],[31,1,31,19],[28,13,30,19],[32,2,36,18],[16,13,17,19],[41,9,41,12],[43,13,43,14],[60,1,60,3],[60,4,60,5],[60,6,60,8],[46,26,46,27],[43,25,43,28],[54,1,54,3],[54,4,54,5],[54,6,54,8],[44,13,44,14],[44,15,44,17],[53,1,53,3],[53,4,53,5],[53,6,53,8],[59,11,59,13],[59,14,59,15],[59,16,59,18],[55,4,55,5],[55,6,55,8],[33,23,33,24],[33,25,33,27],[49,4,49,5],[49,6,49,8],[26,9,26,12],[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,23,38,24],[38,25,38,27],[42,13,42,14],[42,15,42,17],[46,28,46,30],[39,15,39,17],[45,25,45,27],[16,30,16,33],[43,15,43,17],[43,10,43,12],[41,13,41,15],[45,10,45,12],[45,13,45,14],[45,15,45,17],[42,10,42,12],[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,27,24,28],[24,13,24,14],[38,13,38,14],[38,15,38,17],[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],[13,7,13,9],[12,2,12,4],[12,5,12,6],[9,2,9,4],[4,13,5,19],[13,11,13,13],[13,14,13,15],[13,16,13,18],[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],[13,5,13,6]]}
["■試行錯誤法による端部支柱（単杭）の検討実行フロー",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":106.28952776393027}]
[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,318.5,null,null,null,"③津波の諸元（漂流物のエネルギー）"]
[null,null,"肉厚",null,null,"ｔ＝",null,10.3,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,1,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":235.119}]
[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":237.89699999999999}]
[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.0109999999999999}]
[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!H134","v":6.7549999999999999}]
[]
[]
[]
[null,"↓　上記①②③の条件を入力したら下のボタンをクリックする。"]
[null,null,null,null,null,null,null,null,null,"衝突荷重",null,null,null,"Fmax＝",null,{"$f":"kouzoukeisan!H81","v":106.28952776393027},null,null,null,null,null,null,null,"（Ｅｎ＋ＥＲ）／Ｅｄ＝",null,null,null,{"$f":"kouzoukeisan!H137","v":10.112}]
[null,null,null,null,null,null,null,null,null,"ＭＲ／Ｍmax＝",null,null,null,{"$f":"kouzoukeisan!H100","v":1.0109999999999999},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!H137","v":10.112},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!H148","v":34.12571301221417}]
[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!H159","v":75.488}]
[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":237.89699999999999}]
[]
[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!H166","v":3.1509999999999998}]
[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!H148","v":34.12571301221417},null,null,null,null,null,null,null,"Ｅｎ＋ＥＲ＝",null,{"$f":"kouzoukeisan!H198","v":0.67499999999999993}]
[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!H166","v":3.1509999999999998},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!H201","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!H179","v":3.4000000000000002E-2}]
[null,null,null,null,null,null,null,null,null,null,"発生応力",null,null,"Ｍmax＝",null,{"$f":"kouzoukeisan!H159","v":75.488},null,null,null,null,null,null,null,null,null,"（Ｅｎ＋ＥＲ）／Ｅｄ＝",null,null,null,{"$f":"kouzoukeisan!H201","v":1.01}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"σmax＝",null,{"$f":"kouzoukeisan!H163","v":140573.557},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD44>=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!H211","v":4.91},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,{"$f":"kouzoukeisan!H211","v":4.91}]
[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,null,null,null,null,null,null,null,null,null,"σmax＝",null,{"$f":"kouzoukeisan!H163","v":140573.557}]

{"sheet":"kouzoukeisan","index":1,"n_rows":211,"n_cols":22,"rows_kept":211,"cut":false,"hidden":false,"merged":[[29,11,29,12],[29,9,29,10],[181,8,181,9],[181,10,181,11],[12,13,13,20],[208,6,209,6],[208,7,208,8],[209,7,209,8],[152,6,153,6],[109,11,110,12],[38,5,38,6],[59,0,59,20],[200,9,200,19],[201,2,202,19],[170,2,171,19],[183,2,183,19],[205,2,205,19],[206,5,207,6],[206,7,206,8],[207,7,207,8],[195,9,195,10],[196,2,196,19],[197,4,197,6],[197,9,197,10],[198,2,198,19],[199,2,199,6],[199,7,199,8],[199,10,199,11],[189,7,189,8],[189,9,189,10],[190,3,190,20],[191,5,192,6],[191,7,192,7],[191,8,191,9],[192,8,192,9],[193,6,194,6],[193,7,194,8],[193,9,194,9],[193,10,193,11],[194,10,194,11],[184,3,184,20],[185,2,185,4],[185,5,186,6],[185,7,186,8],[185,9,185,11],[185,12,186,13],[186,9,186,11],[187,6,188,6],[187,7,188,8],[187,9,188,9],[187,14,187,15],[187,19,188,20],[188,10,188,11],[188,13,188,14],[188,16,188,17],[182,9,182,10],[172,3,172,20],[173,5,174,6],[173,7,173,10],[173,11,174,11],[174,7,174,10],[175,13,175,20],[176,6,177,6],[176,7,176,8],[176,9,176,10],[176,12,176,13],[176,14,176,15],[176,16,177,16],[176,17,177,18],[177,9,177,10],[177,12,177,13],[83,17,84,19],[90,7,91,7],[178,9,178,10],[179,3,179,20],[180,5,180,6],[181,13,181,14],[129,7,130,8],[129,9,130,9],[129,10,129,11],[130,10,130,11],[164,10,164,11],[165,9,165,19],[166,2,167,19],[146,2,146,19],[147,2,147,4],[147,5,147,6],[147,9,147,10],[132,2,132,19],[134,2,134,19],[135,7,135,8],[98,7,98,8],[98,10,98,11],[90,8,91,9],[90,10,91,10],[90,11,91,12],[156,11,157,12],[137,2,138,19],[158,9,158,10],[159,3,159,20],[135,10,135,11],[136,9,136,19],[133,4,133,6],[135,2,135,6],[126,3,126,20],[127,5,128,6],[127,7,128,7],[127,8,127,9],[128,8,128,9],[129,6,130,6],[123,19,124,20],[117,8,117,9],[117,10,117,11],[117,13,117,14],[119,2,119,19],[120,3,120,20],[121,5,122,6],[121,7,122,8],[122,9,122,11],[160,5,160,6],[160,7,160,8],[161,7,161,8],[161,10,161,11],[162,9,162,10],[154,7,155,8],[154,9,155,10],[154,11,154,17],[155,11,155,12],[155,13,155,14],[155,16,155,17],[156,7,157,7],[156,8,157,9],[156,10,157,10],[121,9,121,11],[123,6,124,6],[123,7,124,8],[123,9,124,9],[123,14,123,15],[124,10,124,11],[124,13,124,14],[124,16,124,17],[121,12,122,13],[86,13,86,14],[86,15,86,16],[112,17,113,18],[111,13,111,20],[106,2,107,19],[115,3,115,20],[108,3,108,20],[93,3,93,20],[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],[109,5,110,6],[95,10,95,11],[99,9,99,19],[97,2,97,19],[83,2,83,4],[86,8,86,9],[100,2,101,19],[197,7,197,8],[210,9,210,10],[210,7,210,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],[83,5,84,6],[158,7,158,8],[178,7,178,8],[182,7,182,8],[195,7,195,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],[73,7,73,8],[76,7,76,8],[72,10,72,11],[74,7,74,8],[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],[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],[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],[194,23,194,24],[148,3,148,20],[149,2,149,4],[149,5,150,6],[149,7,150,7],[149,8,149,10],[149,11,150,12],[149,13,150,14],[149,15,149,16],[149,17,150,19],[150,8,150,10],[162,7,162,8],[150,15,150,16],[151,13,151,20],[152,7,153,7],[152,8,152,9],[152,10,152,11],[152,13,152,14],[152,15,152,16],[153,11,153,12],[153,14,153,15],[163,2,163,19],[164,3,164,6],[164,7,164,8],[89,16,89,17],[89,11,89,12],[88,11,88,17],[34,2,34,4],[35,2,35,4],[25,9,25,10],[27,9,27,10],[165,7,165,8],[200,7,200,8],[141,1,144,19],[92,7,92,8],[114,7,114,8],[118,7,118,8],[125,7,125,8],[131,7,131,8],[133,7,133,8],[147,7,147,8],[79,2,79,19],[81,2,81,19],[85,13,85,20],[86,5,87,6],[86,7,87,7],[28,9,28,10],[31,9,31,10],[31,2,31,4],[31,7,31,8],[206,2,206,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],[87,14,87,15],[88,7,89,8],[88,9,89,10],[89,13,89,14],[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],[19,2,19,4],[20,2,20,4],[15,7,15,8],[16,7,16,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],[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],[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],[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],[23,11,23,12],[24,11,24,12],[25,11,25,12],[114,9,114,10],[118,9,118,10],[125,9,125,10],[131,9,131,10],[133,9,133,10],[136,7,136,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],[94,7,94,8],[95,7,95,8],[34,9,34,10],[35,9,35,10],[69,7,69,8],[70,7,70,8]]}
["端部支柱の構造計算（頭部自由杭の計算）"]
["■計算条件"]
[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":318.5},null,"mm",null,"（",{"$f":"ROUND(J7/1000,6)","v":0.31850000000000001},null,"m）"]
[null,null,"肉厚",null,null,null,null,"ｔ＝",null,{"$f":"jikkou!H13","v":10.3},null,"mm",null,"（",{"$f":"ROUND(J8/1000,6)","v":1.03E-2},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":7.0000000000000001E-3},null,"m",null,"（Ｄ／tp＝",null,{"$f":"ROUND(J13/J12,1)","v":44.7},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.313},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.29799999999999999},null,"m"]
[null,"・杭の断面性能"]
[null,null,"断面二次モーメント",null,null,null,null,"Ｉo＝",null,{"$f":"ROUND(PI()*(O7^4-O8^4)/64,6)","v":5.0500000000000002E-4},null,"m4",null,"（腐食前）"]
[null,null,null,null,null,null,null,"Ｉ＝",null,{"$f":"ROUND(PI()*(J13^4-J14^4)/64,6)","v":8.3999999999999995E-5},null,"m4",null,"（腐食後）"]
[null,null,"ＥＩの計算",null,null,null,null,"ＥＩo＝",null,{"$f":"ROUND(J6*J16,0)","v":101000},null,"kN・㎡",null,"（腐食前）"]
[null,null,null,null,null,null,null,"ＥＩ＝",null,{"$f":"ROUND(J6*J17,0)","v":16800},null,"kN・㎡",null,"（腐食後）"]
[null,null,"断面係数",null,null,null,null,"Ｚ＝",null,{"$f":"ROUND(J17*2/J13,6)","v":5.3700000000000004E-4},null,"m3",null,"（腐食後）"]
[null,null,"塑性断面係数",null,null,null,null,"Ｚp＝",null,{"$f":"ROUND((J13^3-J14^3)/6,6)","v":6.9999999999999999E-4},null,"m3"]
[null,"・杭・地盤の特性値"]
[null,null,"杭幅",null,null,null,null,"B＝",null,{"$f":"J13","v":0.313},null,"m"]
[null,null,null,null,null,null,null,"B・kh＝",null,{"$f":"ROUND(J32*J23,0)","v":9390},null,"kN/m3"]
[null,null,"特性値",null,null,null,null,"βo＝",null,{"$f":"ROUND((J24/4/J18)^(1/4),4)","v":0.39050000000000001},null,"m-1",null,"（腐食前）"]
[null,null,null,null,null,null,null,"β＝",null,{"$f":"ROUND((J24/4/J19)^(1/4),4)","v":0.61140000000000005},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":1},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.31850000000000001},null,"／",{"$f":"$O$8","v":1.03E-2},null,"）-0.104"]
[null,null,null,null,null,null,"＝",{"$f":"ROUND($J$28*($O$7/$O$8)^-0.104,3)","v":369.17700000000002},null,"N/mm3"]
[null,null,null,null,null,null,"＝",{"$f":"ROUND(1000*$J$28*($O$7/$O$8)^-0.104,0)","v":369177},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":369177}]
[null,null,null,null,null,null,"＝",{"$f":"ROUND($J$29*H71,0)","v":443012},null,"kN/m3"]
[null,null,null,null,null,"ＭＲ＝",null,"Z×σdy"]
[null,null,null,null,null,null,"＝",{"$f":"$J$20","v":5.3700000000000004E-4},null,"×",{"$f":"H74","v":443012}]
[null,null,null,null,null,null,"＝",{"$f":"ROUND($J$20*H74,3)","v":237.89699999999999},null,"kN・m"]
[]
[null,"・杭に発生する反力"]
[null,null,"　杭に発生する曲げ応力が杭の曲げ耐力に等しくなるような反力Fmaxを求める。"]
[null,null,"　ここで、",null,null,"Fmax＝",null,106.28952776393027,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.61140000000000005},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.61140000000000005},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.61140000000000005},null,"×",{"$f":"$J$36","v":2}]
[null,null,null,null,null,null,null,"×",{"$f":"H81","v":106.28952776393027},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":235.119},null,"kN・m"]
[null,null,null,"（杭の最大曲げ応力）"]
[null,null,null,null,null,"σmax＝",null,"Ｍmax／Z"]
[null,null,null,null,null,null,"＝",{"$f":"H93","v":235.119},null,"／",{"$f":"$J$20","v":5.3700000000000004E-4}]
[null,null,null,null,null,null,"＝",{"$f":"ROUND(H93/$J$20,3)","v":437837.989},null,"kN/㎡"]
[null,null,"　ここで、"]
[null,null,null,"ＭＲ／Ｍmax＝",null,null,null,{"$f":"$H$77","v":237.89699999999999},null,"／",{"$f":"H93","v":235.119}]
[null,null,null,null,null,null,"＝",{"$f":"ROUNDDOWN($H$77/H93,3)","v":1.0109999999999999},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.61140000000000005},null,"×",{"$f":"$J$36","v":2},null,"）3+1",null,"×",{"$f":"H81","v":106.28952776393027}]
[null,null,null,null,null,null,null,null,"6×",{"$f":"$J$19","v":16800},null,"×",{"$f":"$J$26","v":0.61140000000000005},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":0.106},null,"m"]
[null,null,null,"（梁変形による吸収エネルギー）"]
[null,null,null,null,null,"Ｅｎ＝",null,"n×1/2×Fmax×ytop"]
[null,null,null,null,null,null,"＝",{"$f":"$J$30","v":1},"×1/2×",null,{"$f":"H81","v":106.28952776393027},null,"×",{"$f":"H115","v":0.106}]
[null,null,null,null,null,null,"＝",{"$f":"ROUND($J$30*1/2*H81*H115,3)","v":5.633},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.313},null,"×",null,null,null,"4×",{"$f":"H81","v":106.28952776393027},null,null,null,null,1.25]
[null,null,null,null,null,null,null,null,null,null,185,null,"×",{"$f":"$H$74","v":443012},null,"×",{"$f":"$J$12","v":7.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":1.9E-2},null,"m",null,null,null,"（ここに、K：実験定数（=185））"]
[null,null,null,"（局部変形による吸収エネルギー）"]
[null,null,null,null,null,"ＥＲ＝",null,"Fmax","δＬ０"]
[null,null,null,null,null,null,null,null,1.8]
[null,null,null,null,null,null,"＝",{"$f":"H81","v":106.28952776393027},null,"×",{"$f":"H126","v":1.9E-2}]
[null,null,null,null,null,null,null,null,null,null,1.8]
[null,null,null,null,null,null,"＝",{"$f":"ROUND(H81*H126/1.8,3)","v":1.1220000000000001},null,"kN・m"]
[null,null,"　以上の和から、吸収エネルギーは以下のとおりとなる。"]
[null,null,null,null,"Ｅｎ＋ＥＲ＝",null,null,{"$f":"H119+H132","v":6.7549999999999999},null,"kN・m"]
[null,null,"　ここで、"]
[null,null,"（Ｅｎ＋ＥＲ）／Ｅｄ＝",null,null,null,null,{"$f":"H134","v":6.7549999999999999},null,"／",{"$f":"$J$35","v":0.66800000000000004}]
[null,null,null,null,null,null,"＝",{"$f":"ROUNDDOWN(H134/$J$35,3)","v":10.112},null,{"$f":"IF(H137>=1,\"≧1.0　となり、\",\"＜1.0　となり、\")","v":"≧1.0　となり、"}]
[null,null,{"$f":"IF(H137>=1,\"　杭の吸収エネルギーが衝突エネルギーを上回るので、本条件により杭の諸元を確定する。\",\"　杭の吸収エネルギーが衝突エネルギーを下回るので、計算条件を再設定する必要がある。\")","v":"　杭の吸収エネルギーが衝突エネルギーを上回るので、本条件により杭の諸元を確定する。"}]
[]
[]
["■STEP-2：作用荷重の決定、杭の挙動解析（発生応力、所要根入れ長）"]
[null,"　STEP-1で確定した断面諸元を有する杭部材に漂流物が衝突した場合の挙動を解析する。\n　杭が吸収するエネルギーが衝突エネルギーに等しくなるような衝突力Fを求める。この衝突力が作用するときの杭の断面応力及び所要根入れ長を計算するとともに、杭の吸収エネルギーが衝突エネルギーに等しいことを説明する。"]
[]
[]
[]
[null,"・杭に発生する反力"]
[null,null,"　杭に発生する曲げ応力が杭の曲げ耐力に等しくなるような反力Fを求める。"]
[null,null,"　ここで、",null,null,"F＝",null,34.12571301221417,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.61140000000000005},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.61140000000000005},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.61140000000000005},null,"×",{"$f":"$J$36","v":2}]
[null,null,null,null,null,null,null,"×",{"$f":"H148","v":34.12571301221417},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))))*H148*$J$36,3)","v":75.488},null,"kN・m"]
[null,null,null,"（杭の最大曲げ応力）"]
[null,null,null,null,null,"σmax＝",null,"Ｍmax／Z"]
[null,null,null,null,null,null,"＝",{"$f":"H159","v":75.488},null,"／",{"$f":"$J$20","v":5.3700000000000004E-4}]
[null,null,null,null,null,null,"＝",{"$f":"ROUND(H159/$J$20,3)","v":140573.557},null,"kN/㎡"]
[null,null,"　ここで、"]
[null,null,null,"ＭＲ／Ｍmax＝",null,null,null,{"$f":"$H$77","v":237.89699999999999},null,"／",{"$f":"H159","v":75.488}]
[null,null,null,null,null,null,"＝",{"$f":"ROUNDDOWN($H$77/H159,3)","v":3.1509999999999998},null,{"$f":"IF(H165>=1,\"≧1.0　となり、\",\"＜1.0　となり、\")","v":"≧1.0　となり、"}]
[null,null,{"$f":"IF(H166>=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.61140000000000005},null,"×",{"$f":"$J$36","v":2},null,"）3+1",null,"×",{"$f":"H148","v":34.12571301221417}]
[null,null,null,null,null,null,null,null,"6×",{"$f":"$J$19","v":16800},null,"×",{"$f":"$J$26","v":0.61140000000000005},null,3]
[null,null,null,null,null,null,"＝",{"$f":"ROUND((2*(1+$J$26*$J$36)^3+1)/(6*$J$19*$J$26^3)*H148,3)","v":3.4000000000000002E-2},null,"m"]
[null,null,null,"（梁変形による吸収エネルギー）"]
[null,null,null,null,null,"Ｅｎ＝",null,"n×1/2×F×ytop"]
[null,null,null,null,null,null,"＝",{"$f":"$J$30","v":1},"×1/2×",null,{"$f":"H148","v":34.12571301221417},null,"×",{"$f":"H179","v":3.4000000000000002E-2}]
[null,null,null,null,null,null,"＝",{"$f":"ROUND($J$30*1/2*H148*H179,3)","v":0.57999999999999996},null,"kN・m"]
[null,null,"　局部変形による吸収エネルギーは、荷重Fとそれに対する凹み量から求める。"]
[null,null,null,"（荷重Fに対する凹み量）"]
[null,null,null,null,null,"δＬ０＝",null,"D×",null,"4F",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.313},null,"×",null,null,null,"4×",{"$f":"H148","v":34.12571301221417},null,null,null,null,1.25]
[null,null,null,null,null,null,null,null,null,null,185,null,"×",{"$f":"$H$74","v":443012},null,"×",{"$f":"$J$12","v":7.0000000000000001E-3},null,2]
[null,null,null,null,null,null,"＝",{"$f":"ROUND($J$13*(4*H148/185/$H$74/$J$12^2)^1.25,3)","v":5.0000000000000001E-3},null,"m",null,null,null,"（ここに、K：実験定数（=185））"]
[null,null,null,"（局部変形による吸収エネルギー）"]
[null,null,null,null,null,"ＥＲ＝",null,"Po","δＬ０"]
[null,null,null,null,null,null,null,null,1.8]
[null,null,null,null,null,null,"＝",{"$f":"H148","v":34.12571301221417},null,"×",{"$f":"H190","v":5.0000000000000001E-3}]
[null,null,null,null,null,null,null,null,null,null,1.8]
[null,null,null,null,null,null,"＝",{"$f":"ROUND(H148*H190/1.8,3)","v":9.5000000000000001E-2},null,"kN・m"]
[null,null,"　以上の和から、吸収エネルギーは以下のとおりとなる。"]
[null,null,null,null,"Ｅｎ＋ＥＲ＝",null,null,{"$f":"H183+H196","v":0.67499999999999993},null,"kN・m"]
[null,null,"　ここで、"]
[null,null,"（Ｅｎ＋ＥＲ）／Ｅｄ＝",null,null,null,null,{"$f":"H198","v":0.67499999999999993},null,"／",{"$f":"$J$35","v":0.66800000000000004}]
[null,null,null,null,null,null,"＝",{"$f":"ROUNDDOWN(H198/$J$35,3)","v":1.01},null,{"$f":"IF(H201>=1,\"≧1.0　となり、\",\"＜1.0　となり、\")","v":"≧1.0　となり、"}]
[null,null,{"$f":"IF(H201>=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.61140000000000005}]
[null,null,null,null,null,null,"＝",{"$f":"ROUND(3/$J$26,2)","v":4.91},null,"m"]

{"sheet":"colliding_force（車両）","index":2,"n_rows":36,"n_cols":17,"rows_kept":36,"cut":false,"hidden":false,"merged":[[22,1,22,19],[18,2,18,4],[18,7,18,8],[18,9,18,10],[18,11,18,12],[19,2,19,4],[19,7,19,8],[19,9,19,10],[19,11,19,12],[3,1,4,19],[8,7,8,8],[8,11,8,12],[7,11,7,12],[6,2,6,4],[8,2,8,4],[7,2,7,4],[8,9,8,10],[7,9,7,10],[7,7,7,8],[6,9,6,11],[31,3,32,4],[25,5,25,6],[25,7,25,8],[26,3,26,19],[27,4,27,5],[27,6,27,10],[27,11,27,12],[30,1,30,19],[29,1,29,19],[33,4,34,4],[33,5,33,6],[33,8,33,9],[35,5,35,6],[35,7,35,8],[34,8,34,9],[34,5,34,6],[23,3,23,4],[23,5,23,19],[24,5,24,6],[24,7,24,8],[24,13,24,14],[24,16,24,17],[24,10,24,11],[9,2,9,4],[9,11,9,12],[9,9,9,10],[9,7,9,8],[14,1,16,19],[10,7,10,8],[10,2,10,4],[10,9,10,10],[10,13,11,20],[10,11,10,12],[11,2,11,4],[11,7,11,8],[11,9,11,10],[11,11,11,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],[35,5,35,6],[30,1,31,19],[29,1,29,19],[32,3,33,4],[34,4,35,4],[34,5,34,6],[34,8,34,9],[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":[[3,1,4,19],[6,2,6,4],[7,2,7,4],[7,7,7,8],[7,9,7,10],[7,11,7,12],[6,9,6,11],[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],[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],[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],[20,2,20,4],[20,7,20,8],[20,9,20,10],[20,11,20,12],[23,1,23,19],[26,17,27,18],[24,3,25,4],[24,5,25,7],[24,13,25,14],[24,15,25,16],[25,8,25,9],[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],[28,6,29,6],[28,7,29,7],[28,8,29,8],[28,9,29,9],[30,5,30,6],[30,7,30,8]]}
["池野らの式による漂流物の衝突力の計算"]
["■計算条件"]
[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"]