Excel_中边桩坐标计算程序(原件勿改)

左 边 桩 坐 标 右夹角 N （X ） E（Y） 距离
右 边 桩 坐 标 右夹角 N（X） E（Y）
桩 号 K48+760. K48+770. K48+780. K48+790. HY K48+799.355 K48+800. K48+810. K48+820. K48+830. K48+840. K48+850. QZ K48+856.705 K48+860. K48+870. K48+880. K48+890. K48+900. K48+910. YH K48+914.056 K48+920. K48+930. K48+940. K48+950. K48+960. K48+970.
左 边 பைடு நூலகம் 坐 标
右 边 桩 坐 标
桩 号 K48+980. HZ K48+984.056 ZH K48+984.057 K48+990. K49+000. K49+010. K49+020. HY K49+029.057 K49+030. K49+040. K49+050. QZ K49+059.388 K49+060. K49+070. K49+080. YH K49+089.719 K49+090. K49+100. K49+110. K49+120. ZH K49+124.719 HZ K49+124.719 K49+130. K49+140. K49+150.
左 边 桩 坐 标
右 边 桩 坐 标
桩 号 HY K49+159.719 K49+160. K49+170. K49+180. K49+190. K49+200. K49+210. QZ K49+213.66 K49+220. K49+230. K49+240. K49+250. K49+260. YH K49+267.601 K49+270. K49+280. K49+290. K49+300. ZH K49+302.6 HZ K49+302.601 K49+310. K49+320. K49+330. HY K49+337.6 K49+340.
中线坐标 3046817.255 3046813.969 3046810.155 3046805.661 3046800.721 3046800.352 3046794.165 3046787.150 3046779.393 3046770.988 3046762.038 3046755.785 3046752.652 3046742.944 3046733.033 3046723.040 3046713.087 3046703.295 3046699.396 3046693.781 3046684.625 3046675.842 3046667.411 3046659.279 3046651.375 450234.430 450224.987 450215.745 450206.816 450198.874 450198.344 450190.495 450183.375 450177.072 450171.663 450167.214 450164.796 450163.780 450161.401 450160.107 450159.914 450160.824 450162.826 450163.944 450165.891 450169.898 450174.672 450180.046 450185.865 450191.990 切线方位角 252°04′25.6″ 249°22′03.9″ 245°36′23.7″ 240°47′24.8″ 235°19′45.9″ 234°55′15.2″ 228°35′23.5″ 222°15′31.8″ 215°55′40.1″ 209°35′48.4″ 203°15′56.7″ 199°01′13.8″ 196°56′05.0″ 190°36′13.3″ 184°16′21.6″ 177°56′29.9″ 171°36′38.3″ 165°16′46.6″ 162°42′41.6″ 159°06′30.0″ 153°46′01.5″ 149°19′49.0″ 145°47′52.5″ 143°10′11.9″ 141°26′47.2″
中线坐标 3046608.471 3046616.757 3046624.004 3046630.010 3046633.612 3046634.609 3046637.673 3046639.118 3046638.903 3046637.034 3046634.592 3046634.592 3046634.592 3046634.592 3046633.563 3046628.587 3046622.242 3046614.706 3046606.187 3046599.398 3046596.921 3046587.164 3046577.188 3046567.268 3046557.680 450073.904 450068.327 450061.453 450053.472 450046.865 450044.606 450035.099 450025.215 450015.229 450005.417 449998.374 449998.374 449998.374 449998.374 449996.052 449987.392 449979.677 449973.121 449967.907 449965.001 449964.178 449962.038 449961.546 449962.716 449965.515 切线方位角 330°50′10.8″ 321°17′13.3″ 311°44′15.9″ 302°11′18.4″ 294°59′52.3″ 292°38′20.9″ 283°05′23.5″ 273°32′26.0″ 263°59′28.5″ 254°26′31.1″ 247°19′07.5″ 247°19′07.5″ 247°19′07.1″ 247°19′07.1″ 244°53′33.2″ 235°20′35.7″ 225°47′38.3″ 216°14′40.8″ 206°41′43.3″ 199°38′21.8″ 197°08′45.9″ 187°35′48.4″ 178°02′50.9″ 168°29′53.5″ 158°56′56.0″
中线坐标 桩 号 N （X ） K48+580. ZH K48+590.666 K48+600. K48+610. K48+620. K48+630. HY K48+630.666 K48+640. K48+650. K48+660. QZ K48+665.01 K48+670. K48+680. K48+690. YH K48+699.354 K48+700. K48+710. K48+720. K48+730. HZ K48+739.354 ZH K48+739.355 K48+740. K48+750. 3046919.844 3046910.651 3046902.618 3046894.096 3046885.757 3046877.715 3046877.193 3046870.089 3046862.936 3046856.292 3046853.166 3046850.191 3046844.662 3046839.733 3046835.687 3046835.428 3046831.735 3046828.528 3046825.644 3046823.094 3046823.093 3046822.919 3046820.181 E（Y） 450373.316 450367.908 450363.154 450357.923 450352.404 450346.463 450346.049 450339.998 450333.013 450325.542 450321.627 450317.621 450309.291 450300.593 450292.161 450291.569 450282.278 450272.807 450263.232 450254.232 450254.232 450253.610 450243.993 210°28′04.4″ 210°28′04.4″ 210°54′26.2″ 212°21′11.4″ 214°48′28.0″ 218°16′16.0″ 218°32′15.8″ 222°18′13.6″ 226°20′19.3″ 230°22′25.0″ 232°23′42.7″ 234°24′30.7″ 238°26′36.4″ 242°28′42.1″ 246°15′09.6″ 246°30′40.2″ 249°58′35.6″ 252°25′59.7″ 253°52′52.3″ 254°19′21.0″ 254°19′21.0″ 254°19′13.1″ 253°43′28.7″ 切线方位角 距离
中线坐标 3046493.852 3046493.710 3046489.442 3046486.731 3046485.652 3046486.235 3046488.465 3046489.681 3046492.279 3046497.571 3046504.196 3046511.969 3046520.674 3046527.768 3046530.072 3046539.876 3046549.836 3046559.832 3046562.432 3046562.432 3046569.831 3046579.817 3046589.725 3046597.098 3046599.373 450173.882 450173.639 450164.609 450154.995 450145.065 450135.094 450125.358 450121.907 450116.126 450107.655 450100.179 450093.906 450089.010 450086.294 450085.625 450083.698 450082.835 450082.571 450082.542 450082.542 450082.431 450081.938 450080.622 450078.789 450078.029 切线方位角 239°39′26.8″ 239°55′33.9″ 249°28′31.4″ 259°01′28.8″ 268°34′26.3″ 278°07′23.8″ 287°40′21.2″ 291°10′02.1″ 297°13′18.7″ 306°46′16.2″ 316°19′13.6″ 325°52′11.1″ 335°25′08.6″ 342°40′37.4″ 344°53′23.3″ 352°25′13.0″ 357°13′20.5″ 359°17′45.9″ 359°23′18.0″ 359°23′18.0″ 358°38′29.0″ 355°15′30.0″ 349°08′48.8″ 342°40′37.4″ 340°23′08.3″
中线坐标 3046643.608 3046640.474 3046640.474 3046635.877 3046628.028 3046619.876 3046611.278 3046603.040 3046602.157 3046592.560 3046582.666 3046573.285 3046572.674 3046562.790 3046553.213 3046544.387 3046544.141 3046535.715 3046527.869 3046520.409 3046516.950 3046516.949 3046513.092 3046505.960 3046499.359 450198.288 450200.864 450200.864 450204.632 450210.827 450216.616 450221.714 450225.464 450225.797 450228.579 450229.966 450229.973 450229.930 450228.472 450225.622 450221.573 450221.439 450216.066 450209.870 450203.212 450200.003 450200.002 450196.396 450189.387 450181.881 切线方位角 140°37′38.5″ 140°33′10.7″ 140°33′10.7″ 140°52′27.2″ 142°51′53.0″ 146°40′27.0″ 152°18′09.0″ 158°58′10.1″ 159°44′30.0″ 167°55′36.4″ 176°06′42.8″ 183°47′45.1″ 184°17′49.2″ 192°28′55.6″ 200°40′02.0″ 208°37′20.0″ 208°51′05.0″ 215°48′05.3″ 220°24′46.6″ 222°41′08.9″ 222°56′46.3″ 222°56′46.3″ 223°19′36.1″ 226°07′54.5″ 231°39′55.1″
左 边 桩 坐 标
右 边 桩 坐 标
桩 号 K49+350. K49+360. K49+370. K49+380. QZ K49+387.53 K49+390. K49+400. K49+410. K49+420. K49+430. ZH K49+437.459 HY K49+437.459 YH K49+437.46 HZ K49+437.46 K49+440. K49+450. K49+460. K49+470. K49+480. QZ K49+487.389 K49+490. K49+500. K49+510. K49+520. K49+530.