Excel宏在隧洞控制测量中的应用及测量控制措施  

Application of Excel Macro in Tunnel Control Measurement and Measurement Control Measures

作　　者：刘江 浦瑞 杨昊垂 杨树发 郭翔 LIU Jiang;PU Rui;YANG Haochui;YANG Shufa;GUO Xiang(POWERCHINA SINOHYDRO ENGINEERING BUREAU 14 CO.,LTD.,Kunming 650041,China)

机构地区：[1]中国水利水电第十四工程局有限公司,云南昆明650041

出　　处：《云南水力发电》2024年第9期81-86,共6页Yunnan Water Power

摘　　要：以云南省滇中引水工程昆明段施工1标隧洞洞内控制测量介绍支导线的测量方法、采用Excel宏编程计算支洞的应用,控制测量作为隧洞工程测量工作的核心内容,要求重点做好测量精度控制工作,从而为施工方案制定及施工过程控制等工作提供有效的数据支持。当前水工隧洞常见的控制测量以导线为主,导线平差软件也较多。通过新技术的合理应用,能够显著减少测量误差。在施工过程中不断完善优化外业测量方法及Excel宏程序。达到比较理想的效果从而提高工作效率。实践证明Excel宏编程解决控制平差应用在隧洞控制测量中能便捷高效、安全准确地解决控制测量。This paper introduces the measurement method of branch wires and the application of Excel macro programming to calculate the application of branch tunnels in the Kunming section of the Yunnan Central Water Diversion Project.Control measurement is the core content of tunnel engineering measurement work,and it is required to focus on measuring accuracy control,so as to provide effective data support for the formulation of construction plans and construction process control.The current common control measurement for hydraulic tunnels is mainly based on wires,and there are also many wire adjustment software.Through the rational application of new technologies,measurement errors can be significantly reduced.During the construction process,it is necessary to continuously improve and optimize the field measurement methods and Excel macro programs to achieve ideal results and improve work efficiency.Practice has proven that Excel macro programming can solve control adjustment problems conveniently,efficiently,safely,and accurately in tunnel control measurement.

关 键 词：隧洞控制测量 Excel宏程序 控制措施 工作效率 

分 类 号：TV221.1[水利工程—水工结构工程]