how would I make a spreadsheet to calculate the consolidation settlement of a single foundation. The spreadsheet should
Posted: Thu May 05, 2022 11:46 am
how would I make a spreadsheet to calculate the consolidation settlement of a single foundation. The spreadsheet should have the inputs of this problem as variables. It should still correctly calculate the Sc value if any of the inputs are changed.
Problem 1: The results of a direct shear test of a 3 inch dia. soil sample are shown below. a. Determine the shear strength parameters of the soil. b. Determine the shear strength of the soil at 15 ft. depth, assume y=110 pcf and water table at 4 ft. depth. Normal Stress Max. Shear Failure Load (lbs) (psi) Stress (psi) 5 35 10 50 20 70 20 25 Shear Stress (psi) 0 5 10 15 Normal Stress (psi)
Problem 1: The results of a direct shear test of a 3 inch dia. soil sample are shown below. a. Determine the shear strength parameters of the soil. b. Determine the shear strength of the soil at 15 ft. depth, assume y=110 pcf and water table at 4 ft. depth. Normal Stress Max. Shear Failure Load (lbs) (psi) Stress (psi) 5 35 10 50 20 70 20 25 Shear Stress (psi) 0 5 10 15 Normal Stress (psi)