Reefs.org Pump Selection Guide (suggestions/corrections)

A forum where members can share and refine their DIY ideas!

Moderators: Acrylics, seven ephors, Louey, Admins

Postby tenshi » October 31st, 2003, 3:36 pm

I'm having trouble using the spreadsheet and I'm wondering if someone can tell me what I'm doing wrong. Let's say I didn't make any changes to the spreadsheet and used it as it downloaded with Mag 18. When I click the Solve botton the following happens:

    1.)Microsoft Visual Basic - waterpipe-v1.xls[running] opens up with four windows named:

    Compile error:
    can't find project library
    there is also a "ok" and "help" button

    waterpipe-v1.xls - Sheet 7 (Code)
    Private Sub CommandButton1_Click()<(this is highlighted in yellow)
    SolverOk SetCell:="$B$45", MaxMinVal:=2, ValueOf:="0", ByChange:="$B$38"
    SolverSolve
    End Sub

    waterpipe-v1.xls - Module2 (Code)
    Sub Plumb()
    '
    ' Plumb Macro
    ' Macro recorded 5/27/2002 by Sanjay Joshi
    '
    '
    SolverOk SetCell:="$H$9", MaxMinVal:=2, ValueOf:="0", ByChange:="$B$25"
    SolverSolve
    End Sub

    waterpipe-v1.xls - Module6 (Code)
    Sub Reset_Form()
    '
    ' Reset_Form Macro
    ' Macro recorded 12/23/2002 by Shane Graber
    '
    ' Keyboard Shortcut: Ctrl+r
    '
    Range("B38").Select
    ActiveCell.FormulaR1C1 = "0.00000001"
    Range("B19").Select
    End Sub

    2.) I click ok and nothing happens.


Does anyone have any idea what I'm doing wrong?

Tenshi
User avatar
tenshi
Reefkeeper
 
Posts: 157
Joined: August 6th, 2003, 2:23 pm
Location: Houston, TX

Postby liquid » October 31st, 2003, 4:21 pm

1) Are you using MS Excel 2000?
2) Did you install the Solver Add-On?

If yes to both, then instead of clicking the Solve button, click TOOLS - SOLVER and then click the Solve button that's on the popup window that pops up.

Sometimes the Solve button flakes out for whatever reason...

Shane
Shane
__________________________________________________________________
Advanced Aquarist Online Magazine | Marine Aquarist Courses Online
User avatar
liquid
Site Admin
 
Posts: 6425
Joined: January 13th, 2000, 2:01 am
Location: Ohio

Postby tenshi » October 31st, 2003, 6:53 pm

liquid wrote:1) Are you using MS Excel 2000?
2) Did you install the Solver Add-On?


1.) Using MS Excel 2003.
2.) Yes, I installed the Solver Add-On. I read your article all the way through. I loved it! Well not like I want to marry it love, but you get my drift. I'm glad my math years in high school and college didn't go to waste!!

The Solve botton did "Flake", but your suggestion made it work. Thank you for this valuable tool. It's going to make designing my plumbing that much easier. Thanks a million DOC.

Tenshi
User avatar
tenshi
Reefkeeper
 
Posts: 157
Joined: August 6th, 2003, 2:23 pm
Location: Houston, TX

Postby BillA » December 13th, 2003, 11:06 am

for any interested in a 12VDC pump, you might consider adding the Swiftech MCP600

be cool
BillA
Junior Member
 
Posts: 1
Joined: December 13th, 2003, 11:01 am

Postby Mouse » January 28th, 2004, 1:14 pm

Deltec, their me faves!!!!!
N.B. Jack of all trades master of none

i luv the big blue wobbly thing with the whole of my body (including my pee pee)

Holy is to war what fish is to bicycle
User avatar
Mouse
{squat}
 
Posts: 3248
Joined: June 29th, 2001, 1:01 am
Location: London, England

Postby Trigger Me Happy » February 3rd, 2004, 5:25 pm

The spreadsheet is amazing. Thansk for all of your work.

A question and a comment:
1. What is "fluid Power" and how should it be used.

2. It would be great if the sheet also reported the wattage used for each scenerio as this would help to evaluate the efficiency of each scenerio.

Regards,
Todd
Trigger Me Happy
Reefkeeper
 
Posts: 36
Joined: August 10th, 2000, 1:01 am
Location: Fallbrook, CA

Postby Mihai » February 3rd, 2004, 11:39 pm

I second the need for a noise evaluation. It doesn't need to
be exact (like the dB); a fuzzy description would be OK (writing on paper, toilet flush, jumbo jet engine, etc.).

Mihai
Current status: setting up the sump.
User avatar
Mihai
{squat}
 
Posts: 1730
Joined: January 12th, 2004, 7:23 pm
Location: Cary, NC, USA

Postby liquid » February 4th, 2004, 2:37 pm

I'll look into it, but I'm not sure if I'd be able to find all of that info for every pump. The industrial pumps are typically good at providing that data (Iwaki, GRI, etc) but the pumps like Danner (Mag), etc, don't provide dB ratings for their pumps.

Shane
Shane
__________________________________________________________________
Advanced Aquarist Online Magazine | Marine Aquarist Courses Online
User avatar
liquid
Site Admin
 
Posts: 6425
Joined: January 13th, 2000, 2:01 am
Location: Ohio

Postby liquid » February 4th, 2004, 2:39 pm

Oh! I forgot to update our pump page! I've had a web-based calculator installed for over a month now and haven't linked it into the pump page yet. DOH. :(

Web-Based Pump Head Loss Calculator
http://reefs.org/pumps/


This one replaces the Excel spreadsheet!


Enjoy!

Shane
Shane
__________________________________________________________________
Advanced Aquarist Online Magazine | Marine Aquarist Courses Online
User avatar
liquid
Site Admin
 
Posts: 6425
Joined: January 13th, 2000, 2:01 am
Location: Ohio

Postby sambo » February 13th, 2004, 8:02 pm

How 'bout Panworld/Bluline?

Ditto on the dB ratings. That would be great!
Sam I Am
sambo
Reefkeeper
 
Posts: 92
Joined: October 3rd, 2003, 12:58 pm
Location: Michigan

Postby Dragoon » February 23rd, 2004, 6:08 pm

Hows about the "SURGE" pumps all the way from the 300 to the 9000. I beleive they are made by aquus.
Attachments
surge 9000.jpg
surge 9000.jpg (2.27 KiB) Viewed 11013 times
The Patriot Act is just the beginning :cry:

They that can give up essential liberty to obtain a little temporary safety
deserve neither liberty nor safety.
Benjamin Franklin, Historical Review of Pennsylvania, 1759

Keep your friends close and your anemones closer
User avatar
Dragoon
{squat}
 
Posts: 1274
Joined: March 24th, 2003, 8:07 pm
Location: athenosphere

Postby Dragoon » February 25th, 2004, 1:01 am

Hey you guys in there? just checking. By the way the website for the surge pumps is http://www.aquus.net/aquus_main.html Just giving you a little more info on the surges. They aren't bad pumps and aren't priced too bad either.
The Patriot Act is just the beginning :cry:

They that can give up essential liberty to obtain a little temporary safety
deserve neither liberty nor safety.
Benjamin Franklin, Historical Review of Pennsylvania, 1759

Keep your friends close and your anemones closer
User avatar
Dragoon
{squat}
 
Posts: 1274
Joined: March 24th, 2003, 8:07 pm
Location: athenosphere

Postby ReefVan » March 5th, 2004, 8:21 pm

Can you add the new Sequence pumps... ReeFlo Series... Dart, Hammerhead and Stingray...

Use the Valu-Flo pumps, they're basically the pond equivalents without the saltwater seals.

http://www.mdminc.com/Valu_Flo.htm

Van
Last edited by ReefVan on March 15th, 2004, 11:01 pm, edited 1 time in total.
"It's not junk, it's un-assembled DIY"
User avatar
ReefVan
Reefkeeper
 
Posts: 72
Joined: January 12th, 2003, 10:49 pm
Location: Montreal

Postby Dragoon » March 14th, 2004, 1:15 am

Also try Via Aqua pumps.

FEATURES:
VA80 has built in flow adjuster. Discharge is 5/16" OD.

VA302 has built in flow adjuster and includes accessory pack. Discharge is (13mm) 1/2" OD.

VA305 & VA306 have built in flow adjuster and include an accessory pack. Discharge is (18mm) 5/8" OD.

VA360 & VA480 include an adjustable flow valve. Discharge is (13mm) 1/2"OD.

VA1300 includes an adjustable flow valve and has a 3 prong Grounded cord. Discharge is (19mm) 3/4"OD. In-line use with a 1" input.

VA2600, VA3300, VA3600 & VA4900 have a 3 prong Grounded cord. Include an adjustable flow valve and Discharge is (19mm) 3/4"OD. These pumps can also be used in-line (out of water) with a 1" input. These models include an internal sponge filter.

All ViaAqua Pumps are Oil Free and Quiet!

Removable Suction Cups on all models!

All of the ViaAqua Pumps except the VA80 include an accessory pack with about 7 different accessories. These pumps can be used for aquariums, ponds, fountains, hydroponics, etc.





SIZES:

Model Measurements
VA80 1.30"H x 1.65"W x 1.85"L (33mm x 42mm x 47mm)
VA302 1.97"H x 1.77"W x 2.09"L (50mm x 45mm x 53mm)
VA305 3.35"H x 2.13"W x 3.43"L (85mm x 54mm x 87mm)
VA306 3.74"H x 2.76"W x 3.82"L (95mm x 70mm x 97mm)
VA360 2.17"H x 1.77"W x 2.21"L (55mm x 45mm x 56mm)
VA480 2.52"H x 1.89"W x 3.03"L (64mm x 48mm x 77mm)
VA1300 2.80"H x 2.32"W x 4.45"L (71mm x 59mm x 113mm)
VA2600 3.82"H x 2.91"W x 6.10"L (97mm x 74mm x 155mm)
VA3300 3.82"H x 2.91"W x 6.10"L (97mm x 74mm x 155mm)
VA3600 4.05"H x 3.11"W x 6.46"L (103mm x 79mm x 164mm)
VA4900 4.05"H x 3.11"W x 6.46"L (103mm x 79mm x 164mm)



FLOW TABLE:

Look at the Watts... Low wattage means Low Electric Bills.

These are some of the most economical pumps on the market.

Model/Watts/MaxFlow/MaxHead/0'/1'/2'/3'/4'/5'/6'/7'/8'/9/10'/11'
VA80 2.7 79 1' / 79 _ _ _ _ _ _ _ _ _ _ _
VA302 6 130 2' / 130 60 12 _ _ _ _ _ _ _ _ _
VA305 18 315 5' / 315 264 171 132 79 38 _ _ _ _ _ _ VA306 35 526 6' / 526 486 439 360 305 165 97 _ _ _ _ _
VA360 6.7 152 3' / 152 95 48 _ _ _ _ _ _ _ _ _
VA480 8.6 200 4' / 200 127 84 34 _ _ _ _ _ _ _ _
VA1300 20.5 370 6' / 370 349 317 254 190 119 79 _ _ _ _ _
VA2600 46 740 7' / 740 634 539 476 349 254 132 34 _ _ _ _
VA3300 80 977 10' /977 888 761 697 614 471 406 360 290 180 117 98
VA3600 80 1057 11' /1057 925 824 729 634 507 444 396 321 222 152 102
VA4900 122 1321 12' /1321 1268 1173 1017 951 824 761 740 729 660 581 539
The Patriot Act is just the beginning :cry:

They that can give up essential liberty to obtain a little temporary safety
deserve neither liberty nor safety.
Benjamin Franklin, Historical Review of Pennsylvania, 1759

Keep your friends close and your anemones closer
User avatar
Dragoon
{squat}
 
Posts: 1274
Joined: March 24th, 2003, 8:07 pm
Location: athenosphere

Postby MLVA123 » April 16th, 2004, 8:28 am

I heard that custom sea life went under - don't know what is going to happen to the velocity pump line, but I'm sure some company will pick it up... I heard a rumor about some company called "currents" or some such...
"If I had only known, I would have been a locksmith." - Albert Einstein
User avatar
MLVA123
Reefkeeper
 
Posts: 77
Joined: August 3rd, 2003, 12:59 pm
Location: Richmond, VA

Postby liquid » April 16th, 2004, 8:54 am

I'll see what I can do to get these added.

shane
Shane
__________________________________________________________________
Advanced Aquarist Online Magazine | Marine Aquarist Courses Online
User avatar
liquid
Site Admin
 
Posts: 6425
Joined: January 13th, 2000, 2:01 am
Location: Ohio

Postby MickeyStock » April 17th, 2004, 12:27 pm

First of all I just want to say thank you. The pump selection guide and also the spreadsheet have been invaluable to me in planning my new tank upgrade.

Now a request, is it possible to update the Sequence pumps to their current models in the spreadsheet, or at least add the one I'm planning on - 4300SEQ12. I'd really appreciate it. I tried figuring it out myself but I'm not sure where the values on the worksheet came from and where they relate on the pump curve.

Thanks again for a great tool.

Mickey
MickeyStock
Reefkeeper
 
Posts: 66
Joined: September 30th, 2001, 1:01 am
Location: Cheshire, CT

Postby thorilan » May 20th, 2004, 12:58 am

would it be possible to get the L series of hydor pumps in your evolving pump info page ( which has some great info btw)

mainly the L20 L30 and L35 ( the L35 is new and i might be the only non comercial person to have one so far not sure if they where released yet to public )
thorilan
Junior Member
 
Posts: 1
Joined: May 20th, 2004, 12:55 am

Postby liquid » May 20th, 2004, 8:24 am

thorilan: Do you have a link to any info on these pumps? I am unfamiliar w/ them.

Shane
Shane
__________________________________________________________________
Advanced Aquarist Online Magazine | Marine Aquarist Courses Online
User avatar
liquid
Site Admin
 
Posts: 6425
Joined: January 13th, 2000, 2:01 am
Location: Ohio

Postby sawyerc » June 30th, 2004, 3:35 pm

The pump guide is awesome. A thousand thanks. I noticed that some of the pumps have watts as N/A but list the amperage (iwakis for example). Unless I am mistaken you can multiply the amperage by the voltage (I'm assuming it's about 120) to find the wattage. Is this correct. If so, you might want to add the wattage the iwaki line for those who are not mathematically inclined. Thanks again. Happy reefing.
sawyerc
Reefkeeper
 
Posts: 158
Joined: June 18th, 2004, 10:31 am
Location: New Hampshire

PreviousNext

Return to DIY: Do It Yourself

Who is online

Users browsing this forum: No registered users and 1 guest