Calculations for an air lift assembly – Best excel sheet in the internet
There are two major sections to this spreadsheet. They fill two different niches. 1. on the left figures from a known, desired gal/day number. 2. On the right will calculate the maximum capacity for a given scenario. There are a lot of variables that might lower that maximum. This is a theoretical maximum. It will not be grossly in error. My test demonstrated a flow of 30 gal/min and the calculator said it would be 33 gal/min
I have entered my basic pumping needs in the calculators.
The bottom, yellow cells show the CFM and the pressure needed to overcome the head. An air pump would need to match this and not be at its maximum, and therefore, limit that would make it prone to failure.
The convention I follow is to enter data in green cells and the formulas are completed in other colored cells.
If you enter a set of data where the air lift assembly will not work, there will be odd characters appear within the calculations. If this occurs, change the sizes or gallons to tweak your desired assembly. For instance, if a 2″ pipe will not work, then try a 3″ and see if the formulas complete properly.
This spreadsheet is built off other persons’ work . It must not be distributed for profit. It is for education and design purposes only. I built the calculator on the right based on formulas found on an engineer ing site for air lift assemblies.
Please give proper attribution.
The calculator on the right is adapted from one found on http://www.airliftpump.com/ap_calc.htm by Dr. Sam Kondo, Ph.D. who is expressing the formulas from:
to download the excel sheet click here