线路坐标计算程序.xls
( 4.5 )《线路坐标计算程序.xls》由会员分享，可在线阅读，更多相关《线路坐标计算程序.xls（314页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。
1、注:红块内的数据为需要输入的数,D、E、F栏内的数据为需要输入的数，其余均为自动计算值.在计算新的里程或加桩里程坐标时,一定要先将最右边的K、L两栏往下拖，再将X、Y值往下拖，计算才正确。交点桩号 K91+799.229 交点坐标X 2923839.8370交点坐标Y 530137.324曲线半径R 3000曲线偏角 22.94166667225630.0偏向-1注：左偏为-1，右偏为+1缓和曲线长度L 360330330第一计算方位角A1 269.54638892693247.0切线长度T 788.373774.795#DIV/0!曲线长度l 1546.223直缓点桩号ZH K91+010.
2、856 缓圆点桩号HY K91+370.856 曲中桩号QZ K91+783.968 圆缓点桩号YH K92+227.079 缓直点桩号HZ K92+557.079 第二计算方位角A2 246.6047222中桩坐标左边桩距桩号右边桩距左边桩坐标右边桩坐标XYXYXY第一计算边直线段 2923392.366473618.32429.000K148+320.000 33.0002923363.367473618.5542923425.365473618.063K11+543.175 2922759.916393734.96820.000K228+205.860 33.0002922739.917
3、393735.1262922792.915393734.7072922759.916393734.9688.000K228+205.860 33.0002922751.916393735.0312922792.915393734.7072922759.781393717.96820.000K228+222.860 33.0002922739.782393718.1272922792.780393717.7072922759.441393674.9318.000K228+265.899 33.0002922751.441393674.9942922792.440393674.670第一计算边缓和
4、段 2923846.078530925.67220.900K91+010.856 33.0002923825.179530925.8382923879.077530925.411K91+010.856#8.000K228+269.140 33.000#2923846.006530916.52920.000K91+020.000 33.0002923826.007530916.6882923879.005530916.266#20.000K228+286.140 33.000#24.000K228+286.140 33.000#K228+295.000 28.000#24.000K228+330
5、.000 27.000#15.000K228+340.000 20.000#15.000K228+420.000#23.000K228+440.000#K228+450.000 18.000#15.000K228+460.000#K228+485.000 23.000#K228+600.000 19.000#K148+560.001 22.000#圆曲线 2923836.031530565.87020.000K91+370.856 2923816.077530567.2272923836.031530565.870K91+370.856 2922260.659533413.3432.850K1
6、44+480.000 2.8502922259.313533410.8312922262.006533415.8542922261.546533412.86722.000K144+481.006 2922251.143533393.4822922261.546533412.8672922278.254533403.83325.000K144+500.000 10.1502922266.293533381.8802922283.110533412.7462922260.924533413.20120.000K144+480.300 10.1502922251.471533395.57629222
7、65.721533422.1462919895.818527922.89724.000K228+790.000 23.0002919903.395527945.6702919888.556527901.0732922312.988533384.60929.000K144+539.700 10.1502922298.778533359.3292922317.962533393.4572919717.555527988.54929.000K228+980.000 2919728.433528015.4312919717.555527988.5492919659.408528012.794K229+
8、043.000 25.0002919659.408528012.7942919649.545527989.8212919643.806528019.54523.000K229+060.000 22.0002919652.999528040.6272919635.012527999.3792919625.500528027.600K229+080.000 22.0002919625.500528027.6002919616.572528007.4932919607.248528035.777K229+100.000 26.0002919607.248528035.7772919596.53852
9、8012.0852919600.873528038.66827.000K229+107.000 2919612.051528063.2452919600.873528038.6682919589.051528044.07614.000K229+120.000 19.0002919594.902528056.7942919581.110528026.8152919579.973528048.27119.000K229+130.000 2919587.972528065.5052919579.973528048.2712919570.910528052.496K229+140.000 26.000
10、2919570.910528052.4962919559.885528028.9492919552.825528061.03623.000K229+160.000 2919562.716528081.8012919552.825528061.0362919528.241528072.884K229+187.290 29.0002919528.241528072.8842919515.532528046.8172919445.549528114.79424.000K229+280.000 28.0002919456.728528136.0312919432.506528090.017291931
11、0.316528190.50323.000K229+435.000 28.0002919322.067528210.2752919296.012528166.4332919191.485528264.93420.000K229+575.230 25.0002919202.495528281.6312919177.723528244.0632919191.485528264.93423.000K229+575.230 27.0002919204.146528284.1362919176.622528242.3932919177.319528274.33320.000K229+592.230 25
12、.0002919188.424528290.9672919163.439528253.5402919177.319528274.3338.000K229+592.230 13.0002919181.761528280.9862919170.102528263.5202919139.637528299.9038.000K229+637.770 13.0002919144.179528306.4892919132.256528289.2022919139.637528299.90320.000K229+637.770 25.0002919150.992528316.3672919125.44252
- 配套讲稿：
如PPT文件的首页显示word图标，表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制：
部分文档作品中含有的国旗、国徽等图片，仅作为作品整体效果示例展示，禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词：
- 线路 坐标 计算 程序
淘文阁 - 分享文档赚钱的网站所有资源均是用户自行上传分享，仅供网友学习交流，未经上传用户书面授权，请勿作他用。
限制150内