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

半径渠深倾角口宽sincostan弧底梯形渠0.51.0452.410.7070.7071.000U型渠0.51.0141.280.2420.9700.249干渠1.52.0455.240.7070.7071.000H弦l弦S弧底S梯S渠0.1460.7070.0711.3321.4030.3790.9700.2730.6990.9720.4392.1210.6425.7466.388桩号地面高程开挖高程渠底高程渠顶高程距离|挖深|填高\设计纵坡挖方面积填方面积清基挖方填方10+086596.068596.819596.919599.219-0.8513.1510.000286041.607920.679510+102595.982596.814596.914599.21416.00-0.9323.2320.000286043.269821.04590.00679.0210+147596.006596.802596.902599.20245.00-0.8963.1960.000286042.515520.88010.001930.1710+215596.182596.782596.882599.18268.00-0.7003.0000.000286038.572820.00060.002757.0110+294596.548596.760596.860599.16079.00-0.3122.6120.000286031.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.000286033.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.51052.9310.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=渠心梯形面积+弧底面积渠心梯形面积=（渠口宽+R*√2）*(渠高-弦高)/2弧底面积=∏R2/4-R2/2弦高=R-R/√2填高=渠顶高程-地面高程挖深=地面高程-渠底高程（说明在区间2范围内用挖方公式中计算弧底面积再作差）R为设计弧底半径弧底梯形渠道土方开挖工程量计算公式=IF{地面高程渠顶高程,S1+L2*(地面高程-渠顶高程)+(地面高程-渠顶高程)^2*0.5,IF[地面高程(渠底高程+弦高),弦长*(挖深-弦高)+(挖深-弦高)^2*1+弧底面积,IF(地面高程渠底高程,(R^2)*ACOS((R-挖深)/R)-(R-挖深)*SQRT(R^2-(R-挖深)^2),0)]}L2=渠口宽+马道1+马道2S1=渠心梯形面积+弧底面积渠心梯形面积=（渠口宽+R*√2）*(渠高-弦高)/2弧底面积=∏R2/4-R2/2弦高=R-R/√2弦长=R*√2填高=渠顶高程-地面高程挖深=地面高程-渠底高程（说明在区间2范围内用挖方公式中计算弧底面积再作差）R为设计弧底半径桩号地面高程开挖高程渠底高程渠顶高程距离|挖深|填高\设计纵坡挖方面积填方面积清基挖方填方弧底梯形渠道土方回填工程量计算公式=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=渠心梯形面积+弧底面积渠心梯形面积=（渠口宽+R*√2）*(渠高-弦高)/2弧底面积=∏R2/4-R2/2弦高=R-R/√2填高=渠顶高程-地面高程挖深=地面高程-渠底高程（说明在区间2范围内用挖方公式中计算弧底面积再作差）R为设计弧底半径弧底梯形渠道土方开挖工程量计算公式=IF{地面高程渠顶高程,S1+L2*(地面高程-渠顶高程)+(地面高程-渠顶高程)^2*0.5,IF[地面高程(渠底高程+弦高),弦长*(挖深-弦高)+(挖深-弦高)^2*1+弧底面积,IF(地面高程渠底高程,(R^2)*ACOS((R-挖深)/R)-(R-挖深)*SQRT(R^2-(R-挖深)^2),0)]}L2=渠口宽+马道1+马道2S1=渠心梯形面积+弧底面积渠心梯形面积=（渠口宽+R*√2）*(渠高-弦高)/2弧底面积=∏R2/4-R2/2弦高=R-R/√2弦长=R*√2填高=渠顶高程-地面高程挖深=地面高程-渠底高程（说明在区间2范围内用挖方公式中计算弧底面积再作差）R为设计弧底半径桩号地面高程开挖高程渠底高程渠顶高程距离|挖深|填高\设计纵坡挖方面积填方面积清基挖方填方弧底梯形渠道土方回填工程量计算公式=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=渠心梯形面积+弧底面积渠心梯形面积=（渠口宽+R*√2）*(渠高-弦高)/2弧底面积=∏R2/4-R2/2弦高=R-R/√2填高=渠顶高程-地面高程挖深=地面高程-渠底高程（说明在区间2范围内用挖方公式中计算弧底面积再作差）R为设计弧底半径弧底梯形渠道土方开挖工程量计算公式=IF{地面高程渠顶高程,S1+L2*(地面高程-渠顶高程)+(地面高程-渠顶高程)^2*0.5,IF[地面高程(渠底高程+弦高),弦长*(挖深-弦高)+(挖深-弦高)^2*1+弧底面积,IF(地面高程渠底高程,(R^2)*ACOS((R-挖深)/R)-(R-挖深)*SQRT(R^2-(R-挖深)^2),0)]}L2=渠口宽+马道1+马道2S1=渠心梯形面积+弧底面积渠心梯形面积=（渠口宽+R*√2）*(渠高-弦高)/2弧底面积=∏R2/4-R2/2弦高=R-R/√2弦长=R*√2填高=渠顶高程-地面高程挖深=地面高程-渠底高程（说明在区间2范围内用挖方公式中计算弧底面积再作差）R为设计弧底半径清基大100.14大283.00大416.98大453.29大389.08大229.80大206.42大225.80大252.18大227.63大237.14大223.00大172.47大3.43大130.84大122.25大3673.47清基弧底梯形渠道土方回填工程量计算公式=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=渠心梯形面积+弧底面积渠心梯形面积=（渠口宽+R*√2）*(渠高-弦高)/2弧底面积=∏R2/4-R2/2弦高=R-R/√2填高=渠顶高程-地面高程挖深=地面高程-渠底高程（说明在区间2范围内用挖方公式中计算弧底面积再作差）R为设计弧底半径弧底梯形渠道土方开挖工程量计算公式=IF{地面高程渠顶高程,S1+L2*(地面高程-渠顶高程)+(地面高程-渠顶高程)^2*0.5,IF[地面高程(渠底高程+弦高),弦长*(挖深-弦高)+(挖深-弦高)^2*1+弧底面积,IF(地面高程渠底高程,(R^2)*ACOS((R-挖深)/R)-(R-挖深)*SQRT(R^2-(R-挖深)^2),0)]}L2=渠口宽+马道1+马道2S1=渠心梯形面积+弧底面积渠心梯形面积=（渠口宽+R*√2）*(渠高-弦高)/2弧底面积=∏R2/4-R2/2弦高=R-R/√2弦长=R*√2填高=渠顶高程-地面高程挖深=地面高程-渠底高程（说明在区间2范围内用挖方公式中计算弧底面积再作差）R为设计弧底半径清基弧底梯形渠道土方回填工程量计算公式=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=渠心梯形面积+弧底面积渠心梯形面积=（渠口宽+R*√2）*(渠高-弦高)/2弧底面积=∏R2/4-R2/2弦高=R-R/√2填高=渠顶高程-地面高程挖深=地面高程-渠底高程（说明在区间2范围内用挖方公式中计算弧底面积再作差）R为设计弧底半径弧底梯形渠道土方开挖工程量计算公式=IF{地面高程渠顶高程,S1+L2*(地面高程-渠顶高程)+(地