道路工程计算表格任意点标高计算.xls

《道路工程计算表格任意点标高计算.xls》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

变坡点1变坡点2变坡点3桩号1高程1桩号2高程2桩号3高程373900100.77176000101.69976600102.227纵坡度1纵坡度2切线长竖曲线起点竖曲线终点0.0004419050.000884.38095238175995.6190576004.38095桩号设计高程74000100.81574100100.859IF(A7>$E$3,"桩号太大了！",IF(A7>$F$5,$D$3+(A7-$C$3)*$C$5,IF(A7>$C$3,$D$3+(A7-$C$3)*$C$5+($F$5-75000101.257A7)^2/2/$G$3,IF(A7>$E$5,$B$3+(A7-$A$3)*$B$5+(A7-76000101.699$E$5)^2/2/$G$3,IF(A7>=$A$3,$B$3+(A7-$A$3)*$B$5,"桩号太小76500102.139了！")))))550桩号太小了！560桩号太小了！600桩号太小了！635桩号太小了！686桩号太小了！1100桩号太小了！ 竖曲线半径20000IF(A7>$E$3,"桩号太大了！",IF(A7>$F$5,$D$3+(A7-$C$3)*$C$5,IF(A7>$C$3,$D$3+(A7-$C$3)*$C$5+($F$5-A7)^2/2/$G$3,IF(A7>$E$5,$B$3+(A7-$A$3)*$B$5+(A7-$E$5)^2/2/$G$3,IF(A7>=$A$3,$B$3+(A7-$A$3)*$B$5,"桩号太小了！")))))