Ashok Pandit, Ph.D., P.E., has been employing spreadsheets in the classroom and in practice for more than 20 years. Used as a supplement to undergraduate and graduate texts and lectures, Pandit's book will help students gain a solid foundation in using spreadsheets for applications in water engineering.

Topics include: force calculations under static and dynamic conditions, pipe design, and pipe network analysis; open channel flow; normal and critical depth calculations; channel designs and transitions; lake evaporation; unit hydrographs and S-hydrographs; convolution and deconvolution; reservoir and channel routing; and analysis and design of stormwater management systems for land development, including retention/detention basins and storm sewers.

Pandit provides background information, helpful hints, assumptions, equations to be used, solutions, and a what-if analysis to provide an in-depth examination of the problem. Advanced features of Excel spreadsheets, such as Goal Seek, Circulation Cells, and Trendlines, are explored.

Students will find this book an excellent preparation for the fundamentals of engineering or professional engineering exams. Practitioners may also find this a convenient collection of ready-to-use spreadsheets for a professional practice.

Note to customers: The print edition of this book contains a CD-ROM with unlocked Excel files. Microsoft Excel software is not included; Excel 2003 or above is recommended.

Order No: R161106
Meduim: Book
Publisher: American Society of Civil Engineers (ASCE)
Year: 2016
ISBN: 978-0-7844-1404-0