Asset Management Database:
A Case Study in Custom Exploration and Production Software
This client is a foreign-owned producer of oil and gas located in Houston, Texas and based overseas. With more than 60 producing off-shore wells, the company is a mid-sized producer that is poised to grow rapidly.
The Problem
For several years, the company has used Excel spreadsheets and a succession of Access databases to track information about producing wells. The data that was tracked in this fashion includes: drilling logs, production numbers, well logs, and the results of production tests. They used this information to track and optimize well performance, to forecast sales for accounting and regulatory purposes, and to make marketing determinations.
As they grew from a small-to-medium company to one capable of operating many wells over a geographically diverse region, management realized that they needed a way to report gross and net production data, and reconcile these numbers with the figures they received from oil and gas buyers onshore.
The Custom Software Solution
Entrance Software built on the client's existing Asset Management Database to create a production reporting system for engineers and management. Entrance created reports to reconcile engineers’ forecasts with actual production, and to compute net production from gross volume and well test results.
Over time, modules were added to import sales volumes from the accounting department and non-gas liquid data from production. Together, these modules allow management to reconcile internal production numbers with sales volumes.
In addition to pure volumetric data, Asset Management Database tracks miscellaneous information about the geography and operations of the company's producing assets. Well bore schematics and well logs can be stored online. Asset Management Database encodes the geographic structure of the Gulf Coast, allowing engineers and management to produce ad-hoc reports based on the standard Area-Block-Lease-Well-Completion nomenclature used in this region. A parallel nomenclature is used to model the Field-Prospect-Platform structure that exists in their operations.
Integration with Excalibur, SAP and OFM allows the production engineers to create variance reports comparing reservoir forecasts, production estimate, production theoreticals, reported volumes (OGOR) and sales volumes.
