基於VBA技術的軌道交通帶狀地層三維建模方法
Three-Dimensional Modeling Method in Zonal Stratum of Rail Transit Based on VBA Technology
-
摘要: 地層是軌道交通的載體, 帶狀三維地層模型是隧道工程及地下建築工程研究的對象.利用Visual Basic for Applications(VBA)技術, 提出了一種使用多源數據構建帶狀三維地層模型的方法.以鉆孔資料作為地層建模的"硬數據", 將地質剖面圖進行手工編輯修改並提取相應關鍵點作為"半硬數據", 將虛擬鉆孔及帶狀邊界限製點作為"軟數據".結合Kriging插值, 較好地解決了以往單純依靠鉆孔"硬數據"建模導致的帶狀地層模型結果不精確等問題.結合上海某軌道交通工程實例展示了該方法的實際建模效果.Abstract: 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.