How can soil particle size be graphically represented in Microsoft Excel?

How do you determine D10, D30, and D60 in Excel Spreadsheet?
Soil Classification : Unified Soil Classification System (USCS):
Watch the Videos on Our YouTube Channel:
https://www.youtube.com/watch?v=b1LrrIB7V0k
https://youtu.be/MRlMFXpHtgw
https://youtu.be/Z7w0dPFC9us

Watch the Video on Our YouTube Channel (in English):
Flow Nets: Two-Dimensional Flow of Water Through Soils: Excel Spreadsheet: GEOtExcel


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

Soil particle size distribution can be effectively represented graphically in Microsoft Excel by plotting a gradation curve, which helps visualize the range of particle sizes within a soil sample. To do this, data from sieve analysis or hydrometer tests are first entered into an Excel spreadsheet. The key data points typically include the percentage of soil passing through each sieve (cumulative percent finer) and the corresponding sieve sizes. Using this data, you can create a scatter or line chart in Excel, with the sieve size (or particle diameter in mm) plotted on a logarithmic scale on the x-axis and the cumulative percent finer on the y-axis. Excel’s chart tools allow you to format the axes, add labels, and generate a smooth curve that shows the particle size distribution of the soil sample. This graphical representation helps in classifying the soil based on its gradation characteristics, such as identifying whether it is well-graded, poorly graded, or uniformly graded. Excel’s flexibility in data manipulation and visualization makes it a convenient tool for engineers to represent and analyze soil particle size distribution.

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

Designed by Dr. Ahmad Fahmi

How is the flow rate through the soil beneath a concrete dam calculated? Excel sheet

✅ How is the flow rate through the soil beneath a concrete dam calculated?

✅ Flow rate calculation: Innovative unique Excel Spreadsheet

Watch the video on our YouTube channel:

https://youtu.be/CBNMKoEMhV4

✅ Instagram Page Address:

https://www.instagram.com/academy.dr.fahmi/

✅ Excel Spreadsheets for Soil Mechanics & Foundation Engineering

✅ Geotechnical Excel Programs & Lectures

✅ Let’s make education a delightful and enriching experience together.

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

Calculating the flow rate of water through the soil beneath a concrete dam is crucial for maintaining the dam’s stability and safety. This process requires a comprehensive understanding of seepage, which describes how water interacts with and moves through the soil. Using an Excel spreadsheet, you can streamline the calculation by inputting soil properties (such as permeability), hydraulic gradients, and cross-sectional areas to compute the flow rate through Darcy’s Law. Excel’s formulas and data visualization tools allow for clear graphical representation of seepage calculations.

Designed by Dr. Ahmad Fahmi

#GEOtExcel #soilmechanics #excelspreadsheets #geotechnics #geotechnicalengineering #soil_mechanics #excel #excelsheet #shearstress #microsoftexcel

Let’s thoroughly explore “Soil Phase Relationships” in soil mechanics using Excel spreadsheets.

✅ Watch the video on our YouTube channel:

https://youtu.be/a83_VRxPKe8

✅ Instagram Page Address:

https://www.instagram.com/academy.dr.fahmi/

✅ Excel Spreadsheets for Soil Mechanics & Foundation Engineering

✅ Geotechnical Excel Programs & Lectures

✅ Let’s make education a delightful and enriching experience together.

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

Soil Phase Relationships:

Understanding the relationships between the different phases of soil is crucial in both geotechnical engineering and soil science. These phases—solid particles, water, and air—interact in ways that significantly impact soil properties such as density, porosity, and moisture content. The proportion and interaction of these phases determine how soil behaves under various conditions. By analyzing these relationships, engineers can more accurately predict soil behavior, which is essential for designing and constructing stable, safe structures. In this session, we’ll explore the fundamentals of soil phase relationships and their practical applications in engineering.

Designed by Dr. Ahmad Fahmi

#GEOtExcel #soilmechanics #excelspreadsheets #geotechnics #geotechnicalengineering #soil_mechanics #excel #excelsheet #shearstress #microsoftexcel

How can we calculate the flow rate through the soil beneath the dam using flow nets (flow lines and equipotential lines)?

Watch the Video on Our YouTube Channel (in English):
https://youtu.be/9g8jc7q5Mo4

Flow Nets: Two-Dimensional Flow of Water Through Soils: Excel Spreadsheet: GEOtExcel


✅ 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

#GEOtExcel #soilmechanics #excelspreadsheets #geotechnics #geotechnicalengineerin

How can we effectively learn about Soil Consolidation, Single Drainage, and Double Drainage in soil mechanics using Excel spreadsheets?

✅ Watch the video on our YouTube channel:

https://youtu.be/KRN0Iv9nxjQ

✅ Instagram Page Address:

https://lnkd.in/dJU-MJXe

✅ Excel Spreadsheets for Soil Mechanics & Foundation Engineering

✅ Geotechnical Excel Programs & Lectures

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

Designed by Dr. Ahmad Fahmi

#GEOtExcel #soilmechanics #excelspreadsheets #geotechnics #geotechnicalengineering #soil_mechanics #excel #excelsheet #shearstress #microsoftexcel

Foundation Engineering: Bearing Capacity Comparison

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

✅ Unique Excel Spreadsheets: Geotechnical Excel Spreadsheets(GEOtExcel)

📊 Geotechnical Excel Spreadsheets

✅ Terzaghi, Hansen & Vesic Methods: Plastic Zones (Zone I, Zone II & Zone III)

Designed by Dr. Ahmad Fahmi

#soilmechanics #foundation #foundationengineering #foundationdesign #geotechnics #geotechnical #engineering #excel #spreadsheeta

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

Foundation Engineering: Bearing Capacity Excel Spreadsheets

✅ Terzaghi, Hansen, Vesic, and Meyerhof’s methods are foundational approaches in geotechnical engineering for determining the bearing capacity of soils. Terzaghi’s method is the earliest and simplest, providing a basic formula for bearing capacity using three key factors. Hansen expanded on Terzaghi’s work by introducing additional correction factors to account for shape, depth, and load inclination. Vesic’s method further refined these calculations by incorporating plasticity theory and offering more accurate predictions for complex conditions. Meyerhof introduced a generalized bearing capacity formula that considered the influence of the shape of the foundation, the depth of the foundation, the inclination of the load.

✅ In Terzaghi’s method, the shape and depth factors for rectangular footings are derived from other methods (In this video).

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

Register for an Organ Donor Card (Website Addresses for Different Countries in Excel Spreadsheet)

✅ Website Address: Register for an Organ Donor Card

📊 Excel Spreadsheet

✅ If your country’s name is not listed in the provided Excel file and there is an organization in your country that issues organ donation cards, please share the relevant website address with me. The donation Excel file will be updated every month based on the information you provide and will be shared on my LinkedIn page. Additionally, if you have a high-quality image of an organ donation card, please send it to me so that it can be included in the file. The updated Excel spreadsheet is available in this post every month:

Vesrion1 (2024/08):

Dr. Ahmad Fahmi

#life #donation #donor_card #donorcard #donor #excel #excel_spreadsheet #spreadsheet #organ_donor_card

https://youtu.be/NYBNRPsJCtQ

Foundation Engineering: Bearing Capacity [Meyerhof’s Method]

Excel Spreadsheet: #foundation_engineering #bearing_capacity #excel_spreadsheet :

✅ Meyerhof’s method is a widely recognized approach for determining the bearing capacity of shallow foundations in geotechnical engineering. This method takes into account various factors that influence the bearing capacity, such as the shape of the foundation, the depth of the foundation, the inclination of the load, and the properties of the soil. Meyerhof’s approach is distinguished by its comprehensive consideration of these factors, leading to a more accurate estimation of the ultimate bearing capacity.

Bearing Capacity [Meyerhof’s Method]

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

Calculating Soil Bearing Capacity: Excel Spreadsheets (Terzaghi’s Method)

Video Link:

https://youtu.be/BT0QMJ5-YJ0

✅ Foundation Engineering Problem & Solution: “Bearing Capacity”
✅ Terzaghi’s Method: Strip, Square and Circle Foundations
✅ Unique Excel Spreadsheets: Geotechnical Excel Spreadsheets(GEOtExcel)

✅ Multi-Language Video: The subtitles in this video are accurate, so you can enable auto-translate to listen to the video in any language you prefer.

✅ Foundation Engineering: Bearing Capacity:
Foundation engineering is a vital discipline within civil engineering that focuses on the design and construction of foundations for various structures. A key element in this field is the bearing capacity of the soil, which refers to the soil’s ability to support the loads imposed by the structure. Assessing bearing capacity is essential to ensure the foundation remains stable and secure, thereby preventing excessive settlement or structural failure. This process involves determining the maximum load per unit area that the soil can withstand without experiencing shear failure. Factors influencing bearing capacity include soil type, moisture content, density, and the dimensions of the foundation. Thorough evaluation and enhancement of bearing capacity are crucial for the durability and stability of any construction project.

✅ In this educational and concept-focused video, you will see:
1) Calculating the Ultimate and Allowable Bearing Capacity of Strip, Square, and Circular Foundations Using Terzaghi’s Method
2) Considering the Variation of Ultimate Bearing Capacity Values with Different Soil-Foundation Parameters such as Foundation Depth, Foundation Width, Soil Cohesion, Soil Internal Friction Angle, and Soil Unit Weight
3) Considering Special Cases in the Calculation of Bearing Capacity, Such As:

  • Non-Cohesive Soils (c’=0)
  • Zero Foundation Depth (Df =0)
  • Un-drained Soil Conditions (phi’=0)
  • Combonation1: (c’=0 & Df = 0)
  • Combonation2: (Df = 0 & phi’ = 0)

✅ Definitions:
For the Strip Foundations : B = The width of the foundation
For the Square Foundations : B = The dimension of each side of the foundation
For the Circle Foundations : B = The diameter of the foundation
Foundation Depth: Df = The depth of foundation measured from the ground surface
gamma = Unit Weight of Soil
c’ = Soil Cohesion or cu = Undrained Cohesion (phi =0)
phi’ = Angle of friction of soil
Sc , Sq & Sg : Shape Factors
FS = Factor of Safety
q = Surcharge: The soil above the bottom of the foundation can also be considered as being replaced by an equivalent surcharge (q= gamma . Df)
Nc = The bearing capacity factor related to the contribution of soil cohesion
Nq = The bearing capacity factor related to the contribution of surcharge
N(gamma) = The bearing capacity factor related to the contribution of unit weight
qu = Ultimate Bearing Capacity
q(all) = Allowable Bearing Capacity

Designed & Presented by Dr. Ahmad Fahmi

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


foundation #geotechnicalengineering #foundationengineering #engineering #soilmechanics #civilengineering #bearingcapacity #bearing #footing #engineeringeducation