排水管沟槽土方量自动计算---Excel版
排水土方开挖(135度）(300:1.27;400:1.39;500:1.52;600:1.85;800:2.13;1000:2.41;1200:2.88;1350:3管径底宽长度深度1深度2坡度面积体积
200 1.10.850.8500.9350
300 1.27 1.1 1.10 1.3970
400 1.39 1.2 1.30 1.73750
1.39 1.173 1.1730.67
2.5523420
1.39 1.173 1.1730.67
2.5523420
500 1.52 1.32 1.40 2.06720
1.52 1.3 1.30 1.9760
1.52 1.8 1.60.67 4.5270
1.52 1.5 1.70.67 4.15390
1.52 1.35 1.30.67 3.1906880
1.52 1.325 1.3250.67 3.1902690
1.52 1.5 1.50.67 3.78750
1.52 1.35 1.30.67 3.1906880
1.52 1.3 1.30.67 3.10830
1.52 1.31 1.310.67 3.1409870
1.52 1.31 1.310.67 3.1409870
1.52 1.3 1.30.67 3.10830
1.52 1.4 1.40.67 3.44120
800 2.13 1.5 1.50.67 4.70250
2.13 1.4 1.40.67 4.29520
2.13 1.575 1.50.67 4.8596340
2.13 1.605 1.50.67 4.9235430
2.13 1.5 1.6250.67 4.9664840
2.13 1.605 1.50.67 4.9235430
2.13 1.4 1.40.67 4.29520
2.13 1.5 1.5250.67 4.7544590
2.13 1.58 1.40.67 4.6665940
2.13 1.59 1.40.67 4.6878640
2.13 1.5 1.50.67 4.70250
填方0挖方0
总挖方:0
总填方:0
扣减体积
管径底宽深度1深度2长度
坡度0300
1.3 1.5 1.90.670 1.3 1.9
2.30.670 1.3 2.61 1.880.670 1.3 2.694 2.10.670400
1.43 3.024
2.8630.670 1.43 1.15 1.150.670 1.43 1.15 1.180.670500
1.57 3.878 3.6480.670 1.57 3.623 3.3080.670 1.57 3.278 3.10.670800
2.2
3.978 3.9780.670 2.2 1.92 2.770.670 2.2 1.7 2.520.670 2.2 1.7 2.60.670 2.2 1.58 1.620.670 2.2 1.48 1.630.670 2.2 1.58 1.630.670 2.2 1.55 1.60.6701000
2.5 2.5 2.50.670 2.5 2.44 1.70.670 2.5 2.44 1.70.670 2.5 1.7 1.70.670 2.5 1.78 2.050.670 2.5 1.78 1.860.670 2.5 1.85 1.850.670 2.5 1.78 1.850.670 2.5 1.75 1.880.670 2.5 1.88 1.880.670
1200
2.97 2.34
2.380.67填方
800:2.13;1000:2.41;1200:2.88;1350:3.08;1500:3.33)排 水 土 方 开 挖(180度）(300:1.3;400:1.43;500:1.57;600:1.9;800:2.2;1000
.43;500:1.57;600:1.9;800:2.2;1000:2.5;1200:2.97;1350:3.18;1500:3.45)面积体积扣减体积
4.173100
5.711500
6.38457800
7.02475800
10.0185600
2.53057500
2.57544200
15.4040800
13.5039500
11.8257500
19.35400
8.96436600
7.73753400
7.9627500
5.23546800
5.04484600
5.25735600
5.12743800
10.437500
8.13760600
8.13760600
6.186300
7.25675200
6.7703800
6.91807500
6.74545200
6.74746200
7.06804800
10.741100
挖方0