Geotechnical Consolidation Compression Curve Report

Report Name: Geotechnical Consolidation Compression Curve (example 1, example 2)

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

Description: The Geotechnical Consolidation Compression Curve report charts the Stress vs. Strain or Stress vs. Void Ratio results from a Consolidation test. This report filters the results based on the selected task and will only display samples that have an associated DT_GEO_TEST table record where DT_GEO_TEST.TEST_TYPE = ‘Consolidation_Detail’ and 'ConsolidationLoad'. This report can be run in EQuIS Professional or published to EQuIS Enterprise.

Y-axis parameters supported in this report:

•Strain

•Void Ratio

Installation Instructions: This report requires an EQuIS Geotech license and the Geotech Schema applied to the database. The Geotechnical Consolidation Compression Curve 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:

This report produces a compression curve displaying either Stress vs Strain or Stress vs Void Ratio. This report refers to the Geotechnical Consolidation Sample and Load Results report to grab the related data to report. The report output is dependent on the user selected report parameter – "Y-Axis". The Y-axis parameter allows the user to select whether they would like to display Strain or Void Ratio on the y-axis. Based on the selected parameter, the report selects the appropriate sheet to populate in the template. The results of each load are displayed on a chart and are connected by a line.

When running the report, DT_SAMPLE.TASK_CODE must be populated to generate an ouput.

This report supports task_code based paging.

Note: If the test does not have the associated chart data (for Void Ratio or Strain), then the test record is excluded from the chart.

This report uses the Shared Attributes detailed in the Shared Report Attributes article.

Template:

The Geotechnical Consolidation Compression Curve report is designed to use a selected Microsoft Excel template.

Note: The EarthSoft_ConsolidationCompressionCurve.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 selected template must have a separate sheet for each supported "Y-Axis" parameter. Based on the selected parameter, the report will select the appropriate sheet from the template to display the data. Each sheet name in the template must match the following naming conventions:

Parameter Name	Excel Sheet Name
Strain	StressvsStrain
Void Ratio	StressvsVR

The report is built to respect the chart properties defined within each sheet of the template. This includes the chart type, axis scale type, and the minimum and maximum X/Y axis values. If the minimum/maximum axis values are set to AUTO in the template, then the report dynamically defines the Min/Max axis values based on the data plotted.

To configure the chart axis titles to support dynamic units, "{stress_unit}" must be included in the chart axis titles. If there is a discrepancy amongst the displayed tests or if one test is missing units, then the {stress_unit} is not displayed in the axis title.

In addition to the Shared Report Attributes, the following Excel Name Manager fields are available for use in the Geotechnical Consolidation Compression Curve report.

Excel Name Manager	EQuIS Source	Description
test_notes	DT_GEO_TEST.REMARK	The remarks associated with the test.
test_start_date	DT_GEO_TEST.TEST_DATE	The start date of the test.
test_method	DT_GEO_TEST.TEST_METHOD	The test method used to conduct the Consolidation test.
specimen_diameter	DT_GEO_TEST_PARAMETER.PARAM_CODE = 'specimen_diameter'	The specimen diameter.
initial_specimen_height	DT_GEO_TEST_PARAMETER.PARAM_CODE = 'init_specimen_height'	The initial specimen height.
length_unit	DT_GEO_TEST_PARAMETER.PARAM_UNIT where DT_GEO_TEST_PARAMETER.PARAM_CODE = 'init_specimen_height'	The unit of measurement of length.
specific_gravity	DT_GEO_RESULT.GEO_RESULT_CODE = 'specific_gravity'	The specific gravity of the specimen.
initial_moisture	DT_GEO_RESULT.GEO_RESULT_CODE = 'initial_wc'	The initial moisture content of the specimen.
initial_dry_density	DT_GEO_RESULT.GEO_RESULT_CODE = 'initial_dry_density'	The initial dry density of the specimen.
density_unit	DT_GEO_RESULT.RESULT_UNIT where DT_GEO_RESULT.GEO_RESULT_CODE = 'initial_dry_density'	The dry density unit.
initial_void_ratio	DT_GEO_RESULT.GEO_RESULT_CODE = 'initial_void_ratio'	The initial void ratio of the specimen.
initial_saturation	DT_GEO_RESULT.GEO_RESULT_CODE = 'initial_saturation'	The initial saturation of the specimen.
overburden	DT_GEO_TEST_PARAMETER.PARAM_CODE = 'overburden'	The overburden stress. This value is rounded to a whole number.
overburden_unit	DT_GEO_TEST_PARAMETER.PARAM_UNIT where DT_GEO_TEST_PARAMETER.PARAM_CODE = 'overburden'	The unit associated with the overburden stress.
cc	DT_GEO_RESULT.GEO_RESULT_CODE = 'compression_index'	The compression index.
cr	DT_GEO_RESULT.GEO_RESULT_CODE = 'rebound_index'	The recompression index.
cc_vr	DT_GEO_RESULT.GEO_RESULT_CODE = 'compres_index_vrplot'	The compression index associated with the Void Ratio plot.
cr_vr	DT_GEO_RESULT.GEO_RESULT_CODE = 'rebound_index_vrplot'	The recompression index associated with the Void Ratio plot.
pc	DT_GEO_RESULT.GEO_RESULT_CODE = 'pc_calc' or ‘pc_override’	The Preconsolidation Pressure.
pc_unit	DT_GEO_RESULT.RESULT_UNIT where DT_GEO_RESULT.GEO_RESULT_CODE = 'pc_calc' or ‘pc_override’	The Preconsolidation Pressure unit.
Name Manager Field Only Applicable to Chart
(stress_unit)	DT_GEO_RESULT.RESULT_UNIT where DT_GEO_RESULT.GEO_RESULT_CODE = 'Cons_Stress'	Stress unit of measurement. This field is used to add a unit to the X-axis caption.

Tables: DT_GEO_RESULT, DT_GEO_TEST, DT_LOCATION, DT_SAMPLE, DT_TASK

Report Parameters

Task(s)	Parameter for selecting task code(s).
Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.
Y-Axis	Parameter for selecting data plotting on the Y-axis – Strain or void_ratio. By default, this parameter is set to Strain.
Excel Template	Parameter for selecting Excel template. The report searches the DT_FILE table where DT_FILE.PLACE_TYPE = ‘Consolidation_CompressionCurve’’.
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.

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