Geotechnical Gradation (Sieve) - ASTM D6913  Report

<< Click to Display Table of Contents >>

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

Geotechnical Gradation (Sieve) - ASTM D6913  Report

Report Name: Geotechnical Gradation (Sieve) - ASTM D6913 (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 Gradation (Sieve) - ASTM D6913 report creates a Grain Size Distribution by plotting the sieve analysis results. 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 = ‘Sieve’ and ‘Sieve_Readings’ and the associated DT_GEO_TEST.TEST_METHOD = ‘ASTM D6913’. 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 Gradation (Sieve) - ASTM D6913 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:

 

For the sieve analysis results, this report plots the percent finer value against the sieve diameter size. Based on the data available, the report calculates the D60, D30, and D10 Coefficient of curvature (Cc) and the Uniformity Coefficient (Cu) values per sample. Each curve on the plot corresponds to one sample.

 

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

 

This report supports task_code based paging.  

 

 

Template:

 

The Geotechnical Gradation (Sieve) - ASTM D6913 report is designed to use a selected Microsoft Excel template.

 

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

 

In addition to the Shared Attributes detailed in the Shared Report Attributes article, the following Excel Name Manager fields are specific to the Geotechnical Gradation (Sieve) - ASTM D6913 report.

 

Excel Name
Manager Field

EQuIS Source

Description

sieve

DT_GEO_RESULT.GEO_RESULT_CODE = ‘Sieve’ where DT_GEO_TEST.TEST_TYPE = 'Sieve_Readings' and DT_GEO_TEST.TEST_METHOD = ‘ASTM_D6913’

Sieve diameter size

percent_finer

DT_GEO_RESULT.GEO_RESULT_CODE = ‘Percent_Finer’ where DT_GEO_TEST.TEST_TYPE = 'Sieve_Readings' and DT_GEO_TEST.TEST_METHOD = ‘ASTM_D6913’

Percent finer value associated with the sieve diameter size

dhundred

Calculated

Particle diameter at 100 percent

dsixty

Calculated

Particle diameter at 60 percent passing

dthirty

Calculated

Particle diameter at 30 percent passing

dten

Calculated

Particle diameter at 10 percent passing

cc

Calculated

Coefficient of curvature. This value cannot be calculated if D60, D30, and D10 cannot be determined.

cu

Calculated

Coefficient of uniformity. This value cannot be calculated if  D60 and D10 cannot be determined.

 

 

Tables: DT_GEO_RESULT, DT_GEO_TEST, DT_LOCATION, DT_SAMPLE, DT_TASK

 

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

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.