It's a Excel basics book that every civil engineer should have read by now. It addresses skills that may not be covered in most Excel for civil engineering texts, such as step by step guides to create an application program and how to convert the steps into VBA code, how to perform matrix operations (multiplication and inversion) using Excel-VBA, macro for creating an engineering chart, a brief and simple guide to become an instant Excel-VBA programmer, and more...
Also to be presented the depiction in AutoCAD program. Yes! AutoCAD is chosen because one of its advantages that relies on high drawing accuracy. You will learn how to create a simple AutoCAD script file using Excel formulas and Excel-VBA. It is expected that you will be able to create simple Cartesian graph in AutoCAD, even you are an AutoCAD first time user!
In general, the articles presented in this book include:
1. Creating macros for user-defined functions.
2. The use of Excel functions for data analysis obtained from experimental results.
3. Basics of Excel - VBA programming for beginners.
4. Macro sample to create an engineering chart.
5. Creating Excel-VBA programs for Civil Engineering applications such as:
• Analysis of 2D Frame Structure
• Analysis of 2D Truss Structure
• Beam on Elastic Foundation
• Laterally Loaded Structure
• Finite Difference Method for One Dimensional Consolidation
• AutoCAD script file for the depiction in AutoCAD
With the ease of working with Excel, coupled with benefit of the 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 calculation will be an exciting challenge for a programming job is already enjoyable.
Happy Excel programming!
Also to be presented the depiction in AutoCAD program. Yes! AutoCAD is chosen because one of its advantages that relies on high drawing accuracy. You will learn how to create a simple AutoCAD script file using Excel formulas and Excel-VBA. It is expected that you will be able to create simple Cartesian graph in AutoCAD, even you are an AutoCAD first time user!
In general, the articles presented in this book include:
1. Creating macros for user-defined functions.
2. The use of Excel functions for data analysis obtained from experimental results.
3. Basics of Excel - VBA programming for beginners.
4. Macro sample to create an engineering chart.
5. Creating Excel-VBA programs for Civil Engineering applications such as:
• Analysis of 2D Frame Structure
• Analysis of 2D Truss Structure
• Beam on Elastic Foundation
• Laterally Loaded Structure
• Finite Difference Method for One Dimensional Consolidation
• AutoCAD script file for the depiction in AutoCAD
With the ease of working with Excel, coupled with benefit of the 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 calculation will be an exciting challenge for a programming job is already enjoyable.
Happy Excel programming!
