Calculation of Irregular Polygon Area of oil-Gas Reservoir Using Microsoft Excel Software

Abstract

Abstract: Traditional method for calculation of irregular polygon area of oil-gas reservoir is very complicated and makes mistakes easily because of plenty of work and low accuracy. This article introduces the principle of calculating acreage of irregular polygon, then analyzes the algorithm of irregular polygon area acquisition using macro function in Microsoft Excel, and finally lists some key step codes in the program. The author uses the program to calculate acreage of oil/gas-bearing area, greatly improving working efficiency.

Key words: area acquisition, algorithm, macro

CLC Number:

TE112.12

WEI Zhong-yuan, GUO Zhen-hua, WANG Hai-ying. Calculation of Irregular Polygon Area of oil-Gas Reservoir Using Microsoft Excel Software[J]. Xinjiang Petroleum Geology, 2008, 29(2): 240-243.

[1]	LEI Zexuan, XIN Xiankang, YU Gaoming, WANG Li. Reservoir Production Performance Optimization Algorithm Based on Numerical Simulation [J]. Xinjiang Petroleum Geology, 2022, 43(5): 612-616.
[2]	GAO Qiuju, ZHANG Yunyin, QU Zhipeng, XU Yankai, WANG Zongjia, WANG Qianjun. Decomposition and Application of Constrained Sparse Inversion Spectrum Based on ISTA Algorithm [J]. Xinjiang Petroleum Geology, 2020, 41(4): 471-476.
[3]	ZHANG Yishan, XU Huaibao, QI Hongyan, XIE Tianshou, YANG Yuanfeng, YANG Bangwei. Using Multiple Seismic Data Volume to Identify Oil-Bearing Channel Sandbodies Based on XGBoost Algorithm [J]. Xinjiang Petroleum Geology, 2020, 41(4): 477-482.
[4]	DOU Yan1GAO Gang1LIANG Lin2XIE Xiaoqing3PENG Rui4. Prediction of SWave Velocity Based on XuWhite Model [J]. , 2016, 37(1): 1-1.
[5]	HOU Dali, LUO Pingya, SUN Lei, TANG Yong, SUN Yang, PAN Yi. An Improved Minimum Miscibility Pressure Prediction Model for Hydrocarbon GasOil Flooding System [J]. , 2013, 34(6): 1-1.
[6]	HE Chao-qun, WANG Yan-chun, ZHANG Pin. Application of PSO-GA Hybrid Algorithm to Residual Statics Correction [J]. Xinjiang Petroleum Geology, 2011, 32(6): 656-659.
[7]	WU Ming-lu, YAO Jun, JIA Wei-xia, ZHANG Kai. Streamline Numerical Well-Testing Interpretation Model for Horizontal Wells and Its Application [J]. Xinjiang Petroleum Geology, 2010, 31(4): 408-412.
[8]	LI Xiao-ming, ZHANG Jian, ZENG Xian-bing, LIU Bo. Optimum Programming and Decision-Making for Production Allocation in Clustered Gas Fields in Western Sichuan Province [J]. Xinjiang Petroleum Geology, 2008, 29(3): 358-360.
[9]	WANG Wei-hong, CUI Bao-wen. Multiple Attenuation by Hyperbolic Radon Transform [J]. Xinjiang Petroleum Geology, 2007, 28(3): 363-365.
[10]	CHENG Hong-liang, FAN Xiao-min, ZHANG Li-hua. Application of Homotopy BP Algorithm to Prediction of Reservoir Parammeters [J]. Xinjiang Petroleum Geology, 2006, 27(6): 754-756.
[11]	ZHOU Yan-ru. Mechanisms of Micro Hydrocarbon Gener ation and Macro Hydrocarbon Accumulation from Organic Matter [J]. Xinjiang Petroleum Geology, 2006, 27(2): 135-141.
[12]	WANG Guo-chang, LV Xue-ju. Application of Gener alized Regr ession Neur al Network and Genetic Algor ithm to Production Decline Analaysis [J]. Xinjiang Petroleum Geology, 2006, 27(1): 90-93.
[13]	LI Xiao-ming, ZHANG Lie-hui, ZHOU Hong. Application of Genetic Algorithm to Optimized Oilfield Development [J]. Xinjiang Petroleum Geology, 2005, 26(1): 80-82.
[14]	LI Jing, CHEN Yu-ming, WANG Zhen-guo. Improved Genetic Algorithm for Wave Impedance Inversion [J]. Xinjiang Petroleum Geology, 2004, 25(2): 150-152.
[15]	LI Jing, CHEN Yu-ming, WANG Zhen-guo. Improved Genetic Algorithm for Wave Impedance Inversion [J]. Xinjiang Petroleum Geology, 2004, 25(1): 150-152.

Calculation of Irregular Polygon Area of oil-Gas Reservoir Using Microsoft Excel Software

PDF

Knowledge

Abstract

Cite this article

share this article

References

Related Articles 15

Recommended Articles

Metrics

Comments