基于VBA语言开发的隧洞围岩类别与稳定性分析软件  

Software developed based on VBA language for analysis of tunnel surrounding rock class and stability

作　　者：吕超 孙旭良 吴曼菲 苗强 LV Chao;SUN Xu-liang;WU Man-fei;MIAO Qiang(Guangxi Guiyu Engineering Consultant Co.,Ltd.,Nanning 530023,China)

机构地区：[1]广西桂禹工程咨询有限公司,南宁530023

出　　处：《广西水利水电》2023年第3期83-86,共4页Guangxi Water Resources & Hydropower Engineering

摘　　要：确定隧洞围岩类别,评价隧洞围岩稳定性,并提出支护建议,是水利水电工程地质勘察和施工地质中经常遇到的工作。目前该工作由地质技术人员对应规范(GB50487-2008)进行人工计算。当隧洞较长,数据较多时,人工计算工作繁琐,且容易出错,影响工作效率和地质判别质量。作者利用VBA语言在Excel中编写隧洞围岩类别与稳定性自动分析软件,通过5种地质要素采集,自动计算围岩总评分,自动判别围岩类别,自动分析围岩稳定性,并相应给出隧洞围岩支护建议,可提高工作效率和成果质量。The geological survey and construction geology of water conservancy or hydropower project often requires class determination and stability evaluation of tunnel surrounding rock,as well as supporting proposals.Now geolog⁃ical technicians conduct these works by manual calculation according to the specification GB50487-2008.When the tunnel is long and has a lot of data,manual calculation is tedious and prone to errors,affecting work efficiency and geological judgement quality.The authors write software with VBA language and Excel for automatic analysis of the class and stability of tunnel surrounding rock.Based on collection of five kinds of geological factors,the total score of surrounding rock is able to be calculated automatically,the class of surrounding rock is judged automatical⁃ly,the stability of surrounding rock is analyzed automatically,and corresponding supporting proposals are put for⁃ward,which is able to improve the work efficiency and quality.

关 键 词：隧洞围岩类别 围岩稳定性 地质要素 围岩总评分 VBA语言 

分 类 号：TP391.7[自动化与计算机技术—计算机应用技术]