Bearing Capacity of Shallow Foundations: Indian Code IS6403

  • Bearing Capacity Calculator: Terzaghi’s Method
  • Professional Excel Spreadsheets (GEOtExcel)
  • Ultimate Bearing Capacity Calculation – Academic Education Focus
  • Ultimate Bearing Capacity Calculation (Design) as per IS 6403 Code
  • Beyond IS 6403: Technical Critique & Recommendations for Bearing Capacity Estimation by GEOtExcel

CODE OF PRACTICE FOR DETERMINATION OF BEARING CAPACITY OF SHALLOW FOUNDATIONS




2.1.1 Net Loading Intensity — The net loading intensity on the foundation is the gross intensity of loading minus the weight of displaced soil above the foundation base.

2.1.2 Ultimate Bearing Capacity — The intensity of loading at the base of the foundation which would cause shear failure of the soil support.

2.1.3 Safe Bearing Capacity — Maximum intensity of loading that the foundation will safely carry without the risk of shear failure of soil irrespective of any settlement that may occur.

2.1.4 Safe Bearing Pressure or Net Soil Pressure for Specified Settlement — The intensity of loading that will cause a permissible settlement or specified settlement of the structure.

2.2.1 Density Index (Relative Density) — The ratio of the difference between the void ratios of cohesionless soil in the loosest state and any given state to the difference between its void ratios at the loosest and densest states.

2.2.2 Effective Surcharge at the Base Level of Foundation — The intensity of vertical pressure at the base level of foundation, computed assuming total unit weight for the portion of soil above the water table and submerged unit weight for the portion below the water table.

2.2.3 Footing — A structure constructed in brickwork, masonry or concrete under the base of a wall or column for the purpose of distributing the load over a larger area.


نماد (Symbol) (Meaning) (Unit)
AArea of footingcm2
AEffective area of footingcm2
BWidth of strip footing, width of footing, side of square footing, diameter of circular footingcm
BEffective width of footingcm
bHalf of BBcm
cCohesionkgf/cm2
ε1Undrained cohesion of the top layerkgf/cm2
ε2Undrained cohesion of the lower clay layerkgf/cm2
DfDepth of foundationcm
DwDepth to water tablecm
ddDepth of top clay layer with undrained cohesion ε1ε1​cm
dc,dq,dγDepth factors
eEccentricity of loadingcm
eBEccentricity of loading along the widthcm
eLEccentricity of loading along the lengthcm
HHorizontal component of loadingkgf
ic,iq,iγInclination factors
KdDepth factor (varies linearly from 1 for depth Df=0Df​=0 to 1.33 for depth Df=BDf​=B)
LLength of footingcm
LEffective length of footingcm
NCorrected standard penetration value
Nc,Nq,Nγ,Nc,Nq,NγBearing capacity factors
Nϕtan2(π/4+ϕ/2)tan2(π/4+ϕ/2)
qEffective surcharge at the base level of foundationkgf/cm2
qaNet soil pressure for a specified settlement of 25 mmkgf/cm2
qcStatic cone penetration resistancekgf/cm2
qdNet ultimate bearing capacity based on general shear failurekgf/cm2
qdNet ultimate bearing capacity based on local shear failurekgf/cm2
DrRelative density of soil
WCorrection factor for location of water table
sc,sq,sγShape factors
αInclination of the load to the verticaldegrees
ϕAngle of shearing resistance of soildegrees
γBulk unit weight of foundation soilkgf/cm3


General Shear Failure

Local Shear Failure

Calculation for Cohesive-Frictional, Cohesionless and Cohesive Soils


a) Single Eccentricity — If the load has an eccentricity e, with respect to the centroid of the foundation in only one direction, then the dimension of the footing in the direction of eccentricity shall be reduced by a length equal to 2e. The modified dimension shall be used in the bearing capacity equation and in determining the effective area of the footing in resisting the load.

b) Double Eccentricity — If the load has double eccentricity with respect to the centroid of the footing then the effective dimensions of the footing to be used in determining the bearing capacity as well as in computing the effective area of the footing in resisting the load shall be determined as given below: ​ A′=L′×B

L=L2eLB=B2eB


a) In case of general shear failureqd=cNc+γDf(Nq1)+0.5γBNγ

b) In case of local shear failureqd=23cNc+γDf(Nq1)+0.5γBNγ

The values of Nc,Nc,Nq,Nq,Nγ and Nγ​ may be obtained from Table 1.

TABLE 1: BEARING CAPACITY FACTORS

ϕ (Degrees)​
N
c

NqNγ
05.141.000.00
56.491.570.45
108.352.471.22
1510.983.942.65
2014.836.405.39
2520.7210.6610.88
3030.1418.4022.40
3546.1233.3048.03
4075.3164.20109.41
45138.88134.88271.76
50266.89319.07762.89

Notes:

  • For obtaining values of Nc​, Nq​ and Nγ​, calculate ϕ=tan1(0.67tanϕ).
  • Read Nc​, Nq​, and Nγ​ from the Table corresponding to the value of ϕ instead of ϕ which are values of Nc​, Nq​, Nγ​ respectively.

The modified bearing capacity formulae are given as under:

a) In case of general shear failure qd

qd=cNcscdcic+γDf(Nq1)sqdqiq+0.5γBNγsγdγiγW

b) In case of local shear failure qd

qd=cNcscdcic+γDf(Nq1)sqdqiq+0.5γBNγsγdγiγW

Shape of Basescsqsγ
i) Continuous strip1.001.001.00
ii) Rectangle1+0.2B/L1+0.2B/L10.4B/L
iii) Square1.31.20.8
iv) Circle1.31.20.6

dc=1+0.2DfBNϕ​​dq=dγ=1forϕ<10dq=dγ=1+0.1DfBNϕforϕ>10

Note — The correction is to be applied only when back filling is done with proper compaction.


ic=iq=(1α90)2iγ=(1αϕ)2


GEOtExcel: Shape, Depth and Inclination FACTORS: Continuous Strip

GEOtExcel: Shape, Depth and Inclination FACTORS: Circle

GEOtExcel: Shape, Depth and Inclination FACTORS: Rectangle

GEOtExcel: Shape, Depth and Inclination FACTORS: Square


a) If the water table is likely to permanently remain at or below a depth of (Df+B) beneath the ground level surrounding the footing then W=1.

b) If the water table is located at a depth Df​ or likely to rise to the base of the footing or above then the value of W shall be taken as 0.5.

c) If the water table is likely to permanently get located at depth Df<Dw<(Df+B), then the value of W be obtained by linear interpolation.


The ultimate net bearing capacity shall be calculated as given in 5.2.1 and 5.2.2.

TABLE 3 METHOD OF ANALYSIS BASED ON RELATIVE DENSITY

i)Greater than 70 percentLess than 0.55DenseGeneral shear
ii)Less than 20 percentGreater than 0.75LooseLocal shear (as well as punching shear)
iii)20 to 70 percent0.55 to 0.75MediumInterpolate between i) and ii)

qd=q(Nq1)sqdqiq+12γBNγsγdγiγW

SPT-Derived ϕ

The methods in this section follow IS 6403:1981, but for modern limitations and advanced correlations, refer to the GEOtExcel Technical Critique & Recommendations section at the end of this post.


The static cone point resistance ‘qc​’ shall be determined as per IS: 4968 (Part III)-1976† at number of selected points at intervals of 10 to 15 cm. The observed values shall be corrected for the dead weight of sounding rods. Then the average value at each one of the location shall be determined between the level of the base of the footing and the depth equal to BB to 2 times the width of the footing. The average of the static cone point resistance values shall be determined for each one of the location and minimum of the average values shall be used in the design. The ultimate bearing capacity of shallow strip footings on cohesionless soil deposits shall be determined from Fig. 2.


5.3.1.1 The net ultimate bearing capacity immediately after construction on fairly saturated homogeneous cohesive soils shall be calculated from following formula:

qd=cNcscic whereNc=5.14

The value of c shall be obtained from unconfined compressive strength test. Alternatively, it can also be derived from static cone test (see 5.3.1.2). The values of sc​, dc​ and ic​ may be obtained as in 5.1. If the shear strength for a depth of B beneath the foundation does not depart from the average by more than 50 percent, the average may be used in the calculation.

5.3.1.2 Alternately, cohesion c shall be determined from the static cone point resistance qc​ using the empirical relationship shown below:

Soil TypePoint Resistance Values (qcqc​) kgf/cm²Range of Undrained Cohesion (kgf/cm²)
Normally consolidated clayqc​<20qc/18 to qc/15
Over consolidated claysqc>20qc/26 to qc/22

In the case of two layered cohesive soil system which do not exhibit marked anisotropy the ultimate net bearing capacity of a strip footing can be calculated by using the formula given below:qd=c1Nc

where Nc​ may be obtained from Fig. 3.


In the case of desiccated cohesive soils, the undrained cohesion is likely to decrease along with depth and is likely to get stabilized at some depth below ground level, around 3.5 m, if other factors do not influence. If a plot of undrained cohesion values as shown in Fig. 4 is obtained, and where the pressure bulb falls within the desiccated top soil, the ultimate net bearing capacity shall be obtained with the assumption of cylindrical failure surface from Table 4.



a) Net ultimate bearing capacity divided by a suitable factor of safety (net safe bearing capacity).

b) The net soil pressure that can be imposed on the base without the settlement exceeding the permissible values as given in IS: 1904-1978 (safe bearing pressure).

The permissible settlements for different types of soil formations are specified in IS: 1904-1978*. The methods for calculations of settlements for assumed pressure from standard penetration resistance are specified in IS: 8009 (Part I)-1976†; by calculating the settlements for two or three probable soil pressures and interpolating, the net soil pressure for permissible settlement may be estimated. This safe bearing pressure can also be calculated based on plate load test (see IS: 1888-1982).


GEOtExcel Advisory Note: While IS 6403:1981 is a long-standing standard for shallow foundation design, its empirical correlations were developed several decades ago. Modern geotechnical practice, including Eurocode 7 and advanced literature by Das and Bowles, offers more refined methods. Users are advised to consider the following critiques when using the IS 6403:

Feature / ClauseIS 6403:1981 Approach Recommendation
SPT in Cohesionless Soil (Cl. 5.2.2)Uses N values for ϕ from a simple chart (Fig. 1).Requires explicit N60​ (energy) and N1(60)​ (overburden) corrections.

CPT in Sands (Cl. 5.2.3)
Uses raw average qc​ with Figure 2 curves.
Requires normalizing qc​ for effective stress or correlating to ϕ for stress-dependent analysis.
CPT in Clays (Cl. 5.3.1.2)
Simple ratios like qc​/15 or qc​/18 to estimate cu​.
Uses cu​=(qc​−σv0​)/Nkt​, accounting for total overburden stress (σv0​).
Layered Soils (Cl. 5.3.2)Relies on static charts (Fig. 3) for Nc​ factors.Recommends Punching Shear analysis to model stress distribution through stiff-over-soft layers.
Desiccated Soils (Cl. 5.3.3)Assumes a fixed linear reduction of cohesion with depth.Uses Unsaturated Soil Mechanics; warns of strength loss (collapse) upon saturation.
  • IS 6403 Limitation: The code provides a direct relationship between the N value and ϕ in Fig. 1. Although it mentions “Corrected N value”, it lacks explicit instructions for essential modern corrections like N60​ (energy correction) and N1(60)​ (overburden pressure correction).
  • Modern Recommendation: Following Das (2019) design engineers should first apply energy and stress-level corrections to the field N value before estimating ϕ. Relying on uncorrected or partially corrected values may lead to overestimating the soil’s shear strength.

N60Nactual hammer efficiency60

N60=NηHηBηSηR60 ​​CN=Paσv0

(N1)60=N60CN

Pa​ = 100 kPa

Recommended Correlations:

ReferenceApplicabilityFormula
Wolff (1989)Sands & non-plastic siltsϕ=27.1+0.3N600.00054[N60]2
Hatanaka & Uchida (1996)Clean sandsϕ=20N1(60)+20
Kulhawy & Mayne (1990)Sands & gravelly sandsϕ=tan1[N6012.2+20.3(σopa)]0.34

  • IS 6403 Limitation: The standard calculates bearing capacity directly from the average qc​ value using the empirical curves in Figure 2.
  • Modern Recommendation: Modern practice emphasizes that qc​ is highly dependent on effective overburden pressure. It is recommended to normalize qc values for stress levels or use them to derive the friction angle (ϕ) for a more robust analysis. Modern Formula (Kulhawy & Mayne): Provides a stress-dependent effective friction angle:

ϕ=17.6+11log10[qc/Paσv0/Pa]

Method / ReferenceFormula / ProcedureParameters & Notes
Kulhawy & Mayne (1990) – Effective Friction Angleϕ=17.6+11log10[qc/Paσv0/Pa]Pa=100kPa
σv0= vertical effective stress at test depth
Eslami-Fellenius (CPTu) – Direct ApproachStep 1: qe=qtu2

Step 2: qEg=qe,1×qe,2××qe,nn
​​
Step 3: qb=Cte×qEg
qt = corrected cone resistance
u2​ = pore pressure behind cone
Influence zone = 2B
Eurocode 7 – Pore Pressure Correctionqt=qc+u2(1a)aa = net cone area ratio (0.7 to 0.85)
  • Furthermore, settlement—rather than shear—often governs design in sands, which requires more advanced CPT-based settlement analysis (e.g., Schmertmann’s method).
  • IS 6403 Limitation: The code uses simple ratios (e.g., qc​/15 or qc​/18) to estimate cohesion from cone resistance. This approach ignores the total overburden stress at the test depth.
  • Modern Recommendation: Eurocode 7 suggests the use of the Nkt​ factor (Cone Factor) where cu​=(qc​−σv0​)/Nkt​. This method accounts for the in-situ stress state (σv0​), providing a far more accurate representation of soil strength, especially at greater depths:

cu=qcσv0Nkt

(Where σᵥ₀ is the total overburden stress and Nkt is typically 10–20.)

Typical Nkt Values by Soil Type

Soil Type / ConditionTypical Nkt​ Range
Highly sensitive clays (e.g., quick clays)8 – 12
Soft, normal clays12 – 16
Firm to stiff clays16 – 20
Eurocode 7 (default, no site calibration)15
Overconsolidated clays (OCR > 2)18 – 20
  • IS 6403 Limitation: The bearing capacity factors (Nc​) in Fig. 3 are based on simplified charts. These do not fully capture the complex “Punching Shear” failure mechanism that occurs when a thin stiff crust overlies a soft clay layer.
  • Modern Recommendation: Approaches suggested by Das and Bowles analyze the distribution of stress through the top layer and the shearing resistance along the failure perimeter. For critical projects, numerical analysis or the punching shear theory is recommended over the static charts of IS 6403.
  • Modern Formula (Meyerhof & Hanna): For a stiff layer over a soft layer:

qu=qu(b)+2caHB+γ1H2(1+2DfH)Kstanϕ1Bγ1Hqu(t)

TermPhysical meaningUnit
quUltimate bearing capacity of the two‑layer systemkPa
qu(b)Ultimate bearing capacity of the underlying soft layer alonekPa
2caHBShearing resistance along the two vertical sides of the punched zone (adhesion)kPa
γ1H2(1+2DfH)Kstanϕ1BFrictional resistance along the inclined failure surface within the stiff layerkPa
γ1HReduction due to the weight of the stiff layer pushing down on the soft layerkPa
qu(t)Ultimate bearing capacity of the top (stiff) layer alone (upper bound)kPa

  • IS 6403 Limitation: The standard assumes a linear reduction of cohesion with depth (Table 4 and Fig. 4). This is a highly empirical and simplified model for complex desiccated profiles.
  • Modern Recommendation: Modern practice utilizes Unsaturated Soil Mechanics. The strength of desiccated soils is primarily governed by Matric Suction, which varies seasonally with moisture content. Design engineers should be cautious of the “collapse” or “swelling” potential of these soils upon wetting, which the linear model in IS 6403 does not address.
  • Semi-Empirical Model (Vanapalli & Mohamed, 2013):

qu(unsat)=[c+(uauw)AVR(Sψ)tanϕ]Ncζc+qNqζq+0.5γBNγζγ

TermPhysical meaningUnit
qu(unsat)Ultimate bearing capacity of unsaturated soilkPa
cEffective cohesion (saturated condition)kPa
(uauw)AVRAverage matric suction over the influence zonekPa
SDegree of saturation– (0 to 1)
ψEmpirical pore size distribution parameter (typically 1–4)
ϕEffective friction angledegree
Nc,Nq,NγBearing capacity factors (function of ϕ)
ζc,ζq,ζγCombined correction factors (shape, depth, inclination, ground slope)
qEffective overburden pressure at footing base (=γ×Df​)kPa
γUnit weight of soilkN/m³
BFooting widthm
  • Unified Effective Stress Approach:

qu=[c+χstanϕ]Ncdc+qNqdq+0.5γBNγdγ

TermPhysical meaningUnit
quUltimate bearing capacity (unsaturated/saturated)kPa
cEffective cohesionkPa
χBishop’s parameter (depends on degree of saturation, 0χ1)
sMatric suction (=uauw​)kPa
ϕEffective friction angledegree
Nc,Nq,NγBearing capacity factors (function of ϕ)
dc,dq,dγDepth correction factors (embedment effect)
qEffective overburden pressure at footing basekPa
γUnit weight of soilkN/m³
BFooting widthm

Users are encouraged to use GEOtExcel as a powerful tool for IS 6403 compliance but should supplement their designs with modern correlations for enhanced reliability and safety in complex soil conditions.


✳️ Bearing Capacity Calculator
☑️ Dynamic Professional Excel Spreadsheets
✅ Terzaghi’s Method

1️⃣ Ultimate Bearing Capacity Calculation – Academic Education Focus
2️⃣ Ultimate Bearing Capacity Calculation (Design) as per IS 6403 Code

☑️ [GEO-2026-IS6401-Design] & [GEO-2026-IS6401-Cocept]
📊 “Developed by GEOtExcel Co., Copyrighted.”

1️⃣ Effect of Water Table on the Bearing Capacity
2️⃣ Effect of Relative Density on the Bearing Capacity of Cohesion-less Soils
3️⃣ Effect of Eccentric Loading on the Bearing Capacity

🟥 YouTube Channel: https://www.youtube.com/@Dr.Fahmi.GEOtExcel
☑️ academy.dr.fahmi@gmail.com

Dr. Ahmad Fahmi
Associated Professor,
The University of Bonab
& CEO of GEOtExcel Company (KAPA)


GEOtExcel 2025-1 | Geotechnical Excel Spreadsheets for Soil Mechanics & Foundation Engineering

Geotechnical Excel Spreadsheets – GEOtExcel (2025-1)

GEOtExcel 2025-1 is now easier to access, fully secure, and permanently usable on your personal computer. With this version, GEOtExcel brings an Excel-based desktop application packed with essential tools for soil mechanics, foundation engineering, and geotechnical testing.

What’s New in GEOtExcel 2025-1?

Thanks to valuable user feedback, the delivery method of GEOtExcel has been improved. The 2025-1 version now offers:

1️⃣ Lifetime, Unlimited Access: Use it anytime on your personal computer.
2️⃣ No Restrictions: Save, print, and manage data locally without any limitations.
3️⃣ Offline Access: No need for an internet connection or cloud service to use GEOtExcel.

Important Note

The current GEOtExcel 2025-1 version is fully functional and permanently usable on the registered computer.
(If future versions are released and you choose to upgrade, you’ll receive special discounts for existing users.)


How to Order GEOtExcel 2025

To begin the process of getting GEOtExcel 2025, follow these steps:

  1. Download the package:
    Download Zip File
  2. Unzip and open the package:
    It contains two Excel files:
  • File 1: GET ID: This file helps you extract your computer’s unique ID. Simply open the file and click the “Copy Computer ID” button.
  • File 2: Agreement: This file contains 3 sheets:
    • Sheet 1: Price List: Select the GEOtExcel files you wish to purchase, and the total price will be calculated automatically.
    • Sheet 2: Customer & PC Info: Fill in your contact details and paste the copied Computer ID.
    • Sheet 3: Agreement: Review and confirm your order details.
  1. Complete the required fields, then save the Agreement file and email it to:
    📧 academy.dr.fahmi@gmail.com

Support and Assistance

Our support team is ready to assist you with the entire process, including payment, installation, and file delivery.

Why Choose GEOtExcel?

  • Comprehensive: Includes 12 fields, 50 files, and over 470 Excel spreadsheets.
  • Educational & Professional Quality: Created by Dr. Ahmad Fahmi, Assistant Professor at The University of Bonab, and CEO of GEOtExcel.
  • Real-World Application: Designed for professionals and students working in geotechnical engineering, soil mechanics, and foundation engineering.

Follow GEOtExcel on Social Media:

Contact Dr. Ahmad Fahmi:

Assistant Professor, The University of Bonab
CEO of GEOtExcel (KAPA)
Email: academy.dr.fahmi@gmail.com

Stay Updated:

Subscribe to get the latest updates, lectures, and spreadsheets for soil mechanics, foundation engineering, and geotechnical testing.
➡️ Subscribe on YouTube

Foundation Engineering – Pile Frictional Resistance (Beta Method) | Geotechnical Excel Spreadsheets

Foundation Engineering – Pile Frictional Resistance (Beta Method)

[GEO-2025-0105] – Developed by GEOtExcel Co.

This educational spreadsheet package provides a step-by-step solution for pile frictional resistance calculations using the Beta Method in foundation engineering. It helps in analyzing the frictional resistance of a concrete pile in sandy soil and understanding the effects of varying parameters such as pile length, diameter, and friction angle.


Problem Overview:

A concrete pile with:

  • Length (L) = 10m
  • Diameter (D) = 0.5m
  • Soil Friction Angle (φ’) = 20°
  • Eccentricity (e) = 0.5
  • Pile-Soil Friction Angle = (2/3 φ’)

Steps Covered:

A) Calculate the frictional resistance (Qs) using the Beta Method.
B) Analyze the effect of varying L (10-15m), D (0.5-1m), and φ (20°-30°) on the frictional resistance.
C) Evaluate the impact of groundwater level ossification on the pile frictional resistance.


What’s Included:

  • 3 Professional Spreadsheets designed for analyzing pile frictional resistance using the Beta Method.
  • Comprehensive step-by-step solutions for all variables affecting pile frictional resistance.

Spreadsheets Included:

  1. Start Sheet: Introduction to the pile frictional resistance problem and parameters.
  2. Problem01: Detailed Foundation Engineering Problem with corresponding solution approach using GEOtExcel.
  3. Qs-Solution: Pile Frictional Resistance (Qs) Calculation using the Beta Method.

Features and Benefits:

  • Complete Analysis: This package includes comprehensive steps for calculating pile frictional resistance under different loading conditions and soil parameters.
  • Educational Use: Ideal for students and professionals in foundation engineering and geotechnical engineering.
  • Real-world Problem Solving: Provides a practical solution to a common engineering challenge in foundation design.

Why Choose GEOtExcel:

  • Expert-Developed: Created by Dr. Ahmad Fahmi, an expert in foundation engineering and soil mechanics.
  • Educational & Professional Quality: Suitable for both classroom learning and professional practice.
  • User-Friendly Format: Easy-to-use Excel spreadsheets designed for efficient problem-solving in geotechnical and foundation engineering.

Part of the GEOtExcel 2025-1 Collection

  • 12 Groups of spreadsheets
  • 50 Files covering various geotechnical topics
  • 470+ Spreadsheets
  • Commercially Licensed: Full access for professionals and educational use

For more details or to make a purchase, please contact:
📧 academy.dr.fahmi@gmail.com

🛒 To Buy GEOtExcel and Use It on Your PC:

👉 How to Buy GEOtExcel and Use It on Your PC

🔗 Follow GEOtExcel on Social Media:

👨‍🏫 About Dr. Ahmad Fahmi

Assistant Professor, Geotechnical Engineering, University of Bonab
Dr. Fahmi is a leading expert in soil mechanics, foundation engineering, and geotechnical testing, dedicated to providing high-quality educational tools for professionals and students.

📌 Stay Updated:

Subscribe to get access to the latest soil mechanics, foundation engineering, and geotechnical testing lectures on YouTube:
➡️ Subscribe on YouTube


Soil Mechanics – Unified Soil Classification System & Hydrometer Analysis for Fat Clay (CH) | Geotechnical Excel Spreadsheets

Soil Mechanics – Unified Soil Classification System & Hydrometer Analysis for Fat Clay (CH)

[GEO-2025-0115] – Developed by GEOtExcel Co.

This professional spreadsheet package provides a detailed solution for Soil Mechanics focusing on Fat Clay (CH) using the Unified Soil Classification System (USCS) and Hydrometer Analysis.


What’s Included:

  • 8 Professional Spreadsheets covering soil classification, sieve, and hydrometer analysis for Fat Clay (CH).

Detailed Breakdown:

  • [GEO-2025-0115]:
    1) Start Sheet: Introduction to Unified Soil Classification System & Hydrometer Analysis for Fat Clay (CH).
    2) DATA: Soil Classification data for Fat Clay (USCS).
    3) USCS: Excel Spreadsheet for Unified Soil Classification System (USCS).
    4) Sieve: Sieve Analysis for Fat Clay.
    5) Hydrometer: Hydrometer Analysis for Fat Clay.
    6) Table 1: Hydrometer 152H – Table1
    7) Table 1-Full: Full data for Hydrometer 152H – Table1
    8) Table 2: Hydrometer 152H – Table3
    9) Table 2-Full: Full data for Hydrometer 152H – Table2
    10) Table 3: Hydrometer 152H – Table1
    11) Table 3-Full: Full data for Hydrometer 152H – Table3

Features and Benefits:

  • Comprehensive Soil Classification: Covers the USCS system and Hydrometer analysis for Fat Clay (CH), including sieve analysis.
  • Professional and Educational Use: Aimed at students and professionals in soil mechanics and geotechnical engineering.
  • Detailed Spreadsheets: The package includes 8 detailed spreadsheets, ideal for practical use in laboratory settings.
  • Complete Hydrometer Analysis: Includes detailed tables and hydrometer calculations, providing valuable insights for soil testing and classification.

Why Choose GEOtExcel:

  • Educational & Professional-Grade: These spreadsheets offer a detailed approach to soil classification and analysis, suitable for both educational and professional use.
  • Comprehensive & User-Friendly: The easy-to-use format ensures users can perform detailed soil tests and obtain reliable results efficiently.
  • Expert-Developed: Created by Dr. Ahmad Fahmi, an expert in soil mechanics and geotechnical engineering.

📦 Part of the GEOtExcel 2025-1 Collection

  • 12 Groups of spreadsheets
  • 50 Files for soil mechanics and foundation engineering
  • 470+ Spreadsheets
  • Secure Access: Easily downloadable and usable on your computer
  • Commercially Licensed: Full access for professionals and educational use

For more details or to make a purchase, please contact:
📧 academy.dr.fahmi@gmail.com

🛒 To Buy GEOtExcel and Use It on Your PC:

👉 How to Buy GEOtExcel and Use It on Your PC

🔗 Follow GEOtExcel on Social Media:

👨‍🏫 About Dr. Ahmad Fahmi

Assistant Professor, Geotechnical Engineering, University of Bonab
Dr. Fahmi is a leading expert in soil mechanics, foundation engineering, and geotechnical testing, dedicated to providing high-quality educational tools for professionals and students.

📌 Stay Updated:

Subscribe to get access to the latest soil mechanics, foundation engineering, and geotechnical testing lectures on YouTube:
➡️ Subscribe on YouTube


Soil Mechanics – Soil Phase Relationships – Step-by-Step Solutions for Problem02, Problem03, & Problem04 | Geotechnical Excel Spreadsheets

Soil Mechanics – Soil Phase Relationships: Step-by-Step Solutions for Problem02, Problem03, & Problem04

[GEO-2025-0109], [GEO-2025-0110], [GEO-2025-0111] – Developed by GEOtExcel Co.

This comprehensive product includes 17 professional spreadsheets that help solve Soil Phase Relationships problems in Soil Mechanics. The spreadsheets cover Problem02, Problem03, & Problem04 in detail with a step-by-step approach, ensuring a thorough understanding of the concepts.


What’s Included:

  • [GEO-2025-0109]: 7 Spreadsheets for Problem02, including detailed steps for solving the phase relationships.
  • [GEO-2025-0110]: 6 Spreadsheets for Problem03, covering calculations and key principles in soil mechanics.
  • [GEO-2025-0111]: 4 Spreadsheets for Problem04, designed to aid in comprehensive soil phase analysis and understanding.

Features and Benefits:

  • Step-by-Step Solutions: Each problem is solved with clear, structured steps to enhance learning and application.
  • Educational-Oriented: Ideal for students and professionals alike, these spreadsheets provide valuable insights and practice.
  • Comprehensive Coverage: From calculation of soil parameters to soil classification, the product covers all essential soil phase relationships in great detail.
  • Practical Applications: Designed for use in real-world soil mechanics problems and foundation design.

Why Choose GEOtExcel:

  • Complete Package: A total of 17 professional spreadsheets designed specifically for soil mechanics and phase relationships.
  • Trusted by Professionals: Developed by Dr. Ahmad Fahmi, an expert in Geotechnical Engineering.
  • Educational Focus: Aimed at enhancing your understanding of complex soil behavior and mechanics through practical and structured solutions.

📦 Part of the GEOtExcel 2025-1 Collection

  • 12 Groups of spreadsheets
  • 50 Files for soil mechanics and foundation engineering
  • 470+ Spreadsheets
  • Secure Access: Easily downloadable and usable on your computer
  • Commercially Licensed: Full access for professionals and educational use

For more details or to make a purchase, please contact:
📧 academy.dr.fahmi@gmail.com

🛒 To Buy GEOtExcel and Use It on Your PC:

👉 How to Buy GEOtExcel and Use It on Your PC

🔗 Follow GEOtExcel on Social Media:

📺 GEOtExcel YouTube Channel

👨‍🏫 About Dr. Ahmad Fahmi

Assistant Professor, Geotechnical Engineering, University of Bonab
Dr. Fahmi is a leading expert in soil mechanics, foundation engineering, and geotechnical testing, dedicated to providing high-quality educational tools for professionals and students.

📌 Stay Updated:

Subscribe to get access to the latest soil mechanics, foundation engineering, and geotechnical testing lectures on YouTube:
➡️ Subscribe on YouTube


[GEO-2025-0109]


[GEO-2025-0110]


[GEO-2025-0111]


Advanced Soil Mechanics – Critical State Mechanics (MCC) Model | CU Triaxial Test | Geotechnical Excel Spreadsheets

Advanced Soil Mechanics – Critical State Mechanics (MCC) Model | CU Triaxial Test

[GEO-2025-0140] – By Dr. Ahmad Fahmi

This advanced Geotechnical Excel Spreadsheet for Critical State Mechanics (MCC Model) is designed for CU Triaxial Tests in soil mechanics. It allows classification of soil into three categories:

  1. NC – Normally Consolidated Clay
  2. LOC – Lightly Over-Consolidated Clay
  3. HOC – Highly Over-Consolidated Clay

The spreadsheet provides a professional tool for analyzing soil behaviors under different consolidation states, essential for advanced geotechnical engineering and foundation design.


What’s Included in the Product:

  • [GEO-2025-0140]: Includes 7 Professional Spreadsheets for soil classification based on the Modified Cam Clay (MCC) Model.
    • Start Sheet: Introduction and Overview.
    • MCC-CU Sheet: Main Super Sheet for Critical State Mechanics and CU Triaxial Test.
    • Calculation Sheets (Cal1-Cal5): For performing the detailed calculations required for soil classification under MCC.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Critical State Mechanics (MCC Model): Used to understand the soil behavior under varying stress states.
  • CU Triaxial Test: Important for testing soil in consolidated undrained conditions.
  • Soil Classification: The tool classifies clay into normally consolidated, lightly over-consolidated, and highly over-consolidated based on the MCC Model.
  • Geotechnical Engineers: Essential for soil stability, foundation analysis, and earthworks.
  • Educational Use: Suitable for students and professors in advanced soil mechanics courses.

📦 Part of Geotechnical Excel Spreadsheets 2025-1 Collection

This product is part of the Geotechnical Excel Spreadsheets (2025-1) suite, featuring:

  • 12 groups of spreadsheets
  • 50 files for various soil mechanics and foundation engineering calculations
  • 470+ spreadsheets
  • Secure and permanent access to all files on your computer
  • Commercially licensed for professional use

For more information or to purchase, contact us at:
📧 academy.dr.fahmi@gmail.com


🛒 To Buy Geotechnical Excel Spreadsheets and Use It on Your PC:

👉 How to Buy Geotechnical Excel Spreadsheets and Use It on Your PC


🔗 Follow Geotechnical Excel Spreadsheets on Social Media:


👨‍🏫 About Dr. Ahmad Fahmi

Assistant Professor, Geotechnical Engineering, University of Bonab
Dr. Fahmi specializes in applying Excel-based solutions for soil mechanics, foundation engineering, and geotechnical testing.


📌 Stay Updated:

Subscribe for upcoming lectures on:



Soil Mechanics – Soil Classification (USCS) | Geotechnical Excel Spreadsheets

Soil Mechanics – Soil Classification (USCS)

[GEO-2025-0116], [GEO-2025-0117], [GEO-2025-0118] – By Dr. Ahmad Fahmi

We are excited to present the Soil Classification (USCS) tools in Geotechnical Excel Spreadsheets. This product includes 44 spreadsheets, offering a comprehensive solution for soil classification using the Unified Soil Classification System (USCS). The package includes various sections for comparing different soil classification systems, Fuller’s comparison, and analysis of poorly graded soils.

This tool is designed for geotechnical engineers, students, and soil mechanics professionals who are working with soil classification systems, especially focusing on the USCS.

What’s Included in the 44 Spreadsheets?

  1. [GEO-2025-0116]: Comparison
    • 20 Spreadsheets covering the USCS classification system, with detailed soil property analysis.
  2. [GEO-2025-0117]: Comparison with Fuller
    • 14 Spreadsheets offering a comparison between USCS and Fuller’s Classification.
  3. [GEO-2025-0118]: Poorly Graded Soils
    • 10 Spreadsheets focusing on the classification and analysis of poorly graded soils using the USCS.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Unified Soil Classification System (USCS): Ideal for classifying soils based on particle size and plasticity characteristics.
  • Geotechnical Engineers: A useful tool for foundation design, soil testing, and soil analysis.
  • Educational Use: Great for soil mechanics students and professors to demonstrate soil classification methods.
  • Comparison Analysis: Includes Fuller’s Classification comparison, which is essential for understanding soil behavior in various construction contexts.
  • Advanced Soil Analysis: Provides tools for the analysis of poorly graded soils, an important factor in foundation design and soil stabilization.

📦 Part of Geotechnical Excel Spreadsheets 2025-1 Collection

This product is part of the Geotechnical Excel Spreadsheets (2025-1) suite, featuring:

  • 12 groups of spreadsheets
  • 50 files for various soil mechanics and foundation engineering calculations
  • 470+ spreadsheets
  • Secure and permanent access to all files on your computer
  • Commercially licensed for professional use

For more information or to purchase, contact us at:
📧 academy.dr.fahmi@gmail.com

🛒 To Buy Geotechnical Excel Spreadsheets and Use It on Your PC:

👉 How to Buy Geotechnical Excel Spreadsheets and Use It on Your PC

🔗 Follow Geotechnical Excel Spreadsheets on Social Media:

👨‍🏫 About Dr. Ahmad Fahmi

Assistant Professor, Geotechnical Engineering, University of Bonab
Dr. Fahmi specializes in applying Excel-based solutions for soil mechanics, foundation engineering, and geotechnical testing.


📌 Stay Updated:

Subscribe for upcoming lectures on:


[GEO-2025-0116]


[GEO-2025-0117]


[GEO-2025-0118]


Soil Mechanics – Stress Distribution in Soil using Newmark Method | Geotechnical Excel Spreadsheets

Soil Mechanics – Stress Distribution in Soil Using Newmark Method

[GEO-2025-0129 A&B] – By Dr. Ahmad Fahmi

We are pleased to present the Stress Distribution in Soil analysis tool using the Newmark Method with Geotechnical Excel Spreadsheets. This advanced product includes 22 spreadsheets, which provide a comprehensive solution for calculating the stress distribution in soils based on the Newmark method.

This product is designed for geotechnical engineers and soil mechanics students working on foundation design, soil analysis, and stress distribution. Whether you are analyzing the vertical stress distribution in soil or studying soil behavior under varying conditions, these spreadsheets will help you perform precise calculations.


What’s Included in the 22 Spreadsheets?

  1. [GEO-2025-0129-A]:
    • Start Sheet: Introduction to the Newmark Method for stress distribution.
    • Main Super Sheet: Stress Distribution in Soil using the Newmark Method.
    • Calculation Sheets: Detailed spreadsheets for calculations based on the Newmark Method.
  2. [GEO-2025-0129-B]:
    • Additional Spreadsheets for extended calculations and analysis.
    • More comprehensive breakdowns for stress distribution.

Applications in Soil Mechanics and Foundation Engineering:

  • Newmark Method: Use the Newmark Method for stress distribution calculations in soil mechanics.
  • Soil Behavior Analysis: Analyze the effect of external loads on soil using stress distribution models.
  • Geotechnical Engineers: Ideal for professionals working on shallow foundations and soil load analysis.
  • Educational Use: A great tool for students and professors in soil mechanics and geotechnical engineering courses.
  • Detailed Analysis: Includes multiple calculation options to accurately model stress distribution in different soil types.

📦 Part of Geotechnical Excel Spreadsheets 2025-1 Collection

This product is part of the Geotechnical Excel Spreadsheets (2025-1) suite, featuring:

  • 12 groups of spreadsheets
  • 50 files for various soil mechanics and foundation engineering calculations
  • 470+ spreadsheets
  • Secure and permanent access to all files on your computer
  • Commercially licensed for professional use

For more information or to purchase, contact us at:
📧 academy.dr.fahmi@gmail.com

🛒 To Buy Geotechnical Excel Spreadsheets and Use It on Your PC:

👉 How to Buy Geotechnical Excel Spreadsheets and Use It on Your PC

🔗 Follow Geotechnical Excel Spreadsheets on Social Media:

👨‍🏫 About Dr. Ahmad Fahmi

Assistant Professor, Geotechnical Engineering, University of Bonab
Dr. Fahmi specializes in applying Excel-based solutions for soil mechanics, foundation engineering, and geotechnical testing.

📌 Stay Updated:

Subscribe for upcoming lectures on:



Soil Mechanics – Effect of Surcharge on Effective Stress | Geotechnical Excel Spreadsheets

Soil Mechanics – Effect of Surcharge on Effective Stress

[GEO-2025-0125] – By Dr. Ahmad Fahmi

Introducing the comprehensive Excel Spreadsheets for analyzing the Effect of Surcharge on Effective Stress in soil mechanics. This product, developed by GEOtExcel Co., includes 24 spreadsheets designed to provide accurate calculations of effective stress when surcharge loads are applied to shallow foundations. The package includes two layouts (Layout 1 and Layout 2) for flexibility in analysis and application.

These spreadsheets are ideal for geotechnical engineers and students working on projects related to foundation design, soil mechanics, and surcharge effects. Whether you’re analyzing shallow foundations or soil behavior under surcharge load, these tools will help you calculate effective stress with ease.

What’s Included in the 24 Spreadsheets?

  1. Start Sheet: Overview of the Effect of Surcharge on Effective Stress calculations.
  2. Surcharge Main Super Sheet: Core sheet for analyzing the effect of surcharge on effective stress (kg/m²).
  3. Calculation Spreadsheets: A series of 12 spreadsheets in both Layout 1 and Layout 2 for step-by-step calculations.

Applications in Soil Mechanics and Foundation Engineering:

  • Effective Stress Calculation: Calculate effective stress under surcharge loads with two layouts for flexibility and accuracy.
  • Foundation Design: Analyze the effect of surcharge on shallow foundations and soil behavior.
  • Practical Tool: Ideal for geotechnical engineers involved in soil testing and foundation design.
  • Educational Use: A great resource for students and professors studying soil mechanics and geotechnical engineering.
  • Advanced Analysis: Comprehensive tools for soil mechanics involving shallow foundation and surcharge load analysis.

📦 Part of Geotechnical Excel Spreadsheets 2025-1 Collection

This product is part of the Geotechnical Excel Spreadsheets (2025-1) suite, featuring:

  • 12 groups of spreadsheets
  • 50 files for various soil mechanics and foundation engineering calculations
  • 470+ spreadsheets
  • Secure and permanent access to all files on your computer
  • Commercially licensed for professional use

For more information or to purchase, contact us at:
📧 academy.dr.fahmi@gmail.com

🛒 To Buy Geotechnical Excel Spreadsheets and Use It on Your PC:

👉 How to Buy Geotechnical Excel Spreadsheets and Use It on Your PC

🔗 Follow Geotechnical Excel Spreadsheets on Social Media:

👨‍🏫 About Dr. Ahmad Fahmi

Assistant Professor, Geotechnical Engineering, University of Bonab
Dr. Fahmi specializes in applying Excel-based solutions for soil mechanics, foundation engineering, and geotechnical testing.


📌 Stay Updated:

Subscribe for upcoming lectures on:



Foundation Engineering – Bearing Capacity: Hansen Method with Inclined Load | Geotechnical Excel Spreadsheets

Foundation Engineering – Bearing Capacity: Hansen Method with Inclined Load

[GEO-2025-0104-A] – By Dr. Ahmad Fahmi

We are pleased to present the Bearing Capacity Calculator using Hansen’s Method for shallow foundations under inclined loads. This advanced set of 10 professional spreadsheets developed by GEOtExcel Co. allows engineers and students to calculate the bearing capacity of foundations when subjected to inclined loads.

This product is perfect for foundation engineers involved in designing shallow foundations subjected to various angles of inclination. By using this tool, you can determine the effect of loading inclination on the bearing capacity, an essential factor in geotechnical and foundation engineering.

What’s Included in the 10 Spreadsheets?

Start: Start Sheet – Introduction to the Hansen method for calculating bearing capacity under inclined loads.

  1. Angles: Introducing the Alpha, Beta, and Theta Angles – Explanation of different angles affecting bearing capacity.
  2. Hansen-Inclined Load: Main Super Sheet – Core sheet for calculating the bearing capacity using the Hansen method under inclined loads.
  3. C1-C7: Calculation Sheets – Detailed calculation sheets that handle various angles and loading conditions.

Applications in Foundation Engineering:

  • Hansen Method: Apply the Hansen method to calculate bearing capacity for shallow foundations under inclined loads.
  • Inclined Loads: Account for the effect of inclined loading on bearing capacity, which is crucial for foundations subjected to sloping or angled loads.
  • Practical Tool: Ideal for foundation design and geotechnical engineers working with shallow foundations.
  • Educational Use: Useful for students and professors in foundation engineering and geotechnical engineering courses.
  • Comprehensive Analysis: Includes all necessary calculations for bearing capacity factors, shape, depth factors, and more.

📦 Part of Geotechnical Excel Spreadsheets 2025-1 Collection

This product is part of the Geotechnical Excel Spreadsheets (2025-1) suite, featuring:

  • 12 groups of spreadsheets
  • 50 files for various soil mechanics and foundation engineering calculations
  • 470+ spreadsheets
  • Secure and permanent access to all files on your computer
  • Commercially licensed for professional use

For more information or to purchase, contact us at:
📧 academy.dr.fahmi@gmail.com

🛒 To Buy Geotechnical Excel Spreadsheets and Use It on Your PC:

👉 How to Buy Geotechnical Excel Spreadsheets and Use It on Your PC

🔗 Follow Geotechnical Excel Spreadsheets on Social Media:

👨‍🏫 About Dr. Ahmad Fahmi

Assistant Professor, Geotechnical Engineering, University of Bonab
Dr. Fahmi specializes in applying Excel-based solutions for soil mechanics, foundation engineering, and geotechnical testing.


📌 Stay Updated:

Subscribe for upcoming lectures on: