经纬度算距离

用EXCEL算
https://zhidao.baidu.com/question/1372805600144046539.html

=6371004*ACOS(1-(POWER((SIN((90-B2)*PI()/180)*COS(A2*PI()/180)-SIN((90-D2)*PI()/180)*COS(C2*PI()/180)),2)+POWER((SIN((90-B2)*PI()/180)*SIN(A2*PI()/180)-SIN((90-D2)*PI()/180)*SIN(C2*PI()/180)),2)+POWER((COS((90-B2)*PI()/180)-COS((90-D2)*PI()/180)),2))/2)

在线计算网站:
http://www.hhlink.com/经纬度

其它
https://blog.csdn.net/cuiluyang/article/details/43052693

标签: none

添加新评论