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:
- Time step.
- Stage-Storage relationship- usually derived from topographic maps.
- Stage-Discharge relationship- can be based on formula such as Equation 1.4 for spillway or other appropriate formula.
- The inflow hydrograph.
- 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