Geotechnical CPT Parameters Report

Report Name: Geotechnical CPT Parameters (example)

File Name: EarthSoft.Reports.Library.d26526.dll

Dependencies: Licensed EQuIS Geotech and Geotechnical Schema

Software: EQuIS Professional

Source: EQuIS Professional install + EQuIS Geotech (EarthSoft Community Center > Products > EQuIS Geotech)

Language: English

Output Type: Excel1 or PDF

Description: The Geotechnical CPT Parameters report produces a graphical output of various calculated Cone Penetration Test (CPT) parameters against depth. This report filters the results based on the selected task and will only display locations that have the appropriate data in the DT_DOWNHOLE_POINT_DATA table. This report references the EQUIS.GEOTECH_CPT_DATA database function to grab the related data to report. This report can be run in EQuIS Professional or published to EQuIS Enterprise.

X-axis parameters supported in this report:

•Sleeve_Friction

•Sleeve_Friction_LOG

•Tip_Resistance

•Tip_Resistance_LOG

•Elastic_Modulus

•Constrained_Modulus

•Eff_Friction_Angle

•N60

•OCR_1

•OCR_2

•Undrained_Shear_Strength

•Undrain_Shear_Strength_vs_Elev

Installation Instructions: This report requires an EQuIS Geotech license and the Geotechnical Schema applied to the database. The Geotechnical CPT Parameters report (EarthSoft.Reports.Library.d26526.dll) is available for download in the Products\EQuIS Geotech folder on the Downloads Dashboard on the EarthSoft Community Center. For Enterprise use, this report should be published to the database. When publishing the report, the assembly should be stored in the database. The report will be available for selection once it has been published.

Additional Details:

Note: The EarthSoft_CPTParameters.xlsx template file is provided with EQuIS Geotech. See the Geotechnical Template Configuration article for detailed information on editing/creating Excel templates for use with EQuIS Geotech reports.

Tables: DT_DOWNHOLE_POINT_DATA, DT_EQUIPMENT, DT_EQUIPMENT_PARAMETER, DT_LOCATION, DT_LOCATION_PARAMETER, DT_TASK, DT_TASK_PARAMETER, DT_WATER_TABLE

Report Parameters

Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.
Task(s)	Parameter for selecting task code(s).
Excel Template	Parameter for selecting Excel template. The report searches the DT_FILE table where DT_FILE.PLACE_TYPE = ‘CPT_Parameters’.
Override Template (EQuIS Professional Only)	Parameter to enter the full file path to use a local override template. This parameter is only available in EQuIS Professional.
Output File Type	Parameter for selecting the output file type. The options are PDF or Excel.
X-axis Parameters	Parameter for selecting the CPT Parameters to display in the output report. If none are selected, then all CPT parameters are included in the output.

1Excel report output requires a valid license of Microsoft Excel to view the output.