Problem Set 6 CE 4400 1-Use microsoft excel to draw elastic settlement-based bearing capacity (in ksf) versus a square foundation width (ranging from 2 to 20 ft) curves for two limit settlements of 0.5 and 1.0 in. (Please upload your excel file on Canvas). (use FHWA equation for settlement-based bearing capacity) Given: Soil Poisson's ratio=0.30 Soil average elastic modulus=300 ksf 2-An eccentrically loaded foundation is shown below. Use FS of 4 and calculate the maximum allowable load that the foundation can carry. Use Meyerhof's effective area method. (Eccentricity in one direction only) e = 0.15 m y = 17 kN/m3 c' =0 1.0 m ₲' = 36° 1.5 m × 1.5 m Centerline

Fig: 1