Excel中坐标反算程序

来源：网络收集时间：2026-09-18

导读：公路计算坐标导线点成果表国道主干线兰海高速公路树达段两阶段施工图设计点名 X(N)坐标4016866.628 4016285.690 4015626.151 4015142.857 4014729.494 4014021.693 4013556.557 4012761.119 4012250.197 4011787.221 4011327.042 4010708.739 4010160

公路计算坐标

导线点成果表国道主干线兰海高速公路树达段两阶段施工图设计点名 X(N)坐标4016866.628 4016285.690 4015626.151 4015142.857 4014729.494 4014021.693 4013556.557 4012761.119 4012250.197 4011787.221 4011327.042 4010708.739 4010160.584 4009896.521 4009430.081 4008917.578 4008357.400 4007719.839 4007931.344 4008008.094 4007885.470 4007528.738 4007163.179 4007151.874 4007017.063

S3-5 第1页共2页方位角(° ′″)155°14′39.5″ 1726.230 SDX026 SDX025 SDX024 SDX023 GPS027 GPS026 SDX022 SDX021 GPS023 GPS022 SDX020 SDX019 SDX018 SDX017 DX015 DX014 DX014-1 DX013-2 DX013 DX013-1 DX012 DX012-1 GPS010 GPS009 4007306.179 4007171.931 4006798.776 4006676.271 4006635.834 4006599.546 4006781.433 4007033.954 4006875.881 4006974.545 4006763.332 4006788.265 4006459.870 4006134.021 4006061.615 4006222.244 4006129.437 4006106.046 4006234.199 4006296.617 4006204.597 4006142.840 4006046.678 4005967.725 209292.785 914.482 1700.846 208388.211 482.322 1691.720 208082.613 537.704 1723.830 207559.050 598.209 1720.550 206962.209 509.959 1729.370 206453.543 185.739 1689.120 206415.913 814.443 1711.070 205641.607 1140.360 1725.026 204512.256 357.864 1718.460 204168.262 315.086 1724.350 203934.449 814.894 1666.880 203119.937 343.427 1676.805 203019.444 674.421 1694.690 202428.964 684.206 1670.755 201748.600 301.219 1705.810 201493.784 194.997 1680.830 201322.288 110.537 1628.363 201214.254 317.563 1689.985 200923.697 257.038 1681.328 200674.353 278.933 1665.359 200411.036 239.777 1688.961 200179.349 348.146 1702.924 199844.747 479.470 1714.800 199371.822 260°31′19.5″ 1561.410 253°57′56.7″ 1567.432 255°04′28.6″ 1571.862 250°44′14.2″ 1571.529 284°03′14.3″ 1571.621 293°48′01.2″ 1571.426 257°46′59.4″ 1565.535 241°34′46.0″ 1566.682 302°13′34.3″ 1569.468 263°55′31.1″ 1565.589 241°06′30.3″ 1753.837 197°00′53.1″ 1674.023 271°45′11.9″ 1679.857 227°54′25.8″ 1684.479 286°00′14.0″ 1615.412 262°01′55.8″ 1664.783 288°03′44.9″ 1872.190 348°18′40.2″ 1697.438 265°55′10.0″ 1678.731 266°07′26.5″ 1681.924 256°49′50.3″ 1657.224 219°18′57.6″ 1676.970 261°33′30.0″ 1694.298 174°22′58.4″ 164°04′50.4″ 221°18′55.3″ 195°46′12.1″ 190°46′36.7″ 187°30′12.6″ 207°25′42.8″ 161°56′49.4″ 164°15′41.8″ 189°11′02.0″ 172°43′10.0″ 181°02′03.1″ 191°00′43.5″ 175°03′59.3″ 199°36′51.1″ 160°48′01.2″ 350°17′30.8″ 283°47′13.4″ 259°11′33.7″ 223°43′16.8″ 236°28′18.6″ 268°40′49.0″ 237°44′51.9″

Y(E)坐标212553.439

边长(m)639.728

高程(m)1753.920

备注

点

名

X(N)坐标4007017.063

Y(E)坐标209635.512

边长(m)448.386

方位角(° ′″) 高程(m)1714.800 310°09′00.5″ 1772.026

备注

DX327 DX328 DX329 DX330 DX331 GPS313 GPS314 DX332 DX333 SDX334 DX335 DX336 DX337 DX338 DX339 GPS315 GPS316 DX341 GPS034 GPS033 DX0

31 DX030 DX029 DX028 SDX027

SDX027

212821.325 662.721 212886.192 502.568 213024.038 550.353 212660.693 735.485 212460.805 473.487 212372.270 802.308 212267.499 575.631 212002.339 486.948 212153.242 478.103 212282.925 626.332 212182.960 552.610 212252.991 264.106 212248.224 475.190 212157.455 514.409 212201.694 594.685 212002.067 675.112 212224.085 214.578 212187.901 322.054 211875.126 653.974 211232.751 493.604 210891.596 661.829 210339.886 490.860 209849.156 252.622 209635.512

编制：



 

复核：

公路计算坐标

导线点成果表国道主干线兰海高速公路树达段两阶段施工图设计点名 X(N)坐标4005967.725 4006218.561 4006283.476 4006068.935 4005967.361 4005279.832 4004754.565 4004604.605 4004288.636 4004084.348 4003943.840 4003635.222 4003023.181 4002782.434 4002770.497 4002397.340 4002472.220 4002453.023 4002348.344 4002538.637 4002645.486 4003150.086 4003909.408

S3-5 第2页共2页方位角(° ′″)315°23′46.1″ 1569.254 DX340 SDX342 SDX343 SDX344 SDX345 SDX346 GPS320 DX348 4007287.993 4006303.895 4005760.796 4004527.228 4003879.953 4003330.225 4002824.617 4002356.678 212245.304 1071.463 1599.645 212669.077 557.440 1641.590 212543.448 1293.177 1663.535 212931.541 669.271 1680.949 213101.713 1089.800 1675.190 214042.703 534.893 1657.852 213868.142 472.387 1702.324 213803.467 187°52′08.8″ 1573.398 199°02′49.9″ 1570.845 120°17′36.7″ 1605.645 165°16′11.9″ 1616.314 162°32′09.2″ 1593.521 193°01′28.2″ 1628.812 156°42′08.2″ 1631.590 276°42′07.6″ 237°02′54.2″ 254°59′22.7″ 221°16′58.3″ 190°10′41.0″ 241°31′00.7″ 222°24′44.3″ 248°07′58.7″ 1706.369 252°43′29.4″ 1719.048 227°13′01.3″ 1731.605 230°51′42.0″ 1700.253 232°05′09.8″ 1700.621 268°55′10.1″ 1702.033 238°11′25.6″ 1699.300 278°02′38.8″ 1700.384 265°05′00.9″ 1699.678 261°16′35.3″ 1705.348 284°04′33.5″ 1699.914 283°30′44.2″ 1602.418 340°14′19.7″ 1654.985 336°21′00.6″ 1621.384

Y(E)坐标199371.822

边长(m)352.308

高程(m)1561.410

备注

点

名

X(N)坐标4007719.839

Y(E)坐标212224.085

边长(m)432.367

方位角(° ′″) 高程(m)1680.830 177°11′13.2″ 1680.837

备注

GPS009 SDX011 GPS008 GPS007 DX010 SDX009 GPS006 GPS005 DX008 DX007 DX006 DX005 SDX008 DX370 DX371 SDX007 SDX006 SDX005 SDX004 SDX003 SDX002 SDX001 DX375

DX341

199124.431 556.219 198572.013 394.427 198241.037 392.188 197862.231 914.923 197258.586 533.665 197164.283 314.447 196887.897 427.962 196599.253 548.493 196090.224 473.153 195638.415 454.369 195304.939 969.655 194552.851 391.792 194243.753 633.007 193610.859 707.947 193009.242 535.103 192479.404 223.997 192256.231 690.192 1915 …… 此处隐藏：3232字，全部文档内容请下载后查看。喜欢就下载吧 ……

Excel中坐标反算程序.doc 将本文的Word文档下载到电脑，方便复制、编辑、收藏和打印

下载这篇word文档

本文链接：https://www.jiaowen.net/wendang/2324318.html（转载请注明文章来源）

上一篇：初一数学习题易错题汇编 017
下一篇：食品塑料包装材料的选用