基于Excel全路线三维坐标计算与实现  

Realization and Calculation of 3D_Coordinate of Total Road Curve Based on Excel

作　　者：李文军 唐争气[2,3] 周青山[3] 

机构地区：[1]二十三冶集团矿业工程有限公司,长沙410003 [2]中南大学信息物理工程学院,长沙410083 [3]湖南城市学院,益阳413000

出　　处：《电脑编程技巧与维护》2011年第10期22-24,61,共4页Computer Programming Skills & Maintenance

摘　　要：利用Excel函数,实现了公路带断链处理的全路线中桩、边桩三维坐标的计算,在计算出各个待放样的点的三维坐标,为利用全站仪高精度、高效率的特点进行坐标放样提供了三维测设坐标,可大大地提高测设精度和效率。The use of Excel functions,to achieve the highway with a broken chain line in dealing with the whole pile,pile side of the calculation of three-dimensional coordinates,in the calculation of each point of setting out to be three-dimensional coordinates for the use of total station high precision and high efficiency features Setting out to provide a three-dimensional coordinate measurement based coordinates,survey and design can greatly improve the accuracy and efficiency.

关 键 词：EXCEL 中桩 边桩 断链 三维坐标 

分 类 号：U412[交通运输工程—道路与铁道工程] TP317.3[自动化与计算机技术—计算机软件与理论]