Answer Happy

The attached workbook contains an unfinished spreadsheet for designing a sheet pile in sand. Your assignment is as follows: 1) Complete missing formulas in the worksheet: Enter the correct formulas into the cells to complete the design calculations. Use the Step by Step method discussed in the video lecture (and also provided as a handout see AYBUZEM page). You may format the sheet so that it is neat and easy to use. 2) Verification: Check that the calculation are correct by comparing it with the worked example from the sheetpile handout from the textbook. The input values are already in the worksheet 3) Copy the completed and verified worksheet into the same workbook. Reduce the internal friction angle of the soil by a couple of degrees and find the revised solution. Repeat for an even smaller friction angle. Save each solution as a seperate workbook. Rename these two workbook so they are meaningful. 4) Comment on how the required penetration depth D has changed when the soil friction angle is reduced. Comment on how the maximum moment has changed when the soil friction angle is reduced.
Sand Cantilever Sheet Pile in Sand Refi Foundation Engineering by Beaja Das Chapter 9 Step-by-Step Procedure for obtaining the Pressure Diagram (for Sand) Water table Sand Yu L c=0 Dredge line 1 Calculate K, and K, 2 Obtain o,' and 0,' legn 9.1 and 9.2) 3 Calculate , eq 9.6 4 Calculate s Calculate 2, bat (in the center of pressure for the area ACDE by taking the moment about E • Calculate ' 49.11 7 Calculate A,A,A, A * Solve eq 0.16 by trial and error to determine Calculate '9.10 10 Calculate , E997 11 Obtain from eq 9.15 12 Draw pressure distribution diagram as shown in Figure obtain the theoretical depth of penetration using eq9.12 as is th. The actual depth of penetration, D. is increased by 20 to 30% T Slope: 1 vertical: (K,-K) horizontal L Sand 7 13 d=0 8 (a)
calculation Table for Sheet Pile i Sand = Note: kst- kips/ft2 Value Other Units) = Enter value in Orange Cells Calculated Values Design Solution Variable Value L1 10 ft L2 20 ft 7 120 pol 129.4 pot 62.4 pol 67 pol 40 Opst Input Values 0.067 kipsift3 There JY Ro Galtor 30 kipslin - sheet Ka Kp - kst kst ) L3 pst psf ft Ibift ft NO99W 2。 kipift z bar 2 3 kst Resultant Force for: Triangle ACL1 kipsift Rectangl CDL 2: kipsift Triangle CDL2 kipsitt Triangle DEL3: kipsilt Total (Trapezoid ACDEL): kips/ft 5 Calculated Values 7 3 3 psf A1 ft A2 A3 A4 L4 (trial) 19.8323 it RHS of eq L4 (rounded up)' 20 ft psf O' psf L5 ft z ft DEL 3+L4 ft Actual D (30% ino) ft Total Pile Length ft Mmax kip-ft/ft S (section modulus) frift க9534 ksi kst 2 3 5 5 Results 7 kip-in/ft inft 3 7