Spreadsheet: 142267d1329759939-how-to-create-a-formula-based-on-excel-data-already-inputed-3-inch-riser-tube-all-submergences
Sheet: Sheet1

3" Airlift Riser Tube w/ Complete Submergence @ 44" |  |  |  |  |  |  |  |  |  |  | LPM Water Flow w/ Complete Submergence @ 44" |  |  |  | 1" Lift | 2" Lift | 3" Lift | 4" Lift | 5" Lift | 6" Lift
 | GPM @ | GPM @ | GPM @ | GPM @ | GPM @ | GPM @ |  | LPM @ | LPM @ | LPM @ | LPM @ | LPM @ | LPM @ |  | LPM H2O | LPM H2O | LPM H2O | LPM H2O | LPM H2O | LPM H2O
Air Supply | 1" Lift | 2" Lift | 3" Lift | 4" Lift | 5" Lift | 6" Lift |  | 1" Lift | 2" Lift | 3" Lift | 4" Lift | 5" Lift | 6" Lift |  | LPM Air | LPM Air | LPM Air | LPM Air | LPM Air | LPM Air
20 | 45 | 32 | 20 | ? | ? | ? |  | 170.55 | 121.28 | 75.8 | 0 | 0 | 0 |  | 8.5275 | 6.064 | 3.79 | 0 | 0 | 0
22.5 | 49 | 38 | 26 | 15 | ? | ? |  | 185.71 | 144.02 | 98.54 | 56.85 | 0 | 0 |  | 8.253777777777778 | 6.40088888888889 | 4.379555555555556 | 2.526666666666667 | 0 | 0
25 | 52 | 41 | 31 | 26 | 13 | ? |  | 197.08 | 155.39 | 117.49 | 98.54 | 49.27 | 0 |  | 7.8832 | 6.2156 | 4.6996 | 3.9416 | 1.9708 | 0
27.5 | 56 | 45 | 37 | 30 | 21 | 14 |  | 212.24 | 170.55 | 140.23 | 113.7 | 79.59 | 53.06 |  | 7.717818181818182 | 6.201818181818182 | 5.099272727272727 | 4.134545454545455 | 2.894181818181818 | 1.929454545454546
30 | 59 | 48 | 40 | 34 | 28 | 20 |  | 223.61 | 181.92 | 151.6 | 128.86 | 106.12 | 75.8 |  | 7.453666666666667 | 6.064000000000001 | 5.053333333333333 | 4.295333333333334 | 3.537333333333334 | 2.526666666666666
32.5 | 61 | 53 | 43 | 37 | 31 | 23 |  | 231.19 | 200.87 | 162.97 | 140.23 | 117.49 | 87.17 |  | 7.113538461538462 | 6.180615384615384 | 5.014461538461538 | 4.31476923076923 | 3.615076923076923 | 2.682153846153846
35 | 64 | 55 | 47 | 40 | 35 | 27 |  | 242.56 | 208.45 | 178.13 | 151.6 | 132.65 | 102.33 |  | 6.930285714285715 | 5.955714285714286 | 5.089428571428571 | 4.331428571428571 | 3.79 | 2.923714285714285
37.5 | 65 | 57 | 50 | 43 | 36 | 30 |  | 246.35 | 216.03 | 189.5 | 162.97 | 136.44 | 113.7 |  | 6.569333333333333 | 5.7608 | 5.053333333333334 | 4.345866666666667 | 3.6384 | 3.032
40 | 67 | 58 | 52 | 45 | 39 | 33 |  | 253.93 | 219.82 | 197.08 | 170.55 | 147.81 | 125.07 |  | 6.34825 | 5.4955 | 4.927 | 4.26375 | 3.69525 | 3.12675
42.5 | 69 | 60 | 53 | 47 | 41 | 34 |  | 261.51 | 227.4 | 200.87 | 178.13 | 155.39 | 128.86 |  | 6.153176470588235 | 5.350588235294118 | 4.72635294117647 | 4.191294117647058 | 3.656235294117647 | 3.032
45 | 71 | 61 | 54 | 49 | 43 | 36 |  | 269.09 | 231.19 | 204.66 | 185.71 | 162.97 | Average Efficiency |  | 7.295054660600838 | 5.968952497633086 | 4.783233800056154 | 3.634525404105698 | 2.679727736870972 | 1.925273934398934
3" Airlift Riser Tube w/ Complete Submergence @ 50" |  |  |  |  |  |  |  |  |  |  | LPM Water Flow w/ Complete Submergence @ 50" |  |  |  | 1" Lift | 2" Lift | 3" Lift | 4" Lift | 5" Lift | 6" Lift
 | GPM @ | GPM @ | GPM @ | GPM @ | GPM @ | GPM @ |  | LPM @ | LPM @ | LPM @ | LPM @ | LPM @ | LPM @ |  | LPM H2O | LPM H2O | LPM H2O | LPM H2O | LPM H2O | LPM H2O
Air Supply | 1" Lift | 2" Lift | 3" Lift | 4" Lift | 5" Lift | 6" Lift |  | 1" Lift | 2" Lift | 3" Lift | 4" Lift | 5" Lift | 6" Lift |  | LPM Air | LPM Air | LPM Air | LPM Air | LPM Air | LPM Air
20 | 48 | 36 | 28 | 16 | ? | ? |  | 181.92 | 136.44 | 106.12 | 60.64 | 0 | 0 |  | 9.096 | 6.822 | 5.306 | 3.032 | 0 | 0
22.5 | 52 | 38 | 32 | 26 | 15 | ? |  | 197.08 | 144.02 | 121.28 | 98.54 | 56.85 | 0 |  | 8.759111111111112 | 6.40088888888889 | 5.390222222222222 | 4.379555555555556 | 2.526666666666667 | 0
25 | 55 | 46 | 36 | 29 | 24 | ? |  | 208.45 | 174.34 | 136.44 | 109.91 | 90.96000000000001 | 0 |  | 8.338 | 6.9736 | 5.4576 | 4.3964 | 3.6384 | 0
27.5 | 57 | 48 | 40 | 33 | 29 | ? |  | 216.03 | 181.92 | 151.6 | 125.07 | 109.91 | 0 |  | 7.855636363636363 | 6.615272727272727 | 5.512727272727273 | 4.548 | 3.996727272727273 | 0
30 | 61 | 53 | 44 | 38 | 31 | 25 |  | 231.19 | 200.87 | 166.76 | 144.02 | 117.49 | 94.75 |  | 7.706333333333333 | 6.695666666666667 | 5.558666666666666 | 4.800666666666667 | 3.916333333333333 | 3.158333333333333
32.5 | 64 | 55 | 47 | 40 | 3 | 29 |  | 242.56 | 208.45 | 178.13 | 151.6 | 11.37 | 109.91 |  | 7.463384615384616 | 6.413846153846153 | 5.480923076923077 | 4.664615384615384 | 0.3498461538461539 | 3.381846153846154
35 | 66 | 58 | 50 | 43 | 38 | 32 |  | 250.14 | 219.82 | 189.5 | 162.97 | 144.02 | 121.28 |  | 7.146857142857144 | 6.280571428571428 | 5.414285714285715 | 4.656285714285715 | 4.114857142857143 | 3.465142857142857
37.5 | 67 | 59 | 53 | 47 | 40 | 34 |  | 253.93 | 223.61 | 200.87 | 178.13 | 151.6 | 128.86 |  | 6.771466666666667 | 5.962933333333334 | 5.356533333333333 | 4.750133333333333 | 4.042666666666666 | 3.436266666666667
40 | 68 | 61 | 55 | 49 | 43 | 36 |  | 257.72 | 231.19 | 208.45 | 185.71 | 162.97 | 136.44 |  | 6.443000000000001 | 5.77975 | 5.21125 | 4.64275 | 4.07425 | 3.411
42.5 | 70 | 63 | 57 | 50 | 45 | 38 |  | 265.3 | 238.77 | 216.03 | 189.5 | 170.55 | 144.02 |  | 6.24235294117647 | 5.618117647058824 | 5.083058823529412 | 4.458823529411765 | 4.012941176470589 | 3.388705882352941
 |  |  |  |  |  |  |  |  |  |  |  |  | Average Efficiency |  | 7.582214217416572 | 6.356264684563802 | 5.377126710968769 | 4.432923018386842 | 3.067268841256782 | 2.024129489334195
3" Airlift Riser Tube w/ Complete Submergence @ 56" |  |  |  |  |  |  |  |  |  |  | LPM Water Flow w/ Complete Submergence @ 56" |  |  |  | 1" Lift | 2" Lift | 3" Lift | 4" Lift | 5" Lift | 6" Lift
 | GPM @ | GPM @ | GPM @ | GPM @ | GPM @ | GPM @ |  | LPM @ | LPM @ | LPM @ | LPM @ | LPM @ | LPM @ |  | LPM H2O | LPM H2O | LPM H2O | LPM H2O | LPM H2O | LPM H2O
Air Supply | 1" Lift | 2" Lift | 3" Lift | 4" Lift | 5" Lift | 6" Lift |  | 1" Lift | 2" Lift | 3" Lift | 4" Lift | 5" Lift | 6" Lift |  | LPM Air | LPM Air | LPM Air | LPM Air | LPM Air | LPM Air
20 | 49 | 39 | 30 | 20 | ? | ? |  | 185.71 | 147.81 | 113.7 | 75.8 | 0 | 0 |  | 9.2855 | 7.3905 | 5.685 | 3.79 | 0 | 0
22.5 | 53 | 43 | 34 | 27 | 15 | ? |  | 200.87 | 162.97 | 128.86 | 102.33 | 56.85 | 0 |  | 8.927555555555555 | 7.243111111111111 | 5.727111111111112 | 4.548 | 2.526666666666667 | 0
25 | 57 | 48 | 39 | 32 | 24 | ? |  | 216.03 | 181.92 | 147.81 | 121.28 | 90.96000000000001 | 0 |  | 8.6412 | 7.276800000000001 | 5.9124 | 4.8512 | 3.6384 | 0
27.5 | 60 | 52 | 44 | 37 | 30 | 20 |  | 227.4 | 197.08 | 166.76 | 140.23 | 113.7 | 75.8 |  | 8.26909090909091 | 7.166545454545455 | 6.064 | 5.099272727272727 | 4.134545454545455 | 2.756363636363636
30 | 62 | 55 | 47 | 40 | 33 | 27 |  | 234.98 | 208.45 | 178.13 | 151.6 | 125.07 | 102.33 |  | 7.832666666666666 | 6.948333333333333 | 5.937666666666667 | 5.053333333333333 | 4.169 | 3.411
32.5 | 65 | 57 | 50 | 43 | 37 | 31 |  | 246.35 | 216.03 | 189.5 | 162.97 | 140.23 | 117.49 |  | 7.58 | 6.647076923076924 | 5.83076923076923 | 5.014461538461538 | 4.31476923076923 | 3.615076923076923
35 | 66 | 58 | 51 | 47 | 40 | 35 |  | 250.14 | 219.82 | 193.29 | 178.13 | 151.6 | 132.65 |  | 7.146857142857144 | 6.280571428571428 | 5.522571428571428 | 5.089428571428571 | 4.331428571428571 | 3.79
37.5 | 69 | 62 | 55 | 49 | 44 | 37 |  | 261.51 | 234.98 | 208.45 | 185.71 | 166.76 | 140.23 |  | 6.973599999999999 | 6.266133333333333 | 5.558666666666666 | 4.952266666666667 | 4.446933333333333 | 3.739466666666666
40 | 70 | 63 | 57 | 52 | 46 | 39 |  | 265.3 | 238.77 | 216.03 | 197.08 | 174.34 | 147.81 |  | 6.6325 | 5.969250000000001 | 5.40075 | 4.927 | 4.3585 | 3.69525
42.5 | 72 | 65 | 58 | 53 | 47 | 42 |  | 272.88 | 246.35 | 219.82 | 200.87 | 178.13 | 159.18 |  | 6.420705882352941 | 5.796470588235294 | 5.172235294117647 | 4.72635294117647 | 4.191294117647058 | 3.745411764705882
 |  |  |  |  |  |  |  |  |  |  |  |  | Average Efficiency |  | 7.770967615652322 | 6.698479217220688 | 5.681117039790275 | 4.805131577833931 | 3.611153737439031 | 2.475256899081311
3" Airlift Riser Tube w/ Complete Submergence @ 62" |  |  |  |  |  |  |  |  |  |  | LPM Water Flow w/ Complete Submergence @ 62" |  |  |  | 1" Lift | 2" Lift | 3" Lift | 4" Lift | 5" Lift | 6" Lift | 7" Lift
 | GPM @ | GPM @ | GPM @ | GPM @ | GPM @ | GPM @ | GPM @ | LPM @ | LPM @ | LPM @ | LPM @ | LPM @ | LPM @ | LPM @ | LPM H2O | LPM H2O | LPM H2O | LPM H2O | LPM H2O | LPM H2O | LPM H2O
Air Supply | 1" Lift | 2" Lift | 3" Lift | 4" Lift | 5" Lift | 6" Lift | 7" Lift | 1" Lift | 2" Lift | 3" Lift | 4" Lift | 5" Lift | 6" Lift | 7" Lift | LPM Air | LPM Air | LPM Air | LPM Air | LPM Air | LPM Air | LPM Air
20 | 46 | 37 | 31 | 23 | ? | ? | ? | 174.34 | 140.23 | 117.49 | 87.17 | 0 | 0 | 0 | 8.717 | 7.0115 | 5.874499999999999 | 4.3585 | 0 | 0 | 0
22.5 | 51 | 42 | 35 | 27 | 15 | ? | ? | 193.29 | 159.18 | 132.65 | 102.33 | 56.85 | 0 | 0 | 8.590666666666666 | 7.074666666666667 | 5.895555555555556 | 4.548 | 2.526666666666667 | 0 | 0
25 | 55 | 47 | 39 | 33 | 22 | 14 | ? | 208.45 | 178.13 | 147.81 | 125.07 | 83.38 | 53.06 | 0 | 8.338 | 7.1252 | 5.9124 | 5.002800000000001 | 3.3352 | 2.1224 | 0
27.5 | 58 | 50 | 45 | 38 | 30 | 20 | 16 | 219.82 | 189.5 | 170.55 | 144.02 | 113.7 | 75.8 | 60.64 | 7.993454545454545 | 6.890909090909091 | 6.201818181818182 | 5.237090909090909 | 4.134545454545455 | 2.756363636363636 | 2.205090909090909
30 | 61 | 54 | 49 | 42 | 36 | 29 | 21 | 231.19 | 204.66 | 185.71 | 159.18 | 136.44 | 109.91 | 79.59 | 7.706333333333333 | 6.822 | 6.190333333333333 | 5.306 | 4.548 | 3.663666666666666 | 2.653
32.5 | 63 | 57 | 51 | 45 | 39 | 34 | 26 | 238.77 | 216.03 | 193.29 | 170.55 | 147.81 | 128.86 | 98.54 | 7.346769230769231 | 6.647076923076924 | 5.947384615384615 | 5.247692307692308 | 4.548 | 3.964923076923077 | 3.032
35 | 66 | 60 | 55 | 48 | 43 | 36 | 30 | 250.14 | 227.4 | 208.45 | 181.92 | 162.97 | 136.44 | 113.7 | 7.146857142857144 | 6.497142857142857 | 5.955714285714286 | 5.197714285714286 | 4.656285714285715 | 3.898285714285714 | 3.248571428571429
37.5 | 68 | 62 | 57 | 51 | 45 | 38 | 33 | 257.72 | 234.98 | 216.03 | 193.29 | 170.55 | 144.02 | 125.07 | 6.872533333333334 | 6.266133333333333 | 5.7608 | 5.1544 | 4.548 | 3.840533333333334 | 3.3352
40 | 70 | 64 | 59 | 54 | 48 | 39 | 36 | 265.3 | 242.56 | 223.61 | 204.66 | 181.92 | 147.81 | 136.44 | 6.6325 | 6.064 | 5.59025 | 5.1165 | 4.548 | 3.69525 | 3.411
42.5 | 72 | 65 | 60 | 56 | 49 | 40 | 39 | 272.88 | 246.35 | 227.4 | 212.24 | 185.71 | 151.6 | 147.81 | 6.420705882352941 | 5.796470588235294 | 5.350588235294118 | 4.993882352941177 | 4.36964705882353 | 3.567058823529412 | 3.477882352941176
45 | 73 | 67 | 62 | 57 | 52 | 43 | 42 | 276.67 | 253.93 | 234.98 | 216.03 | 197.08 | 162.97 | 159.18 | 6.148222222222222 | 5.642888888888889 | 5.221777777777778 | 4.800666666666666 | 4.379555555555556 | 3.621555555555556 | 3.537333333333334
 |  |  |  |  |  |  |  |  |  |  |  |  | Average Efficiency |  | 7.446640214271766 | 6.53072621347755 | 5.80919290771617 | 4.99665877473685 | 3.781263677261539 | 2.830003346059763 | 2.263643456721531
3" Airlift Riser Tube w/ Complete Submergence @ 68" |  |  |  |  |  |  |  |  |  |  | LPM Water Flow w/ Complete Submergence @ 68" |  |  |  | 1" Lift | 2" Lift | 3" Lift | 4" Lift | 5" Lift | 6" Lift | 7" Lift
 | GPM @ | GPM @ | GPM @ | GPM @ | GPM @ | GPM @ | GPM @ | LPM @ | LPM @ | LPM @ | LPM @ | LPM @ | LPM @ | LPM @ | LPM H2O | LPM H2O | LPM H2O | LPM H2O | LPM H2O | LPM H2O | LPM H2O
Air Supply | 1" Lift | 2" Lift | 3" Lift | 4" Lift | 5" Lift | 6" Lift | 7" Lift | 1" Lift | 2" Lift | 3" Lift | 4" Lift | 5" Lift | 6" Lift | 7" Lift | LPM Air | LPM Air | LPM Air | LPM Air | LPM Air | LPM Air | LPM Air
20 | 52 | 45 | 38 | 30 | 23 | ? | ? | 197.08 | 170.55 | 144.02 | 113.7 | 87.17 | 0 | 0 | 9.854000000000001 | 8.5275 | 7.201000000000001 | 5.685 | 4.3585 | 0 | 0
22.5 | 57 | 49 | 41 | 35 | 28 | 18 | ? | 216.03 | 185.71 | 155.39 | 132.65 | 106.12 | 68.22 | 0 | 9.601333333333333 | 8.253777777777778 | 6.906222222222222 | 5.895555555555556 | 4.716444444444445 | 3.032 | 0
25 | 61 | 54 | 47 | 39 | 33 | 28 | 22 | 231.19 | 204.66 | 178.13 | 147.81 | 125.07 | 106.12 | 83.38 | 9.2476 | 8.186399999999999 | 7.1252 | 5.9124 | 5.002800000000001 | 4.244800000000001 | 3.3352
27.5 | 63 | 56 | 50 | 44 | 36 | 31 | 27 | 238.77 | 212.24 | 189.5 | 166.76 | 136.44 | 117.49 | 102.33 | 8.682545454545455 | 7.717818181818182 | 6.890909090909091 | 6.064 | 4.961454545454545 | 4.272363636363636 | 3.721090909090909
30 | 66 | 59 | 54 | 47 | 41 | 35 | 32 | 250.14 | 223.61 | 204.66 | 178.13 | 155.39 | 132.65 | 121.28 | 8.338000000000001 | 7.453666666666667 | 6.822 | 5.937666666666667 | 5.179666666666667 | 4.421666666666667 | 4.042666666666666
32.5 | 69 | 62 | 56 | 50 | 45 | 38 | 35 | 261.51 | 234.98 | 212.24 | 189.5 | 170.55 | 144.02 | 132.65 | 8.046461538461537 | 7.230153846153846 | 6.530461538461538 | 5.83076923076923 | 5.247692307692308 | 4.431384615384616 | 4.081538461538462
35 | 71 | 64 | 59 | 52 | 48 | 41 | 38 | 269.09 | 242.56 | 223.61 | 197.08 | 181.92 | 155.39 | 144.02 | 7.688285714285714 | 6.930285714285715 | 6.388857142857144 | 5.630857142857143 | 5.197714285714286 | 4.439714285714286 | 4.114857142857143
37.5 | 72 | 66 | 61 | 55 | 50 | 45 | 39 | 272.88 | 250.14 | 231.19 | 208.45 | 189.5 | 170.55 | 147.81 | 7.2768 | 6.670400000000001 | 6.165066666666666 | 5.558666666666666 | 5.053333333333334 | 4.548 | 3.9416
40 | 74 | 67 | 62 | 57 | 52 | 48 | 42 | 280.46 | 253.93 | 234.98 | 216.03 | 197.08 | 181.92 | 159.18 | 7.0115 | 6.34825 | 5.874499999999999 | 5.40075 | 4.927 | 4.548 | 3.9795
42.5
45
 |  |  |  |  |  |  |  |  |  |  |  |  | Average Efficiency |  | 8.41628067118067 | 7.479805798522467 | 6.656024073457406 | 5.768407251390585 | 4.960511731478398 | 3.770881022681023 | 3.024050353350354