市政道路土方EXCEL计算表(含公式).xls
《市政道路土方EXCEL计算表(含公式).xls》由会员分享,可在线阅读,更多相关《市政道路土方EXCEL计算表(含公式).xls(5页珍藏版)》请在得力文库 - 分享文档赚钱的网站上搜索。
1、路路基基土土方方工工程程量量表表序序号号桩桩号号现现状状高高程程 设设计计高高程程 挖挖填填高高度度设设计计主主路路宽宽度度距距离离断断面面积积(m2)m2)平平均均面面积积(m2)m2)土土方方数数(m3)(m3)备备注注左左路路基基右右路路基基 路路宽宽填填挖挖填填挖挖填填挖挖1 1K0+K0+0 097.6897.6897.8897.880.20.23.53.53.53.57 70.1950.1951.6451.6452 2K0+K0+202098.4298.4298.2898.28-0.14-0.143.53.53.53.57 720206.0656.0650.09750.09753.
2、8553.8551.951.9577.1077.103 3K0+K0+404099.5399.5398.6998.69-0.84-0.843.53.53.53.57 7202015.71415.7140 0 10.889510.88950.000.00217.79217.794 4K0+K0+6060100.05100.0599.0999.09-0.96-0.963.53.53.53.57 7202017.83817.8380 016.77616.7760.000.00335.52335.525 5K0+K0+808099.9199.9199.4999.49-0.42-0.423.53.53.
3、53.57 720200.0680.0687.437.430.0340.03412.63412.6340.680.68252.68252.686 6K0+K0+10010099.5699.5699.8999.890.330.333.53.53.53.57 720201.7631.7630.4110.4110.91550.91553.92053.920518.3118.3178.4178.417 7K0+K0+12012099.3899.38100.11100.110.730.733.53.53.53.57 720209.5769.5765.66955.66950.20550.2055113.3
4、9113.394.114.118 8K0+K0+14014099.0299.021001000.980.983.53.53.53.57 7202010.37910.3799.97759.97750 0199.55199.550.000.009 9K0+K0+16016099.0999.0997.7197.71-1.38-1.383.53.53.53.57 720202.8762.8766.62756.62750 0132.55132.550.000.001010K0+K0+18018099.1399.1399.4299.420.290.293.53.53.53.57 720200.1580.1
5、584.6274.6271.5171.5172.31352.313530.3430.3446.2746.271111K0+K0+20020099.1899.1899.1399.13-0.05-0.053.53.53.53.57 720200.0090.0094.7674.7670.08350.08354.6974.6971.671.6793.9493.941212K0+K0+22022099.0799.0798.8498.84-0.23-0.233.53.53.53.57 7202011.19311.1930.00450.00457.987.980.090.09159.60159.601313
6、K0+K0+24024099.0899.0898.5598.55-0.53-0.533.53.53.53.57 720200.5870.58712.16612.1660.29350.2935 11.679511.67955.875.87233.59233.591414K0+K0+26026099.0899.0898.2698.26-0.82-0.823.53.53.53.57 7202016.44116.4410.29350.2935 14.303514.30355.875.87286.07286.071515K0+K0+28028097.8697.8697.9797.970.110.113.
7、53.53.53.57 720200.0710.0712.42.40.03550.03559.42059.42050.710.71188.41188.411616K0+K0+30030097.2897.2897.6897.680.40.43.53.53.53.57 720200.6120.6120.2670.2670.34150.34151.33351.33356.836.8326.6726.671717K0+K0+32032096.8796.8797.3997.390.520.523.53.53.53.57 720201.4431.4431.02751.02750.13350.133520.
8、5520.552.672.671818K0+K0+34034096.6496.6497.0997.090.450.453.53.53.53.57 720200.9250.9250.0090.0091.1841.1840.00450.004523.6823.680.090.091919K0+K0+36036096.1596.1596.896.80.650.653.53.53.53.57 720202.9162.9161.92051.92050.00450.004538.4138.410.090.092020K0+K0+38038096.1396.1396.5996.590.460.463.53.
9、53.53.57 720201.0051.0050.0010.0011.96051.96050.00050.000539.2139.210.010.012121K0+K0+40040095.9395.9396.5196.510.580.583.53.53.53.57 720202.1252.1251.5651.5650.00050.000531.3031.300.010.012222K0+K0+42042095.8995.8996.5196.510.620.623.53.53.53.57 720202.6732.6732.3992.3990 047.9847.980.000.002323K0+
10、K0+44044095.4495.4496.5196.511.071.073.53.53.53.57 720208.6618.6615.6675.6670 0113.34113.340.000.002424K0+K0+44144192.4492.4496.5196.514.074.070.910.9110.1210.129.39059.39050 08.558.550.000.00白白潭潭湖湖一一桥桥2626K0+K0+48448495.4895.4896.5196.511.031.0343.0443.049.25669.25669.68839.68830 00.000.00白白潭潭湖湖一一桥
11、桥2727K0+K0+50050094.8394.8396.5196.511.681.6816.0516.0517.2817.2813.268313.26830 0212.96212.960.000.00白白潭潭湖湖一一桥桥2828K0+K0+52052094.2794.2796.5196.512.242.243.53.53.53.57 7202045.65145.65131.465531.46550 0629.31629.310.000.002929K0+K0+54054095.1595.1596.5196.511.361.363.53.53.53.57 7202010.90110.9012
12、8.27628.2760 0565.52565.520.000.003030K0+K0+56056094.794.796.5196.511.811.813.53.53.53.57 7202016.76616.76613.833513.83350 0276.67276.670.000.003131K0+K0+58058094.594.596.5196.512.012.013.53.53.53.57 7202041.05641.05628.91128.9110 0578.22578.220.000.003232K0+K0+60060094.4294.4296.5196.512.092.093.53
13、.53.53.57 7202042.64342.64341.849541.84950 0836.99836.990.000.003333K0+K0+62062095.4195.4196.5196.511.11.13.53.53.53.57 7202025.18825.18833.915533.91550 0678.31678.310.000.00第 1 页,共 5 页3434K0+K0+64064095.1595.1596.5196.511.361.363.53.53.53.57 7202029.40729.40727.297527.29750 0545.95545.950.000.00353
14、5K0+K0+66066094.5494.5496.5196.511.971.973.53.53.53.57 7202040.38240.38234.894534.89450 0697.89697.890.000.003636K0+K0+68068094.0894.0896.5196.512.432.433.53.53.53.57 7202049.14349.14344.762544.76250 0895.25895.250.000.003737K0+K0+72072093.9893.9896.5196.512.532.533.53.53.53.57 7404051.251.250.17155
15、0.17150 02006.862006.860.000.003838K0+K0+74074093.9393.9396.5196.512.582.583.53.53.53.57 7202052.15952.15951.679551.67950 01033.591033.590.000.003939K0+K0+76076094.1694.1696.5196.512.352.353.53.53.53.57 7202039.08339.08345.62145.6210 0912.42912.420.000.004040K0+K0+78078095.295.296.5196.511.311.313.5
16、3.53.53.57 7202028.5728.5733.826533.82650 0676.53676.530.000.004141K0+K0+80080095.5795.5796.5196.510.940.943.53.53.53.57 7202022.67622.67625.62325.6230 0512.46512.460.000.004242K0+K0+82082095.7795.7796.5196.510.740.743.53.53.53.57 7202023.1223.1222.89822.8980 0457.96457.960.000.004343K0+K0+84084095.
17、7595.7596.5196.510.760.763.53.53.53.57 720207.2297.22915.174515.17450 0303.49303.490.000.004444K0+K0+86086095.2595.2596.5196.511.261.263.53.53.53.57 7202025.83125.83116.5316.530 0330.60330.600.000.004545K0+K0+88088093.6593.6596.5196.512.862.863.53.53.53.57 7202055.755.740.765540.76550 0815.31815.310
18、.000.004646K0+K0+90090093.6493.6496.5196.512.872.873.53.53.53.57 7202055.80555.80555.752555.75250 01115.051115.050.000.004747K0+K0+92092093.8893.8896.5196.512.632.633.53.53.53.57 7202050.84450.84453.324553.32450 01066.491066.490.000.004848K0+K0+94094094.0794.0796.5196.512.442.443.53.53.53.57 7202047
19、.19747.19749.020549.02050 0980.41980.410.000.004949K0+K0+96096094.5794.5796.5196.511.941.943.53.53.53.57 7202037.57937.57942.38842.3880 0847.76847.760.000.005050K0+K0+98098094.9994.9996.5196.511.521.523.53.53.53.57 7202013.13113.13125.35525.3550 0507.10507.100.000.005151K1+K1+0 095.2295.2296.5196.51
20、1.291.293.53.53.53.57 7202010.2910.2911.710511.71050 0234.21234.210.000.00525218558.1318558.132003.032003.035353K1+K1+202093.3193.3196.5196.513.23.23.53.53.53.57 7202034.16834.1680.1080.10822.22922.2290.0540.054444.58444.581.081.085454K1+K1+404039.2839.2896.5196.5157.2357.233.53.53.53.57 7202037.582
21、37.58235.87535.8750.0540.054717.50717.501.081.085555K1+K1+606036.3136.3196.5196.5160.260.23.53.53.53.57 7202036.94836.94837.26537.2650 0745.30745.300.000.005656K1+K1+808093.3593.3596.5196.513.163.163.53.53.53.57 7202036.18936.18936.568536.56850 0731.37731.370.000.005757K1+K1+10010039.3339.3396.5196.
22、5157.1857.183.53.53.53.57 7202036.70736.70736.44836.4480 0728.96728.960.000.005858K1+K1+12012093.3193.3196.5196.513.23.23.53.53.53.57 7202036.98536.98536.84636.8460 0736.92736.920.000.005959K1+K1+14014093.8593.8596.5196.512.662.663.53.53.53.57 7202027.31927.31932.15232.1520 0643.04643.040.000.006060
23、K1+K1+16016094.0294.0296.5196.512.492.493.53.53.53.57 7202024.62924.62925.97425.9740 0519.48519.480.000.006161K1+K1+18018093.9993.9996.5196.512.522.523.53.53.53.57 7202025.12425.12424.876524.87650 0497.53497.530.000.006262K1+K1+20020093.9493.9496.5196.512.572.573.53.53.53.57 7202025.83925.83925.4815
24、25.48150 0509.63509.630.000.006363K1+K1+22022093.9193.9196.5196.512.62.63.53.53.53.57 7202026.32426.32426.081526.08150 0521.63521.630.000.006464K1+K1+24024093.8893.8896.5196.512.632.633.53.53.53.57 7202026.89626.89626.6126.610 0532.20532.200.000.006565K1+K1+26026093.8593.8596.5196.512.662.663.53.53.
25、53.57 7202027.31927.31927.107527.10750 0542.15542.150.000.00路路基基土土方方工工程程量量表表序序号号桩桩号号现现状状高高程程 设设计计高高程程 挖挖填填高高度度设设计计主主路路宽宽度度距距离离断断面面积积(m2)m2)平平均均面面积积(m2)m2)土土方方数数(m3)(m3)备备注注左左路路基基右右路路基基 路路宽宽填填挖挖填填挖挖填填挖挖第 2 页,共 5 页6666K1+K1+30030095.7595.7596.5296.520.770.773.53.53.53.57 7404013.2613.2620.289520.28950
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 市政道路 土方 EXCEL 计算 公式
限制150内