An Introduction to Excel for Civil Engineers: From Engineering Theory to Excel Practice

It’s a must have standard engineering book that should have read many years ago. It addresses many articles that may not be covered by any Excel for 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, 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 choosen 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! This book contains the author’s collection of custom functions and also a series of engineering calculation programming that are very useful to adopt. 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!

Table of Contents

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