Let’s QC 1000 well logs in Spotfire

Got a question today about the Well Log visualization that I thought I would work through here. We haven’t done much write up on the tool so I thought I would take a moment and sketch out this use case.

Let’s say that you have a repository of LAS files that you need to look through.

Now to get these into Spotfire, we’re not going to add these one by one as data tables. That would be a huge mess and problematic to load so much data. What we will do instead is load them on-demand. To do this, we need to create a specific architecture. Here are the steps outlined:

  1. Create list of LAS files
  2. Import LAS path list into Spotfire
  3. Setup LAS OnDemand
  4. Highlight rows in the original list table.
  5. Ensure the well logs came in.
  6. Setup a Well Log visualization that is trellised on Well Name.

Alright here we go!

Create the list of LAS Files

Alright first we need a list of the file paths in a data table. I’ll show you folks a quick shortcut.

Open PowerShell from the Start Menu and navigate to the directory using the following:

  • cd C:\Users\lucaswood1\lasfiles\
  • (Get-ChildItem * -Recurse).fullname

You should get something like this:

You can use the command, ls, to get just the file names, we’ll use those to get the FileName column.

Click and drag over the entire list and paste that into Excel. Hit Enter to copy.

I used =SUBSTITUTE(B2,”.las”,””) to lop off the .las filename.

Import LAS path list into Spotfire

Alright now that we have our table, let’s begin with the end in mind (courtesy Stephen Covey) by reviewing what we’re going to make.

Normally, in Spotfire we’d go to Insert > Rows but that will be quite a bit of button work for our 400 wells. We’ll build the above table for us from a list of LAS files that we provide from another Spotfire table.

Anytime you Mark
a file on the ListOfLASFiles table, it will load the LAS file into the LAS OnDemand table.

Setup LAS OnDemand

Access the LAS OnDemand dialog box by going to Tools > LAS(P) > Load LAS files on demand:

Let’s step through our choices.

  • Data table – this is the data table we just created in Excel.
  • Filename – this will be the full path of the file.
  • Identifier – this will be the well name or filename, it doesn’t matter too much.
  • Marking – this is the marking layer that the OnDemand table will be listening on.
  • Result table – the LAS OnDemand loader will build our table with this name.\
  • Automatic update – use this to toggle automatic updates on marking.

That’s it! Spotfire will create the table for you. Just remember to setup the trellis by the well name. Let me know if you have any questions in the comments below.

One thought on “Let’s QC 1000 well logs in Spotfire

  1. New to spotfire, have tinkered with R and would love to explore this approach to viewing LAS.. There isn’t a company I have ever worked for that doesn’t have a huge collection of LAS files they paid big $ for and then squirrled away in some absurd folder structure rendering them mostly useless.
    But I digress…
    You lose me on the R transform you reference above….?
    It’s early… am I missing something obvious? what is this doing?

Leave a Comment

Your email address will not be published. Required fields are marked *