《线路坐标计算程序.xls》由会员分享，可在线阅读，更多相关《线路坐标计算程序.xls（314页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
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
13、8279.3242919125.670528309.59520.000K229+654.770 25.0002919137.118528325.9942919111.359528289.0962919125.670528309.59523.000K229+654.770 28.0002919138.836528328.4542919109.642528286.6362919105.043528324.12422.000K229+680.000 27.0002919117.788528342.0572919089.402528302.1162919090.403528334.59614.000K
14、229+698.000 31.0002919098.581528345.9582919072.293528309.4352919072.594528347.51313.000K229+720.000 18.0002919080.266528358.0082919061.972528332.9812919008.646528395.57814.000K229+800.000 2919017.206528406.6562919008.646528395.578XYXYXY2918992.861528407.859K229+820.000 21.0002918992.861528407.859291
15、8979.910528391.3282918961.538528432.736K229+860.000 20.0002918961.538528432.7362918948.995528417.1582918946.002528445.33116.000K229+880.000 2918956.119528457.7262918946.002528445.3312918930.550528458.02922.000K229+900.000 26.0002918944.574528474.9792918913.976528437.9962918896.856528486.325K229+944.
16、000 25.0002918896.856528486.3252918880.638528467.2992918892.293528490.22123.000K229+950.000 2918907.248528507.6962918892.293528490.2212922391.761533338.74022.000K144+630.857 22.0002922380.403533319.8992922403.119533357.582第二计算边缓和段 2923657.630529731.407K92+227.079 2923657.630529731.4072923657.6305297
17、31.407K92+227.079 2923565.040529502.40412.400K92+474.120 2923553.642529507.2882923565.040529502.4042923565.040529502.4049.600K92+474.120 19.0002923556.216529506.1852923582.504529494.9212923566.064529504.79412.400K92+471.520 22.0002923554.665529509.6762923586.287529496.1332923565.040529502.40418.000K
18、92+474.120 22.0002923548.495529509.4942923585.262529493.739#20.000K230+157.380 25.000#20.000K230+174.380 25.000#8.000K230+174.380 13.000#8.000K230+214.000 13.000#8.000K149+340.000 13.000#第二计算边直线段 2923532.188529426.227K92+557.079 2923532.188529426.2272923532.188529426.227K92+557.079 2900961.441477256
19、.5138.000K149+400.000 13.0002900954.099477259.6902900973.372477251.3512902808.426481525.6098.000K144+748.492 13.0002902801.084481528.7852902820.357481520.4472902799.591481505.1878.000K144+770.743 13.0002902792.248481508.3632902811.522481500.0252868673.908402627.5528.000K230+714.000 13.0002868666.566
20、402630.7292868685.839402622.3902960284.035614373.9442960284.035614373.9442960284.035614373.944XYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXY
21、XYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXY
22、XYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXY
23、XYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXYXY对应弦和切线方位角 0.0000.000#9.1449.144#注:红块内的数据为需要输入的数,D、E、F栏内的数据为需要输入的数，其余均为自动计算值.在计算新的里程或加桩里程坐标时,一定要先将最右边的K、L两栏往下拖，再将X、Y值往下拖，计算才正确。#57549.145#0.000359.94253109.144 359.94253110.150
24、359.94253129.144 359.94253109.444 359.942#359.94253168.844 359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.942#359.94253260.001 359.942330.000329.95682.95982.95982.95982.95985.55985.55982.95982.959#0.0000.000