英语翻译6371000*ACOS(COS(RADIANS(SUM(1*LEFT(H3,FIND("°",H3)-1),M

妖精妖夭2022-10-04 11:39:541条回答

英语翻译
6371000*ACOS(COS(RADIANS(SUM(1*LEFT(H3,FIND("°",H3)-1),MID(H3,FIND("°",H3)+1,FIND("'",H3)-FIND("°",H3)-1)/60,RIGHT(LEFT(H3,LEN(H3)-1),LEN(H3)-FIND("'",H3)-1)/3600)-SUM(1*LEFT(D3,FIND("°",D3)-1),MID(D3,FIND("°",D3)+1,FIND("'",D3)-FIND("°",D3)-1)/60,RIGHT(LEFT(D3,LEN(D3)-1),LEN(D3)-FIND("'",D3)-1)/3600)))*COS(RADIANS(SUM(1*LEFT(I3,FIND("°",I3)-1),MID(I3,FIND("°",I3)+1,FIND("'",I3)-FIND("°",I3)-1)/60,RIGHT(LEFT(I3,LEN(I3)-1),LEN(I3)-FIND("'",I3)-1)/3600)-SUM(1*LEFT(E3,FIND("°",E3)-1),MID(E3,FIND("°",E3)+1,FIND("'",E3)-FIND("°",E3)-1)/60,RIGHT(LEFT(E3,LEN(E3)-1),LEN(E3)-FIND("'",E3)-1)/3600))))这个是xls表格的公式,小弟不才看不懂,跪求那个大哥帮我翻译下,这个是GPS经纬度的计算公式
111°40'57.143" 32°20'52.628"
111°40'58.694" 32°20'43.639" 结果是等于280米 那个 大哥帮我翻译下详细的公式,

已提交,审核后显示!提交回复

共1条回复
yzwxh 共回答了17个问题 | 采纳率76.5%
公式看上去很复杂,实际上很简单.
公式中大部分内容都是将文本形式的经纬度数据,转换成角度数据,也就是这些部分:
转换H3的经度数据:SUM(1*LEFT(H3,FIND("°",H3)-1),MID(H3,FIND("°",H3)+1,FIND("'",H3)-FIND("°",H3)-1)/60,RIGHT(LEFT(H3,LEN(H3)-1),LEN(H3)-FIND("'",H3)-1)/3600)
转换D3的经度数据:SUM(1*LEFT(D3,FIND("°",D3)-1),MID(D3,FIND("°",D3)+1,FIND("'",D3)-FIND("°",D3)-1)/60,RIGHT(LEFT(D3,LEN(D3)-1),LEN(D3)-FIND("'",D3)-1)/3600)
转换I3的纬度数据:SUM(1*LEFT(I3,FIND("°",I3)-1),MID(I3,FIND("°",I3)+1,FIND("'",I3)-FIND("°",I3)-1)/60,RIGHT(LEFT(I3,LEN(I3)-1),LEN(I3)-FIND("'",I3)-1)/3600)
转换E3的角度数据:SUM(1*LEFT(E3,FIND("°",E3)-1),MID(E3,FIND("°",E3)+1,FIND("'",E3)-FIND("°",E3)-1)/60,RIGHT(LEFT(E3,LEN(E3)-1),LEN(E3)-FIND("'",E3)-1)/3600)
这样,公式就简化为计算两个经纬度的距离公式:
6371000*ACOS(COS(RADIANS(H3经度角度值-D3经度角度值 ))*COS(RADIANS(I3纬度角度值-E3纬度角度值)))
其中:
RADIANS函数是将角度值转换为弧度值
COS是余弦函数,ACOS是反余弦函数
1年前

相关推荐