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

Visualized calculation of condition adjustment based on Excel

作　　者：李刚[1,2] 杨建华[3] 

机构地区：[1]天津城市建设学院土木工程系,天津300384 [2]天津市软土特性与工程环境重点实验室,天津300384 [3]长安大学地测学院,西安710054

出　　处：《测绘科学》2010年第6期242-243,224,共3页Science of Surveying and Mapping

基　　金：现代工程测量国家测绘局重点实验室项目资助(ES-SBSM-(07)-10)

摘　　要：在测量平差学习中,相当多的计算工作是矩阵转置、求逆、相乘等,人工解算繁复又容易出错。虽然有各种平差软件可以进行解算,但是一般过程均为隐含式的,不利于测量初学者掌握测量平差原理。本文利用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.

关 键 词：EXCEL 条件平差 可视化 数据处理 

分 类 号：P207[天文地球—测绘科学与技术]