Worked Example 1 – Level Pool Routing Through A Reservoir


This is a worked example using a spreadsheet to perform level pool routing through a reservoir.


Following are the data required for the solution of Equation 1.3:

  1. Time step.
  2. Stage-Storage relationship- usually derived from topographic maps.
  3. Stage-Discharge relationship- can be based on formula such as Equation 1.4 for spillway or other appropriate formula.
  4. The inflow hydrograph.
  5. Initial values of storage and discharge.


Equation 2.14 can be solved using the spreadsheet below as follows:


Table 1.1 Stage-Storage-Discharge Data

Figure 1.3 Microsoft Visual Basic For Application In Excel

Table 1.2 Level Pool Routing Using Spreadsheet

Back : Outlet Structure

Next : Note about the spreadsheet

Print This Page Print This Page

Leave a Reply

Your email address will not be published. Required fields are marked *