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

Application of Excel function in data processing of reservoir research

在油藏研究工作中,经常遇到大量数据处理的问题。以井斜校直和生产数据统计为例,提出使用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.