| Excel VBA批量处理在录井砂地比统计中的应用 |
| |
| 引用本文： | 郝才超,薛霆虓. Excel VBA批量处理在录井砂地比统计中的应用[J]. 工程地球物理学报, 2012, 0(2): 145-150 |
| |
| 作者姓名： | 郝才超 薛霆虓 |
| |
| 作者单位： | [1]桂林理工大学地球科学学院,广西桂林541004 [2]桂林理工大学广西地质工程中心区重点实验室,广西桂林541004 |
| |
| 基金项目： | 桂林理工大学科研启动费（编号：002401003302）资助 |
| |
| 摘 要： | VBA批量处理程序能够自动操作Excel软件,轻松统计大量分散地质信息,可以避免枯燥重复操作,大幅提高工作效率。本文以统计录井砂地比为例,阐述了统计方法与关键步骤,并且给出了完整的VBA批量处理程序,可以同时统计出砂地比、泥地比、砂岩厚度、泥岩厚度和地层厚度等储层参数。此程序引入数组变量提高了运行速度,可以直接应用于实际工作提高效率,也可以加以修改扩展应用。
|
| 关 键 词： | Excel VBA 砂地比 录井 |
Application of Excel VBA Batch Processing Method to Sand Content Statistics from Mud Logging Data |
| |
| Hao Caichao,Xue Tingxiao. Application of Excel VBA Batch Processing Method to Sand Content Statistics from Mud Logging Data[J]. Chinese Journal of Engineering Geophysics, 2012, 0(2): 145-150 |
| |
| Authors: | Hao Caichao Xue Tingxiao |
| |
| Affiliation: | 1.Faculty of Earth Sciences,Guilin University of Technology,Guilin 541004,China; 2.Key Laboratory of Geological Engineering Centre of Guangxi Province, Guilin University of Technology,Guilin 541004,China) |
| |
| Abstract: | 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. |
| |
| Keywords: | Excel VBA sand content mud logging |
| 本文献已被 CNKI 维普 等数据库收录！ |
|
