• ??ӭ?????й????????     
  • ?ղر?վ
  • |
  • ??ҪͶ??
  • ??ע???ǣ?
  •  ΢ ??
  • Cehui8.com ????????Ϣ??ҵ??һƷ???Ż?
???????| ???????| ר??̽??| 3S| ????б?| ???չ??| ??Ʒ????| ???淶| ????????| ???ñ???| ???????| ????| ??ַ??ȫ|?˲?|??̳
??ҳ > ??????? > ????/????

??EXCEL???GPS????ת???ļ??׷???

2013-07-08 21:57:55????Դ: ?????̳?????ߣ?
????
 ??Ϊ??˼???GPS???ܷ??????Եزⶨ????λ???꣬?????Dz????ϻ??Ǿ????ϣ???ȫվ?ǵ?????????????豸?????Ե???Խ?ԡ??????ҹ?????GPS???̨վ?IJ??Ͻ????Լ?????SA???ߵ?ȡ????ʹ?õ?????λ?ľ??ȴ????ߣ??е??Ѿ??ﵽ?????׼????ȣ??ܹ??????????Դ???顢???????ø??¡?ң?м?⡢????ʹ??Ȩ???ȹ?????Ӧ?á???һ??????£?????ʹ?õ???1954?걱??????ϵ??1980??????????ϵ?????·ֱ???54ϵ??80ϵ??????GPS?ⶨ????????WGS-84????ϵ???꣬??Ҫ????????ϵת???????ڷDz???רҵ?Ĺ?????Ա??˵????ȻGPS??λ?????dz????ף???????ת???????????գ?EXCEL?DZȽ??ռ??ĵ??ӱ??????????ܹ??????ϸ??ӵ???ѧ???㣬??????????GPS????ת????????????dz????????硣Ҫ????????ϵת?????벻????˹ͶӰ???㣬????ֱ??????EXCEL???л???ķ?????GPS????ת????????

һ????EXCEL???и?˹ͶӰ????

?Ӿ?γ??BL???㵽??˹ƽ??ֱ??????XY????˹ͶӰ???㣩?????XY?????BL????˹ͶӰ???㣩??һ????Ҫר?ü??????????ɣ???Ŀǰ???еĻ????????У?????һ????ͬ?IJ???֮????????????Խϲ????Ҫһ????һ????ؽ??У????ܳ?????????ɣ???ʵ?ʹ??????????಻?㡣???߷??֣???EXCEL???Ժ?ֱ?ۡ????????????껻?㹤????????Ҫ?????κ???????ֻ??Ҫ??EXCEL????Ӧ??Ԫ??????????Ӧ?Ĺ?ʽ???ɡ???????54ϵΪ???????ܾ???ļ??㷽????

??ɾ?γ??BL??ƽ??ֱ??????XY?Ļ??㣬??EXCEL?д?Լ??Ҫռ??21?У???Ȼ???߿???ͨ???򻯼??㹫ʽ????ֱ???ԣ??ʵ????ӻ??????ռ????????EXCEL?У????빫ʽ????ʼ??Ԫ??ͬ????ӳ?????Ĺ?ʽ??ͬ???Թ?ʽ?ӵ?2?е?1?У?A2??Ϊ??ʼ??Ԫ??Ϊ????????Ԫ??Ĺ?ʽ???£?

??Ԫ??
??Ԫ??????
˵??
A2
?????????????ߣ??Զ?.??????ʽ???룬??115??30????????115.30
????????L0
B2
=INT(A2)+(INT(A2*100)-INT(A2)*100)/60+(A2*10000-INT(A2*100)*100)/3600
??L0???ɶ?
C2
?Զ?С????ʽ????γ??ֵ????38°14′20″??????38.1420
????????B
D2
?Զ?С????ʽ???뾭??ֵ
????????L
E2
=INT(C2)+(INT(C2*100)-INT(C2)*100)/60+(C2*10000-INT(C2*100)*100)/3600
??B???ɶ?
F2
=INT(D2)+(INT(D2*100)-INT(D2)*100)/60+(D2*10000-INT(D2*100)*100)/3600
??L???ɶ?
G2
=F2-B2
L-L0
H2
=G2/57.2957795130823
????????
I2
=TAN(RADIANS(E2))
Tan(B)
J2
=COS(RADIANS(E2))
COS(B)
K2
=0.006738525415*J2*J2
  
L2
=I2*I2
  
M2
=1+K2
  
N2
=6399698.9018/SQRT(M2)
  
O2
=H2*H2*J2*J2
  
P2
=I2*J2
  
Q2
=P2*P2
  
R2
=(32005.78006+Q2*(133.92133+Q2*0.7031))
  
S2
=6367558.49686*E2/57.29577951308-P2*J2*R2+((((L2-58)*L2+61)*
O2/30+(4*K2+5)*M2-L2)*O2/12+1)*N2*I2*O2/2
??????X
T2
=((((L2-18)*L2-(58*L2-14)*K2+5)*O2/20+M2-L2)*O2/6+1)*N2*(H2*J2)
??????Y

???й?ʽ????Դ??EXCEL?????IJ???????????????й????ϣ????ﲻ??׸??????????????еĹ?ʽ???뵽??Ӧ??Ԫ??󣬾Ϳɷ?????ɾ?γ?????ƽ??ֱ?????ꡣ???????????еľ?γ?Ⱥ?????????????ɵõ????еļ??????????е????൥Ԫ??ʽΪ?м???̣???????EXCEL???????ع??ܰ???Щû?б?Ҫ??ʾ?????????????????????γɱ?׼?ļ??㱨????ʹ??????????????ˡ????????Ͻ????ɼ???????????????޵ģ?????һ?????빫ʽ???൱???Լ??????һ?????ı??ƣ?????????????????ظ?ʹ?ã?һ?????ݡ?

????GPS????ת???????????????

GPS?????õ?????ϵ????????????1984????????ϵ?????WGS-84??????һ??Э?????ο?ϵ??????ϵԭ???ڵ??????ġ?GPS?IJ?????????ҹ???54ϵ??80ϵ??????ʮ????һ?ٶ??ף???????ͬ?????Ҳ??ͬ????????ͳ?ƣ??ҹ????????70?????ң???????140?????ң??ϲ?75?????ң??в?45?????ҡ??ɴ˿ɼ??????뽫WGS-84???????????ϵת?????ܹ???ͼʹ?á?????ϵ֮???ת??һ??????߲??????????????????????߲???ΪXƽ?ơ?Yƽ?ơ?Zƽ?ơ?X??ת??Y??ת??Z??ת?Լ??߶ȱȲ?????????????ת?????ͳ߶ȱȲ?????Ϊ????????????????????Ϊ?߲??????????????????Z??Y??Z?ǿռ???ֱ??????ϵ???꣬Ϊת?????̵??м?ֵ????ʵ?ʹ????????dz??õ???ƽ??ֱ?????꣬?Ƿ?????????ռ?ֱ??????ϵ??ʡ?Ը??ӵ????㣬???м?ת???أ?Ϊ?ˣ????߽????˳??ڵ?ʵ????֤???ǿ??еġ?????ԭ???ǣ?????GPS???ⶨ??WGS-84???굱??WGS-84???꣬???ǵ???????һ??ϵͳ??????54ϵ????ֵ??Ȼ??ͨ????????֪?????????????ϵͳ???????ݰѸ÷????????????????????????WGS-84????ת????54ϵ????Ϊ???????????ݴ?????????

???ȣ??ڲ???????ѡ??һ??????֪?㣬?ڸ???֪??????GPS?ⶨWGPS-84????ϵ??γ??B??L???Ѵ???????Ϊ??????54ϵ???꣬????54ϵEXCEL????γ??BLת????ƽ??ֱ??????X’Y’??Ȼ??????֪????Ƚ???ɼ????ƫ??????

??X=X??X’
??Y=Y??Y’
ʽ?е?X??YΪ???ҿ??Ƶ????֪???꣬X’??Y’Ϊ?ⶨ???꣬??X?͡?YΪƫ??????

???ƫ?????󣬾Ϳ????ô?ƫ?????????????ڵ????????????ˡ???????GPS??????ľ?γ?Ȳ???ֵ??ת????ƽ??????X’Y’???ڴ?XY????ֵ??ֱ?Ӽ???ƫ??ֵ?͵õ???ת?????54ϵ???꣺
X=X’+??X
Y=Y’+??Y
??????EXCEL?????????????У?????????õĸ????????ֱ???????????XY??Ӻ󣬼??õ?ת?????????????·????һ?պ?????Ļ????ɰѼ???????·??˳????????????????????Ӧ?ļ??㹫ʽ?????ɼ?????????????????й???????????????ԭ???빫ʽ?????ﲻ???????????߿ɲ????й????ϡ???Ҫ˵?????ǣ?????ļ??㾫?Ȼ????ϲ???????ת?????ȵ?Ӱ?죬??ֻ??Ҫ????????Ļ????ɲ?????????ϵת????һ????ֻ??Ҫ??BL????XY?????ˡ?

??1??1??????߳?ͼ???ԣ???һ?????????????Χ?ڣ???40Km×40Km?????ô˼򵥵??????????????ת????ϸ??ӵ??߲?????û?ж?????ܷ?????1??1??????߱???????Ҫ????Ҫȡ????GPS???ջ??????ľ??ȣ???ת????????ѡ???ϵ???󡣵?????ϴ?ʱ??ʹ?ø÷??????ܻ?ʹ?????????ʱ?ɿ??Ƿ?????ת????
??Ȩ????????վ??????????Դ?????磨??????Ͷ?壩????????Ȩ??????ϵ????ɾ????????
????Ķ?