{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["入力シート","計算シート"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":1,"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":67,"n_cols":17,"rows_kept":67,"cut":false,"hidden":false,"merged":[[62,1,64,8],[10,1,13,1],[11,8,13,8],[10,8,10,10],[66,1,69,16],[10,16,12,16],[10,13,13,13],[11,5,12,5],[10,15,12,15],[11,7,12,7],[10,11,13,11],[2,8,3,10],[49,1,60,8],[11,6,13,6],[10,4,10,7],[10,2,11,2],[10,3,11,3],[38,1,47,8],[7,2,7,7]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"バージョン情報 ： \"&LEFT(計算シート!BC2,9)&\" / \"&TEXT(計算シート!BF2,\"yyyy.m\")","v":"バージョン情報 ： ver.22-05 / 2022.5"}]
[null,null,null,null,null,null,null,null,"設計ツール"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"　　　ブレスターH.Ttype-耐震-は岡部株式会社の木造軸組工法用の製品です。"]
[null,null,null,null,null,null,null,null,null,null,"　　　製品・本ツールに関するお問い合わせは岡部株式会社までお願い致します。"]
[null,"物件名：",null,null,null,null,null,null,null,"　　　　　","　　　製品専用WEBサイト URL：https://www.okabe.co.jp/mokuzo/brastarh-t/　"]
[]
[]
[null,"No.","柱心間\n距離\n（壁幅）","横架材心間\n距離\n（壁高さ）","柱",null,null,null,"ブレスターＨ.Ttype-耐震-取付け高さ\n偏心配置する場合はhuまたはhdの小さい方の\n距離を入力して下さい（下図参照）",null,null,"使用\n環境",null,"入力\n判定",null,"短期許容\nせん断耐力","壁倍率\n相当"]
[null,null,null,null,"柱長さ","断面寸法","木材","弾性係数\n(ヤング係数)","取付け\n位置","中央配置","偏心配置"]
[null,null,"B","h0","hC",null,null,null,null,"hu ＆ hd","hu or hd"]
[null,null,"mm","mm","mm","mm",null,"E",null,"mm","mm",null,null,null,null,"kN","倍"]
[]
[null,1,null,null,null,null,null,null,null,{"$f":"計算シート!I7","v":""},null,null,null,{"$f":"計算シート!AQ7","v":"-"},null,{"$f":"計算シート!AH7","v":"-"},{"$f":"計算シート!AI7","v":"-"}]
[null,2,null,null,null,null,null,null,null,{"$f":"計算シート!I8","v":""},null,null,null,{"$f":"計算シート!AQ8","v":"-"},null,{"$f":"計算シート!AH8","v":"-"},{"$f":"計算シート!AI8","v":"-"}]
[null,3,null,null,null,null,null,null,null,{"$f":"計算シート!I9","v":""},null,null,null,{"$f":"計算シート!AQ9","v":"-"},null,{"$f":"計算シート!AH9","v":"-"},{"$f":"計算シート!AI9","v":"-"}]
[null,4,null,null,null,null,null,null,null,{"$f":"計算シート!I10","v":""},null,null,null,{"$f":"計算シート!AQ10","v":"-"},null,{"$f":"計算シート!AH10","v":"-"},{"$f":"計算シート!AI10","v":"-"}]
[null,5,null,null,null,null,null,null,null,{"$f":"計算シート!I11","v":""},null,null,null,{"$f":"計算シート!AQ11","v":"-"},null,{"$f":"計算シート!AH11","v":"-"},{"$f":"計算シート!AI11","v":"-"}]
[null,6,null,null,null,null,null,null,null,{"$f":"計算シート!I12","v":""},null,null,null,{"$f":"計算シート!AQ12","v":"-"},null,{"$f":"計算シート!AH12","v":"-"},{"$f":"計算シート!AI12","v":"-"}]
[null,7,null,null,null,null,null,null,null,{"$f":"計算シート!I13","v":""},null,null,null,{"$f":"計算シート!AQ13","v":"-"},null,{"$f":"計算シート!AH13","v":"-"},{"$f":"計算シート!AI13","v":"-"}]
[null,8,null,null,null,null,null,null,null,{"$f":"計算シート!I14","v":""},null,null,null,{"$f":"計算シート!AQ14","v":"-"},null,{"$f":"計算シート!AH14","v":"-"},{"$f":"計算シート!AI14","v":"-"}]
[null,9,null,null,null,null,null,null,null,{"$f":"計算シート!I15","v":""},null,null,null,{"$f":"計算シート!AQ15","v":"-"},null,{"$f":"計算シート!AH15","v":"-"},{"$f":"計算シート!AI15","v":"-"}]
[null,10,null,null,null,null,null,null,null,{"$f":"計算シート!I16","v":""},null,null,null,{"$f":"計算シート!AQ16","v":"-"},null,{"$f":"計算シート!AH16","v":"-"},{"$f":"計算シート!AI16","v":"-"}]
[]
[]
[null,"本設計ツールについて"]
[null,"・下記適用範囲をご確認の上、青塗りの項目をご入力ください。物件名は必要に応じてご入力ください。"]
[null,"・横架材心間距離，柱長さ以外の項目はプルダウンリストからご選択ください。"]
[null,"・柱長さは横架材心間距離よりも小さい数字をご入力ください。"]
[null,"・入力判定でNGの場合、各項目の入力内容をご確認ください。"]
[null,"・短期許容せん断耐力の算出は耐力算出評価式を用いて算出しております。（下記参照）"]
[null,"・壁倍率相当は短期許容せん断耐力から算出した参考倍率です。（下記参照）"]
[null,"・ブレスターH.Ttype-耐震-の取付け高さは中央位置からずらした偏心位置でも取付け可能です。(下図参照)"]
[null,"　偏心位置の場合：「取付け位置」項目で「偏心」を選択し、huまたはhdの小さい方の数字をご入力ください。"]
[null,"　　　　　　　　　 また、中央配置よりも耐力は低下しますので、ご注意ください。"]
[]
[null,"ー適用範囲ー\n・梁（桁）、土台：断面寸法105mm以上\n・柱：断面寸法105～120mm，基準強度Fb：22.2N/mm2以上\n　　　製材：E50以上\n　　　集成材：同一等級E55-F225以上，対称異等級E65-F225以上\n・柱心間距離（壁幅）Ｂ：450～460mm，600～610mm\n・横架材心間距離（壁高さ）h0：2250～3185mm\n・取付け位置：横架材面からCR2プレート端部までは100mm以上離してください\n　　　　　　　（偏心する場合、huまたはhdの小さい方の距離が100mm以上必要です）\n\n※本工法は大臣認定壁倍率を取得しておりません。\n　許容応力度計算などの構造計算が必要になります。（46条2項ルート）"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ー耐力算出評価式ー\n\n\n　Pa：短期許容せん断耐力[N]　　K0：せん断一次剛性[N/mm]　　h0：横架材心間距離[mm]\n　α：低減係数（使用環境Ⅰ：0.66，使用環境Ⅱ：0.76，使用環境Ⅲ：0.95）\n\n\n\n\n　h0：横架材心間距離[mm]　　hP：800[mm]　　kP：T type=6700[N/mm]　　a：0.7\n　kB：4.5×107[N・mm/rad.]　hu：CR2プレート上端から横架材下面までの長さ[mm]\n　hd：CR2プレート下端から横架材上面（土台上面）までの長さ[mm]\n　I：柱の断面二次モーメント[mm4]　　E：柱の弾性係数（ヤング係数）[N/mm2]\n　kV：6400[N/mm]　　B：柱心間距離[mm]"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ー壁倍率相当の算出方法ー\n・壁倍率相当は短期許容せん断耐力(Pa)および柱心間距離から算出した参考倍率です。\n　壁倍率相当=Pa[kN]/(柱心間距離[m]×1.96[kN/m])"]
[]
[]
[]
[null,"※注意事項\n　本設計ツールで出力される耐力・剛性・検定結果は，計算条件ならびに当社の知見に基づき結果の有効性を示したものであり，実施にあたっては工事・設計関係者の確認・承認を要する内容もございます。\n　なお，検討結果と異なる諸事情ならびに諸条件によって結果が異なる場合がございますことをあらかじめご了承ください。\n　本ツールには、，BAマクロを使用しております。ツール使用時は，マクロを有効にしてご使用ください。 Windows 10 / Microsoft Excel for Office 365 MSO で作成および動作確認を行っております。\n　上記以外の環境につきましては，想定していない動作をする可能性がありますのであらかじめご了承ください。\n　Windows / ExcelはMicrosoft社の商標です。"]

{"sheet":"計算シート","index":1,"n_rows":29,"n_cols":58,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
[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,null,null,"バージョン","ver.22-05.1.0.1.2",null,"更新日","2022-05-12"]
[]
[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,"h0","kp","hp","kB","huまたはhd","huまたはhd","E","I","a","kV","B",null,"δP","δWu","δWd","δR","δ0",null,"K0","P0","α","Pa","壁倍率",null,"壁幅判定","壁高さ判定","柱断面判定","柱長さ","ヤング判定","取付け判定","総合判定",null,"柱サイズ","木材","弾性係数","弾性係数","取付位置","壁幅","使用環境","使用環境"]
[null,"mm","mm","mm","mm",null,"E",null,null,"mm",null,null,"mm","N/mm","mm","N・mm/rad.","mm","mm","N/mm2","mm4",0.7,"N/mm","mm",null,"mm","mm","mm","mm","mm",null,"N/mm","kN",null,"kN","倍",null,null,null,null,null,null,null,null,null,null,null,null,"N/mm2"]
[null,{"$f":"入力シート!C16","v":0},{"$f":"入力シート!D16","v":0},{"$f":"入力シート!E16","v":0},{"$f":"入力シート!F16","v":0},{"$f":"入力シート!G16","v":0},{"$f":"入力シート!H16","v":0},{"$f":"入力シート!I16","v":0},{"$f":"IF(ISTEXT(H7),IF(H7=\"中央\",D7/2-O7/2,\"入力⇒\"),\"\")","v":""},{"$f":"IF(H7=\"中央\",I7,入力シート!K16)","v":0},{"$f":"入力シート!L16","v":0},null,{"$f":"C7","v":0},6700,800,45000000,{"$f":"IF(J7=0,\"\",J7)","v":""},{"$f":"D7-O7-Q7","v":{"$error":"#VALUE!"}},{"$f":"IF(F7=\"製材\",VLOOKUP(G7,$AU$7:$AV$12,2,FALSE),IF(F7=\"集成材\",VLOOKUP(G7,$AU$14:$AV$24,2,FALSE),\"\"))","v":""},{"$f":"E7^4/12","v":0},{"$f":"$U$6","v":0.7},6400,{"$f":"B7","v":0},null,{"$f":"(M7^2)/(N7*(O7^2))","v":0},{"$f":"((1/2)-(U7*P7*Q7)/(4*S7*T7))*(Q7^3)/(3*S7*T7)","v":{"$error":"#VALUE!"}},{"$f":"((1/2)-(U7*P7*R7)/(4*S7*T7))*(R7^3)/(3*S7*T7)","v":{"$error":"#VALUE!"}},{"$f":"M7/(V7*W7)","v":{"$error":"#DIV/0!"}},{"$f":"Y7+Z7+AA7+AB7","v":{"$error":"#VALUE!"}},null,{"$f":"1/AC7","v":{"$error":"#VALUE!"}},{"$f":"AE7*(M7/120)/1000","v":{"$error":"#VALUE!"}},{"$f":"IF(K7=3,$AZ$9,IF(K7=2,$AZ$8,IF(K7=1,$AZ$7,\"-\")))","v":"-"},{"$f":"IF(AQ7=\"OK\",IF(AG7=\"-\",\"-\",ROUNDDOWN(AF7*AG7,2)),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(AH7),ROUNDDOWN(AH7/B7*1000/1.96,1),\"-\")","v":"-"},null,{"$f":"IF(ISNUMBER(入力シート!C16),IF(AND(入力シート!C16>=450,入力シート!C16<=460),\"OK\",IF(AND(入力シート!C16>=600,入力シート!C16<=610),\"OK\",\"NG\")),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!D16),IF(AND(2250<=C7,C7<=3185),\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!F16),IF(AND(105<=E7,E7<=120),\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!E16),IF(D7<C7,\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!H16),IF(入力シート!G16=\"製材\",IF(COUNTIF(計算シート!$AU$7:$AU$12,入力シート!H16),\"OK\",\"NG\"),IF(入力シート!G16=\"集成材\",IF(COUNTIF(計算シート!$AU$14:$AU$24,入力シート!H16),\"OK\",\"NG\"),\"NG\")),\"-\")","v":"-"},{"$f":"IF(ISTEXT(H7),IF(H7=\"中央\",\"OK\",IF(AND(100<=J7,J7<=D7/2-O7/2),\"OK\",\"NG\")),\"-\")","v":"-"},{"$f":"IF(AND(AK7:AP7=\"OK\"),\"OK\",IF(COUNTIF(AK7:AP7,\"NG\"),\"NG\",\"-\"))","v":"-"},null,105,"製材",50,4900,"中央",450,1,0.66]
[null,{"$f":"入力シート!C17","v":0},{"$f":"入力シート!D17","v":0},{"$f":"入力シート!E17","v":0},{"$f":"入力シート!F17","v":0},{"$f":"入力シート!G17","v":0},{"$f":"入力シート!H17","v":0},{"$f":"入力シート!I17","v":0},{"$f":"IF(ISTEXT(H8),IF(H8=\"中央\",D8/2-O8/2,\"入力⇒\"),\"\")","v":""},{"$f":"IF(H8=\"中央\",I8,入力シート!K17)","v":0},{"$f":"入力シート!L17","v":0},null,{"$f":"C8","v":0},6700,800,45000000,{"$f":"IF(J8=0,\"\",J8)","v":""},{"$f":"D8-O8-Q8","v":{"$error":"#VALUE!"}},{"$f":"IF(F8=\"製材\",VLOOKUP(G8,$AU$7:$AV$12,2,FALSE),IF(F8=\"集成材\",VLOOKUP(G8,$AU$14:$AV$24,2,FALSE),\"\"))","v":""},{"$f":"E8^4/12","v":0},{"$f":"$U$6","v":0.7},6400,{"$f":"B8","v":0},null,{"$f":"(M8^2)/(N8*(O8^2))","v":0},{"$f":"((1/2)-(U8*P8*Q8)/(4*S8*T8))*(Q8^3)/(3*S8*T8)","v":{"$error":"#VALUE!"}},{"$f":"((1/2)-(U8*P8*R8)/(4*S8*T8))*(R8^3)/(3*S8*T8)","v":{"$error":"#VALUE!"}},{"$f":"M8/(V8*W8)","v":{"$error":"#DIV/0!"}},{"$f":"Y8+Z8+AA8+AB8","v":{"$error":"#VALUE!"}},null,{"$f":"1/AC8","v":{"$error":"#VALUE!"}},{"$f":"AE8*(M8/120)/1000","v":{"$error":"#VALUE!"}},{"$f":"IF(K8=3,$AZ$9,IF(K8=2,$AZ$8,IF(K8=1,$AZ$7,\"-\")))","v":"-"},{"$f":"IF(AQ8=\"OK\",IF(AG8=\"-\",\"-\",ROUNDDOWN(AF8*AG8,2)),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(AH8),ROUNDDOWN(AH8/B8*1000/1.96,1),\"-\")","v":"-"},null,{"$f":"IF(ISNUMBER(入力シート!C17),IF(AND(入力シート!C17>=450,入力シート!C17<=460),\"OK\",IF(AND(入力シート!C17>=600,入力シート!C17<=610),\"OK\",\"NG\")),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!D17),IF(AND(2250<=C8,C8<=3185),\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!F17),IF(AND(105<=E8,E8<=120),\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!E17),IF(D8<C8,\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!H17),IF(入力シート!G17=\"製材\",IF(COUNTIF(計算シート!$AU$7:$AU$12,入力シート!H17),\"OK\",\"NG\"),IF(入力シート!G17=\"集成材\",IF(COUNTIF(計算シート!$AU$14:$AU$24,入力シート!H17),\"OK\",\"NG\"),\"NG\")),\"-\")","v":"-"},"-",{"$f":"IF(AND(AK8:AP8=\"OK\"),\"OK\",IF(COUNTIF(AK8:AP8,\"NG\"),\"NG\",\"-\"))","v":"-"},null,120,"集成材",70,6900,"偏心",451,2,0.76]
[null,{"$f":"入力シート!C18","v":0},{"$f":"入力シート!D18","v":0},{"$f":"入力シート!E18","v":0},{"$f":"入力シート!F18","v":0},{"$f":"入力シート!G18","v":0},{"$f":"入力シート!H18","v":0},{"$f":"入力シート!I18","v":0},"",{"$f":"IF(H9=\"中央\",I9,入力シート!K18)","v":0},{"$f":"入力シート!L18","v":0},null,0,6700,800,45000000,"",{"$error":"#VALUE!"},"",0,0.7,6400,0,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"-","-","-",null,{"$f":"IF(ISNUMBER(入力シート!C18),IF(AND(入力シート!C18>=450,入力シート!C18<=460),\"OK\",IF(AND(入力シート!C18>=600,入力シート!C18<=610),\"OK\",\"NG\")),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!D18),IF(AND(2250<=C9,C9<=3185),\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!F18),IF(AND(105<=E9,E9<=120),\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!E18),IF(D9<C9,\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!H18),IF(入力シート!G18=\"製材\",IF(COUNTIF(計算シート!$AU$7:$AU$12,入力シート!H18),\"OK\",\"NG\"),IF(入力シート!G18=\"集成材\",IF(COUNTIF(計算シート!$AU$14:$AU$24,入力シート!H18),\"OK\",\"NG\"),\"NG\")),\"-\")","v":"-"},"-",{"$f":"IF(AND(AK9:AP9=\"OK\"),\"OK\",IF(COUNTIF(AK9:AP9,\"NG\"),\"NG\",\"-\"))","v":"-"},null,null,null,90,8800,null,452,3,0.95]
[null,{"$f":"入力シート!C19","v":0},{"$f":"入力シート!D19","v":0},{"$f":"入力シート!E19","v":0},{"$f":"入力シート!F19","v":0},{"$f":"入力シート!G19","v":0},{"$f":"入力シート!H19","v":0},{"$f":"入力シート!I19","v":0},"",{"$f":"IF(H10=\"中央\",I10,入力シート!K19)","v":0},{"$f":"入力シート!L19","v":0},null,0,6700,800,45000000,"",{"$error":"#VALUE!"},"",0,0.7,6400,0,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"-","-","-",null,{"$f":"IF(ISNUMBER(入力シート!C19),IF(AND(入力シート!C19>=450,入力シート!C19<=460),\"OK\",IF(AND(入力シート!C19>=600,入力シート!C19<=610),\"OK\",\"NG\")),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!D19),IF(AND(2250<=C10,C10<=3185),\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!F19),IF(AND(105<=E10,E10<=120),\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!E19),IF(D10<C10,\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!H19),IF(入力シート!G19=\"製材\",IF(COUNTIF(計算シート!$AU$7:$AU$12,入力シート!H19),\"OK\",\"NG\"),IF(入力シート!G19=\"集成材\",IF(COUNTIF(計算シート!$AU$14:$AU$24,入力シート!H19),\"OK\",\"NG\"),\"NG\")),\"-\")","v":"-"},"-",{"$f":"IF(AND(AK10:AP10=\"OK\"),\"OK\",IF(COUNTIF(AK10:AP10,\"NG\"),\"NG\",\"-\"))","v":"-"},null,null,null,110,10800,null,453]
[null,{"$f":"入力シート!C20","v":0},{"$f":"入力シート!D20","v":0},{"$f":"入力シート!E20","v":0},{"$f":"入力シート!F20","v":0},{"$f":"入力シート!G20","v":0},{"$f":"入力シート!H20","v":0},{"$f":"入力シート!I20","v":0},"",{"$f":"IF(H11=\"中央\",I11,入力シート!K20)","v":0},{"$f":"入力シート!L20","v":0},null,0,6700,800,45000000,"",{"$error":"#VALUE!"},"",0,0.7,6400,0,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"-","-","-",null,{"$f":"IF(ISNUMBER(入力シート!C20),IF(AND(入力シート!C20>=450,入力シート!C20<=460),\"OK\",IF(AND(入力シート!C20>=600,入力シート!C20<=610),\"OK\",\"NG\")),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!D20),IF(AND(2250<=C11,C11<=3185),\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!F20),IF(AND(105<=E11,E11<=120),\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!E20),IF(D11<C11,\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!H20),IF(入力シート!G20=\"製材\",IF(COUNTIF(計算シート!$AU$7:$AU$12,入力シート!H20),\"OK\",\"NG\"),IF(入力シート!G20=\"集成材\",IF(COUNTIF(計算シート!$AU$14:$AU$24,入力シート!H20),\"OK\",\"NG\"),\"NG\")),\"-\")","v":"-"},"-",{"$f":"IF(AND(AK11:AP11=\"OK\"),\"OK\",IF(COUNTIF(AK11:AP11,\"NG\"),\"NG\",\"-\"))","v":"-"},null,null,null,130,12700,null,454]
[null,{"$f":"入力シート!C21","v":0},{"$f":"入力シート!D21","v":0},{"$f":"入力シート!E21","v":0},{"$f":"入力シート!F21","v":0},{"$f":"入力シート!G21","v":0},{"$f":"入力シート!H21","v":0},{"$f":"入力シート!I21","v":0},"",{"$f":"IF(H12=\"中央\",I12,入力シート!K21)","v":0},{"$f":"入力シート!L21","v":0},null,0,6700,800,45000000,"",{"$error":"#VALUE!"},"",0,0.7,6400,0,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"-","-","-",null,{"$f":"IF(ISNUMBER(入力シート!C21),IF(AND(入力シート!C21>=450,入力シート!C21<=460),\"OK\",IF(AND(入力シート!C21>=600,入力シート!C21<=610),\"OK\",\"NG\")),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!D21),IF(AND(2250<=C12,C12<=3185),\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!F21),IF(AND(105<=E12,E12<=120),\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!E21),IF(D12<C12,\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!H21),IF(入力シート!G21=\"製材\",IF(COUNTIF(計算シート!$AU$7:$AU$12,入力シート!H21),\"OK\",\"NG\"),IF(入力シート!G21=\"集成材\",IF(COUNTIF(計算シート!$AU$14:$AU$24,入力シート!H21),\"OK\",\"NG\"),\"NG\")),\"-\")","v":"-"},"-",{"$f":"IF(AND(AK12:AP12=\"OK\"),\"OK\",IF(COUNTIF(AK12:AP12,\"NG\"),\"NG\",\"-\"))","v":"-"},null,null,null,150,14700,null,455]
[null,{"$f":"入力シート!C22","v":0},{"$f":"入力シート!D22","v":0},{"$f":"入力シート!E22","v":0},{"$f":"入力シート!F22","v":0},{"$f":"入力シート!G22","v":0},{"$f":"入力シート!H22","v":0},{"$f":"入力シート!I22","v":0},"",{"$f":"IF(H13=\"中央\",I13,入力シート!K22)","v":0},{"$f":"入力シート!L22","v":0},null,0,6700,800,45000000,"",{"$error":"#VALUE!"},"",0,0.7,6400,0,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"-","-","-",null,{"$f":"IF(ISNUMBER(入力シート!C22),IF(AND(入力シート!C22>=450,入力シート!C22<=460),\"OK\",IF(AND(入力シート!C22>=600,入力シート!C22<=610),\"OK\",\"NG\")),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!D22),IF(AND(2250<=C13,C13<=3185),\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!F22),IF(AND(105<=E13,E13<=120),\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!E22),IF(D13<C13,\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!H22),IF(入力シート!G22=\"製材\",IF(COUNTIF(計算シート!$AU$7:$AU$12,入力シート!H22),\"OK\",\"NG\"),IF(入力シート!G22=\"集成材\",IF(COUNTIF(計算シート!$AU$14:$AU$24,入力シート!H22),\"OK\",\"NG\"),\"NG\")),\"-\")","v":"-"},"-",{"$f":"IF(AND(AK13:AP13=\"OK\"),\"OK\",IF(COUNTIF(AK13:AP13,\"NG\"),\"NG\",\"-\"))","v":"-"},null,null,null,null,null,null,456]
[null,{"$f":"入力シート!C23","v":0},{"$f":"入力シート!D23","v":0},{"$f":"入力シート!E23","v":0},{"$f":"入力シート!F23","v":0},{"$f":"入力シート!G23","v":0},{"$f":"入力シート!H23","v":0},{"$f":"入力シート!I23","v":0},"",{"$f":"IF(H14=\"中央\",I14,入力シート!K23)","v":0},{"$f":"入力シート!L23","v":0},null,0,6700,800,45000000,"",{"$error":"#VALUE!"},"",0,0.7,6400,0,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"-","-","-",null,{"$f":"IF(ISNUMBER(入力シート!C23),IF(AND(入力シート!C23>=450,入力シート!C23<=460),\"OK\",IF(AND(入力シート!C23>=600,入力シート!C23<=610),\"OK\",\"NG\")),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!D23),IF(AND(2250<=C14,C14<=3185),\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!F23),IF(AND(105<=E14,E14<=120),\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!E23),IF(D14<C14,\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!H23),IF(入力シート!G23=\"製材\",IF(COUNTIF(計算シート!$AU$7:$AU$12,入力シート!H23),\"OK\",\"NG\"),IF(入力シート!G23=\"集成材\",IF(COUNTIF(計算シート!$AU$14:$AU$24,入力シート!H23),\"OK\",\"NG\"),\"NG\")),\"-\")","v":"-"},"-",{"$f":"IF(AND(AK14:AP14=\"OK\"),\"OK\",IF(COUNTIF(AK14:AP14,\"NG\"),\"NG\",\"-\"))","v":"-"},null,null,null,55,5500,null,457]
[null,{"$f":"入力シート!C24","v":0},{"$f":"入力シート!D24","v":0},{"$f":"入力シート!E24","v":0},{"$f":"入力シート!F24","v":0},{"$f":"入力シート!G24","v":0},{"$f":"入力シート!H24","v":0},{"$f":"入力シート!I24","v":0},"",{"$f":"IF(H15=\"中央\",I15,入力シート!K24)","v":0},{"$f":"入力シート!L24","v":0},null,0,6700,800,45000000,"",{"$error":"#VALUE!"},"",0,0.7,6400,0,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"-","-","-",null,{"$f":"IF(ISNUMBER(入力シート!C24),IF(AND(入力シート!C24>=450,入力シート!C24<=460),\"OK\",IF(AND(入力シート!C24>=600,入力シート!C24<=610),\"OK\",\"NG\")),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!D24),IF(AND(2250<=C15,C15<=3185),\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!F24),IF(AND(105<=E15,E15<=120),\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!E24),IF(D15<C15,\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!H24),IF(入力シート!G24=\"製材\",IF(COUNTIF(計算シート!$AU$7:$AU$12,入力シート!H24),\"OK\",\"NG\"),IF(入力シート!G24=\"集成材\",IF(COUNTIF(計算シート!$AU$14:$AU$24,入力シート!H24),\"OK\",\"NG\"),\"NG\")),\"-\")","v":"-"},"-",{"$f":"IF(AND(AK15:AP15=\"OK\"),\"OK\",IF(COUNTIF(AK15:AP15,\"NG\"),\"NG\",\"-\"))","v":"-"},null,null,null,65,6500,null,458]
[null,{"$f":"入力シート!C25","v":0},{"$f":"入力シート!D25","v":0},{"$f":"入力シート!E25","v":0},{"$f":"入力シート!F25","v":0},{"$f":"入力シート!G25","v":0},{"$f":"入力シート!H25","v":0},{"$f":"入力シート!I25","v":0},"",{"$f":"IF(H16=\"中央\",I16,入力シート!K25)","v":0},{"$f":"入力シート!L25","v":0},null,0,6700,800,45000000,"",{"$error":"#VALUE!"},"",0,0.7,6400,0,null,0,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"-","-","-",null,{"$f":"IF(ISNUMBER(入力シート!C25),IF(AND(入力シート!C25>=450,入力シート!C25<=460),\"OK\",IF(AND(入力シート!C25>=600,入力シート!C25<=610),\"OK\",\"NG\")),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!D25),IF(AND(2250<=C16,C16<=3185),\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!F25),IF(AND(105<=E16,E16<=120),\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!E25),IF(D16<C16,\"OK\",\"NG\"),\"-\")","v":"-"},{"$f":"IF(ISNUMBER(入力シート!H25),IF(入力シート!G25=\"製材\",IF(COUNTIF(計算シート!$AU$7:$AU$12,入力シート!H25),\"OK\",\"NG\"),IF(入力シート!G25=\"集成材\",IF(COUNTIF(計算シート!$AU$14:$AU$24,入力シート!H25),\"OK\",\"NG\"),\"NG\")),\"-\")","v":"-"},"-",{"$f":"IF(AND(AK16:AP16=\"OK\"),\"OK\",IF(COUNTIF(AK16:AP16,\"NG\"),\"NG\",\"-\"))","v":"-"},null,null,null,75,7500,null,459]
[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,85,8500,null,460]
[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,95,9500]
[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,105,10500,null,600]
[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,120,12000,null,601]
[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,135,13500,null,602]
[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,150,15000,null,603]
[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,170,17000,null,604]
[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,190,19000,null,605]
[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,606]
[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,607]
[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,608]
[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,609]
[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,610]