excel弧底梯形渠道土方工程量计算公式(地势平坦区)

桩号地面高程开挖高程渠底高程渠顶高程距离|挖深|填高\设计纵坡 挖方面积 填方面积 清基挖方填方10+086596.068596.819596.919599.219-0.8513.1510.000286 041.607920.679510+102595.982596.814596.914599.21416.00-0.9323.2320.000286 043.269821.04590.00 679.0210+147596.006596.802596.902599.20245.00-0.8963.1960.000286 042.515520.88010.001930.1710+215596.182596.782596.882599.18268.00-0.7003.0000.000286 038.572820.00060.002757.0110+294596.548596.760596.860599.16079.00-0.3122.6120.000286 031.017218.25210.002748.8110+369596.953596.738596.838599.13875.000.1152.1850.0002860.091823.251716.33313.442035.0910+417597.106596.724596.824599.12448.000.2822.0180.0002860.346820.558415.582910.531051.4410+457596.375596.713596.813599.11340.00-0.4382.7380.000286 033.434118.82106.941079.8510+500596.948596.701596.801599.10143.000.1472.1530.0002860.132922.713916.18722.861207.1810+553597.078596.686596.786599.08653.000.2922.0080.0002860.366720.388715.534113.241142.2210+604597.355596.671596.771599.07151.000.5841.7160.0002860.820617.779514.222030.28973.2910+661597.496596.655596.755599.05557.000.7411.5590.0002861.236715.598213.514258.63951.2610+715597.369596.639596.739599.03954.000.6301.6700.0002860.936517.134014.016358.68883.7710+757597.503596.627596.727599.02742.000.7761.5240.0002861.334415.135613.359347.69677.6610+758598.358596.627596.727599.0271.001.6310.6690.0002864.52185.35559.5105 2.93 10.2510+804598.358596.614596.714599.01446.001.6440.6560.0002864.58225.23099.4514209.39243.4910+849598.521596.601596.701599.00145.001.8200.4800.0002865.42353.63848.6600225.13199.56669.7318570.0722243.54桩号地面高程开挖高程渠底高程渠顶高程距离|挖深|填高\设计纵坡挖方面积填方面积清基挖方 填方弧底梯形渠道土方回填工程量计算公式=IF{地面高程<渠底高程,(L1*2+1.25*填高*2)*填高/2-S1,IF[地面高程<(渠底高程+弦高),(L1*2+1.25*填高*2)*填高/2- S1+((R^2)*ACOS((R-挖深)/R)-(R-挖深)*SQRT(R^2-(R-挖深)^2)),IF(地面高程<渠顶高程,(渠堤路1*2+渠堤路2*2+2*(1.25+1)*填高)*填高/2,"0")]}L1=渠口宽+渠堤路1+渠堤路2S1=渠心梯形面积+弧底面积渠心...