道路桩号算中边桩坐标高程计算程序

路线坐标计算软件作者：王中伟ROADCOORDINATECALCULATINGSOFTWARE单位：湖南交通职业技术学院地址：长沙市韶山南路635号Copyright©2001电话：[phone]版权所有AllRightsReservedE-Mail:[e-mail]1．本计算软件基于EXCEL开发，使用VBA编程，为保证顺利使用，请将宏安全性设为“中”；2．本软件适用于基本型曲线的道路的计算，但不适用于卵形曲线、立交匝道的计算；3．作者开发有适用于卵形曲线、立交匝道计算的计算软件，需要者请与作者联系；4．本软件供工程一线技术人员免费使用，但版权和改编权属于作者；5．本软件使用简单，使用者有任何问题，可与作者联系，作者尽可能提供帮助；6．用户若有支助意向，请与作者联系。序号交点号X（N）坐标Y（E）坐标半径Ls1Ls2桩号1QD78536.21842779.46802JD178647.13842460.7502000003JD278837.96641645.8481400202.46202.464JD379190.12541151.1002200005JD479685.59340010.9472500006JD581506.54738272.9941500201.67201.677JD681586.90035939.7652500008JD783246.28034436.7982500009JD885350.64630008.208100000010ZD86390.99727916.304N（X）E（Y）左偏右偏RLs1Ls2T1T2LEZHHYQZYHHZ直线长度交点间距计算方位角桩号线元长度起始半径结束半径12345678910111213141516171819202124252627QD78536.21842779.468K0+000.000K0+000.000JD178647.13842460.750K0+337.4686°00′33.3″200000104.977104.977209.7622.753K0+232.490K0+232.490K0+337.371K0+442.252K0+442.252232.490337.468289°11′20.0″K0+232.490232.49000JD278837.96641645.848K1+174.22222°15′48.3″1400202.46202.455376.924376.924746.45328.088K0+797.299K0+999.754K1+170.525K1+341.297K1+543.752355.046836.947283°10′46.7″K0+442.252209.762-2000-2000JD379190.12541151.100K1+774.11011°57′18.3″220000230.358230.358459.04212.027K1+543.752K1+543.752K1+773.274K2+002.795K2+002.7950.001607.282305°26′35.0″K0+797.299355.04600JD479685.59340010.947K3+015.59422°50′53.0″250000505.179505.179996.93450.531K2+510.414K2+510.414K3+008.881K3+507.348K3+507.348507.6191243.156293°29′16.7″K0+999.754202.45501400JD581506.54738272.994K5+519.38144°21′49.0″1500201.67201.667712.862712.8621363.104121.107K4+806.519K5+008.186K5+488.070K5+967.955K6+169.6221299.1702517.212316°20′09.6″K1+341.297341.54314001400JD681586.90035939.765K7+791.37345°51′33.1″2500001057.5641057.5642000.985214.487K6+733.809K6+733.809K7+734.301K8+734.794K8+734.794564.1872334.612271°58′20.7″K1+543.752202.45514000JD783246.28034436.798K9+916.08122°24′56.1″250000495.367495.367978.06548.605K9+420.714K9+420.714K9+909.746K10+398.779K10+398.779685.9202238.851317°49′53.8″K1+543.7520.00100JD885350.64630008.208K14+806.5501°01′34.3″100000089.55489.554179.1030.401K14+716.997K14+716.997K14+806.548K14+896.099K14+896.0994318.2184903.138295°24′57.6″K2+002.795459.042-2200-2200ZD86390.99727916.304K17+142.8662246.7672336.320296°26′31.9″K2+510.414507.61900K3+507.348996.93425002500K4+806.5191299.17000K5+008.186201.6670-1500K5+967.955959.770-1500-1500K6+169.622201.667-15000K6+733.809564.18700K8+734.7942000.98525002500K9+420.714685.92000K10+398.779978.065-2500-2500K14+716.9974318.21800K14+896.099179.1031000010000K17+142.8662246.76700曲线要素值(m)线元要素表直线、曲线及转角一览表交点号偏角值交点桩号交点坐标曲线主点桩号直线长度及方向N（X）E（Y）左偏右偏RLs1Ls2T1T2LEZHHYQZYHHZ直线长度交点间距计算方位角桩号线元长度起始半径结束半径12345678910111213141516171819202124252627曲线要素值(m)线元要素表直线、曲线及转角一览表交点号偏角值交点桩号交点坐标曲线主点桩号直线长度及方向N（X）E（Y）左偏右偏RLs1Ls2T1T2LEZHHYQZYHHZ直线长度交点间距计算方位角桩号线元长度起始半径结束半径12345678910111213141516171819202124252627曲线要素值(m)线元要素表直线、曲线及转角一览表交点号偏角值交点桩号交点坐标曲线主点桩号直线长度及方向N（X）E（Y）左偏右偏RLs1Ls2T1T2LEZHHYQZYHHZ直线长度交点间距计算方位角桩号线元长度起始半径结束半径12345678910111213141516171819202124252627曲线要素值(m)线元要素表直线、曲线及转角一览表交点号偏角值交点桩号交点坐标曲线主点桩号直线长度及方向N（X）E（Y）左偏右偏RLs1Ls2T1T2LEZHHYQZYHHZ直线长度交点间距计算方位角桩号线元长度起始半径结束半径12345678910111213141516171819202124252627曲线要素值(m)线元要素表直线、曲线及转角一览表交点号偏角值交点桩号交点坐标曲线主点桩号直线长度及方向N（X）E（Y）左偏右偏RLs1Ls2T1T2LEZHHYQZYHHZ直线长度交点间距计算方位角桩号线元长度起始半径结束半径12345678910111213141516171819202124252627曲线要素值(m)线元要素表直线、曲线及转角一览表交点号偏角值交点桩号交点坐标曲线主点桩号直线长度及方向N（X）E（Y）左偏右偏RLs1Ls2T1T2LEZHHYQZYHHZ直线长度交点间距计算方位角桩号线元长度起始半径结束半径12345678910111213141516171819202124252627曲线要素值(m)线元要素表直线、曲线及转角一览表交点号偏角值交点桩号交点坐标曲线主点桩号直线长度及方向N（X）E（Y）左偏右偏RLs1Ls2T1T2LEZHHYQZYHHZ直线长度交点间距计算方位角桩号线元长度起始半径结束半径12345678910111213141516171819202124252627曲线要素值(m)线元要素表直线、曲线及转角一览表交点号偏角值交点桩号交点坐标曲线主点桩号直线长度及方向N（X）E（Y）左偏右偏RLs1Ls2T1T2LEZHHYQZYHHZ直线长度交点间距计算方位角桩号线元长度起始半径结束半径12345678910111213141516171819202124252627曲线要素值(m)线元要素表直线、曲线及转角一览表交点号偏角值交点桩号交点坐标曲线主点桩号直线长度及方向N（X）E（Y）左偏右偏RLs1Ls2T1T2LEZHHYQZYHHZ直线长度交点间距计算方位角桩号线元长度起始半径结束半径12345678910111213141516171819202124252627曲线要素值(m)线元要素表直线、曲线及转角一览表交点号偏角值交点桩号交点坐标曲线主点桩号直线长度及方向N（X）E（Y）左偏右偏RLs1Ls2T1T2LEZHHYQZYHHZ直线长度交点间距计算方位角桩号线元长度起始半径结束半径12345678910111213141516171819202124252627曲线要素值(m)线元要素表直线、曲线及转角一览表交点号偏角值交点桩号交点坐标曲线主点桩号直线长度及方向N（X）E（Y）左偏右偏RLs1Ls2T1T2LEZHHYQZYHHZ直线长度交点间距计算方位角桩号线元长度起始半径结束半径12345678910111213141516171819202124252627曲线要素值(m)线元要素表直线、曲线及转角一览表交点号偏角值交点桩号交点坐标曲线主点桩号直线长度及方向N（X）E（Y）左偏右偏RLs1Ls2T1T2LEZHHYQZYHHZ直线长度交点间距计算方位角桩号线元长度起始半径结束半径12345678910111213141516171819202124252627曲线要素值(m)线元要素表直线、曲线及转角一览表交点号偏角值交点桩号交点坐标曲线主点桩号直线长度及方向N（X）E（Y）左偏右偏RLs1Ls2T1T2LEZHHYQZYHHZ直线长度交点间距计算方位角桩号线元长度起始半径结束半径12345678910111213141516171819202124252627曲线要素值(m)线元要素表直线、曲线及转角一览表交点号偏角值交点桩号交点坐标曲线主点桩号直线长度及方向N（X）E（Y）左偏右偏RLs1Ls2T1T2LEZHHYQZYHHZ直线长度交点间距计算方位角桩号线元长度起始半径结束半径12345678910111213141516171819202124252627曲线要素值(m)线元要素表直线、曲线及转角一览表交点号偏角值交点桩号交点坐标曲线主点桩号直线长度及方向N（X）E（Y）左偏右偏RLs1Ls2T1T2LEZHHYQZYHHZ直线长度交点间距计算方位角桩号线元长度起始半径结束半径12345678910111213141516171819202124252627曲线要素值(m)线元要素表直线、曲线及转角一览表交点号偏角值交点桩号交点坐标曲线主点桩号直线长度及方向N（X）E（Y）左偏右偏RLs1Ls2T1T2LEZHHYQZYHHZ直线长度