市政道路土方EXCEL计算表含公式xls.xls

1K0+097.6897.880.23.53.570.1951.6452K0+2098.4298.28-0.143.53.57206.0650.09753.8551.95 77.10 3K0+4099.5398.69-0.843.53.572015.714010.88950.00 217.79 4K0+60100.0599.09-0.963.53.572017.838016.7760.00 335.52 5K0+8099.9199.49-0.423.53.57200.0687.430.03412.6340.68 252.68 6K0+10099.5699.890.333.53.57201.7630.4110.91553.920518.31 78.41 7K0+12099.38100.110.733.53.57209.5765.66950.2055113.39 4.11 8K0+14099.021000.983.53.572010.3799.97750199.55 0.00 9K0+16099.0997.71-1.383.53.57202.8766.62750132.55 0.00 10K0+18099.1399.420.293.53.57200.1584.6271.5172.313530.34 46.27 11K0+20099.1899.13-0.053.53.57200.0094.7670.08354.6971.67 93.94 12K0+22099.0798.84-0.233.53.572011.1930.00457.980.09 159.60 13K0+24099.0898.55-0.533.53.57200.58712.1660.293511.67955.87 233.59 14K0+26099.0898.26-0.823.53.572016.4410.293514.30355.87 286.07 15K0+28097.8697.970.113.53.57200.0712.40.03559.42050.71 188.41 16K0+30097.2897.680.43.53.57200.6120.2670.34151.33356.83 26.67 17K0+32096.8797.390.523.53.57201.4431.02750.133520.55 2.67 18K0+34096.6497.090.453.53.57200.9250.0091.1840.004523.68 0.09 19K0+36096.1596.80.653.53.57202.9161.92050.004538.41 0.09 20K0+38096.1396.590.463.53.57201.0050.0011.96050.000539.21 0.01 21K0+40095.9396.510.583.53.57202.1251.5650.000531.30 0.01 22K0+42095.8996.510.623.53.57202.6732.399047.98 0.00 23K0+44095.4496.511.073.53.57208.6615.6670113.34 0.00 24K0+44192.4496.514.070.9110.129.390508.55 0.00 白潭湖一桥26K0+48495.4896.511.0343.049.25669.688300.00 白潭湖一桥27K0+50094.8396.511.6816.0517.2813.26830212.96 0.00 白潭湖一桥28K0+52094.2796.512.243.53.572045.65131.46550629.31 0.00 29K0+54095.1596.511.363.53.572010.90128.2760565.52 0.00 路基土方工程量表序号桩号现状高程设计高程挖填高度设计主路宽度距离断面积（m2)平均面积（m2)土方数(m3)备注左路基右路基路宽填挖填挖填挖