Report Name: Geotechnical Atterberg Limits (example)
File Name: EarthSoft.Reports.Library.176839.dll
Dependencies: Licensed EQuIS Geotech and Geotechnical Schema
Software: EQuIS Professional
Source: EQuIS Professional install + EQuIS Geotech (EarthSoft Community Center > Products > EQuIS Geotech)
Output Type: Excel1 or PDF
Description: The Geotechnical Atterberg Limits report plots the Plasticity Index against the Liquid Limit for each sample result. 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 = ‘Atterberg’. This report can be run in EQuIS Professional or published to EQuIS Enterprise.
Installation Instructions: This report requires an EQuIS Geotech license and the Geotechnical Schema applied to the database. The Geotechnical Atterberg Limits 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.
The Plasticity Index is calculated by subtracting the Plastic Limit from the Liquid Limit (Liquid Limit – Plastic Index). The Liquid Limit is gathered from the DT_GEO_RESULT table where DT_GEO_RESULT.GEO_RESULT_CODE = 'Att_LL' and the Plastic Limit information comes from the DT_GEO_RESULT table where DT_GEO_RESULT.GEO_RESULT_CODE = 'ATT_PL'.
This report supports task_code based paging.
This report uses the Shared Attributes detailed in the Shared Report Attributes article.
Note: The EarthSoft_AtterbergLimits.xlsx template file is provided with EQuIS Geotech. This template file contains a hidden sheet in the workbook labeled “Chart Data” that is used to construct the constant “U” and “A” lines. See the Geotechnical Template Configuration article for detailed information on editing/creating Excel templates for use with EQuIS Geotech reports.
Tables: DT_GEO_RESULT, DT_GEO_TEST, DT_LOCATION, DT_SAMPLE, DT_TASK
Copyright © 2023 EarthSoft, Inc. • Modified: 23 Aug 2023