Application of Voronoi to Teapot Dome Field

This is a repost from our Ruths.ai channel on YouTube.

“In this demonstration we apply a geospatial R package to Spotfire (via TERR) to provide “planes” or “boundaries” across an oil field. The oil field is Teapot dome (open data source) and the R package is deldir. We have applied this technique to fields such as Eagleford or Cooper Basin and the technique can be augmented with further statistical methods such as kriging to gain further understanding into areal (i.e. well) performance or behavior.”

Using Spotfire Controls as JavaScript Objects

Let’s say that you are building an advanced workflow. You may need to take advantage of the text area’s capabilities to incorporate jQuery, CSS, and other responsive elements to design your interactive areas. I want to enumerate some of the techniques that I’ve used in the Blackjack template on Exchange.ai as a suggestion for best practices.

Read More

Using Spotfire for Decline Model Identification

A common reservoir engineering workflow is identifying production decline model(s) suitable for the production profile of wells or reservoirs; and quite frequently, asset management experts are tasked with calculating values of determining factors, and applying those factors in decline curve equations to establish forecast methodologies applicable to different periods in an asset’s production history.

Read More

Hide elements inside a SpotfireControl

Let’s say you want to remove an item from the dropdown of a SpotfireControl.

You can look inside of a Spotfire Control with the following JavaScript:

HTML:

<p id="turkey"><SpotfireControl id="b6d7d7d9761649bd9f87f096def91dfb" ></p>

<p id="bacon"></p>

JS:

$( document ).ready(function() {
   $('#bacon').text($('#turkey').html());
});

This lets you see the inside of the SpotfireControl. We see that the ‘Variable’ selection is the one that we want to hide. Simply grab the object using the title attribute.

JS:

$( document ).ready(function() {
   $("[title='Variable']").hide();
});

Viola!

Changing the Colors of Spotfire Controls

In Spotfire 7.0 you should be able to change the colors of links easily.

Coloring Action Controls

To create a custom colored link, perform the following:

  1. Create an action control and set the control type to “Link“.

  2. Enter into “Edit HTML” mode, highlight the newly created action control and press Format.

  3. Change the color of the link.

Coloring Spotfire Calculated Values

For Spotfire Controls, this is trickier. To change the color of Spotfire Labels you have to spoof it by making rules.

  1. Create a new calculated value.

  2. You’ll notice that from the editor you can’t control color, only font type, size, and font decorations.

  3. Go back into the Calculated Value Settings. Since you can’t change the formatting of the calculated value from the editor, you’ll need to make a rule.

  4. Presto! Happy editing.

Better Architecture with Joined Data Tables

Recently we had a client that was having trouble with their tables freezing. They had a SQL database joined directly to an Excel sheet but found that the table would not update and was embedded. These frozen tables can be avoided with proper architecture. It’s best to have sources that are separate and then joined later. You can use the ‘From Current Analysis’ data source option to make a reference to these tables.

Where’s Waldo? – Using Logical and Text Functions to Find “_W”

When you’re performing column matching and the primary key of one table does not exactly match the similar column in the second table, data manipulation may be necessary. Using calculated columns, you could create the necessary values for column matching. This example demonstrates how to use a custom expression to extract a string of characters from a column when the number of character values may not be consistent.

Read More