1. Use Excel to perform the CPT analysis described in the Reader with the data in the...
Question:
1. Use Excel to perform the CPT analysis described in the Reader with the data in the "HW CPT" worksheet. Produce (to turn in), on a new page: four perfectly aligned profile graphs: qt, fs, and un and u2, and FR. Set the x- axis scale for FR from 0 to 8%. Set the x-axis scale for un and uz to start at 0. Identify at least 4 layers (and at most 6), by adding horizontal lines at layer interfaces (across all four graphs).
2. Use the graphs created in problem 8 to classify the layer that extends from z=22m to z=25m, using the Robertson et al 1986 method. 10. Use the graphs created in problem 8 to determine the friction angle for the layer that extends from z=22m to z=25m.
3. Use the graphs created in problem 8 to calculate the soil modulus of the layer that extends from z=22m to z=25m.?
4. Use the profile graphs created in problem 8 to calculate whether or not the layer that extends from z=22m to z=25m will liquefy if the peak ground acceleration at the site reaches 0.05g.?
?
??