道路工程計算表格任意點標高計算.xls

《道路工程計算表格任意點標高計算.xls》由會員上傳分享，免費在線閱讀，更多相關(guān)內(nèi)容在行業(yè)資料-天天文庫。

變坡點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,"樁號太小了！")))))