solve by excel method (integration block by block)

Subject: Geotechnical Design

A rectangular 10 ft x 12 ft mat foundation is subjected to a concentric point load Q=50 kip and the moments Mx=130 kip-ft, and My=140 kip-ft, applied about the x and y axes, respectively. The modulus of subgrade reaction for the soil is ks=100 kcf.

Subdivide the mat area into a mesh of 1 ft x 1 ft square elements, such that 10 elements are generated in the short (B=10 ft) direction, and 12 elements in the long (L=12 ft) direction. By using the method presented in class, calculate: 1) Maximum elastic settlement of the mat 2) Maximum and minimum soil pressures 3) Ratio of mat-soil interface contact area to total mat area. Submit intermediate hand calculations and associated Excel spreadsheet, as applicable.