Solutions for soil and structural systems using Excel and VBA programs

Select an Action

Place Hold(s)
Add to My Lists
Email
Print

Title:

Personal Author:

Sogge, Robert Lund

Publication Information:

Hoboken, NJ : Wiley, 2012.

Physical Description:

xx, 286 p. : ill. ; 26 cm. + 1 CD-ROM (12 cm.)

ISBN:

9781119951551

General Note:

Accompanies by Cd-ROM : CP 026577 ; CP 029895

Abstract:

"Provides a cost-effective alternative to Finite Element software tools for soil and structural analysisGiving 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. The book demystifies complex soil and structure applications using simple modelling techniques to present the essentials in a clear and concise way.It also shows the theory behind the programming of the finite element method, and how analysis using Excel spreadsheets and VBA macros can be used to test underlying assumptions of FEM tools. By providing an expert system and guidance to the reader in its use through examples, the text shows how an analysis of any structure or soil-structure system, regardless of complexity, can be conducted. It explains the operations being performed by all the computer programs in a general manner, and any limitations, simplifying assumptions, or approximations inherent in the method. The book also addresses some of the common problems and misunderstandings in the theory and practice of geo-engineering by providing tools to calculate deformations; implement soil-structure interaction procedures for many problems; provide reality checks on more complicated procedures; and enable proper implementation of soil and rock properties in analyses. A hands-on reference enabling readers to efficiently solve problems in the analysis of geotechnical and structural systems using Excel and VBA macros Uniquely utilises Excel spreadsheets and programming tools to solve practical problems in soil-structure interaction in a cost-effective way Both a self-study guide and a reference, with extensive question and answer sections within chapters, to enable hands-on learning Includes an Appendix with solutions to practical civil engineering applications Companion website features Matlab coding, Excel spreadsheets and VBA macros "-- Provided by publisher.

"The book demystifies complex soil and structure applications using simple modelling techniques to present the essentials in a clear and concise way"-- Provided by publisher.

Title Subject:

Microsoft Visual BASIC

Microsoft Excel (Computer file)

Subject Term:

Soil mechanics -- Data processing

Finite element method -- Computer programs

Available:*

Library	Item Barcode	Call Number	Material Type	Item Category 1	Status
Searching... PSZ JB	30000010293763	TA710 S586 2012	Open Access Book	Book	Searching... Unknown
Searching... PSZ KL	30000010240221	TA710 S586 2012	Open Access Book	Book	Searching... Unknown
Searching... Razak School	30000010302984	TA710 S586 2012	Open Access Book	Book	Searching... Unknown

On Order

Summary

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 files

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.

Author Notes

About the Author	p. xxi
Preface	p. xxiii
Acknowledgments	p. xxv
Part 1 Computer Software	p. 1
1 Microsoft Excel Spreadsheet	p. 3
1.1 History of Spreadsheet Development	p. 3
1.2 Excel 2010	p. 4
1.2.1 File Conversion and Compatibility	p. 4
1.3 Transmitting Cell Values Not Formulas	p. 5
1.4 Accuracy	p. 5
1.5 Saving	p. 6
1.6 Implementation of Excel Features	p. 6
1.6.1 General Tips	p. 6
1.6.2 Fonts	p. 7
1.6.3 =IF Statements	p. 7
1.6.4 Naming Cells	p. 8
1.6.5 Functions	p. 8
1.6.6 Drawing	p. 9
1.6.7 Charting	p. 9
Related Workbook on DVD	p. 11
Further Readings	p. 11
2 Microsoft VBA Programming Language	p. 13
2.1 History of the BASIC Computer Language	p. 13
2.1.1 Stage I - BASIC with CP/M and DOS	p. 13
2.1.2 Stage II - Visual BASIC with Windows	p. 14
2.1.3 Stage III - VBA and Excel with Windows	p. 15
2.2 Justification for Using Excel with VBA Macros	p. 15
2.3 Difference between aWorkbook and a VBA Macro	p. 16
2.4 VBA Macro Nomenclature	p. 16
2.5 Generating a Procedure	p. 17
2.6 Security Level Required to Open VBA Macros	p. 19
2.7 VBA Code Statements that Differ from Previous BASIC Versions	p. 19
2.8 Implementation of VBA Macro Programming	p. 20
2.8.1 Type and Size Declaration of Variables for Subs and Functions	p. 20
2.8.2 Integer Variables	p. 20
2.8.3 Floating Point Variables	p. 21
2.8.4 Double-Precision Variables	p. 21
2.8.5 Currency Variables	p. 22
2.8.6 String Variables	p. 22
2.8.7 Variant Variables	p. 22
2.8.8 Declaring Data Types in Sub or Function Procedures	p. 23
2.8.9 Dimensioning Variables	p. 23
2.8.10 Option Explicit Statement	p. 24
2.8.11 ReDim Statement	p. 24
2.8.12 Sub Procedure	p. 24
2.8.13 Function Procedure	p. 25
2.9 Inputting Data to a VBA Procedure	p. 26
2.9.1 In Worksheet Cells	p. 26
2.9.2 From a Sequential Data File	p. 27
2.9.3 From Input Boxes	p. 30
2.10 Output Data from a VBA Procedure	p. 30
2.10.1 Output toWorksheet Cells	p. 30
2.10.2 Output to a Sequential Data File	p. 31
2.11 Running a Macro	p. 32
2.11.1 Using a Start Button	p. 32
2.11.2 Alternative Start Methods	p. 33
2.12 Code Debugging	p. 33
2.13 Charting in a Worksheet	p. 34
2.14 Line Plots in a Worksheet	p. 34
2.15 Macro Sub Program Showing Output toWorksheet	p. 35
2.16 Computer Hardware/Software Requirements	p. 36
2.16.1 Memory Requirements	p. 36
2.16.2 Processing Speed	p. 37
Related Workbooks on DVD	p. 38
Further Readings	p. 39
Part 2 Structures	p. 41
3 Finite Element Method - The Theory	p. 43
3.1 Theory	p. 43
3.2 Developing the Element Stiffness Matrix	p. 44
3.2.1 Equilibrium	p. 44
3.2.2 Force-Deformation (Stress-Strain)	p. 46
3.2.3 Deformation Compatibility	p. 46
3.3 Creating the Global Stiffness Matrix by Assembling Element Stiffnesses	p. 47
3.4 Solving Simultaneous Equations for Displacements	p. 47
3.5 Element Displacements and Forces	p. 48
3.6 Flowchart of Steps	p. 49
Related Workbook on DVD	p. 49
References	p. 49
4 Finite Element Analysis VBA Program PFrame	p. 51
4.1 Program PFrame - Finite Element Analysis (FEA) of Beam-Bar Structural Systems	p. 51
4.2 Creating an Input Data Worksheet	p. 52
4.3 Input Data	p. 52
4.3.1 Member Axis Orientation and Conversion of Moment of Inertia	p. 54
4.4 Joint Numbering and Dimensions	p. 56
4.5 Load Application	p. 58
4.5.1 Applied Joint Loads	p. 58
4.5.2 Applied Member Loads	p. 58
4.5.3 Applied FEFs	p. 58
4.6 Imposed Joint Displacements	p. 59
4.7 Unstable or Improperly Supported Configurations	p. 60
4.8 Running Program PFrame	p. 60
4.9 Output Data	p. 62
4.10 Alternate Solution Approach to Macro Program PFrame	p. 63
4.11 Significant Aspects of Excel Worksheet & VBA Macro Program Construction	p. 63
5 Beams	p. 65
5.1 Beam Member Types	p. 65
5.2 Bar Members as Pinned-End Beams	p. 65
5.3 Moment of Inertia Conversion for Different Member Axis Orientation	p. 67
5.4 Load Application	p. 69
Related Workbooks on DVD	p. 69
6 Frames	p. 71
6.1 Analysis of Frames	p. 71
6.2 Rigid Joints	p. 71
6.3 Joint Numbering	p. 71
6.4 Pinned-End Beam	p. 73
6.5 Supports	p. 74
6.5.1 Inclined or Skewed	p. 74
6.5.2 Elastic	p. 74
6.5.3 Imposed Support Displacements	p. 75
6.6 Varying EI of Members Comprising a Frame	p. 75
6.7 Stability - The P- Effect	p. 76
6.8 Load Case Combinations of Load Groups	p. 76
6.9 Interior Member Forces	p. 77
6.10 Examples	p. 77
Related Workbooks on DVD	p. 79
References	p. 80
7 Trusses	p. 81
7.1 Theory for Bar Members	p. 81
7.2 Analysis of Bar Assemblage	p. 81
7.3 Load Application	p. 82
7.4 Initial Member Length Changes	p. 82
7.5 Support Displacements	p. 82
Reference	p. 82
8 Reinforced Concrete	p. 83
8.1 Concrete and Reinforcing Steel Properties	p. 83
8.2 Design Capacity and Reinforcing Requirements	p. 84
8.2.1 Shear Design Capacity	p. 85
8.2.2 Moment Design Capacity	p. 85
8.2.3 Beam-Column Capacity	p. 86
8.2.4 Shrinkage and Temperature Reinforcement (AASHTO 5.10.8)	p. 87
8.2.5 Reinforcement to Control Cracking	p. 87
8.3 Strength Properties for a Soil-Structure Interaction Analyses	p. 89
8.4 Cracked-Section Concrete Properties	p. 90
8.5 Excel Workbooks	p. 91
8.5.1 Workbook Reinf Concrete	p. 91
8.5.2 Workbook Beam-LFD	p. 92
8.5.3 Workbook Beam-Col ID	p. 92
8.5.4 Workbook PMEIX-VBA	p. 92
Related Workbooks on DVD	p. 92
8.6 Notation	p. 92
References	p. 93
Part 3 SOILS	p. 95
9 Soil Classification	p. 97
9.1 Field Geotechnical Processes	p. 97
9.1.1 Soil/Rock Exploration	p. 97
9.1.2 Soil/Rock Sampling	p. 98
9.1.3 Field Testing	p. 99
9.2 Soil Description	p. 100
9.2.1 Color	p. 100
9.2.2 Basic Soil Type	p. 100
9.2.3 Modifying Terms	p. 101
9.2.4 Special Soil Types	p. 101
9.3 Field and Laboratory Tests for Soil Identification	p. 103
9.3.1 Field Tests for Soil Identification	p. 103
9.3.2 Laboratory Testing for Soil Identification	p. 105
9.4 Soil Classification Systems	p. 106
9.4.1 Textural Classification	p. 106
9.4.2 Engineering Classification	p. 106
9.5 Excel Workbooks and VBA Programs	p. 108
Related Workbooks on DVD	p. 109
9.6 Soil Mechanics Symbol Nomenclature	p. 109
References	p. 113
10 Soil Strength Properties	p. 115
10.1 Discrete and Elastic Finite Element Models	p. 115
10.2 General Elasticity Equations Relating Stress and Strain	p. 115
10.2.1 Alternative Constitutive Equation Formulation	p. 116
10.2.2 Two-Dimensional Plane-Stress and Plane-Strain Constitutive Equations	p. 117
10.3 Modulus of Elasticity and Poisson's Ratio	p. 118
10.3.1 The Stress-Strain Curve	p. 118
10.3.2 Failure Strength Related to Confining Pressure Dependency	p. 120
10.3.3 Elastic Modulus - Relation to Pore Water Pressure and Water Content	p. 121
10.3.4 Elastic Modulus for Repeated Loading	p. 123
10.3.5 Elastic Modulus for Dynamic Loading	p. 124
10.3.6 Analytical Expressions for Elastic Modulus	p. 124
10.3.7 Secant and Tangent Modulus Values for Iterative and Incremental Analysis	p. 132
10.3.8 General and Local Failure Conditions	p. 134
10.3.9 The Relation between ¿, ¿, and Ko	p. 134
10.3.10 Analytical Representation of Poisson's Ratio	p. 135
10.3.11 Typical E and ¿ Values	p. 135
10.4 Coefficient of Subgrade Reaction	p. 135
10.4.1 Terzaghi Relation for kv and kh	p. 136
10.4.2 Bowles Relation for kh	p. 136
10.4.3 E and kh Developed from Lateral Wall Movement	p. 137
10.4.4 Relation between kv and E	p. 138
10.5 Mathematical Descriptions of Curves Using Program Curve Fit	p. 138
References	p. 139
11 Stresses in an Elastic Half-Space	p. 141
11.1 Closed-Form Elasticity Solutions	p. 141
11.2 Lateral Stresses against a Wall Restrained from Movement due to Point, Line, and Strip Loading	p. 141
11.3 Boussinesq Equation	p. 141
11.3.1 Assumptions	p. 142
11.4 Westergaard Equation	p. 142
11.5 Mindlin Equation	p. 142
11.6 Chart Solutions	p. 142
11.7 Excel Workbook - Lat&VertStress	p. 143
11.8 VBA Program HSpace	p. 143
11.9 Significant Programming Aspects	p. 144
11.10 VBA Program HSpace - Program Documentation	p. 144
Related Workbooks on DVD	p. 147
References	p. 147
12 Lateral Soil Pressures and Retaining Walls	p. 149
12.1 Lateral Earth Pressure - Sloped Backfill Acting on Inclined Retaining Wall	p. 149
12.2 Slope Stability	p. 150
12.3 Stability of a Vertical Cut	p. 150
12.4 Retaining Wall Movements	p. 151
12.5 Retaining Walls - Factor of Safety	p. 151
Related Workbooks on DVD	p. 152
References	p. 152
13 Shallow and Deep Foundation Vertical Bearing Capacity	p. 153
13.1 Shallow Foundations	p. 153
13.2 Vertical Bearing Stress Capacity	p. 153
13.3 Soil Pressure Distribution	p. 154
13.3.1 Smooth and Rough Footing Bottoms	p. 154
13.3.2 Eccentric Loadings	p. 155
13.3.3 Footing Flexibility	p. 155
13.4 Settlement-Based Bearing Capacity	p. 155
13.5 Excel Workbooks	p. 156
13.6 Deep Foundations	p. 156
13.7 Capacities Based on Displacement Limits	p. 157
13.7.1 End Bearing	p. 157
13.7.2 Skin Resistance	p. 157
13.7.3 Combined Capacity and Factor of Safety	p. 157
13.8 Capacities Based on Stress Limits	p. 158
13.8.1 End Bearing	p. 158
13.8.2 Skin Resistance	p. 159
13.8.3 Bearing Capacity in Terms of Blow Counts	p. 159
13.8.4 Reduction in Capacity Based on Spacing	p. 160
13.9 Limitations on Capacities	p. 160
13.10 Load Testing	p. 161
13.11 Pier Settlement	p. 161
13.12 Excel Workbook	p. 161
13.13 Combined Foundations - Shallow and Deep	p. 161
Related Workbooks on DVD	p. 162
References on Shallow Foundations	p. 162
References on Deep Foundations	p. 162
References on Load Testing of Deep Foundations	p. 162
References Associated with the Osterberg Load Cell	p. 163
14 Slope Stability	p. 165
14.1 Workbook Program Slope - Slope Stability by Bishop's Modified Method of Slices	p. 165
14.2 Workbook Program STABR - Slope Stability by Bishop's Modified Method of Slices	p. 166
14.3 Workbook Program Slope8R - Slope Stability by Spencer's Procedure for Non-circular Slip Surfaces	p. 167
Related Workbooks on DVD	p. 167
References	p. 167
15 Seepage Flow through Porous Media	p. 169
15.1 Program Flownet for Analysis of Seepage Flow through Porous Media	p. 169
15.2 Program Input - from Data file	p. 170
15.3 Program Output - to Data File	p. 171
15.4 Input Data Description	p. 172
15.5 Output Data Description	p. 172
15.6 Example	p. 172
15.7 Significant Aspects of Excel Workbook and VBA Macro Program Construction	p. 174
Related Workbooks on DVD	p. 175

Available:*

On Order

Summary

Summary

Author Notes

Table of Contents