道路中边桩坐标计算程序表格文件下载.xls
- 文档编号:807567
- 上传时间:2023-04-29
- 格式:XLS
- 页数:182
- 大小:486.50KB
道路中边桩坐标计算程序表格文件下载.xls
《道路中边桩坐标计算程序表格文件下载.xls》由会员分享,可在线阅读,更多相关《道路中边桩坐标计算程序表格文件下载.xls(182页珍藏版)》请在冰点文库上搜索。
路路线线坐坐标标计计算算软软件件作者:
@#@王中伟ROADCOORDINATECALCULATINGSOFTWARE单位:
@#@湖南交通职业技术学院地址:
@#@长沙市韶山南路635号Copyright2001电话:
@#@0731-5686870,13973170180版权所有AllRightsReservedE-Mail:
@#@1本计算软件基于EXCEL开发,使用VBA编程,为保证顺利使用,请将宏安全性设为“中”;@#@2本软件适用于基本型曲线的道路的计算,但不适用于卵形曲线、立交匝道的计算;@#@3作者开发有适用于卵形曲线、立交匝道计算的计算软件,需要者请与作者联系;@#@4本软件供工程一线技术人员免费使用,但版权和改编权属于作者;@#@5本软件使用简单,使用者有任何问题,可与作者联系,作者尽可能提供帮助;@#@6用户若有支助意向,请与作者联系。
@#@序号交点号X(N)坐标Y(E)坐标半径Ls1Ls2桩号1BP3046919.844450373.316485802JD13046843.992450328.69314240403JD23046776.665450088.80890.560704JD33046575.400450254.4067045355JD43046392.698450084.3546035356JD5a3046669.291450081.401603507JD5b3046599.893449915.348600358JD63046472.237450041.9006835359JD73046350.841449963.05663404010JD83046220.006450094.17660404010JD93046152.276449921.60665505011JD103046010.537449926.601150406012JD113045820.446449798.495173.8452505013JD123045676.968449798.476250404014断链点3045607.755449772.611直线、曲线及转角一览表线元要素表交点号交点坐标交点桩号偏角值曲线要素值(m)曲线主点桩号直线长度及方向N(X)E(Y)左偏右偏RLs1Ls2T1T2LEZHHYQZYHHZ直线长度交点间距计算方位角桩号线元长度起始半径结束半径12345678910111213141516171819202124252627BP3046919.844450373.316K48+580.000K48+580.000JD13046843.992450328.693K48+668.004435116.6142404077.33877.338148.68811.579K48+590.666K48+630.666K48+665.010K48+699.354K48+739.35410.66688.0042102804.4K48+590.66610.66600JD23046776.665450088.808K48+911.1701134610.390.56070171.816176.365244.70278.717K48+739.355K48+799.355K48+856.705K48+914.056K48+984.0560.001249.1542541921.0K48+630.66640.0000142JD33046575.400450254.406K49+068.326822335.670453584.26979.851140.66224.310K48+984.057K49+029.057K49+059.388K49+089.719K49+124.7190.000260.6341403310.7K48+699.35468.688142142JD43046392.698450084.354K49+294.4631362631.8603535169.744169.744177.882103.999K49+124.719K49+159.719K49+213.660K49+267.601K49+302.6010.000249.5952225646.3K48+739.35440.0001420JD5a3046669.291450081.401K49+409.4651120410.960350106.86589.986134.85948.153K49+302.600K49+337.600K49+387.530K49+437.460K49+437.4600.000276.6093592318.0K48+739.3550.00100JD5b3046599.893449915.348K49+527.4451120411.06003589.986106.865134.85948.153K49+437.459K49+437.459K49+487.389K49+537.319K49+572.3190.000179.9712471907.1K48+799.35560.0000-90.5JD63046472.237450041.900K49+645.207774513.868353572.88972.889127.28020.310K49+572.318K49+607.318K49+635.958K49+664.598K49+699.5980.000179.7541351456.0K48+914.056114.702-90.5-90.5JD73046350.841449963.056K49+771.462780353.863404071.86371.863125.83719.460K49+699.599K49+739.599K49+762.517K49+785.436K49+825.4360.000144.7532130009.8K48+984.05670.000-90.50JD83046220.006450094.176K49+938.8021133759.9604040113.366113.366158.99751.647K49+825.436K49+865.436K49+904.934K49+944.432K49+984.4320.000185.2301345616.0K49+029.05745.000070JD93046152.276449921.606K50+056.452703523.265505072.02072.020130.08216.592K49+984.432K50+034.432K50+049.473K50+064.514K50+114.5140.000185.3862483415.9K49+089.71960.6627070JD103046010.537449926.601K50+184.321355943.7150406069.80778.073144.2368.476K50+114.514K50+154.514K50+176.632K50+198.750K50+258.7500.000141.8271775852.8K49+124.71935.000700JD113045820.446449798.495K50+409.906335809.0173.8452505078.26478.264153.0688.554K50+331.642K50+381.642K50+408.176K50+434.710K50+484.71072.892229.2292135836.5K49+159.71935.000060JD123045676.968449798.476K50+549.923202900.0250404065.21465.214129.3754.319K50+484.710K50+524.710K50+549.397K50+574.085K50+614.0850.000143.4781800027.5K49+267.601107.8826060断链点3045607.755449772.611K50+622.7608.67573.8882002927.4K49+302.60135.000600K49+337.60035.0000-60K49+437.46099.859-60-60K49+537.31999.859-60-60K49+572.31935.000-600K49+607.31835.000068K49+664.59857.2806868K49+699.59835.000680K49+739.59940.0000-63K49+785.43645.837-63-63K49+825.43640.000-630K49+865.43640.000060K49+944.43278.9976060K49+984.43240.000600K50+034.43250.0000-65K50+064.51430.082-65-65K50+114.51450.000-650K50+154.51440.0000150K50+198.75044.236150150K50+258.75060.0001500K50+331.64272.89200K50+381.64250.0000-173.8452K50+434.71053.068-173.8452-173.8452K50+484.71050.000-173.84520K50+524.71040.0000250K50+574.08549.375250250K50+614.08540.0002500K50+622.7608.67500直线、曲线及转角一览表线元要素表交点号交点坐标交点桩号偏角值曲线要素值(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直线长度交点间距计算方位角桩号线元长度起始半径结束半径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直线长度交点间距计算方位角桩号线元长度起始半径结束半径12345678910111213141516171819202124252627直线、曲线及转角一览表线元要素表交点号交点坐标交点桩号偏角值曲线要素值(m)曲线主点桩号直线长度及方向N(X)E(Y)左偏右偏RLs1Ls2T1T2LEZHHYQZYHHZ直线长度交点间距计算方位角桩号线元长度起始半径结束半径12345678910111213141516171819202124252627直线、曲线及转角一览表线元要素表交点号
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 道路 中边桩 坐标 计算 程序