Excel VBA批量处理在录井砂地比统计中的应用

Application of Excel VBA Batch Processing Method to Sand Content Statistics from Mud Logging Data

VBA批量处理程序能够自动操作Excel软件,轻松统计大量分散地质信息,可以避免枯燥重复操作,大幅提高工作效率。本文以统计录井砂地比为例,阐述了统计方法与关键步骤,并且给出了完整的VBA批量处理程序,可以同时统计出砂地比、泥地比、砂岩厚度、泥岩厚度和地层厚度等储层参数。此程序引入数组变量提高了运行速度,可以直接应用于实际工作提高效率,也可以加以修改扩展应用。

Much dispersed geological statistics information will be done by VBA batch processing program easily,which can automatically operate excel software,so it will improve the work efficiency greatly and avoid the boring and repetitive operation.Statistics method and key steps are described in this paper taking sand content statistics from mud logging data for Example.And the VBA batch processing program is completely provided.The reservoir parameters including sand content,mud content,sandstone thickness,mudstone thickness and formation thickness are calculated out.The program in which array variable is used to increase the running speed can be applied to the actual work directly to improve efficiency.