Pages

Sunday, October 10, 2010

A Huge Thank You

A huge thank you to two folks who wrote to tell me that it was indeed possible to bring the NDIC's "Confidential Spreadsheet" and the "Active Drilling Rig Spreadsheet" to a Microsoft Excel spreadsheet.

I had tried doing that some months ago but it did not work for me. When these folks told me that's what they did, I tried it again, and it worked like a charm.

I can't guarantee my numbers will always be current. Some days I am away from my computer and some days, even if I am watching things, data changes so quickly, one cannot keep up with it.

But the bottom line is that it is incredibly easy to move the NDIC spreadsheets to one's Excel spreadsheet, and then from there sort the data as one wishes.

So, a big thank you. I won't mention names: they know who they are.

6 comments:

  1. Also....

    Pivot tables are your friend!!!!

    rory

    ReplyDelete
  2. Yes, indeed. Thank you for all your help.

    Due to information overload, I probably won't update the numbers more than once a month, but we'll see.

    ReplyDelete
  3. It would be useful and efficient, at least with subscription services, to allow the analysis directly through the ND Oil and Gas interface, avoiding the incessant repetition of importation.

    With a database application (like Access) the NDIC data can be easily imported and seriously manipulated.

    Hess342

    ReplyDelete
  4. I have to chuckle. I have to be careful. I started this blog as a hobby. I have obviously become obsessed with it -- it keeps me out of trouble. But I am afraid if I have access to so much more NDIC data I will become hyper-obsessed. We'll see. Smile. This information is much appreciated.

    ReplyDelete
  5. Obsessions seem to be the source of human creations. Reducing the time required to get from question to answer can reduce 'obsession time'. Or, raise more questions...

    Hess342

    ReplyDelete
  6. That's the problem ... it will raise more questions....

    ReplyDelete

Note: Only a member of this blog may post a comment.