Creating Vintage Columns for Type Curve Groups

Periodically at the office we have bouts where we compete to see who can run through our homebrew decline curve analysis challenge the fastest. Today’s challenge was that we needed to create type curve groups based on vintage classes.

To begin with, we needed to take the [Spud Date] and then create binned groups. The custom expression that you want to use is this:

The idea here is that first, we extract the year from the DateTime object that is the Spud Date column. Next, we use the BinByEvenIntervals calculated expression to take that pseudo column and break it into five even interval, in this case parameterized by 5.

Now we can color by the vintage classes and see the results:

Using this binned column, we can set the DCA Wrangler to use this column as a Type Curve Group. When the DCA Wrangler is in the Type Curve mode, you can create individual type curves for each vintage:

Using the legend, we can isolate a single vintage:

Try it for yourself! Let us know if you have similar techniques using the tool so we can showcase your work.

Grooming your Data for the DCA Wrangler

One of the first skills that you develop in Spotfire is the ability to select a freeform area of markers in a visualization. You may remember that this was accomplished by holding down and left click and drag to “lasso” markers. In this article, we’re going to use this technique to rapid wrangle the data we need, as a stand-in

Part 1: Well Selection

In the CI Bandit workflow, this is key for select wells to decline, more so because wells of interest are never in a straight line on a Map chart visualization. Take this field map, for example, that for simplicity we have created using a scatter plot visualization:

Our operators here are all over the place and to make type curves we’ll need a special selection method to grab them. In comes the lasso:

We’ll use this again to clean up our production.

Part 2: Production

The real magic comes from being able to clean up points that adversely affect our type curves. Take the decline of the well below:

We’ve got these drops that we want to remove from this well (and probably many more). One quick way to do this would be to line all the wells up horizontally and filter out these markers.

Check to make sure that your DCA Wrangler is attached to a Filtering Scheme (it’s in your Properties) and rerun the decline.

Finished! Cycle through all the wells and see the corrected declines.


Auto Detect Flow Regimes in Spotfire: Supercharge your Rate Transient Analysis Workflow Part 1

We are starting a new blog post series, on Rate Transient Analysis (RTA) in Spotfire. In this first part we will discuss a mathematical framework to automate the flow regime detection in RTA. Unlike traditional reservoir engineering methods such as Decline Curve Analysis (DCA), RTA incorporates both fluid rates and flowing pressures, where the end goal is to understand the fluid flow in the reservoir. The industry has been doing this with Pressure Transient Analysis (PTA) for many years and RTA is built on the same theory, we are just using the data in a different way. I will refer you to the excellent presentation by Blasingame as a refresher on the fundamental theory for RTA. Following figure represents the important flow regimes in a Multi Fractured Horizontal Wells (MFHW) in conventional/unconventional reservoirs:

Blasingame (2015). Image Source:

Continue reading

Nitin is a Data Scientist at working passionately towards helping companies realize maximum potential of their data. He has experience with machine learning problems in clustering, classification and regression applying ensemble and Bayesian approaches with toolsets from R, Python and Spotfire