Excel二次开发及其在地基处理设计中的应用  

Excel Programing for a Ground Improvement Design Application

作　　者：朱佳 ZHU Jia(Central South Survey&Design Institute Group Co.Ltd.,Wuhan 430000)

机构地区：[1]中南勘察设计院集团有限公司,武汉430000

出　　处：《土工基础》2021年第3期243-246,共4页Soil Engineering and Foundation

摘　　要：从地基处理设计中变形计算环节面临的现实问题出发,提出了利用Excel程序结合VBA解决问题的思路,介绍了Visual Basic编辑器的基本操作及常用方法函数;同时引入规范推荐的沉降计算公式,对公式中的关键参数编程计算的可行性进行了分析;在此基础上对沉降计算程序的编制过程进行了阐述,最后将其应用于实际工程,检验了该方法的可行性,对数据后处理也提出了一些建议。This paper presents a solution for estimating the foundation settlement in the ground improvement design by using the VBA programing function in the Excel spreadsheet.The basic functions and operations in the Visual Basic developer tab are introduced and the feasibility of calculation of the key parameters in the foundation settlement formula using VBA programing are discussed.The method for the foundation settlement estimation programing is also presented.In the end,the settlement estimation method is used in a practical ground improvement project.The data processing techniques are also provided.

关 键 词：EXCEL 二次开发 VBA编程 地基处理 变形计算 

分 类 号：TU472[建筑科学—结构工程] TP311[建筑科学—土工工程]