Importing Fugro CPT Data into the P-Data Table

Borehole Manager | File | Import | Fugro CPT | P-Data

Use this program to import into the current borehole's P-Data table the data contained in a Fugro Cone Penetrometer data file. You can select which of the tip, sleeve, pore pressure, and f-ratio data are to be imported.

Menu Options
Step-by-Step Summary

Menu Options

• File Name: Click on File Name to browse for the Fugro CPT file to be imported into the current P-Data tab.
• Starting Row: Click on this prompt to type in the number for the row in the input file that represents the start of the data.  Default = 8.
  In the following excerpt, you can see what a typical Fugro data file header looks like.  To determine the starting row in your file, you can open the Fugro file into Windows Notepad (or similar program) and count the rows from the top where the actual data listing begins.
  
        DATE : 07-15-2005
        JOB NUMBER: 1065-8495
        CPT NUMBER: J-56
  
     DEPTH  TIP    SLEEVE F RATIO PIEZO  SOIL BEHAVIOR
     (M)   (TSF)   (TSF)  (%)     (TSF)  TYPE
     _____  _____  ______ _______ _____  ____________
      .02     .00    .00    .00     .00  CLAYS
      .04     .00    .00    .00     .00  CLAYS
      .06     .00    .00    .00     .00  CLAYS
      .08     .00    .02    .29     .00  CLAYS
      .10     .00    .02    .17     .01  CLAYS
      .12     .00    .04    .28     .01  CLAYS
      .14   11.32    .09    .47     .01  CLAYEY SANDY SILT&SILT
      .16   17.10    .16    .71     .01  SILTY SAND
      .18   17.61    .22    .90     .01  SILTY SAND
      .20   19.71    .27   1.05     .01  SILTY SAND
  
  
• Items to be Imported:
  • "Tip" Data:  Insert a check here if the Tip data is to be imported into the current P-Data tab.  Expand this heading to select the name of the P-Data column or track into which this data is to be listed.
  • "Sleeve" Data: Insert a check here if the Sleeve data is to be imported.  Expand this heading to select the name of the P-Data column into which this data is to be imported.
  • "F Ratio" Data: Insert a check here if the F Ratio data is to be imported.  Expand this heading to select the destination P-Data track.
  • "Piezo" Data: Insert a check here if the piezometer data is to be imported, and expand this heading to define the P-Data column into which this data is to be recorded.
    
    

Step-by-Step Summary

1. Access the Borehole Manager. 

2. Select the well for which the data is to be imported, by clicking on the well's name in the borehole listing.  

3. If you have not already done so, assign the titles for the columns in the P-Data table.  You can do this by right-clicking in the data table, and selecting the Show Column Names option. For example, you could assign a column named "Tip" for tip data, "Sleeve" for sleeve data, etc.
   ! Note that assigning column names affects the column titles for all boreholes, not just for the current borehole.

4. Select the File | Import | Fugro CPT | P-Data menu option.

5. Enter the requested menu information, listed above.

6. Click the Process button to continue.

The program will read the indicated cone penetrometer data file, extract the depths and geophysical measurements from the file, and list the data in the current well's P-Data table. This process can be repeated for additional boreholes and CPT files.

For more information about Fugro, please visit www.fugro.com.

Back to Importing Data

RockWare home page