Excel函数在油藏研究数据处理中的应用  

Application of Excel function in data processing of reservoir research

作　　者：周继龙 李蕾[1,2] 张金通 Zhou Jilong;Li Lei;Zhang Jingtong(SINOPEC,Petroleum Exploration and Development Research Institute,Henan Oilfifield Branch Nanyang 473132;Henan EOR Key Laboratory,Nanyang 473132)

机构地区：[1]中国石油化工股份有限公司河南油田分公司勘探开发研究院,河南南阳473132 [2]河南省提高石油采收率重点实验室,河南南阳473132

出　　处：《石化技术》2021年第2期94-95,共2页Petrochemical Industry Technology

摘　　要：在油藏研究工作中,经常遇到大量数据处理的问题。以井斜校直和生产数据统计为例,提出使用Excel函数编写相应公式,在公式中灵活使用单元格引用方式,通过合理安排输入输出单元格的位置以及充分发挥Excel单元格日期序列自动填充的特性,实现对大量数据快速有效地处理,提高工作效率,具有较大的推广应用价值。In the reservoir research,problems of a large amount of data processing often occur.Taking correction of well devitaiton and production data statistics as an example,Excel functions to write corresponding formula are recommended to implement a large amount of data processing quickly and efficiently with flexible use of cell references,as well as the reasonable arrangement of the position of the input and output cells with the full play to the automatic filling characteristics of Excel date series.The method can improve the work efficiency and has great promotion value.

关 键 词：油藏研究 EXCEL函数 井斜校直 数据处理 

分 类 号：TE319[石油与天然气工程—油气田开发工程] TP391.13[自动化与计算机技术—计算机应用技术]