A B 两列为规划点的经纬度共500个左右,C D 两列是村庄的经纬度,4000个左右,想通过函数求出 村庄是否位于所有的规划点3000m以内,求解答
A经度(规划) B 纬度(规划) C经度(村庄) D纬度(村庄) E 距离(m)
114.62927 37.75479 114.5451131 38.06119727
114.77085 37.79988 114.5439281 38.06728327
114.95982 37.78978 114.5675262 38.06484428
114.7648 37.83005 114.5748656 38.04345164
114.62325 37.72913 114.5617938 38.04097963
114.66265 38.25014 114.5811366 38.04348964
114.53442 37.78876 114.5347195 38.09455965
114.29869 37.87339 114.5264229 38.0954021
114.41828 37.81239 114.5457052 38.09127701
114.32737 37.85062 114.5517026 38.10170934
114.494347 37.707699 114.6027329 38.07178129
æ¥éª¤å¦ä¸ï¼
1.å·²ç¥ä¸¤å°ç»çº¬åº¦ï¼æ±ä¸¤å°è·ç¦»
2.è¾å ¥å¦ä¸å ¬å¼ï¼
=6371.004*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)
3.ç»æå¦ä¸ï¼