An Introduction to Excel for Civil Engineers: From engineering theory to Excel practice – Gunthar Pangaribuan
Microsoft Excel learning is perceived as more attractive from time to time and it is probably the most widely software-learning topic written into books, websites, courses, tutorial videos, groups, etc. Favored by many people because Excel is relatively easy to operate and giving “completely” results by showing spreadsheet form (rows and columns), images, text, tables, charts, and so on. Talking about Excel for applied engineering calculation cannot be separated from the discussion on Visual Basic for Application (VBA) macro, which is the programming language of Microsoft Visual Basic for the automation of certain tasks. This is due to macro like any other programming language capable of doing iterative calculation or repeating the calculation process with ease. There is a unique combination between worksheet as user-interface and VBA, which turned out to be a lot makes it easy for users to create a program.
This book also discussed the depiction in AutoCAD software. Why? Because the drawing creation process can be done through Excel formulas or macros, and this will enhance a series of producing program. The advantage of an AutoCAD drawing creation is no doubt that relies on high image accuracy with a myriad of features it will certainly be a challenge to create drawings. With the ease of working with Excel, coupled with a lot of given examples in this book, it is expected to increase the interest of the reader to create new original application programs. Thus, each model or even a specific model of calculation will be an exciting challenge for a programming job is already enjoyable.
Chapter 1: Basics Of Excel
Chapter 2: Excel Functions
Chapter 3: Creating Macro
Chapter 4: Matrix Program
Chapter 5: Numerical Method
Chapter 6: Program For 2D Frame Structure Analysis
Chapter 7: Program For 2D Truss Structure Analysis
Chapter 8: Beam On Elastic Foundation
Chapter 9: Laterally Loaded Structure
Chapter 10: One Dimensional Consolidation
Chapter 11: Autocad Script File
Attachment: Program Code
Enlaces Públicos de descarga