Problem Set 4 CE 4400 1-Use microsoft excel to draw ultimate bearing capacity (in ksf) versus foundation width (ranging from 2 to 20 ft) curve for a strip, circular, and square footing rested on a dry soil using Terzaghi's bearing capacity equations. Show all curves in one plot. Please upload your spreadsheet on Canvas. Ybulk (pcf) c' (psf) '(deg.) 125 100 30 3 Embedment depth D, (ft) Hint: your answer should look like the curves below: Ultimate Bearing Capacity, qu (ksf) 40.0 35.0 30.0 25.0 20.0 15.0 10.0 5.0 0.0 2 7 12 Foundation Width, B (ft) -Strip -Square Circular 17 2-Calculate the maximum factored load in kips that the square footing in problem 1 with B=6 ft can withstand under strength limit state and extreme event limit state condition?