My Book Proposal!
Statement of Aims
Background : derived from research, practice and teaching.
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.
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
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
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
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.)
(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.
chapters are available in draft form, I can make some available any time
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,
firstname.lastname@example.org, 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.
A sample draft chapter and a journal article can be sent