U3F1ZWV6ZTIxMzgzNDc4MzQ4X0FjdGl2YXRpb24yNDIyNDUzMDg1MTg=

An Introduction to EXCEL for Civil Engineers From engineering theory to Excel practice

An Introduction to EXCEL for Civil Engineers 

From engineering theory to Excel practice 

Gunthar Pangaribuan 


CONTENTS

PREFACE......................................................................................................... ii

Chapter 1: BASICS OF  EXCEL.........................................................................1

1.1 Worksheet and Workbook ............................................................................... 1
1.2 Data Type ........................................................................................................ 2
1.3 Formula..................................................................................................... 5
1.4 BuiltIn Function .............................................................................................. 7
1.5 Array Formula .................................................................................................. 9
1.6 Data Formatting .................................................................................................... 11
1.7 Error Message ................................................................................................. 11
1.8 Printing ................................................................................................................. 12
1.9 Making Charts .................................................................................................... 13
1.10 Engineering Drawing ............................................................................................ 15
1.11 Visual Basic for Application ...................................................................................... 24
1.11.1 Creating Macro ....................................................................................... 25
1.11.2 Recording Macro ................................................................................................. 27
1.11.3 Procedure ................................................................................................................ 29
1.11.4 Running Macro ...................................................................................................... 31
1.11.5 VBA Dictionary ................................................................................................. 32

Chapter 2: EXCEL FUNCTIONS......................................................................................33

2.1 Math and Trigonometry Functions ................................................................................. 33
2.2 Logical Functions ......................................................................................................... 36
2.3 Lookup Functions .................................................................................................... 38
2.4 Text Functions ............................................................................................................. 40
2.5 Data Analysis Functions ............................................................................................... 43
2.5.1 Linear Regression ...................................................................................................... 43
2.5.2 Polynomial Regression ............................................................................................ 52
2.5.3 Interpolation ................................................................................................................ 53
2.5.4 Statistical Data ............................................................................................................. 59
2.5.5 Circular Reference ..................................................................................................... 65

Chapter 3: CREATING MACRO............................................................................................69

3.1 Function Procedure ........................................................................................................... 69
3.2 Sub Procedure ................................................................................................................ 74
3.3 Control Structures .......................................................................................................... 76
3.3.1 Looping ......................................................................................................................... 76
3.3.2 Branching .................................................................................................................... 79
3.4 User Defined Function Problems .................................................................................... 83
3.5 Structure of Program ...................................................................................................... 97
3.5.1 Input Output Form ..................................................................................................... 97
3.5.2 Work With Modules .................................................................................................. 98
3.5.3 Tips .......................................................................................................................... 100
3.6 Chart Macro........................................................................................... 102
3.7 Manipulation on Program Steps ......................................................................... 108

Chapter 4: MATRIX PROGRAM.................................................................................. 112

4.1 Matrix Definition ................................................................................................ 112
4.1.1 Types of Matrix.................................................................................................. 112
4.1.2 Matrix Operation ............................................................................................ 115
4.2 Program for Matrix Operations ................................................................................. 124
4.3 Matrix Method for Structural Analysis ............................................................... 132
4.3.1  Upper Structure .................................................................................................... 132
4.3.2  Sub Structure ......................................................................................................... 134

Chapter 5: NUMERICAL METHOD ................................................... 135

5.1 Numerical Integration ......................................................................... 135
5.2 Numerical Differentiation .................................................................................... 138

Chapter 6: PROGRAM FOR 2D FRAME STRUCTURE ANALYSIS........................... 144

6.1 Case Example................................................................... 144
6.2 Sign Convention for Diagram ............................................................... 160
6.3 Application ........................................................................... 162
Chapter 7: PROGRAM FOR 2D TRUSS STRUCTURE ANALYSIS..... 163
7.1 Case Example................................................. .................................. 164
7.2 Application ....................................................................................... 176

Chapter 8: BEAM ON ELASTIC FOUNDATION............................................ 180

8.1 Case Example.................................................................................. 182
8.1 Application ............................................................................................... 187

Chapter 9: LATERALLY LOADED STRUCTURE.............................................. 189

9.1 Case Example...................................................................................................... 189
9.2 Application ........................................................................................................... 196

Chapter 10: ONE DIMENSIONAL CONSOLIDATION .................................................... 199

10.1 Application 1 ...................................................................................................... 205

10.2 Application 2 ...................................................................................................... 207

Chapter 11: AUTOCAD SCRIPT FILE...................................................................... 210

11.1 Creating Scripts in Worksheet ........................................................................ 210
11.2 Creating Scripts in VBA ............................................................................. 231

REFERENCES ............................................................................. 240

ATTACHMENT: PROGRAM CODE.............................................. 241

Full Text   Click Here

الاسمبريد إلكترونيرسالة