1 / 17

LAS IN, LAS OUT & Resample Programs

LAS IN, LAS OUT & Resample Programs. By Anthony Miller. Anthony Miller Geoscience Applications Support Telephone: +44 (0) 20 7648 4950 E-Mail: millera@rpsgroup.com Web: http://www.rpsgroup.com. 2011 Grapher Version.

hamish-medina
Download Presentation

LAS IN, LAS OUT & Resample Programs

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. LAS IN, LAS OUT & Resample Programs By Anthony Miller Anthony Miller Geoscience Applications Support Telephone: +44 (0) 20 7648 4950 E-Mail: millera@rpsgroup.com Web: http://www.rpsgroup.com

  2. 2011 Grapher Version Originally the LAS -> Excel and Excel -> LAS buttons were on separate toolbars but I have now integrated them onto the same toolbar. They’re now on one toolbar with some new buttons. The second button from the right generates Grapher plots from the XLS file and Excel file The far right button edits the Grapher plot without the user having to regenerate it so as to change vertical scales. First let’s examine the LAS -> Excel -> LAS functions …

  3. LAS IN Pressing the Las In button causes a file select window to appear... …the selected file is opened and the selected file name is pasted onto the Sheet tab

  4. LAS IN ~Curve Information Block #MNEM.UNIT API CODE Curve Description #--------- ------------ ------------------ DEPTH.F 00 000 00 00: 1 Depth Curve GR .inch 00 000 00 00: 2 RHOB .g/cc 00 000 00 00: 3 NPHI .% 00 000 00 00: 4 DRHO .g/cc 00 000 00 00: 5 ~Parameter Information Block The Curve Block Information is entered in rows 1,2,3 with Row1 containing Curve Name Row2 containing Units Row3 containing the Curve Description This sheet now contains the wireline data...

  5. LAS IN ~Version Information VERS. 2.0: CWLS log ASCII Standard - VERSION 2.0 WRAP. NO: One line per depth step ~Well Information #MNEM.UNIT Data Information #--------- ---------------------------- ------------------------------------- STRT.F 740.0544: START DEPTH STOP.F 884.9868: STOP DEPTH STEP.F 0.1524: STEP NULL. -999.0000: NULL VALUE COMP. B.P.C. : COMPANY WELL. K-057 : WELL FLD . Kirkuk : FIELD LOC . : LOCATION PROV. : PROVINCE CNTY. : COUNTY STAT. : STATE CTRY. IRAQ : COUNTRY SRVC. : SERVICE COMPANY DATE. : DATE API . : API NUMBER HIDE. : Log Heading SECT. : Section TOWN. : Township RANG. : Range LATI. : Latitude LONG. : Longitude CLAB. : SLAB. : WHDS. : WCID. : PD . SDL : Permanent Datum RUN . : Run Number DMF . KB : Drilling Measured From LMF . KB : Logging Measured From TCS . : Time Circulation Stopped TLAB. : Time Logger at Bottom DFT . : Drilling Fluid Type MCSS. : Mud Cake Sample Source MFSS. : Mud Filtrate Sample Source MSS . : Mud Sample Source LUL . : Equiptment Location DB . : Digitized by ENGI. : Logging Engineer's Name WITN. : Witness's Name R1 . : Remarks TN1 . : Tool Numbers OS1 . : Other Services ~Curve Information Block #MNEM.UNIT API CODE Curve Description #--------- ------------ ------------------------------------- DEPTH.F 00 000 00 00: 1 Depth Curve GR .inch 00 000 00 00: 2 RHOB .g/cc 00 000 00 00: 3 NPHI .% 00 000 00 00: 4 DRHO .g/cc 00 000 00 00: 5 ~Parameter Information Block #MNEM.UNIT Value Description #--------- ---------------------------- ------------------------------------- EDF .F : Elevation, Derrick Floor EGL .F : Elevation, Ground Level EKB .F : Elevation, Kelly Bushing EPD .F : Elevation Permanent Datum TDD .f : Total Depth-Driller TDL .F : Total Depth-Logger CBD .F : Casing Bottom Driller CBL .F : Casing Bottom Logger TLI .F : Top Logged Interval BLI .F : Bottom Logged Interval DFD .G/CC : Drilling Fluid Density DFPH.---- : Drilling Fluid Ph DFL .---- : Drilling Fluid Loss DFV .---- : Drilling Fluid Viscosity RMS .---- : Mud Sample Resistivity MST .DEGC : Mud Sample Temperature RMFS.---- : Mud Filtrate Resistivity MFST.DEGC : Mud Filtrate Sample Temp RMCS.---- : Mud Cake Resistivity MCST.DEGC : Mud Cake Sample Temperature MRT .DEGC : Maximum Recorded Temperature CS .---- : Casing CW .---- : Weight BS .---- : Bit Size BSD .M : Depth The Well Information and Parameter Information Blocks are entered into a second sheet using columns A,B & C. This sheet is named the same as the wireline sheet (i.e. the Las file name with “_const” appended). Each line is split into three pieces A,B & C using the “.” & “:” markers

  6. LAS OUT using constants sheet ~Version Information Block VERS . 2.00: CWLS LOG ASCII STANDARD - VERSION 2.00 WRAP . NO: One line per depth step ~Well Information Block #MNEM.UNIT Data Type Information #---------- ---------------- ----------- STRT .F 740.0544: START DEPTH STOP .F 884.9868: STOP DEPTH STEP .F 0.1524: STEP NULL . -999.2500: NULL VALUE COMP . B.P.C. : COMPANY WELL . K-057 : WELL FLD . : FIELD LOC . : LOCATION PROV . : PROVINCE SRVC . : SERVICE COMPANY DATE . : LOG DATE UWI . : UNIQUE WELL ID ~Curve Information Block #MNEM.UNIT Value Description #---------- ---------------- ----------- DEPTH.F :evruC htpeD 1 GR .inch :2 RHOB .g/cc :3 NPHI .% :4 DRHO .g/cc :5 ~Parameter Information Block #MNEM.UNIT Value Description #---------- ---------------- ----------- CNTY . :COUNTY STAT . :STATE # Enter comments into the header

  7. LAS OUT without constants sheet ~Version Information Block VERS . 2.00: CWLS LOG ASCII STANDARD - VERSION 2.00 WRAP . NO: One line per depth step ~Well Information Block #MNEM.UNIT Data Type Information #---------- ---------------- ----------- STRT .F 740.0544: START DEPTH STOP .F 884.9868: STOP DEPTH STEP .F 0.1524: STEP NULL . -999.2500: NULL VALUE COMP . : COMPANY WELL . K-057_200_CALtest_noheader: WELL FLD . : FIELD LOC . : LOCATION PROV . : PROVINCE SRVC . : SERVICE COMPANY DATE . : LOG DATE UWI . : UNIQUE WELL ID ~Curve Information Block #MNEM.UNIT Value Description #---------- ---------------- ----------- DEPTH.F :evruC htpeD 1 GR .inch :2 RHOB .g/cc :3 NPHI .% :4 DRHO .g/cc :5 # Without Header Information Sheet In the absence of a Header Constants Sheet the Depth Units are taken from the Export sheet and the Well Name becomes the tab name - which is also the file name. Null value is assumed to be a default -999.25. Sample rate is calculated from sheet

  8. LASIN OUT bugs When using LAS IN - The Text input in Cell A2 retains the “.” before the “.F” or “.M”... ...but this does not matter because on export the user can use “.F” or “F” or “.M” or “M” in this cell and the “.”s (dots) will not cause a problem on export as the program is designed to remove all leading dots. There is also an Error in the Cell A3 import but as it isn’t very important in terms of the meaning of the data nothing has been done to fix it …and probably nothing will be. With some specific LAS files the data in Cell A4 can get lost but this is easily fixed by the user if they have any common sense. Obviously if the Depth column is NOT REGULARLY SAMPLED DECENDING DOWN THE PAGE the export LAS file will not make sense but again this is not a problem if the user has any common sense. Also YOU CANT Load or Unload A FILE NAME LONGER THAN 31 CHARACTERS because it has to fit on an Excel Worksheet Tab! …nothing I can do about this.

  9. Grapher Buttons Pressing the Grapher button opens a window which shows the columns of data listed and numbered and the well curve track to which they will be assigned. By pressing the Higher and Lower buttons the user can change the track that the curve will be attributed to and the order of the curves being plotted. This allows curves to be plottted each on a separate track…

  10. Grapher Buttons …or multiple curves to be plotted on the same tracks

  11. Grapher Scales Database File In order to decide what horizontal scale to place each curve on the program connects to a simple Access database (the user can either use the Logworld database or a smaller version on the local hard drive) containing the Log Mnemonic, Log Name, Log Tool Units and Display Minimum, Maximum and Orientation (left to right or right to left). If it cannot match the curve name with the Log Mnemonic the program tries to match the curve unit type with the Log Tool units and chooses a scale that way…

  12. Grapher Edit/Redraw Button As it’s highly likely that after generating the plot the user may want to resize it the button opens a form which allows the user to change the vertical scales any positioning of the plot presently open in Grapher via Activex. The user must press “Read Active File” followed by the Explore Futher button. They will then be able to change the scales in Depth Axis Options. The Change scales buttons actives the redraw. Spacing can also be altered in Auto.Object.Left box – redraw activated by Apply button. See/Hide shows more details of track positioning statistics.

  13. Resampler 2 Column Version (stand alone) Null Value Stipulation … Pressing the UD List box scans the second column for all possible values then posts them in the list box to aid Null In selection Resamples using Sample Increment selected or typed and posts calculation a default of 2 columns to the right of the input data. The 2 description cells above the start value are also copied if box ticked

  14. Resampler 2 Column Version (stand alone) The SV and EV options are merely to allow the user to stipulate different Start and End Depth values for the output data. If you choose an SV above the actual Start Value or and EV below the End value nulls are placed in the columns as appropriate. Nulls are pasted in such a way as to blank out any distortions at the end of sections due to data gaps.

  15. Resampler Array Version (stand alone) Does the same thing as for 2 columns but this time on an array (original cell info is deleted so save it before you start!)

  16. Resampler Array Version Log Calculator The module is also available as part of the Scott Pickford Log Calculator ….this version is identical to the original except that when you use the Array button the program copies Lines 1 and 2 to memory, deletes them then pastes them back again allowing you to Resample Arrays in the Log Calculator / Las IN / Las Out Excel format without having to continually copy and paste the Column Headers. The Las In / Las Out programs were written for the Log Calculator program whereas the Resampler program was written some time before and then incorporated into the Log Calculator. The Log Calculator version requires ActiveX and Database tools to be enabled that do not exist in Excel 97 … with the result that it only works in versions 2000 onwards. Running both versions of the Resampler at the same time may cause confusion and crashing in some circumstance

  17. Log Calculator The Log Calculator is designed to use the Las In / Las Out Excel format. It does many simple wireline conversions and some basic petrophysics. It also contains a cross plot module.

More Related