TESTING PROGRAM AND SUPERVISION PROCEDURES

1. INTRODUCTION

This document outlines the comprehensive testing program and supervision procedures for soil and rock
investigations. It aims to ensure the accuracy, reliability, and consistency of all geotechnical testing activities,
from sample reception to final reporting.
Adherence to these procedures is critical for delivering high-quality factual reports that meet industry
standards and client requirements.

2. SAMPLE MANAGEMENT AND TRACKING

2.1 SAMPLE RECEPTION AND LOGGING

All samples arriving at the laboratory shall be meticulously received and logged into the Sample Reception
system (as detailed in the Sample_Reception sheet of the Excel workbook).
Each sample will be assigned a unique identifier upon arrival, which will be used consistently throughout its
lifecycle within the laboratory.
This unique ID will link physical samples to their digital records, ensuring traceability and preventing mix-
ups. The reception process includes:

Verification of Sample Integrity: Checking for proper packaging, labeling, and any signs of damage or
disturbance during transit.
Discrepancies must be immediately reported and documented.

● Initial Visual Classification: A preliminary visual classification of the soil or rock material, noting
color, texture, consistency, and any unusual features.
This initial assessment aids in determining appropriate handling and testing protocols.

● Weight Measurement: Recording the initial weight of the sample as received.

This is crucial for mass balance calculations in subsequent tests.

● Storage: Samples must be stored under appropriate conditions (e.g., temperature, humidity) to
preserve their in-situ properties until testing.
Undisturbed samples, in particular, require careful handling and storage to minimize changes in their
moisture content and structure.
2.2 SAMPLE IDENTIFICATION AND LABELING
Each sample will be clearly labeled with its unique ID, project name, borehole/trial pit ID, depth, and date of
reception.
This labeling system ensures that samples are correctly identified at every stage of the testing process.
Labels should be durable and resistant to moisture and handling.

2.3 SAMPLE STORAGE AND PRESERVATION

Proper storage is paramount to maintaining the integrity of soil and rock samples.
Samples will be stored in designated areas, segregated by project and type.
Undisturbed samples will be sealed to prevent moisture loss and stored in a humidity-controlled
environment. Disturbed samples will be air-dried or stored in sealed containers as appropriate for their
intended tests.

3. TEST ASSIGNMENT AND SCHEDULING

3.1 REQUIRED TESTS DETERMINATION

Upon reception, the required tests for each sample will be determined based on the material type (soil or
rock) and project specifications.
The Test_Assignment sheet in the Excel workbook will serve as the primary tool for this purpose,
providing a matrix of standard tests required for different material types.
Any deviations from the standard matrix must be approved by the project manager and documented.

3.2 TEST PRIORITIZATION AND SCHEDULING

Tests will be prioritized based on project deadlines, sample stability, and the sequence of dependent tests.
A testing schedule will be developed to optimize laboratory workflow and ensure timely completion of all
required analyses.
The schedule will consider equipment availability, personnel allocation, and curing times for certain tests.
4. GEOTECHNICAL TESTING PROCEDURES

All geotechnical tests will be performed in strict accordance with relevant international standards (e.g.,
ASTM, BS, ISO) and internal quality manuals.
Detailed Standard Operating Procedures (SOPs) will be available for each test, covering equipment
calibration, sample preparation, testing methodology, data recording, and calculation procedures. The
following tests are covered:

4.1 SIEVE ANALYSIS

Purpose: To determine the particle size distribution of coarse-grained soils.
Procedure: Samples are oven-dried, weighed, and then passed through a series of sieves with progressively
smaller openings. The mass retained on each sieve is measured. [1]
Data Recording: Initial dry mass, pan mass, and mass retained on each sieve.
These inputs will be recorded in the Sieve_Analysis sheet of the Excel workbook. Calculations: Percentage
retained, cumulative percentage retained, and percentage passing are calculated. Coefficient of Uniformity
(Cu) and Coefficient of Curvature (Cc) are determined to characterize the soil grading.

4.2 ATTERBERG LIMITS

Purpose: To determine the Liquid Limit (LL), Plastic Limit (PL), and Plasticity Index (PI) of fine-grained soils,
which are critical for soil classification and understanding engineering behavior. Procedure: The LL is
determined using the Casagrande apparatus or cone penetrometer method, measuring the water content at
which a soil transitions from plastic to liquid state.
The PL is determined by rolling a thread of soil until it crumbles, measuring the water content at this point.
[2]
Data Recording: Wet and dry masses of soil for LL and PL tests, number of blows for LL, and optionally, data
for Shrinkage Limit (SL). These inputs will be recorded in the Atterberg_Limits sheet.
Calculations: Water contents, LL, PL, PI, and optionally SL and Liquidity Index (LI). Soil classification
according to the Unified Soil Classification System (USCS) is derived from these values.

4.3 HYDROMETER ANALYSIS

Purpose: To determine the particle size distribution of fine-grained soils (silt and clay fractions). Procedure:
A soil-water suspension is prepared, and a hydrometer is used to measure the density of the suspension at
various time intervals as particles settle. [3]
Data Recording: Mass of soil, specific gravity of solids (Gs), temperature, hydrometer readings at different
times, meniscus correction, and zero correction.
These inputs will be recorded in the Hydrometer sheet.
Calculations: Corrected hydrometer readings, effective depth, particle diameter, and percentage finer. This
data is used to extend the grain size distribution curve from the sieve analysis into the fine-grained range.

4.4 DIRECT SHEAR TEST

Purpose: To determine the shear strength parameters (cohesion, c, and angle of internal friction, φ) of soils
under drained conditions.
Procedure: A soil sample is placed in a shear box, subjected to a normal load, and then sheared at a constant
rate. Shear force and displacement are measured. Multiple tests are performed under different normal loads.
[4] Data Recording: Sample dimensions, normal load, peak shear force, and residual shear force for each
test. These inputs will be recorded in the Direct_Shear sheet. Calculations: Normal stress, peak shear
stress, and residual shear stress. The shear strength parameters (c and φ) are determined from the Mohr-
Coulomb failure envelope plotted from the test results.

4.5 CONSOLIDATION TEST (OEDOMETER TEST)

Purpose: To determine the compressibility and consolidation characteristics of cohesive soils. Procedure: A
soil sample is subjected to incremental vertical loads, and the resulting vertical deformation is measured over
time. [5] Data Recording: Initial sample dimensions, initial void ratio, applied pressure for each load
increment, and dial gauge readings at various time intervals. These inputs will be recorded in the
Consolidation sheet. Calculations: Change in height, void ratio, coefficient of compressibility (av),
coefficient of volume change (mv), compression index (Cc), recompression index (Cr), preconsolidation
pressure (σ’p), and coefficient of consolidation (Cv). These parameters are crucial for settlement predictions.

4.6 SOIL UNIT WEIGHT

Purpose: To determine the bulk and dry unit weight of soil samples. Procedure: Typically involves
measuring the wet mass and volume of a soil sample, followed by oven-drying to determine the dry mass. [6]
Data Recording: Wet mass of soil, dry mass of soil, and volume of soil. These inputs will be recorded in the
Soil_Unit_Weight sheet. Calculations: Water content, bulk unit weight, dry unit weight, void ratio, and
degree of saturation.

4.7 ROCK UNIT WEIGHT

Purpose: To determine the unit weight of rock samples. Procedure: Involves measuring the mass of the rock
sample in air and in water (for saturated surface dry conditions) to determine its volume and density. [7]
Data Recording: Mass of rock in air, mass of rock in water, and optionally, direct measurement of rock
volume. These inputs will be recorded in the Rock_Unit_Weight sheet. Calculations: Bulk unit weight and
dry unit weight.
4.8 POINT LOAD TEST
Purpose: To provide an indirect measure of rock strength, often correlated with Unconfined Compressive
Strength (UCS). Procedure: A rock core or irregular lump is subjected to a concentrated load by two conical
platens until failure. The failure load and distance between platens are recorded. [8] Data Recording: Sample
type (diametral, axial, irregular), failure load, and distance between platens. These inputs will be recorded in
the Point_Load sheet. Calculations: Equivalent core diameter (De), uncorrected point load index (Is), size
correction factor (F), corrected point load index (Is(50)), and estimated UCS.

4.9 UNCONFINED COMPRESSIVE STRENGTH (UCS) TEST

Purpose: To determine the unconfined compressive strength of intact rock or cohesive soil specimens.
Procedure: A cylindrical specimen is subjected to axial compressive load until failure, without lateral
confinement. [9] Data Recording: Sample dimensions (diameter, height) and failure load. These inputs will
be recorded in the UCS sheet. Calculations: Cross-sectional area and unconfined compressive strength (qu).
Stress-strain curves can also be generated if deformation data is collected.

4.10 CHEMICAL ANALYSIS (SO4, CL, TDS)

Purpose: To determine the concentration of specific chemical constituents in soil or water samples that may
affect concrete or steel structures. Procedure: Laboratory chemical analysis methods are used to quantify
Sulphate (So4), Chloride (Cl), and Total Dissolved Solids (TDS) content. [10] Data Recording: Measured
concentrations of So4, Cl, and TDS. These inputs will be recorded in the Chemical_Analysis sheet.
Calculations: Standardization of units if necessary, and assessment of corrosivity based on established
thresholds.

5. SUPERVISION PROCEDURES

Effective supervision is crucial to ensure that all testing procedures are followed correctly and that data is
accurately recorded. Supervision will involve:

5.1 DIRECT OVERSIGHT

Experienced laboratory supervisors will provide direct oversight of all critical testing activities, particularly
during sample preparation, equipment calibration, and the execution of complex tests. This includes:

● Pre-test Briefings: Ensuring that technicians understand the specific requirements of each test,
including any non-standard procedures or critical parameters.

● In-process Checks: Regularly observing testing in progress to verify adherence to SOPs, proper
equipment operation, and correct data acquisition.
 ● Troubleshooting: Providing immediate guidance and support to resolve any technical issues or
unexpected observations during testing.

5.2 DATA VERIFICATION

Supervisors will conduct initial checks of raw data sheets and electronic records for completeness, legibility,
and consistency. This includes:

● Completeness Check: Verifying that all required data points have been recorded for each test.

● Legibility and Clarity: Ensuring that handwritten entries are clear and that electronic data is
properly formatted.

● Consistency Checks: Cross-referencing data points with expected ranges or previous measurements
to identify potential anomalies.

5.3 EQUIPMENT CALIBRATION AND MAINTENANCE

Supervisors are responsible for ensuring that all laboratory equipment is calibrated according to schedule
and maintained in good working order. Calibration records will be meticulously kept and readily accessible.
Regular maintenance checks will be performed to prevent equipment malfunctions that could compromise
test results.

5.4 PERSONNEL TRAINING AND COMPETENCY

Supervisors will assess the competency of laboratory personnel and identify training needs. Regular training
sessions will be conducted to keep staff updated on new testing methodologies, equipment, and quality
control procedures. Only trained and authorized personnel will be permitted to perform specific tests.

6. REFERENCES

[1] ASTM D422/D422M-63(2007)e2, Standard Test Method for Particle-Size Analysis of Soils. [2] ASTM
D4318-17, Standard Test Methods for Liquid Limit, Plastic Limit, and Plasticity Index of Soils. [3] ASTM
D7928-17, Standard Test Method for Particle-Size Distribution (Gradation) of Fine-Grained Soils Using the
Hydrometer Analysis. [4] ASTM D3080/D3080M-11, Standard Test Method for Direct Shear Test of Soils
Under Consolidated Drained Conditions. [5] ASTM D2435/D2435M-11, Standard Test Methods for One-
Dimensional Consolidation Properties of Soils Using Incremental Loading. [6] ASTM D2937-00, Standard Test
Method for Density of Soil in Place by the Drive-Cylinder Method. [7] ASTM D7263-09, Standard Test
Methods for Laboratory Determination of Density (Unit Weight) of Soil and Rock in Place by the Sand-Cone
Method. [8] ASTM D5731-08, Standard Test Method for Determination of the Point Load Strength Index of
Rock and Application to Other Rock Strength Tests. [9] ASTM D2938-95, Standard Test Method for
Unconfined Compressive Strength of Intact Rock Core Specimens. [10] ASTM D516-11, Standard Test Method
for Sulfate Ion in Water.

2.4 SAMPLE FLOW AND CHAIN OF CUSTODY

To maintain the integrity and traceability of samples, a strict chain of custody protocol will be followed. From
the moment a sample is received until its final disposal, every transfer of custody will be documented,
including the date, time, and signatures of both the relinquishing and receiving parties. This ensures an
unbroken record of accountability and provides a verifiable audit trail for all samples. The chain of custody
form will accompany the samples throughout their journey in the laboratory, from initial logging to individual
test stations and finally to storage or disposal. Any discrepancies or deviations from the established chain of
custody procedures will be immediately investigated and documented, with corrective actions implemented
to prevent recurrence.

2.5 SAMPLE DISPOSAL AND ARCHIVING

Upon completion of all required testing and reporting, samples will be either disposed of or archived for
future reference, as per project requirements and laboratory policies. Disposal will be conducted in an
environmentally responsible manner, adhering to all applicable regulations. Archived samples will be
properly labeled and stored in a secure location for a specified retention period, allowing for re-testing or
further analysis if necessary. The archiving process will include a detailed inventory of stored samples, their
locations, and the date of archiving, ensuring efficient retrieval when needed.

3. TEST ASSIGNMENT AND SCHEDULING (CONTINUED)

3.3 DYNAMIC TEST ASSIGNMENT USING EXCEL WORKBOOK

The Test_Assignment sheet in the Excel workbook is designed to dynamically assign required tests based
on the material type and user-defined criteria. This sheet will function as a central control panel for test
selection, allowing laboratory personnel to quickly identify the necessary tests for each incoming sample. The
structure of this sheet will include:

● Material Type Column: A dropdown list (Soil, Rock) to categorize the sample.

● Test Name Column: A comprehensive dropdown list of all available geotechnical tests (Sieve
Analysis, Atterberg Limits, Hydrometer, Direct Shear, Consolidation, Soil Unit Weight, Rock Unit
Weight, Point Load, UCS, So4, Cl, TDS).
 ● Required Column: A dropdown (Yes, No) to indicate whether a specific test is mandated for the
selected material type. This allows for flexibility in test selection based on project-specific needs or
client requests.

This dynamic assignment system minimizes manual errors and ensures that all relevant tests are considered
for each sample. Furthermore, it provides a clear, auditable record of test assignments, which is crucial for
quality control and project management. The Excel workbook will leverage XLOOKUP or INDEX/MATCH
functions to automatically pull required test information into other relevant sheets, streamlining the
workflow and reducing data entry redundancy.

3.4 RESOURCE ALLOCATION AND LOAD BALANCING

Effective scheduling extends beyond simply listing tests; it involves optimizing resource allocation. This
includes:

● Personnel Availability: Matching test requirements with the skills and certifications of available
technicians. Complex tests requiring specialized expertise will be assigned to appropriately qualified
personnel.

● Equipment Utilization: Ensuring that high-demand equipment (e.g., consolidation frames, direct
shear machines) is scheduled efficiently to maximize throughput and minimize idle time. Preventive
maintenance schedules will be integrated into the overall planning to avoid unexpected downtime.

● Laboratory Space: Managing the allocation of bench space and specialized testing areas to prevent
overcrowding and ensure a safe working environment. This is particularly important for tests
requiring specific environmental conditions or large setups.

● Sample Throughput: Establishing realistic targets for the number of samples that can be processed
within a given timeframe, considering the complexity and duration of each test. This helps in setting
achievable deadlines and managing client expectations.

By carefully balancing these factors, the laboratory can maintain a steady workflow, reduce turnaround
times, and deliver results efficiently without compromising quality. Regular reviews of the testing schedule
will be conducted to identify bottlenecks and adjust resource allocation as needed.
4. GEOTECHNICAL TESTING PROCEDURES (CONTINUED)

4.1.1 SIEVE ANALYSIS: DETAILED PROCEDURE AND QUALITY CONTROL

The sieve analysis is a fundamental test for granular soils, providing crucial data for classification and
engineering design. The detailed procedure involves several critical steps to ensure accuracy:

1. Sample Preparation: The soil sample is first air-dried or oven-dried at a temperature not exceeding
60°C to prevent alteration of clay minerals. After drying, the sample is disaggregated to break down
any lumps, ensuring that individual particles can pass through the sieves. The entire sample is then
weighed to determine the initial dry mass [1]. This initial mass is a critical input for calculating the
percentage retained and passing on each sieve.

2. Sieving Process: A stack of standard sieves, arranged in descending order of opening size from top
to bottom, is used. A pan is placed at the bottom to collect the finest particles. The dried and
disaggregated soil sample is placed on the top (largest) sieve, and the stack is subjected to
mechanical shaking for a specified duration (e.g., 10-15 minutes) to ensure complete separation of
particles. Manual shaking may be used for specific fractions to ensure thorough separation without
damaging particles.

3. Mass Measurement: After shaking, the mass of soil retained on each sieve and in the pan is carefully
weighed. It is crucial to ensure that the sum of the masses retained on all sieves and in the pan is
approximately equal to the initial dry mass of the sample. A deviation of more than 0.2% is typically
considered unacceptable and warrants re-sieving or investigation into potential mass loss [1].

4. Data Recording and Calculation: The individual masses retained are recorded in the
Sieve_Analysis sheet of the Excel workbook. The workbook then automatically calculates:

● Cumulative Mass Retained: The sum of masses retained on a given sieve and all coarser
sieves above it.

● Percentage Retained: The mass retained on each sieve as a percentage of the total initial
dry mass.

● Percentage Passing: The percentage of soil passing through each sieve, calculated as 100%
minus the cumulative percentage retained. This is the primary output used for plotting the
grain size distribution curve.

5. Quality Control: Regular checks of sieve calibration are performed to ensure the accuracy of sieve
openings. Duplicate tests are conducted periodically to assess repeatability. The sum of retained
 masses is always compared to the initial sample mass to ensure mass balance. Any significant
discrepancies trigger a re-evaluation of the testing process.

4.2.1 ATTERBERG LIMITS: DETAILED PROCEDURE AND QUALITY CONTROL

Atterberg Limits tests are fundamental for classifying fine-grained soils and understanding their engineering
behavior, particularly their consistency and plasticity. The procedures for Liquid Limit (LL) and Plastic Limit
(PL) are detailed below:

1. Sample Preparation: A representative portion of the soil sample is air-dried and then pulverized to
break down aggregations. For the Liquid Limit test, the soil is mixed with distilled water to form a
paste. For the Plastic Limit test, a smaller portion is mixed to a consistency where it can be rolled into
a thread.

2. Liquid Limit (LL) Determination: The Casagrande apparatus is commonly used. A portion of the
soil paste is placed in the cup, a groove is cut through the paste, and the cup is repeatedly dropped
from a standard height until the groove closes over a specified length (e.g., 13 mm) [2]. The number
of blows required to close the groove is recorded, and a small portion of the soil is taken for water
content determination. This process is repeated for at least three different water contents, aiming for
blow counts between 15 and 35. The Liquid Limit is then determined graphically as the water
content corresponding to 25 blows.

3. Plastic Limit (PL) Determination: A small soil sample is rolled into a thread approximately 3 mm in
diameter. The rolling continues until the thread crumbles when it reaches a diameter of about 3 mm
[2]. The water content of the crumbled soil is then determined. This procedure is repeated at least
twice, and the average water content is reported as the Plastic Limit.

4. Data Recording and Calculation: All wet and dry masses, container IDs, and number of blows are
meticulously recorded in the Atterberg_Limits sheet. The Excel workbook automatically calculates:

● Water Content: For each trial of LL and PL.

● Liquid Limit (LL): Determined by linear interpolation or a best-fit line from the plot of
water content versus the logarithm of the number of blows.

● Plastic Limit (PL): The average of the water contents from the plastic limit trials.

● Plasticity Index (PI): Calculated as the difference between the Liquid Limit and the Plastic
Limit (PI = LL - PL). This index quantifies the range of water content over which the soil
behaves plastically.
 ● Shrinkage Limit (SL): If the optional SL test is performed, the change in volume and mass
during drying is used to calculate the water content at which no further volume change
occurs upon drying.

● Liquidity Index (LI): Calculated using the natural water content of the soil (if available), LL,
and PL. It indicates the consistency of the soil in its natural state.

● USCS Classification: The workbook provides a simplified classification based on the

calculated LL and PI values, aiding in preliminary soil identification.

5. Quality Control: Regular calibration of the Casagrande apparatus (drop height, cup wear) is
essential. Consistency in rolling technique for the PL test is maintained through technician training
and periodic checks. Duplicate tests are performed to ensure repeatability, and results are compared
against expected ranges for similar soil types.

4.3.1 HYDROMETER ANALYSIS: DETAILED PROCEDURE AND QUALITY CONTROL

The hydrometer analysis is used to determine the particle size distribution of the fine-grained portion of a
soil sample (silt and clay), complementing the sieve analysis for a complete gradation curve.

1. Sample Preparation: A representative soil sample (typically the portion passing the No. 200 sieve)
is dispersed in distilled water using a mechanical stirrer or air-jet disperser. A dispersing agent (e.g.,
sodium hexametaphosphate) is added to prevent flocculation of clay particles [3]. The suspension is
then transferred to a sedimentation cylinder and brought to a standard volume.

2. Sedimentation and Reading: The sedimentation cylinder is thoroughly agitated to ensure a uniform
suspension. Immediately after agitation, a hydrometer is carefully inserted into the suspension, and
readings are taken at predetermined time intervals (e.g., 0.25, 0.5, 1, 2, 4, 8, 15, 30 minutes, 1, 2, 4, 8,
24, 48 hours). The temperature of the suspension is also recorded at each reading, as it affects the
density and viscosity of water.

3. Corrections: Hydrometer readings require several corrections:

● Meniscus Correction (Cm): Due to the surface tension of water, the hydrometer reading is
typically taken at the top of the meniscus. A correction is applied to obtain the reading at the
true liquid level.

● Zero Correction (Cz): Determined by taking a reading in a blank solution (distilled water
with dispersing agent) to account for any calibration errors of the hydrometer.
 ● Temperature Correction: Applied to account for variations in the density and viscosity of
water at different temperatures, ensuring that calculations are based on standard
conditions.

4. Data Recording and Calculation: All raw hydrometer readings, temperatures, and corrections are
entered into the Hydrometer sheet. The Excel workbook performs the following calculations:

● Corrected Hydrometer Reading (Rc): The raw reading adjusted for meniscus and zero
corrections.

● Effective Depth (L): The depth corresponding to the corrected hydrometer reading, which
represents the distance through which particles have settled. This value is typically obtained
from a calibration chart or table for the specific hydrometer used.

● Particle Diameter (D): Calculated using Stokes' Law, which relates the settling velocity of
particles to their diameter, the density and viscosity of the fluid, and the density of the
particles. The formula used is D = SQRT((18 * Viscosity * L) / (9810 * (Gs - 1) *
Density_of_Water)), where Viscosity and Density_of_Water are temperature-dependent
values obtained from the Lookups sheet.

● Percentage Finer (%): Calculated based on the corrected hydrometer reading, the mass of
soil in suspension, and the specific gravity of solids (Gs). This represents the percentage of
particles finer than the calculated diameter D.

5. Quality Control: Regular calibration of hydrometers and thermometers is essential. The dispersing
agent concentration is carefully controlled. Duplicate tests are performed to check repeatability,
especially for samples with high clay content. The combined grain size distribution curve (from sieve
and hydrometer analyses) is checked for smoothness and logical progression.

4.4.1 DIRECT SHEAR TEST: DETAILED PROCEDURE AND QUALITY CONTROL

The direct shear test is widely used to determine the shear strength parameters (cohesion and angle of
internal friction) of granular and cohesive soils under drained conditions. It is a relatively quick and simple
test, making it suitable for routine investigations.

1. Sample Preparation: A representative soil sample is prepared and placed in a two-piece shear box.
For cohesive soils, undisturbed samples are preferred, while for granular soils, compacted or loose
samples can be prepared to simulate field conditions. The sample dimensions (typically 60x60 mm
or 100x100 mm square) are accurately measured to determine the shear area [4]. Porous stones are
placed at the top and bottom of the sample to allow drainage.
 2. Loading and Shearing: A predetermined normal load is applied to the sample, simulating the
overburden pressure in the field. The sample is then allowed to consolidate under this normal load
(for cohesive soils). Once consolidation is complete, the two halves of the shear box are separated
horizontally at a constant rate of displacement. The shear force required to cause failure and the
corresponding horizontal displacement are continuously measured.

3. Multiple Tests: To determine both cohesion (c) and the angle of internal friction (φ), at least three
tests are performed on identical samples under different normal loads. This allows for the
establishment of a failure envelope.

4. Data Recording and Calculation: The normal load, peak shear force, and residual shear force for
each test are recorded in the Direct_Shear sheet. The Excel workbook performs the following
calculations:

● Normal Stress (σ): Calculated by dividing the normal load by the sample's cross-sectional
area (σ = Normal Load / Area). Units are typically converted to kPa.

● Peak Shear Stress (τ_peak): Calculated by dividing the peak shear force by the sample's
cross-sectional area (τ_peak = Peak Shear Force / Area). This represents the maximum
shear resistance mobilized by the soil.

● Residual Shear Stress (τ_residual): Calculated by dividing the residual shear force (the
shear force after significant displacement, where resistance stabilizes) by the sample's
cross-sectional area. This represents the shear strength of the soil after large deformations.

● Angle of Internal Friction (φ): Determined from the slope of the failure envelope plotted
as shear stress versus normal stress. For peak strength, the peak shear stresses are plotted
against their corresponding normal stresses. For residual strength, the residual shear
stresses are used. The angle φ is calculated as
DEGREES(ATAN(SLOPE(Shear_Stress_Range, Normal_Stress_Range))).

● Cohesion (c): Determined from the y-intercept of the failure envelope. It represents the
shear strength at zero normal stress. The cohesion c is calculated as
INTERCEPT(Shear_Stress_Range, Normal_Stress_Range).

5. Quality Control: Regular calibration of load cells and displacement transducers is crucial. Sample
preparation techniques are standardized to ensure consistent density and moisture content. The rate
of shearing is carefully controlled to ensure drained conditions for the test. Visual inspection of the
failure plane after the test provides valuable insights into the shear mechanism.

4.5.1 CONSOLIDATION TEST: DETAILED PROCEDURE AND QUALITY CONTROL

The one-dimensional consolidation (oedometer) test is essential for predicting the magnitude and rate of
settlement of structures built on cohesive soils. It provides critical parameters related to soil compressibility
and permeability.

1. Sample Preparation: An undisturbed cylindrical soil sample is carefully trimmed and placed into a
rigid consolidation ring. Porous stones are placed above and below the sample to allow for drainage,
and the entire assembly is saturated with water [5]. The initial dimensions (diameter and height)
and initial void ratio of the sample are accurately determined.

2. Incremental Loading: The sample is subjected to a series of incrementally increasing vertical loads
(pressures). Each load increment is typically maintained for 24 hours (or until primary consolidation
is complete) to allow the sample to fully compress and expel pore water. During each load increment,
the vertical deformation of the sample is measured at various time intervals using a dial gauge or
displacement transducer (e.g., 0, 0.25, 0.5, 1, 2, 4, 8, 15, 30 minutes, 1, 2, 4, 8, 24 hours).

3. Unloading: After the maximum load is applied, the sample is incrementally unloaded, and rebound
readings are taken to determine the recompression characteristics of the soil.

4. Data Recording and Calculation: All applied pressures, dial gauge readings at different times, and
initial sample properties are recorded in the Consolidation sheet. The Excel workbook performs
extensive calculations:

● Change in Height (ΔH): The total vertical deformation for each load increment.

● Void Ratio (e): Calculated at the end of each load increment. The change in void ratio is
directly related to the change in height and the initial void ratio.

● Coefficient of Compressibility (av): Represents the change in void ratio per unit change in
effective stress. Calculated as (Δe / Δσ').

● Coefficient of Volume Change (mv): Represents the change in volume per unit volume per
unit change in effective stress. Calculated as av / (1 + e0).

● Compression Index (Cc): The slope of the virgin compression curve (e-log σ' plot). It
quantifies the compressibility of the soil under normally consolidated conditions. This is
typically determined by plotting the void ratio against the logarithm of effective stress and
finding the slope of the linear portion of the curve.

● Recompression Index (Cr): The slope of the recompression curve (e-log σ' plot) during
unloading and reloading. It indicates the compressibility of the soil under overconsolidated
conditions.
 ● Preconsolidation Pressure (σ’p): The maximum effective stress to which a soil has been
subjected in the past. It is a critical parameter for settlement analysis and is typically
determined graphically from the e-log σ' curve using Casagrande's method.

● Coefficient of Consolidation (Cv): A measure of how quickly a soil consolidates. It is

determined from the time-deformation curves for each load increment using methods like
the square root of time method or the logarithm of time method. The formula for the square
root of time method is Cv = (0.197 * H_dr^2) / t50, where H_dr is the drainage path and
t50 is the time for 50% primary consolidation.

● Time Factor (Tv): A dimensionless parameter used in consolidation theory, related to Cv,
time, and drainage path.

5. Quality Control: Maintaining sample saturation throughout the test is critical. Accurate
measurement of initial sample dimensions and dial gauge readings is essential. The loading sequence
and duration for each increment must strictly follow the standard. Regular calibration of the loading
system and dial gauges is performed. Duplicate tests are conducted for critical samples to ensure
reliability of results.

4.6.1 SOIL UNIT WEIGHT: DETAILED PROCEDURE AND QUALITY CONTROL

Unit weight is a fundamental property of soil, essential for calculating stresses, bearing capacity, and stability.
Both bulk (wet) and dry unit weights are commonly determined.

1. Sample Collection: For undisturbed samples, a known volume (e.g., from a core cutter or Shelby
tube) is collected. For disturbed samples, a representative portion is taken. The wet mass of the
sample is determined immediately after collection to minimize moisture loss [6].

2. Volume Determination: The volume of the soil sample can be determined by various methods:

● Core Cutter Method: For cohesive soils, a cylindrical core cutter of known volume is driven
into the soil, and the excess soil is trimmed. The volume of the soil in the cutter is equal to
the cutter's volume.

● Sand Replacement Method: For granular soils, a hole of known volume is excavated, and
the volume is determined by filling it with sand of known density.

● Water Displacement: For irregular samples, the volume can be determined by water
displacement (Archimedes' principle).

3. Dry Mass Determination: The entire wet soil sample is then oven-dried at 105 ± 5°C until a
constant mass is achieved. This ensures all free water is removed. The dry mass is then recorded.
 4. Data Recording and Calculation: The wet mass, dry mass, and volume of the soil are recorded in
the Soil_Unit_Weight sheet. The Excel workbook calculates:

● Water Content (w): The ratio of the mass of water to the mass of solids, expressed as a
percentage: w = ((Wet Mass - Dry Mass) / Dry Mass) * 100%.

● Bulk Unit Weight (γb): The total weight of the soil per unit volume: γb = (Wet Mass /
Volume) * g, where g is the acceleration due to gravity (9.81 kN/m³). The workbook
converts this to kN/m³.

● Dry Unit Weight (γd): The weight of soil solids per unit volume: γd = (Dry Mass /
Volume) * g. The workbook converts this to kN/m³.

● Void Ratio (e): The ratio of the volume of voids to the volume of solids. Calculated using the
dry unit weight, specific gravity of solids (Gs), and unit weight of water: e = (Gs * γw / γd)
- 1. The Gs value is typically obtained from the Lookups sheet.

● Degree of Saturation (S): The ratio of the volume of water to the volume of voids,
expressed as a percentage: S = (w * Gs / e) * 100%.

5. Quality Control: Accurate mass and volume measurements are paramount. Oven temperature
calibration is checked regularly. Duplicate tests are performed to ensure repeatability, especially for
critical samples. The consistency of results with visual classification and other index properties is
also reviewed.

4.7.1 ROCK UNIT WEIGHT: DETAILED PROCEDURE AND QUALITY CONTROL

Determining the unit weight of rock is important for rock mass classification, stability analysis, and material
quantity estimations. The procedure often involves water displacement methods due to the irregular shapes
of rock samples.

1. Sample Preparation: A representative rock sample, ideally intact and free from significant fractures,
is selected. The sample should be cleaned of any loose material.

2. Mass in Air: The mass of the rock sample in air is accurately measured using a balance [7].

3. Mass in Water: The sample is then submerged in water, and its mass while suspended in water is
measured. This is typically done by suspending the sample from a balance into a water bath. Care is
taken to ensure no air bubbles are trapped on the sample surface.
 4. Volume Calculation: The volume of the rock sample is determined using Archimedes' principle:
Volume = (Mass in Air - Mass in Water) / Density of Water. The density of water is typically
taken as 1 g/cm³ or 1000 kg/m³.

5. Data Recording and Calculation: The mass in air, mass in water, and optionally, directly measured
volume are recorded in the Rock_Unit_Weight sheet. The Excel workbook calculates:

● Calculated Volume of Rock: If a direct volume measurement is not provided, the workbook
calculates it from the mass in air and mass in water. The formula =(B2-C2)/1 assumes the
density of water is 1 g/cm³.

● Bulk Unit Weight (γb): The total weight of the rock per unit volume: γb = (Mass in Air /
Volume) * g. The workbook converts this to kN/m³.

6. Quality Control: Accurate mass measurements are crucial. Ensuring complete saturation of the
sample (if required for saturated unit weight) and removal of air bubbles during submerged
weighing are important. Regular calibration of the balance is performed. The consistency of results
with rock type and visual observations is reviewed.

4.8.1 POINT LOAD TEST: DETAILED PROCEDURE AND QUALITY CONTROL

The Point Load Test is a simple and quick index test used to estimate the strength of rock materials,
particularly useful for field assessments and preliminary strength classification. It is an indirect measure of
rock strength and can be correlated with UCS.

1. Sample Preparation: The test can be performed on rock core specimens (diametral or axial tests) or
on irregular rock lumps. For core specimens, the ends should be relatively flat. For irregular lumps,
the bearing surfaces should be roughly parallel [8]. The distance between the platens (D) is
measured.

2. Loading: The sample is placed between two conical platens of a point load testing machine. A load is
applied at a constant rate until the sample fails. The failure load (P) is recorded.

3. Multiple Tests: Multiple tests (typically 5-10) are performed on similar samples to obtain a
representative average and to account for natural variability in rock strength.

4. Data Recording and Calculation: The sample type, failure load (P), and distance between platens
(D) are recorded in the Point_Load sheet. The Excel workbook performs the following calculations:

● Equivalent Core Diameter (De): This is a critical parameter that normalizes the test results
for different sample sizes and shapes. For diametral tests, De = D. For axial tests, De is
calculated based on the sample diameter and length. For irregular samples, De is calculated
 as SQRT(D * Width), where 'Width' is the dimension perpendicular to D. The workbook
uses a lookup value from the Lookups sheet for 'Width' for irregular samples.

● Uncorrected Point Load Index (Is): Calculated as Is = P / De^2. This value is dependent
on the sample size.

● Size Correction Factor (F): A factor applied to Is to normalize the results to a standard
equivalent core diameter (typically 50 mm). This factor is obtained from empirical charts or
formulas and is typically looked up from the Lookups sheet based on De.

● Corrected Point Load Index (Is(50)): Calculated as Is(50) = Is * F. This is the primary
output of the test and represents the point load strength normalized to a 50 mm equivalent
core diameter.

● Estimated UCS: The Is(50) value can be correlated to the Unconfined Compressive Strength
(UCS) using an empirical conversion factor. The workbook calculates Estimated UCS =
Is(50) * Conversion Factor, where the Conversion Factor is obtained from the Lookups
sheet.

5. Quality Control: Regular calibration of the point load testing machine and load cell is essential. The
platens should be inspected for wear and replaced if necessary. Sample preparation and
measurement of D are critical for accurate results. Outlier results should be identified and
investigated, potentially using statistical methods like Dixon's Q-test (though the provided VBA
function for Dixon's test is for general outlier detection and would need to be integrated and applied
carefully, noting that the 'UCS knows eg.30' condition should be neglected as per best practices).

4.9.1 UNCONFINED COMPRESSIVE STRENGTH (UCS) TEST: DETAILED PROCEDURE AND

QUALITY CONTROL
The Unconfined Compressive Strength (UCS) test is a fundamental laboratory test for determining the
compressive strength of intact rock core specimens and cohesive soil samples. It is a direct measure of
strength and is widely used in geotechnical design.

1. Sample Preparation: Cylindrical rock core specimens or undisturbed cohesive soil samples are
prepared with a length-to-diameter ratio typically between 2.0 and 2.5. The ends of the specimen
must be cut flat and parallel to ensure uniform load application [9]. The diameter and height of the
specimen are accurately measured.

2. Loading: The prepared specimen is placed in a compression testing machine. An axial compressive
load is applied at a constant rate of strain or stress until the specimen fails. The maximum load
sustained by the specimen is recorded as the failure load.
 3. Data Recording and Calculation: The sample diameter, height, and failure load are recorded in the
UCS sheet. The Excel workbook calculates:

● Cross-sectional Area: Calculated as PI() * (Diameter/2)^2.

● Unconfined Compressive Strength (UCS): Calculated by dividing the failure load by the
cross-sectional area: ucs = Failure Load / Cross-sectional Area. The result is typically
expressed in kPa or MPa.

● Axial Strain: If a displacement transducer is used to measure axial deformation during the
test, axial strain can be calculated as (Change in Height / Initial Height) * 100%. This
allows for the plotting of stress-strain curves, which provide additional information on the
elastic modulus and post-peak behavior of the material.

4. Quality Control: Accurate trimming and measurement of specimens are crucial. The loading rate
must be controlled to ensure consistent test conditions. Regular calibration of the compression
testing machine and load cell is performed. Visual inspection of the failure mode (e.g., shear failure,
axial splitting) provides valuable insights into the material's behavior. Duplicate tests are conducted
to assess repeatability.

4.10.1 CHEMICAL ANALYSIS (SO4, CL, TDS): DETAILED PROCEDURE AND QUALITY CONTROL
Chemical analysis of soil and water samples is critical for assessing the potential corrosivity of the ground to
buried concrete and steel structures. The determination of Sulphate (So4), Chloride (Cl), and Total Dissolved
Solids (TDS) are key parameters.

1. Sample Collection and Preservation: Soil and water samples for chemical analysis must be
collected in appropriate containers and preserved according to standard methods to prevent
chemical changes. For example, water samples for TDS may require refrigeration, and samples for
sulfate and chloride analysis may need to be filtered [10].

2. Laboratory Analysis: The collected samples are sent to a specialized chemical laboratory for
analysis. Various analytical techniques are employed:

● Sulphate (So4): Typically determined by gravimetric methods (precipitation as barium

sulfate) or turbidimetric methods (measuring turbidity caused by barium sulfate
precipitation) [10]. Ion chromatography can also be used.

● Chloride (Cl): Commonly determined by titration with silver nitrate (Mohr method) or by
ion chromatography.
 ● Total Dissolved Solids (TDS): Determined by filtering a water sample, evaporating the
filtrate to dryness, and weighing the residue. For soil, a water extract is typically prepared,
and the TDS of the extract is measured.

3. Data Recording and Calculation: The measured concentrations of So4, Cl, and TDS are recorded in
the Chemical_Analysis sheet. The Excel workbook performs the following:

● Standardization of Units: If the input units differ from the desired reporting units (e.g.,
mg/kg to %), conversion factors from the Lookups sheet are applied.

● Corrosivity Assessment: Based on the standardized concentrations, the workbook

provides a preliminary corrosivity assessment (e.g., Mild, Moderate, Severe) for concrete or
steel. This assessment is based on predefined thresholds for each chemical, which are stored
in the Lookups sheet. For example, IF(So4_Content > Lookups!$K$2, "Severe",
IF(So4_Content > Lookups!$L$2, "Moderate", "Mild")).

4. Quality Control: Regular calibration of laboratory instruments (e.g., spectrophotometers, titrators)

is essential. Certified reference materials are used to verify the accuracy of analytical methods.
Duplicate analyses are performed on a percentage of samples to assess precision. Inter-laboratory
comparisons (round-robin tests) are also conducted to ensure consistency across different
laboratories.

5.5 DOCUMENTATION AND REPORTING

Supervisors are responsible for reviewing and approving all raw data sheets, calculation sheets, and
preliminary test reports before they are finalized. This includes verifying that all data is accurately
transcribed, calculations are correct, and reporting formats adhere to established templates. Any
discrepancies or errors identified during this review process will be immediately addressed and corrected.
Supervisors will also ensure that all relevant documentation, including calibration records, training logs, and
quality control charts, are properly maintained and readily accessible for audits.

5.6 CORRECTIVE AND PREVENTIVE ACTIONS

In the event of non-conforming work or deviations from established procedures, supervisors will initiate
corrective and preventive actions. This involves investigating the root cause of the non-conformance,
implementing immediate corrective measures to address the issue, and developing preventive actions to
avoid recurrence. All corrective and preventive actions will be documented, and their effectiveness will be
monitored over time. This proactive approach to quality management ensures continuous improvement in
laboratory operations.
6. REFERENCES

[1] ASTM D422/D422M-63(2007)e2, Standard Test Method for Particle-Size Analysis of Soils.
[[Link] [2] ASTM D4318-17, Standard Test Methods for
Liquid Limit, Plastic Limit, and Plasticity Index of Soils. [[Link] [3] ASTM
D7928-17, Standard Test Method for Particle-Size Distribution (Gradation) of Fine-Grained Soils Using the
Hydrometer Analysis. [[Link] [4] ASTM D3080/D3080M-11, Standard Test
Method for Direct Shear Test of Soils Under Consolidated Drained Conditions.
[[Link] [5] ASTM D2435/D2435M-11, Standard Test Methods for
One-Dimensional Consolidation Properties of Soils Using Incremental Loading.
[[Link] [6] ASTM D2937-00, Standard Test Method for Density of
Soil in Place by the Drive-Cylinder Method. [[Link] [7] ASTM D7263-09,
Standard Test Methods for Laboratory Determination of Density (Unit Weight) of Soil and Rock in Place by
the Sand-Cone Method. [[Link] [8] ASTM D5731-08, Standard Test Method
for Determination of the Point Load Strength Index of Rock and Application to Other Rock Strength Tests.
[[Link] [9] ASTM D2938-95, Standard Test Method for Unconfined
Compressive Strength of Intact Rock Core Specimens. [[Link] [10] ASTM
D516-11, Standard Test Method for Sulfate Ion in Water. [[Link]