GEOtExcel Archives - Page 3 of 3

Soil Mechanics – Seepage & Darcy’s Law | Geotechnical Excel Spreadsheets

July 27, 2025 by Dr. Ahmad Fahmi

Soil Mechanics – Seepage & Darcy’s Law | Geotechnical Excel Spreadsheets

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

We are excited to present the Seepage & Darcy’s Law spreadsheet pack, part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 8 essential spreadsheets designed for soil mechanics and geotechnical engineering professionals to analyze and calculate seepage, hydraulic gradient, and flow rate using Darcy’s Law.

What’s Included in the 8 Spreadsheets?

Start: Introduction sheet to Darcy’s Law and seepage analysis.
Darcy’s law-01: Hydraulic gradient concept — Part 1.
Darcy’s law-02: Hydraulic gradient concept — Part 2.
Darcy’s law-03: Darcy’s Law concept — Part 1, with visual explanations.
Darcy’s law-04: Darcy’s Law concept — Part 2, focusing on soil characteristics and flow.
Darcy’s law-05: Darcy’s Law flow rate calculation — Part 1, covering theoretical concepts.
Darcy’s law-06: Darcy’s Law flow rate calculation — Part 2, applying real data.
Darcy’s law-07: Darcy’s Law flow rate calculation — Part 3, advanced application and results.

Applications in Soil Mechanics and Geotechnical Engineering:

Seepage and Flow Rate Analysis: Calculate flow rate and seepage in soil based on Darcy’s law.
Hydraulic Gradient: Understand and apply the hydraulic gradient concept in various soil conditions.
Darcy’s Law: Deep dive into Darcy’s law for seepage and fluid flow through porous materials.
Practical Tools for soil mechanics and geotechnical engineering projects.
Laboratory & Field Testing: Use for soil testing and site investigations in civil and geotechnical projects.
Educational Use: Ideal for students, lecturers, and professionals learning and applying seepage 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:

📺 Geotechnical Excel YouTube Channel
💼 LinkedIn Company Page

👨‍🏫 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
Foundation Engineering
Geotechnical Lab Testing
➡️ Subscribe on YouTube

Soil Mechanics – Consolidation (Single and Double Drainage) | Geotechnical Excel Spreadsheets

July 27, 2025 by Dr. Ahmad Fahmi

Soil Mechanics – Consolidation (Single and Double Drainage) | Geotechnical Excel Spreadsheets

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

We are excited to introduce the Consolidation spreadsheet pack for single and double drainage scenarios as part of the Geotechnical Excel Spreadsheets (2025-1) collection. This set includes 5 essential spreadsheets designed for soil mechanics calculations, focusing on consolidation under different drainage conditions. The pack includes detailed calculations and graphs for total stress, pore water pressure, effective stress, and provides insights into stress distribution in soil.

What’s Included in the 5 Spreadsheets?

Start: The introductory sheet for Consolidation, covering single drainage and double drainage methods.
Single drainage-min: Single drainage Consolidation sheet with Cv unit in cm²/min, with a drainage height of 2 cm.
Single drainage-day: Single drainage Consolidation sheet with Cv unit in m²/day, with a drainage height of 5 m.
Double Drainage-min: Double drainage Consolidation sheet with Cv unit in cm²/min, with a drainage height of 2 cm.
Double Drainage-day: Double drainage Consolidation sheet with Cv unit in m²/day, with a drainage height of 5 m.

Applications in Soil Mechanics and Geotechnical Engineering:

Calculate consolidation for soil under both single and double drainage conditions.
Analyze coefficient of consolidation (Cv) in different units: cm²/min and m²/day.
Single Drainage vs. Double Drainage scenario comparisons for soil consolidation.
Consolidation testing and fieldwork for soil behavior in various drainage conditions.
Educational use for soil mechanics and geotechnical engineering courses.
Practical tool for civil engineers working on foundation and soil stability projects.

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

📺 Geotechnical Excel YouTube Channel
💼 LinkedIn Company Page

👨‍🏫 About Dr. Ahmad Fahmi

📌 Stay Updated:

Subscribe for upcoming lectures on:

Soil Mechanics
Foundation Engineering
Geotechnical Lab Testing
➡️ Subscribe on YouTube

Soil Mechanics – Effective Stress for Single Layer Soil Profile | GEOtExcel Spreadsheets

July 27, 2025 by Dr. Ahmad Fahmi

Soil Mechanics – Effective Stress for Single Layer Soil Profile | GEOtExcel Spreadsheets

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

We are excited to present the Effective Stress for Single Layer Soil Profile spreadsheet pack, part of the GEOtExcel (2025-1) collection. This set includes 20 sheets, designed for geotechnical engineers, soil mechanics students, and civil engineers looking to calculate and visualize effective stress in a single-layer soil profile. The pack includes essential calculations and graphs for total stress, pore water pressure, and effective stress in both kg/m² and kN/m² units.

What’s Included in the 20 Spreadsheets?

Start: Introduction sheet for Effective Stress calculations (kg-Layout 1).
Single Layer-kg: Main sheet explaining the Effective Stress concept for a single-layer profile in kg/m².
TS-01: Calculation Sheet 1 for Total Stress calculation and associated graph.
u-01: Calculation Sheet 2 for Pore Water Pressure calculation and graph.
ES-01: Calculation Sheet 3 for Effective Stress calculation and graph.
[GEO-2025-0122-A] – kg-Layout 1: Effective Stress layout for kg/m².
[GEO-2025-0122-B] – kg-Layout 2: Second layout for Effective Stress using kg/m².
[GEO-2025-0122-C] – kN-Layout 1: Effective Stress layout for kN/m².
[GEO-2025-0122-D] – kN-Layout 2: Second layout for Effective Stress using kN/m².

Applications in Soil Mechanics and Geotechnical Engineering:

Performing effective stress analysis in single-layer soil profiles
Calculating and visualizing total stress, pore water pressure, and effective stress
Teaching and learning about effective stress concepts in soil mechanics
Suitable for geotechnical testing, field work, and laboratory experiments
Ideal for use in civil engineering projects and foundation design
Comprehensive graphs for visual understanding and data interpretation

📦 Part of GEOtExcel 2025-1 Collection

This product is part of the GEOtExcel (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 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
💼 LinkedIn Company Page

👨‍🏫 About Dr. Ahmad Fahmi

📌 Stay Updated:

Subscribe for upcoming lectures on:

Soil Mechanics
Foundation Engineering
Geotechnical Lab Testing
➡️ Subscribe on YouTube

Soil Mechanics – Analysis of Soil Hydrometer Testing | Geotechnical Excel Spreadsheets

July 27, 2025 by Dr. Ahmad Fahmi

Soil Mechanics – Analysis of Soil Hydrometer Testing | Geotechnical Excel Spreadsheets

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

We are pleased to introduce the Soil Hydrometer Testing Analysis spreadsheet pack, part of the GEOtExcel (2025-1) collection. This set includes 7 comprehensive spreadsheets designed for geotechnical engineers and soil mechanics students to perform hydrometer analysis and determine soil properties such as effective depth, k-value, and temperature correction factors.

What’s Included in the 7 Spreadsheets?

Start: The introductory sheet to begin the hydrometer analysis for soil.
Calculation: Comprehensive sheet for input, computation, and output tables for the soil hydrometer analysis process.
Table 1: Table for Effective Depth (L) determination based on actual hydrometer reading (RC1).
Table 2: Table for k-value determination based on Gs (specific gravity) and temperature in soil hydrometer analysis.
Table 2-Full: Expanded version of Table 2 for more detailed k-value determination.
Table 3: Sheet for determining the Temperature Correction Factor (CT) during soil hydrometer analysis.
Table 3-Full: Extended version of Table 3 for accurate temperature correction factor determination.

Applications in Soil Mechanics and Geotechnical Engineering:

Perform soil classification tests using hydrometer analysis
Accurately determine soil’s effective depth and specific gravity (Gs)
Calculate k-value based on real lab data
Apply temperature correction factor (CT) to soil behavior analysis
Educational use for soil mechanics and geotechnical engineering courses
Useful for soil testing and lab experiments

📦 Part of GEOtExcel 2025-1 Collection

This product is part of the GEOtExcel (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 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
💼 LinkedIn Company Page

👨‍🏫 About Dr. Ahmad Fahmi

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

📌 Stay Updated:

Subscribe for upcoming lectures on:

Soil Mechanics
Foundation Engineering
Geotechnical Lab Testing
➡️ Subscribe on YouTube

How to Buy GEOtExcel and Use It on Your PC

July 28, 2025June 3, 2025 by Dr. Ahmad Fahmi

GEOtExcel (2025-1)

GEOtExcel (2025-1)

We are excited to announce the release of GEOtExcel (2025-1), now more accessible, secure, and permanently usable on your personal computer. Based on valuable user feedback, we’ve enhanced the delivery method. GEOtExcel is now available as an Excel-based desktop application, offering the following advantages:

✅ Lifetime, unlimited access on your personal computer
✅ Save, print, and manage data locally, with no restrictions
✅ No internet or cloud connection required

🔺 Important Note:
The current version (2025-1) is fully functional and permanently usable on the registered computer. Should future versions be released, existing users will enjoy special discounts for upgrading.

📦 How to Order GEOtExcel – Version 2025

To get started, follow these simple steps:

Download and unzip the provided package: Download here The package contains two Excel files:
- File 1: GET ID
  This file helps you extract your computer’s unique ID. Open it, then click the “Copy Computer ID” button to copy your ID.
- File 2: Agreement
  This file has 3 sheets:
  - Sheet 1: Price List – Select the GEOtExcel files you wish to purchase; the total price will be automatically calculated.
  - Sheet 2: Customer & PC Info – Fill in your contact details and paste the copied Computer ID.
  - Sheet 3: Agreement – Review and sign the agreement.
Send the completed Agreement file to:
📧 academy.dr.fahmi@gmail.com

File Safety Assurance

The “Get ID.exe” file and the GEOtExcel files (which will be shared with you after we receive the completed agreement) are all safe. If your antivirus or firewall issues a warning, please rest assured that the files are secure and can be downloaded and run without concern.

You can be fully confident that our support team will assist you throughout the entire process — including payment, installation, and file delivery. If you have any questions, please feel free to ask. We will guide you through the installation process.

Thank you for choosing GEOtExcel.
GEOtExcel Support Team

Agreement Instruction Video

GEOtExcel: Geotechnical Excel Spreadsheets

Soil Mechanics: Effective Stress Concept

Bearing Capacity Factors: Meyerhof, Hansen,Vesić

April 12, 2024March 28, 2024 by Dr. Ahmad Fahmi

Cost-Free Excel Spreadsheet:

In geotechnical engineering, bearing capacity is the soil’s ability to support applied loads. It’s the maximum pressure between the foundation and soil that won’t cause failure. Ultimate bearing capacity is the highest pressure soil can handle without failing, while allowable bearing capacity considers a safety factor. Soft soil may settle under load without failing, so allowable bearing capacity can be based on acceptable settlement. Allowable bearing pressure is the maximum pressure soil can handle without failure, while ultimate bearing capacity is the pressure before failure.
In this freely available Excel spreadsheet, you’ll find Bearing Capacity Factors based on methodologies by Meyerhof, Hansen, and Vesić.