EXCEL全線路基坐標(biāo)計算程序

1、路路 線線 坐坐 標(biāo)標(biāo) 計計 算算 公公 式式樁號左線曲線要素曲線類型曲線起點(diǎn)樁號X坐標(biāo)Y坐標(biāo)曲線半徑緩和參數(shù) 曲線長度K129+500.000HY-YHK129+620.851 48050.176 8697.990-531.481230.540K129+520.000K129+620.851 48050.176 8697.990-531.481230.540K129+540.000K129+620.851 48050.176 8697.990-531.481230.540K129+560.000K129+620.851 48050.176 8697.990-531.481230.540K12

2、9+580.000K129+620.851 48050.176 8697.990-531.481230.540K129+600.000K129+620.851 48050.176 8697.990-531.481230.540K129+620.000K129+620.851 48050.176 8697.990-531.481230.540K129+620.851K129+620.851 48050.176 8697.990-531.481230.540K129+620.851YH-ZHK129+720.851 47999.283 8611.955531.481230.540100K129+6

3、40.000K129+720.851 47999.283 8611.955531.481230.540100K129+660.000K129+720.851 47999.283 8611.955531.481230.540100K129+680.000K129+720.851 47999.283 8611.955531.481230.540100K129+700.000K129+720.851 47999.283 8611.955531.481230.540100K129+720.000K129+720.851 47999.283 8611.955531.481230.540100K129+7

4、20.851K129+720.851 47999.283 8611.955531.481230.540100左K129+720.851ZH-HYK129+720.851 47999.283 8611.9551658.331575.900200左K129+740.000K129+720.851 47999.283 8611.9551658.331575.900200左K129+760.000K129+720.851 47999.283 8611.9551658.331575.900200左K129+780.000K129+720.851 47999.283 8611.9551658.331575

5、.900200左K129+800.000K129+720.851 47999.283 8611.9551658.331575.900200左K129+820.000K129+720.851 47999.283 8611.9551658.331575.900200左K129+840.000K129+720.851 47999.283 8611.9551658.331575.900200左K129+860.000K129+720.851 47999.283 8611.9551658.331575.900200左K129+880.000K129+720.851 47999.283 8611.9551

6、658.331575.900200左K129+900.000K129+720.851 47999.283 8611.9551658.331575.900200左K129+920.000K129+720.851 47999.283 8611.9551658.331575.900200左K129+920.852K129+720.851 47999.283 8611.9551658.331575.900200左K129+920.852HY-YHK129+920.852 47895.537 8441.0051658.331575.900左K129+940.000K129+920.852 47895.5

7、37 8441.0051658.331575.900左K129+960.000K129+920.852 47895.537 8441.0051658.331575.900左K129+980.000K129+920.852 47895.537 8441.0051658.331575.900左K130+000.000K129+920.852 47895.537 8441.0051658.331575.900左K130+025.000K129+920.852 47895.537 8441.0051658.331575.900左K130+040.000K129+920.852 47895.537 84

8、41.0051658.331575.900左K130+060.000K129+920.852 47895.537 8441.0051658.331575.900左K130+080.000K129+920.852 47895.537 8441.0051658.331575.900左K130+100.000K129+920.852 47895.537 8441.0051658.331575.900左K130+120.000K129+920.852 47895.537 8441.0051658.331575.900左K130+134.182K129+920.852 47895.537 8441.00

9、51658.331575.900左K130+134.182YH-HZK130+334.182 47738.541 8059.458 -1658.331575.900200左K130+140.000K130+334.182 47738.541 8059.458 -1658.331575.900200左K130+160.000K130+334.182 47738.541 8059.458 -1658.331575.900200左K130+180.000K130+334.182 47738.541 8059.458 -1658.331575.900200左K130+200.000K130+334.1

10、82 47738.541 8059.458 -1658.331575.900200左K130+220.000K130+334.182 47738.541 8059.458 -1658.331575.900200左K130+240.000K130+334.182 47738.541 8059.458 -1658.331575.900200左K130+260.000K130+334.182 47738.541 8059.458 -1658.331575.900200左K130+280.000K130+334.182 47738.541 8059.458 -1658.331575.900200左K1

11、30+300.000K130+334.182 47738.541 8059.458 -1658.331575.900200左K130+320.000K130+334.182 47738.541 8059.458 -1658.331575.900200左K130+334.182K130+334.182 47738.541 8059.458 -1658.331575.900200左K130+334.182HZ-ZHK130+334.182 47738.541 8059.458左K130+340.000K130+334.182 47738.541 8059.458左K130+360.000K130+

12、334.182 47738.541 8059.458左K130+380.000K130+334.182 47738.541 8059.458左K130+400.000K130+334.182 47738.541 8059.458左K130+420.000K130+334.182 47738.541 8059.458左K130+440.000K130+334.182 47738.541 8059.458左K130+460.000K130+334.182 47738.541 8059.458左K130+480.000K130+334.182 47738.541 8059.458左K130+500.

13、000K130+334.182 47738.541 8059.458左K130+520.000K130+334.182 47738.541 8059.458左K130+540.000K130+334.182 47738.541 8059.458左K130+560.000K130+334.182 47738.541 8059.458左K130+580.000K130+334.182 47738.541 8059.458左K130+600.000K130+334.182 47738.541 8059.458左K130+620.000K130+334.182 47738.541 8059.458左K

14、130+640.000K130+334.182 47738.541 8059.458左K130+660.000K130+334.182 47738.541 8059.458左K130+680.000K130+334.182 47738.541 8059.458左K130+700.000K130+334.182 47738.541 8059.458左K130+712.918K130+334.182 47738.541 8059.458左K130+712.918ZH-HYK130+712.918 47620.726 7699.513-1500519.620180左K130+720.000K130+

15、712.918 47620.726 7699.513-1500519.620180左K130+740.000K130+712.918 47620.726 7699.513-1500519.620180左K130+760.000K130+712.918 47620.726 7699.513-1500519.620180左K130+780.000K130+712.918 47620.726 7699.513-1500519.620180左K130+800.000K130+712.918 47620.726 7699.513-1500519.620180左K130+820.000K130+712.9

16、18 47620.726 7699.513-1500519.620180左K130+840.000K130+712.918 47620.726 7699.513-1500519.620180左K130+860.000K130+712.918 47620.726 7699.513-1500519.620180左K130+880.000K130+712.918 47620.726 7699.513-1500519.620180左K130+892.918K130+712.918 47620.726 7699.513-1500519.620180左K130+892.918HY-YHK130+892.9

17、18 47561.333 7529.625-1500519.620左K130+900.000K130+892.918 47561.333 7529.625-1500519.620左K130+920.000K130+892.918 47561.333 7529.625-1500519.620左K130+940.000K130+892.918 47561.333 7529.625-1500519.620左K130+960.000K130+892.918 47561.333 7529.625-1500519.620左K130+980.000K130+892.918 47561.333 7529.62

18、5-1500519.620左K131+000.000K130+892.918 47561.333 7529.625-1500519.620左K131+020.000K130+892.918 47561.333 7529.625-1500519.620左K131+040.000K130+892.918 47561.333 7529.625-1500519.620YH-HZ左K131+060.000K130+892.918 47561.333 7529.625-1500519.620左K131+080.000K130+892.918 47561.333 7529.625-1500519.620左K

19、131+100.000K130+892.918 47561.333 7529.625-1500519.620左K131+120.000K130+892.918 47561.333 7529.625-1500519.620左K131+140.000K130+892.918 47561.333 7529.625-1500519.620左K131+160.000K130+892.918 47561.333 7529.625-1500519.620左K131+180.000K130+892.918 47561.333 7529.625-1500519.620左K131+200.000K130+892.

20、918 47561.333 7529.625-1500519.620左K131+220.000K130+892.918 47561.333 7529.625-1500519.620左K131+240.000K130+892.918 47561.333 7529.625-1500519.620左K131+260.000K130+892.918 47561.333 7529.625-1500519.620左K131+280.000K130+892.918 47561.333 7529.625-1500519.620左K131+300.000K130+892.918 47561.333 7529.6

21、25-1500519.620左K131+320.000K130+892.918 47561.333 7529.625-1500519.620左K131+340.000K130+892.918 47561.333 7529.625-1500519.620左K131+360.000K130+892.918 47561.333 7529.625-1500519.620左K131+380.000K130+892.918 47561.333 7529.625-1500519.620左K131+400.000K130+892.918 47561.333 7529.625-1500519.620左K131+

22、420.000K130+892.918 47561.333 7529.625-1500519.620左K131+440.000K130+892.918 47561.333 7529.625-1500519.620左K131+447.007K130+892.918 47561.333 7529.625-1500519.620左K131+447.007YH-HZ左K131+460.000左K131+480.000左K131+500.000左K131+520.000左K131+540.000左K131+560.000左K131+580.000左K131+600.000左K131+620.000左K1

23、31+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.000K131+880.000K131+900.000K131+920.000HY-YHK131+940.000K131+960.000K131+980.000K132+000.000K132+020.000K132+040.000K132+060.000K132+080

24、.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右K129+860.000右K129+880.000右K129+900.000右K129+920.000右K129+940.000右K129+9

25、60.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右K130+320.000右K130+340.000右K130+360.000右K130+380.000右K130+400.000右K130+42

26、0.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右K130+780.000右K130+800.000右K130+820.000右K130+840.000右K130+860.000右K130+880

27、.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右K131+240.000右K131+260.000右K131+280.000右K131+300.000右K131+320.000右K131+340.

28、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左邊邊坐標(biāo)中樁方位角距離XYXY242.9906389 2425926.3012.2548080.5113 8811.189 48092.398 8810.948242.9906389 2425926.3012.2548075.4351 8791.913 48087.202 8791.636242.9906389 2425926.3

29、012.2548069.6526 8772.847 48081.284 8772.533242.9906389 2425926.3012.2548063.1721 8754.015 48074.650 8753.666242.9906389 2425926.3012.2548056.0027 8735.447 48067.312 8735.062242.9906389 2425926.3012.2548048.1547 8717.167 48059.278 8716.748242.9906389 2425926.3012.2548039.639 8699.201 48050.562 8698.

30、748242.9906389 2425926.3012.2548039.2621 8698.444 48050.176 8697.990237.5955556 2373544.0012.2548039.2654 8698.443 48050.1789 8697.988237.5955556 2373544.0012.2548030.4687 8681.561 48041.1951 8681.079237.5955556 2373544.0012.2548020.7272 8664.209 48031.2921 8663.703237.5955556 2373544.0012.2548010.5

31、494 8647.081 48020.9937 8646.559237.5955556 2373544.0012.2548000.0636 8630.107 48010.4329 8629.574237.5955556 2373544.0012.2547989.3965 8613.209 47999.739 8612.673237.5955556 2373544.0012.2547988.9405 8612.491 47999.283 8611.955237.5955556 2373544.0012.2547988.9405 8612.491 47999.283 8611.955237.595

32、5556 2373544.0012.2547978.678 8596.321 47989.0242 8595.786237.5955556 2373544.0012.2547967.9712 8579.420 47978.3288 8578.886237.5955556 2373544.0012.2547957.2964 8562.492 47967.6734 8561.961237.5955556 2373544.0012.2547946.6744 8545.526 47957.0784 8544.998237.5955556 2373544.0012.2547936.1258 8528.5

33、08 47946.5645 8527.984237.5955556 2373544.0012.2547925.6719 8511.426 47936.1525 8510.908237.5955556 2373544.0012.2547915.3338 8494.269 47925.8635 8493.758237.5955556 2373544.0012.2547905.1332 8477.025 47915.7187 8476.522237.5955556 2373544.0012.2547895.092 8459.684 47905.7399 8459.189237.5955556 237

34、3544.0012.2547885.2326 8442.234 47895.9489 8441.750237.5955556 2373544.0012.2547884.8169 8441.489 47895.5363 8441.004241.0505833 2410302.1012.2547884.8177 8441.489 47895.537 8441.005241.0505833 2410302.1012.2547875.5785 8424.670 47886.366 8424.196241.0505833 2410302.1012.2547866.1377 8406.991 47876.

35、994 8406.528241.0505833 2410302.1012.2547856.9122 8389.201 47867.836 8388.748241.0505833 2410302.1012.2547847.9034 8371.301 47858.893 8370.859241.0505833 2410302.1012.2547836.9491 8348.776 47848.019 8348.348241.0505833 2410302.1012.2547830.541 8335.184 47841.658 8334.764241.0505833 2410302.1012.2547

36、822.198316.972 47833.369 8316.563241.0505833 2410302.1012.2547814.0607 8298.661 47825.299 8298.263241.0505833 2410302.1012.2547806.1544 8280.254 47817.451 8279.867241.0505833 2410302.1012.2547798.472 8261.754 47809.825 8261.379241.0505833 2410302.1012.2547793.1609 8248.581 47804.552 8248.213251.8761

37、111 2515234.0012.2547793.1612 8248.584 47804.5526 8248.216251.8761111 2515234.0012.2547791.0153 8243.167 47802.4222 8242.802251.8761111 2515234.0012.2547783.7805 8224.492 47795.2364 8224.138251.8761111 2515234.0012.2547776.7487 8205.744 47788.2469 8205.399251.8761111 2515234.0012.2547769.8975 8186.9

38、32 47781.432 8186.596路路 線線 坐坐 標(biāo)標(biāo) 計計 算算 公公 式式左線曲線要素251.8761111 2515234.0012.2547763.2044 8168.068 47774.7695 8167.738251.8761111 2515234.0012.2547756.6467 8149.159 47768.2369 8148.835251.8761111 2515234.0012.2547750.2016 8130.214 47761.8118 8129.895251.8761111 2515234.0012.2547743.8462 8111.242 47755

39、.4715 8110.927251.8761111 2515234.0012.2547737.5577 8092.251 47749.1932 8091.938251.8761111 2515234.0012.2547731.3129 8073.247 47742.954 8072.936251.8761111 2515234.0012.2547726.8988 8059.769 47738.541 8059.458251.8761111 2515234.0012.2547726.8988 8059.769 47738.541 8059.458251.8761111 2515234.0012.

40、2547725.0889 8054.240 47736.7312 8053.929251.8761111 2515234.0012.2547718.8675 8035.232 47730.5097 8034.921251.8761111 2515234.0012.2547712.646 8016.224 47724.2883 8015.913251.8761111 2515234.0012.2547706.4246 7997.217 47718.0668 7996.905251.8761111 2515234.0012.2547700.2031 7978.209 47711.8454 7977

41、.898251.8761111 2515234.0012.2547693.9817 7959.201 47705.6239 7958.890251.8761111 2515234.0012.2547687.7602 7940.193 47699.4025 7939.882251.8761111 2515234.0012.2547681.5388 7921.186 47693.181 7920.875251.8761111 2515234.0012.2547675.3173 7902.178 47686.9595 7901.867251.8761111 2515234.0012.2547669.

42、0959 7883.170 47680.7381 7882.859251.8761111 2515234.0012.2547662.8744 7864.163 47674.5166 7863.851251.8761111 2515234.0012.2547656.653 7845.155 47668.2952 7844.844251.8761111 2515234.0012.2547650.4315 7826.147 47662.0737 7825.836251.8761111 2515234.0012.2547644.217807.139 47655.8523 7806.828251.876

43、1111 2515234.0012.2547637.9886 7788.132 47649.6308 7787.821251.8761111 2515234.0012.2547631.7671 7769.124 47643.4094 7768.813251.8761111 2515234.0012.2547625.5457 7750.116 47637.1879 7749.805251.8761111 2515234.0012.2547619.3242 7731.108 47630.9665 7730.797251.8761111 2515234.0012.2547613.1028 7712.

44、101 47624.745 7711.790251.8761111 2515234.0012.2547609.0843 7699.824 47620.7266 7699.513251.8761111 2515234.0012.2547609.0838 7699.824 47620.726 7699.513251.8761111 2515234.0012.2547606.8809 7693.094 47618.5228 7692.782251.8761111 2515234.0012.2547600.6528 7674.091 47612.2899 7673.778251.8761111 251

45、5234.0012.2547594.3924 7655.102 47606.0189 7654.787251.8761111 2515234.0012.2547588.0716 7636.137 47599.6817 7635.818251.8761111 2515234.0012.2547581.6627 7617.204 47593.2503 7616.880251.8761111 2515234.0012.2547575.1382 7598.315 47586.6969 7597.984251.8761111 2515234.0012.2547568.4708 7579.480 4757

46、9.9938 7579.141251.8761111 2515234.0012.2547561.6334 7560.711 47573.1137 7560.362251.8761111 2515234.0012.2547554.5996 7542.018 47566.0294 7541.658251.8761111 2515234.0012.2547549.9398 7529.992 47561.3326 7529.625248.4383611 2482618.1012.2547549.9402 7529.993 47561.333 7529.625248.4383611 2482618.10

47、12.2547547.3434 7523.417 47558.715 7523.045248.4383611 2482618.1012.2547539.8438 7504.914 47551.153 7504.529248.4383611 2482618.1012.2547532.1001 7486.513 47543.346 7486.116248.4383611 2482618.1012.2547524.1135 7468.218 47535.294 7467.809248.4383611 2482618.1012.2547515.8856 7450.032 47526.998 7449.

48、611248.4383611 2482618.1012.2547507.4177 7431.958 47518.460 7431.525248.4383611 2482618.1012.2547498.7114 7413.999 47509.682 7413.554248.4383611 2482618.1012.2547489.7683 7396.159 47500.666 7395.702248.4383611 2482618.1012.2547480.5898 7378.441 47491.412 7377.972248.4383611 2482618.1012.2547471.1777

49、 7360.847 47481.922 7360.367248.4383611 2482618.1012.2547461.5337 7343.382 47472.199 7342.890248.4383611 2482618.1012.2547451.6594 7326.048 47462.243 7325.544248.4383611 2482618.1012.2547441.5565 7308.848 47452.057 7308.333248.4383611 2482618.1012.2547431.227 7291.785 47441.642 7291.258248.4383611 2

50、482618.1012.2547420.6726 7274.862 47431.001 7274.324248.4383611 2482618.1012.2547409.8952 7258.083 47420.135 7257.534248.4383611 2482618.1012.2547398.8967 7241.450 47409.046 7240.890248.4383611 2482618.1012.2547387.6791 7224.966 47397.736 7224.395248.4383611 2482618.1012.2547376.2444 7208.634 47386.

51、207 7208.052248.4383611 2482618.1012.2547364.5945 7192.458 47374.461 7191.865248.4383611 2482618.1012.2547352.7316 7176.439 47362.501 7175.836248.4383611 2482618.1012.2547340.6579 7160.581 47350.327 7159.967248.4383611 2482618.1012.2547328.3753 7144.887 47337.944 7144.263248.4383611 2482618.1012.254

52、7315.8862 7129.359 47325.352 7128.724248.4383611 2482618.1012.2547303.1927 7114.000 47312.554 7113.355248.4383611 2482618.1012.2547290.297 7098.814 47299.552 7098.158248.4383611 2482618.1012.2547277.2016 7083.801 47286.349 7083.136248.4383611 2482618.1012.2547263.9086 7068.966 47272.946 7068.291248.

53、4383611 2482618.1012.2547259.2052 7063.811 47268.204 7063.133圓曲線右邊邊樁FGIXY角度弧度角度弧度角度48104.2868810.706 332.9906389 5.811783027 166.01886052.897575736346.018860548098.9708791.358 332.9906389 5.811783027 163.86278042.85994504343.862780448092.9148772.219 332.9906389 5.811783027 161.70670042.822314344341.

54、706700448086.1288753.317 332.9906389 5.811783027 159.55062032.784683648339.550620348078.6208734.678 332.9906389 5.811783027 157.39454022.747052952337.394540248070.4028716.329 332.9906389 5.811783027 155.23846022.709422256335.238460248061.4858698.296 332.9906389 5.811783027 153.08238012.67179156333.0

55、82380148061.0908697.536 332.9906389 5.811783027 152.99063892.670190374332.990638948061.0928697.5340332.985755848051.9228680.59600331.11906748041.8578663.19700329.591462748031.4388646.03600328.495074548020.8028629.04200327.829902248010.0828612.13800327.59594600327.595555600327.595555600327.6272282003

56、27.727938800327.897749900328.136661500328.444673700328.821786400329.267999700329.783313400330.367727800331.021242600331.0506169331.0505833 5.777922669 151.05058332.636330016331.0505833331.0505833 5.777922669 151.71215182.647876565331.7121518331.0505833 5.777922669 152.40315722.659936883332.403157233

57、1.0505833 5.777922669 153.09416252.671997202333.0941625331.0505833 5.777922669 153.78516792.68405752333.7851679331.0505833 5.777922669 154.64892462.699132918334.6489246331.0505833 5.777922669 155.16717862.708178157335.1671786331.0505833 5.777922669 155.85818392.720238475335.8581839331.0505833 5.7779

58、22669 156.54918932.732298794336.5491893331.0505833 5.777922669 157.24019462.744359112337.2401946331.0505833 5.777922669 157.93122.756419431337.9312331.0505833 5.777922669 158.42119182.764971403338.4211918341.8761111 5.966863773 168.78616462.945874304338.421084400338.619174100339.255527800339.8227810

59、0340.3209337路路 線線 坐坐 標(biāo)標(biāo) 計計 算算 公公 式式00340.749985800341.109937400341.400788500341.62253900341.77518900341.858738400341.8761111341.8761111341.8761111341.8761111341.8761111341.8761111341.8761111341.8761111341.8761111341.8761111341.8761111341.8761111341.8761111341.8761111341.8761111341.8761111341.8761111

60、341.8761111341.8761111341.8761111341.8761111341.8761111341.8761111341.8707895341.7982913341.6409104341.3986468341.0715007340.6594719340.1625604339.5807663338.9140896338.4383643338.4383611 5.906863716 158.43836112.765271063338.4383611338.4383611 5.906863716 158.16784862.760549729338.1678486338.438361