Oxford University Press - Online Resource Centres

Hendriks: Introduction to Physical Hydrology

Interactive spreadsheets

These interactive spreadsheets will help you to further explore some of the hydrological problems and equations discussed in the textbook. Each spreadsheet is related to a specific section in the chapter. Read the section, then open the spreadsheet and change the variable values (in the yellow cells) to affect the outcome(s) (the cells with the blue characters). Some spreadsheets contain additional sheets showing graphs, which will also change depending on the values entered (in the yellow cells).

Chapter 2 Section 2.7
Estimation of evaporation from a forest, grassland and open water surface using the Penman-Monteith model - an additional explanatory file on how to perform a sensitivity analysis of the Penman-Monteith model is available as a PDF.

Chapter 3 Exercise 3.10.6
This interactive spreadsheet offers you the possibility to further explore this hydrological problem using other variable values.

Chapter 3 Exercise 3.15.2.5
This interactive spreadsheet offers you the possibility to further explore this hydrological problem using other variable values.

Chapter 4 Section 4.8
Try out the three equations for ponded infiltration: Green & Ampt, Horton, and Philip.

Chapter 5 Section 5.2
Salt dilution gauging - this file helps you to estimate the discharge of a small, turbulent stream during fieldwork.

Chapter 5 Section 5.4
The time-area model for 5 time zones and 7 hours of rainfall.

Chapter 5 Section 5.5
The exponential reservoir model (STORFLO) - an additional explanatory file on the derivation of the STORFLO simulation equation is available as a PDF.

Chapter 5 Section 5.5
Flood frequency curve (annual maximum series using the Weibull formula): Figure B5.10.3.