第三行,A3单元格输入所在地的中央子午线(如不知道可以查阅资料计算),以度分秒的形式输入.
B3中输入=INT(A3) (INT(A3*100)-INT(A3)*100)/60 (A3*10000-INT(A3*100)*100)/3600
C3输入纬度值,D3输入经度值(度分秒)
E3输入=INT(C3) (INT(C3*100)-INT(C3)*100)/60 (C3*10000-INT(C3*100)*100)/3600
F3输入=INT(D3) (INT(D3*100)-INT(D3)*100)/60 (D3*10000-INT(D3*100)*100)/3600
G3输入=F3-B3
H3输入=G3/57.2957795130823
I3输入=TAN(RADIANS(E3))
J3输入=COS(RADIANS(E3))
K3输入=0.006738525415*J3*J3
L3输入=I3*I3
M3输入=1+K3
N3输入=6399698.9018/SQRT(M3)
O3输入=H3*H3*J3*J3P3输入=I3*J3Q3输入=P3*P3R3输入=(32005.78006+Q3*(133.92133+Q3*0.7031))S3输入=6367558.49686*E3/57.29577951308-P3*J3*R3+((((L3-58)*L3+61)*O3/30+(4*K3+5)*M3-L3)*O3/12+1)*N3*I3*O3/2
T3输入=((((L3-18)*L3-(58*L3-14)*K3+5)*O3/20+M3-L3)*O3/6+1)*N3*(H3*J3)