{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Sheet4","锅炉管","焊管及镀锌管重量"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet4","index":0,"n_rows":43,"n_cols":12,"rows_kept":43,"merged":[[0,0,0,9],[1,0,1,8],[2,0,2,8],[5,0,5,5],[7,3,8,3],[9,3,10,3],[11,5,12,5],[22,9,22,10],[23,9,23,10],[38,0,38,4],[38,5,38,6],[38,7,38,8],[39,0,39,5],[42,0,42,5]],"flags":["formulas_cached_only"]}
["圆形截面钢管重量计算"]
["公式：kg/m = (Od - Wt) * Wt * 0.02466 "]
["其中Od是外径 Wt是壁厚"]
[]
[]
["圆钢管"]
["公称内径","市场价格","单价(元/公斤)","管道类别","壁厚(mm)","备注"]
["DN25",6,{"v":15.323999999999998,"d":"15.32"},"(国标热镀锌钢管)","Φ33.7*3.2 1\"","错误"]
["DN200",6,{"v":216.71999999999997,"d":"216.72"},null,"Φ219*6.5 8\"","错误"]
["DN65",6,{"v":42.660000000000004,"d":"42.66"},"(国标焊接钢管)","Φ76.1*4 21/2\"","错误"]
["DN200",6,189.18,null,"Φ219*6 8\"","错误"]
["管道外径","管道壁厚","管道重量","市场价格(元/公斤)","单价(元/公斤)"]
[114,8,{"v":20.91168,"d":"20.91"},5.25,{"v":109.78632,"d":"109.79"}]
{"$rows_empty":9}
["外径mm",0,"壁厚mm",0,"重量",0,"kg/m",0,null,"靖江剀靖",null,"外径mm"]
["公称内径","外径mm",{"$nulls":3},"米重kg","根重kg","米重kg","根重kg","淮安07年10月",null,"公称内径"]
["DN15",21.3,null,"Φ21.3*2.8 1/2\"",null,1.28,7.68,1.357,8.14,6.66,{"v":9.03762,"d":"9.04"},"DN15"]
["DN20",26.9,null,"Φ26.9*2.8 3/4\"",null,1.66,9.96,1.76,10.56,6.56,{"v":11.545599999999999,"d":"11.55"},"DN20"]
["DN25",33.7,null,"Φ33.7*3.2 1\"",null,2.41,14.46,2.554,15.32,6.31,{"v":16.11574,"d":"16.12"},"DN25"]
["DN32",42.4,null,"Φ42.4*3.5 11/4\"",null,3.36,20.16,3.56,21.36,6.31,{"v":22.4636,"d":"22.46"},"DN32"]
["DN40",48.3,null,"Φ48.3*3.5 11/2\"",null,3.87,23.22,4.1,24.6,6.13,{"v":25.133,"d":"25.13"},"DN40"]
["DN50",60.3,null,"Φ60.3*3.8 2\"",null,5.29,31.74,5.607,33.64,6.13,{"v":34.37091,"d":"34.37"},"DN50"]
["DN65",76.1,null,"Φ76.1*4 21/2\"",null,7.11,42.66,7.536,45.21,6.05,{"v":45.5928,"d":"45.59"},"DN65"]
["DN80",88.9,null,"Φ88.9*4 3\"",null,8.38,50.28,8.88,53.28,5.25,{"v":46.620000000000005,"d":"46.62"},"DN80"]
["DN100",114.3,null,"Φ114.3*4 4\"",null,10.88,65.28,11.53,69.18,6.05,{"v":69.75649999999999,"d":"69.76"},"DN100"]
["DN125",140,null,"Φ140*4.5 5\"",null,15.04,90.24,15.942,98.65,6.27,{"v":99.95634,"d":"99.96"},"DN125"]
["DN150",168.3,null,"Φ168.3*4.5 6\"",null,18.18,109.08,19.27,115.62,6.27,{"v":120.82289999999999,"d":"120.82"},"DN150"]
["DN200",219.1,null,"Φ219*6 8\"",null,31.53,189.18,36.12,null,null,{"v":0,"d":"0.00"},"DN200"]
["DN200",219.1,null,"Φ219*6.5 8\"",{"$nulls":3},36.12,216.72,6.57,{"v":237.3084,"d":"237.31"},"DN200"]
[]
[{"$nulls":5},"焊管（6米定尺）",null,"镀锌管(6米定尺）"]
["矩形钢管"]
["长(mm)","宽(mm)","壁厚(mm)","重量(公斤/米)","市场价格(元/公斤)","单价(元/公斤)"]
[120,120,{"v":4,"d":"4.00"},14.5696,5.25,76.4904]
["红色不需填写,黄色必须填写"]

{"sheet":"锅炉管","index":1,"n_rows":45,"n_cols":14,"rows_kept":45,"merged":[[1,0,1,8],[2,0,2,8],[3,0,3,8],[6,0,6,8],[7,0,7,8],[8,0,8,3],[8,5,8,7],[8,9,8,11],[9,1,9,2],[10,0,11,0],[10,1,10,2],[10,5,11,5],[10,9,11,9],[11,1,11,2],[12,0,16,0],[12,1,13,2],[12,5,13,5],[12,9,13,9],[14,1,14,2],[15,1,16,1],[17,0,17,5],[19,0,20,0],[21,0,30,0],[33,0,34,1],[35,0,44,1]],"flags":["formulas_cached_only"]}
[]
["钢材理论重量计算方法(单位：公斤)圆钢：每米重量=0.00617*直径*直径(螺纹钢和圆钢相同）"]
["规格：10-42mm（10、12、14、16、18、20、22、25、28、30、32、34、35、36、38、40、42mm）"]
["钢种：Q215、Q235、45#、50#、HG3、20CrMnTi、20Cr、20CrMo、35CrMo、42CrMo、60Si2Mn、40Cr"]
[]
[]
["锅炉管(GB3087-1999 GB5310-1995)"]
["GB3087-1999  GB5310-1995（热轧、挤压、扩管）"]
["壁厚允许偏差",{"$nulls":8},"外径允许偏差"]
["标准","壁厚(S)",null,"壁厚允许偏差",{"$nulls":5},"标准","外径(D)","外径允许偏差"]
["GB3087-1999","≤20",null,"+15%,-12.5%(最小为+0.45mm,-0.35mm)",{"$nulls":5},"GB3087-1999","≤159","±1.0%(最小为±0.5mm)"]
[null,">20",null,"±12.5%",{"$nulls":6},">159","±1.0%"]
["GB5310-1995","<3.5",null,"+15%(最小为+0.48mm)",{"$nulls":5},"GB5310-1995","≤159","±1.0%(最小为±0.5mm)"]
[{"$nulls":3},"-10%(最小为+0.32mm)",{"$nulls":6},">159","±1.0%"]
[null,"3.5-20",null,"+15%,-10%"]
[null,">20","D<219","±10%"]
[null,null,"D≥219","+12.5%,-10%"]
[" 纵向力学性能"]
["标准","牌号","抗拉强度(MPa)","屈服点（MPa）≥","伸长率（%） ≥","冲击功(J)≥"]
["GB3087-1999",10,"333-475",196,24,"-"]
[null,20,"392-588","245/226",20,"-"]
["GB5310-1995","20G","410-550",245,24,35]
[null,"20MnG","≥415",240,22,35]
[null,"25MnG","≥485",275,20,35]
[null,"15MoG","450-600",270,22,35]
[null,"20MoG","≥415",220,22,35]
[null,"12CrMoG","410-560",205,21,35]
[null,"15CrMoG","440-640",235,21,35]
[null,"12Cr2MoG","450-600",280,20,35]
[null,"12Cr1MoVG","470-640",255,21,35]
[null,"12Cr2MoWVTib","540-735",345,18,35]
["化学成份"]
["标准",null,"牌号","C","Si","Mn","P≤","S≤","Cr","Mo","V","Ti","B","W"]
["GB3087-1999",null,10,"0.07-0.10","0.17-0.37","0.35-0.65",0.035,0.035,"≤0.15","-","-","-","-","-"]
[null,null,20,"0.17-0.24","0.17-0.37","0.35-0.65",0.035,0.035,"≤0.25","-","-","-","-","-"]
["GB5310-1995",null,"16G","0.17-0.24","0.17-0.37","0.35-0.65",0.03,0.03,"-","-","-","-","-","-"]
[null,null,"20MnG","0.17-0.24","0.17-0.37","0.70-1.00",0.03,0.03,"-","-","-","-","-","-"]
[null,null,"25MnG","0.22-0.26","0.17-0.37","0.70-1.00",0.03,0.03,"-","-","-","-","-","-"]
[null,null,"15MoG","0.12-0.16","0.17-0.37","0.40-0.80",0.03,0.03,"-","0.25-0.31","-","-","-","-"]
[null,null,"20MoG","0.15-0.21","0.17-0.37","0.40-0.80",0.03,0.03,"-","0.44-0.61","-","-","-","-"]
[null,null,"12CrMoG","0.08-0.11","0.17-0.37","0.40-0.70",0.03,0.03,"0.40-0.66","0.40-0.55","-","-","-","-"]
[null,null,"15CrMoG","0.12-0.14","0.17-0.37","0.40-0.70",0.03,0.03,"0.80-1.6","0.40-0.55","-","-","-","-"]
[null,null,"12Cr2MoG","0.08-0.15","≤0.46","0.40-0.70",0.03,0.03,"2.00-2.46","0.90-1.16","-","-","-","-"]
[null,null,"12Cr1MoG","0.08-0.15","0.17-0.33","0.40-0.70",0.03,0.03,"0.90-1.16","0.25-0.31","0.15-0.26","-","-","-"]
[null,null,"12Cr2MoWVTiB","0.08-0.15","0.45-0.71","0.45-0.61",0.03,0.03,"1.60-2.6","0.50-0.61","0.28-0.38","0.08-0.14","0.002-0.14","0.30-0.51"]

{"sheet":"焊管及镀锌管重量","index":2,"n_rows":16,"n_cols":9,"rows_kept":16,"merged":[[0,0,0,8],[1,0,1,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,1,6],[1,7,1,8]],"flags":["formulas_cached_only"]}
["焊管及镀锌管重量表(按GB/T3091—2001标准执行)"]
["规格",null,"外径mm","壁厚mm","最小壁厚mm","焊管（6米定尺）",null,"镀锌管(6米定尺）"]
["公称内径","英寸",{"$nulls":3},"米重kg","根重kg","米重kg","根重kg"]
["DN15",0.5,21.3,2.8,2.45,1.28,7.68,1.357,8.14]
["DN20",0.75,26.9,2.8,2.45,1.66,9.96,1.76,10.56]
["DN25",1,33.7,3.2,2.8,2.41,14.46,2.554,15.32]
["DN32",1.25,42.4,3.5,3.06,3.36,20.16,3.56,21.36]
["DN40",1.5,48.3,3.5,3.06,3.87,23.22,4.1,24.6]
["DN50",2,60.3,3.8,3.325,5.29,31.74,5.607,33.64]
["DN65",2.5,76.1,4,3.5,7.11,42.66,7.536,45.21]
["DN80",3,88.9,4,null,8.38,50.28,8.88,53.28]
["DN100",4,114.3,4,null,10.88,65.28,11.53,69.18]
["DN125",5,140,4.5,null,15.04,90.24,15.942,98.65]
["DN150",6,168.3,4.5,null,18.18,109.08,19.27,115.62]
["DN200",8,219.1,"6.0(焊管)",null,31.53,189.18]
["DN200",8,219.1,"6.5(热镀锌)",{"$nulls":3},36.12,216.72]