Water Flow Calculator

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

  1. Reef Maniac

    Reef Maniac

    Joined:
    15 May 2007
    Posts:
    2,899
    Likes Received:
    117
    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. Guest




  3. Mekaeel

    Mekaeel Moderator

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

    jacquesb Retired Moderator

    Joined:
    29 May 2007
    Posts:
    17,868
    Likes Received:
    71
    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:
    29,771
    Likes Received:
    1,375
    Awesome Hennie, thank you so much for sharing this with us. Would you mind if we loaded it onto our Calculators Page
     
  6. OP
    Reef Maniac

    Reef Maniac

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

    Hennie
     
  7. Tridan

    Tridan

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

    Reef Maniac

    Joined:
    15 May 2007
    Posts:
    2,899
    Likes Received:
    117
    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,600
    Likes Received:
    2
    Location:
    Durban, ZA
    Thanks Hennie.
     
  10. OP
    Reef Maniac

    Reef Maniac

    Joined:
    15 May 2007
    Posts:
    2,899
    Likes Received:
    117
    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:
    29,771
    Likes Received:
    1,375
    Thanks Hennie, I have loaded it onto our calculators page :thumbup:
     
  12. OP
    Reef Maniac

    Reef Maniac

    Joined:
    15 May 2007
    Posts:
    2,899
    Likes Received:
    117
    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

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

    viper357 Admin MASA Contributor

    Joined:
    4 May 2007
    Posts:
    29,771
    Likes Received:
    1,375
    Did you fix it Rory? What was wrong?
     

Recent Posts

Loading...
Similar Threads - Water Flow Calculator Forum Date
Water flow / Wavemakers Pumps and Waterflow Yesterday at 06:04
Water flow General Discussions and Advice 28 Oct 2018
Waterflow in 60l Nano Reef General Discussions and Advice 5 May 2018
RSS The Perks of Using A Digital Water Flow Meter RSS Feeds 25 Apr 2018
RSS LupyLED TheFlow Stainless Steel Pipes for Freshwater Aquariums RSS Feeds 30 Jan 2017
RSS Rossmont Waver is poised to shake up reef aquarium water flow RSS Feeds 18 Apr 2016
RSS Simplicity DC pumps redefine the value of controllable water flow RSS Feeds 13 Apr 2016

Share This Page