Make your own free website on



My Book Proposal!

Statement of Aims


Background : derived from research, practice and teaching.

Rationale: a collection of engineering applications in the area of water resources including: hydrology, hydraulics, irrigation, water environment, and Linear Programming applications.  It concentrates on how to put design calculations in spreadsheet form.

Approach: make design calculations easier and more efficient without learning much about programming, use of graphics, statistics and optimization tools available in EXCEL.

Features: the simple use of a powerful computational tool to carry out water resources calculations with practical examples.


Definition of Market


Readership: aimed for practicing engineers, engineering instructors, can be bought by educational institutions and government and private design offices, will be read by engineers, professionals, and engineering students, it has an international appeal since the examples used are of global importance and reflect the state of the art practices, it can be sold in the States, Europe, the Far and the Middle East, the subject is basic engineering topics and the approach is used already.

Level: undergraduate engineering students, and probably diploma level, the book takes the reader to a higher professional level.

Courses: recommended for third year engineering students as a supplementary book on the main subjects: hydraulics, hydrology, irrigation and environmental engineering, or as main text on a series of courses that can be titled computational hydraulics or hydrology, irrigation design calculations, computational environmental hydraulics, project management, or network problems.


Existing Books: there is no clear competitor, since the available books are less specialized and do not follow the same approach, I find my book more clear and the examples cited are more practical.  The following are some samples of related books,


                Quattro Pro for Scientific and Engineering Spreadsheets, R.G. Parks, Springer-Verlag, 1992

                Computerized Environmental Modelling, J. Hardisty, D Taylor, S. Metcalfe, John Wiley &  Sons, 1993

                Spreadsheet Tools for Engineers, B. Gottfried, McGraw-Hill, 2000

                Spreadsheets in Science and Engineering, G. Filby (Ed.), Springer-Verlag Berlin Heidelberg, 1998


Detailed Synopsis



Book working title:  Spreadsheet Applications in Water Resources

List of contents:   


1.0 Introduction (1.1 What Are Spreadsheets?, 1.2 Spreadsheets and Programming Languages, 1.3 Simple Examples, 1.3.1 Catchment Routing, 1.3.2 Dam Volume, 1.3.3  Flow in Natural Channels, 1.3.4 Hydraulic Properties of Natural Channels, 1.3.5 Friction Loss in Pipes, 1.3.6 Pump Operation, 1.3.7 Economics of Water Supply Systems, 1.3.8 Groundwater Model)


2.0 Hydraulics Applications (2.1 Water Resources Systems, 2.2 Analysis of Pipe Networks, 2.3 Design of Collection Networks, 2.4 Water and Bed Profile Calculations, 2.5 Design of Grassed Waterways, 2.6 Shoreline Prediction)


3.0 Hydrology Applications ( 3.1 Pumping Well System Control, 3.2 Rainfall-Runoff Calculations, 3.3 Flow Routing, 3.4 Design of Small Hydropower Plants, 3.5 Pumping Test Analysis, 4.6 Groundwater Modeling)


4.0 Irrigation Applications (4.1 Calculation of Evapo-transpiration, Irrigation Scheduling, 4.2 Design of Earth and Gravity Dams, 4.3 Hydraulic Design of Earth Embankments , 4.4 Land Grading Calculations, Design of Branched Distribution Systems, 4.5 Design of Surface Irrigation) Systems, 4.6 Design of Modern Irrigation Systems)


5.0 Environmental Applications (5.1Conversion of Units, 5.2 Prediction of Word Population, 5.3 Calculation of Mass Loading Rates, 5.4 Discharge of Residual Materials into Rivers, 5.5 Stream Pollution Modeling, 5.6 Dispersion Coefficient in Rivers, 5.7 Estimation of Diffusion Coefficient in Lakes, 5.8 Turbulent Transport in Rivers, Wastewater Control in Rivers)


6.0 Linear Programming Applications (6.1 Project Management, 6.2 Network Problems, 6.2.1 Transshipment, 6.2.2.Shortest Path, 6.2.3 Transportation/Assignment, 6.2.4 Generalized Network, 6.3 Integer             Linear programming, 6.4 Class Scheduling, 6.5 Steel Bar Cutting.)


Length: Chapters (approximate number of pages): 1 (28), 2(158), 3(87), 4(112), 5(53), 6(82), total length is 520 pages

Illustrations: Chapters (approximate number): 1 (22), 2 (100), 3 (60), 4 (65), 5 (30), 6(60) total number is 340.

Timetable: All chapters are available in draft form, I can make some available any time


Additional Information


About me: Dr. Aly N. El-Bahrawy, Professor of Hydraulics, Faculty of Engineering, Ain Shams University, 1 El-Sarayat Street, Abbasia, Cairo, 11517, Ph. and Fax: 202-6831797, Mobile: 012-7340569,, B.Sc. in Irrigation and Hydraulics (1975, Ain Shams Univ., Egypt), M.Sc. in Experimental Hydraulics (1979, Ain Shams Univ., Egypt), Ph.D. in Computational Water Resources (1985, McMaster Univ., Canada), Consultant for different international projects funded by CIDA and other organizations, taught and conducted research in Canada, Germany, Japan, the Arabian Gulf, and Ethiopia, have more than 50 published papers, supervised and examined more than 20 M.Sc. and Ph.D. candidates in the water resources area.  I am Egyptian.


Supporting Material:

A sample draft chapter and a journal article can be sent upon request


This site was last updated 01/13/06