EXCEL市政工程量计算表

1、第 1 页，共 3 页排排 水水 管管 ( 污污 水水 ) 工工 程程 量量 计计 算算 表表识别:1=主管 2=支管180度混凝土基础序序号号井井 编编 号号识识别别管管径径 中中 线线 长长 度度 管管 长长 路路面面标标高高 地地面面标标高高管管 底底 标标 高高挖挖土土深深 下下底底宽宽 上上底底宽宽土土 方方每每 米米 体体 积积回回填填土土适适 用用 井井 径径检检查查井井(实实数数) 井井深深备备 注注前前后后平平均均管管道道基基础础前前井井 后后井井1W1W2140015.00 2.7502.96-0.59 -0.59-0.593.791.6307.308253.710.130

2、.19249.027007003.347007002W2W3140030.002.7502.96-0.54 -0.54-0.543.741.6307.240497.610.130.19488.227007003.297007003W2W2-1130015.002.7502.96-0.55 -0.55-0.553.751.3006.918230.810.070.14227.587007003.307007004W3W4140028.002.7502.96-0.48 -0.48-0.483.681.6307.150452.350.130.19443.587007003.237007005W4W51

3、40027.002.7502.96-0.43 -0.43-0.433.631.6307.068425.630.130.19417.187007003.187007006W4W4-113009.002.7502.960.570.570.572.631.3005.24577.460.070.1475.537007002.197007007W5W6140027.002.7502.96-0.38 -0.38-0.383.581.6306.993416.140.130.19407.697007003.137007008W5W5-1130027.002.7502.960.440.440.442.761.3

4、005.433250.400.070.14244.597007002.317007009W5-1W5-2130027.002.7502.960.520.520.522.681.3005.313238.790.070.14232.997007002.2370070010 W6W7130037.002.7502.96-0.01 -0.01-0.013.211.3006.108439.210.070.14431.257007002.7670070011 W6W6-1A130012.002.7502.960.610.610.612.591.3005.178100.470.070.1497.897007

5、002.1470070012 W6W6-2A13006.002.7502.960.610.610.612.591.3005.17850.230.070.1448.947007002.1470070013 W6W6-1140029.002.7502.96-0.32 -0.32-0.323.521.6306.910435.880.130.19426.807007003.0770070014 W6-1W6-2140011.002.7502.96-0.29 -0.29-0.293.491.6306.865163.060.130.19159.627007003.0470070015 W6-2W6-2-1

6、22008.002.7502.961.501.501.501.691.1803.71533.090.030.1032.05700 700化16 W6-2W6-3130015.502.7502.961.381.381.381.821.3004.02374.870.070.1471.547007001.3770070017 W6-3W6-3-122008.002.7502.961.501.501.501.691.1803.71533.090.030.1032.05700 700化18 W6-3W6-3-2220010.002.7502.961.501.501.501.691.1803.71541.

7、360.030.1040.06700 700化19 W6-3W6-4130013.102.7502.961.431.431.431.771.3003.94860.670.070.1457.857007001.3270070020 W6-4W6-4-122008.002.7502.961.501.501.501.691.1803.71533.090.030.1032.05700 700化21 W6-4W6-4-2220010.002.7502.961.501.501.501.691.1803.71541.360.030.1040.06700 700化22 W6-4W6-5130016.002.7

8、502.961.481.481.481.721.3003.88071.280.070.1467.847007001.2770070023 W6-5W6-5-122008.002.7502.961.501.501.501.691.1803.71533.090.030.1032.05700 700化24 W6-5W6-5-2220010.002.7502.961.501.501.501.691.1803.71541.360.030.1040.06700 700化25 W6-1W9140035.002.7502.56-0.27 -0.27-0.273.071.6306.228421.460.130.

9、19410.507007003.0270070026 W9W10140035.002.7502.56-0.21 -0.21-0.213.011.6306.138408.470.130.19397.527007002.9670070027 W10W11140016.502.7502.56-0.15 -0.15-0.152.951.6306.048186.530.130.19181.377007002.970070028 W11W12140035.002.7502.56-0.12 -0.12-0.122.921.6306.010390.400.130.19379.457007002.8770070

10、029 W11W11-1130010.502.7502.56-0.15 -0.15-0.152.941.3005.710108.200.070.14105.947007002.970070030 W11-1W11-1-1 22008.002.7502.561.501.501.501.291.1803.11522.160.030.1021.12700 700化合合 计计546.606032.245892.40备备 注注D200=462.00米D300=1339.90米D400=518.60米D500=168.00米700检查井H1+D时,应为1000第 2 页，共 3 页排排 水水 管管 ( 雨

11、雨 水水 ) 工工 程程 量量 计计 算算 表表识别:1=主管 2=支管(雨) 3=支管(埋)135度混凝土基础序序号号井井 编编 号号识识别别 管管径径(D)中中 线线 长长 度度管管 长长 路路面面标标高高地地 面面 标标 高高管管 底底 标标 高高挖挖土土深深 下下底底宽宽 上上底底宽宽土土 方方每每 米米 体体 积积回回填填土土适适用用井井径径检检查查井井(实实数数) 井井深深 雨雨水水井井数数备备 注注前前后后平平均均管管道道基基础础前前井井 后后井井1Y21Y21-122001.001.35 2.750 2.5601.5001.5001.5001.2901.1503.0852.73

12、0.030.082.62 700 11250雨2Y21Y21-222005.505.85 2.750 2.5601.5001.5001.5001.2901.1503.08515.020.030.0814.40 700 11250雨3Y21Y21-333007.507.85 2.750 2.5601.5001.5001.5001.2951.2703.21321.770.070.1220.34 700 12504Y21Y22180011.0011.70 2.750 2.5600.4250.4250.4252.4602.3306.020112.980.600.43101.63 125012502.3

13、3 1250 12505Y21Y6180022.002.750 2.5600.4100.4100.4102.4752.3306.043227.940.600.43205.26 125012502.34 1500 12506Y22Y22-1130021.102.750 2.5601.3951.3951.3951.4001.2703.37068.530.070.1264.52 7007001.36 1250 7007Y22-1Y22-2130018.902.750 2.5601.4701.4701.4701.3251.2703.25856.690.070.1253.10 7007001.28 70

14、07008Y22Y22-3130015.002.750 2.5601.2801.2801.2801.5151.2703.54354.680.070.1251.83 7007001.47 1000 70009Y22-1Y22-1-122002.502.750 2.5601.5001.5001.5001.2901.1503.0856.830.030.086.54 700 1700雨10 Y22-1Y22-1-233007.002.750 2.5601.5001.5001.5001.2951.2703.21320.320.070.1218.99 700 70011 Y22-1Y22-1-333001

15、1.002.750 2.5601.5001.5001.5001.2951.2703.21331.930.070.1229.84 700 70012 Y22-2Y22-2-122002.502.750 2.5601.5001.5001.5001.2901.1503.0856.830.030.086.54 700 1700雨13 Y22-2Y22-2-233007.002.750 2.5601.5001.5001.5001.2951.2703.21320.320.070.1218.99 700 70014 Y22-2Y22-2-3330011.002.750 2.5601.5001.5001.50

16、01.2951.2703.21331.930.070.1229.84 700 70015 Y22-3Y22-3-122002.002.750 2.5601.5001.5001.5001.2901.1503.0855.460.030.085.24 700 1700雨16 Y22Y23180013.002.750 2.5600.4350.4350.4352.4502.3306.005132.730.600.43119.33 125012502.32 1250 125017 Y23Y23-122005.502.750 2.5601.5001.5001.5001.2901.1503.08515.020

17、.030.0814.40 700 11250雨18 Y23Y23-222008.502.750 2.5601.5001.5001.5001.2901.1503.08523.220.030.0822.25 700 11250雨19 Y23Y23-333007.502.750 2.5601.5001.5001.5001.2951.2703.21321.770.070.1220.34 700 125020 Y23Y24180019.002.750 2.5600.4500.4500.4502.4352.3305.983192.290.600.43172.70 125012502.3 1250 1250

18、21 Y24Y24-1130012.802.750 2.5601.2801.2801.2801.5151.2703.54346.660.070.1244.23 7007001.47 1250 70022 Y24Y24-213009.802.750 2.5600.9800.9800.9801.8151.2703.99346.800.070.1244.94 7007001.77 1250 70023 Y24-1Y24-1-122002.002.750 2.5601.5001.5001.5001.2901.1503.0855.460.030.085.24 700 1700雨24 Y24-2Y24-2

19、-122002.002.750 2.5601.5001.5001.5001.2901.1503.0855.460.030.085.24 700 1700雨25 Y24-2Y24-2-222002.002.750 2.5601.5001.5001.5001.2901.1503.0855.460.030.085.24 700 1700雨26 Y24Y25180023.002.750 2.5600.4700.4700.4702.4152.3305.953230.030.600.43206.31 125012502.28 1250 1250合合 计计2501408.871289.8910备备 注注D2

20、00=1038.5 D300=1620.5D400=653.8D500=329.3D600=410D800=318.5D1000=110.2D1200=124.3700检查井H1+D时,应为1000道道 路路 工工 程程 量量 计计 算算 表表序序号号起起 点点 坐坐 标标终终 点点 坐坐 标标中中 线线 长长 度度应应扣扣长长度度路路 长长 条条数数路路基基宽宽度度挖挖前前标标高高挖挖后后标标高高挖挖土土深深度度路路 床床 整整 形形土土 方方块块 石石 底底 层层 H =300碎碎 石石 底底 层层 H =1006%6%水水泥泥石石粉粉渣渣 H=100H=100砼砼路路面面4.5MPaH=

21、1804.5MPaH=180备备 注注17412.77529850.8217439.94229871.26534.007.027.0019.0 2.962.170.79259.20204.77243.00243.00243.00243.0027388.13029833.2477367.85429865.38538.009.029.0018.0 2.962.170.79249.40197.02232.00232.00232.00232.00园弧段373318.608 86741.226 73311.379 86776.39235.903.532.4016.0 2.762.170.59213.85

22、126.17194.41194.41194.41194.41473318.608 86741.226 73285.768 86752.14034.613.531.1116.0 2.762.170.59205.30121.13186.64186.64186.64186.64573448.234 86685.901 73413.702 86722.55350.3622.228.16110.0 2.672.170.50298.46149.23281.57281.57281.57281.57673413.702 86722.553 73363.798 86775.98073.1124.748.4111

23、0.0 2.672.170.50513.13256.57484.09484.09484.09484.09773363.798 86775.98036.5015.521.00110.0 2.672.170.50222.60111.30210.00210.00210.00210.00873363.798 86775.980 73502.409 86907.319190.9525.0165.95110.0 2.672.170.501759.10879.551659.531659.531659.531659.53973502.499 86907.319 73449.060 86987.17996.09

24、28.068.09110.0 2.672.170.50721.76360.88680.90680.90680.90680.9010 73449.060 86987.17968.0025.043.00125.0 2.672.100.571100.80627.461075.001075.001075.001075.0011 73217.790 86687.769 73430.659 86889.701293.410.0293.4117.0 2.562.170.392229.92869.672053.872053.872053.872053.8712 73430.659 86889.701 7343

25、1.779 86932.07747.100.047.1017.0 2.562.170.39357.96139.60329.70329.70329.70329.70园弧段13 73431.779 86932.077 73373.931 86993.16784.134.579.6317.0 2.562.170.39605.21236.03557.43557.43557.43557.4314 73373.931 86993.167 73385.549 87004.16816.00-3.519.5017.0 2.562.170.39148.2057.80136.50136.50136.50136.50

26、15 73385.549 87004.168 73319.475 87073.94596.100.096.1017.0 2.562.170.39730.34284.83672.68672.68672.68672.6816 73422.648 86882.089 73270.836 87042.410220.7915.5205.2917.0 2.562.170.391560.23608.491437.051437.051437.051437.0517 73217.790 86687.769 73204.360 86688.13514.920.014.9217.0 2.562.170.39113.3944.22104.44104.44104.44104.44园弧段18 73204.360 86688.135 73178.165 86715.79838.100.038.1017.0 2.562.170.39289.54112.92266.68266.6826