excel竖曲线高程计算表

1、竖竖曲曲线线参参数数表表编编号号交交点点桩桩号号交交点点高高程程曲曲线线半半径径第一竖曲线1 1K5+200K5+200215215变坡点桩号K6+300.0002 2K6+300K6+300188.6188.62500025000变坡点高程188.6003 3K7+775K7+775178.55178.551900019000坡度(i1)-2.40004 4K8+480.000K8+480.000165.155165.15512258.06512258.065坡度(i2)-0.68145 5K8+900.000K8+900.000170.195170.1952000020000曲线半径(R)

2、250006 6K9+380.000K9+380.000164.915164.9151900019000竖曲线起点桩号K6+085.169竖曲线终点桩号K6+514.831外距 (E)0.9230切线长(T)214.831第二竖曲线第三竖曲线第三竖曲线变坡点桩号K7+775.000变坡点桩号K8+480.000变坡点桩号K8+900.000变坡点高程178.550变坡点高程165.155变坡点高程165.155坡度(i1)-0.6814坡度(i1)-1.9000坡度(i1)1.2000坡度(i2)-1.9000坡度(i2)1.2000坡度(i2)-1.1000曲线半径(R)19000曲线半径(

3、R)12258.065曲线半径(R)20000竖曲线起点桩号K7+659.229竖曲线起点桩号K8+290.000竖曲线起点桩号K8+670.000竖曲线终点桩号K7+890.771竖曲线终点桩号K8+670.000竖曲线终点桩号K9+130.000外距 (E)0.3527外距 (E)1.4725外距 (E)1.3225切线长(T)115.771切线长(T)190.000切线长(T)230.000竖 曲 线 高 程 计 算第一竖曲线第二竖曲线第三竖曲线变坡点桩号K6+300.000变坡点桩号K7+775.000变坡点桩号K8+480.000变坡点高程188.600变坡点高程178.550变坡点

4、高程165.155坡度(i1)-2.4000坡度(i1)-0.6814坡度(i1)-1.9000坡度(i2)-0.6814坡度(i2)-1.9000坡度(i2)1.2000曲线半径(R)25000曲线半径(R)19000曲线半径(R)12258竖曲线起点桩号 K6+085.169竖曲线起点桩号 K7+659.229竖曲线起点桩号 K8+290.000竖曲线终点桩号 K6+514.831竖曲线终点桩号 K7+890.771竖曲线终点桩号 K8+670.000外距 (E)0.9230外距 (E)0.3527外距 (E)1.4725切线长(T)214.831切线长(T)115.771切线长(T)19

5、0.000桩桩 号号高高 程程(m)(m)桩桩 号号高高 程程(m)(m)桩桩 号号高高 程程(m)(m)K6+200K6+200191.264191.264K6+660186.147186.147K8+300K8+300168.579168.579K6+220K6+220190.884190.884K6+680186.011186.011K8+320K8+320168.232168.232K6+240K6+240190.519190.519K6+700185.875185.875K8+340K8+340167.917167.917K6+260K6+260190.171190.171K6+72

6、0185.738185.738K8+360K8+360167.635167.635K6+280K6+280189.839189.839K6+740185.602185.602K8+380K8+380167.385167.385K6+300K6+300189.523189.523K6+760185.466185.466K8+400K8+400167.169167.169K6+320K6+320189.223189.223K6+780185.329185.329K8+420K8+420166.984166.984K6+340K6+340188.939188.939K6+800185.193185.

7、193K8+440K8+440166.833166.833K6+360K6+360188.671188.671K6+820185.057185.057K8+460K8+460166.714166.714K6+380K6+380188.419188.419K6+840184.921184.921K8+480K8+480166.627166.627K6+400K6+400188.182188.182K6+860184.784184.784K8+500K8+500164.216164.216K6+420K6+420187.962187.962K6+880184.648184.648K6+440K6+

8、440187.758187.758K6+900184.512184.512K6+460K6+460187.570187.570K6+920184.376184.376K6+480K6+480187.398187.398K6+940184.239184.239K6+500K6+500187.242187.242K6+960184.103184.103K6+520187.101187.101K6+980183.967183.967K6+540186.965186.965K7+000183.831183.831K6+560186.828186.828K7+020183.694183.694K6+58

9、0186.692186.692K7+040183.558183.558K6+600186.556186.556K7+060183.422183.422K6+620186.420186.420K7+080183.285183.285K6+640186.283186.283K7+100183.149183.149K7+120183.013183.013K7+140182.877182.877K7+160182.740182.740K7+180182.604182.604K7+200182.468182.468K7+220182.332182.332K7+240182.195182.195K7+26

10、0182.059182.059K7+280181.923181.923K7+300181.786181.786K7+320181.650181.650K7+340181.514181.514K7+360181.378181.378K7+380181.241181.241K7+400181.105181.105K7+420180.969180.969K7+440180.833180.833K7+460180.696180.696K7+480180.560180.560K7+500180.424180.424K7+520180.287180.287K7+540180.151180.151K7+56

11、0180.015180.015K7+580179.879179.879K7+600179.742179.742K7+620179.606179.606K7+640179.470179.470K7+660K7+660179.334179.334K7+680K7+680179.209179.209K7+700K7+700179.105179.105K7+720K7+720179.022179.022K7+740K7+740178.960178.960K7+760K7+760178.919178.919K7+780K7+780178.132178.132K7+800K7+800177.858177.

12、858K7+820K7+820177.563177.563K7+840K7+840177.247177.247K7+860K7+860176.910176.910K7+880K7+880176.552176.552K7+900176.175176.175K7+920175.795175.795K7+940175.415175.415K7+960175.035175.035K7+980174.655174.655K8+000174.275174.275K8+020173.895173.895K8+040173.515173.515K8+060173.135173.135K8+080172.755

13、172.755K8+100172.375172.375K8+120171.995171.995K8+140171.615171.615K8+160171.235171.235K8+180170.855170.855K8+200170.475170.475K8+220170.095170.095K8+240169.715169.715K8+260169.335169.335K8+280168.955168.955竖竖曲曲线线计计算算原原则则是是: :先先按按道道路路坡坡度度计计算算某某桩桩号号的的高高程程, ,再再根根据据曲曲线线参参数数计计算算该该桩桩号号的的改改正正值值, ,一一个个竖竖曲曲

14、线线要要分分四四段段计计算算: :前前坡坡段段的的直直线线段段和和曲曲线线段段, ,后后坡坡段段的的曲曲线线段段和和直直线线段段。直直线线计计算算= =变变坡坡点点高高程程加加某某桩桩号号到到变变坡坡点点的的距距离离* *坡坡度度, ,曲曲线线部部分分= =变变坡坡点点高高程程加加某某桩桩号号到到变变坡坡点点的的距距离离* *坡坡度度，再再加加曲曲线线改改正正值值(Y),(Y),其其中中Y=XY=X2/(2R),X/(2R),X是是曲曲线线起起点点到到某某桩桩号号的的距距离离,R,R是是曲曲线线半半径径。全线设计高程表桩号路面中桩设计高程路基设计高程左中右偏距高程偏距高程K6+200191.2

15、64K6+220190.884K6+240190.519K6+260190.171K6+280189.839K6+300189.523K6+320189.223K6+340188.939K6+360188.671K6+380188.419K6+400188.182K6+420187.962K6+440187.758K6+460187.570K6+480187.398K6+500187.242K6+520187.101K6+540186.965K6+560186.828K6+580186.692K6+600186.556K6+620186.420K6+640186.283K6+660186.14

16、7K6+680186.011K6+700185.875K6+720185.738K6+740185.602K6+760185.466K6+780185.329K6+800185.193K6+820185.057K6+840184.921K6+860184.784K6+880184.648K6+900184.512K6+920184.376K6+940184.239K6+960184.103K6+980183.967K7+000183.831K7+020183.694K7+040183.558K7+060183.422K7+080183.285K7+100183.149K7+120183.013

17、K7+140182.877K7+160182.740K7+180182.604K7+200182.468K7+220182.332K7+240182.195K7+260182.059K7+280181.923K7+300181.786K7+320181.650K7+340181.514K7+360181.378K7+380181.241K7+400181.105K7+420180.969K7+440180.833K7+460180.696K7+480180.560K7+500180.424K7+520180.287K7+540180.151K7+560180.015K7+580179.879K

18、7+600179.742K7+620179.606K7+640179.470K7+660179.334K7+680179.209K7+700179.105K7+720179.022K7+740178.960K7+760178.919K7+780178.132K7+800177.858K7+820177.563K7+840177.247K7+860176.910K7+880176.552K7+900176.175K7+920175.795K7+940175.415K7+960175.035K7+980174.655K8+000174.275K8+020173.895K8+040173.515K8+060173.135K8