☰

Excel 轴承计算

tag-icon • tag-icon microsoft-excel worksheet-function coordinates
Excel 轴承计算

我想从地图上找到坐标的罗盘方位： 附有示例的地图 中间点就是我所在的位置。

我已经知道点之间的距离。但我找不到适合 Excel 表格的方位公式

答案1

从这里：https://www.igismap.com/formula-to-find-bearing-or-heading-angle-between-two-points-latitude-longitude/ 您可以使用以下方式计算弧度和度数的方向：

=DEGREES(ATAN2(x2-x1,y2-y1))

然后您可以使用这里的函数： https://www.mrexcel.com/board/threads/convert-number-in-deg-to-direction-text-n-nne.541185/ 分配地图方向，这个看起来最好：

=CHOOSE(1+ROUND(A1/22.5,0),"N","NNE","NE","ENE","E","ESE","SE","SSE","S","SSW","SW","WSW","W","WNW","NW","NNW","N")

或者您可以将这些内容合并到一个单元格中，例如：

=ROUND(DEGREES(ATAN2(B2,B3)),2) & "° " & LOOKUP(MOD(DEGREES(ATAN2(B2,B3)),360),{0,22.5,45,67.5,90,112.5,135,157.5,180,202.5,225,247.5,270,292.5,315,337.5},{"N","NNE","NE","ENE","E","ESE","SE","SSE","S","SSW","SW","WSW","W","WNW","NW","NNW"})

其中我在 B2 和 B3 中有 X 和 Y 的计算。

我使用坐标已经有一段时间了，所以它可能不是正确的术语，但你应该能够进行修改以适应。

相关内容