An Introduction to Excel for Civil Engineers

An Introduction to Excel for Civil Engineers

Author: Gunthar Pangaribuan

Publisher: Createspace Independent Publishing Platform

Published: 2016-07-09

Total Pages: 388

ISBN-13: 9781535196529

DOWNLOAD EBOOK

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! 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!


An Introduction to Excel for Civil Engineers

An Introduction to Excel for Civil Engineers

Author: Gunthar Pangaribuan

Publisher:

Published: 2020-03-28

Total Pages: 386

ISBN-13:

DOWNLOAD EBOOK

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 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! 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. The exercise files can be downloaded freely from the Author's blog (renew).


Fundamentals of Civil Engineering

Fundamentals of Civil Engineering

Author: Richard H. McCuen

Publisher: CRC Press

Published: 2011-02-22

Total Pages: 232

ISBN-13: 1439851492

DOWNLOAD EBOOK

While the ASCE Body of Knowledge (BOK2) is the codified source for all technical and non-technical information necessary for those seeking to attain licensure in civil engineering, recent graduates have notoriously been lacking in the non-technical aspects even as they excel in the technical.Fundamentals of Civil Engineering: An Introduction to the


Excel for Scientists and Engineers

Excel for Scientists and Engineers

Author: E. Joseph Billo

Publisher: John Wiley & Sons

Published: 2007-03-16

Total Pages: 480

ISBN-13: 0470126701

DOWNLOAD EBOOK

Learn to fully harness the power of Microsoft Excel® to perform scientific and engineering calculations With this text as your guide, you can significantly enhance Microsoft Excel's® capabilities to execute the calculations needed to solve a variety of chemical, biochemical, physical, engineering, biological, and medicinal problems. The text begins with two chapters that introduce you to Excel's Visual Basic for Applications (VBA) programming language, which allows you to expand Excel's® capabilities, although you can still use the text without learning VBA. Following the author's step-by-step instructions, here are just a few of the calculations you learn to perform: Use worksheet functions to work with matrices Find roots of equations and solve systems of simultaneous equations Solve ordinary differential equations and partial differential equations Perform linear and non-linear regression Use random numbers and the Monte Carlo method This text is loaded with examples ranging from very basic to highly sophisticated solutions. More than 100 end-of-chapter problems help you test and put your knowledge to practice solving real-world problems. Answers and explanatory notes for most of the problems are provided in an appendix. The CD-ROM that accompanies this text provides several useful features: All the spreadsheets, charts, and VBA code needed to perform the examples from the text Solutions to most of the end-of-chapter problems An add-in workbook with more than twenty custom functions This text does not require any background in programming, so it is suitable for both undergraduate and graduate courses. Moreover, practitioners in science and engineering will find that this guide saves hours of time by enabling them to perform most of their calculations with one familiar spreadsheet package


Engineering Computations

Engineering Computations

Author: Joseph C. Musto

Publisher:

Published: 2009-01-01

Total Pages: 330

ISBN-13: 9780071263573

DOWNLOAD EBOOK

The strength of Engineering Computation is its combination of the two most important computational programs in the engineering marketplace today, MATLAB® and Excel®. Engineering students will need to know how to use both programs to solve problems. The focus of this text is on the fundamentals of engineering computing: algorithm development, selection of appropriate tools, documentation of solutions, and verification and interpretation of results. To enhance instruction, the companion website includes a detailed set of PowerPoint slides that illustrate important points reinforcing them for students and making class preparation easier.


Excel Crash Course for Engineers

Excel Crash Course for Engineers

Author: Eklas Hossain

Publisher: Springer Nature

Published: 2021-03-31

Total Pages: 254

ISBN-13: 303071036X

DOWNLOAD EBOOK

Excel Crash Course for Engineers is a reader-friendly introductory guide to the features, functions, and applications of Microsoft Excel in engineering. The book provides readers with real-world examples and exercises that are directly related to engineering, and offers highly illustrated, step-by-step demonstrations of techniques to solve and visualize engineering problems and situations. The book includes an introduction to MS Excel, along with in-depth coverage of graphing and charting, functions and formulae, Excel's Visual Basic for Applications (VBA) programming language, and engineering data analysis. This powerful tutorial is a great resource for students, engineers, and other busy technical professionals who need to quickly acquire a solid understanding of Excel.


Statistics and Probability for Engineering Applications

Statistics and Probability for Engineering Applications

Author: William DeCoursey

Publisher: Elsevier

Published: 2003-05-14

Total Pages: 417

ISBN-13: 0080489753

DOWNLOAD EBOOK

Statistics and Probability for Engineering Applications provides a complete discussion of all the major topics typically covered in a college engineering statistics course. This textbook minimizes the derivations and mathematical theory, focusing instead on the information and techniques most needed and used in engineering applications. It is filled with practical techniques directly applicable on the job. Written by an experienced industry engineer and statistics professor, this book makes learning statistical methods easier for today's student. This book can be read sequentially like a normal textbook, but it is designed to be used as a handbook, pointing the reader to the topics and sections pertinent to a particular type of statistical problem. Each new concept is clearly and briefly described, whenever possible by relating it to previous topics. Then the student is given carefully chosen examples to deepen understanding of the basic ideas and how they are applied in engineering. The examples and case studies are taken from real-world engineering problems and use real data. A number of practice problems are provided for each section, with answers in the back for selected problems. This book will appeal to engineers in the entire engineering spectrum (electronics/electrical, mechanical, chemical, and civil engineering); engineering students and students taking computer science/computer engineering graduate courses; scientists needing to use applied statistical methods; and engineering technicians and technologists. * Filled with practical techniques directly applicable on the job* Contains hundreds of solved problems and case studies, using real data sets* Avoids unnecessary theory


A Guide to Microsoft Excel for Scientists and Engineers

A Guide to Microsoft Excel for Scientists and Engineers

Author: Bernard V. Liengme

Publisher: Butterworth-Heinemann

Published: 2000

Total Pages: 292

ISBN-13:

DOWNLOAD EBOOK

This work gives scientific and engineering students an introduction to the use of excel for the analysis and presentation of experimental results. It also discusses some of the more advanced functions, such as modelling.


The Civil Engineering Handbook

The Civil Engineering Handbook

Author: W.F. Chen

Publisher: CRC Press

Published: 2002-08-29

Total Pages: 2898

ISBN-13: 1420041215

DOWNLOAD EBOOK

First published in 1995, the award-winning Civil Engineering Handbook soon became known as the field's definitive reference. To retain its standing as a complete, authoritative resource, the editors have incorporated into this edition the many changes in techniques, tools, and materials that over the last seven years have found their way into civil


Fundamentals of Engineering FE Civil All-in-One Exam Guide

Fundamentals of Engineering FE Civil All-in-One Exam Guide

Author: Indranil Goswami

Publisher: McGraw Hill Professional

Published: 2018-03-23

Total Pages: 657

ISBN-13: 1260011356

DOWNLOAD EBOOK

This highly effective study guide offers 100% coverage of every subject on the FE Civil examThis self-study resource contains all of the information you need to prepare for and pass the challenging FE Civil exam on the first try. The book features clear explanations of every topic on the exam as well as hands-on exam strategies and accurate practice problems with fully worked solutions.Organized to follow the order of the official exam syllabus, the book includes references to the official FE Reference Handbook along with tips on how to utilize that resource during the exam itself. Written by a leading civil engineering educator and exam coach, Fundamentals of Engineering FE Civil All-in-One Exam Guide helps you pass the exam with ease.•Contains complete coverage of all objectives for the FE Civil exam•Follows the exact order of the official exam syllabus •Written by an experienced educator and researcher