《EXCEL全线路基坐标计算程序.xls》由会员分享，可在线阅读，更多相关《EXCEL全线路基坐标计算程序.xls（21页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、路路 线线 坐坐 标标 计计 算算 公公 式式桩号左线曲线要素曲线类型曲线起点桩号X坐标Y坐标曲线半径缓和参数K129+500.000HY-YH#8697.990-531.481230.540K129+520.000#8697.990-531.481230.540K129+540.000#8697.990-531.481230.540K129+560.000#8697.990-531.481230.540K129+580.000#8697.990-531.481230.540K129+600.000#8697.990-531.481230.540K129+620.000#8697.990-53
2、1.481230.540K129+620.851#8697.990-531.481230.540K129+620.851YH-ZH#8611.955531.481230.540K129+640.000#8611.955531.481230.540K129+660.000#8611.955531.481230.540K129+680.000#8611.955531.481230.540K129+700.000#8611.955531.481230.540K129+720.000#8611.955531.481230.540K129+720.851#8611.955531.481230.540左K
3、129+720.851ZH-HY#8611.9551658.331575.900左K129+740.000#8611.9551658.331575.900左K129+760.000#8611.9551658.331575.900左K129+780.000#8611.9551658.331575.900左K129+800.000#8611.9551658.331575.900左K129+820.000#8611.9551658.331575.900左K129+840.000#8611.9551658.331575.900左K129+860.000#8611.9551658.331575.900左
4、K129+880.000#8611.9551658.331575.900左K129+900.000#8611.9551658.331575.900左K129+920.000#8611.9551658.331575.900左K129+920.852#8611.9551658.331575.900左K129+920.852HY-YH#8441.0051658.331575.900左K129+940.000#8441.0051658.331575.900左K129+960.000#8441.0051658.331575.900左K129+980.000#8441.0051658.331575.900
5、左K130+000.000#8441.0051658.331575.900左K130+025.000#8441.0051658.331575.900左K130+040.000#8441.0051658.331575.900左K130+060.000#8441.0051658.331575.900左K130+080.000#8441.0051658.331575.900左K130+100.000#8441.0051658.331575.900左K130+120.000#8441.0051658.331575.900左K130+134.182#8441.0051658.331575.900左K13
6、0+134.182YH-HZ#8059.458-1658.331575.900左K130+140.000#8059.458-1658.331575.900左K130+160.000#8059.458-1658.331575.900左K130+180.000#8059.458-1658.331575.900左K130+200.000#8059.458-1658.331575.900左K130+220.000#8059.458-1658.331575.900左K130+240.000#8059.458-1658.331575.900左K130+260.000#8059.458-1658.33157
7、5.900左K130+280.000#8059.458-1658.331575.900左K130+300.000#8059.458-1658.331575.900左K130+320.000#8059.458-1658.331575.900左K130+334.182#8059.458-1658.331575.900左K130+334.182HZ-ZH#8059.458左K130+340.000#8059.458左K130+360.000#8059.458左K130+380.000#8059.458左K130+400.000#8059.458左K130+420.000#8059.458左K130+
8、440.000#8059.458左K130+460.000#8059.458左K130+480.000#8059.458左K130+500.000#8059.458左K130+520.000#8059.458左K130+540.000#8059.458左K130+560.000#8059.458左K130+580.000#8059.458左K130+600.000#8059.458左K130+620.000#8059.458左K130+640.000#8059.458左K130+660.000#8059.458左K130+680.000#8059.458左K130+700.000#8059.4
9、58左K130+712.918#8059.458左K130+712.918ZH-HY#7699.513-1500519.620左K130+720.000#7699.513-1500519.620左K130+740.000#7699.513-1500519.620左K130+760.000#7699.513-1500519.620左K130+780.000#7699.513-1500519.620左K130+800.000#7699.513-1500519.620左K130+820.000#7699.513-1500519.620左K130+840.000#7699.513-1500519.62
10、0左K130+860.000#7699.513-1500519.620左K130+880.000#7699.513-1500519.620左K130+892.918#7699.513-1500519.620左K130+892.918HY-YH#7529.625-1500519.620左K130+900.000#7529.625-1500519.620左K130+920.000#7529.625-1500519.620左K130+940.000#7529.625-1500519.620左K130+960.000#7529.625-1500519.620左K130+980.000#7529.625
11、-1500519.620左K131+000.000#7529.625-1500519.620YH-HZ左K131+020.000#7529.625-1500519.620左K131+040.000#7529.625-1500519.620左K131+060.000#7529.625-1500519.620左K131+080.000#7529.625-1500519.620左K131+100.000#7529.625-1500519.620左K131+120.000#7529.625-1500519.620左K131+140.000#7529.625-1500519.620左K131+160.0
12、00#7529.625-1500519.620左K131+180.000#7529.625-1500519.620左K131+200.000#7529.625-1500519.620左K131+220.000#7529.625-1500519.620左K131+240.000#7529.625-1500519.620左K131+260.000#7529.625-1500519.620左K131+280.000#7529.625-1500519.620左K131+300.000#7529.625-1500519.620左K131+320.000#7529.625-1500519.620左K131
13、+340.000#7529.625-1500519.620左K131+360.000#7529.625-1500519.620左K131+380.000#7529.625-1500519.620左K131+400.000#7529.625-1500519.620左K131+420.000#7529.625-1500519.620左K131+440.000#7529.625-1500519.620左K131+447.007#7529.625-1500519.620左K131+447.007YH-HZ左K131+460.000左K131+480.000左K131+500.000左K131+520.
14、000左K131+540.000左K131+560.000左K131+580.000左K131+600.000左K131+620.000左K131+627.007左K131+627.007K131+640.000K131+660.000K131+680.000K131+700.000K131+720.000K131+740.000K131+760.000K131+780.000K131+800.000K131+820.000K131+840.000K131+860.000HY-YHK131+880.000K131+900.000K131+920.000K131+940.000K131+960.
15、000K131+980.000K132+000.000K132+020.000K132+040.000K132+060.000K132+080.000K132+100.000K132+120.000K132+140.000K132+160.000K132+180.000K132+200.000K132+220.000K132+240.000K132+260.000K132+280.000右K129+717.744右K129+720.000右K129+740.000右K129+760.000右K129+780.000右K129+800.000右K129+820.000右K129+840.000右
16、K129+860.000右K129+880.000右K129+900.000右K129+920.000右K129+940.000右K129+960.000右K129+980.000右K130+000.000右K130+020.000右K130+040.000右K130+060.000右K130+080.000右K130+100.000右K130+120.000右K130+140.000右K130+160.000右K130+180.000右K130+200.000右K130+220.000右K130+240.000右K130+260.000右K130+280.000右K130+300.000右K
17、130+320.000右K130+340.000右K130+360.000右K130+380.000右K130+400.000右K130+420.000右K130+440.000右K130+460.000右K130+480.000右K130+500.000右K130+520.000右K130+540.000右K130+560.000右K130+580.000右K130+600.000右K130+620.000右K130+640.000右K130+660.000右K130+680.000右K130+700.000右K130+720.000右K130+740.000右K130+760.000右K1
18、30+780.000右K130+800.000右K130+820.000右K130+840.000右K130+860.000右K130+880.000右K130+900.000右K130+920.000右K130+940.000右K130+960.000右K130+980.000右K131+000.000右K131+020.000右K131+040.000右K131+060.000右K131+080.000右K131+100.000右K131+120.000右K131+140.000右K131+160.000右K131+180.000右K131+200.000右K131+220.000右K13
19、1+240.000右K131+260.000右K131+280.000右K131+300.000右K131+320.000右K131+340.000右K131+360.000右K131+380.000右K131+400.000右K131+420.000右K131+440.000右K131+460.000右K131+480.000右K131+500.000右K131+520.000右K131+537.183左边边坐标中桩曲线长度方位角距离XYX242.9906389 2425926.3012.2548080.511 8811.189 48092.398242.9906389 2425926.30
20、12.2548075.435 8791.913 48087.202242.9906389 2425926.3012.2548069.653 8772.847 48081.284242.9906389 2425926.3012.2548063.172 8754.015 48074.650242.9906389 2425926.3012.2548056.003 8735.447 48067.312242.9906389 2425926.3012.2548048.155 8717.167 48059.278242.9906389 2425926.3012.2548039.639 8699.201 4
21、8050.562242.9906389 2425926.3012.2548039.262 8698.444 48050.176100237.5955556 2373544.0012.2548039.265 8698.443 48050.179100237.5955556 2373544.0012.2548030.469 8681.561 48041.195100237.5955556 2373544.0012.2548020.727 8664.209 48031.292100237.5955556 2373544.0012.2548010.549 8647.081 48020.99410023
22、7.5955556 2373544.0012.2548000.064 8630.107 48010.433100237.5955556 2373544.0012.2547989.396 8613.209 47999.739100237.5955556 2373544.0012.2547988.948612.491 47999.283200237.5955556 2373544.0012.2547988.948612.491 47999.283200237.5955556 2373544.0012.2547978.678 8596.321 47989.024200237.5955556 2373
23、544.0012.2547967.971 8579.420 47978.329200237.5955556 2373544.0012.2547957.296 8562.492 47967.673200237.5955556 2373544.0012.2547946.674 8545.526 47957.078200237.5955556 2373544.0012.2547936.126 8528.508 47946.565200237.5955556 2373544.0012.2547925.672 8511.426 47936.153200237.5955556 2373544.0012.2
24、547915.334 8494.269 47925.863200237.5955556 2373544.0012.2547905.133 8477.025 47915.719200237.5955556 2373544.0012.2547895.092 8459.68447905.74200237.5955556 2373544.0012.2547885.233 8442.234 47895.949200237.5955556 2373544.0012.2547884.817 8441.489 47895.536241.0505833 2410302.1012.2547884.818 8441
25、.489 47895.537241.0505833 2410302.1012.2547875.579 8424.670 47886.366241.0505833 2410302.1012.2547866.138 8406.991 47876.994241.0505833 2410302.1012.2547856.912 8389.201 47867.836241.0505833 2410302.1012.2547847.903 8371.301 47858.893241.0505833 2410302.1012.2547836.949 8348.776 47848.019241.0505833
26、 2410302.1012.2547830.541 8335.184 47841.658241.0505833 2410302.1012.2547822.198316.972 47833.369241.0505833 2410302.1012.2547814.061 8298.661 47825.299241.0505833 2410302.1012.2547806.154 8280.254 47817.451241.0505833 2410302.1012.2547798.472 8261.754 47809.825241.0505833 2410302.1012.2547793.161 8
27、248.581 47804.552200251.8761111 2515234.0012.2547793.161 8248.584 47804.553200251.8761111 2515234.0012.2547791.015 8243.167 47802.422200251.8761111 2515234.0012.2547783.781 8224.492 47795.236200251.8761111 2515234.0012.2547776.749 8205.744 47788.247路路 线线 坐坐 标标 计计 算算 公公 式式200251.8761111 2515234.0012.
28、2547769.897 8186.932 47781.432200251.8761111 2515234.0012.2547763.204 8168.068 47774.769200251.8761111 2515234.0012.2547756.647 8149.159 47768.237200251.8761111 2515234.0012.2547750.202 8130.214 47761.812200251.8761111 2515234.0012.2547743.846 8111.242 47755.471200251.8761111 2515234.0012.2547737.55
29、8 8092.251 47749.193200251.8761111 2515234.0012.2547731.313 8073.247 47742.954200251.8761111 2515234.0012.2547726.899 8059.769 47738.541251.8761111 2515234.0012.2547726.899 8059.769 47738.541251.8761111 2515234.0012.2547725.089 8054.240 47736.731251.8761111 2515234.0012.2547718.867 8035.23247730.512
30、51.8761111 2515234.0012.2547712.646 8016.224 47724.288251.8761111 2515234.0012.2547706.425 7997.217 47718.067251.8761111 2515234.0012.2547700.203 7978.209 47711.845251.8761111 2515234.0012.2547693.982 7959.201 47705.624251.8761111 2515234.0012.2547687.767940.193 47699.402251.8761111 2515234.0012.254
31、7681.539 7921.186 47693.181251.8761111 2515234.0012.2547675.317 7902.17847686.96251.8761111 2515234.0012.2547669.096 7883.170 47680.738251.8761111 2515234.0012.2547662.874 7864.163 47674.517251.8761111 2515234.0012.2547656.653 7845.155 47668.295251.8761111 2515234.0012.2547650.431 7826.147 47662.074
32、251.8761111 2515234.0012.2547644.217807.139 47655.852251.8761111 2515234.0012.2547637.989 7788.132 47649.631251.8761111 2515234.0012.2547631.767 7769.124 47643.409251.8761111 2515234.0012.2547625.546 7750.116 47637.188251.8761111 2515234.0012.2547619.324 7731.108 47630.966251.8761111 2515234.0012.25
33、47613.103 7712.101 47624.745251.8761111 2515234.0012.2547609.084 7699.824 47620.727180251.8761111 2515234.0012.2547609.084 7699.824 47620.726180251.8761111 2515234.0012.2547606.881 7693.094 47618.523180251.8761111 2515234.0012.2547600.653 7674.09147612.29180251.8761111 2515234.0012.2547594.392 7655.
34、102 47606.019180251.8761111 2515234.0012.2547588.072 7636.137 47599.682180251.8761111 2515234.0012.2547581.663 7617.20447593.25180251.8761111 2515234.0012.2547575.138 7598.315 47586.697180251.8761111 2515234.0012.2547568.471 7579.480 47579.994180251.8761111 2515234.0012.2547561.633 7560.711 47573.11
35、4180251.8761111 2515234.0012.2547554.67542.018 47566.029180251.8761111 2515234.0012.2547549.947529.992 47561.333248.4383611 2482618.1012.2547549.947529.993 47561.333248.4383611 2482618.1012.2547547.343 7523.417 47558.715248.4383611 2482618.1012.2547539.844 7504.914 47551.153248.4383611 2482618.1012.
36、2547532.17486.513 47543.346248.4383611 2482618.1012.2547524.114 7468.218 47535.294248.4383611 2482618.1012.2547515.886 7450.032 47526.998248.4383611 2482618.1012.2547507.418 7431.958 47518.460248.4383611 2482618.1012.2547498.711 7413.999 47509.682248.4383611 2482618.1012.2547489.768 7396.159 47500.6
37、66248.4383611 2482618.1012.2547480.597378.441 47491.412248.4383611 2482618.1012.2547471.178 7360.847 47481.922248.4383611 2482618.1012.2547461.534 7343.382 47472.199248.4383611 2482618.1012.2547451.659 7326.048 47462.243248.4383611 2482618.1012.2547441.557 7308.848 47452.057248.4383611 2482618.1012.
38、2547431.227 7291.785 47441.642248.4383611 2482618.1012.2547420.673 7274.862 47431.001248.4383611 2482618.1012.2547409.895 7258.083 47420.135248.4383611 2482618.1012.2547398.897 7241.450 47409.046248.4383611 2482618.1012.2547387.679 7224.966 47397.736248.4383611 2482618.1012.2547376.244 7208.634 4738
39、6.207248.4383611 2482618.1012.2547364.595 7192.458 47374.461248.4383611 2482618.1012.2547352.732 7176.439 47362.501248.4383611 2482618.1012.2547340.658 7160.581 47350.327248.4383611 2482618.1012.2547328.375 7144.887 47337.944248.4383611 2482618.1012.2547315.886 7129.359 47325.352248.4383611 2482618.
40、1012.2547303.193 7114.000 47312.554248.4383611 2482618.1012.2547290.297 7098.814 47299.552248.4383611 2482618.1012.2547277.202 7083.801 47286.349248.4383611 2482618.1012.2547263.909 7068.966 47272.946248.4383611 2482618.1012.2547259.205 7063.811 47268.204圆曲线右边边桩FGYXY角度弧度角度弧度8810.948 48104.2868810.70
41、6 332.9906389 5.811783027 166.0188605 2.8975757368791.636 48098.9708791.358 332.9906389 5.811783027 163.8627804 2.859945048772.533 48092.9148772.219 332.9906389 5.811783027 161.7067004 2.8223143448753.666 48086.1288753.317 332.9906389 5.811783027 159.5506203 2.7846836488735.062 48078.6208734.678 332
42、.9906389 5.811783027 157.3945402 2.7470529528716.748 48070.4028716.329 332.9906389 5.811783027 155.2384602 2.7094222568698.748 48061.4858698.296 332.9906389 5.811783027 153.0823801 2.671791568697.990 48061.0908697.536 332.9906389 5.811783027 152.9906389 2.6701903748697.988 48061.0928697.53408681.079
43、 48051.9228680.596008663.703 48041.8578663.197008646.559 48031.4388646.036008629.574 48020.8028629.042008612.673 48010.0828612.138008611.955008611.955008595.786008578.886008561.961008544.998008527.984008510.908008493.758008476.522008459.189008441.750008441.004008441.005331.0505833 5.777922669 151.05
44、05833 2.6363300168424.196331.0505833 5.777922669 151.7121518 2.6478765658406.528331.0505833 5.777922669 152.4031572 2.6599368838388.748331.0505833 5.777922669 153.0941625 2.6719972028370.859331.0505833 5.777922669 153.7851679 2.684057528348.348331.0505833 5.777922669 154.6489246 2.6991329188334.7643
45、31.0505833 5.777922669 155.1671786 2.7081781578316.563331.0505833 5.777922669 155.8581839 2.7202384758298.263331.0505833 5.777922669 156.5491893 2.7322987948279.867331.0505833 5.777922669 157.2401946 2.7443591128261.379331.0505833 5.777922669 157.93122.7564194318248.213331.0505833 5.777922669 158.42
46、11918 2.7649714038248.216341.8761111 5.966863773 168.7861646 2.9458743048242.802008224.138008205.39900中桩8186.596008167.738008148.835008129.895008110.927008091.938008072.936008059.458008059.4588053.9298034.9218015.9137996.9057977.8987958.8907939.8827920.8757901.8677882.8597863.8517844.8447825.8367806
47、.8287787.8217768.8137749.8057730.7977711.7907699.5137699.5137692.7827673.7787654.7877635.8187616.8807597.9847579.1417560.3627541.6587529.6257529.625338.4383611 5.906863716 158.4383611 2.7652710637523.045338.4383611 5.906863716 158.1678486 2.7605497297504.529338.4383611 5.906863716 157.4039049 2.7472
48、163967486.116338.4383611 5.906863716 156.6399612 2.7338830637467.809338.4383611 5.906863716 155.8760174 2.7205497297449.611338.4383611 5.906863716 155.1120737 2.7072163967431.525338.4383611 5.906863716 154.348132.6938830637413.554338.4383611 5.906863716 153.5841863 2.6805497297395.702338.4383611 5.9
49、06863716 152.8202425 2.6672163967377.972338.4383611 5.906863716 152.0562988 2.6538830637360.367338.4383611 5.906863716 151.2923551 2.6405497297342.890338.4383611 5.906863716 150.5284114 2.6272163967325.544338.4383611 5.906863716 149.7644676 2.6138830637308.333338.4383611 5.906863716 149.0005239 2.60
50、05497297291.258338.4383611 5.906863716 148.2365802 2.5872163967274.324338.4383611 5.906863716 147.4726365 2.5738830637257.534338.4383611 5.906863716 146.7086927 2.5605497297240.890338.4383611 5.906863716 145.9447492.5472163967224.395338.4383611 5.906863716 145.1808053 2.5338830637208.052338.4383611