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.