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

路基土方工程量表序号 64 65 66 67 68 69 70 71 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 桩号 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+ 240 260 300 320 340 360 380 400 420 440 460 480 500 520 540 560 580 600 620 640 660 680 700 720 740 760 780 800 820 840 880 现状高程 设计高程 挖填高度 93.88 93.85 95.75 94.95 94.98 94.93 94.91 94.9 94.81 96.06 94.42 94.53 94.61 94.6 94.54 94.44 94.35 96.07 95.57 95.25 95.26 96.33 95.3 94.06 94.19 94.3 95.77 95.92 95.59 95.79 95.02 96.51 96.51 96.52 96.53 96.54 96.55 96.56 96.58 96.59 96.6 69.62 96.63 96.64 96.65 96.67 69.68 69.69 69.7 96.72 96.73 96.74 96.76 96.77 96.78 69.79 96.79 96.79 96.78 96.77 96.76 96.74 2.63 2.66 0.77 1.58 1.56 1.62 1.65 1.68 1.78 0.54 -24.8 2.1 2.03 2.05 2.13 -24.76 -24.66 -26.37 1.15 1.48 1.48 0.43 1.47 2.72 -24.4 2.49 1.02 0.86 1.18 0.97 1.72 设计主路宽度 距离 左路基 右路基 路宽 3.5 3.5 7 20 3.5 3.5 7 20 3.5 3.5 7 40 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 2

0 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 40 断面积(m2) 填 挖 26.896 27.319 13.26 38.943 38.531 39.948 20.672 18.066 9.045 3.704 0.902 11.132 12.665 3.322 11.802 3.786 11.154 4.152 11.362 4.033 11.992 4.086 13.094 3.496 13.819 3.211 2.628 17.556 25.996 6.713 4.112 11.217 0.039 9.472 39.77 37.668 35.66 14.144 1.117 21.95 26.982 23.541 36.143 平均面积(m2) 填 挖 26.61 0 27.1075 0 20.2895 0 26.1015 0 38.737 0 39.2395 0 30.31 0 19.369 0 13.5555 1.852 4.9735 7.418 6.7835 7.227 12.2335 3.554 11.478 3.969 11.258 4.0925 11.677 4.0595 12.543 3.791 13.4565 3.3535 8.2235 1.6055 10.092 0 21.776 0 16.3545 2.056 8.965 2.0755 10.3445 0.0195 24.621 0 38.719 0 36.664 0 24.902 0.5585 18.047 0.5585 24.466 0 25.2615 0 29.842 0 土方数(m3) 填 挖 532.20 0.00 542.15 0.00 811.58 0.00 522.03 0.00 774.74 0.00 784.79 0.00 606.20 0.00 387.38 0.00 271.11 37.04 99.47 148.36 135.67 144.54 244.67 71.08 229.56 79.38 225.16 81.85 233.54 81.19 250.86 75.82 269.13 67.07 164.47 32.11 201.84 0.00 435.52 0.00 327.09 41.12 179.30 41.51 206.89 0.39 492.42 0.00 774.38 0.00 733.28 0.00 498.04 11.17 360.94 11.17 489.32 0.00 505.23 0.00 1193.68 0.00 备注

第 3 页，共 5 页

路基土方工程量表