Up and Running with VBA for Civil Engineers

Microsoft Excel is a comprehensive spreadsheet application that lets you manage, format, chart, and analyze data. Installed on virtually every personal computer in the world, Microsoft Excel provides engineers with a comprehensive tool for managing, formatting, charting, and analyzing the most complex data. Written in an easy to use and understand format, Microsoft Excel For Civil, Mechanical, and Structural Engineers dives into Excel's more complex capabilities and teaches engineers how to take Excel to the next level of usage.Microsoft Excel For Civil, Mechanical, and Structural Engineers helps to unlock the power of Microsoft Excel to solve a full range of engineering problems to meet the needs of all civil, mechanical and structural engineers. In this book, the authors dive directly into Excel's more complex capabilities taking readers to the next level of usage. The significance is to show that a simple and widely available spreadsheet program such as Microsoft Excel has capabilities to perform analysis and modelling of various civil, mechanical and structural engineering applications in a very short time in comparison to the other commercially software.Written by two Excel power users, these engineers have four main goals: 1) to help readers become more gain a more comfortable feel for using Microsoft Excel for analysis and design projects. 2) Develop a solid background of basic programming skills using VBA. 3) Create realistic models comfortably. 4) Understand the importance of presentation and aesthetics of a spreadsheet. The authors accomplish these task by first providing readers with the essential background needed to perform future creative projects with Microsoft Excel. Examples are taken from such areas as Structural, Water, Geotechnical or Traffic engineering. The book allows readers to dive into Excel's more complex capabilities of spreadsheet manipulation and learn basic programming skills with VBA and application development principles.