摘要
为了简化GPS基线解算后的数据统计工作,方便超限数据查找及数据分析,运用EXCEL与WORD交互编程思想,利用EXCEL软件中内置的Visual Basic for Applications(VBA)语言开发了一套平差数据后处理程序。该程序可以按照规范要求统计分析基线解算和平差后各精度指标的超限情况,并对超限数据进行标注和列表显示,完成相应指标曲线图的绘制;可根据铁路控制网复测要求进行复测分析,完成复测指标及内插更新点的统计,最终将统计结果输出到WORD规范表格中,方便结果分析和报告编写,实现了EXCEL与WORD的数据交互。该程序能够快速进行平差数据的后处理,有利于将来测量自动化办公程序的进一步实现。实践证明,该程序兼容性强,自动化程度高,适用性强,操作方便,能够满足数据统计分析的要求,可提高精度指标的统计效率和规范性。
In order to simplify the data statistical analysis after GPS baseline processing and find out-of-limit data,a set of data post-processing programs was developed by the VBA of EXCEL software using EXCEL and WORD interactive programming ideas.The program can statistically analyze the over-limit condition of each precision index after the GPS data constraint adjustment according to the specification requirements,display the out-of-limit data with labeling and list,and complete the curve drawing of corresponding index.According to the re-testing requirements of the railway control network,the program can also perform retesting analysis,complete the statistics of retesting index and interpolation update point,and finally output the statistical result of WORD to facilitate the report writing,realizing the data interaction of EXCEL and WORD.This program can quickly perform post-processing of adjustment data,which is conducive to the further realization of the office automation program for measurement in the future.Practice has proved that the program has strong compatibility,high degree of automation,strong applicability and convenient operation,which can meet the statistical analysis requirements of GPS result data,and improve the statistical efficiency and standardization of precision index.
作者
方齐
Fang Qi(China Railway Design Corporation,Tianjin 300308,China)
出处
《铁道勘察》
2020年第2期5-9,共5页
Railway Investigation and Surveying
