排水管沟土方量自动计算表格(函数)

排水土方开挖(135度）

管径底宽长度深度1深度2坡度面积200 1.10.850.8500.935 300 1.27 1.1 1.10 1.397 400 1.39 1.2 1.30 1.7375

1.39 1.173 1.1730.67

2.55234243

1.39 1.173 1.1730.67

2.55234243

500 1.52 1.32 1.40 2.0672

1.52 1.3 1.30 1.976

1.52 1.8 1.60.67 4.527

1.52 1.5 1.70.67 4.1539

1.52 1.35 1.30.67 3.1906875

1.52 1.325 1.3250.67 3.19026875

1.52 1.5 1.50.67 3.7875

1.52 1.35 1.30.67 3.1906875

1.52 1.3 1.30.67 3.1083

1.52 1.31 1.310.67 3.140987

1.52 1.31 1.310.67 3.140987

1.52 1.3 1.30.67 3.1083

1.52 1.4 1.40.67 3.4412

800 2.13 1.5 1.50.67 4.7025

2.13 1.4 1.40.67 4.2952

2.13 1.575 1.50.67 4.859634375

2.13 1.605 1.50.67 4.923543375

2.13 1.5 1.6250.67 4.966484375

2.13 1.605 1.50.67 4.923543375

2.13 1.4 1.40.67 4.2952

2.13 1.5 1.5250.67 4.754459375

2.13 1.58 1.40.67 4.666594

2.13 1.59 1.40.67 4.6878635

2.13 1.5 1.50.67 4.7025

填方0挖方

总挖方:0

总填方:0

排水土方开挖(180度）

体积扣减体积管径底宽深度1深度2 00300 1.3 1.5 1.9 00 1.3 1.9 2.3 00 1.3 2.61 1.88 00 1.3 2.694 2.1 00400 1.43 3.024 2.863 00 1.43 1.15 1.15 00 1.43 1.15 1.18 00500 1.57 3.878 3.648 00 1.57 3.623 3.308 00 1.57 3.278 3.1 00800 2.2 3.978 3.978 00 2.2 1.92 2.77 00 2.2 1.7 2.52 00 2.2 1.7 2.6 00 2.2 1.58 1.62 00 2.2 1.48 1.63 00 2.2 1.58 1.63 00 2.2 1.55 1.6 001000 2.5 2.5 2.5 00 2.5 2.44 1.7 00 2.5 2.44 1.7 00 2.5 1.7 1.7 00 2.5 1.78 2.05 00 2.5 1.78 1.86 00 2.5 1.85 1.85 00 2.5 1.78 1.85 00 2.5 1.75 1.88 00 2.5 1.88 1.88 001200 2.97 2.34 2.38 0填方

）

长度坡度面积体积扣减体积

0.67 4.173100

0.67 5.711500

0.67 6.384577500

0.677.024758100

0.6710.01855600

0.67 2.53057500

0.67 2.575441500

0.6715.40408400

0.6713.50394800

0.6711.8257500

0.6719.35400400

0.678.964365500

0.677.73753400

0.677.9627500

0.67 5.23546800

0.67 5.044845500

0.67 5.257355500

0.67 5.127437500

0.6710.437500

0.678.13760600

0.678.13760600

0.67 6.186300

0.677.256751500

0.67 6.7703800

0.67 6.91807500

0.67 6.745451500

0.67 6.747461500

0.677.06804800

0.6710.741100

0挖方0