SoilEngineering: A Microsoft Excel® spreadsheet© program for geotechnical and geophysical analysis of soils

Computers and Geosciences

Volumn 36, Issue 10, 2010, Pages 1355-1361

  Ozcep, Ferhat ^a  

^a ISTANBUL UNIVERSITY   (Turkey)

Author keywords

Excel spreadsheet; Geotechnical and geophysical analysis; Soil mechanics and dynamics

Indexed keywords

DATA PREPARATION; DEEP FOUNDATIONS; EARTHQUAKE FORCE; EXCEL SPREADSHEETS; GEOELECTRICAL; GEOPHYSICAL ANALYSIS; GEOPHYSICAL DATA; GEOTECHNICAL; GEOTECHNICAL DATA; GEOTECHNICAL PARAMETERS; MAJOR ELEMENTS; MICROSOFT EXCEL; SEISMIC HAZARD ANALYSIS; SEISMIC REFRACTION DATA; SETTLEMENT ANALYSIS; SLOPE STABILITY ANALYSIS; SOIL AMPLIFICATION; SOIL BEHAVIORS; SOIL ENGINEERING; SOIL LIQUEFACTION ANALYSIS; SPREADSHEET PROGRAM; STATIC AND DYNAMIC LOADS; STRONG MOTION; STRUCTURAL RESPONSE; SUBGRADE REACTION COEFFICIENT;

DYNAMIC LOADS; DYNAMICS; EARTHQUAKES; GEOPHYSICS; GEOTECHNICAL ENGINEERING; RISK ASSESSMENT; SLOPE STABILITY; SOIL LIQUEFACTION; SOIL MECHANICS; SOILS; SPREADSHEETS; STRUCTURAL DESIGN; STRUCTURAL GEOLOGY;

DYNAMIC ANALYSIS;

BOREHOLE; GEOPHYSICS; GEOTECHNICAL ENGINEERING; SEISMIC REFRACTION; SOIL ANALYSIS; SOIL DYNAMICS; SOIL MECHANICS; SPREADSHEET;

EID: 77956759894     PISSN: 00983004     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.cageo.2010.01.015     Document Type: Article

References (36)

1. Andrus, R.D., Stokoe, K.H., 1997. Liquefaction resistance of soils from shear-wave velocity. In: Proceedings of the National Center for Earthquake Engineering Research Workshop on Evaluation of Liquefaction Resistance of Soils, National Center for Earthquake Engineering Research, Buffalo, New York, 89-128.
2. Andrus R.D., Stokoe K.H. Liquefaction resistance based on shear-wave velocity. Journal of Geotechnical Engineering 2000, 126(11):1015-1025.
3. Ansal, A.M., 1991. Evaluation of liquefaction susceptibility. In: Proceedings of the Fifth International Conference on Soil Dynamics and Earthquake Engineering, Karlsruhe, Germany, 303-312.
4. Ansal A.M., Iyisan R., Yildirim H. The cyclic behavior of soils and effects of geotechnical factors in microzonation. Soil Dynamics and Earthquake Engineering 2001, 21:445-452.
5. Bard, P.Y., 1998. Microtremor measurements: a tool for site effect estimation? In: Proceedings of the Second International Symposium on the Effects of Surface Geology on Seismic Motion-ESG98, Yokohama, Japan, 1251-1279.
6. Bowles J.E. Foundation Analysis and Design 1996, McGraw-Hill Book Co., Singapore, 1004pp.
7. Burland J.B., Burbridge M.C. Settlement of foundations on sand and gravel. In: Proceedings of the Institution of Civil Engineers 1985, 78(1):1325-1381.
8. Campbell K.W. Empirical near-source attenuation relationships for horizontal and vertical components of peak ground acceleration, peak ground velocity, and pseudo-absolute acceleration response spectra. Seismological Research Letters 1997, 68(1):154-179.
9. Craig R.F. Soil Mechanics 1992, ELBS with Chapman & Hall, London, 427pp.
10. Das B.M. Principles of Soil Dynamics 1993, PWS Kent Publishing Company, Boston, 570pp.
11. Ishihara K., Yoshimine M. Evaluation of settlements in sand deposits following liquefaction during earthquakes. Soils and Foundations 1992, 32(1):73-188.
12. Iwasaki, T., Tatsuoka, F., Tokida, K., Yasuda, S., 1978. A practical method for assessing soil liquefaction potential based on case studies at various sites in Japan. In: Proceedings of the Second International Conference on Microzonation, San Francisco, 885-896.
13. Janbu N. Application of composite slip surfaces for stability analysis. Proceedings European Conference on Stability of Earth Slopes Stockholm 1954, 3:43-49.
14. Joyner W.B., Boore D.M. Peak acceleration and velocity from strong motion records including records from the 1979 imperial valley California earthquake. Bulletin of the Seismological Society of America 1981, 71:2011-2038.
15. Joyner, W.B., Fumal, T., 1984. Use of measured shear-wave velocity for predictive geological site effects on strong motion. In: Proceedings of the Eighth World Conference on Earthquake Engineering, San Francisco, USA, 777-783.
16. ® spreadsheet program for modeling rayleigh fractionation vectors in closed magmatic systems. Computers & Geosciences 2002, 28:919-928.
17. Krinitzsky E.L., Gold J.P., Edinger P.H. Fundamentals of Earthquake Resistant Construction 1993, John Wiley and Sons, New York, 298pp.
18. Meyerhof, G.G., 1956. Penetration tests and bearing capacity of cohesionless soils. In: Proceedings of the American Society of Civil Engineers, Stockholm 82, SM1, Paper 866, 1-9.
19. Meyerhof, G.G., 1961. The ultimate bearing capacity of wedge-shaped foundations. In: Proceedings of the Fifth International Conference on Soil mechanics and Foundation Engineering, Paris, vol. II, 105-109.
20. Pitikalis G. Site effects. Recent Advances in Earthquake Geotechnical Engineering and Microzonation 2004, 139-197. Kluwer Academic Publishers, Netherlands. A. Ansal (Ed.).
21. Richards R., Elms D.G., Budhu M. Seismic bearing capacity and settlements of foundations. Journal of Geotechnical Engineering 1993, 119(4):662-674.
22. Robertson P.K., Campanella R.G. Liquefaction potential of sands using the CPT. Journal of Geotechnical Engineering 1985, 111(3):384-403.
23. Safak E. Local site effects and dynamic soil behavior. Soil Dynamics and Earthquake Engineering 2001, 21(5):453-458.
24. Seed, H.B., De Alba, P., 1986. Use of SPT and CPT tests for evaluating the liquefaction resistance of sands. In: Proceedings of the American Society of Civil Engineers Specialty Conference In-Situ'86: Use of In-Situ Tests in Geotechnical Engineering, Blacksburg, VI, USA, 281-302.
25. Seed H.B., Idriss I.M. Simplified procedure for evaluating soil liquefaction potential. Journal of Soil Mechanics and Foundations 1971, 97(9):249-1273.
26. Seed, R.B., Cetin, K.O., Moss, R.E.S., Kammerer, A.M., Wu, J., Pesatana, J.M., Riemer, M.F., 2001. Recent advances in soil liquefaction engineering and seismic site response evaluation. In: Proceedings of the 15th International Conference on Soil Mechanics and Foundation Engineering, Geotechnical Engineering and Microzonation Seminar, Istanbul, Turkey, Paper no. SPL-2.
27. Siyahi B.G., Ansal A. Manual for zonation on seismic geotechnical hazards. Technical Committee for Earthquake Geotechnical Engineering, Technical Committe 4. International Society of Soil Mechnics and Geotechnical Engineering 1999, 68-70.
28. Stokoe, K.H., Roeset, J..M., Bierschwalle, J.G., Aouad, M., 1988. Liquefaction potantial of sands from shear wave velocity. In: Proceedings of the Ninth World Conference on Earthquake Engineering, Japan, 213-218.
29. Terzaghi K. Theoretical Soil Mechanics 1943, John Wiley and Sons, New York, 349pp.
30. Terzaghi K., Peck R.B. Soil Mechanics in Engineering Practice 1967, Wiley International Edition, New York, 321pp. Second ed.
31. Tezcan S., Keceli A., Özdemir Z. Allowable bearing capacity of shallow foundations based on shear wave velocity. Geotechnical and Geological Engineering 2006, 24(1):203-218.
32. Tokimatsu, K., Seed, H.B., 1984. Simplified procedures for the evaluation of settlements in sands due to earthquake shaking. Report no. UBB/EERC-84/16, Earthquake Engineering Research Center, University of California, Berkeley, 130pp.
33. Tokimatsu K., Yoshimi Y. Empirical correlation of soil liquefaction based on SPT-N value and fines content. Soils and Foundation 1983, 30(3):153-158.
34. Vesic, A.S., 1964. Investigation of bearing capacity of piles in sands. Publication no: 3, Duke University Soil Mechanics Laboratory, Durham, NC.
35. Wilson, R., Wieczorek, G., Harp, E., 1979. Development of criteria for regional mapping of slope stability. In: Proceedings of the Annual Meeting of the Geological Society of America, San Diego, USA, 30.
36. Youd, T.L., Idriss, I.M., Andrus, R.D., Arango, I., Castro, G., Christian, J.T., Dobry, R., Finn, W.D.L., Harder, L.F., Jr., Hynes, M.E., Ishihara, K., Koester, J.P., Liao, S.S.C., Marcuson, W.F., III., Martin, G.R., Mitchell, J.K., Moriwaki, Y., Power, M.S., Robertson, P.K., Seed, R.B., Stokoe, K.H., II, 2001. Liquefaction resistance of soils: summary report from the 1996 NCEER and 1998 NCEER/NSF workshops on evaluation of liquefacton resistance of soils. Journal of Geotechnical Engineering 127(10), 817-833.