给排水及暖通安装工程量计算表格（自动计算）.xls

1、 钢材单重表 钢材单重表 钢材单重表 工字钢 槽钢 不等边角钢 等边角钢 圆钢方钢Kg/M 无缝钢管 铸铁管 焊接管 六角钢 钢丝绳规格 Kg/m规格 Kg/m规格Kg/m规格Kg/m规格Kg/m规格 圆钢方钢规格Kg/m规格Kg/m规格长度 Kg/根规格外径英寸Kg/m规格 Kg/m规格Kg/百米1011.2615.05.43863*40*53.9220*3 0.889 90*810.9466.5 0.260.332 32*2.51.82133*4.5 14.2675475.615*2.75 21.25 1/21.26141.336*19*7.721.1412.6 14.2336.36.63

2、463*40*64.63825*3 1.124 90*10 13.47680.395 0.502 32*32.15133*515.78100497.720*2.75 26.75 3/41.63161.746*19*9.330.451416.898.08.04570*45*54.40325*41.459 90*1215.9490.499 0.636 32*3.52.46133*5.5 17.29150414925*3.25 33.512.42182.26*19*1141.441620.5131010.00770*45*65.21830*31.373 100*812.276100.617 0.78

3、5 38*2.53.19159*5.5 20.82200420732*3.25 42.25 11/43.13202.726*19*12.554.121824.14312.6 12.31875*50*65.69930*41.786 100*10 15.12120.888 1.1338*32.59159*622.642505340.740*3.54811/23.84223.296*19*1468.520a27.92914a14.53575*50*87.43136*31.656 100*12 17.893141.211.5438*3.52.98159*6.5 24.453005428.350*3.5

4、602 4.88254.256*19*15.584.5720b31.06914b16.73380*50*65.93536*42.163 100*14 20.611161.582.0142*32.89159*726.243505524.365*3.75 75.521/26.64285.336*19*17102.322a33.0716a17.2480*50*76.84840*31.852 100*16 23.2571822.5442*3.53.32159*7.5 28.02400564080*488.538.34306.126*37*1140.9622b36.52416b19.75480*50*8

5、7.74540*42.422 110*813.532202.473.1442*43.75159*829.794505748100*4114410.85 扁钢6*37*1358.9825a38.10518a20.17490*56*66.71745*32.088 110*10 16.69222.983.845*33.11159*933.295005869125*4140513.426*37*1580.2725b42.0318b2390*56*77.75645*42.736 110*12 19.782253.854.9145*3.53.58168*623.9760051142150*4.5 1656

6、17.81 12*3 0.286*37*17.5104.828a43.49220a22.637100*63*78.72245*53.369 110*14 22.809264.175.3145*44.04168*727.7970061694 花纹钢板12*4 0.386*37*19.5132.728b47.88820b25.777100*63*89.87850*32.332 125*815.504284.836.1550*3.54.01168*831.568006210614*3 0.336*37*21.5163.832a52.71722a24.999100*80*79.65650*43.059

7、 125*10 19.133305.557.0651*3.54.1219*736.690062572 厚 度 Kg/m14*4 0.446*37*24198.232b57.74122b28.453100*80*810.94650*53.77125*12 22.696326.318.0451*44.64219*841.63100063224 mm16*4 0.56*37*26235.932c62.76525a27.41110*70*79.65656*43.446 125*14 26.193357.559.6257*3.54.62219*946.61 钢 轨325.616*5 0.63 钢丝36a

8、60.03725b31.335110*70*810.94656*54.251 140*10 21.488367.9910.257*45.28219*1051.54 菱3.529.518*5 0.7136b65.68925c35.26125*80*812.55163*43.907 140*12 25.522388.911.360*3.54.88219*1156.42 型 号KgKg/m433.418*6 0.85直径mmKg/千m36c71.34128a31.427125*80*1015.47463*54.822 140*14 29.49409.8612.663*3.55.14245*741.0

9、898.944.537.320*5 0.7816.1740a67.59828b35.823140*90*1017.47563*65.721 140*16 33.3934512.515.963*45.82245*846.76 轻1212.2 型542.320*6 0.941.28.8840b73.87828c40.129140*90*1220.72463*87.469 160*10 24.7295015.419.663.5*3.5 5.18245*952.381515.2650.122*5 0.861.412.0840c80.15832a38.083160*100*12 23.59270*55.

10、397 160*12 29.3915518.623.776*47.1245*1057.95 轨2222.3324.422*6 1.041.615.7845a80.4232b43.107160*100*14 27.24770*66.406 160*14 33.9876022.228.376*4.57.93273*852.283030.1 扁3.528.425*5 0.981.819.9845b87.48532c48.131180*110*12 26.46470*77.398 160*16 38.518652633.276*58.75273*958.593838.733432.425*6 1.18

11、224.6645c94.5536a47.814180*110*14 30.58970*88.373 180*12 33.1597030.538.576*5.59.56273*1064.86 重4344.6534.536.428*6 1.322.538.5350a93.65436b53.466200*125*14 34.43675*66.905 180*14 39.3837534.744.289*4.59.38273*1277.24 轨4545.54 豆540.528*7 1.54355.4950b101.536c59.118200*125*16 39.04575*77.976 180*16 4

12、3.5428039.550.289*510.35325*1292.635051.514648.428*8 1.763.575.53 常用化学元素符号铝板（Kg/M）2.8575*89.03180*18 48.6348544.556.789*5.511.33325*14107.38 钢扁钢：W=0.00785*宽*厚钢板：W=7.85*厚Fe铁 V钒Sn锡 Co钴黄铜板8.580*67.376 200*14 42.8949049.963.689*612.28325*16121.93 材方钢：W=0.00785*边长钢管：W=0.02466*壁厚*（外径-壁厚）Mg镁 S硫Zn锌 Ni镍紫铜板8.

13、980*78.525 200*16 48.689555.670.8108*4.511.49377*16142.44 单圆钢：W=0.00617*直径镀锌管：W=钢管单重*1.03-1.06Ai铝 P磷Cr铬 Ti钛锌版7.280*89.658 200*18 54.401100 61.778.5108*512.7377*18159.36 重六角钢：W=0.0068*对边长角钢W=0.00785*边厚*（长边宽+短便宽-边厚）Si硅 C碳W钨Mo钼不锈钢板7.9380*10 11.87 200*20 60.056105 6886.5108*5.513.9377*20176.08 计钢丝：W=0.0

14、0617*直径钢材黄铜紫铜 铅锌 铝花板Mn锰 B硼Cn铜 Pb铅普通钢板7.8590*79.656 200*24 71.163110 74.695108*615.09377*22192.6 算7.858.58.911.37 7.22.96 钢材理论重量、单价/M自动计算表名 称 直径边厚边宽 边宽 计 算 式单重Kg/（M）单价单价 壁厚 B1B2Kg/(M)元/Kg元/m角 钢0.00785*（B1+B2-)*0.0000.00圆 钢0.00617*0.0000.00扁 钢0.00785*B10.0000.00管 材0.02466*（-）0.0000.00板 材7.85*0.0000.00

15、黄 铜 管0.0267*（-）0.0000.00紫 铜 管0.0796*（-）0.0000.00铝花纹板2.96*0.0000.00黄 铜 板8.5*0.000紫 铜 板8.9*0.000锌 板7.2*0.000铅 板11.37*0.000注：该表使用时，只要输了相应的基本数值、B1、B2、元/Kg即可得到Kg/M、Kg/M、元/M等要求的数值 管道刷油面积、保温体积、保温外表面积自动计算表单位工程名称：单位：M/100M、M/100M单位刷油面积 保 温 体 积（M）保 温 外 表 面 积（M）序号 管道外径100MMB=20B=25B=30B=40B=50B=60B=70B=20B=25B

16、=30B=40B=50B=60B=701DN156.680.270.380.510.821.181.622.1322.4325.7329.0335.6342.2248.8255.422DN200.45 8.40.310.430.570.891.281.742.2624.3227.6130.9137.5144.1150.7157.33DN250 10.520.350.490.630.971.381.862.4126.3629.6632.9639.5546.1552.7559.344DN320 13.270.40.550.71.071.512.012.5827.7532.0435.3441.944

17、8.5455.1361.735DN400 15.080.440.60.761.161.462.142.7430.8334.1337.4344.0250.6257.2163.86DN500 18.850.530.690.891.311.812.383.0134.637.941.247.7954.3860.9867.577DN700 23.720.630.831.041.522.072.693.3739.6342.9246.2252.8159.416672.68DN800 27.80.710.931.171.692.282.933.6842.7447.0450.3356.963.4970.0876

18、.689DN1000 35.810.881.141.422.012.693.434.2451.5654.8658.1564.7571.3478.0384.6210DN1250 43.9811.251.592.2633.794.6657.5260.8264.1270.7177.3183.990.4911DN15051.841.211.551.912.63.424.35.2567.5770.8774.1778.8885.4792.0698.6612DN20068.61.561.982.433.384.395.466.6184.5387.8291.1297.72104.31110.9117.513D

19、N25085.771.92.432.954.085.276.527.48101.48104.78108.08114.67121.27127.86134.4514DN300102.12.242.843.464.6767.539.02117.81121.11124.41128.96135.55144.19150.7815DN3500 118.442.583.263.985.436.958.5410.21134.21137.51140.81147.4154160.6167.216DN400133.832.93.674.456.067.759.5711.32149.6152.9156.2162.816

20、9.39175.99182.5917DN450150.23.234.094.966.758.5910.5212.5165.94169.24172.54179.13185.73192.33198.9318DN500166.23.564.55.457.419.4211.5113.66181.96185.26188.56195.16201.75223.03214.9519DN600197.74.225.326.448.7211.0613.4715.95213.69216.99220.29226.89223.43240.08246.6820DN700228.084.846.097.379.9612.6

21、215.2317.99243.85247.15250.45257.05260.34268.35274.9521DN800257.65.456.868.2810.6614.1417.1720.17273.38276.68279.92286.58293.17299.77306.3722DN900289.036.117.689.2612.4815.7619.1222.54304.83308.1311.34317.99324.58331.19337.7823DN1000320.446.768.4810.2413.8217.3921.0624.81336.21339.51342.81349.41356.

22、01362.6369.224合计3.780.13950.1935 0.2565 0.4005 0.5760.7831.01710.94412.4245 13.9095 16.8795 19.8495 22.8195 25.785使用说明：测算管道各种数据时，只要输入各种管道的100长度，就可得出相关结果 室内排水PVC管件综合单价自动测算表序号 规 格三 通弯 头 四 通接 轮扫出口 变 径伸缩节 小 计综合单价含 量1.155.552.000.210.119.021De50单 价1.631.040.642.602.401.08小 计1.875.770.001.280.550.000.269.

23、74含 量1.931.590.132.862.720.171.3610.762De75单 价3.702.465.001.214.201.703.842.98小 计7.143.910.653.4611.420.295.2232.10含 量4.484.140.251.040.810.250.4111.383De110单 价7.674.6010.402.407.674.307.406.05小 计34.3619.042.602.506.211.083.0368.82含 量3.451.330.111.440.100.140.416.984De160单 价16.2013.0028.605.6016.207

24、.8016.1213.43小 计55.8917.293.158.061.621.096.6193.71含 量3.451.330.111.440.100.140.416.985De200单 价31.2026.0058.507.1536.4022.8037.0025.92小 计107.6434.586.4410.303.643.1915.17180.95使用说明：测算管件综合单价时，只要输入各种管件的单价，就可得出该种 型号PVC管件的综合单价 接轮按管箍价计算，De200管件含量套用De150含量 该表价格是根据白山雨润供应部08年4月调价结果测算的 室内塑料给水热熔管件综合单价自动测算表序号

25、规 格三 通弯 头补芯四 通管箍小 计综合单价含 量3.176.602.2011.971De20单 价0.670.510.870.330.52小 计2.123.370.000.000.736.22含 量3.822.082.771.420.0510.142De25单 价0.920.833.511.200.461.65小 计3.511.739.721.700.0216.68含 量3.002.291.511.410.408.253De32单 价1.791.358.082.330.742.94小 计5.373.0912.203.280.3024.24含 量2.191.801.281.540.026.8

26、34De40单 价2.832.1814.143.681.254.97小 计6.203.9218.105.670.0333.91含 量1.371.661.401.610.016.054De50单 价3.883.8317.945.041.947.43小 计5.326.3625.128.120.0244.93含 量1.851.840.591.000.015.294De63单 价7.296.1719.079.483.138.62小 计13.4911.3511.259.480.0345.60含 量1.621.670.220.353.864De75单 价12.8010.8920.9016.647.8411

27、.99小 计20.7418.194.600.002.7446.26含 量0.711.500.100.923.234De90单 价19.6315.9322.5025.5210.9415.53小 计13.9423.902.250.0010.0650.15含 量1.000.660.120.100.492.284De110单 价27.0026.1125.7635.1014.3925.39小 计27.0017.233.093.517.0557.88使用说明：测算管件综合单价时，只要输入各种管件的单价，就可得出该种 型号塑料管件的综合单价 补芯套用内螺纹管套及法兰连接件的价格，四通的价格按三通的 价格*1

28、.3.该表价格是根据白山雨润供应部08年4月调价结果测算的 补芯套用内螺纹管套及法兰连接件的价格，四通的价格按三通的 消防镀锌管件综合单价自动测算表序号规 格三 通弯 头补 芯管箍四 通小 计综合单价含 量0.3171.1000.2201.6371DN15单 价0.00小 计0.0000.0000.0000.0000.0000.000含 量0.3820.3460.2770.1420.0051.1522DN20单 价0.00小 计0.0000.0000.0000.0000.0000.000含 量0.3000.3820.1510.1410.0040.9783DN25单 价0.00小 计0.0000

29、.0000.0000.0000.0000.000含 量0.2190.3000.1280.1540.0020.8034DN32单 价0.00小 计0.0000.0000.0000.0000.0000.000含 量0.1370.2770.1400.1610.0010.7165DN40单 价0.00小 计0.0000.0000.0000.0000.0000.000含 量0.1850.3060.0590.1000.0010.6516DN50单 价0.00小 计0.0000.0000.0000.0000.0000.000含 量0.1620.1670.0370.0590.4257DN70单 价0.00小

30、计0.0000.0000.0000.0000.0000.000含 量0.0710.1500.0160.1540.3918DN80单 价0.00小 计0.0000.0000.0000.0000.0000.000含 量0.1000.0660.0200.0810.0010.2689DN100单 价0.00小 计0.0000.0000.0000.0000.0000.000使用说明：测算管件综合单价时，只要输入各种管件的单价，就可得出该种 型号镀锌管件的综合单价 该表价格是根据白山雨润供应部08年5月调价结果测算的 放坡系数表 土壤类别 放坡起点 人工挖土 机械挖土 在坑内作业 在坑上作业 一、二类土1

31、.21/0.51/0.331/0.75 三 类 土1.51/0.331/0.251/0.67 四 类 土2.01/0.251/0.11/0.33 管道地沟沟底宽度表 管 径 铸铁管、钢管 砼管 陶土管 50 700.60.80.7 100 2000.70.90.8 250 3500.81.00.9 400 4501.01.31.1 500 6001.31.51.4 700 8001.61.8 900 10001.82.0 1100 12002.02.3 1300 14002.22.6 室内管道沟挖土方放坡断面面积表单位：M放坡沟底宽0.60.70.80.91.01.11.21.31.4系数沟深

32、1.00.850.951.051.151.251.351.451.551.651.10.961.071.181.291.401.511.621.731.841/0.251.21.081.201.321.441.561.681.801.921.841.31.201.331.461.561.721.851.982.112.241.41.331.471.611.751.892.032.172.312.451.00.931.031.131.231.331.431.531.631.731.11.061.171.281.391.501.611.721.831.941/0.331.21.201.321.44

33、1.561.681.801.922.042.161.31.341.471.601.731.861.992.122.252.381.41.491.631.771.912.052.192.332.472.611.01.101.201.301.401.501.601.701.801.901.11.271.381.491.601.711.821.932.042.151/0.51.21.441.561.691.801.922.042.162.282.401.31.631.761.892.022.152.282.412.542.671.41.821.962.102.242.382.522.662.802.

34、94 1：0.25低槽或管沟放坡断面面积表单位：M沟底宽0.60.70.80.911.11.21.3沟深1.51.461.611.761.912.062.212.362.511.61.601.761.922.082.242.402.562.721.71.741.912.082.252.422.592.762.931.81.892.072.252.432.612.792.973.151.92.042.232.422.612.802.993.183.372.02.202.402.602.803.003.203.403.602.12.362.572.782.993.203.413.623.832.2

35、2.532.752.973.193.413.633.854.072.32.702.933.163.393.623.854.084.312.42.883.123.363.603.844.084.324.562.53.063.313.563.814.064.314.564.812.63.253.513.774.034.294.554.815.072.73.443.713.984.254.524.795.065.332.83.643.924.204.484.765.045.325.602.93.844.134.424.715.005.295.585.873.04.054.354.654.955.25

36、5.555.856.15 1：0.25低槽或管沟放坡断面面积表单位：M沟底宽1.41.51.61.71.81.92.0沟深1.52.662.812.963.113.263.413.561.62.883.043.203.363.523.683.841.73.103.273.443.613.783.954.121.83.333.513.693.874.054.234.411.93.563.753.944.134.324.514.702.03.804.004.204.404.604.805.002.14.044.254.464.674.885.095.302.24.294.514.734.955.1

37、75.395.612.34.544.775.005.235.465.695.922.44.805.045.285.525.766.006.242.55.065.315.565.816.066.316.592.65.335.595.856.116.376.636.892.75.605.876.146.416.686.957.222.85.886.166.446.727.007.287.562.96.166.456.747.037.327.607.903.06.456.757.057.357.657.958.25 1：0.33低槽或管沟放坡断面面积表单位：M沟底宽0.60.70.80.911.11

38、.21.3沟深1.51.641.791.942.092.242.392.542.691.61.801.962.122.282.442.602.762.921.71.972.142.312.482.652.822.993.161.82.152.332.512.692.873.053.233.411.92.332.522.712.903.093.283.473.662.02.522.722.923.123.323.523.723.922.12.722.933.143.353.563.773.984.192.22.923.143.363.583.804.024.244.462.33.133.363.

39、593.824.054.284.514.742.43.343.583.824.064.304.544.785.022.53.563.814.064.314.564.815.065.312.63.794.054.314.574.835.095.355.612.74.034.304.574.845.115.385.655.902.84.274.554.835.115.395.675.956.232.94.524.815.105.395.685.976.266.553.04.775.075.375.675.976.276.576.87 1：0.33低槽或管沟放坡断面面积表单位：M沟底宽1.41.51

40、.61.71.81.92.0沟深1.52.842.993.143.293.443.593.741.63.083.243.403.563.723.884.041.73.333.503.673.844.014.184.351.83.593.773.954.134.314.494.671.93.854.044.234.424.614.804.992.04.124.324.524.724.925.125.322.14.404.614.825.035.245.455.662.24.684.905.125.345.565.786.002.34.975.205.435.665.896.126.352.45.265.505.745.986.226.466.702.55.565.816.066.136.566.817.062.65.786.136.396.656.917.177.432.76.196.466.737.007.277.547.812.86.516.797.077.357.637.918.192.96.847.137.427.718.008.298.583.07.177.477.778.078.378.688.97