土石坝工程中渗流问题多软件融合计算方法及应用  

Discussion on Multi-software Fusion Calculation Method forSeepage Problems and its Application in Earth-rock Dam Engineering

作　　者：苗强 孙旭良 方业源 吕超 吴曼菲 MIAO Qiang;SUN Xu-liang;FANG Ye-yuan;LÜChao;WU Man-fei(Guangxi Guiyu Engineering Consulting Co.,LTD,Nanning 530023,Guangxi Zhuang Autonomous Region,China)

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

出　　处：《中国农村水利水电》2024年第4期239-242,249,共5页China Rural Water and Hydropower

摘　　要：渗流分析是土石坝设计、安全评价中的一项重要工作内容,目前国内外较成熟的专业软件如理正岩土软件渗流模块、AutoBank、GeoStudioSEEP/W模块、ANSYS软件等,侧重于渗流计算,对于多方案拟定、成果提取、报告编写及后期处理均需设计人员二次加工,导致整体工作效率不高。为解决该问题,笔者利用VBA语言结合API函数,将Excel、Word、AutoCAD和渗流软件进行融合,实现了土石坝渗流多方案自动分析计算、成果提取、报告编写于一体的功能,对土石坝多断面、多工况的渗流分析成果能够一键生成,降低了计算、制图与编写报告的门槛,实现了计算分析的标准化生产,极大地提高了效率和成果质量。Seepage analysis and calculation is an important work in the design and safety evaluation of earth-rock dam.At present,mature commercial software for seepage calculation includes the seepage module of Lizheng-rock software,AutoBank,GeoStudio\SEEP/W module,Ansys software,etc.These software focus on seepage analysis.For multiple schemes,results extraction,report preparation and post-process⁃ing,designers need to operate manually,and the overall work efficiency of the guidelines is low.To solve this problem,VBA language is combined with API function.Excel,Word,AutoCAD and Lizheng software are integrated to realize automatic analysis and calculation of seepage flow schemes of earth-rock dam,extraction of results and compilation of reports,and the slope stability analysis of earth-rock dam with multi-section and multi-working conditions can be generated with one click.It lowers the threshold of calculation,drawing and report writing,realizes the standardized production of calculation,and greatly improves the work efficiency and quality.

关 键 词：VBA语言 API函数 渗流分析 标准化生产 多软件融合 报告一键生成 

分 类 号：TV641[水利工程—水利水电工程] TU3[建筑科学—结构工程]