Excel环境下的条件平差可视化解算

在测量平差学习中,相当多的计算工作是矩阵转置、求逆、相乘等,人工解算繁复又容易出错。虽然有各种平差软件可以进行解算,但是一般过程均为隐含式的,不利于测量初学者掌握测量平差原理。本文利用Excel内置函数中的矩阵运算功能处理测量平差计算,并以高程控制网条件平差的解算为例,介绍其使用方法及技巧;不仅增加了测量平差原理可视化,而且使得平差计算更加简便和快捷,利于学生理解和吸收。

Visualized calculation of condition adjustment based on Excel

The study of survey adjustment involved a large quantity of such computational work as matrix transposition,inversion,and multiplication,etc.which may well be prone for errors.Though various adjustment software can be applied in calculation,mostly their process is implicit which potentially gets the principle of survey adjustment less likely to be accessible to the novice learners.This paper introduced the application and the corresponding strategies of matrix calculation function in Excel inline parameter to handle condition adjustment computation by exemplifying the calculation of elevation control network condition adjustment which visualized the principle of survey adjustment and accordingly simplified its learning process.