Solutions for Soil and Structural Systems Using Excel and Vba Programs

Informationen zum Autor Robert L. Sogge has a background which includes training, teaching, research and practical consulting in the area of soil-structure interaction. He achieved his PhD in Civil Engineering at the University of Arizona, USA, and practices in that state and California. He has developed many of these computer programs in the pursuit of his work as a consultant. Klappentext A practical guide to analyzing soil and structural systems using Excel spreadsheets and VBA macro programs (in open-source code) that are provided on the accompanying CD.This book gives readers the tools to understand the methods such as finite element analysis used to analyze common problems in structural engineering, foundation engineering and soil-structure interaction. The book has value just based on its instructions in Excel spreadsheets and the Visual Basic for Applications (VBA) macro programming language alone. By providing an expert system and guidance to the reader in its use through examples, the author shows the methods and simple modelling techniques that demystify soil-structure applications by presenting the essentials in a clear and concise way.The book also addresses some of the disappointments in geo-engineering by providing tools to calculate deformations, implement soil-structure interaction procedures, provide simple computer solutions, while incorporating proper soil and rock properties in the analyses.* Can be used by students or practicing professional engineers as a hands-on self-study guide as prewritten complete Excel spreadsheets and VBA programs are applied to many different Civil Engineering example problems* VBA code techniques and its use and programming are explained but a working knowledge is not required to use the spreadsheet and programs provided* Computations are performed using VBA macro programs getting input data from worksheet cells (whereby the spreadsheet functions as a pre-processor) or from input data filesRobert L. Sogge has a background which includes training, teaching, research and practical consulting in the area of soil-structure interaction. He achieved his PhD in Civil Engineering at the University of Arizona, USA, and practices in that state and California. He has developed many of these computer programs in the pursuit of his work as a consultant. Zusammenfassung Giving readers the tools to understand and analyse common problems in structural engineering, foundation engineering and soil-structure interaction, this book is accompanied by Excel Spreadsheets and employs the Visual Basic for Applications (VBA) macro programming language to allow a practical understanding. Inhaltsverzeichnis About the Author xxi Preface xxiii Acknowledgments xxv PART ONE COMPUTER SOFTWARE 1 1 Microsoft Excel Spreadsheet 3 1.1 History of Spreadsheet Development 3 1.2 Excel 2010 4 1.3 Transmitting Cell Values Not Formulas 5 1.4 Accuracy 5 1.5 Saving 6 1.6 Implementation of Excel Features 6 2 Microsoft VBA Programming Language 13 2.1 History of the BASIC Computer Language 13 2.2 Justification for Using Excel with VBA Macros 15 2.3 Difference between aWorkbook and a VBA Macro 16 2.4 VBA Macro Nomenclature 16 2.5 Generating a Procedure 17 2.6 Security Level Required to Open VBA Macros 19 2.7 VBA Code Statements that Differ from Previous BASIC Versions 19 2.8 Implementation of VBA Macro Programming 20 2.9 Inputting Data to a VBA Procedure 26 2.10 Output Data from a VBA Procedure 30 2.11 Running a Macro 32 2.12 Code Debugging 33 2.13 Charting in a Worksheet 34 2.14 Line Plots in a Worksheet 34 2.15 Macro Sub Program Showing Output toWorksheet 35 2.16 Computer Hardware/Software Requirements 36 PART TWO STRUCTURES 41 3 Finite E...

List of contents

About the Author xxi
 
Preface xxiii
 
Acknowledgments xxv
 
PART ONE COMPUTER SOFTWARE 1
 
1 Microsoft Excel Spreadsheet 3
 
1.1 History of Spreadsheet Development 3
 
1.2 Excel 2010 4
 
1.3 Transmitting Cell Values Not Formulas 5
 
1.4 Accuracy 5
 
1.5 Saving 6
 
1.6 Implementation of Excel Features 6
 
Related Workbook on DVD 11
 
Further Readings 11
 
2 Microsoft VBA Programming Language 13
 
2.1 History of the BASIC Computer Language 13
 
2.2 Justification for Using Excel with VBA Macros 15
 
2.3 Difference between aWorkbook and a VBA Macro 16
 
2.4 VBA Macro Nomenclature 16
 
2.5 Generating a Procedure 17
 
2.6 Security Level Required to Open VBA Macros 19
 
2.7 VBA Code Statements that Differ from Previous BASIC Versions 19
 
2.8 Implementation of VBA Macro Programming 20
 
2.9 Inputting Data to a VBA Procedure 26
 
2.10 Output Data from a VBA Procedure 30
 
2.11 Running a Macro 32
 
2.12 Code Debugging 33
 
2.13 Charting in a Worksheet 34
 
2.14 Line Plots in a Worksheet 34
 
2.15 Macro Sub Program Showing Output toWorksheet 35
 
2.16 Computer Hardware/Software Requirements 36
 
Related Workbooks on DVD 38
 
Further Readings 39
 
PART TWO STRUCTURES 41
 
3 Finite Element Method - The Theory 43
 
3.1 Theory 43
 
3.2 Developing the Element Stiffness Matrix 44
 
3.3 Creating the Global Stiffness Matrix by Assembling Element Stiffnesses 47
 
3.4 Solving Simultaneous Equations for Displacements 47
 
3.5 Element Displacements and Forces 48
 
Related Workbook on DVD 49
 
References 49
 
4 Finite Element Analysis VBA Program PFrame 51
 
4.1 Program PFrame - Finite Element Analysis (FEA) of Beam-Bar Structural Systems 51
 
4.2 Creating an Input Data Worksheet 52
 
4.3 Input Data 52
 
4.4 Joint Numbering and Dimensions 56
 
4.5 Load Application 58
 
4.6 Imposed Joint Displacements 59
 
4.7 Unstable or Improperly Supported Configurations 60
 
4.8 Running Program PFrame 60
 
4.9 Output Data 62
 
4.10 Alternate Solution Approach to Macro Program PFrame 63
 
4.11 Significant Aspects of Excel Worksheet & VBA Macro Program Construction 63
 
5 Beams 65
 
5.1 Beam Member Types 65
 
5.2 Bar Members as Pinned-End Beams 65
 
5.3 Moment of Inertia Conversion for Different Member Axis Orientation 67
 
5.4 Load Application 69
 
Related Workbooks on DVD 69
 
6 Frames 71
 
6.1 Analysis of Frames 71
 
6.2 Rigid Joints 71
 
6.3 Joint Numbering 71
 
6.4 Pinned-End Beam 73
 
6.5 Supports 74
 
6.6 Varying EI of Members Comprising a Frame 75
 
6.7 Stability - The P- Effect 76
 
6.8 Load Case Combinations of Load Groups 76
 
6.9 Interior Member Forces 77
 
6.10 Examples 77
 
Related Workbooks on DVD 79
 
References 80
 
7 Trusses 81
 
7.1 Theory for Bar Members 81
 
7.2 Analysis of Bar Assemblage 81
 
7.3 Load Application 82
 
7.4 Initial Member Length Changes 82
 
7.5 Support Displacements 82
 
Reference 82
 
8 Reinforced Concrete 83
 
8.1 Concrete and Reinforcing Steel Properties 83
 
8.2 Design Capacity and Reinforcing Requirements 84
 
8.3 Strength Properties for a Soil-Structure Interaction Analyses 89
 
8.4 Cracked-Section Concrete Properties 90
&

Product details

• Authors: R Sogge, Robert Sogge, Robert (Civil Engineering Consultant) Sogge, Robert Lund Sogge, Sogge Robert
• Publisher: Wiley, John and Sons Ltd
• Languages: English
• Product format: Hardback
• Released: 24.07.2012
• EAN: 9781119951551
• ISBN: 978-1-119-95155-1
• No. of pages: 416
• Subjects: Natural sciences, medicine, IT, technology > Technology > Structural and environmental engineering; Grundbau, Bauingenieur- u. Bauwesen, Civil Engineering & Construction, Soil Constructions & Geotechnics, Grundbau / Geotechnik, Erd- u. Grundbau, Soil (Civil Engineering)