How to Import Well Tops

In ZoneVu, you can bulk import Top data for one or more Wells. This article will walk you through this process. You can download the most up-to-date version of the Single and Multi-Well Top Import Spreadsheet here: Single Well Top Import Spreadsheet Download or Mulit-Well Top Import Spreadsheet Download

Bulk Importing Top Data for a Single Well:

• Navigate to the "Tops" tab in the Well's Folder

• Click the "Import" button

1. Drag & Drop or select the Top data file (.txt, .cvx, Excel Workbook, or ZoneVu Import Spreadsheet)

2. ZoneVu will parse the file and attempt to identify the key data columns. You can use the dropdowns at the top of each column to identify any column.

   • Select the data unit type (Feet or Meters)

   • "Create new formations in start columns for missing formation names" checkbox: When checked on, the importer will add any missing formation tops into the assigned Strat Column.

3. You can download the Import Spreadsheet using the "Download the Template Here" hyperlink

4. Click the "OK" button to import the Top data

Once the import has been completed the Tops Table will display the imported Tops

Bulk Importing Top Data for Multiple Wells:

• While on the Home Page select "Import Tops" under the Well dropdown

1. Drag & Drop or select the Top data file (.txt, .cvx, Excel Workbook, or ZoneVu Import Spreadsheet)

   • ZoneVu will use the UWI/API column to identify which Well the Top data is for

2. ZoneVu will parse the file and attempt to identify the key data columns. You can use the dropdowns at the top of each column to identify any column.

   • Select the data unit type (Feet or Meters)

   • "Create new formations in start columns for missing formation names" checkbox: When checked on, the importer will add any missing formation tops into the assigned Strat Column.

3. You can download the Import Spreadsheet using the "Download the Template Here" hyperlink

4. Click the "OK" button to import the Top data

Bulk Top Import Spreadsheet: Single Well Top Import Spreadsheet Download or Mulit-Well Top Import Spreadsheet Download

Top Import Spreadsheet Format:

If the "Create new formations in strat columns for missing formation names" option is active during import and there is no matching formationname for a formation in the referenced well's strat column then new formations will be created using the formation data from this sheet. To be valid, a row must contain a value for either the md, tvd or elevation columns

The column headers will specify which columns are Required, Recommended, and Suggested.

• uwi (text): Unique Well Identifier (UWI) of the Well that the Tops data is related to. This can be the API or any text

• formationname (text): The name of the Formation the pick represents. This should match the related formation in the associated Strat Column, case-sensitive

• formationsymbol (text): The symbol of the Formation the pick represents, no character limit

• formationcolor (text): The color of the Formation the pick represents. Any HTML color name. See HTML Color Names

• formationlithology (PDT): Specify the bulk lithology associated with the top. When creating new Strat Column Formations, this lithology will be assigned to Start Column Formation and act as the default Litho Texture Litho Textures

  • PDT: Sandstone, Shale, Limestone, Dolomite, Chalk, Marl, MudstoneRich, MudstoneLean, Bentonite, Coal, Chert, Anhydrite, Siltstone, ShalySand, SandstoneBedded, calcareous sandstone, SandyShale,  ShalyLimestone, SandyLimestone, ShalyDolostone, SandyDolostone, LimestoneShale, ShaleSandstone, SandstoneShale, ShaleLimestone, Salt, ChertyShale, Breccia, Conglomerate, Basalt, Granite, Igneous, Tuff, Crosshatch

• interpreter (text): The person (etc.) responsible for the pick

• md (integer): The measured depth of the pick

• tvd (integer): The true vertical depth of the pick

• elevation (integer): The elevation of the pick. Positive above sea level

• entereddepthtype (PDT): The type of depth value that should be used to calculate the other depth values for the pick

  • PDT: Elevation, MD, TVD

• porosity (integer): The pick's Porosity (ϕ)

• watersaturation (integer): The pick's Water Saturation (Sw)

• shalecontent (integer): The pick's Volume Shale (Vsh) Content

• hcporosity (integer): The pick's Oil Saturation x Porosity x Hydrocarbon (SoϕH)

***PDT (Pre-Defined-Text): Denotes columns where the Bulk Top Importer is looking for specific text input. All available PDT inputs will be listed under the column description