\[ \begin{align}\begin{aligned}\newcommand\blank{~\underline{\hspace{1.2cm}}~}\\% Bold symbols (vectors) \newcommand\bs[1]{\mathbf{#1}}\\% Poor man's siunitx \newcommand\unit[1]{\mathrm{#1}} \newcommand\num[1]{#1} \newcommand\qty[2]{#1~\unit{#2}}\\\newcommand\per{/} \newcommand\squared{{}^2} \newcommand\cubed{{}^3} % % Scale \newcommand\milli{\unit{m}} \newcommand\centi{\unit{c}} \newcommand\kilo{\unit{k}} \newcommand\mega{\unit{M}} % % Percent \newcommand\percent{\unit{\%}} % % Angle \newcommand\radian{\unit{rad}} \newcommand\degree{\unit{{}^\circ}} % % Time \newcommand\second{\unit{s}} \newcommand\s{\second} \newcommand\minute{\unit{min}} \newcommand\hour{\unit{h}} % % Distance \newcommand\meter{\unit{m}} \newcommand\m{\meter} \newcommand\inch{\unit{in}} \newcommand\foot{\unit{ft}} % % Force \newcommand\newton{\unit{N}} \newcommand\kip{\unit{kip}} % kilopound in "freedom" units - edit made by Sri % % Mass \newcommand\gram{\unit{g}} \newcommand\g{\gram} \newcommand\kilogram{\unit{kg}} \newcommand\kg{\kilogram} \newcommand\grain{\unit{grain}} \newcommand\ounce{\unit{oz}} % % Temperature \newcommand\kelvin{\unit{K}} \newcommand\K{\kelvin} \newcommand\celsius{\unit{{}^\circ C}} \newcommand\C{\celsius} \newcommand\fahrenheit{\unit{{}^\circ F}} \newcommand\F{\fahrenheit} % % Area \newcommand\sqft{\unit{sq\,\foot}} % square foot % % Volume \newcommand\liter{\unit{L}} \newcommand\gallon{\unit{gal}} % % Frequency \newcommand\hertz{\unit{Hz}} \newcommand\rpm{\unit{rpm}} % % Voltage \newcommand\volt{\unit{V}} \newcommand\V{\volt} \newcommand\millivolt{\milli\volt} \newcommand\mV{\milli\volt} \newcommand\kilovolt{\kilo\volt} \newcommand\kV{\kilo\volt} % % Current \newcommand\ampere{\unit{A}} \newcommand\A{\ampere} \newcommand\milliampereA{\milli\ampere} \newcommand\mA{\milli\ampere} \newcommand\kiloampereA{\kilo\ampere} \newcommand\kA{\kilo\ampere} % % Resistance \newcommand\ohm{\Omega} \newcommand\milliohm{\milli\ohm} \newcommand\kiloohm{\kilo\ohm} % correct SI spelling \newcommand\kilohm{\kilo\ohm} % "American" spelling used in siunitx \newcommand\megaohm{\mega\ohm} % correct SI spelling \newcommand\megohm{\mega\ohm} % "American" spelling used in siunitx % % Inductance \newcommand\henry{\unit{H}} \newcommand\H{\henry} \newcommand\millihenry{\milli\henry} \newcommand\mH{\milli\henry} % % Power \newcommand\watt{\unit{W}} \newcommand\W{\watt} \newcommand\milliwatt{\milli\watt} \newcommand\mW{\milli\watt} \newcommand\kilowatt{\kilo\watt} \newcommand\kW{\kilo\watt} % % Energy \newcommand\joule{\unit{J}} \newcommand\J{\joule} % % Composite units % % Torque \newcommand\ozin{\unit{\ounce}\,\unit{in}} \newcommand\newtonmeter{\unit{\newton\,\meter}} % % Pressure \newcommand\psf{\unit{psf}} % pounds per square foot \newcommand\pcf{\unit{pcf}} % pounds per cubic foot \newcommand\pascal{\unit{Pa}} \newcommand\Pa{\pascal} \newcommand\ksi{\unit{ksi}} % kilopound per square inch \newcommand\bar{\unit{bar}} \end{aligned}\end{align} \]

Oct 24, 2024 | 233 words | 2 min read

2.2.2. Task 2#

Learning Objectives#

By the end of this exercise, you will be able to apply the principles of soil mechanics to calculate vertical stress in different soil types using Terzaghi’s equation. You will use Excel to determine vertical stress at various depths for different soil unit weights, demonstrating proficiency in cell referencing, data organization, and interpretation of results.

Introduction#

Karl Terzaghi was a Czechoslovakian geotechnical engineer who lived between 1883 and 1963. He is known today as the grandfather of soil mechanics. One of his many significant contributions includes the calculation of vertical stress in soil using the equation

(2.1)#\[\sigma = \gamma * h\]

where, \(\sigma\) is the vertical stress (\(\psf\)), \(\gamma\) is the soil unit weight (\(\pcf\)), and \(h\) is the depth below soil surface (\(\foot\)).

On a particular site, engineers find three types of soil:

  • Soil A: \(\gamma = \qty{115}{\pcf}\)

  • Soil B: \(\gamma = \qty{124}{\pcf}\)

  • Soil C: \(\gamma = \qty{140}{\pcf}\)

Task Instructions#

  1. Open the answer sheet ex2_team_2_teamnumber.xlsx. Save it with your team number replacing teamnumber in the file name.

  2. Calculate the vertical stress at \(5\) foot intervals from \(\qty{5}{\foot}\) to \(\qty{40}{\foot}\) for each of the soil types listed above.

  3. Copy the following questions into the Output Section of the spreadsheet and then add your answers.

    1. A stress-measuring device is buried \(\qty{40}{\foot}\) under the surface. The maximum stress this device can stand is \(\qty{5,000}{\psf}\). In which type(s) of soil can this device be buried?

    2. What percentage of stress values calculated for soil C are above \(\qty{5000}{\psf}\)?

  4. Save the ex2_team_2_teamnumber.xlsx file as ex2_team_2_values_teamnumber.pdf displaying the values and ex2_team_2_formulas_teamnumber.pdf displaying the formula.

  5. Submit both files to Gradescope.