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

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

路基土方工程量表序号 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 26 27 28 29 30 31 32 桩号 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+ 0 20 40 60 80 100 120 140 160 180 200 220 240 260 280 300 320 340 360 380 400 420 440 441 484 500 520 540 560 580 600 现状高程 设计高程 挖填高度 97.68 98.42 99.53 100.05 99.91 99.56 99.38 99.02 99.09 99.13 99.18 99.07 99.08 99.08 97.86 97.28 96.87 96.64 96.15 96.13 95.93 95.89 95.44 92.44 95.48 94.83 94.27 95.15 94.7 94.5 94.42 97.88 98.28 98.69 99.09 99.49 99.89 100.11 100 97.71 99.42 99.13 98.84 98.55 98.26 97.97 97.68 97.39 97.09 96.8 96.59 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 96.51 0.2 -0.14 -0.84 -0.96 -0.42 0.33 0.73 0.98 -1.38 0.29 -0.05 -0.23 -0.53 -0.82 0.11 0.4 0.52 0.45 0.65 0.46 0.58 0.62 1.07 4.07 1.03 1.68 2.24 1.36 1.81 2.01 2.09 设计主路宽度 距离 左路基 右路基 路宽 3.5 3.5 7 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 0.91 43.04 16.05 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 20 断面积(m2) 填 挖 0.195 1.645 6.065 15.714 17.838 0.068 7.43 1.763 0.411 9.576 10.379 2.876 0.158 4.627 0.009 4.767 11.193 0.587 12.166 16.441 0.071 2.4 0.612 0.267 1.443 0.925 0.009 2.916 1.005 0.001 2.125 2.673 8.661 10.12 9.2566 17.28 45.651 10.901 16.766 41.056 42.643 平均面积(m2) 填 挖 0.0975 3.855 0 10.8895 0 16.776 0.034 12.634 0.9155 3.9205 5.6695 0.2055 9.9775 0 6.6275 0 1.517 2.3135 0.0835 4.697 0.0045 7.98 0.2935 11.6795 0.2935 14.3035 0.0355 9.4205 0.3415 1.3335 1.0275 0.1335 1.184 0.0045 1.9205 0.0045 1.9605 0.0005 1.565 0.0005 2.399 0 5.667 0 9.3905 0 9.6883 0 13.2683 0 31.4655 0 28.276 0 13.8335 0 28.911 0 41.8495 0 土方数(m3) 填 挖 1.95 0.00 0.00 0.68 18.31 113.39 199.55 132.55 30.34 1.67 0.09 5.87 5.87 0.71 6.83 20.55 23.68 38.41 39.21 31.30 47.98 113.34 8.55 212.96 629.31 565.52 276.67 578.22 836.99 备注

77.10 217.79 335.52 252.68 78.41 4.11 0.00 0.00 46.27 93.94 159.60 233.59 286.07 188.41 26.67 2.67 0.09 0.09 0.01 0.01 0.00 0.00 0.00 白潭湖一桥 0.00 白潭湖一桥 0.00 白潭湖一桥 0.00 0.00 0.00 0.00 0.00

第 1 页，共 5 页

路基土方工程量表