{"id":316,"date":"2026-08-24T17:53:36","date_gmt":"2026-08-24T09:53:36","guid":{"rendered":"https:\/\/xunzhaoweilai.cn\/?p=316"},"modified":"2026-09-10T18:01:03","modified_gmt":"2026-09-10T10:01:03","slug":"%e7%bb%8f%e7%ba%ac%e5%ba%a6%e8%ae%a1%e7%ae%97","status":"publish","type":"post","link":"https:\/\/xunzhaoweilai.cn\/index.php\/2026\/08\/24\/%e7%bb%8f%e7%ba%ac%e5%ba%a6%e8%ae%a1%e7%ae%97\/","title":{"rendered":"\u7ecf\u7eac\u5ea6\u8ba1\u7b97"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u5728\u8868\u683c\u4e2d\u5982\u679c\u8981\u8ba1\u7b97\u4e24\u4e2a\u7ecf\u7eac\u5ea6\u4e4b\u95f4\u7684\u8ddd\u79bb\uff0c\u53ea\u9700\u4e00\u4e2a\u516c\u5f0f\u5c31\u53ef\u4ee5\u641e\u5b9a\uff0c\u5c06\u6e90\u7ecf\u7eac\u5ea6\u548c\u76ee\u6807\u7ecf\u7eac\u5ea6\u653e\u5728A\\B\\C\\D\u5217\uff0c\u5728E\u5217\u8f93\u5165\u516c\u5f0f=6378137*<em>2<\/em>*ASIN(SQRT(SUMSQ(SIN((RADIANS(B2)-RADIANS(D2))\/2))+COS(RADIANS(B2))*COS(RADIANS(D2))*SUMSQ(SIN((RADIANS(A2)-RADIANS(C2))\/2))))\u5373\u53ef\u8ba1\u7b97\uff0c\u6548\u679c\u5982\u4e0b\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><tbody><tr><td>\u6e90\u7ecf\u5ea6Longitude<\/td><td>\u6e90\u7eac\u5ea6Latitude<\/td><td>\u76ee\u6807\u7ecf\u5ea6<\/td><td>\u76ee\u6807\u7eac\u5ea6<\/td><td>\u8ddd\u79bb-\u7c73<\/td><\/tr><tr><td>105.0795<\/td><td>29.59809<\/td><td>105.063889<\/td><td>29.591389<\/td><td>1685.185735<\/td><\/tr><tr><td>120.834023<\/td><td>30.174988<\/td><td>120.859047<\/td><td>30.044104<\/td><td>14767.87771<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f46\u5982\u679c\u6570\u91cf\u91cf\u5f88\u5927\uff0c\u4e14\u8981\u8fdb\u884c\u590d\u6742\u8ba1\u7b97\u7684\u8bdd\u7b80\u5355\u7684\u516c\u5f0f\u5c31\u6ca1\u529e\u6cd5\u5b8c\u6210\uff0c\u6b64\u65f6\u53ea\u80fd\u7528\u5de5\u5177\u6765\u5b8c\u6210\uff0c\u6709\u5927\u4f6c\u5f00\u53d1\u7684excel\u5b8f\u53ef\u4ee5\u5bf9\u8868\u95f4\u7684\u7ecf\u7eac\u5ea6\u8ddd\u79bb\u8fdb\u884c\u8ba1\u7b97\uff0c\u5305\u62ec\u6700\u5c0f\u8ddd\u79bb\u3001\u7279\u5b9a\u8ddd\u79bb\u3001\u6700\u8fd1\u51e0\u4e2a\u70b9\u4f4d\uff0c\u800c\u4e14\u5176\u8fd0\u884c\u8d77\u6765\u5f88\u5feb<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"508\" height=\"344\" src=\"https:\/\/xunzhaoweilai.cn\/wp-content\/uploads\/2026\/08\/image-1.png\" alt=\"\" class=\"wp-image-318\" style=\"width:650px;height:auto\" srcset=\"https:\/\/xunzhaoweilai.cn\/wp-content\/uploads\/2026\/08\/image-1.png 508w, https:\/\/xunzhaoweilai.cn\/wp-content\/uploads\/2026\/08\/image-1-300x203.png 300w\" sizes=\"auto, (max-width: 508px) 100vw, 508px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u5982\u9700\u7a0b\u5e8f\uff0c\u8bf7\u5173\u6ce8\u5fae\u4fe1\u516c\u4f17\u53f7\uff0c\u53d1\u9001\u201c\u7ecf\u7eac\u5ea6\u8ba1\u7b97\u201d\u83b7\u53d6\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u8868\u683c\u4e2d\u5982\u679c\u8981\u8ba1\u7b97\u4e24\u4e2a\u7ecf\u7eac\u5ea6\u4e4b\u95f4\u7684\u8ddd\u79bb\uff0c\u53ea\u9700\u4e00\u4e2a\u516c\u5f0f\u5c31\u53ef\u4ee5\u641e\u5b9a\uff0c\u5c06\u6e90\u7ecf\u7eac\u5ea6\u548c\u76ee\u6807\u7ecf\u7eac\u5ea6\u653e\u5728A\\B\\C\\D\u5217\uff0c\u5728&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[18],"class_list":["post-316","post","type-post","status-publish","format-standard","hentry","category-tools","tag-software"],"_links":{"self":[{"href":"https:\/\/xunzhaoweilai.cn\/index.php\/wp-json\/wp\/v2\/posts\/316","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xunzhaoweilai.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xunzhaoweilai.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xunzhaoweilai.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xunzhaoweilai.cn\/index.php\/wp-json\/wp\/v2\/comments?post=316"}],"version-history":[{"count":1,"href":"https:\/\/xunzhaoweilai.cn\/index.php\/wp-json\/wp\/v2\/posts\/316\/revisions"}],"predecessor-version":[{"id":319,"href":"https:\/\/xunzhaoweilai.cn\/index.php\/wp-json\/wp\/v2\/posts\/316\/revisions\/319"}],"wp:attachment":[{"href":"https:\/\/xunzhaoweilai.cn\/index.php\/wp-json\/wp\/v2\/media?parent=316"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xunzhaoweilai.cn\/index.php\/wp-json\/wp\/v2\/categories?post=316"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xunzhaoweilai.cn\/index.php\/wp-json\/wp\/v2\/tags?post=316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}