电子表格竖曲线高程计算表

竖曲线高程计算,,,,,,,,

第一竖曲线,,第二竖曲线,,第三竖曲线,,,,

变坡点桩号,K0+180.000,变坡点桩号,K0+340.000,变坡点桩号,K0+474.862,,,

变坡点高程,202.630,变坡点高程,206.360,变坡点高程,210.920,,,"竖曲线计算原则是:先按道路坡度计算某桩号的高程,再根据曲线参数计算该桩号的改正值,一个竖曲线要分四段计算:前坡段的直线段和曲线段,后坡段的曲线段和直线段。直线计算=变坡点高程加某桩号到变坡点的距离*坡度,曲线部分=变坡点高程加某桩号到变坡点的距离*坡度，再加曲线改正值(Y),其中Y=X2/(2R),X是曲线起点到某桩号的距离,R是曲线半径。"

坡度(i1),0.6490,坡度(i1),2.3313,坡度(i1),3.3812,,,

坡度(i2),2.3313,坡度(i2),3.3812,坡度(i2),2.1636,,,

曲线半径(R),3000,曲线半径(R),3000,曲线半径(R),3500,,,

竖曲线起点桩号,K0+154.766,竖曲线起点桩号,K0+324.250,竖曲线起点桩号,K0+453.553,,,

竖曲线终点桩号,K0+205.234,竖曲线终点桩号,K0+355.750,竖曲线终点桩号,K0+496.171,,,

外距(E),0.1061,外距(E),0.0413,外距(E),0.0649,,,

切线长(T),25.234,切线长(T),15.750,切线长(T),21.309,,,

桩号,高程(m),桩号,高程(m),桩号,高程(m),,,

K0+010,201.527,K0+280,204.961,K0+420,209.065,,,

K0+020,201.592,K0+290,205.194,K0+430,209.403,,,

K0+030,201.657,K0+300,205.428,K0+440,209.741,,,

K0+040,201.721,K0+310,205.661,K0+450,210.079,,,

K0+050,201.786,K0+320,205.894,K0+460,210.423,,,

K0+060,201.851,K0+330,206.132,K0+470,210.794,,,

K0+070,201.916,K0+340,206.401,K0+480,210.994,,,

K0+080,201.981,K0+350,206.693,K0+490,211.242,,,

K0+090,202.046,K0+360,207.036,K0+500,211.464,,,

K0+100,202.111,K0+370,207.374,K0+510,211.680,,,

K0+110,202.176,K0+380,207.712,K0+520,211.897,,,

K0+120,202.241,K0+390,208.051,K0+530,212.113,,,

K0+130,202.306,K0+400,208.389,K0+540,212.329,,,

K0+140,202.370,K0+410,208.727,K0+550,212.546,,,

K0+150,202.435,K0+420,209.065,K0+560,212.762,,,

K0+160,202.505,K0+430,209.403,K0+570,212.978,,,

K0+170,202.604,K0+440,209.741,K0+580,213.195,,,

K0+180,202.736,K0+450,210.079,K0+590,213.411,,,

K0+190,202.824,,,K0+600,213.627,,,

K0+200,203.092,,,K0+610,213.844,,,

K0+210,203.329,,,K0+620,214.060,,,

K0+220,203.563,,,K0+630,214.277,,,

K0+230,203.796,,,K0+640,214.493,,,

K0+240,204.029,,,K0+650,214.709,,,

K0+250,204.262,,,K0+660,214.926,,,

K0+260,204.495,,,K0+670,215.142,,,

K0+270,204.728,,,K0+680,215.358,,,

K0+280,204.961,,,K0+690,215.575,,,

K0+290,205.194,,,K0+700,215.791,,,

K0+300,205.428,,,K0+710,216.007,,,

K0+310,205.661,,,K0+720,216.224,,,

K0+320,205.894,,,K0+730,216.440,,,

K0+330,206.127,,,K0+740,216.657,,,

,,,,K0+750,216.873,,,

,,,,K0+751,216.900,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,,,,,,,,

,