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

ISBN-13: 9780784414040 / Angielski / Miękka / 2016 / 214 str.

Ashok S. Pandit

Opis

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. 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. The e-book edition is accompanied by a downloadable .zip file for the Excel files. Microsoft Excel software is not included; Excel 2003 or above is recommended. 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.