| 利用Excel实现不同坐标系间的坐标转换 |
| |
| 引用本文： | 李冰峰,陈华荣,王显金.利用Excel实现不同坐标系间的坐标转换[J].地矿测绘,2007,23(3):13-16. |
| |
| 作者姓名： | 李冰峰 陈华荣 王显金 |
| |
| 作者单位： | 1. 武汉大学,资源与环境科学学院,湖北,武汉,430072
2. 贵州省地质矿产勘查开发局,一○五地质大队,贵州,贵阳,550018 |
| |
| 摘 要： | 以二元三次多项式作为坐标转换的数学模型,利用EXCEL软件的宏程序VBA进行编程,求得不同坐标系间的转换参数,最后利用这些参数实现不同坐标系之间坐标的相互转换。
|
| 关 键 词： | 坐标转换 最小二乘法 EXCEL宏程序 高斯主元消去法 二元三次方程多项式 程序设计 |
| 文章编号： | 1007-9394（2007）03-0013-04 |
| 修稿时间： | 2007-01-18 |
Converting Coordinates Data of Different Coordinate Systems by Means of Excel |
| |
| LI Bing-feng,CHEN Hua-rong,WANG Xian-jin.Converting Coordinates Data of Different Coordinate Systems by Means of Excel[J].Surveying and Mapping of Geology and Mineral Resources,2007,23(3):13-16. |
| |
| Authors: | LI Bing-feng CHEN Hua-rong WANG Xian-jin |
| |
| Affiliation: | 1. College of Resource and Environment Science, Wuhan University, Wuhan Hubei 430072, China; 2. 105 Geological Brigade of Guizhou Bureau of Geology and Mineral Exploration, Guiyang Guizhou 550018, China |
| |
| Abstract: | Taking duality thrice multinomial as mathematic model,the authors make a macro program in EXCEL to convert the coordinate data from one coordinate system to another. |
| |
| Keywords: | coordinate transformation least square method Excel macro program Gauss-Jordan elimination algorithm duality thrice multinomial program design |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
