At the site where the sample of data below was taken, the soil profile consists of about 6.5 m of sand and rubble fill and then 9.1 m of clay. The water table is about 1.8 m below the ground surface. Average densities of the sand and rubble fill are 1450 kg/m3 above the water table and 1700 kg/m3 below the water table. Estimate the consolidation settlement if the average stress increase in the compressible layer is (a) 50 kPa, (b) 100 kPa, and (c) 250 kPa. Use both Eq. (7.19) [or Eq. (7.17)] and your percent compression plot from the data, and compare the results.

Modify your spreadsheet to perform all calculations. Set up the spreadsheet so that stresses and incremental settlements are calculated at 0.1m increments starting at 0.05m below ground surface and ending at Z = 15.6m. Do not calculate any consolidation settlement in the sand. Provide sample calculations for each column in the spreadsheet for one row. Plot the stress profiles as we did in Geo I for each case. The preconsolidation stress profile should be included in the effective stress plot. Make sure your plots are clearly labeled and each case is clearly differentiated.

Use the spreadsheet to calculate the elastic settlement in the sand using a Modulus of 250-MPa in the sand. Do not calculate any elastic settlement in the clay.

% Consolidation (Compression is +)	Pressure (kPa)	% Consolidation (Compression is +)	Pressure (kPa)
0.09	5	7.34	160
0.11	10	7.60	320
0.12	20	8.35	640
0.26	40	12.65	1280
0.98	80	17.41	2560
1.91	160	22.18	5120
4.19	320	21.65	1280
8.05	640	20.63	160
8.03	320	19.26	40
7.83	160	15.35	5
7.21	80

Specimen height is 25.4 mm, w_n=32.5%, _d=1450 kg/m³. Sample is from a depth of 11.5 m.

(7.19a) sc=CrHo(logplogvo)+CcHo(logflogp) (7.19b) sc=CrHologvop+CcHologpvo+v (7.17) sc=CrHologvovo+v=CrHo(logvflogvo)