Question

You should use excel functions and capabilities to solve the
problem. Inputs and outputs should be clear using different
colours. There is no mark for copying and pasting the
solution.

please provide step by step formulas to conpute in excel

Q3

A rigid strip footing with a width of B is constructed above
the ground on a clay deposit, overlying bedrock. The depth of clay
layer is H and the water level is at the natural ground surface.
Before construction of the footing, laboratory tests on a saturated
clay sample, taken at a depth of H/2 below the ground surface,
provided the following properties:

Compression Index = Cc , Recompression Index = Cr ,
Consolidation Coefficient = cv

Over Consolidation Ratio = OCR, Water Content = w% and
Specific Gravity = Gs

Assume the vertical uniform surcharge stress on the footing
including the weight of footing and column = q

(a) Calculate the initial saturated unit weight of clay
deposit.

(b) Based on the elastic theory (Boussinesq’s equation),
calculate the excess pore water pressures at the depth of H/2
immediately after applying the surcharge load. Assume the vertical
stress (q) is applied instantaneously.

(c) Using theory of 1-D consolidation, calculate the total
average settlement of this rigid footing due to consolidation of
the clay layer, long time after applying the total load.

(d) Determine the average settlement of this rigid footing
after n days of applying the total load due to consolidation of
clay deposit. Assume the bedrock is permeable (i.e. Drainage path =
H/2)

(e) Plot the graph of settlement versus time (in log scale)
for this footing.

just require step by step formula, so that i van compute on
excel

Answer #1

First four question answered

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 7 minutes ago

asked 45 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 3 hours ago