Abstract: 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.

Key words: Excel, Developer Tab, VBA Programing, Ground Improvement, Settlement Estimation