11-6 Rate of Consolidation Chap. 11
11.7 Using the soil profile in Figure 11.29, develop a spreadsheet that solves Equation 11.17 at
1.0 ft depth intervals through the entire soft clay stratum. Use summations for N. Then
use this spreadsheet to develop a curve of excess pore water pressure versus depth at t = 6
years after construction. Submit a printout of the spreadsheet, and a plot of the excess
pore water pressure curve.
Note for those who may wish to develop spreadsheet or other software for more
general solutions: the natural exponent term in Equation 11.17 may cause difficulties for
some programming languages when they attempt to take e to a large negative power.
However, these difficulties appear to occur only when N has risen to values beyond those
necessary for the summation. Therefore, avoid such difficulties by terminating the
summation whenever the exponent term generates an error, or when the increment of N
produces a negligible change in the summation.