| Excel在GPS基线解算精度统计中的应用 |
| |
| 引用本文： | 张宏.Excel在GPS基线解算精度统计中的应用[J].测绘与空间地理信息,2012(6):140-143. |
| |
| 作者姓名： | 张宏 |
| |
| 作者单位： | 湖北省国土测绘院 |
| |
| 摘 要： | GPS基线解算就是利用GPS观测值,通过数据处理,得到测站间的基线向量值。基线解算是GPS网平差的基础和关键,基线解算精度直接关系着GPS网的精度,所以,基线解算精度统计是一项很有必要的工作。Excel中大量的公式函数可以应用选择,主要用来进行有繁重计算任务的预算、财务、数据处理等工作,借助于Excel的数据筛选和条件格式功能,可以方便、高效、准确无误地进行GPS精度统计,这在GPS广泛大量使用的今天,有一定的现实意义。
|
| 关 键 词： | Excel 基线解算 数据筛选和条件格式 |
The Application of Excel in the Precision of GPS Baseline Solution |
| |
| ZHANG Hong.The Application of Excel in the Precision of GPS Baseline Solution[J].Geomatics & Spatial Information Technology,2012(6):140-143. |
| |
| Authors: | ZHANG Hong |
| |
| Institution: | ZHANG Hong (Land Surveying and Mapping Institute of Hubei Province,Wuhan 430010,China) |
| |
| Abstract: | GPS baseline solution refers to the use of GPS observations together with data processing to obtain the vector value of stations.Baseline GPS network adjustment is considered the basis directly related to the accuracy of GPS network,so the statistics of baseline solution accuracy is necessary.A larger number of Excel formula functions can be applied to the heavy computing tasks,such as the budget,finance and data processing and its data screening and conditional formatting will help to facilitate the accurate and efficient statistics,which is of practical significance. |
| |
| Keywords: | Excel GPS baseline solution data filtering and conditional formatting |
| 本文献已被 CNKI 等数据库收录！ |
|
