Water Engineering with the Spreadsheet

[ska51]

Water Engineering with the Spreadsheet: A Workbook for Water Resources Calculations Using Excel

Author(s)/Editor(s): Ashok Pandit | Size: 2 MB | Format: PDF | Quality: Original preprint | Publisher: ASCE Press | Year: 2016 | pages: 204 | ISBN: 0784414041

Water Engineering with the Spreadsheet: A Workbook for Water Resources Calculations Using Excel presents more than 90 problems, from easy to difficult, in the areas of fluid mechanics, hydraulics, hydrology, and stormwater management. The accompanying unlocked spreadsheets are used to solve the problems and provide hands-on experience with Excel.

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.

Code:

***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html
***************************************

Code:

***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html
***************************************

All credit go to the original contributor of this book to this forum @xnr09.

Code:

***************************************
Content of this section is hidden, You must be registered and activate your account to see this content. See this link to read how you can remove this limitation:

http://forum.civilea.com/thread-27464.html
***************************************

This post has been made by CivilEA Post-Generator V2.3.1