Reefs.org Forums

[tenshi]

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

[liquid]

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

[tenshi]

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

[BillA]

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

be cool

[Mouse]

Deltec, their me faves!!!!!

[Trigger Me Happy]

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

[Mihai]

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

[liquid]

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

[liquid]

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

[sambo]

How 'bout Panworld/Bluline?

Ditto on the dB ratings. That would be great!

[Dragoon]

Hows about the "SURGE" pumps all the way from the 300 to the 9000. I beleive they are made by aquus.

[Dragoon]

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.

[ReefVan]

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

[Dragoon]

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

[MLVA123]

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...

[liquid]

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

shane

[MickeyStock]

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

[thorilan]

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 )

[liquid]

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

Shane

[sawyerc]

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.