Problem$-2$: A $10ft$ deep compacted fill is to be placed over the soil profile shown in the following figure. A consolidation test on a sample from point A produced the following results:

$C_C=0\mathrm{.}4$

$C_T=0\mathrm{.}08$

$e_0=1\mathrm{.}10$

${}_c^{\text{'}}=1325psf$

$($A$)$Please do the following:

Create a spreadsheet with appropriate user input values for future use,

$(20$ points$)$

Find the total consolidation settlement of the foundation and check if it is within the permissible limits $(1$ inch max$)-$ You will need to find if coefficients $c_d(1+e_0)$ for sands and whether the clayey soil is $NC$ or $OC$

Show sample hand$-$calculations

$($B$)$ If the allowable settlement is $1$ inch, calculate the height of fill. Round off the answer to the nearest $6$ inch. Use the properties of the soils given above.

$(10$ points$)$