XLS《Sheet4》

"圆形截面钢管重量计算" "公式:kg/m=(Od-Wt)*Wt*0.

02466" "其中Od是外径Wt是壁厚" "圆钢管",,

,,

,,

"公称内径","市场价格","单价(元/公斤)","管道类别","壁厚(mm)","备注", "DN25","6","15.324","(国标热镀锌钢管)",,

"错误", "DN200","6","216.72",,

,"错误", "DN65","6","42.66","(国标焊接钢管)",,

"错误", "DN200","6","189.18",,

,"错误", "管道外径","管道壁厚","管道重量","市场价格(元/公斤)","单价(元/公斤)",,

"114","8","20.91168","5.25","109.78632",,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

,,

"外径mm","0","壁厚mm","0","重量","0","kg/m","0",,

"靖江剀靖",,

"外径mm" "公称内径","外径mm",,

,,

"米重kg","根重kg","米重kg","根重kg","淮安07年10月",,

"公称内径" "DN15","21.30001953125",,

"Φ21.3*2.81/2""",,

"1.28000122070313","7.6800048828125","1.357","8.1400048828125","6.6600048828125","9.03762","DN15" "DN20","26.90001953125",,

"Φ26.9*2.83/4""",,

"1.66000122070312","9.9600048828125","1.76000122070313","10.560009765625","6.5600048828125","11.5456","DN20" "DN25","33.70001953125",,

"Φ33.7*3.21""",,

"2.41000122070312","14.460009765625","2.554","15.320009765625","6.3100048828125","16.11574","DN25" "DN32","42.4000390625",,

"Φ42.4*3.511/4""",,

"3.36000244140625","20.160009765625","3.56000244140625","21.36001953125","6.3100048828125","22.4636","DN32" "DN40","48.3000390625",,

"Φ48.3*3.511/2""",,

"3.87000244140625","23.22001953125","4.10000244140625","24.60001953125","6.1300048828125","25.133","DN40" "DN50","60.3000390625",,

"Φ60.3*3.82""",,

"5.2900048828125","31.74001953125","5.607","33.64001953125","6.1300048828125","34.37091","DN50" "DN65","76.1000390625",,

"Φ76.1*421/2""",,

"7.1100048828125","42.6600390625","7.536","45.2100390625","6.0500048828125","45.5928","DN65" "DN80","88.900078125",,

"Φ88.9*43""",,

"8.3800048828125","50.2800390625","8.8800048828125","53.2800390625","5.25","46.62","DN80" "DN100","114.300078125",,

"Φ114.3*44""",,

"10.880009765625","65.2800390625","11.530009765625","69.1800390625","6.0500048828125","69.7565","DN100" "DN125","140",,

"Φ140*4.55""",,

"15.040009765625","90.240078125","15.942","98.650078125","6.2700048828125","99.95634","DN125" "DN150","168.30015625",,

"Φ168.3*4.56""",,

"18.180009765625","109.080078125","19.270009765625","115.620078125","6.2700048828125","120.8229","DN150" "DN200","219.10015625",,

"Φ219*68""",,

"31.53001953125","189.18015625","36.12001953125",,

,"0","DN200" "DN200","219.10015625",,

"Φ219*6.58""",,

,,

"36.12001953125","216.72015625","6.5700048828125","237.3084","DN200" ,,

,,

,"焊管(6米定尺)",,

"镀锌管(6米定尺)",,

,,

"矩形钢管",,

,,

,,

"长(mm)","宽(mm)","壁厚(mm)","重量(公斤/米)","市场价格(元/公斤)","单价(元/公斤)", "120","120","4","14.5696","5.25","76.4904", "红色不需填写,黄色必须填写",,

,,

,,

"钢材理论重量计算方法(单位:公斤)圆钢:每米重量=0.00617*直径*直径(螺纹钢和圆钢相同) "规格:10-42mm(