excel豎曲線高程計(jì)算表

1、豎曲線高程計(jì)算第一豎曲線第二豎曲線第三豎曲線變坡點(diǎn)樁號(hào)K0+177.414變坡點(diǎn)樁號(hào)K0+370.000變坡點(diǎn)樁號(hào)K0+546.538變坡點(diǎn)高程6.610變坡點(diǎn)高程4.800變坡點(diǎn)高程5.506坡度(ii)0.4396坡度G1)-0.9398坡度(A)0.3999坡度(匚2)-0.9398坡度)0.3999坡度02)3.0303曲線半徑(R)5800曲線半徑(R)6500曲線半徑(R)3200豎曲線起點(diǎn)樁K0+137.411豎曲線起點(diǎn)樁K0+326.458豎曲線起點(diǎn)樁K0+504.452號(hào)曲線終點(diǎn)樁號(hào)K0+217.417號(hào)曲線終點(diǎn)樁號(hào)K0+413.542號(hào)曲線終點(diǎn)樁號(hào)K0+588.624外距(

2、E)0.1380外距(E)0.1458外距(E)0.2768切線長(T)40.003切線長(T)43.542切線長(T)42.086樁號(hào)高程(m)樁號(hào)高程(m)樁號(hào)高程(m)K0+0105.874K0+2805.646K0+4205.000K0+0205.918K0+2905.552K0+4305.040K0+0305.962K0+3005.458K0+4405.080K0+0406.006K0+3105.364K0+4505.120K0+0506.050K0+3205.270K0+4605.160K0+0606.094K0+3305.177K0+4705.200K0+0706.138K0+3

3、405.096K0+4805.240K0+0806.182K0+3505.031K0+4905.280K0+0906.226K0+3604.981K0+5005.320K0+1006.270K0+3704.946K0+5105.365K0+1106.314K0+3804.753K0+5205.438K0+1206.358K0+3904.837K0+5305.542K0+1306.402K0+4004.906K0+5405.677K0+1406.445K0+4104.959K0+5505.378K0+1506.476K0+4205.000K0+5605.786K0+1606.489K0+4305

4、.040K0+5706.163K0+1706.486K0+4405.080K0+5806.508K0+1806.465K0+4505.120K0+5906.823K0+1906.427K0+6007.126K0+2006.372K0+6107.429K0+2106.299K0+6207.732K0+2206.210K0+6308.035K0+2306.116K0+6408.338K0+2406.022K0+6508.641K0+2505.928K0+6608.944K0+2605.834K0+6709.247K0+2705.740K0+6809.550K0+2805.646K0+6909.853K0+2905.552K0+70010.156K0+3005.458K0+71010.459K0+3105.364K0+72010.762K0+3205.270K0+73011.065K0+3305.176K0+74011.368K0+75011.672K0+75111.710豎曲線計(jì)算原則是:先按道路坡度計(jì)算某樁號(hào)的高程,再根據(jù)曲線參數(shù)計(jì)算該樁號(hào)的改正值,一個(gè)豎曲線要分四段計(jì)算:前坡段的直線段和曲線段,后坡段的曲線段和直線段。直線計(jì)算=變坡點(diǎn)高程加某樁號(hào)到變坡點(diǎn)的