Import Fugro CPT Data into the Lithology Table
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. Any existing data will be overwritten.
Feature Level: RockWorks Basic and higher
Menu Options
Step-by-Step Summary
- Input File
- Fugro CPT (Cone Penetrometer Test) Input File: Click to the right to browse for the Fugro CPT file to be imported into the current Lithology table.
- Import Options
- 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.
- Access the Borehole Manager program tab.
- 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 Continue 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 Import Data
RockWare home page