Problem $6.$

Develop a spreadsheet to solve this problem. The tank below was built at

the ground surface and imparts some load to the ground. The load depends

on the height of the water within the tank. Given the information below,

determine the maximum height of water that can be put in the tank if the

effective stress beneath the middle of the tank at a depth of $6$ ft below the

ground surface cannot exceed $1300$ psf$.$

Tank weight empty $($not shown$)=100,000lbs(50$ tons$)$

Water table a the ground surface

Moist unit weight of clay subsurface pcf soil $-{}_M=105pcf$

Radius of the tank $=7\mathrm{.}5ft$

For this problem show$/$report the following:

a $-$ include two pictures of your spreadsheet, one with the formatting as

you see it and one with the formulas showing

b $-$ report the maximum height of water that can be put in the tank