如何用EXCEL进行附和导线近似平差的计算

How to calculate approximate adjustment of conducting wire with EXCEL

针对传统手工计算在煤矿测量工作中表现出的低效率等现象,从原理方法及问题处理方面阐述了如何用EXCEL进行附和导线近似平差的计算,介于在EXCEL界面上可清晰、直观地显示计算的全过程,得出用EXCEL代替手工计算的结论。

In light of low efficiency of traditional manual calculation in coal mine measurement, starting from aspects of principle, method and problem solving, the paper describes how to calculate approximate adjustment of conducting wire with EXCEL. Owning to clear and visible cal- culation process of EXCEL interface, the paper concludes that EXCEL can replace manual calculation.