高级检索
董文澎, 许杰, 王长虹. 基于VBA技术的轨道交通带状地层三维建模方法[J]. 应用技术学报, 2017, 17(1): 76-79. DOI: 10.3969/j.issn.2096-3424.2017.01.016
引用本文: 董文澎, 许杰, 王长虹. 基于VBA技术的轨道交通带状地层三维建模方法[J]. 应用技术学报, 2017, 17(1): 76-79. DOI: 10.3969/j.issn.2096-3424.2017.01.016
DONG Wenpeng, XU Jie, WANGC hanghong. Three-Dimensional Modeling Method in Zonal Stratum of Rail Transit Based on VBA Technology[J]. Journal of Technology, 2017, 17(1): 76-79. DOI: 10.3969/j.issn.2096-3424.2017.01.016
Citation: DONG Wenpeng, XU Jie, WANGC hanghong. Three-Dimensional Modeling Method in Zonal Stratum of Rail Transit Based on VBA Technology[J]. Journal of Technology, 2017, 17(1): 76-79. DOI: 10.3969/j.issn.2096-3424.2017.01.016

基于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.

     

/

返回文章
返回