« Depth & Time Data Correlation » Welcome Guest. Please Login or Register. May 23, 2013, 4:26pm

[Home] [New Topics] [Help] [Search] [Login] [Register]

If like me you shop on line please try our club store or here first
Instant Video	Appliances	Apps for Android	Arts. Crafts & Sewing	Automotive	The Baby	Beauty	Books	Cell Phones
Clothing & Accessories	Electronics	Grocery & Gourmet	Food	Health Care	Bedding & Bath	Kitchen & Dining	Industrial & Scientific	Jewelry
Kindle Store	Magazine Subscriptions	Movies & TV	MP3 Downloads	Music	Musical Instruments	Office Products	Shoes	Software
		Sports & Outdoors	Tools & Home Improvement	Toys & Games	Video Games	Watches

To Advertise your company Click here * Club Book Store * Air and Gas Drilling * Belt Buckles * Casing and well design * Carbonate Reservoirs * Cementing * Completion * Corrosion and Scale * Directional Drilling * Drilling The Basics * Drilling engineering * Drilling Equipment * Drilling Fluid * Drilling Motors * Engineering Textbooks * Formation evaluation * Formulas/Calculations * Gas well testing * Geology * Horizontal Drilling * Hydrogen Sulphide * Logging * Managed Pressure Drilling * Oil Field Chemicals * Oil Field Safety * Oil Well Investments * Oil Well Testing * Oil well fishing * Production Engineering * Petroleum engineering * Reservoir Engineering * Petroleum Geology * Rotary Drilling Series * SPE Text Books series * Subsea Engineering * Underbalanced Drilling * Well Control * Workover

:: DrillingMegaDeck Composite Mats The ultimate rig mats & portable roadway for oil/gas & pipeline projects :: Oil Well Logging and Logging tools :: Depth & Time Data Correlation Author Topic: Depth & Time Data Correlation (Read 550 times) canuckian Member member is offline Joined: Sept 2010 Posts: 13 Location: Calgary, AB Depth & Time Data Correlation « Thread Started on Apr 14, 2011, 7:57pm » Anyone know a good program that will correlate depth and time? I have logging from downhole tools (time based) and surface data (PASON w/depth and time) and I would like to correlate it all together. There is too much data for Excel to handle and my usual LAS Tools Pro program used for gamma does not accept time. Any info would be much appreciated. Thanks. Link to Post - Back to Top   Logged canuckian Member member is offline Joined: Sept 2010 Posts: 13 Location: Calgary, AB Re: Depth & Time Data Correlation « Reply #1 on Apr 17, 2011, 6:49pm » Just to clarify, I have Time Vs Data and Time Vs Depth data. I know there is software (or excel macro) that will merge the two, most of it being proprietary. Is there a commercial program or can someone share an excel sheet, VBA code, formula (VLOOKUP, merge, ?), anything? Thx Link to Post - Back to Top   Logged canuckian Member member is offline Joined: Sept 2010 Posts: 13 Location: Calgary, AB How to merge depth and time data « Reply #2 on Apr 25, 2011, 9:30pm » I'll assume the ~40 readers of this topic were possibly searching for an answer as I was. I was able to merge the data I had using a combination of Excel and LAS Tools Pro. I will explain below how I skinned this cat and what I learned along the way. The data from the first well took a number of hours I would rather not say , but I now have the process down to an hour. First of all my data was a little unique in that I was correlating four different downhole pressure readings. Pressure, unlike Gamma for example, can change over time while remaining at the same depth or returning to previously drilled depths during reaming or tripping. So although i wanted to correlate my data to bit depth, TVD, etc. I had to use time as the main correlation. Unfortunately my logging program LAS Tools does not accept time (just says "null") and Excel is great for some application but logs/graphs, in my opinion, are not one of them. This is why I used a combination of the programs, to do this I had to trick the program to use time as the depth value. Using Excel I reformatted all of my date/time cells to a 4 decimal number (4 decimal is highest resolution for the LAS Tools program), which is how Excel actually "sees" date and time. Time is stored as a fraction of a day; for example 0.5000 equals noon. Dates are stored as whole numbers with number 1 starting on January 1, 1900. Therefore todays date and time of 25/04/2011 3:00:00 PM equals 40658.625 when formated to a number. Still following? From there I was either able to create a VLOOKUP formula in excel that correlated the time to any of the measurements. But even easier was to use LAS Tools Pro to merge all the newly time formated excel data logs (saved as Text: (Tab delimited)). The program asks which data column is the depth, in this case I selected the newly formated time as depth. If anyone has any further questions I would be happy to help. Link to Post - Back to Top   Logged pupjoint Leading Member member is offline Joined: Jan 2006 Gender: Male Posts: 1,271 Re: Depth & Time Data Correlation « Reply #3 on Apr 26, 2011, 2:35am » Apr 25, 2011, 9:30pm, canuckian wrote: ................ If anyone has any further questions I would be happy to help........ Yes. Its been ages since I've had anything to do with LAS files. We had a problem with transmittal of real time data via WITS (I think).We never figured out the problem but suspected it may have had something to do with the "null" values. Question: Is it normal for LAS use "Null" or should we substitute -9999 instead....manually ? I realize the question is vague and lacking in specifics but perhaps you might be able to figure out what I'm talking about. Thanks for your post. « Last Edit: Apr 26, 2011, 2:40am by pupjoint » Link to Post - Back to Top   Logged MOO Information or opinions are solely provided for educational and/or discussion purposes on an informal public forum and should not be interpreted as a recommendation for a specific treatment plan, course of action or product/ service. Use of any of this information does not replace consultations with qualified individuals in these respective fields. Rebel Tool Leading Member member is online One fine sunny day....... Joined: May 2010 Gender: Male Posts: 829 Location: UK Re: Depth & Time Data Correlation « Reply #4 on Apr 26, 2011, 9:46pm » In LAS 3.0 the NULL value is defined in the data header in the Well section. You can use anything that you want but -999.25 is the most common and will be easily be imported by any software designed to deal with LAS files. ~Well The ~Well section contains data that uniquely identifies the Well bore data. Required Contents (All files) The following eleven Parameter Data lines are required in every ~Well section. The Value field of the STRT, STOP, STEP and NULL parameters must contain data. All other Value fields are not required to contain data but it is strongly recommended that all Parameter Data lines contain correct data. STRT, STOP and STEP value fields must contain the actual first, last and increment values of the index channel in the ~ASCII or the ~Log_Data section (if present, and if there is only one ~Log_Data section). If the file contains more than one ~Log_Data section, then the STRT, STOP and STEP value fields must have the correct data for ~Log_Data[1]. Other sections ~Log_Data[n] sections do not require additional STRT, STOP and STEP parameters at this time. STEP must be 0 if step increment is not exactly constant between every index. STRT . Value : First Index Value STOP . Value : Last Index Value STEP . Value : STEP of index The NULL value requires a value. –999.25 or –99999 are common examples. NULL . Value : NULL VALUE Link to Post - Back to Top   Logged Information or opinions are solely provided for educational and/or discussion purposes on an informal public forum and should not be interpreted as a recommendation for a specific treatment plan, course of action or product/ service. Use of any of this information does not replace consultations with individuals qualified in these respective fields. Forum Jump--------------------» Home--------------------» About The Drillers Club: --------------------- Read more about the Drillers Club--------------------» Oil, Drilling and World news section --------------------- Oil, Drilling and World news section --------------------» Club YouTube and Video files --------------------- Club YouTube and Video files --------------------» General--------------------- Oilmans' Notice Board - Idle Chat or BS- Best practices folder- Entry Level Positions- Oil Field Abbreviations and Acronym- Supporting Companies- Downloads, Tools, Useful Data Sheets and Company Links- Oil Field Humour- Oil Field Safety and Procedures - Drilling Glossary - Company Profiles and New Builds- Safety Alerts--------------------» DrillingMegaDeck Composite Mats The ultimate rig mats & portable roadway for oil/gas & pipeline ...--------------------- Drill String and Bits- Casing and Cementing- Well Control --- Lost Circulation- Geothermal section- Managed Pressure Drilling- BOP Equipment- Drilling Fluid- HPHT Drilling- Deep Water Drilling- Underbalanced Drilling- Coal bed methane drilling- Directional and Horizontal Drilling- Down Hole Problems- H2S- Casing While Drilling- Expandable Tubular- Oil Well Logging and Logging tools--------------------» Workover and CompletionTo Advertise your company Click here--------------------- Oil Well Completions- Coiled Tubing- Stripping and Snubbing- Workover Fluids - Fishing Tools and their functions - Workover Problems- Unconventional well Fracturing--------------------» Equipment: To Advertise your company Click here--------------------- Oil Field Equipment in General- Sub Sea Equipment and completions- Automated Drilling Systems and Tools- Design engineers and equipment design- Equipment failures- Sub Sea Equipment and completions--------------------» MarineTo Advertise your company Click here--------------------- Anchoring- Ballasting,- Dynamic positioning- Vessel stability etc?- Mooring,- shipping and pirates--------------------» WORK REGIONS To Advertise your company Click here--------------------- REGIONS WORKED- Traveling--------------------» Worldwide Petroleum Directory--------------------- Add your company profile --- Read me first --- Air Passenger Charter & Support --- Architecture --- Aviation Fuel Sales Bulk Diesel --- Bearings --- Books --- BOP Equipment --- Bits --- Buildings – Lease Space --- Buildings – Modular --- Casing --- Casing While Drilling --- Camps, Catering & Lodging --- Cellular Communications --- Cementing --- Chemicals --- Chemical Analytical Lab --- Civil & Hazardous Waste --- Coal bed methane drilling --- Commercial Diving --- Communications --- Computer Services --- Construction Equipment & Materials --- Construction Project Management --- Consulting --- Contractor – General --- Contractor – Pipeline --- Control Systems --- Deep Water Technology --- Dredging --- Drilling Equipment --- Drilling Pipe Handling Equipment --- Drilling BOP Handling & HPU --- Drilling Caustic Mixing Unit --- Drilling Drawworks --- Drilling Drill Floor Tools --- Drilling Control Systems --- Drilling Finder Landrigs --- Drilling High Rate Mixers --- Drilling Knuckle/telescopic cranes --- Drilling Mud Control Systems --- Drilling Sack Dosing Unit --- Drilling Solid Control --- Drilling Top Drive Systems --- Drilling Contractors --- Drilling Fluid --- Drilling Software --- Drill String --- Directional and Horizontal Drilling --- Electrical --- Employment Services --- Energy Services --- Engineering Services --- Environmental Engineering --- Environmental Response & Cleanup --- Environmental Supplies --- Equipment & Heavy Hauling --- Equipment Sales/Rental --- Expandable Tubular --- Fire Protection --- Fishing tools --- For Sale --- Freight/Shipping & Cargo --- Fueling Services --- General Oilfield Supplies --- Geophysical & Geological Services --- Health Care Professionals --- Helicopter Contract/Charter Services --- HPHT Drilling --- Hoses, Hydraulic & Industrial --- Industrial Gases --- Industrial Parts & Supply --- Information Technology Consulting --- Inspection Services --- Instrumentation Systems --- Laboratory Services --- Legal --- Logistics --- Machining --- Maintenance --- Management Consulting --- Managed Pressure Drilling --- Maps --- Marine Services & Construction --- Mechanical & Electrical Inspection --- Medical Facilities & Response --- Medical Services --- Meetings & Conventions --- Metal Distributors --- Mud & Mud Logging --- Oceanographic Services --- Oil Commpanies --- Oil and Gas Insurance --- Oilfield Services --- Oil Well Logging and Logging tools --- Packers --- Pipe, Fittings & Thread Technology --- Pipeline Maintenance --- Plumbing --- Power Generation --- Process Equipment --- Procurement Services --- Production Equipment --- On Line Publications --- Offshore Power Outlets --- Public Relations --- Pumps --- Research and Development --- Rig Construction --- Rigging Supplies --- Safety behavioural and safety --- Safety Equipment & Supplies --- Seismic & Geophysical --- Solids Control --- Soil Stabilization --- Steel Fabrication --- Steel Sales --- Sub Sea Equipment --- Surveying & Mapping --- The Driller's Club Shop --- Training --- Underbalanced Drilling --- Underwater NDT & Photography --- Underwater Welding --- Well Services --- Welding --- Weld Repairs/Manufacturing --- Well Control --- Wire Rope --- Workover and Service Companies --- Valves --- Drilling courses and training schools--------------------» Well Control-------------------- The Driller’s Club is constructed around many oil field forums that allow drilling and oil field oriented people to ask and answer questions relating to subjects within the industry. Membership is free and you can pick your own user name Make a small donation and support the club

To Advertise your company Click here

online casino