市政道路土方EXCEL计算表(含公式)

序号12345678910111213141516171819202122232426272829303132桩号K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+020406080100120140160180200220240260280300320340360380400420440441484500520540560580600现状高程设计高程挖填高度97.6898.4299.53100.0599.9199.5699.3899.0299.0999.1399.1899.0799.0899.0897.8697.2896.8796.6496.1596.1395.9395.8995.4492.4495.4894.8394.2795.1594.794.594.4297.8898.2898.6999.0999.4999.89100.1110097.7199.4299.1398.8498.5598.2697.9797.6897.3997.0996.896.5996.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.510.2-0.14-0.84-0.96-0.420.330.730.98-1.380.29-0.05-0.23-0.53-0.820.110.40.520.450.650.460.580.621.074.071.031.682.241.361.812.012.09设计主路宽度距离左路基右路基路宽3.53.573.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57200.9143.0416.053.53.57203.53.57203.53.57203.53.57203.53.5720断面积（m2)填挖0.1951.6456.06515.71417.8380.0687.431.7630.4119.57610.3792.8760.1584.6270.0094.76711.1930.58712.16616.4410.0712.40.6120.2671.4430.9250.0092.9161.0050.0012.1252.6738.66110.129.256617.2845.65110.90116.76641.05642.643平均面积（m2)填挖0.09753.855010.8895016.7760.03412.6340.91553.92055.66950.20559.977506.627501.5172.31350.08354.6970.00457.980.293511.67950.293514.30350.03559.42050.34151.33351.02750.13351.1840.00451.92050.00451.96050.00051.5650.00052.39905.66709.390509.6883013.2683031.4655028.276013.8335028.911041.84950土方数(m3)填挖1.950.000.000.6818.31113.39199.55132.5530.341.670.095.875.870.716.8320.5523.6838.4139.2131.3047.98113.348.55212.96629.31565.52276.67578.22836.99备注77.10217.79335.52252.6878.414.110.000.0046.2793.94159.60233.59286.07188.4126.672.670.090.090.010.010.000.000.00白潭湖一桥0.00白潭湖一桥0.00白潭湖一桥0.000.000.000.000.00第 1 页，共 5 页

路基土方工程量表

序号33343536373839404142434445464748495051525354555657585960616263桩号K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K0+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+620640660680720740760780800820840860880900920940960980020406080100120140160180200220现状高程设计高程挖填高度95.4195.1594.5494.0893.9893.9394.1695.295.5795.7795.7595.2593.6593.6493.8894.0794.5794.9995.2293.3139.2836.3193.3539.3393.3193.8594.0293.9993.9493.9196.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.5196.511.11.361.972.432.532.582.351.310.940.740.761.262.862.872.632.441.941.521.293.257.2360.23.1657.183.22.662.492.522.572.6设计主路宽度距离左路基右路基路宽3.53.57203.53.57203.53.57203.53.57203.53.57403.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.5777777777772020202020202020202020断面积（m2)填挖25.18829.40740.38249.14351.252.15939.08328.5722.67623.127.22925.83155.755.80550.84447.19737.57913.13110.2934.16837.58236.94836.18936.70736.98527.31924.62925.12425.83926.3240.108平均面积（m2)填挖33.9155027.2975034.8945044.7625050.1715051.6795045.621033.8265025.623022.898015.1745016.53040.7655055.7525053.3245049.0205042.388025.355011.7105022.22935.87537.26536.568536.44836.84632.15225.97424.876525.481526.08150.0540.054000000000土方数(m3)填挖678.310.00545.950.00697.890.00895.250.002006.860.001033.590.00912.420.00676.530.00512.460.00457.960.00303.490.00330.600.00815.310.001115.050.001066.490.00980.410.00847.760.00507.100.00234.210.0018558.132003.03444.581.08717.501.08745.300.00731.370.00728.960.00736.920.00643.040.00519.480.00497.530.00509.630.00521.630.00备注第 2 页，共 5 页

路基土方工程量表

序号64656667686970717374757677787980818283848586878889909192939495桩号K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+K1+240260300320340360380400420440460480500520540560580600620640660680700720740760780800820840880现状高程设计高程挖填高度93.8893.8595.7594.9594.9894.9394.9194.994.8196.0694.4294.5394.6194.694.5494.4494.3596.0795.5795.2595.2696.3395.394.0694.1994.395.7795.9295.5995.7995.0296.5196.5196.5296.5396.5496.5596.5696.5896.5996.669.6296.6396.6496.6596.6769.6869.6969.796.7296.7396.7496.7696.7796.7869.7996.7996.7996.7896.7796.7696.742.632.660.771.581.561.621.651.681.780.54-24.82.12.032.052.13-24.76-24.66-26.371.151.481.480.431.472.72-24.42.491.020.861.180.971.72设计主路宽度距离左路基右路基路宽3.53.57203.53.57203.53.57403.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.5740断面积（m2)填挖26.89627.31913.2638.94338.53139.94820.67218.0669.0453.7040.90211.13212.6653.32211.8023.78611.1544.15211.3624.03311.9924.08613.0943.49613.8193.2112.62817.55625.9966.7134.11211.2170.0399.47239.7737.66835.6614.1441.11721.9526.98223.54136.143平均面积（m2)填挖26.61027.1075020.2895026.1015038.737039.2395030.31019.369013.55551.8524.97357.4186.78357.22712.23353.55411.4783.96911.2584.092511.6774.059512.5433.79113.45653.35358.22351.605510.092021.776016.35452.0568.9652.075510.34450.019524.621038.719036.664024.9020.558518.0470.558524.466025.2615029.8420土方数(m3)填挖532.200.00542.150.00811.580.00522.030.00774.740.00784.790.00606.200.00387.380.00271.1137.0499.47148.36135.67144.54244.6771.08229.5679.38225.1681.85233.5481.19250.8675.82269.1367.07164.4732.11201.840.00435.520.00327.0941.12179.3041.51206.890.39492.420.00774.380.00733.280.00498.0411.17360.9411.17489.320.00505.230.001193.680.00备注第 3 页，共 5 页

路基土方工程量表

序号96979899100101102103104105106107108109110111112113114115116117118119120121122123124125126桩号K1+K1+K1+K1+K1+K2+K2+K2+K2+K2+K2+K2+K2+K2+K2+K2+K2+K2+K2+K2+K2+K2+K2+K2+K2+K2+K2+K2+K2+K2+900920940960980020406080100120140160180200240260280300320340360380400420440460480500现状高程设计高程挖填高度95.7595.7795.6195.6694.7294.9595.0195.3295.6395.6395.6295.795.7795.7895.7795.7695.7695.7595.7395.5490.7290.5690.7291.7295.3595.3295.395.5795.7795.6596.7396.7296.7196.6996.6996.6896.6696.6696.6596.6496.6396.6296.6196.696.5996.5896.5696.5596.5496.5395.5296.596.4896.4596.4196.3796.3496.396.2696.230.980.951.11.031.971.731.651.341.021.011.010.920.840.820.820.820.80.80.810.994.85.945.764.731.061.051.040.730.490.58设计主路宽度距离左路基右路基路宽3.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.53.5777777777777777777777777202020202020202020204020202020202020202020202020断面积（m2)填挖23.80723.3725.65924.76840.66539.41135.07629.67124.37324.26224.23122.84221.64521.3421.37121.3421.05321.05321.08327.338120.72113.3108.1280.64113.83511.74511.6079.0427.3277.856平均面积（m2)填挖29.975023.5885024.5145025.2135032.7165040.038037.243532.373527.02224.317524.246523.536522.243521.492521.355521.355521.196521.05321.06824.210574.029117.01110.7194.380547.23812.7911.67610.32458.18457.59150000000000000000000.1870.4360.5181.38652.97153.468土方数(m3)填挖599.500.00471.770.00490.290.00504.270.00654.330.00800.760.0023799.50925.96744.870.00647.470.00540.440.00486.350.00484.930.00470.730.00444.870.00429.850.00427.110.00427.110.00847.860.00421.060.00421.360.00484.210.001480.580.002340.200.002214.200.001887.610.00944.763.74255.808.72233.5210.36206.4927.73163.6959.43151.8369.36备注0.3740.4980.5382.2353.7083.228第 4 页，共 5 页

路基土方工程量表

序号127128129130131132133134135桩号K2+K2+K2+K2+K2+K2+K2+K2+K2+520540560580600620640660680现状高程设计高程挖填高度95.2895.2795.2394.8694.4695.1194.9894.759596.1996.1596.1296.0896.0496.0195.9795.9395.90.910.880.891.221.580.90.991.180.9设计主路宽度距离左路基右路基路宽3.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.57203.53.5720断面积（m2)填挖10.4550.89210.2141.35110.2421.33413.3250.07618.07210.2861.30811.1490.67410.5510.8758.5373.487平均面积（m2)填挖9.15552.0610.33451.121510.2281.342511.78350.70515.69850.03814.1790.65410.71750.99110.850.77459.5442.181土方数(m3)填挖183.1141.20206.6922.43204.5626.85235.6714.10313.970.76283.5813.08214.3519.82217.0015.49190.8843.6219206.71376.6961564.343305.68备注第 5 页，共 5 页