Skip to main content
U.S. Department of Energy
Office of Scientific and Technical Information

Integration of production analyst and Microsoft Excel`s Solver for production forecasts and optimization

Journal Article · · SPE Computer Applications
DOI:https://doi.org/10.2118/27566-PA· OSTI ID:116153

Mobil North Sea Ltd. has used OGCI`s Production Analyst (PA) for several years for reservoir management and surveillance. Once most professionals had been migrated to Microsoft Windows and Excel, the authors began to integrate the spread sheet with PA for specialized applications. Production optimization and forecasts are two applications of significant economic benefit. They developed an Excel spreadsheet and macro that use the Solver and production-decline data from PA for predicting the maximum platform oil production while honoring gas-compression and water-handling constraints. By use of PA, a database of decline-curve information is generated by well for the relationships of oil rate, GOR, and water cut to cumulative oil. Other input required for the forecast are the combination of months and years to forecast, gas compression limit, water-handling limit, and platform efficiency at each timestep. This model adds value to their operations by leveraging existing products and data to predict facility-constrained production schedules. A custom program with this type of functionality would certainly be more expensive than the combined costs of PA and Excel. The integration of these tools provides cost-effective solutions to the specialized problems experienced in oil and gas exploitation.

Sponsoring Organization:
USDOE
OSTI ID:
116153
Journal Information:
SPE Computer Applications, Journal Name: SPE Computer Applications Journal Issue: 5 Vol. 7; ISSN 1064-9778; ISSN SCAPEP
Country of Publication:
United States
Language:
English

Similar Records

Matrix-Based Process Modeling in Microsoft Excel
Technical Report · Mon Jan 18 23:00:00 EST 2021 · OSTI ID:1762712

Optimize production through balanced reservoir depletion
Journal Article · Mon May 01 00:00:00 EDT 1989 · Petroleum Engineer International; (USA) · OSTI ID:6890307

Framework for estimating future lower-48 natural gas processing costs. Topical report, January-April 1994
Technical Report · Thu Mar 31 23:00:00 EST 1994 · OSTI ID:6942590