The links to download the spreadsheets are in the third post of this topic, back on the first page.

WOW WOW WOW WOW WOW!

I am glad to have met you mark! Exactly what I was looking for!!! Thanks for all the time you spend developing those excel sheets.... I plotted rpm vs psi for my pump and saw how time consuming it was to get the data!

Really appreciate your hard work!

Thanks Thanks Thanks Thanks!

Thanks! That makes it worth all the work I put in to it. Let me know if you have any questions and/or suggestions.

Thank you. the Hydraulics 101 spreadsheet is incredible. I really appreciate all the work involved in putting it together.

Call me crazy, but I can not find the links to the spreadsheets. I see some of the posts were edited last month ... were the spreadsheets removed?

I have a lot of questions about my current set up and what I would like to change, but was hoping to do a little investigating/calculating before creating the post.

Thanks,
Jason

No, are aren't going crazy and I should have posted a more detailed explanation so here it is:

There were a couple of reasons that I removed the spreadsheet. The most disturbing to me was that I found web sites that were posting the spreadsheet without giving any credit to TFP or myself. Plus, I didn't want a commercial company to benefit from my work without compensation.
I had no problem with true pool owners, especially those that have contributed to TFP, using it for there own benefit.

However, the second problem I found was with the watts to GPM estimates. The curve fitting was based upon the CEC data when I inverted the curve to determine GPM from watts, a very small error in watts resulted in a very large error in GPM so the actual watts measurement turned out to be important. Several users of the model had discovered issues with the results at low RPM and I had many questions coming my way on how to properly use the model to get a reasonable answer. So I ended up performing a more detailed analysis using my full hydraulics and I found that it took much less of my time to perform the analysis in the first place than it was to "teach" others. Plus it allows me to get more insight into other plumbing systems/configurations so it really benefits me to further hone the models.

Plus not all that many folks are truly interested in getting the operating points to the plumbing system and for those who are only interested in a rough estimate to their variable speed pumps, I do have some approximations listed in the beginning section of this thread.

In the future I may post the spreadsheet again, but next time will be limited to TFP contributors only and I will track downloads much better.

So the bottom line is if you can give the as much detail about your system, I can then give you the best answer I can for the operating point of the pump. As a minimum, I ususally ask the following:

Pump Make/Model
Filter Type and backwash valve model if known
Filter PSI reading at the desired valve settings and pump full speed.
Optional: Pump suction reading (in-hg) - not necessary but improves accuracy
Heater - yes or no
Pool/Spa valve - yes or no

Suction side plumbing system description: # runs pool to equipment, pipe size
Return side plumbing system description: # runs pool to equipment, pipe size, number eyeballs, and eyeball diameter

Also, note that once you have the plumbing curve for your plumbing, that same curve can be used for any pump head curve to get the operating point. This is useful when deciding on a new pump.

Ok, thanks for clearing that up. Like I said, I have a lot of questions about my current capabilities and the possibility of being able to add the solar system I want. I had you in mind to hopefully answer them based on these extensive posts Rather than contacting you directly, I will create a new thread so other members possible benefits in the next few days.

I am already picturing a VERY long post to get all the information covered and not looking forward to writing it

Really bummed you pulled this. I was kind of excited about getting a simple "rule of thumb" kind of number for my pump. I loved the idea of wattage / gpm.

The problem was that it was not very accurate using wattage as an input so people were getting some pretty wild answers. I found that the more accurate method is to start with details about the plumbing and filter pressure and work it out from there. If you are interested in getting some help working this out, please start a new thread.