Borehole Manager | File | Import | Fugro CPT | Lithology
Use this to import into the current borehole's Lithology table the soil data contained in a Fugro Cone Penetrometer data file.
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 Lithology 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
- Decimal Places: Enter the number of decimal places to store for the depth values.
Step-by-Step Summary
-
Access the Borehole Manager.
-
Select the well for which the data is to be imported, by clicking on the well's name in the borehole listing.
-
Select the File | Import | Fugro CPT | Lithology menu option.
-
Enter the requested menu information, listed above.
-
Click the Process button to proceed with the import.
The program will read the indicated cone penetrometer data file, extract the depths and soil information, and list the data in the current well's Lithology table. In the process, the program will concatenate similar intervals such that the lithology doesn't consist of hundreds of small intervals. 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