化曲为直,借助Excel软件简捷准确分析油田产量递减趋势

Analyzing the Relationship between Time and Annual Production by Transiting the Non-linear Curve into a Linear Curve

刘其先 曲秀娟 朱德燕

LIU Qi-xian QU Xiu-juan ZHU De-yan

胜利油田有限公司 地质科学研究院, 山东 东营 257015; 胜利油田有限公司 胜利采油厂, 山东 东营 257051

Geological Science Research Institute of Shengli Oil Field Limited Company, Dongying 257015, China; Shengli Production Factory of Shengli Oil Field Limited Company, Dongying 257015, China

引入化曲为直的思想,以胜坨油田坨11断块为例,对其本为曲线形式的年产递减趋势转化为直线形式,应用Excel软件中的直线回归功能进行了回归分析。这为一般研究人员进行产量预测提供了一种较为快捷的方法。

This paper introduces a way to transit the non-linear curve into a linear curve and use the Excel software to regress and analyse the relationship between time and annual production. With the example of TUO 11 fault block of SHENGTUO oil field,this paper provides a convenient way to predict the future production.