基于VBA的一井定向数据自动处理Excel程序实现
Implementation of Excel program for automatic processing of one well orientation data based on VBA
高鹏1
作者信息
- 1. 北京城建勘测设计研究院有限责任公司,北京 100101
- 折叠
摘要
城市轨道交通建设过程中,为保证不同开挖面准确贯通,一般采用一井定向联系三角形测量方法,以确保地面与地下测量坐标系的统一.针对一井定向联系三角形计算步骤烦琐的问题,本文提出一种基于VBA的一井定向数据自动处理Excel程序,并对一井定向联系三角形的计算原理、图形形式、程序设计思路与方法等进行了详细阐述.该程序可减少人工引起的计算错误,提高工作效率,为一井定向联系三角形计算提供思路和技术支持.
Abstract
In the process of urban rail transit construction,the method of one-well directional contact triangle measurement is generally used to the coordinate system of ground and underground in order to ensure the accurate connection of different excavation faces.An Excel program for automatically process-ing the data of one well based on VBA is proposed in this paper to solve the complex calculation steps of the directional contact triangle of one well,and the calculation principles,graphic form of the contact triangle,program design are described in details.The example shows that the program can be used to reduce the calculation errors caused by manual works,improve the efficiency,and provide an idea and technical support for the calculation of one well directional contact triangle.
关键词
联系测量/一井定向/联系三角形/VBAKey words
contact measurement/one well orientation/contact triangle method/VBA引用本文复制引用
出版年
2024
NETL
NSTL
维普
万方数据