Dates in the Oil & Gas industry data can be a little tricky.
Especially when aggregating data, such as production volumes, to a daily level, and trying to connect multiple tables with date columns.
Some tables, such as tank levels or production volumes, could be based on a Gauge Date (aka Report Date) since the data is measured, aggregated, reported or “gauged” on that date (today), but in essence it is yesterday’s data, or to be more accurate, it is the data for the 24 hour period that began yesterday at the contract hour (e.g. 6am) and ended today at that same time, or the Production Date.
Other tables could have actual dates, such as sales tickets, run tickets, operation logs, etc.
Productioneer has an extensive paginated report library for our customers to utilize. We have everything from simple data exports to paginated reports that highlight variances and trends.
One of the reports we have had in our library for quite a while, is the Tank Stock report. The user selects a day and the report returns the tank stock and tank production for each tank in the organization for the selected day. It aggregates the stock and production at the tank, battery, field, and organization level and provides the tank strappings (feet and inches) for each tank. It is a standard and widely used report and I know it has not had any significant changes requested to it for at least 3 years.
Last week I wrote a blog post talking about the TX RRC publishing data to the public that previously was only available via a paid subscription.
After downloading the different data sets and examining the various types of data and formats, I decided to take a closer look at the data that might prove to be useful to us and to our Productioneer clients.
It is not uncommon for location and depth data, as well as other well-header and meta data to be incomplete or non-existent during a software migration, after all this data might not be considered crucial for the daily gauge sheets. Especially in the case of Excel gauge sheets, where additional columns are a waste of “prime real estate” and might be considered as cluttering that particular production report.
It would be nice if we have a quick way to pull the Lat Long data in bulk to speed up the on-boarding process.
The accounting team at TPIC was spending too much time doing manual and repetitive tasks to close out the month and generate regular reporting packets for management. Having worked with us in the past, they asked us to streamline the process.
We promised them we’d make the process as fast and as simple as possible, joking that it would be as easy as pressing a button, and now it is!
A process that used to take days now only takes a few minutes, and all the manual labor has been reduced to a single button press, literally.
Is Your Oilfield Management Platform Doing These 6 Things?
“Digitization is the new lubricant for the future of the oil and gas industry’s upstream sector.” –Strategy& report by PwC
In order to keep a competitive advantage in a cutthroat marketplace, world-class oil and gas operations are tapping into the latest technologies. Augmented reality (AR), machine learning, automation, and robotics are all part of ‘what’s next’ in oil and gas exploration, but the greatest investments in transformative technologies are taking shape around software designed to make exploration more agile and data more accessible than ever before. Continue reading “Is Your Oilfield Management Software Doing These 6 Things?”