Official Release of GEOtExcel-2025

๐ŸŒ We are proud to announce the official release of GEOtExcel-2025-v1. This version is now available in the Microsoft 365 cloud environment โ€” bringing simplicity, speed, and structure to your Geotechnical-related education & calculations.


โœ… This Educational-Oriented Product (Version 2025) Includes: +470 Excel Spreadsheets:
โ˜‘๏ธ Foundation Engineering (Shallow & Deep Foundations)
โ˜‘๏ธ Soil Mechanics & Soil Mechanics Laboratory
โ˜‘๏ธ Rock Mechanics
โ˜‘๏ธ Advanced Soil Mechanics

โ˜‘๏ธ Group 01: Foundation Engineering – Bearing Capacity
โ˜‘๏ธ 5 Files:
[GEO-2025-0101]
Foundation Eng-Bearing Capacity Calculator-Terzaghi
[GEO-2025-0102-A]
Foundation Eng-Bearing Capacity Calculator-All Methods
[GEO-2025-0102-B]
Foundation Eng-Bearing Capacity Calculator-Special Cases
[GEO-2025-0103]
Foundation Eng-Bearing Capacity Calculator-Comprehensive Comparison
[GEO-2025-0104]
Foundation Eng-Bearing Capacity -Hansen-Inclined Load

โ˜‘๏ธ Group 02: Foundation Engineering-Deep Foundations
โ˜‘๏ธ 1 File:
[GEO-2025-0109]
Foundation Eng-Pile Frictional Resistance

โ˜‘๏ธ Group 03: Soil Mechanics – Soil Phase Relationships
โ˜‘๏ธ 6 Files:
[GEO-2025-0106]
Soil Mech-Soil Phase Relationships-Excel Spreadsheets
[GEO-2025-0107]
Soil Mechanics-Compaction-Consolidation-Swelling
[GEO-2025-0108]
Soil Phase Relationships-Problem01 & Step-by-Step Solution
[GEO-2025-0109]
Soil Phase Relationships-Problem02 & Step-by-Step Solution
[GEO-2025-0110]
Soil Phase Relationships-Problem03 & Step-by-Step Solution
[GEO-2025-0111]
Soil Phase Relationships-Problem04 & Step-by-Step Solution

โ˜‘๏ธ Group 04: Soil Mechanics – Soil Classification
โ˜‘๏ธ 7 Files:
[GEO-2025-0112]
Soil Mech-Unified Soil Classification System-USCS-Gravel Examples
[GEO-2025-0113]
Soil Mech-Unified Soil Classification System-USCS-Sand Examples
[GEO-2025-0114]
Soil Mech-Unified Soil Classification System-USCS-Clay&Silt-Plasticity Chart
[GEO-2025-0115]
Soil Mech-Unified Soil Classification System & Hydrometer Analysis-Fat Clay (CH)
[GEO-2025-0116]
Soil Mech-Unified Soil Classification System-USCS-Comparison
[GEO-2025-0117]
Soil Mech-Unified Soil Classification System-USCS-Comparison ith Fuller
[GEO-2025-0118]
Soil Mech-Unified Soil Classification System-USCS-Poorly Graded Soils

โ˜‘๏ธ Group 05: Soil Mechanics – Hydrometer Analysis
โ˜‘๏ธ 3 Files:
[GEO-2025-0119]
Soil Mech-Analysis of Soil Hydrometer Testing
[GEO-2025-0120]
Soil Mech-Complete Soil Gradation Curve Using Sieve and Hydrometer Analysis-Example1
[GEO-2025-0121]
Soil Mech-Complete Soil Gradation Curve Using Sieve and Hydrometer Analysis-Example2

โ˜‘๏ธ Group 06: Soil Mechanics – Effective Stress Concept
โ˜‘๏ธ 12 Files:
[GEO-2025-0122-A,B,C & D]
Soil Mech-Effective Stress-Single: (4ร—5=20 Spreadsheets)
[GEO-2025-0123-A,B,C & D]
Soil Mech-Effective Stress-Double: (4ร—5=20 Spreadsheets)
[GEO-2025-0124-A &B]
Soil Mech-Effective Stress-Double Layer-GWL Oscillation: (2ร—8=16 Spreadsheets)
[GEO-2025-0125-A &B]
Soil MechEffect of Surcharge on Effective Stress: (2ร—8=16 Spreadsheets)

โ˜‘๏ธ Group 07: Soil Mechanics – Stress Distribution in Soil
โ˜‘๏ธ 5 Files:
[GEO-2025-0126]
Soil Mech-Stress distribution in soil- Boussinesq-Point Load
[GEO-2025-0127]
Soil Mech-Stress distribution in soil- Boussinesq-Strip Loading
[GEO-2025-0128]
Soil Mechanics-Stress distribution in soil-Boussinesq-Rectangular Loading
[GEO-2025-0129-A]
Soil Mech-Stress distribution in Soil- Newmark Method
[GEO-2025-0129-B]
Soil Mech-Stress distribution in Soil- Newmark Method-Concept

โ˜‘๏ธ Group 08: Soil Mechanics – Consolidation
โ˜‘๏ธ 1 File:
[GEO-2025-0130]
Soil Mech-Consolidation

โ˜‘๏ธ Group 09: Soil Mechanics – Shear Strength
โ˜‘๏ธ 3 Files:
[GEO-2025-0131]
Soil Mechanics-Shear Strength Problems-Active & Passive
[GEO-2025-0132]
Soil Mech-Triaxial CD Test-Real Results
[GEO-2025-0133]
Soil Mech-Triaxial CU Test-Real Results

โ˜‘๏ธ Group 10: Soil Mechanics – Seepage
โ˜‘๏ธ 4 Files:
[GEO-2025-0134]
Soil Mechanics-Seepgae-Darcy’s Law
[GEO-2025-0135]
Soil Mechanics-Seepgae-Darcy Law-alpha
[GEO-2025-0136]
Soil Mechanics-Flow Net-Dam
[GEO-2025-0137]
Soil Mechanics-Flow Net & Flow Rate Concept-Dam

โ˜‘๏ธ Group 11: Soil Mechanics – Rock Quality Designation (RQD)
โ˜‘๏ธ 1 File:
[GEO-2025-0138]
Rock Mechanics & Engineering Geology-RQD

โ˜‘๏ธ Group 12: Advanced Soil Mechanics – Critical State Mechanics
โ˜‘๏ธ 2 Files:
[GEO-2025-0139]
Advanced Soil Mechanics-Critical State Mechanics-MCC-CD
[GEO-2025-0140]
Advanced Soil Mechanics-Critical State Mechanics-MCC-CU


โ–ถ๏ธ Watch the Introductory Video:

Please make sure to watch the video on the launch page carefully, as it explains important subscription and access steps.

In this video, learn how GEOtExcel files are securely shared with users worldwide, how cloud-based updates work, and which Microsoft 365 plans (Free Web, Personal, Business Basic, or Business Standard) best match your needs. We’ll also show how subscription works, how to access files, and what features are available under each plan. Whether you’re a student, engineer, researcher, or consultant โ€” this video explains everything you need to get started with GEOtExcel.


๐Ÿ“Š Microsoft 365 Account Required

To use GEOtExcel, youโ€™ll need an active Microsoft 365 account (any of the following plans):

  • Free Web
  • Personal (Recommended)
  • Business Basic
  • Business Standard (Recommended)

๐Ÿ“Š Explore the Introductory PDF Guide:


๐Ÿ’ก Donโ€™t Have Microsoft 365?

You can still try GEOtExcel! Microsoft offers a one-month free trial for new users on:

  • โœ… Microsoft 365 Personal
  • โœ… Microsoft 365 Business Standard

If you use one of these two plans, youโ€™ll have the opportunity to experience the full benefits of Excel Desktop seamlessly integrated with cloud access โ€” including support for macros, form controls, and a significantly faster and more responsive interface.

๐Ÿ‘‰ Visit: https://www.microsoft.com/microsoft-365/try


โœ… GEOtExcel-2025: Subscription Fee

โœ… The official subscription period for GEOtExcel-2025 begins at the time of purchase, with access to the files made available following confirmation of payment.

โœ… Customers who subscribe at any point in 2025 will receive a full one-year subscription starting from the date of payment.

โœ… The subscription fee for GEOtExcel-2025-v1 is $250/year (USD), providing full access for one year from the date of activation.

โœ… As a launch offer, customers who choose to pay via cryptocurrency can benefit from a reduced price of 199 Tether/year, approximately equal to $199 USD.

โœ… Payment details (bank account or USDT wallet address) will be provided upon request after signing this agreement.


โœ… How to Subscribe GEOtExcel 2025-v1

Download the following files:
๐Ÿ“Ž GEOtExcel Catalog (PDF):


๐Ÿ“Ž Pricing & Subscription Agreement (PDF)

Review and sign the agreement (digitally or handwritten). Send the signed agreement, including your Microsoft 365 email address to the address below. Please use the subject line: “GEOtExcel Agreement+Your Full Name” in your email. After verification, weโ€™ll send you the payment instructions.


๐Ÿ’ผ Become a Group Leader & Get a Free GEOtExcel Subscription!

Are you interested in promoting GEOtExcel among your network? Join our Group Purchase Program and receive exclusive benefits!
๐Ÿ”น If you act as a Group Leader and register 10 or more new customers (in addition to yourself), you will receive:
โœ… 1 Free Subscription (for yourself)
โœ… 50% Discount for each of the 10+ group members (only $125/year or 99 USDT/year per person)
๐Ÿ’ณ Conditions:
The total group payment must be made by the Group Leader in a single transaction.
Payments can be made via USD bank transfer or Tether (USDT). The Group Leader is responsible for informing all group members that a valid Microsoft 365 subscription (separate from the GEOtExcel subscription) is required to access the files.
Additionally, the Group Leader must collect and submit the signed GEOtExcel agreement forms for all group members, including themselves, in a single email to:
academy.dr.fahmi@gmail.com

๐Ÿ’ก Example:
A group leader introduces 10 new users and pays via $:
They receive 1 free subscription, and
The group pays: 10 ร— $125 = $1,250 total.
(If paid in Tether: 10 ร— 99 USDT = 990 USDT total).

๐Ÿ“ฉ To request a group purchase, please email us at: academy.dr.fahmi@gmail.com
๐Ÿ“Œ Please include “Group Purchase Request” in the subject line of your email.


๐Ÿ’ผ Become Our Sales Representative in Your City or Country!

If you are interested in becoming an official sales representative for GEOtExcel subscriptions in your city or country, please send your request to the following email address:
๐Ÿ“ง academy.dr.fahmi@gmail.com
๐Ÿ“Œ Please include “Subscription Sales Representative Request” in the subject line of your email.



“GEOtExcel-2025-v1” Catalog: Geotechnical Excel Spreadsheets

โœ… GEOtExcel: Geotechnical Excel Spreadsheets
โ˜‘๏ธ [GEO-2025-0101-0140]-Version 2025
โ˜‘๏ธ 12 Fields, 40 Files, +470 Excel Spreadsheets
๐Ÿ“Š “Developed by GEOtExcel Co., Copyrighted.”
๐Ÿ“Š This Educational-Oriented Product Includes: 12 Fields, 40 Files, +470 Excel Spreadsheets

โ˜‘๏ธ Video “627-Page Catalog”
โ˜‘๏ธ Full video: https://youtu.be/s96jKsjq-D4

โœ… GEOtExcel YouTube Channel Address:
https://www.youtube.com/@Dr.Fahmi.GEOtExcel
โœ… GEOtExcel Company Page Address:
https://www.linkedin.com/company/geotexcel/

โœ… This Educational-Oriented Product (Version 2025) Includes: +474 Excel Spreadsheets:
โ˜‘๏ธ Foundation Engineering (Shallow & Deep Foundations)
โ˜‘๏ธ Soil Mechanics & Soil Mechanics Laboratory
โ˜‘๏ธ Rock Mechanics
โ˜‘๏ธ Advanced Soil Mechanics

Dear Academics, Engineers, and Enthusiasts!
Stay updated by subscribing โ€” simply send us your email at:
academy.dr.fahmi@gmail.com

โœ… This Educational-Oriented Product (Version 2025) Includes: +470 Excel Spreadsheets:
โ˜‘๏ธ Foundation Engineering (Shallow & Deep Foundations)
โ˜‘๏ธ Soil Mechanics & Soil Mechanics Laboratory
โ˜‘๏ธ Rock Mechanics
โ˜‘๏ธ Advanced Soil Mechanics

โ˜‘๏ธ Group 01: Foundation Engineering – Bearing Capacity
โ˜‘๏ธ 5 Files:
[GEO-2025-0101]
Foundation Eng-Bearing Capacity Calculator-Terzaghi
[GEO-2025-0102-A]
Foundation Eng-Bearing Capacity Calculator-All Methods
[GEO-2025-0102-B]
Foundation Eng-Bearing Capacity Calculator-Special Cases
[GEO-2025-0103]
Foundation Eng-Bearing Capacity Calculator-Comprehensive Comparison
[GEO-2025-0104]
Foundation Eng-Bearing Capacity -Hansen-Inclined Load

โ˜‘๏ธ Group 02: Foundation Engineering-Deep Foundations
โ˜‘๏ธ 1 File:
[GEO-2025-0109]
Foundation Eng-Pile Frictional Resistance

โ˜‘๏ธ Group 03: Soil Mechanics – Soil Phase Relationships
โ˜‘๏ธ 6 Files:
[GEO-2025-0106]
Soil Mech-Soil Phase Relationships-Excel Spreadsheets
[GEO-2025-0107]
Soil Mechanics-Compaction-Consolidation-Swelling
[GEO-2025-0108]
Soil Phase Relationships-Problem01 & Step-by-Step Solution
[GEO-2025-0109]
Soil Phase Relationships-Problem02 & Step-by-Step Solution
[GEO-2025-0110]
Soil Phase Relationships-Problem03 & Step-by-Step Solution
[GEO-2025-0111]
Soil Phase Relationships-Problem04 & Step-by-Step Solution

โ˜‘๏ธ Group 04: Soil Mechanics – Soil Classification
โ˜‘๏ธ 7 Files:
[GEO-2025-0112]
Soil Mech-Unified Soil Classification System-USCS-Gravel Examples
[GEO-2025-0113]
Soil Mech-Unified Soil Classification System-USCS-Sand Examples
[GEO-2025-0114]
Soil Mech-Unified Soil Classification System-USCS-Clay&Silt-Plasticity Chart
[GEO-2025-0115]
Soil Mech-Unified Soil Classification System & Hydrometer Analysis-Fat Clay (CH)
[GEO-2025-0116]
Soil Mech-Unified Soil Classification System-USCS-Comparison
[GEO-2025-0117]
Soil Mech-Unified Soil Classification System-USCS-Comparison ith Fuller
[GEO-2025-0118]
Soil Mech-Unified Soil Classification System-USCS-Poorly Graded Soils

โ˜‘๏ธ Group 05: Soil Mechanics – Hydrometer Analysis
โ˜‘๏ธ 3 Files:
[GEO-2025-0119]
Soil Mech-Analysis of Soil Hydrometer Testing
[GEO-2025-0120]
Soil Mech-Complete Soil Gradation Curve Using Sieve and Hydrometer Analysis-Example1
[GEO-2025-0121]
Soil Mech-Complete Soil Gradation Curve Using Sieve and Hydrometer Analysis-Example2

โ˜‘๏ธ Group 06: Soil Mechanics – Effective Stress Concept
โ˜‘๏ธ 12 Files:
[GEO-2025-0122-A,B,C & D]
Soil Mech-Effective Stress-Single: (4ร—5=20 Spreadsheets)
[GEO-2025-0123-A,B,C & D]
Soil Mech-Effective Stress-Double: (4ร—5=20 Spreadsheets)
[GEO-2025-0124-A &B]
Soil Mech-Effective Stress-Double Layer-GWL Oscillation: (2ร—8=16 Spreadsheets)
[GEO-2025-0125-A &B]
Soil MechEffect of Surcharge on Effective Stress: (2ร—8=16 Spreadsheets)

โ˜‘๏ธ Group 07: Soil Mechanics – Stress Distribution in Soil
โ˜‘๏ธ 5 Files:
[GEO-2025-0126]
Soil Mech-Stress distribution in soil- Boussinesq-Point Load
[GEO-2025-0127]
Soil Mech-Stress distribution in soil- Boussinesq-Strip Loading
[GEO-2025-0128]
Soil Mechanics-Stress distribution in soil-Boussinesq-Rectangular Loading
[GEO-2025-0129-A]
Soil Mech-Stress distribution in Soil- Newmark Method
[GEO-2025-0129-B]
Soil Mech-Stress distribution in Soil- Newmark Method-Concept

โ˜‘๏ธ Group 08: Soil Mechanics – Consolidation
โ˜‘๏ธ 1 File:
[GEO-2025-0130]
Soil Mech-Consolidation

โ˜‘๏ธ Group 09: Soil Mechanics – Shear Strength
โ˜‘๏ธ 3 Files:
[GEO-2025-0131]
Soil Mechanics-Shear Strength Problems-Active & Passive
[GEO-2025-0132]
Soil Mech-Triaxial CD Test-Real Results
[GEO-2025-0133]
Soil Mech-Triaxial CU Test-Real Results

โ˜‘๏ธ Group 10: Soil Mechanics – Seepage
โ˜‘๏ธ 4 Files:
[GEO-2025-0134]
Soil Mechanics-Seepgae-Darcy’s Law
[GEO-2025-0135]
Soil Mechanics-Seepgae-Darcy Law-alpha
[GEO-2025-0136]
Soil Mechanics-Flow Net-Dam
[GEO-2025-0137]
Soil Mechanics-Flow Net & Flow Rate Concept-Dam

โ˜‘๏ธ Group 11: Soil Mechanics – Rock Quality Designation (RQD)
โ˜‘๏ธ 1 File:
[GEO-2025-0138]
Rock Mechanics & Engineering Geology-RQD

โ˜‘๏ธ Group 12: Advanced Soil Mechanics – Critical State Mechanics
โ˜‘๏ธ 2 Files:
[GEO-2025-0139]
Advanced Soil Mechanics-Critical State Mechanics-MCC-CD
[GEO-2025-0140]
Advanced Soil Mechanics-Critical State Mechanics-MCC-CU

Dear Academics, Engineers, and Enthusiasts!
Stay updated by subscribing โ€” simply send us your email at:
academy.dr.fahmi@gmail.com

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

A New Revolution in Geotechnical Engineering: Engaging Education and User-Friendly Design with GEOtExcel (Geotechnical Excel Spreadsheets)

โœ… A New Revolution in Geotechnical Engineering: Engaging Education and User-Friendly Design with GEOtExcel (Geotechnical Excel Spreadsheets)

โœ…Soil Mechanics & Foundation Engineering: GEOtExcel
Geotechnical Excel Spreadsheets

โœ… Watch unique videos on our YouTube channel:
โ–ถ๏ธ https://www.youtube.com/@Dr.Fahmi.GEOtExcel

โœ… GEOtExcel Website:
โ–ถ๏ธ https://geotexcel.com/

โœ… Welcome to the GEOtExcel! Weโ€™re glad to have you here. I am Dr. Ahmad Fahmi, the inventor of GEOtExcel. As an academic lecturer, researcher and a geotechnical engineer, my unwavering passion lies in revolutionizing geotechnical engineering education through innovation. My teamโ€™s work centers around the GeotExcel Project, where we design and develop innovative Geotechnical Excel spreadsheets including :

๐Ÿ”น Soil mechanics Spreadsheets
๐Ÿ”น Foundation Engineering Spreadsheets
๐Ÿ”น Spreadsheets for Geotechnical tests (Soil Mechanics Laboratory)

These interesting tools serve both educational and practical purposes in the field of geotechnical engineering. our vision is to make learning not only informative but also enjoyable. Through the GeotExcel Project, we aim to provide students, educators, and professionals with interactive, user-friendly spreadsheets that enhance the learning and designing experience.
Stay tuned for exciting updates, as we will soon be unveiling a series of free and commercial spreadsheets designed with added features, advanced tools, and dedicated support to meet your specific requirements. Join us on this educational journey, where we transform the way we teach and learn in the realm of geotechnical engineering. Letโ€™s make education a delightful and enriching experience together.

Dr. Ahmad Fahmi
Assistant professor
The University of Bonab

GEOtExcel = Geotechnical Excel Spreadsheets

GEOtExcel for professors & Academic Lectures

GEOtExcel for civil engineering and geotechnical engineering students

GEOtExcel for Geotechnical Engineers

GEOtExcel for Geotechnical Engineers

GEOtExcel for Civil Engineers

GEOtExcel for Geotechnical Engineers (Visit our YouTube channel and LinkedIn page)

A New Revolution in Geotechnical Engineering

A New Revolution in Geotechnical Engineering: Engaging Education and User-Friendly Design with GEOtExcel (Geotechnical Excel Spreadsheets)

https://www.linkedin.com/feed/update/urn:li:ugcPost:7276220241121021953

Soil Phase Relationships:

Soil Mechanics Lecture

Soil phase relationships describe how solids, water, and air coexist in a given volume of soil and are essential in understanding soil behavior. These relationships are crucial for assessing characteristics like density, porosity, saturation rate, and moisture content, all of which directly impact soilโ€™s engineering performance. By examining the proportions of solids, water, and air, engineers can determine how well the soil can support loads, retain moisture, or drain. Soil that is fully saturated has no air voids, while partially saturated soils contain both air and water within their void spaces. These relationships offer insights into soil’s stability, compressibility, and permeability, which are necessary for effective design in construction and environmental applications.

Watch the Related Videos on Our YouTube Channel (in English):

Soil Phase Relationships

โœ… Instagram Page Address:
โ˜‘ https://www.instagram.com/academy.dr.fahmi
โœ… Excel Spreadsheets for Soil Mechanics & Foundation Engineering
โœ… Geotechnical Excel Programs & Lectures

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Designed by Dr. Ahmad Fahmi

Bearing Capacity Calculator

โœ… Calculating Bearing Capacity Using Excel Spreadsheets

โœ… Bearing Capacity Calculator

Calculating bearing capacity using Excel spreadsheets is a practical, concept-oriented approach for geotechnical engineers and designers. By organizing key soil parameters such as cohesion, internal friction angle, and unit weight into structured spreadsheets, engineers can streamline complex calculations into manageable, step-by-step processes. Excel allows for the efficient application of various bearing capacity methods, such as Terzaghi, Meyerhof, Hansen and Vesic’s equations, with built-in formulas that simplify the determination of foundation performance under different loading conditions. These methods take into account different factors such as soil type, depth, shape, and load conditions, ensuring comprehensive analysis. The concept-oriented design of the spreadsheet not only clarifies the relationships between variables but also enables easy adjustments to parameters, making it ideal for optimizing designs and testing multiple scenarios. This approach improves both the accuracy of calculations and the clarity of data presentation for project documentation and reporting, while allowing engineers to apply industry-standard methods seamlessly.

Watch the Related Videos on Our YouTube Channel (in English):

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Bearing Capacity Calculation in an Excel spreadsheet
Foundation Engineering: Geotechnical Excel Spreadsheet

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Comprehensively learning about Bearing Capacity
Geotechnical Excel Spreadsheets

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Geotechnical Excel Spreadsheet: Foundation Engineering
Excel Spreadsheet: Foundation Engineering, Bearing Capacity, Tezaghi, Vesic, Hansen

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Foundation Engineering: Innovative Excel Spreadsheets
Excel Spreadsheets for Foundation Engineering, Bearing capacity, Terzaghi, Meyerhof, Vesic, Hansen

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Excel Spreadsheets for Geotechnical Engineering
Terzaghi’s Method, Meyerhof’s Method, Vesic’s Method, Hansen’s Method, bearing capacity

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Excel Spreadsheets for Bearing Capacity Comparison
Foundation Engineering Concept in Excel Spreadsheet: Comparison

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Foundation Engineering Excel Spreadsheet
Geotechnical Excel Spreadsheet

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Bearing capacity
Excel Spreadsheets for Geotechnical Engineering

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Geotechnical Excel Spreadsheet: Foundation Engineering
Excel Spreadsheets for Geotechnical Engineering

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Bearing Capacity, Rectangle Footing: Foundation Engineering
Excel Spreadsheet for Bearing Capacity Calculation

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Dr.Fahmi.GEOtExcel
Excel Spreadsheets for Geotechnical Engineering, Ultimate Bearing Capacity

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Geotechnical Excel Spreadsheet
Foundation Engineering: Meyerhof’s Method

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Geotechnical Excel Spreadsheet: Foundation Engineering
Bearing capacity: Meyerhof’s Method

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Foundation Engineering: Bearing capacity: Meyerhof's Method: Failure Surface
Foundation Engineering

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Foundation Engineering: Bearing capacity:
Geotechnical Excel Spreadsheet: Foundation Engineering: Failure Surface

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Geotechnical Excel Spreadsheet / Failure Surface
Meyerhof’s Method: Failure Surface

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Foundation Engineering: Bearing capacity: Meyerhof's Method
Failure Surface/ Geotechnical Excel Spreadsheet

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Terzaghi's Method: Strip, Square and Circle Foundations: Excel Spreadsheet
Foundation Engineering Problem & Solution: “Bearing Capacity: Terzaghi’s Method”

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Bearing Capacity Excel Sprreadsheets
Bearing Capacity, Terzaghi’s Method

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Foundation Engineering: Bearing Capacity Soil mechanics and Foundation Engineering Excel Spreadsheets
Soil mechanics and Foundation Engineering Excel Spreadsheets

โœ… Instagram Page Address:
โ˜‘ https://www.instagram.com/academy.dr.fahmi
โœ… Excel Spreadsheets for Soil Mechanics & Foundation Engineering
โœ… Geotechnical Excel Programs & Lectures

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Designed by Dr. Ahmad Fahmi

Using the Unified Soil Classification System (USCS) in an Excel spreadsheet for soil classification in geotechnical engineering.

Unified Soil Classification System (USCS) in an Excel spreadsheet

Watch the Related Videos on Our YouTube Channel (in English):

https://lnkd.in/dV_QXBKC

To use the Unified Soil Classification System (USCS) in Excel for soil classification in geotechnical engineering, you start by entering soil test data, such as grain size distribution and Atterberg limits, into structured columns. Parameters like particle size percentages and consistency limits are included. Logical formulas are applied to classify the soil based on these data. For example, if over 50% of the particles pass through the No. 200 sieve, the soil is classified as fine-grained; otherwise, it is coarse-grained. Additional criteria like plasticity index and liquid limit further refine the classification into categories like CL, ML, or SM.

GW-GM is a dual classification in USCS, indicating a mix of well-graded gravel (GW) and silty gravel (GM). Well-graded gravel has a wide range of particle sizes, improving compaction and strength, while the silty component suggests the presence of fine particles, which slightly reduces permeability and increases cohesion. This combination provides a balance between stability and drainage, making it suitable for various engineering applications.

โœ… Instagram Page Address:
โ˜‘ https://www.instagram.com/academy.dr.fahmi
โœ… Excel Spreadsheets for Soil Mechanics & Foundation Engineering
โœ… Geotechnical Excel Programs & Lectures

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Designed by Dr. Ahmad Fahmi

How to utilize the Unified Soil Classification System (USCS) in an Excel spreadsheet for soil classification in geotechnical engineering?

Unified Soil Classification System (USCS) in an Excel spreadsheet

Watch the Related Videos on Our YouTube Channel (in English):

https://lnkd.in/dV_QXBKC

To utilize the Unified Soil Classification System (USCS) in an Excel spreadsheet for soil classification in geotechnical engineering, you can follow a structured approach. First, input your soil test data, such as grain size distribution (sieve analysis) and Atterberg limits (liquid and plastic limits). Create columns for parameters like particle size percentages (gravel, sand, silt, clay), and consistency limits.

Using these data, set up logical conditions and formulas in Excel to classify the soil. For example, if more than 50% of the particles pass through the No. 200 sieve, it would be classified as “fine-grained,” whereas if less than 50% pass, it would be “coarse-grained.” Use additional conditions based on plasticity index (PI) and liquid limit (LL) to further refine the classification into categories like CL (clay with low plasticity), ML (silt with low plasticity), or SM (silty sand). By organizing the data into such formulas, Excel can automatically classify soils according to USCS standards based on the inputted test results, streamlining the soil classification process.

GP-GC is a dual classification in the Unified Soil Classification System (USCS), representing a soil mixture that consists of poorly graded gravel (GP) and clayey gravel (GC). Poorly graded gravel indicates a lack of a wide range of particle sizes, meaning the gravel is uniform in size, while the clayey component suggests the presence of a significant amount of clay, which affects the soil’s cohesiveness and plasticity. This type of soil generally has lower permeability and higher compressibility due to the clay content

โœ… Instagram Page Address:
โ˜‘ https://www.instagram.com/academy.dr.fahmi
โœ… Excel Spreadsheets for Soil Mechanics & Foundation Engineering
โœ… Geotechnical Excel Programs & Lectures

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Designed by Dr. Ahmad Fahmi

How to Efficiently Calculate Effective Stress, Total Stress, and Pore Water Pressure Using Excel Spreadsheets?

Effective Stress, Total Stress, and Pore Water Pressure Calculation

Watch the Related Videos on Our YouTube Channel (in English):

https://youtu.be/OPpBxALQt7c

To efficiently calculate effective stress, total stress, and pore water pressure using Excel spreadsheets, start by organizing your data, such as soil depth, unit weights, and water levels, in a clear and logical layout. Set up separate columns for each input variable to keep the data structured and easy to update. Next, apply Excel functions to calculate total stress based on the depth of the soil and its unit weight, and pore water pressure by considering the water conditions. The effective stress is then determined by subtracting pore water pressure from total stress. Excelโ€™s features like auto-calculation, data validation, and conditional formatting can streamline the process, ensuring accuracy and allowing you to easily modify inputs to explore different scenarios. This setup provides a simple yet powerful tool for performing geotechnical stress analysis.

โœ… Instagram Page Address:
โ˜‘ https://www.instagram.com/academy.dr.fahmi
โœ… Excel Spreadsheets for Soil Mechanics & Foundation Engineering
โœ… Geotechnical Excel Programs & Lectures

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Designed by Dr. Ahmad Fahmi

How to calculate the “Bearing Capacity” in an Excel spreadsheet: Vesic’s method?

Bearing Capacity in an Excel spreadsheet: Vesic’s method

Vesic’s method is a widely used approach in geotechnical engineering for determining the bearing capacity of soils. Building on previous methods like Terzaghiโ€™s, Vesic incorporated advancements in plasticity theory to account for more complex soil conditions. His method provides more accurate predictions by considering factors such as foundation shape, depth, soil compressibility, and load inclination. This makes it especially useful in cases involving layered soils, deep foundations, and variable load conditions, offering greater precision in assessing the stability and capacity of foundations.

Watch the Related Videos on Our YouTube Channel (in English):

https://youtu.be/xafDNzuvdWM

https://youtu.be/38tm9A98ZEA

https://youtu.be/onJhva8dyxY

โœ… Instagram Page Address:
โ˜‘ https://www.instagram.com/academy.dr.fahmi
โœ… Excel Spreadsheets for Soil Mechanics & Foundation Engineering
โœ… Geotechnical Excel Programs & Lectures

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Designed by Dr. Ahmad Fahmi

Understanding Soil Phase Relationships Using Excel Spreadsheets

Understanding Soil Phase Relationships: Problem and Illustrative Solution:

Watch the Video on Our YouTube Channel (in English):

โœ… Instagram Page Address:
โ˜‘ https://www.instagram.com/academy.dr.fahmi
โœ… Excel Spreadsheets for Soil Mechanics & Foundation Engineering
โœ… Geotechnical Excel Programs & Lectures

Grasping the relationships between soil’s different phases is vital in geotechnical engineering and soil science. These phasesโ€”solid particles, water, and airโ€”interact in ways that deeply influence key soil properties, such as density, porosity, and moisture content. The balance and interaction of these phases dictate how soil will perform under various conditions. By studying these relationships, engineers can more precisely predict soil behavior, which is critical for designing and building stable, safe structures.

https://www.youtube.com/@Dr.Fahmi.GEOtExcel

Designed by Dr. Ahmad Fahmi