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

断面积（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
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
K1+ 20 K1+ 40 K1+ 60 K1+ 80 K1+ 100 K1+ 120 K1+ 140 K1+ 160 K1+ 180 K1+ 200 K1+ 220
现状高程
设计高程
挖填高度
设计主路宽度 左路基 右路基 路宽
95.41 96.51
路基土方工程量表
序号
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+ 0 K0+ 20 K0+ 40 K0+ 60 K0+ 80 K0+ 100 K0+ 120 K0+ 140 K0+ 160 K0+ 180 K0+ 200 K0+ 220 K0+ 240 K0+ 260 K0+ 280 K0+ 300 K0+ 320 K0+ 340 K0+ 360 K0+ 380 K0+ 400 K0+ 420 K0+ 440 K0+ 441 K0+ 484 K0+ 500 K0+ 520 K0+ 540 K0+ 560 K0+ 580 K0+ 600
1.68
94.27 96.51
2.24 3.5 3.5
7
95.15 96.51
1.36 3.5 3.5
7
94.7 96.51
1.81 3.5 3.5
7
94.5 96.51
2.01 3.5 3.5
7
94.42 96.51
2.09 3.5 3.5
7
距离
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 0.91 43.04 16.05 20 20 20 20 20
96.15
96.8
0.65 3.5 3.5
7
96.13 96.59
0.46 3.5 3.5
7
95.93 96.51
0.58 3.5 3.5
7
95.89 96.51
0.62 3.5 3.5
7
95.44 96.51
1.07 3.5 3.5
7
92.44 96.51
4.07
95.48 96.51
1.03
94.83 96.51
现状高程
设计高程
挖填高度
设计主路宽度 左路基 右路基 路宽
97.68 97.88
0.2 3.5 3.5 7
98.42 98.28 -0.14 3.5 3.5 7
99.53 98.69 -0.84 3.5 3.5 7
100.05 99.09 -0.96 3.5 3.5 7
99.91 99.49 -0.42 3.5 3.5 7
白潭湖一桥 白潭湖一桥 白潭湖一桥
第 1 页，共 5 页
路基土方工程量表
序号
33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63
桩号
K0+ 620 K0+ 640 K0+ 660 K0+ 680 K0+ 720 K0+ 740 K0+ 760 K0+ 780 K0+ 800 K0+ 820 K0+ 840 K0+ 860 K0+ 880 K0+ 900 K0+ 920 K0+ 940 K0+ 960 K0+ 980 K1+ 0
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
99.56 99.89
0.33 3.5 3.5
7
99.38 100.11
0.73 3.5 3.5
7
99.02
100
0.98 3.5 3.5
7
99.09 97.71 -1.38 3.5 3.5 7
99.13 99.42
0.29 3.5 3.5
7
99.18 99.13 -0.05 3.5 3.5 7
99.07 98.84 -0.23 3.5 3.5 7
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
99.08 98.55 -0.53 3.5 3.5 7
99.08 98.26 -0.82 3.5 3.5 7
97.86 97.97
0.11 3.5 3.5
7
97.28 97.68
0.4 3.5 3.5 7
96.87 97.39
0.52 3.5 3.5
7
96.64 97.09
0.45 3.5 3.5
7
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
Fra Baidu bibliotek
5.6695 0.2055