Water Flow Calculator

Discussion in 'Pumps and Waterflow' started by Reef Maniac, 2 Nov 2007.

  1. Reef Maniac

    Reef Maniac MASA Contributor

    Joined:
    15 May 2007
    Posts:
    2,899
    Likes Received:
    112
    Location:
    Bloemfontein
    Hi All,

    Here is a water flow calculator I wrote for Excel - it's pretty self explanatory, but I will gladly answer any questions, if I can...

    Hennie

    Oops, looks like I cannot attach the Excal file - OK, here's a link to it...

    http://www.reefmaniacs.com/hl3/flowcalcs.xls
     
    Rory likes this.
  2. AdS Guest




    to hide all adverts.
  3. Mekaeel

    Mekaeel Moderator MASA Contributor

    Joined:
    8 May 2007
    Posts:
    24,229
    Likes Received:
    127
    Location:
    Point Waterfront Durban
    thanks Hennie.good little program
     
  4. jacquesb

    jacquesb Retired Moderator

    Joined:
    29 May 2007
    Posts:
    17,868
    Likes Received:
    69
    Location:
    Cape Town
    Yes, Thanks Hennie - I agree with Mekaeel! Good to have! Thanks!
     
  5. viper357

    viper357 Admin MASA Contributor

    Joined:
    4 May 2007
    Posts:
    27,991
    Likes Received:
    782
    Awesome Hennie, thank you so much for sharing this with us. Would you mind if we loaded it onto our Calculators Page
     
  6. Reef Maniac

    Reef Maniac Thread Starter MASA Contributor

    Joined:
    15 May 2007
    Posts:
    2,899
    Likes Received:
    112
    Location:
    Bloemfontein
    No problem - you're welcome to load it.

    Hennie
     
  7. Tridan

    Tridan

    Joined:
    15 Sep 2007
    Posts:
    1,910
    Likes Received:
    9
    Location:
    Kei Mouth
    thanks dude took me a while but i think i got it.:yeahdude:
     
  8. Reef Maniac

    Reef Maniac Thread Starter MASA Contributor

    Joined:
    15 May 2007
    Posts:
    2,899
    Likes Received:
    112
    Location:
    Bloemfontein
    OK, now that I have some time perhaps I should elaborate a bit...

    First calc-box is for calculating the capacity of a pipe or bulkhead opening (in other words, the maximum flow through a hole, before head loss due to pipe length, etc.)

    The second calc-box is to calculate flow over any weir - be it the overflow into your C to C, in-tank "sump" box or weir to external downpipe.

    The third calc-box is to calculate capacity of any "box", such as the corner-to-corner overflow.

    The left and right colums in the first two calc-boxes allow for flow over two types of surfaces for the pipe or weir. It is perhaps not widely known, but a well rounded, smooth pipe or weir edge over which the water must flow can increase the capacity of the pipe or weir quite dramatically - enter the same data in both colums and see for your self...

    Hennie
     
  9. DragonReef

    DragonReef

    Joined:
    4 May 2007
    Posts:
    2,601
    Likes Received:
    2
    Location:
    Durban, ZA
    Thanks Hennie.
     
  10. Reef Maniac

    Reef Maniac Thread Starter MASA Contributor

    Joined:
    15 May 2007
    Posts:
    2,899
    Likes Received:
    112
    Location:
    Bloemfontein
    You're welcome :)

    For those with a scientific / engineering interest, the following formulae, as found in the all time "Engineering bible": Technical Formulae by Kurt Gieck, 4th edition, 1979, were used in the spreadsheet:

    Flow through base aperture, or small lateral aperture:
    velocity (v) = Cv x Sqrt(2gH)

    flow (Q) = Cd x A x Sqrt(2gH)
    Q = volume of outlet flow (m^3/s)
    A = cross sectional area perpendicular to fluid flow (m^2)
    g = gravitational constant (~9.8 m/s^2)
    H = "Head" of water (height of water surface above top of aperture)
    Cv = velocity coefficient (for water it is 0.97)
    Cd = discharge coefficient = Cc x Cv
    Cc = contraction coefficient (use 0.62 for a sharp-edged aperture, and 0.97 for a smooth, well-rounded aperture)

    Wow, this was more typing than I anticipated, and my food is getting cold - I will post Manning's formula for the "open channel" at a later stage...

    Hennie
     
  11. viper357

    viper357 Admin MASA Contributor

    Joined:
    4 May 2007
    Posts:
    27,991
    Likes Received:
    782
    Thanks Hennie, I have loaded it onto our calculators page :thumbup:
     
  12. Reef Maniac

    Reef Maniac Thread Starter MASA Contributor

    Joined:
    15 May 2007
    Posts:
    2,899
    Likes Received:
    112
    Location:
    Bloemfontein
    Hi Mods

    I cannot get the calculator to work, IE tells me ther are "errors on the page"...

    Hennie
     
  13. Rory

    Rory Admin MASA Contributor

    Joined:
    5 May 2007
    Posts:
    4,850
    Likes Received:
    34
    Location:
    JHB
    I will whip Viper harder next time...
     
  14. viper357

    viper357 Admin MASA Contributor

    Joined:
    4 May 2007
    Posts:
    27,991
    Likes Received:
    782
    Did you fix it Rory? What was wrong?
     
Recent Posts

Loading...
Similar Threads - Water Flow Calculator Forum Date
Water Flow in DT General Discussions and Advice 24 Dec 2014
Water outflow 28G Nanocube Beginner Discussions 3 Oct 2014
Internal water flow Pumps and Waterflow 1 May 2011
Water flow in large tanks Pumps and Waterflow 29 Mar 2011
Waterflow through pvc pipe scaping? General Discussions and Advice 10 Oct 2010
Water Flow Advice Boyu TL450 and TL550 advice 1 Sep 2010
Regulated Water Flow Pumps and Waterflow 1 Jan 2010