沟槽开挖土方量自动计算程序.xls

1、排 水 土 方 开 挖(135度）(300:1.27;400:1.39;500:1.52;600:1.85;800:2.13;1000:2.41;1200:2.88;1350:3.08;1500:3.33)管径底宽长度深度1深度2坡度面积体积2001.10.850.8500.93503001.271.11.101.39704001.391.21.301.737501.391.1731.1730.672.55234201.391.1731.1730.672.55234205001.521.321.402.067201.521.31.301.97601.521.81.60.674.52701.52

2、1.51.70.674.153901.521.351.30.673.19068701.521.3251.3250.673.19026901.521.51.50.673.787501.521.351.30.673.19068701.521.31.30.673.108301.521.311.310.673.14098701.521.311.310.673.14098701.521.31.30.673.108301.521.41.40.673.441208002.131.51.50.674.702502.131.41.40.674.295202.131.5751.50.674.85963402.13

3、1.6051.50.674.92354302.131.51.6250.674.96648402.131.6051.50.674.92354302.131.41.40.674.295202.131.51.5250.674.75445902.131.581.40.674.66659402.131.591.40.674.68786302.131.51.50.674.70250填方0挖方0总挖方:0总填方:0排 水 土 方 开 挖(180度）(300:1.3;400:1.43;500:1.57;600:1.9;800:2.2;1000:2.5;1200:2.97;1350:3.18;1500:3.45

4、)扣减体积管径底宽深度1深度2长度坡度03001.31.51.90.6701.31.92.30.6701.32.611.880.6701.32.6942.10.6704001.433.0242.8630.6701.431.151.150.6701.431.151.180.6705001.573.8783.6480.6701.573.6233.3080.6701.573.2783.10.6708002.23.9783.9780.6702.21.922.770.6702.21.72.520.6702.21.72.60.6702.21.581.620.6702.21.481.630.6702.21.

5、581.630.6702.21.551.60.67010002.52.52.50.6702.52.441.70.6702.52.441.70.6702.51.71.70.6702.51.782.050.6702.51.781.860.6702.51.851.850.6702.51.781.850.6702.51.751.880.6702.51.881.880.67012002.972.342.380.67填方0排 水 土 方 开 挖(135度）(300:1.27;400:1.39;500:1.52;600:1.85;800:2.13;1000:2.41;1200:2.88;1350:3.08;

6、1500:3.33)面积体积扣减体积4.1731005.7115006.384578007.0247580010.01856002.530575002.5754420015.404080013.503950011.825750019.354008.964366007.737534007.96275005.235468005.044846005.257356005.1274380010.4375008.137606008.137606006.1863007.256752006.77038006.918075006.745452006.747462007.0680480010.741100挖方0排 水 土 方 开 挖(180度）(300:1.3;400:1.43;500:1.57;600:1.9;800:2.2;1000:2.5;1200:2.97;1350:3.18;1500:3.45)