道路工程計(jì)算表格任意點(diǎn)標(biāo)高計(jì)算.xls

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

變坡點(diǎn)1變坡點(diǎn)2變坡點(diǎn)3樁號(hào)1高程1樁號(hào)2高程2樁號(hào)3高程373900100.77176000101.69976600102.227縱坡度1縱坡度2切線長(zhǎng)豎曲線起點(diǎn)豎曲線終點(diǎn)0.0004419050.000884.38095238175995.6190576004.38095樁號(hào)設(shè)計(jì)高程74000100.81574100100.859IF(A7>$E$3,"樁號(hào)太大了！",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,"樁號(hào)太小76500102.139了！")))))550樁號(hào)太小了！560樁號(hào)太小了！600樁號(hào)太小了！635樁號(hào)太小了！686樁號(hào)太小了！1100樁號(hào)太小了！ 豎曲線半徑20000IF(A7>$E$3,"樁號(hào)太大了！",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,"樁號(hào)太小了！")))))