SoilEngineering: A Microsoft Excel (R) spreadsheet (c) program for geotechnical and geophysical analysis of soils

Abstract

SoilEngineering is a user-friendly, interactive Microsoft Excel (R) spreadsheet program for the geotechnical and geophysical analysis of soils. The influence of soil behavior on earthquake characteristics and/or structural design is one of the major elements in investigating earthquake forces, and thus the structural response with static and dynamic loads. With its interactive nature, the program provides the user with an opportunity to undertake soil static and dynamic load analysis. The program is formed by three main options: (1) Data Preparation, (2) Derived Parameters and (3) Analysis of Soil Problems (with Static and Dynamic Loads). The Data Preparation option is divided into four modules: Seismic Refraction Data, Geoelectrical Data, Borehole and SPT (N) Data and Laboratory Data. The Derived Parameters option is divided into two modules: Geotechnical Parameters Derived from Geophysical Data and Relationships between Vs and SPT (N) Values. The Analysis of Soil Problems (with Static and Dynamic Loads) option is divided into nine modules: Bearing Capacity for Shallow and Deep Foundations. Settlement Analysis (Static and Dynamic Loads), Estimation of Subgrade Reaction Coefficient, Slope Stability Analysis, Seismic Hazard Analysis, Strong Motion Attenuation Relationships, Acceleration/Velocity/Displacement Spectra, Soil Amplification Analysis and Soil Liquefaction Analysis. Soil engineering also permits plotting geophysical and geotechnical data with analysis. (C) 2010 Elsevier Ltd. All rights reserved.