Solutions for Soil and Structural Systems Using Excel and VBA Programs [With CDROM]

By Robert L. Sogge and Robert Sogge

A practical guide to analyzing soil and structural systemsusing Excel spreadsheets and VBA macro programs (in open-sourcecode) that are provided on the accompanying CD.

This book gives readers the tools to understand the methods suchas finite element analysis used to analyze common problems instructural engineering, foundation engineering and soil-structureinteraction. The book has value just based on itsinstructions in Excel spreadsheets and the Visual Basic forApplications (VBA) macro programming language alone. By providingan expert system and guidance to the reader in its use throughexamples, the author shows the methods and simple modellingtechniques that demystify soil-structure applications by presentingthe essentials in a clear and concise way.

The book also addresses some of the disappointments ingeo-engineering by providing tools to calculate deformations, implement soil-structure interaction procedures, providesimple computer solutions, while incorporating proper soil and rockproperties in the analyses.

Can be used by students or practicing professional engineers asa hands-on self-study guide as prewritten complete Excelspreadsheets and VBA programs are applied to many different CivilEngineering example problemsVBA code techniques and its use and programming are explainedbut a working knowledge is not required to use the spreadsheet andprograms providedComputations are performed using VBA macro programs gettinginput data from worksheet cells (whereby the spreadsheet functionsas a pre-processor) or from input data files

Robert L. Sogge has a background which includes training, teaching, research and practical consulting in the area ofsoil-structure interaction. He achieved his PhD in CivilEngineering at the University of Arizona, USA, and practices inthat state and California. He has developed many of thesecomputer programs in the pursuit of his work as aconsultant.

• Format: Hardcover
• Language: English
• ISBN: 1119951550
• ISBN13: 9781119951551
• Release Date: October 2012
• Publisher: Wiley
• Length: 312 Pages
• Weight: 1.40 lbs.
• Dimensions: 0.8" x 6.9" x 9.8"