基于Excel的单一导线智能平差程序在矿山测量中的应用  

The application of single traverse intelligent adjustment program based on Excel in Mine Surveying

作　　者：盖侨侨 朱金秀[1] Ge Qieo-qiao ZHU Jin-xiu(School of Surveying and mapping, Anhui University Of Science And Technology,Huainai 232001,China)

机构地区：[1]安徽理工大学测绘学院,安徽淮南232001

出　　处：《世界有色金属》2017年第6期287-288,共2页World Nonferrous Metals

摘　　要：在矿区数字测图实习过程中遇到多种单一导线的平差计算,传统的手工计算易受人为因素影响。若借助高级语言如Fortran或Basic编程计算,虽然计算比手算快,但出现错误比较难检查。利用Excel良好的人机交互对话界面和内嵌VBA设计出一种与传统导线简易平差一致的智能单导线平差程序,并验证了程序的易用性与可靠性。In the process of Digital Mapping Practice in mining area, a variety of single conductor adjustment calculation is encountered, the traditional manual calculation is easy to be affected by human factors. If the use of high-level language such as Fortran or Basic programming, although the calculation faster than the hand, but the error is more difficult to check. An intelligent single wire adjustment program, which is consistent with the traditional wire simple adjustment, is designed by using Excel＇s good man-machine conversation interface and embedded VBA.

关 键 词：单一导线 简易平差 程序 

分 类 号：TP391.13[自动化与计算机技术—计算机应用技术]