基于Excel的条件平差解算

在测量平差计算中,相当多的计算工作是矩阵转置、求逆、相乘等,人工解算容易出错,且现有各种平差软件一般均为过程隐含式的,不利于测量初学者掌握测量平差原理。探讨利用电子表格软件(Excel2003)的内置函数中的矩阵运算功能处理测量平差计算的方法,并以水准网条件平差的解算为例,介绍其使用方法及使用技巧,得到一些有益的结论。

The Condition Adjustment Calculation Based on Excel

In the survey adjustment computation,the quite many computation work is the matrix transpose,strives for,the multiplication counter and so on,artificial resolving easy to make a mistake,also the existing each kind of adjustment software for the process concealment like,does not favor generally surveys the beginner to grasp the survey adjustment principle.This article discusses the use electronic forms software(Excel 2003)in sets at in the function matrix operation function processing survey adjustment computation method,and take leveling network condition adjustment resolving as the example,introduced its application method and the use skill,obtain some beneficial conclusions.