摘要
为了满足石油勘探开发、沉积相分析、油藏描述等研究过程中,对地质分层数据库中砂岩厚度、砂岩顶底数据、地层厚度进行统计的需要很迫切。笔者利用EXCEL中VBA宏工具,实现了对地质分层数据表中砂岩厚度、砂岩顶底数据、地层厚度的自动提取,对不同研究的分层数据表进行批量处理表明,该程序实现了数据的批处理,可极大地减轻手工处理数据的工作量,为油田数据处理提供了一种实用方法。
In order to meet the need of oil exploration and development, analysis of sedimentary facies and reservoir de-scription research, statistics of the thickness of sandstone, top and bottom data and the layer thickness in the geo-logical layer database is needed urgently. Automatic extraction of the data is realized by using EXCEL VBA macro tools. Researches show that data batch processing is realized, which can greatly reduce the workload of manual data processing. It provides a practical method for data processing in the oilfield.
出处
《石油工业计算机应用》
2015年第4期32-34,3,共3页
Computer Applications Of Petroleum
基金
中石油股份公司重大科技专项项目:"低渗透低丰度砂岩气藏水平井布井和改造工艺技术研究"(2011ZX05015-001)资助
关键词
砂岩顶底
砂岩厚度
分层
VBA宏
the top and bottom of sandstone
thickness of the sandstone
layering
VBA macros
