Excel VBA在导线近似平差计算中的应用  

Application of Excel VBA in Approximate Adjustment of Traverse

作　　者：刘科[1,2] 廖中平[1,2] 余泽彬[2] 

机构地区：[1]道路灾变防治及交通安全教育部工程研究中心,湖南长沙410004 [2]长沙理工大学交通运输工程学院,湖南长沙410004

出　　处：《地矿测绘》2015年第2期31-34,共4页Surveying and Mapping of Geology and Mineral Resources

基　　金：道路灾变防治及交通安全教育部工程研究中心开发基金(kfj110307)

摘　　要：传统导线平差计算过程繁琐,且易受人为因素影响。利用Excel VBA编程进行导线自动平差计算,平差结果包括自动生成的CASS展点文件和平差报告。当观测数据存在粗差,可进行一个转角或一条导线边粗差的自动查找。以闭合导线平差计算为例,本程序可快速检查数据且计算出未知点坐标。The process of traditional adjustment calculation of traverse survey is not only tedious, but also easy to be influenced by human factors. We can utilize the development tools VBA in the Excel to program to finish the process auto- matically. The adjustment results include the file of points for CASS and the report. When the observed data includes the gross errors, the program can be applied to find out the mistake on the condition that only one angle or side contains gross error. By taking the adjustment calculation of closed traverse for an example, we can rapidly check the data and can cal- culate the coordinate of unknown points by using the program.

关 键 词：导线平差 EXCEL VBA 数据检查 CASS 

分 类 号：P221.4[天文地球—大地测量学与测量工程]