角度距离计算

已知2点经纬度，求距离和方位角（正北为0）
A2       B2    C2             D2
LON1 LAT1 SiteLON2 SiteLAT2

距离
=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)

方位角（E2）
=DEGREES(ATAN2((B2-D2),(A2-C2)*COS(RADIANS(D2))))
=IF(Y2<0,360+Y2,Y2)

2方位角度差
=IF(ABS(A2-B2)>180,360-ABS(A2-B2),ABS(A2-B2))

sin值
=SIN(RADIANS(E2))
cos值
=COS(RADIANS(E2))

角度
=DEGREES(ATAN2(cos值,sin值))