| Excel VBA在GPS坐标转换计算中的应用 |
| |
| 引用本文： | 王佩贤,刘永睿,王婷.Excel VBA在GPS坐标转换计算中的应用[J].测绘科学,2012,37(5):200-201. |
| |
| 作者姓名： | 王佩贤 刘永睿 王婷 |
| |
| 作者单位： | 辽宁工程技术大学测绘与地理科学学院,辽宁阜新,123000 |
| |
| 基金项目： | 辽宁省教育厅重点实验室经费资目(编号2008S110) |
| |
| 摘 要： | 为了使GPS的观测成果在实际中得到应用,必须把GPS观测得到的WGS-84坐标转换成实际需要的国家大地坐标或地方独立坐标。本文利用Excel软件的宏程序VBA进行编程,实现不同坐标系之间坐标的相互转换。并且给出一些关于坐标转换的算例,结果表明:所编程序可以方便、快捷、可靠、准确地解决不同坐标间的转换问题,能够满足设计计算工作的要求。
|
| 关 键 词： | Excel VBA GPS 坐标转换 独立坐标系 WGS- |
Application of Excel VBA in GPS coordinate transformation calculation |
| |
| WANG Pei-xian
,
LIU Yong-rui
,
WANG Ting.Application of Excel VBA in GPS coordinate transformation calculation[J].Science of Surveying and Mapping,2012,37(5):200-201. |
| |
| Authors: | WANG Pei-xian LIU Yong-rui WANG Ting |
| |
| Institution: | (School of Geomatics,Liaoning Technical University,Liaoning Fuxin 123000,China) |
| |
| Abstract: | In order to use GPS coordinate,the coordinates in WGS-84 got from GPS observation need to be transformed to the coordinates of national coordinate or local independent coordinate in practical engineering.In the paper,it made a macro program in Excel to convert the coordinate data from one coordinate system to another.Also it gave some examples of coordinate transformation.The results showed that the procedure would be feasible and it could be satisfied to calculate conveniently,fast,reliably and exactly. |
| |
| Keywords: | Excel VBA GPS coordinate transformation independent coordinate system WGS-84 |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
