PDP Reconciliation using Axis.Columns in Spotfire

Comparing models out of the DCA Wrangler simple task if you are familiar with Axis.Columns feature in Spotfire. In this example, we’re going to take the cross table and use it to look for differences across columns.

Consider this scenario, we are creating declines of Teapot dome data in 2016 and then comparing them to 2017. We are specifically looking at the remaining reserves to see how much the reserves have changed based upon the new production data. Our resultant Autocast DCA data might look like this:

Here I’ve got an axis along the top, modelName, and a cell axis with my remainingReserves.oil column. I can’t compare these the way they are! Normally in custom expression language, I can call out columns but not “conditionally”-based upon the value. HOWEVER, I can compare across columns using the OVER command like we do in time series-styled visualizations.

This is done using the OVER command, constrained by “Previous([Axis.Columns])”. This tells Spotfire to walk backwards to the column to the left of it.

That’s it!

Creating Vintage Columns for Type Curve Groups

Periodically at the Ruths.ai 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.