{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["強度検討算出式 (両単位)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"強度検討算出式 (両単位)","index":0,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,6,0,9],[1,0,1,9],[5,0,5,6],[7,0,7,5],[8,0,8,9],[9,0,9,5],[10,0,10,9],[11,5,11,8],[18,0,18,6],[20,0,20,2],[20,5,20,7],[12,7,14,9],[23,0,23,6],[24,0,24,6],[25,0,25,6],[27,0,27,6],[28,0,28,6],[29,0,29,6],[30,0,30,6],[33,0,33,6],[34,0,34,6],[36,0,36,9],[38,0,39,0],[38,2,39,2],[38,4,39,4],[38,5,39,5],[38,6,39,6],[41,0,42,0],[41,2,42,2],[41,4,42,4],[41,5,42,5],[41,6,42,6],[44,0,45,0],[44,2,45,2],[44,4,45,4],[44,5,45,5],[44,6,45,6],[47,0,48,0],[47,2,48,2],[47,4,48,4],[47,5,48,5],[47,6,48,6],[50,0,51,0],[50,2,51,2],[50,4,51,4],[50,5,51,5],[50,6,51,6],[53,0,54,0],[53,2,54,2],[53,4,54,4],[53,5,54,5],[53,6,54,6],[53,7,54,7],[56,0,57,0],[56,2,57,2],[56,4,57,4],[56,5,57,5],[56,6,57,6],[56,7,57,7]],"flags":["formulas_cached_only"]}
[]
["駆動用蓄電池パック取付部の強度検討書（両単位）"]
[]
[null,null,null,"=代入",null,null,"=安全率"]
[]
["１．駆動用バッテリー重量（１ユニットあたり）",{"$nulls":6},"W1",150,"ｋｇ"]
[]
["２．駆動用バッテリーの形状、固定方法及びボルトの本数",{"$nulls":6},"N",4,"本"]
["　　※図面添付のこと"]
["３．固定ボルトの寸法・規格（材質）及びボルトのせん断強さ",{"$nulls":6},"τb",470.4,"MPa"]
["　　※図面に記載のこと　【例】１ユニットあたりＭ８ボルト４本で車両床面に固定（Ｍ８ボルト（４Ｔ）の引っ張り強さ７８４ＭＰａ）"]
[{"$nulls":5},"（τb：せん断強さ=引っ張り強さ×０．６）"]
[{"$nulls":7},"←どちらか一方入力してください。"]
["引っ張り強さ＝",null,null,"kgf/mm2","ｏｒ",784,"MPa"]
[]
["４．ボルト径",{"$nulls":6},"直径",8,"mm"]
[]
[]
["●強度要件"]
[]
["専ら乗用の場合：乗車定員",null,null,10,"人","専ら貨物の場合：車両総重量",null,null,1350,"kg"]
[]
["○車両中心線に平行な方向の加速度に対する強度"]
["専ら乗用の用に供する乗車定員10人以下の自動車又は貨物の運送の用に供する車両総重量3.5ｔ未満の自動車 ±196m/s2",{"$nulls":6},"G1",196]
["専ら乗用の用に供する乗車定員11人以上の自動車であって車両総重量５ｔ未満のもの又は貨物の運送の用に供する車両総重量3.5ｔ以上12ｔ未満の自動車 ±98ｍ/s2",{"$nulls":6},"G1",98]
["専ら乗用の用に供する乗車定員11人以上の自動車であって車両総重量５ｔ以上のもの又は貨物の運送の用に供する車両総重量12ｔ以上の自動車 ±64.7ｍ/s2",{"$nulls":6},"G1",64.7]
[{"$nulls":7},"G1",196]
[]
["○車両中心線と直交する方向の加速度に対する強度"]
["専ら乗用の用に供する乗車定員９人以下の自動車又は貨物の運送の用に供する車両総重量3.5ｔ未満の自動車 ±78.4m/s2",{"$nulls":6},"G2",78.4]
["専ら乗用の用に供する乗車定員10人以上の自動車又は貨物の運送の用に供する車両総重量3.5ｔ以上の自動車 ±49m/s2",{"$nulls":6},"G2",49]
[{"$nulls":7},"G2",78.4]
[]
["○車両中心線に平行な方向の加速度に対する強度",{"$nulls":7},3.2,"＞１．６"]
["○車両中心線と直交する方向の加速度に対する強度",{"$nulls":7},8,"＞１．６"]
[]
[]
["１-１．ボルト１本あたりのせん断力（F）：平行"]
["F１＝","W1・G1","＝",29400,"＝",7350,"MPa"]
[null,"N",null,4]
["１-２．ボルト１本あたりのせん断力（F）：直交"]
["F２＝","W1・G2","＝",11760,"＝",2940,"MPa"]
[null,"N",null,4]
["２．ボルトの断面積（A）"]
["A=","πD２","＝",200.96,"＝",50.24,"mm２"]
[null,4,null,4]
["３ー１．せん断応力（τ）：平行"]
["τ１＝","Ｆ１","＝",7350,"＝",146.3,"MPa"]
[null,"A",null,50.24]
["３ー２．せん断応力（τ）：直交"]
["τ２＝","Ｆ２","＝",2940,"＝",58.5,"MPa"]
[null,"A",null,50.24]
["４－１．破断安全率（fｂ）：平行",null,null,"（τb：せん断強さ=引っ張り強さ×０．６）"]
["ｆｂ＝","τｂ","＝",470.4,"＝",3.2,"＞１．６"]
[null,"τ１",null,146.3]
["４－２．破断安全率（fｂ）：直交",null,null,"（τb：せん断強さ=引っ張り強さ×０．６）"]
["ｆｂ＝","τｂ","＝",470.4,"＝",8,"＞１．６"]
[null,"τ２",null,58.5]