Three-Dimensional Modeling Method in Zonal Stratum of Rail Transit Based on VBA Technology

Stratum is the carrier of rail transit, and the zonal three-dimensional stratum model is the study subject in tunnel and underground construction projects. A method using multi-source data to construct zonal three dimensional stratum model by VBA technique is proposed. The drilling data are taken as the hard data of stratum modeling. The geological section map is manual edited, and the extracted key points are taken as the semi hard data. Virtual drilling and zonal boundary limit points are taken as the soft data. The problem that the zonal stratum model result is inaccurate when we only use hard drill data is solved by use of Kriging interpolation. The practical modeling results of the proposed method are demonstrated through the Shanghai rail transit project.