{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["積算表１","積算結果集計シート","マットの離隔距離について"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":181,"n_cols":15,"rows_kept":181,"cut":false,"hidden":false,"merged":[[55,11,55,12],[0,13,0,15],[9,9,9,11],[9,12,9,14],[54,11,54,12],[53,11,53,12],[69,5,69,6],[70,5,70,6],[78,6,78,8],[61,1,61,15],[58,7,58,14],[64,7,64,14],[80,12,80,15],[79,12,79,15],[75,13,75,15],[76,13,76,15],[77,13,77,15],[78,13,78,15]]}
["タフロックロクマックス材料積算シート（黄色部分だけ入力できるようにしております）",null,null,null,null,null,null,null,null,null,null,null,null,20250207]
[null,"件名："]
[null,"工事店："]
[null,"担当営業所："]
["①配管種類の記入（該当配管サイズをプルダウンメニューから選んでください）"]
[null,"系統（現場使われる配管種類を記載してください）"]
["系統№","液","断面積","ガス１","断面積","ガス２","断面積","断面積合計"]
[0,null,null,null,null,null,null,0]
[1,null,{"$f":"VLOOKUP(B9,$A$89:$B$117,2,FALSE)","v":0},null,{"$f":"VLOOKUP(D9,$A$89:$B$117,2,FALSE)","v":0},null,{"$f":"VLOOKUP(F9,$A$89:$B$117,2,FALSE)","v":0},{"$f":"SUM(C9+E9+G9)","v":0}]
[2,null,{"$f":"VLOOKUP(B10,$A$89:$B$117,2,FALSE)","v":0},null,{"$f":"VLOOKUP(D10,$A$89:$B$117,2,FALSE)","v":0},null,{"$f":"VLOOKUP(F10,$A$89:$B$117,2,FALSE)","v":0},{"$f":"SUM(C10+E10+G10)","v":0},null,"被覆厚１０（８）",null,null,"被覆厚２０"]
[3,null,0,null,0,null,0,0,null,"№","銅管サイズ","断面積","№","銅管サイズ","断面積"]
[4,null,0,null,0,null,0,0,null,1,"6.35(8)",{"$f":"B90","v":392.33},16,"6.35(20)",{"$f":"B105","v":1687.29}]
[5,null,0,null,0,null,0,0,null,2,"9.52(8)",{"$f":"B91","v":511.51},17,"9.52(20)",{"$f":"B106","v":1925.98}]
[6,null,0,null,0,null,0,0,null,3,"6.35(10)",545.31999999999994,18,"12.7(20)",2181.2800000000002]
[7,null,0,null,0,null,0,0,null,4,"9.52(10)",684.42,19,"15.88(20)",2452.4700000000003]
[8,null,0,null,0,null,{"$f":"VLOOKUP(F16,$A$89:$B$117,2,FALSE)","v":0},0,null,5,"12.7(10)",839.81999999999994,20,"19.05(20)",2738.61]
[9,null,0,null,0,null,0,0,null,6,"15.88(10)",1011.11,21,"22.22(20)",3040.5400000000004]
[10,null,0,null,0,null,0,0,null,7,"19.05(10)",1197.6600000000001,22,"25.4(20)",3359.28]
[11,null,0,null,0,null,0,0,null,8,"22.22(10)",1400,23,"28.58(20)",3693.9]
[12,null,0,null,0,null,0,0,null,9,"25.4(10)",1618.84,24,"31.75(20)",4043.28]
[13,null,0,null,0,null,0,0,null,10,"28.58(10)",1853.56,25,"34.92(20)",4408.45]
[14,null,0,null,0,null,0,0,null,11,"31.75(10)",2103.3500000000004,26,"38.1(20)",4790.63]
[15,null,0,null,0,null,0,0,null,12,"34.92(10)",2368.9300000000003,27,"41.28(20)",5188.6900000000005]
[16,null,0,null,0,null,0,0,null,13,"38.1(10)",2651.2000000000003,28,"44.45(20)",5601.31]
[17,null,0,null,0,null,0,0,null,14,"41.28(10)",2949.36]
[18,null,0,null,0,null,0,0,null,15,"44.45(10)",3262.3900000000003]
[19,null,0,null,0,null,0,0]
[20,null,0,null,0,null,0,0]
[]
[]
[]
["②配管束組み合わせ確認（開口に入る配管種類を上記の系統№で入力して配管束の組み合わせを決めてください）"]
[null,"配管系統１","断面積","配管系統２","断面積","配管系統３","断面積","配管系統４","断面積","配管系統５","断面積","配管系統６","断面積","合計断面積","適用マット"]
["配管束１",null,{"$f":"VLOOKUP(B34,$A$8:$H$28,8)","v":0},null,{"$f":"VLOOKUP(D34,$A$8:$H$28,8)","v":0},null,{"$f":"VLOOKUP(F34,$A$8:$H$28,8)","v":0},null,{"$f":"VLOOKUP(H34,$A$8:$H$28,8)","v":0},null,{"$f":"VLOOKUP(J34,$A$8:$H$28,8)","v":0},null,{"$f":"VLOOKUP(L34,$A$8:$H$28,8)","v":0},{"$f":"SUM(C34+E34+G34+I34+K34+M34)","v":0},{"$f":"LOOKUP(N34,A119:A122,B119:B122)","v":0}]
["配管束２",null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"LOOKUP(N35,A119:A122,B119:B122)","v":0}]
["配管束３",null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"LOOKUP(N36,A119:A122,B119:B122)","v":0}]
["配管束４",null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"LOOKUP(N37,A119:A122,B119:B122)","v":0}]
["配管束５",null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"LOOKUP(N38,A119:A122,B119:B122)","v":0}]
["配管束６",null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"LOOKUP(N39,A119:A122,B119:B122)","v":0}]
["配管束７",null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"LOOKUP(N40,A119:A122,B119:B122)","v":0}]
["配管束８",null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"LOOKUP(N41,A119:A122,B119:B122)","v":0}]
["配管束９",null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"LOOKUP(N42,A119:A122,B119:B122)","v":0}]
["配管束１０",null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"LOOKUP(N43,A119:A122,B119:B122)","v":0}]
["配管束１１",null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"LOOKUP(N44,A119:A122,B119:B122)","v":0}]
["配管束１２",null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"LOOKUP(N45,A119:A122,B119:B122)","v":0}]
["配管束１３",null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"LOOKUP(N46,A119:A122,B119:B122)","v":0}]
["配管束１４",null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"LOOKUP(N47,A119:A122,B119:B122)","v":0}]
["配管束１５",null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"LOOKUP(N48,A119:A122,B119:B122)","v":0}]
["配管束１６",null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"LOOKUP(N49,A119:A122,B119:B122)","v":0}]
["配管束１７",null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"LOOKUP(N50,A119:A122,B119:B122)","v":0}]
["配管束１８",null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"LOOKUP(N51,A119:A122,B119:B122)","v":0}]
["配管束１９",null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"LOOKUP(N52,A119:A122,B119:B122)","v":0}]
["配管束２０",null,0,null,0,null,0,null,0,null,0,null,0,0,{"$f":"LOOKUP(N53,A119:A122,B119:B122)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"総系統数",null,{"$f":"COUNTIF(B34:M53,\">20\")","v":0},"系統"]
[null,null,null,null,null,null,null,null,null,null,null,"総系統断面積",null,{"$f":"SUM(N34:N53)","v":0},"㎟"]
[null,null,null,null,null,null,null,null,null,null,null,"配管束数",null,{"$f":"COUNTIF(C34:C53,\">20\")","v":0},"束"]
["③配管束一つに対し横２００㎜×縦２００㎜のサイズで並べる。"]
[]
[null,"横(㎜）","×","縦（㎜）","＝","開口面積（㎡）",null,{"$f":"IFERROR(LOOKUP(A172,A173:A176,B173:B176),\"-\")","v":"-"}]
[null,null,null,null,null,{"$f":"SUM(B60*D60)/1000000","v":0},null,{"$f":"LOOKUP(F60,A163:A165,B163:B165)","v":"０．７５㎡を超える場合は認定になりません。"}]
[null,"※横と縦が２００㎜で整数として割り切れない場合には、配管種類によって施工ができなくなることがありますのでご注意ください。"]
[]
["④占積率"]
[]
[null,"配管面積（㎡）","÷","開口面積（㎡）","＝","占積率（％）",null,{"$f":"IFERROR(LOOKUP(F66,A178:A181,B178:B181),\"-\")","v":"-"}]
[null,{"$f":"SUM(N55/1000000)","v":0},null,{"$f":"IFERROR(F60,\" \")","v":0},null,{"$f":"IFERROR(B66/D66, \" \")","v":" "},null,"※３5％以上は認定になりません。作業しやすいのは２０～２５％くらいです。"]
[]
["⑤非占積率（ブロックの充填面積）"]
[]
[null,"開口面積（㎡）","×","非占積率（％）","＝","非占積面積（㎡）"]
[null,{"$f":"SUM(F60)","v":0},null,{"$f":"IFERROR((1-F66),\" \")","v":" "},null,{"$f":"IFERROR(B71*D71,\" \")","v":" "},null,"この面積に対応するＴＡＦRXB（RXBY）を選定する。"]
[null,null,null,null,null,null,null,"０．２４㎡以上は、組み合わせて選定する。"]
[]
["※床施工の場合、別途、鋼製スリーブと支持板、もしくは支持金具と支持板が必要になります。",null,null,null,null,null,null,null,null,null,null,null,null,"※データ転記は積算結果を積算結果"]
["※壁施工の場合、中空壁(壁厚100を超える場合)なら鋼製開口補強枠が必要になります。",null,null,null,null,null,null,null,null,null,null,null,null,"集計シートに転記します。"]
["※厚さについては、認定条件通りとします。",null,null,null,null,null,null,null,null,null,null,null,null,"※データクリア①は①配管種類の表をクリア"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"にします。"]
["積算結果",null,null,null,null,null,null,null,null,null,null,null,null,"※データクリア②は②配管束組み合わせ表を"]
[null,null,null,null,null,null,"認定・施工条件チェック",null,null,null,null,null,null,"クリアにします。"]
[null,"開口サイズ（㎜）",null,null,"占積率","総系統数","開口面積","占積率","配管束配置",null,"ＴＡＦRXＭＴ－Ｍ","ＴＡＦRXＭＴ－Ｌ","ブロック"]
[null,{"$f":"B60","v":0},"×",{"$f":"D60","v":0},{"$f":"F66","v":" "},{"$f":"SUM(N54)","v":0},{"$f":"IFERROR(LOOKUP(F60,A164:A165,C164:C165),\"-\")","v":"-"},{"$f":"IFERROR(LOOKUP(F66,A178:A181,C178:C181),\"-\")","v":"-"},{"$f":"IFERROR(LOOKUP(A172,A174:A176,C174:C176),\"-\")","v":"-"},{"$f":"COUNTIF($O$34:$O$53,#REF!)","v":0},{"$f":"COUNTIF($O$34:$O$53,B120)","v":0},{"$f":"COUNTIF($O$34:$O$53,B121)","v":0},{"$f":"IFERROR(LOOKUP(F71,A124:A162,B124:B162),\"　\")","v":"　"}]
[null,"このページを印刷することで、各マットにどの配管束を巻きつけるのかの記録を残すことができます。"]
[null,"また、積算表シートをコピーすることで、別の施工箇所用の積算シートとして使用することができます。（データ転記も可能です）"]
[null,"このシートでの計算結果はあくまでも概算用ですので、実際の施工状況では必要数量が異なる場合がございます。"]
[]
[]
[]
[null,"断面積","銅管","被覆厚"]
[0]
["6.35(8)",{"$f":"ROUNDUP(((C90+D90*2)/2)^2*PI(),2)","v":392.33},6.35,8]
["9.52(8)",{"$f":"ROUNDUP(((C91+D91*2)/2)^2*PI(),2)","v":511.51},9.52,8]
["6.35(10)",545.31999999999994,6.35,10]
["9.52(10)",684.42,9.52,10]
["12.7(10)",839.81999999999994,12.7,10]
["15.88(10)",1011.11,15.88,10]
["19.05(10)",1197.6600000000001,19.05,10]
["22.22(10)",1400,22.22,10]
["25.4(10)",1618.84,25.4,10]
["28.58(10)",1853.56,28.58,10]
["31.75(10)",2103.3500000000004,31.75,10]
["34.92(10)",2368.9300000000003,34.92,10]
["38.1(10)",2651.2000000000003,38.1,10]
["41.28(10)",2949.36,41.28,10]
["44.45(10)",3262.3900000000003,44.45,10]
["6.35(20)",1687.29,6.35,20]
["9.52(20)",1925.98,9.52,20]
["12.7(20)",2181.2800000000002,12.7,20]
["15.88(20)",2452.4700000000003,15.88,20]
["19.05(20)",2738.61,19.05,20]
["22.22(20)",3040.5400000000004,22.22,20]
["25.4(20)",3359.28,25.4,20]
["28.58(20)",3693.9,28.58,20]
["31.75(20)",4043.28,31.75,20]
["34.92(20)",4408.45,34.92,20]
["38.1(20)",4790.63,38.1,20]
["41.28(20)",5188.6900000000005,41.28,20]
["44.45(20)",5601.31,44.45,20]
[]
[0,0]
[100,"ＴＡＦRXＭＴ－M"]
[6057,"ＴＡＦRXＭＴ－L"]
[12363,"NG"]
[]
[0,0]
[0.01,"TAFRXB(Y)-006"]
[3.1E-2,"TAFRXB(Y)-006"]
[6.0999999999999999E-2,"TAFRXB(Y)-008"]
[8.1000000000000003E-2,"TAFRXB(Y)-010"]
[0.10100000000000001,"TAFRXB(Y)-012"]
[0.121,"TAFRXB(Y)-014"]
[0.14099999999999999,"TAFRXB(Y)-016"]
[0.161,"TAFRXB(Y)-018"]
[0.18099999999999999,"TAFRXB(Y)-020"]
[0.20100000000000001,"TAFRXB(Y)-022"]
[0.221,"TAFRXB(Y)-024"]
[0.24099999999999999,"TAFRXB(Y)-026"]
[0.26100000000000001,"TAFRXB(Y)-022とTAFRXB(Y)-006"]
[0.28100000000000003,"TAFRXB(Y)-024とTAFRXB(Y)-006"]
[0.30099999999999999,"TAFRXB(Y)-026とTAFRXB(Y)-006"]
[0.32100000000000001,"TAFRXB(Y)-026とTAFRXB(Y)-008"]
[0.34100000000000003,"TAFRXB(Y)-026とTAFRXB(Y)-010"]
[0.36099999999999999,"TAFRXB(Y)-026とTAFRXB(Y)-012"]
[0.38100000000000001,"TAFRXB(Y)-026とTAFRXB(Y)-014"]
[0.40100000000000002,"TAFRXB(Y)-026とTAFRXB(Y)-016"]
[0.42099999999999999,"TAFRXB(Y)-026とTAFRXB(Y)-018"]
[0.441,"TAFRXB(Y)-026とTAFRXB(Y)-020"]
[0.46100000000000002,"TAFRXB(Y)-026とTAFRXB(Y)-022"]
[0.48099999999999998,"TAFRXB(Y)-026とTAFRXB(Y)-024"]
[0.501,"TAFRXB(Y)-026：２組"]
[0.52100000000000002,"TAFRXB(Y)-026とTAFRXB(Y)-022とTAFRXB(Y)-006"]
[0.54100000000000004,"TAFRXB(Y)-026とTAFRXB(Y)-024とTAFRXB(Y)-006"]
[0.56100000000000005,"TAFRXB(Y)-026：２組とTAFRXB(Y)-006"]
[0.58099999999999996,"TAFRXB(Y)-026：２組とTAFRXB(Y)-008"]
[0.60099999999999998,"TAFRXB(Y)-026：２組とTAFRXB(Y)-010"]
[0.621,"TAFRXB(Y)-026：２組とTAFRXB(Y)-012"]
[0.64100000000000001,"TAFRXB(Y)-026：２組とTAFRXB(Y)-014"]
[0.66100000000000003,"TAFRXB(Y)-026：２組とTAFRXB(Y)-016"]
[0.68100000000000005,"TAFRXB(Y)-026：２組とTAFRXB(Y)-018"]
[0.70099999999999996,"TAFRXB(Y)-026：２組とTAFRXB(Y)-020"]
[0.72099999999999997,"TAFRXB(Y)-026：２組とTAFRXB(Y)-022"]
[0.74099999999999999,"TAFRXB(Y)-026：２組とTAFRXB(Y)-024"]
[0.751,"※認定外の恐れがあります。"]
[0,"０．７５㎡を超える場合は認定になりません。"]
[0.01,"開口面積は問題なし。","○"]
[0.751,"※０．７５㎡を超えています。","×"]
[]
["①配管束数"]
[{"$f":"COUNTIF(C34:C53,\">20\")","v":0}]
["②開口への設置できる配管数予想"]
[{"$f":"INT((B60/200))","v":0},{"$f":"INT(D60/200)","v":0}]
["②-①"]
[{"$f":"IFERROR(((A170*B170)/A168),\"配管束大きさに対し開口サイズが小さい可能性があり、実際に配置できるか検討する必要があります。\")","v":"配管束大きさに対し開口サイズが小さい可能性があり、実際に配置できるか検討する必要があります。"}]
[]
[0,{"$f":"SUM(A172)","v":0}]
[0,"開口サイズに対して、配管束が多い(大きい)です。実際に配置できるか検討する必要があります。","△"]
[1,"配管束数は問題なし","○"]
[]
[0]
[1E-3,"占積率は問題なし","○"]
[0.3,"占積率が高めです。きちんと施工できるか注意が必要です。","△"]
[0.3841,"占積率が超えています。","×"]

{"sheet":"積算結果集計シート","index":1,"n_rows":70,"n_cols":13,"rows_kept":70,"cut":false,"hidden":false,"merged":[[5,12,5,15],[4,9,4,15],[4,6,4,8]]}
["タフロックロクマックス材料積算集計"]
[null,"件名："]
[null,"工事店："]
[null,"担当営業所："]
[null,null,null,null,null,null,"認定・施工条件チェック",null,null,"必要部材（支持板等は除く）"]
[null,"開口サイズ（㎜）",null,null,"占積率（％）","総系統数","開口面積","占積率","配管束配置",null,"ＴＡＦRXＭＴ－Ｍ","ＴＡＦRXＭＴ－Ｌ","ブロック"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
["※床施工の場合、別途鋼製スリーブと支持板、もしくは支持金具と支持板が必要になります。"]
["※壁施工の場合、中空壁なら鋼製開口補強枠が必要になります。"]
["※片壁は認定工法外です。"]
["このシートでの計算結果はあきまでも概算用ですので、実際の施工状況では必要数量が異なる場合がございます。"]

{"sheet":"マットの離隔距離について","index":2,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[[8,0,9,0],[8,1,9,1],[8,2,8,4],[8,5,8,7]]}
["タフロックロクマックスマットの離隔距離について"]
[]
["マットに収まる配管束の積算について"]
["　マットの収める配管束は、下記のサイズを収めることが可能です。"]
[]
[null,"ＴＡＦRXＭＴ－Ｍ：φ１０５以下"]
[null,"ＴＡＦRXＭＴ－Ｌ：φ１５０以下"]
["　配管束同士の離隔距離は以下の寸法を標準と考えます。"]
[null,"開口端部からの距離","並列配置時の距離",null,null,"45°配置の距離"]
[null,null,"Ｓ","Ｍ","Ｌ","Ｓ","Ｍ","Ｌ"]
["ＴＡＦRXＭＴ－Ｍ",72.5,97,143,168,86,103,119]
["ＴＡＦRXＭＴ－Ｌ",95,145,168,190,102,119,135]
[]
["タフロックロクマックスマットの束は、それぞれ施工できる最大サイズ（φ１０５、１５０）にマット厚２０㎜として算出しております。"]
["マットと開口端部、マットとマットが接触しても認定上問題ありません。"]
["マットの束の組み合わせを決定した後、使用する束のサイズに応じて配置を決めてそれぞれの寸法を加算していきます。"]
["開口サイズが決定したら、占積率が合うかどうか確認して、開口サイズの微調整をして占積率以下に収まるようにして完了です。"]
["※概算用なので、部材や開口が多めに積算されます。"]
["ギリギリいっぱいを狙う場合には、ＣＡＤ等で正確な配置を書いてチェックする必要があります。"]
["配管配置方法について"]
[null,"①並列配置時"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"並列配置時"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"②４５°配置の距離"]
[]
[]
[]
[null,null,null,null,null,"４５°配置"]