Geotechnical Unconsolidated Undrained Report

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports by Product > Standard with Geotech > Geotech Sample Reports >

Geotechnical Unconsolidated Undrained Report

Report Name: Geotechnical Unconsolidated Undrained (example)

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

Dependencies: Licensed EQuIS Geotech and Geotech Schema

Software: EQuIS Professional and Enterprise

Source: EQuIS Geotech (EarthSoft Community Center > Products > EQuIS Geotech)

Language: English

Output Type: Excel1 or PDF

 

Description: The Geotechnical Unconsolidated Undrained report plots the Stress and Strain reading results of an Unconsolidated Undrained (UU) test. This report references the EQUIS.GEOTECH_UNCONSOL_UNDRAIN and EQUIS.GEOTECH_UNCONSOL_UNDRAIN_READINGS database functions to grab the appropriate data to report. These functions filter results based on the selected task and will only display samples that have an associated DT_GEO_TEST record where DT_GEO_TEST.TEST_TYPE = ‘Unconsolidated_Undrained’ and 'UnconsolUndrain_Readings’. This report can be run in EQuIS Professional or published to EQuIS Enterprise.

 

Installation Instructions: This report requires an EQuIS Geotech license and the Geotech Schema applied to the database. The Geotechnical Unconsolidated Undrained report (EarthSoft.Reports.Library.176839.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:

 

The report dynamically calculates the test result information based on the data available in the database. The unit in which the values are calculated is dependent on the unit specified in DT_TASK_PARAMETER.PARAM_CODE = ‘comp_strength_units’. The report supports the following units: pounds per square foot (PSF), pounds per square inch (PSI), and tons per square foot (TSF). See the EQUIS.GEOTECH_UNCONSOL_UNDRAIN and EQUIS.GEOTECH_UNCONSOL_UNDRAIN_READINGS functions articles for calculation details.

 

On the report chart, the Stress (Y-axis) interval ranges are determined by the unit defined in DT_TASK_PARAMETER.PARAM_CODE = ‘comp_strength_units’. The axis dynamically changes based on the unit.

TSF – 0.2 interval

PSF – 500 interval

PSI – 5 interval

 

An (optional) image can be displayed on this report. The image can either be a dynamic image based on the failure_mode or an actual image of the failed specimen.

 

If the user would like to display the image of the failed specimen, their image must be uploaded to the DT_FILE table with the following information populated:

DT_FILE.FACILITY_ID = facility_id (cannot be null)

DT_FILE.PLACE_TYPE = ‘UC_UU_Image’

DT_FILE.PLACE_CODE = sys_sample_code

DT_FILE.PLACE_SUBCODE = sys_loc_code

 

For the image based on the DT_GEO_TEST_PARAMETER.PARAM_CODE = ‘failure mode’, the images must be configured appropriately in DT_FILE.

DT_FILE.PLACE_TYPE = ‘UC_UU_Image’

DT_FILE.PLACE_CODE = failure_mode

 

Warning: If multiple records are present for the same DT_FILE.PLACE_TYPE and DT_FILE.PLACE_CODE combination, an error is encountered.  

 

This report supports task_code based paging.  

 

 

Template:

 

The Geotechnical Unconsolidated Undrained report is designed to use a selected Microsoft Excel template.

 

Note: The EarthSoft_Unconsolidated_Undrained.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.

 

The following is a list of the Excel Name Manager fields available for use in the Geotechnical Unconsolidated Undrained Report.

 

Excel Name
Manager Field

EQuIS Source

Description

uu_water_content

DT_GEO_RESULT.GEO_RESULT_CODE = ‘water_content’

Water content of the sample

uu_dry_density

DT_GEO_RESULT.GEO_RESULT_CODE = ‘dry_density’

Dry density of the sample

uu_dry_density_unit

RESULT_UNIT associated with DT_GEO_RESULT.GEO_RESULT_CODE = ‘dry_density

Dry density unit

sample_diameter

DT_GEO_TEST_PARAMETER.PARAM_CODE = ‘spec_diameter_avg

Sample diameter

sample_diameter_unit

DT_GEO_TEST_PARAMETER.PARAM_UNIT associated with DT_GEO_TEST_PARAMETER.PARAM_CODE = ‘spec_diameter_avg’

Unit of measurement for diameter

sample_height

DT_GEO_TEST_PARAMETER.PARAM_CODE = ‘specimen_height_avg’

Sample height

sample_height_unit

DT_GEO_TEST_PARAMETER.PARAM_UNIT associated with DT_GEO_TEST_PARAMETER.PARAM_CODE = ‘specimen_height_avg’

Unit of measurement for height

sample_height_diam_ratio

Calculated

Ratio of the sample’s height to diameter

uu_calc_saturation

Calculated

Saturation for a sample

uu_calc_void_ratio

Calculated

Void ratio (volume of voids to the volume of solids) for a sample

uu_specific_gravity

DT_GEO_RESULT.GEO_RESULT_CODE = ‘specific_gravity’

Specific gravity for a sample

sg_measurement_method

DT_GEO_TEST_PARAMETER.PARAM_CODE = ‘specificgravity_type’

Specifies whether the specific gravity value was measured or assumed. For example, if the type is ‘Measured’, then this will print as “Measured Specific Gravity”.

uu_failure_strain

DT_GEO_RESULT.GEO_RESULT_CODE = ‘failure_strain_val’

Strain at failure (%) at the maximum Stress reading

unconf_compres_strength

DT_GEO_RESULT.GEO_RESULT_CODE = ‘strength’

Value represents the maximum Stress value for Strain values that are equal or less than 15%

unconf_compres_strength_unit

DT_TASK_PARAMETER.PARAM_CODE = ‘comp_strength_units’ if present, otherwise defaults to 'TSF'

Unit of the Unconfined Compressive Strength

undrain_shear_strength

Calculated

Undrained shear strength

uu_strain_rate

DT_GEO_RESULT.GEO_RESULT_CODE = ‘strain_rate’

Rate of strain throughout the test

uu_strain_rate_unit

If the PARAM_VALUE associated with DT_TASK_PARAMETER.PARAM_CODE = ‘comp_strength_units’ is equal to 'MPA', then uses 'cm/s'. Otherwise, uses 'in/s'.

Unit of rate of strain

failure_image

DT_FILE.PLACE_TYPE = ‘UC_UU_Image’

DT_PLACE.PLACE_CODE = failure_mode

The failure image associated with the sample. If an image is not supplied, the report returns the default image associated with the failure_mode.

failure_mode

DT_GEO_RESULT.GEO_RESULT_CODE = ‘failure_mode’

Mode of failure for the sample

cell_pressure

DT_GEO_RESULT.GEO_RESULT_CODE = ‘cell_pressure’

Cell pressure

 

 

Tables: DT_GEO_RESULT, DT_GEO_TEST, DT_GEO_TEST_PARAMETER, DT_LOCATION, DT_SAMPLE, DT_TASK, DT_TASK_PARAMETER

 

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 = ‘Unconsolidated_Undrained’.

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.

 

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