{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Sheet1","計算書テンプレート","MA断面性能","V50断面性能","工事情報","ヘルプテキスト"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Sheet1","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"計算書テンプレート","index":1,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":true,"merged":[[0,11,0,12]]}
[null,null,null,null,null,null,null,null,null,null,null,"YYYY/MM/DD"]
["明治耐火屋根デッキの構造計算書",null,null,null,null,"(一般の場合 or 多雪区域の場合)"]
["■前提"]
[null,"①構造設計は、(社)日本鉄鋼連盟編「デッキプレート床構造設計・施工規準-2004」及び(社)日本金属屋根協会「鋼板制屋根構法標準SSR2007」による。"]
[null,"②風圧力算定は、平成12年5月31日建設省告示第1458号による。"]
[null,"③屋根形状は陸屋根で、閉鎖型の建築物を原則とする。"]
[null,"④たわみ検定で単純支持がNGの場合は、デッキ連続支持での使用となる。"]
["■工事名称"]
[null,"XXXXXXXX"]
["■設計条件"]
[null,"①スパン",null,null,"最大スパン","(L)","=",0,"mm"]
[null,"②デッキプレート",null,null,"種類",null,":"]
[null,null,null,null,"板厚",null,"=",0,"mm"]
[null,null,null,null,"基準強度",null,"=",0,"N/mm2","(SDP1TG: 205N/mm2 / SDP2G: 235N/mm2)"]
[null,null,null,null,"自重","(Ｗd)","=",0,"N/m2"]
[null,null,null,null,"断面2次モーメント","(Ix)","=",0,"×104mm4"]
[null,null,null,null,"断面係数","(Zx)","=",0,"×103mm3"]
[null,null,null,null,"長期たわみ補正係数","(LC)","=",0,null,"(MA75の場合: 1.00 / V50の場合: 1.16)"]
[null,null,null,null,"短期たわみ補正係数","(sC)","=",0,null,"(MA75の場合: 1.00 / V50の場合: 1.20)"]
[null,null,null,null,"鋼材のヤング係数","(E)","=",0,"×105N/mm2"]
[null,"③仕上げ材",null,null,"仕上げ荷重","(W0)","=",0,"N/mm2"]
[null,"④梁との接合強度",null,null,null,"(Qa）","=",0,"KN/ｍ"]
["■設計荷重の算出"]
[null,"①固定荷重",null,null,null,"G","=",0,"N/m2","(=Ｗd+Ｗ0）"]
[null,"②積載荷重",null,null,null,"P","=",0,"N/m2"]
[null,"③積雪荷重",null,null,"積雪の単位荷重","(γ)","=",0,"N/cm/m2"]
[null,null,null,null,"垂直積雪量","(D)","=",0,"cm"]
[null,null,null,null,"レベル係数","(X)","=",0,null,"(積雪の不均衡を考慮)"]
[null,null,null,null,null,"S","=",0,"N/m2","(=γ*D*√cos(1.5*β)*X)"]
[null,"④風荷重 (正圧)",null,null,"地表面粗度区分",null,"=",null,null,"(Ⅰ～Ⅳのいずれかを選択する)"]
[null,null,null,null,"基準風速","(V0)","=",0,"m/s","(平成12年建設省告示1454号による)"]
[null,null,null,null,"屋根平均高さ","(H)","=",0,"m","(Ｈ>5mを対象)"]
[null,null,null,null,"地表面粗度による係数","(Zg)","=",0,"m","Ⅰ: 250 / Ⅱ: 350 / Ⅲ: 450"]
[null,null,null,null,"地表面粗度による係数","(α)","=",0,null,"Ⅰ: 0.10 / Ⅱ: 0.15 / Ⅲ: 0.20"]
[null,null,null,null,"高さ方向分布係数","(Er)","=",0,null,"(Er=1.7(H/Zg)α)"]
[null,null,null,null,"平均速度圧","(q)","=",0,"N/m2","(q=0.6*Er2*V02)"]
[null,null,null,null,"正圧ピーク風力係数","(pCf)","=",0,null,"(陸屋根タイプ&閉鎖型の建築物)"]
[null,null,null,null,null,"Wp","=",0,"N/m2","(=pCf*q)"]
[null,"⑤風荷重 (負圧)",null,null,"負圧ピーク風力係数","(nCf)","=",0,null,"(陸屋根タイプ&閉鎖型の建築物)"]
[null,null,null,null,null,"Wn","=",0,"N/m2","(=nCf*q)"]
["■応力・たわみ検定"]
[null,"Ⅰ) 長期に生ずる力",null,null,null,"LW","=",0,"N/m2","[※プログラムによる計算結果を入力]"]
[null,null,"・応力検定",null,"σ=1/8・LＷ・(L/1000)2/Zx",null,"=",0,"N/mm2","≦ F/1.5 =",0,"N/mm2"]
[null,null,"・たわみ検定 (単純支持)",null,"ssδ=1.5・LC・5/384・LＷ・(L/1000)4/(E・Ix)",null,"=",0,"mm","≦ L/250 =",0,"mm"]
[null,null,"・たわみ検定 (連続支持)",null,"csδ=1.5・LC・1/145・LＷ・(L/1000)4/(E・Ix)",null,"=",0,"mm","≦ L/250 =",0,"mm"]
[null,"Ⅱ) 短期に生ずる力",null,null,null,"sW","=",0,"N/m2","(=Max, [sＷs, sＷwp, |sＷwn|])"]
[null,null,"積雪時荷重",null,null,"sWs","=",0,"N/m2","(=G+P+S)"]
[null,null,"暴風時荷重 (正圧)",null,null,"sWwp","=",0,"N/m2","[※プログラムによる計算結果を入力]"]
[null,null,"暴風時荷重 (負圧)",null,null,"sWwn","=",0,"N/m2","(=G+P+Wn)"]
[null,null,"・応力検定",null,"σ=1/8・sW・(L/1000)2/Zx",null,"=",0,"N/mm2","≦ F =",0,"N/mm2"]
[null,null,"・たわみ検定 (単純支持)",null,"ssδy=sC・5/384・sW・(L/1000)4/(E・Ix)",null,"=",0,"mm","≦ L/180 =",0,"mm and 20mm"]
[null,null,"・たわみ検定 (連続支持)",null,"csδy=sC・1/145・sW・(L/1000)4/(E・Ix)",null,"=",0,"mm","≦ L/180 =",0,"mm and 20mm"]
[null,"Ⅲ) 接合部に生ずる力",null,null,null,"qW","=",0,"KN/m2","(=|sＷwn|)"," "]
[null,null,"・強度検定",null,"Qy=1.25・qＷ・L",null,"=",0,"KN/m","≦ Qa =",0,"KN/m"]
["■屋根30分耐火構造認定検定"]
[null,"・耐火時許容単純支持スパン",null,null,null,"S.S.","=",0,"m","≧ L =",0,"m"]
[null,"・耐火時許容連続支持スパン",null,null,null,"D.S.","=",0,"m","≧ L =",0,"m"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"以上"]

{"sheet":"MA断面性能","index":2,"n_rows":7,"n_cols":14,"rows_kept":7,"cut":false,"hidden":true,"merged":[[0,0,2,0],[0,2,0,3],[0,4,0,5],[0,6,0,7],[0,10,0,12]]}
[null,"板厚","質量",null,"全断面有効",null,"有効幅考慮",null,"長期係数","短期係数","接合強度（KN/m）",null,null,"備考"]
[null,"t","Z12","Z27","Ｉx","Ｚx","Ｉx","Ｚx","LＣ","sＣ","SPW","打込み鋲","ﾄﾞﾘﾙﾋﾞｽ"]
[null,"(mm)","(kg/m2)","(kg/m2)","(cm4)","(cm3)","(cm4)","(cm3)"]
["MA75",1.2,14.1,14.5,167.8,44.16,167.8,44.16,1,1,20,15.5,7.85,"@200"]
[null,1.6,18.8,19.3,219.8,57.99,219.8,57.99,1,1,26.6,20.6,10.4,"@150"]
[null,null,null,null,null,null,null,null,null,null,40,31,15.7,"@100"]
[null,null,null,null,null,"負曲げ用",null,"正曲げ用",null,null,53.3,41.3,20.9,"@75"]

{"sheet":"V50断面性能","index":3,"n_rows":7,"n_cols":14,"rows_kept":7,"cut":false,"hidden":true,"merged":[[0,0,2,0],[0,2,0,3],[0,4,0,5],[0,6,0,7],[0,10,0,12]]}
[null,"板厚","質量",null,"全断面有効",null,"有効幅考慮",null,"長期係数","短期係数","接合強度（KN/m）",null,null,"備考"]
[null,"t","Z12","Z27","Ｉx","Ｚx","Ｉx","Ｚx","LＣ","sＣ","SPW","打込み鋲","ﾄﾞﾘﾙﾋﾞｽ"]
[null,"(mm)","(kg/m2)","(kg/m2)","(cm4)","(cm3)","(cm4)","(cm3)"]
["V50",1.2,13.6,13.9,60.5,17.600000000000001,45,16,1.1599999999999999,1.2,19.5,15.1,7.65,"@200"]
[null,1.6,17.899999999999999,18.2,78.5,22.9,65,21.6,1.1599999999999999,1.2,26,20.100000000000001,10.199999999999999,"@150"]
[null,null,null,null,null,null,null,null,null,null,39,30.2,15.3,"@100"]
[null,null,null,null,null,"負曲げ用",null,"正曲げ用",null,null,52,40.200000000000003,20.399999999999999,"@75"]

{"sheet":"工事情報","index":4,"n_rows":5,"n_cols":14,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["工事名称","デッキ種類","基準強度","形式","ピッチ","スパン","積載荷重","仕上げ荷重","積雪の単位荷重","垂直積雪量","レベル係数","地表面粗度区分","基準風速","屋根平均高さ"]
["検収0702forMA75一般部","MA75-1.6","205 (SDP1TG)","SPW (4.0KN/箇所)","@200",4400,0,300,20,50,1,"Ⅰ",34,20]
["検収0702forMA75多雪区域","MA75-1.2","235 (SDP2G)","ドリルねじ (1.57KN/箇所)","@100",3600,0,300,20,130,1,"Ⅰ",34,20]
["検収0702forV50一般部","V50-1.6","235 (SDP2G)","ドリルねじ (1.57KN/箇所)","@100",3000,0,300,20,50,1,"Ⅰ",34,15]
["検収0702forV50多雪区域","V50-1.2","235 (SDP2G)","ドリルねじ (1.57KN/箇所)","@100",2600,0,300,20,130,1,"Ⅰ",34,20]

{"sheet":"ヘルプテキスト","index":5,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["対象オブジェクト名","表示テキスト"]
["cbb工事名称","(工事名称用ヘルプテキスト)"]
["opbMA7512","(デッキ種類用ヘルプテキスト)"]
["opbMA7516","(デッキ種類用ヘルプテキスト)"]
["opbV5012","(デッキ種類用ヘルプテキスト)"]
["opbV5016","(デッキ種類用ヘルプテキスト)"]
["opb基準強度205","(基準強度用ヘルプテキスト)"]
["opb基準強度235","(基準強度用ヘルプテキスト)"]
["opbSPW","(形式用ヘルプテキスト)"]
["opb打込み鋲","(形式用ヘルプテキスト)"]
["opbドリルねじ","(形式用ヘルプテキスト)"]
["opbピッチ200","(ピッチ用ヘルプテキスト)"]
["opbピッチ150","(ピッチ用ヘルプテキスト)"]
["opbピッチ100","(ピッチ用ヘルプテキスト)"]
["opbピッチ75","(ピッチ用ヘルプテキスト)"]
["txbスパン","(スパン用ヘルプテキスト)"]
["txb積載荷重","(積載荷重用ヘルプテキスト)"]
["txb仕上げ荷重","(仕上げ荷重用ヘルプテキスト)"]
["txb積雪の単位荷重","(積雪の単位荷重用ヘルプテキスト)"]
["txb垂直積雪量","(垂直積雪量用ヘルプテキスト)"]
["txbレベル係数","(レベル係数用ヘルプテキスト)"]
["opb地表面粗度区分1","(地表面粗度区分用ヘルプテキスト)"]
["opb地表面粗度区分2","(地表面粗度区分用ヘルプテキスト)"]
["opb地表面粗度区分3","(地表面粗度区分用ヘルプテキスト)"]
["opb地表面粗度区分4","(地表面粗度区分用ヘルプテキスト)"]
["txb基準風速","(基準風速用ヘルプテキスト)"]
["txb屋根平均高さ","(屋根平均高さ用ヘルプテキスト)"]