EQuIS Geotech Reports – Shared Attributes

Some of the EQuIS Geotech reports that use Microsoft Excel template files share methods to display different report attributes, including the following:

These methods include various queries that are each associated with a specific EQuIS field name. These queries are stored under an associated field name and can perform calculations, simple decision logic, and incorporate data from database fields. This field name can then be used to populate the output report. These components are determined based on the data available to use for each sample.

This article provides details for each of the Shared Attribute methods, including use of the Name Manager functionality in Excel and the EQuIS source of the information. The Shared Attribute documentation applies to the following EQuIS Geotech reports:

•Atterberg Limits

•Atterberg Limits 3 Point

•Compaction

•Consolidation Compression Curve

•CPT Parameters

•CPT - Pore Pressure Dissipation

•Gradation (Hydrometer) - ASTM D7928

•Gradation (Sieve) - ASTM D6913

•Grain Size Analysis

•Lab Forms

•Lab Summary

•Unconfined Compression

•Unconsolidated Undrained

•Water Content vs. Depth

Note: Some of the listed EQuIS Geotech reports have slightly different or additional Excel Name Manager configurations in the Excel templates, as noted in the corresponding report articles.

Project/Sample Information

Excel Name Manager Field	EQuIS Source	Description
task_code	DT_TASK.TASK_CODE	Project Task Code
task_desc	DT_TASK.TASK_DESC	Project Task Name
project_info	Concatenation of the DT_TASK.TASK_DESC, ‘-’, RT_COMPANY.CITY, ’,’ RT_COMPANY.STATE	Concatenation of Project name with city and state (e.g., 405Bridge – Seattle, Washington)
office_address	Address in RT_COMPANY associated with AT_FACILITY.COMPANY_CODE. This includes RT_COMPANY.ADDRESS_1, RT_COMPANY.CITY, and RT_COMPANY.STATE.	Office in charge of project
office_address_1	RT_COMPANY.ADDRESS_1 for address in RT_COMPANY associated with AT_FACILITY.COMPANY_CODE	First street address line for the office in charge of the project
office_city_state	Concatenation of the RT_COMPANY.CITY, ’,’ RT_COMPANY.STATE for address in RT_COMPANY associated with AT_FACILITY.COMPANY_CODE	City and State of the Office in charge of the project
logo	Queries the image in DT_FILE based on if DT_TASK_PARAMETER.PARAM_CODE = ‘logo’ or ‘alternative_logo’. If ‘alternative_logo’ is null, then the ‘Default’ logo is displayed.	Logo associated with office
site_address	DT_FACILITY.ADDRESS, DT_FACILITY.CITY, DT_FACILITY.STATE	Project site address
address_1	DT_FACILITY.ADDRESS	Project site street address
city_state	DT_FACILITY.CITY, DT_FACILITY.STATE	Project site city and state separated by a comma
client	DT_TASK.CLIENT	Project client name
client_location	DT_TASK_PARAMETER.PARAM_CODE = ‘client_location'	The location of the client (city and state)
symbol		Data icon marker used on plots
sys_loc_code	DT_LOCATION.SYS_LOC_CODE	Location identifier of sample collection
sample_id	DT_SAMPLE.SAMPLE_ID	Additional sample identification information, as necessary
sys_sample_code	DT_SAMPLE.SYS_SAMPLE_CODE	Unique sample identifier
sample_type	DT_SAMPLE.SAMPLE_METHOD	Method of extracting the sample
start_depth	DT_SAMPLE.START_DEPTH	Start depth below ground surface
depth	DT_SAMPLE.START_DEPTH and DT_SAMPLE.END_DEPTH	The sample’s depth range (start depth – end depth)
remark	DT_SAMPLE.REMARK	Remark

USCS Classification (per ASTM D2487)

This shared component automatically determines the appropriate Unified Soil Classification System (USCS) Symbol/Description based on laboratory results from a grain size analysis and an Atterberg limits test as specified by ASTM D2487. This autoclassification can only be executed if sufficient Sieve and Atterberg Limits data are available.

•Override option in DT_SAMPLE_PARAMETER with SAMPLE_DESC or SAMPLE_USCS

Excel Name Manager Field	EQuIS Source	Description
uscs_desc	Automatically calculated or populated from DT_SAMPLE_PARAMETER.PARAM_CODE = ‘samp_classification’	USCS description
uscs_symbol	Automatically calculated or populated from DT_SAMPLE_PARAMETER.PARAM_CODE = ‘sample_uscs’	USCS symbol
uscs_desc_symbol	Automatically calculated	Formatted USCS description with USCS symbol in parenthesis

AASHTO Classification (per ASTM D3282, AASHTO M145)

The American Association of State Highway and Transportation Officials (AASHTO) classification automatically determines the appropriate AASHTO group classification for a sample based on laboratory results from a grain size analysis and an Atterberg limits test. This autoclassification is based on AASHTO M145.

Excel Name Manager Field	EQuIS Source	Description
aashto_classification	Automatically calculated	Autoclassification of AASHTO Group Classification and Group Index
aashto_coarsematerial	Automatically calculated	Determines the percent coarse material based on the AASHTO definition for coarse material (% Coarse Material > 2.0 mm)
aashto_sand	Automatically calculated	Determines the percent sand based on the AASHTO T-88 definition for sand (2.0 mm < % Sand < 0.074 mm)
aashto_fines	Automatically calculated	Determines the percent fines based on the AASHTO T-88 definition for fines (% Fines < 0.075 mm)
aashto_silt	Automatically calculated	Determines the percent silt based on the AASHTO T-88 definition for silt (0.0749 mm < % Silt < 0.002 mm)
aashto_clay	Automatically calculated	Determines the percent clay based on the AASHTO T-88 definition for clay (% Clay < 0.002 mm)

USDA Classification

Excel Name Manager Field	EQuIS Source	Description
usda_classification	Automatically calculated or populated from DT_SAMPLE_PARAMETER.PARAM_CODE = ‘sample desc’	USDA description
usda_sand	Automatically calculated	USDA percent sand
usda_silt	Automatically calculated	USDA percent silt
usda_clay	Automatically calculated	USDA percent clay

Atterberg Limits

The Atterberg Limits Shared Component gathers the Liquid Limit and Plastic Limit values and calculates the Plasticity Index.

•Report will round the LL, PL, PI values to whole numbers in case the data are entered with decimals in the database.

•Nonplastic reporting of Liquid Limit and Plasticity Index: If the value is 0 or below, then it should report the text 'NP'.

Excel Name Manager Field	EQuIS Source	Description
LL	DT_GEO_RESULT.GEO_RESULT_CODE = 'Att_LL' where DT_GEO_TEST.TEST_TYPE = 'Atterberg'	Liquid limit
PL	DT_GEO_RESULT.GEO_RESULT_CODE = 'Att_PL' where DT_GEO_TEST.TEST_TYPE = 'Atterberg'	Plastic limit
PI	Automatically calculated	Calculated plasticity index

Sieve Analysis Results

The Sieve Shared Component determines the percentage of different particle sizes in a sample. This component filters the results based on the selected task and will only display samples that have an associated DT_GEO_TEST table record where TEST_TYPE = ‘Sieve’ and ‘Hydrometer’ when the TEST_METHOD = ‘ASTM D422’, ‘ASTM C136’, or is null.

Excel Name Manager Field	EQuIS Source	Description
fines	SIEVE_PERCENT_FINER or HYD_PERCENT_FINER value associated with SIEVE_DIAMETER or HYD_DIAMETER at 0.075 mm	Percent of material finer than 0.075 mm
cobbles	Automatically calculated	Percent of material between 300 mm to 75 mm (per ASTM D422)
gravel	Automatically calculated	Percent of material between 75 mm to 4.75 mm (per ASTM D422)
sand	Automatically calculated	Percent of material between 4.75 mm to 0.075 mm (per ASTM D422)
silt	Automatically calculated	Percent of material between 0.075 mm to 0.005 mm (per ASTM D422)
clay	Automatically calculated	Percent of material finer than 0.005 mm (per ASTM D422)
hyd7928_silt	Automatically calculated	Determines the percent silt based on the ASTM D7928 definition for silt (0.0749 mm < % Silt < 0.002 mm)
hyd7928_clay	Automatically calculated	Determines the percent clay based on the ASTM D7928 definition for clay (% Clay < 0.002 mm)

Geo Test Information

The Geo test results are from the associated Test record.

Excel Name Manager Field	EQuIS Source	Description
lab_start_test_date	DT_GEO_TEST.TEST_DATE	Test's start date
lab_end_test_date	DT_GEO_TEST.END_DATE	Test's end date
lab_test_technician	DT_GEO_TEST.TECHNICIAN	Name of the testing laboratory/organization
lab_test_lab_code	DT_GEO_TEST.LAB_CODE	Lab code associated with the test

Facility Information

Excel Name Manager Field	EQuIS Source	Description
facility_code	DT_FACILITY.FACILITY_CODE	Facility Code
facility_name	DT_FACILITY.FACILITY_NAME	Facility Name
facility_type	DT_FACILITY.FACILITY_TYPE	Facility Type
facility_manager	DT_FACILITY.PROJECT_MANAGER	Project Manager
facility_start_date	DT_FACILITY.START_DATE	Start Date
facility_client	DT_FACILITY.CLIENT	Client