skip to main content
OSTI.GOV title logo U.S. Department of Energy
Office of Scientific and Technical Information

Title: 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, Vol. 7, Issue 5; Other Information: DN: Paper presented at the 1994 SPE European Petroleum Computer Conference, Aberdeen, Scotland, March 15--17; PBD: Oct 1995
Country of Publication:
United States
Language:
English