Soil Mechanics and Foundation Engineering/ Dr. Ahmad Fahmi / Professional Excel Spreadsheet Designer
Soil Mechanics and Foundation Engineering/ Dr. Ahmad Fahmi / Professional Excel Spreadsheet Designer

Soil Mechanics and Foundation Engineering/ Dr. Ahmad Fahmi / Professional Excel Spreadsheet Designer

In the name of God /Dr. Ahmad Fahmi's Weblog

Soil Mechanics and Foundation Engineering for Professors, Engineers and Students,

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)


https://s32.picofile.com/file/8481971376/A03.png

GEOtExcel for professors & Academic Lectures

https://s32.picofile.com/file/8481971400/A01.png

A New Revolution in Geotechnical Engineering

https://s32.picofile.com/file/8481971426/A04.png

GEOtExcel for Civil Engineering and Geotechnical engineering students

https://s32.picofile.com/file/8481971442/A05.png

GEOtExcel for Geotechnical Engineers

https://s32.picofile.com/file/8481971450/A06.png


https://s32.picofile.com/file/8481971468/A07.png

GEOtExcel for Civil Engineers

https://s32.picofile.com/file/8481971500/A08.png

GEOtExcel for Geotechnical Engineers

https://s32.picofile.com/file/8481971518/KAPA.png

Khak Azma Pey Afzar (KAPA) Company Logo


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


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

A New Revolution in Geotechnical Engineering: (Geotechnical Excel Spreadsheets)-Part1

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

Assistant Professor / Geotechnical Engineering Consultant / Soil Mechanics Laboratory Specialist / Foundation Engineering Designer / Excel Spreadsheet Designer & Developer / Civil Engineer / University Lecturer

In the dynamic and ever-changing world of geotechnical engineering, valuable resources such as textbooks and professional software are available for education, design, and report writing in this field. However, there is a clear gap: the absence of engaging software tools that can transform learning and design into an enjoyable experience.

https://www.linkedin.com/pulse/new-revolution-geotechnical-engineering-engaging-education-fahmi-6zyxf/?trackingId=Vs0n7LBBQFqeHs5NJDSu%2Fg%3D%3D


Why GEOtExcel?

GEOtExcel is designed with one goal in mind: to provide an innovative, interactive tool built on Microsoft Excel, leveraging Visual Basic and macros to create a user-friendly and professional environment. Importantly, users do not need to be familiar with Visual Basic or macro programming. All tools and calculations are designed to be easily accessible with just a few simple clicks. With this program, instructors can teach complex concepts dynamically, students can engage interactively, and engineers can produce professional reports.

A New Revolution in Geotechnical Engineering

Join us as we unveil a fresh experience in Geotechnical engineering!


The Main Objective of GEOtExcel

This article explores the story behind the design of the GEOtExcel suite of programs, its unique features, and why this tool has become essential for professionals in the field.

For professors & Academic Lectures

GEOtExcel is more than just a computational tool; it is designed to revolutionize the teaching of geotechnical engineering concepts. Courses in soil mechanics, foundation engineering, geotechnical laboratory, rock mechanics, engineering geology, advanced soil mechanics, advanced foundation engineering, soil behavior modeling, and other geotechnical subjects are taught in a new and engaging way with GEOtExcel. Professors can use this tool to teach complex concepts dynamically through real-time calculations and graphs, turning the process into an enjoyable and rewarding experience for both themselves and their students.

For Students

Students can interactively learn geotechnical engineering concepts by adjusting parameters and observing immediate results. This method resembles an educational game, helping them deeply understand and enjoy the learning process. By mastering concepts and becoming familiar with design and report-writing methods, they can confidently prepare for job interviews and pave the way for future career success.

For Geotechnical engineers

Geotechnical engineers, laboratory experts in soil and rock mechanics, and field researchers can use GEOtExcel to accurately analyze lab data and create professional and engaging geotechnical reports with the help of visual tools. They will enjoy the process of analysis, design, and report writing, making their work both efficient and rewarding.


GEOtExcel for professors & Academic Lectures
GEOtExcel for Students


GEOtExcel for Geotechnical Engineers

Creativity in GEOtExcel: Why Is This Tool Unique?

In a market filled with technical tools, GEOtExcel stands out by adding a creative touch. Just as an artist carefully crafts a masterpiece, every detail in GEOtExcel has been meticulously designed to meet the specific needs of academic staff, students, and geotechnical engineers.

Geotechnical Excel Spreadsheet Samples:

Foundation Engineering: Bearing Capacity Comparision
Soil Mechanics: Seepage: Flow Net
Soil Mechanics: CD Triaxial Test
Rock Mechanic: RQD

GEOtExcel: Geotechnical Excel Spreadsheets

Explore more examples towards the end of the article!

Explore more examples towards the end of the article


Learn More About GEOtExcel

Want to see GEOtExel in action? Check out our tutorials and resources:

 Website: www.geotexcel.com

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

• LinkedIn: https://www.linkedin.com/in/ahmad-fahmi-excel/

• ResearchGate: https://www.researchgate.net/publication/GEOtExcel


High Demand for GEOtExcel: Free Trial Available Now and Product Catalog for Purchase Coming Soon

To date, hundreds of customers have requested to purchase the GEOtExel program, and the product catalog along with pricing will be available soon. Meanwhile, two free programs are offered on the GEOtExel website, allowing you to experience the enjoyable use of these sheets:

1) Consolidation (Excel File Download Link):

https://geotexcel.com/geotexcel-consolidation-spreadsheet-is-presented-as-a-gift-to-our-subscribers-and-followers/

Soil Mechanics: Soil Consolidation

2) Bearing Capacity Factors (Excel File Download Link):

https://geotexcel.com/bearing-capacity-factorsmeyerhofhansenvesic/

Foundation Engineering: Bearing Capacity Factors

Feedback

You can find a selection of user feedback on my LinkedIn page, as well as on the LinkedIn Page and YouTube channel:

LinkedIn:

YouTube:


Feedback on the Linkedin Page and YouTube channel

Future Plans

GEOtExcel’s personal brand, created by me, Ahmad Fahmi, a university faculty member with over 20 years of experience in geotechnical engineering, has now evolved into a reputable organizational brand. With the registration of KAPA (Khak Azma Pey Aafzar) as a knowledge-based company, GEOtExcel has entered a new phase of development. The goal of this company is to recruit specialized talent to further enhance this software in the field of geotechnical engineering.

Our long-term vision is to design and develop innovative, education-focused programs for courses in civil engineering, mining engineering, and engineering geology in the coming years. GEOtExcel is more than just software; it will be a tool for transforming education and design in these academic fields.


GEOtExcel Future Plans

Conclusion

GEOtExel, as an innovative and user-friendly tool in geotechnical engineering, has uniquely addressed the educational, design, and report-writing needs of this field. By simplifying complex concepts and providing an interactive environment, this software makes the learning experience enjoyable for students while enabling instructors to teach dynamically and effectively.

Moreover, GEOtExcel serves as a powerful tool for engineers and specialists, helping them analyze lab data and generate professional reports while enhancing productivity and the quality of their work. Most importantly, users don’t need to know coding or macro programming; this feature makes GEOtExcel accessible to all users, regardless of skill level.

This tool not only bridges the gap in the educational and design processes but also creates a delightful and professional experience, leading to a brighter future for geotechnical engineering. GEOtExcel is not just a tool—it is a pivotal step towards transforming learning and design in this field.

GEOtExel, as an Innovative and User-friendly Tool in Geotechnical Engineering

Follow Us for More Information on GEOtExcel!"

"GEOtExcel is experiencing high demand, and the free trial is available now! To receive the product catalog and learn more details, make sure to follow our LinkedIn page and check out our educational videos on our YouTube channel. By following our pages, you’ll stay updated with the latest news and insights, and get the most out of GEOtExcel’s unique features. Join us and enjoy the experience!"

"Follow us and don’t miss out on our educational videos!"

GEOtExcel: Geotechnical Excel Spreadsheets (Dr. Ahmad Fahmi)

Explore more Excel Spreadsheet Examples (GEOtExcel):

1) Soil Mechanics

  • Soil Phase Relationships
  • Compaction of Soils
  • Atterberg Limits
  • Soil Classification
  • Permeability & Seepage, Flow Net
  • Stress Distribution in Soil
  • Effective Stress
  • Consolidation & Settelment
  • Shear Strength of Soils
  • Slope Stability

2) Soil Mechanics Laboratory

  • Moisture Content Test
  • Specific Gravity Test
  • Unit Weight Determination
  • Sieve Analysis (Soil Particle Size Analysis)
  • Atterberg Limits (Liquid Limit Test & Plastic Limit Test)
  • Constant Head Permeability Test
  • Falling Head Permeability Test
  • Proctor Test (Standard and modified compaction tests)
  • Oedometer Test
  • Direct Shear Test
  • Unconfined Compression Test
  • Triaxial Test (Consolidated drained, undrained, and unconsolidated undrained tests)
  • Sand Cone Method


3) Advanced Soil Mechanics

Critical State Soil Mechanics:

  • Cam-Clay and Modified Cam-Clay (NC)
  • Cam-Clay and Modified Cam-Clay (LOC)
  • Cam-Clay and Modified Cam-Clay (HOC)


4) Foundation Engineering

  • Bearing Capacity: Terzaghi's Method
  • Bearing Capacity: Myeerhof's Method
  • Bearing Capacity: Hansen's Method
  • Bearing Capacity: Vesic's Method
  • Bearing Capacity: Comparison
  • Effects of water table and eccentric loading on bearing capacity
  • Settlement Analysis of Foundations
  • Deep Foundations (Load capacity of piles)
  • Retaining Structures

5) Rock Mechanics

  • Rock Quality Designation (RQD)

Explore more Excel Spreadsheet Examples (Images):

1) Soil Mechanics

Soil Mechanics: Soil Phase Relationships
Soil Mechanics: Soil Phase Relationships:Unit Weight
Soil Mechanics: Soil Phase Relationships: Problem & Solution
Soil Mechanics: Soil Phase Relationships: Problem & Solution
Soil Mechanics: Seepage: Darcy's Law
Soil Mechanics: Seepage: Flow Net
Soil Mechanics: Seepage: Flow Rate Calculation
Soil Mechanics: Compaction - Consolidation - Swelling
Soil Mechanics: Consolidation: Double Drainage Consolidation
Soil Mechanics: Consolidation: Single Drainage Consolidation
Soil Mechanics: Effective Stress, Total Stress, Pore Water Pressure
Soil Mechanics: Effective Stress
Soil Mechanics: Mohr-Coulomb Theory (Active & Passive)
Soil Mechanics: Soil Particle Size Analysis
Soil Mechanics: Plasticity Chart
Soil Mechanics: Unified Soil classification System (USCS)
Soil Mechanics: Stress Distribution in Soil
Soil Mechanics: Stress Distribution in Soil: Newmark's Method
Soil Mechanics: Stress Distribution in Soil: Stress Bulb
Soil Mechanics: Stress Distribution: Stress Bulb
Soil Mechanics: Stress Distribution in Soil: Stress Bulb

2) Soil Mechanics Laboratory

Soil Mechanics Laboratory: Triaxial CD
Soil Mechanics Laboratory: Tiaxial CU
Soil Mechanics Laboratory: Hydrometer & Sieve Analysis

3) Advanced Soil Mechanics

Advanced Soil Mechanics: Modified Cam Clay (MCC-NC)
Advanced Soil Mechanics: Modified Cam Clay (MCC-LOC)
Advanced Soil Mechanics: Modified Cam Clay (MCC-HOC)

4) Foundation Engineering

Foundation Engineering: Bearing Capacity Comparison
Foundation Engineering: Bearing Capacity Calculation (Meyerhof's Method)
Foundation Engineering: Bearing Capacity Calculator
Foundation Engineering: Bearing Capacity Calculator: Comparison
Foundation Engineering: Bearing Capacity Calculator: Zones & Angles
Foundation Engineering: Bearing Capacity Calculator: Inclined Load
Foundation Engineering: Bearing Capacity Calculator: Pile Foundation (Meyerhof's Method)
Foundation Engineering: Bearing Capacity Calculator: Comprehensive Calaculation
Foundation Engineering: Bearing Capacity Calculator: Terzaghi's Method
Foundation Engineering: Bearing Capacity Calculator: Nc, Nq & Ngama Factors
Foundation Engineering: Bearing Capacity Calculator: Special conditions
Foundation Engineering: Bearing Capacity Calculator: Deep Foundation: Pile Frictional Resistance

5) Rock Mechanics

Rock Mechanics: Rock Quality Designation (RQD)

Explore more Excel Spreadsheet Examples & Lectures (Videos):

Media is loading
Loaded: 0.00%
Remaining time 9:44
Foundation Engineering Lecture: Terzaghi's Method
Loaded: 9.09%
Remaining time 1:27
Soil Mechanics: Soil Consolidation
Loaded: 3.97%
Remaining time 1:39
Foundation Engineering: Bearing Capacity Comparsion
Media is loading
Loaded: 0.00%
Remaining time 4:44
Soil Mechanics: Consolidated Untrained Triaxial Test
Loaded: 5.32%
Remaining time 1:14
Rock Mechanics: Rock Quality Designation (RQD)
Captions are auto generated
Loaded: 1.00%
Remaining time 6:35
Soil Mechanics Lecture: Soil Phase Relationships

Your Thoughts Matter!

We’d love to hear from you! If you have any questions about GEOtExcl, or if you’d like to share your feedback, please feel free to leave a comment below or connect with us on LinkedIn. Your input is invaluable in shaping the future of GEOtExcel.

Khak Azma Pey Afzar (KAPA) Company Logo
GEOtExcel (Geotechnical Excel Spreadsheets)

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

https://youtu.be/a83_VRxPKe8
Soil Phase Relationships
https://s32.picofile.com/file/8480279534/SPR_01.png
https://s32.picofile.com/file/8480279550/SPR_02.png
https://s32.picofile.com/file/8480279576/SPR_03.png
https://s32.picofile.com/file/8480279584/SPR_04.png
https://s32.picofile.com/file/8480279592/SPR_05.png
https://s32.picofile.com/file/8480279600/SPR_06.png
https://s32.picofile.com/file/8480279618/SPR_07.png
https://s32.picofile.com/file/8480279626/SPR_08.png
https://s32.picofile.com/file/8480279634/SPR_09.png
https://s32.picofile.com/file/8480279642/SPR_10.png
https://s32.picofile.com/file/8480279650/SPR_11.png
https://s32.picofile.com/file/8480279668/SPR_12.png
https://s32.picofile.com/file/8480279676/SPR_13.png
https://s32.picofile.com/file/8480279684/SPR_14.png
https://s32.picofile.com/file/8480279692/SPR_15.png
https://s32.picofile.com/file/8480279700/SPR_16.png
https://s32.picofile.com/file/8480279718/SPR_17.png
https://s32.picofile.com/file/8480279734/SPR_18.png
https://s32.picofile.com/file/8480279750/SPR_19.png
https://s32.picofile.com/file/8480279768/SPR_20.png
https://s32.picofile.com/file/8480279784/SPR_21.png
https://s32.picofile.com/file/8480279792/SPR_22.png

✅ 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://youtu.be/onJhva8dyxY

https://youtu.be/xafDNzuvdWM




https://www.youtube.com/watch?v=xafDNzuvdWM

https://s32.picofile.com/file/8478825184/002_i.png

https://www.youtube.com/watch?v=2A-nvMpLCTQ&t=32s

https://s32.picofile.com/file/8478825126/001_h.png

https://www.youtube.com/watch?v=CYsjxh9IuLk

https://s32.picofile.com/file/8478825134/002_h.png

https://www.linkedin.com/feed/update/urn:li:activity:7230479702426058752/

https://s32.picofile.com/file/8478825250/08_17_2024.png

https://www.researchgate.net/publication/383073922_Foundation_Engineering_Bearing_Capacity_Excel_Spreadsheets

https://www.linkedin.com/feed/update/urn:li:activity:7229481766682558464/

https://www.linkedin.com/feed/update/urn:li:activity:7226966139539488768/

https://youtu.be/CYsjxh9IuLk

https://s32.picofile.com/file/8478825326/01_m.png

https://www.linkedin.com/feed/update/urn:li:activity:7230130595618582529/

https://youtu.be/CYsjxh9IuLk

https://youtu.be/CYsjxh9IuLk

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

https://www.youtube.com/watch?v=eoQZksrBvrI&t=61s

https://www.youtube.com/watch?v=eoQZksrBvrI&t=61s

https://www.youtube.com/watch?v=cIzYpDOUlVo

 GEOtExcel YouTube Channel

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

Designed by Dr. Ahmad Fahmi


https://s32.picofile.com/file/8478825126/001_h.png

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

https://s32.picofile.com/file/8478825134/002_h.png

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

https://s32.picofile.com/file/8478825150/000_4_i.png

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

https://s32.picofile.com/file/8478825168/000_i.png

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

https://s32.picofile.com/file/8478825176/001_i.png

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

https://s32.picofile.com/file/8478825184/002_i.png

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

https://s32.picofile.com/file/8478825192/003_i.png

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

https://s32.picofile.com/file/8478825226/000_j.png

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

https://s32.picofile.com/file/8478825234/001_j.png

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

https://s32.picofile.com/file/8478825242/002_j.png

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

https://s32.picofile.com/file/8478825250/08_17_2024.png

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

https://s32.picofile.com/file/8478825268/0022_j.png

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

https://s32.picofile.com/file/8478825284/001_k.png

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

https://s32.picofile.com/file/8478825292/A01_l.png

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

https://s32.picofile.com/file/8478825326/01_m.png

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

https://s32.picofile.com/file/8478825334/02_m.png

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

https://s32.picofile.com/file/8478825350/03_m.png

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

https://s32.picofile.com/file/8478825368/04_m.png

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

https://s32.picofile.com/file/8478825376/05_m.png

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

https://s32.picofile.com/file/8478825384/06_m.png

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

https://s32.picofile.com/file/8478825418/03_n.png

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

https://s32.picofile.com/file/8478825434/02_o.png

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

https://s32.picofile.com/file/8478825450/02_p.png

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

https://s32.picofile.com/file/8478825476/03_p.png

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

https://s32.picofile.com/file/8478825484/001_q.png

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

------------------------------------------------------------------------
Soil Mechanics & Soil Mechanics Laboratory

https://s32.picofile.com/file/8478824926/07.png

Soil mechanics and Foundation Engineering Excel Spreadsheets

#Soilmechanics #Foundation #Foundationengineering #Foundationdesign #Geotechnics #Geotechnical #Engineering #Excel 

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
✅ Excel Spreadsheets for Soil Mechanics & Foundation Engineering
✅ Geotechnical Excel Programs & Lectures

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

Designed by Dr. Ahmad Fahmi