Advancing Reservoir Performance Optimization through UserFriendly Excel VBA Software Development

Abstract

This study addresses the pressing demand for streamlined field performance analysis within oil and natural gas development, which currently necessitates substantial expertise and time investment. The principal aim involves developing a user-friendly software tool dedicated to optimizing reservoir rendition. Leveraging the Havlena and Odeh material balance straight line equation form, this tool integrates a zero-dimensional reservoir model with Decline Curve Analysis. The implementation of this user-friendly software enables achievable material balance optimization by aligning cumulative produced fluid with historical production data, akin to the widely acknowledged concept of history matching in material balance analysis. This accomplishment not only facilitates further endeavors like pressure simulation and forecasting but also augments the comprehension of reservoir dynamics. The analysis incorporated three datasets: one modeled from L.P. Dake's textbook and two drawn from real-life reservoirs in the Niger Delta. Assessment of estimated water influx and cumulative oil production indicated minimal discrepancies between Np Real and Np model for these reservoirs. Consequently, material balance history matching for these reservoirs seems feasible. Achieving reservoir rendition optimization involved a Microsoft Excel VBA code consisting of two hundred and thirty-five (235) lines, meticulously designed to replicate MBAL functionality. The software demonstrated congruent outcomes with MBAL, affirming its reliability for history matching and enhancing reservoir performance. We strongly advocate the utilization of this software for optimizing reservoir performance across diverse global regions. Its capacity to streamline field analysis could significantly benefit the oil and natural gas industry.