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

路基土方工程量表序号 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 桩号 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+ 900 920 940 960 980 0 20 40 60 80 100 120 140 160 180 200 240 260 280 300 320 340 360 380 400 420 440 460 480 500 现状高程 设计高程 挖填高度 95.75 95.77 95.61 95.66 94.72 94.95 95.01 95.32 95.63 95.63 95.62 95.7 95.77 95.78 95.77 95.76 95.76 95.75 95.73 95.54 90.72 90.56 90.72 91.72 95.35 95.32 95.3 95.57 95.77 95.65 96.73 96.72 96.71 96.69 96.69 96.68 96.66 96.66 96.65 96.64 96.63 96.62 96.61 96.6 96.59 96.58 96.56 96.55 96.54 96.53 95.52 96.5 96.48 96.45 96.41 96.37 96.34 96.3 96.26 96.23 0.98 0.95 1.1 1.03 1.97 1.73 1.65 1.34 1.02 1.01 1.01 0.92 0.84 0.82 0.82 0.82 0.8 0.8 0.81 0.99 4.8 5.94 5.76 4.73 1.06 1.05 1.04 0.73 0.49 0.58 设计主路宽度 距离 左路基 右路基 路宽 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 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 3.5 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 20 20 20 20 20 20 20 20 20 20 40 20 20 20 20 20 20 20 20 20 20 20 20 20 断面积(m2) 填 挖 23.807 23.37 25.659 24.768 40.665 39.411 35.076 29.671 24.373 24.262 24.231 22.842 21.645 21.34 21.371 21.34 21.053 21.053 21.083 27.338 120.72 113.3 108.12 80.641 13.835 11.745 11.607 9.042 7.327 7.856 平均面积(m2) 填 挖 29.975 0 23.5885 0 24.5145 0 25.

2135 0 32.7165 0 40.038 0 37.2435 32.3735 27.022 24.3175 24.2465 23.5365 22.2435 21.4925 21.3555 21.3555 21.1965 21.053 21.068 24.2105 74.029 117.01 110.71 94.3805 47.238 12.79 11.676 10.3245 8.1845 7.5915 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.187 0.436 0.518 1.3865 2.9715 3.468 土方数(m3) 填 挖 599.50 0.00 471.77 0.00 490.29 0.00 504.27 0.00 654.33 0.00 800.76 0.00 23799.50 925.96 744.87 0.00 647.47 0.00 540.44 0.00 486.35 0.00 484.93 0.00 470.73 0.00 444.87 0.00 429.85 0.00 427.11 0.00 427.11 0.00 847.86 0.00 421.06 0.00 421.36 0.00 484.21 0.00 1480.58 0.00 2340.20 0.00 2214.20 0.00 1887.61 0.00 944.76 3.74 255.80 8.72 233.52 10.36 206.49 27.73 163.69 59.43 151.83 69.36 备注

0.374 0.498 0.538 2.235 3.708 3.228

第 4 页，共 5 页

路基土方工程量表