摘要
采用VBA语言编程开发拱坝坝肩稳定分析程序.程序包括建立VBA与EXCEL通信并提取相关数据,VBA与CAD交互操作求最小稳定安全系数两部分.应用该系统时,用户只需要输入或选择程序默认参数数值,并在CAD地形图文件上选取若干实体,即可自动计算出对应高程的拱坝坝肩最小稳定安全系数.工程实例结果显示,程序运行安全可靠,符合设计标准.
In order to resolve the problems of heavy workload and repetitive calculation on stability analysis of abutment of arch dam, the VBA language was used to develop the software of stability analysis of abutment of arch dam. The program includes two sections, one section of which is to create communication between VBA and EXCEL then extract data, and the other section of which is to realize interactive operation between VBA and AutoCAD to induce least stability safety factor. A certain arch dam was chosen in CAD map as case study and the least stability safety factor can be yielded by calculation. The results show that this program runs safely and steadily which design criteria.
出处
《华侨大学学报(自然科学版)》
CAS
北大核心
2011年第5期495-497,共3页
Journal of Huaqiao University(Natural Science)