G# $=$ Group Number

Make a spreadsheet to designg a water cannon with the following conditions:

Lateral Force at top of post $=$ F $=1\mathrm{.}3+0\mathrm{.}2*$G# kip

Height of post, h $=30+2*$G# ft

Weight of post, Wp $=0\mathrm{.}6+0\mathrm{.}1*$G# kip

Soil friction angle $=$ f$=10$ deg

Soil cohesion $=$ c $=1000$ psf

Overturning Safety factor $=1\mathrm{.}50$

Sliding safety factor $=1\mathrm{.}50($assume the coefficient of friction $=$ tan$($f$)$

Soil bearing capacity: calculate using Terzhagui's Theory

Modify the soil pressure to avoid negative pressures $($minimum pressure is zero$)$

Design the footing size and depth $($Df$).$

Note:

Reproduce the problem done in classroom using Excel. After all is checked, input the data given.

$1$ spreadsheet per group:

G#$-$FndWaterCanon$-$HW$3.$xls