Gunthar Pangaribuan

An Introduction to Excel for Civil Engineers Gunthar Pangaribuan

Microsoft Excel is a spreadsheet program that is widely used for calculations. It is easy to operate and giving "complete" results by showing rows and columns sheet, images, text, tables, charts, and so on. One of the strong points of Excel is its MACRO capability to shorten and simplify the repetitive works using Visual Basic Application (VBA) programming language. At the next level macro can be developed to make useful application, such as structural analysis.

In general, in this book you will learn:
1. Advancing Excel skills to a higher level by practicing VBA. The main goal is getting used to VBA macro and be able to enjoy it.
2. Using VBA to create user-defined functions. Introducing LINEAR interpolation function that is one of the MOST USEFUL function in civil engineering, alongside LOG and 3rd degree POLYNOMIAL interpolation function presented in this book.
3. Using VBA to automate Excel graph. It is GREAT TIME-SAVER for creating line graphs.
4. Using Excel for civil engineering applications, such as truss and frame analysis using matrix method.
5. The fastest way to create line graph in AutoCAD by automating the process with Excel.

This book includes exercise files and VBA code examples that can be freely downloaded from the link inside.