Excel环境下控制测量导线坐标计算

以闭合导线为例，将Excel的表格特性和测量计算传统的列表格式结合起来进行导线网的平差和坐标计算，有效地克服了使用VC或VB语言后台编程计算且开发周期长的缺陷。充分地利用Excel强大的功能和良好的人机交互对话界面、方便地进行数据处理和函数运算、迅速地制作复杂图表的特性，将整个计算过程展示在前台，易操作、易修改、透明度高，是控制测量计算的有效方法之一。

Polygon Coordinate Calculation of Control Measurement Based on Excel

With the closed polygon as an example,it is necessary to combine Excel form features with traditional tabling form of measurement calculation in carrying out the computation of the adjustment and coordinate of polygon net,which can effectively overcome the weak points of background programming computation by using VC or VB language and long cycle of exploration. Accordingly,Excel strong functions and fine features including man-machine inter-dialogue interface, convenient data processing and function operation and quick preparation of sophisticated diagrams and forms are used to the fullest extent to exhibit the complete computation process to the foreground,being easy to operate,and to modify and high in transparency. Therefore,it is one of effective methods to control over measurement computation.