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

Abstract

• 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.

  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 of the Excel files. Microsoft Excel software is not included; Excel 2003 or above is recommended.

  Ashok Pandit, Ph.D., P.E., is currently head of the department of civil engineering at the Florida Institute of Technology. He has more than 30 years of teaching and research experience in the areas of fluid mechanics, hydraulics, hydrology, and numerical groundwater modeling. He is a registered professional engineer with experience in stormwater drainage and management.