Foundation Design

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

by

✅ 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

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

by

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

by

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

by

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

by

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

by

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:

Soil Mechanics – Stress Distribution in Soil Using Boussinesq Theory (Rectangular Loading) / Geotechnical Excel Spreadsheets

by

Soil Mechanics – Stress Distribution in Soil Using Boussinesq Theory (Rectangular Loading)

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

We are excited to introduce the Stress Distribution in Soil Using Boussinesq Theory (Rectangular Loading) spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 4 essential spreadsheets designed to help soil mechanics professionals, students, and geotechnical engineers calculate and analyze vertical stress distribution in soil under rectangular loading using Boussinesq theory.

This pack provides solutions for computing stress distribution and includes influence charts that are crucial for foundation design and soil behavior analysis in areas affected by varying load conditions.

What’s Included in the 4 Spreadsheets?

  1. Start: Stress Distribution in Soil – Boussinesq Theory – Rectangular Loading – Introduction sheet for stress distribution analysis.
  2. Rectangular Loading: Calculation Sheet for Stress Distribution in soil using Boussinesq Theory for vertical stress calculation.
  3. Influence-Main: Influence Chart for Computing Vertical Stress – Visual tool for calculating stress distribution.
  4. Influence-Image: Influence Chart Image – A graphical representation of the influence chart for stress calculations.

Applications in Soil Mechanics and Geotechnical Engineering:7

  • Stress Distribution: Use Boussinesq theory to calculate vertical stress distribution in soil under rectangular loading conditions.
  • Influence Charts: Generate and interpret influence charts for accurate stress calculations in different soil conditions.
  • Foundation Design: Essential for designing foundations in geotechnical engineering projects affected by varying load distribution.
  • Practical Tool: Ideal for soil testing, foundation stability analysis, and site investigations in geotechnical projects.
  • Educational Tool: Useful for soil mechanics and geotechnical engineering courses focusing on load distribution and stress analysis in soils.

📦 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 – Effective Stress with Double Layer and Groundwater Oscillation | Geotechnical Excel Spreadsheets

by

Soil Mechanics – Effective Stress with Double Layer and Groundwater Oscillation | Geotechnical Excel Spreadsheets

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

We are excited to introduce the Effective Stress with Double Layer and Groundwater Oscillation spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 16 powerful spreadsheets designed for soil mechanics professionals, students, and geotechnical engineers to analyze the effects of groundwater oscillation on effective stress variation in double layer soil systems.

This pack enables users to perform detailed calculations for total stress, pore water pressure, and effective stress, before and after groundwater oscillation, which is essential for foundation and soil stability analysis in areas affected by fluctuating water levels.

What’s Included in the 16 Spreadsheets?

  1. Start: Effective Stress (kg-Layout 1) – Introduction sheet for calculating effective stress in double layer soil systems.
  2. Double Layer-kg: Main Super Sheet – Analyzing the effect of groundwater oscillation on effective stress variation (kg/m²).
  3. D1: Calculation Sheet 1 – Total Stress Calculation and graph before groundwater oscillation.
  4. D2: Calculation Sheet 2 – Pore Water Pressure Calculation and graph before groundwater oscillation.
  5. D3: Calculation Sheet 3 – Effective Stress Calculation and graph before groundwater oscillation.
  6. D4: Calculation Sheet 1 – Total Stress Calculation and graph after groundwater oscillation.
  7. D5: Calculation Sheet 1 – Pore Water Pressure Calculation and graph after groundwater oscillation.
  8. D6: Calculation Sheet 1 – Effective Stress Calculation and graph after groundwater oscillation.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Effective Stress Calculation: Calculate the effective stress in double layer soils under varying groundwater conditions.
  • Groundwater Oscillation Effects: Analyze how oscillating groundwater affects total stress, pore water pressure, and effective stress.
  • Foundation Design: Essential for designing foundations in areas where groundwater levels fluctuate.
  • Practical Tool: Ideal for geotechnical engineers, soil mechanics professionals, and students working on foundation stability and soil behavior analysis.
  • Educational Use: A valuable teaching tool for soil mechanics and geotechnical engineering courses, particularly for understanding stress variations under groundwater changes.

📦 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 – Complete Soil Gradation Curve Using Sieve and Hydrometer Analysis | Geotechnical Excel Speadsheets

by

Soil Mechanics – Complete Soil Gradation Curve Using Sieve and Hydrometer Analysis | Example 2 (GP-GM Soil)

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

We are pleased to introduce Example 2 (GP-GM Soil) from our Complete Soil Gradation Curve series. This set of Geotechnical Excel Spreadsheets includes 10 powerful spreadsheets for analyzing sieve and hydrometer test data to create a complete soil gradation curve for GP-GM soils (Gravelly Poorly Graded Sand and Gravel Mixture). These spreadsheets also include k-value determination and the calculation of temperature correction factors.

This set is ideal for soil mechanics professionals, students, and geotechnical engineers involved in soil classification, foundation design, and site investigations.

What’s Included in the 10 Spreadsheets?

  1. Start: Hydrometer Analysis of GP-GM Soil – Introduction sheet for analysis of GP-GM soils.
  2. Input Data: Sieve and Hydrometer Test Data – Enter the data from the sieve and hydrometer tests for full analysis.
  3. Sieve Analysis: Sieve Analysis Table and corresponding gradation curve for GP-GM soil.
  4. Hydrometer Analysis: Detailed hydrometer analysis tables for soil gradation calculations.
  5. Sieve & Hydrometer Analysis: Combining sieve and hydrometer data for full gradation analysis.
  6. USCS: Unified Soil Classification System (USCS Process Table) – Soil classification based on the USCS system.
  7. Important Note: Hydrometer test results are also necessary for accurate analysis in this particular example.
  8. Table 1: k-Value Determination based on Gs and temperature in soil hydrometer analysis.
  9. Table 2: Another k-Value Determination table for additional soil analysis.
  10. Table 3: Temperature Correction Factor (CT) determination for hydrometer analysis.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Soil Gradation Analysis: Combine sieve and hydrometer test data to create a complete soil gradation curve for GP-GM soils.
  • Soil Classification: Classify soil using the Unified Soil Classification System (USCS) based on test data.
  • k-Value Determination: Accurately calculate k-values for soil hydrometer analysis based on specific gravity (Gs) and temperature.
  • Temperature Correction: Use the temperature correction factor (CT) to adjust for temperature variations in hydrometer analysis.
  • Practical Use: Essential for soil testing, foundation design, site investigations, and geotechnical analysis.
  • Educational Tool: Ideal for soil mechanics and geotechnical engineering students and professionals to understand soil behavior and gradations.

📦 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 Comparison of Classic Methods | Terzaghi, Vesic, and Meyerhof | Geotechnical Excel Spreadsheets

by

Foundation Engineering – Bearing Capacity Comparison of Classic Methods | Terzaghi, Vesic, and Meyerhof | Geotechnical Excel Spreadsheets

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

We are pleased to present the Bearing Capacity Comparison of Classic Methods spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This comprehensive set includes 15 powerful spreadsheets designed to help soil mechanics professionals and students compare bearing capacity using the classic methods of Terzaghi, Vesic, and Meyerhof. The pack allows you to calculate bearing capacity factors, shape and depth factors, and analyze solutions for different foundation types.

These spreadsheets are essential for foundation engineers, geotechnical engineers, and students who need to understand and apply these classic methods for real-world foundation design.

What’s Included in the 15 Spreadsheets?

  1. Start: GEOtExcel: Foundation Engineering-Bearing Capacity Calculator – Comprehensive Comparison – Overview and introduction sheet.
  2. Problem: A rectangular foundation with width B, length L, and other parameters for various student IDs.
  3. Problem-public: Rectangular foundation analysis for public student ID.
  4. Comprehensive Comparison: Comprehensive Bearing Capacity Comparison using Terzaghi, Vesic, and Meyerhof methods.
  5. N Factors: Bearing Capacity Factors (Nc, Nq, and Ng) – Formulas for calculating key bearing capacity factors.
  6. Bearing-Capacity Factors: Comprehensive Bearing Capacity Factors calculation for Terzaghi, Vesic, and Meyerhof methods.
  7. Shape & Depth Factors: Comprehensive Shape and Depth Factors for Vesic, Hansen, and Meyerhof methods.
  8. Terzaghi: Solution Using Terzaghi Bearing Capacity Calculator – Layout 1 for a rectangular foundation.
  9. Vesic1: Solution Using Vesic Bearing Capacity Calculator for a rectangular foundation.
  10. Vesic2: Solution Using Vesic Bearing Capacity Calculator – Layout 2 for a more detailed analysis.
  11. Shape & Depth Factors-(V): Comprehensive Shape and Depth Factors for Vesic’s Method.
  12. Hansen: Solution Using Hansen Bearing Capacity Calculator for a rectangular foundation.
  13. Shape & Depth-(H): Comprehensive Shape and Depth Factors for Hansen’s Method.
  14. Meyerhof: Solution Using Meyerhof Bearing Capacity Calculator for a rectangular foundation.
  15. Shape & Depth-(M): Comprehensive Shape and Depth Factors for Meyerhof’s Method.

Applications in Soil Mechanics and Geotechnical Engineering:

  • Bearing Capacity Comparison: Compare Terzaghi, Vesic, and Meyerhof methods for estimating foundation bearing capacity.
  • Practical Solutions: Use comprehensive solutions and calculations for rectangular foundations and varying foundation depths.
  • Bearing Capacity Factors: Calculate Nc, Nq, and Ng bearing capacity factors for accurate foundation design.
  • Shape and Depth Factors: Understand how shape and depth factors influence bearing capacity in each method.
  • Educational Use: Ideal for soil mechanics and geotechnical engineering courses on foundation design and bearing capacity analysis.
  • Real-World Application: Essential for geotechnical engineers, foundation design, and site investigations.

📦 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: