Notes about the Spreadsheet Computation


  • The initial time j is taken as 12 min in the computation.
  • The inflow hydrograph is computed using either Time-Area Method or the Runoff-Routing Model.
  • Water level WL (m RL) is equal to Water Depth (m) + datum (RL) where the datum is 99.5 m RL.
  • The interpolation of Q and H values (Columns 7 and 8) were done using a Microsoft Visual Basic for Application in Excel (see Figure 1.3).
  • The outflow hydrograph has the highest peak discharge of 7.44 m3/s at 101.55 m RL.
  • The highest peak discharge is compared to and found to be less than the pre-development peak.
  • The highest water level of 101.55 m RL is found to be lower than the top of the reservoir, thus will not cause overtopping of the reservoir.
Back : Worked Example 1                                        Next : Case Study 1


Print This Page Print This Page

3 thoughts on “Notes about the Spreadsheet Computation

  1. Pingback: Oakley Big Taco
  2. Pingback: Cheap ray bans
  3. A person essentially help to make seriously articles I would state.

    This is the first time I frequented your web page and thus far?

    I amazed with the research you made to make this particular publish amazing.
    Wonderful job!

Leave a Reply

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