Spreadsheet: 820152d1677881942-index-and-match-function-or-any-other-way-calculation-table
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Pipe diameter
 |  |  |  |  |  |  |  |  | Pressure loss mhd/m | 15 | 22 | 28 | 35
 |  | Flow rate KG/S | Pipe diameter in MM | Pressure loss mhd/m | Flow rate KG/S | Pipe diameter in MM | Pressure loss mhd/m |  | 0.001 | 0.01 | 0.025 | 0.08
 |  | 0.06547619047619048 | 15 |  | 0.065 | 15 | 0.001 |  | 0.002 | 0.015 | 0.045 | 0.1
 |  | 0.119047619047619 | 22 |  | 0.065 | 15 | 0.002 |  | 0.003 | 0.02 | 0.06 | 0.12
 |  | 0.1696428571428572 | 22 |  | 0.065 | 15 | 0.003 |  | 0.004 | 0.025 | 0.07 | 0.14
 |  | 0.1994047619047619 | 28 |  | 0.032 | 15 | 0.001 |  | 0.005 | 0.027 | 0.08 | 0.16
 |  | 0.2648809523809524 | 28 |  | 0.032 | 15 | 0.002 |  | 0.006 | 0.03 | 0.09 | 0.18
 |  | 0.032 | 15 |  | 0.032 | 15 | 0.003 |  | 0.007 | 0.035 | 0.1 | 0.2
 |  | 0.336 | 28 |  | 0.119 | 22 | 0.001 |  | 0.008 | 0.038 | 0.109 | 0.227 | 0.4
 |  |  |  |  | 0.119 | 22 | 0.002 |  | 0.009 | 0.04 | 0.117 | 0.235 | 0.424
 |  |  |  |  | 0.119 | 22 | 0.003 |  | 0.01 | 0.042 | 0.124 | 0.25 | 0.448
 |  |  |  |  | 0.17 | 22 | 0.001 |  | 0.011 | 0.044 | 0.131 | 0.263 | 0.475
 |  |  |  |  | 0.17 | 22 | 0.002 |  | 0.012 | 0.047 | 0.137 | 0.277 | 0.499
 |  |  |  |  | 0.17 | 22 | 0.003 |  | 0.013 | 0.049 | 0.144 | 0.289 | 0.523
 |  |  |  |  | 0.199 | 28 | 0.001 |  | 0.014 | 0.052 | 0.15 | 0.302 | 0.543
 |  |  |  |  | 0.199 | 28 | 0.002 |  | 0.015 | 0.054 | 0.156 | 0.314 | 0.564
 |  |  |  |  | 0.265 | 28 | 0.001 |  | 0.016 | 0.056 | 0.161 | 0.325 | 0.594
 |  |  |  |  | 0.265 | 28 | 0.002 |  | 0.017 | 0.058 | 0.167 | 0.336 | 0.604
 |  |  |  |  | 0.336 | 28 | 0.001 |  | 0.018 | 0.06 | 0.172 | 0.348 | 0.623
 |  |  |  |  | 0.336 | 28 | 0.002 |  | 0.019 | 0.061 | 0.178 | 0.359 | 0.645
 |  |  |  |  | 0.199 | 28 | 0.003 |  | 0.02 | 0.063 | 0.183 | 0.369 | 0.669
 |  |  |  |  | 0.265 | 28 | 0.003 |  | 0.021 | 0.065 | 0.188 | 0.38 | 0.686
 |  |  |  |  | 0.336 | 28 | 0.003 |  | 0.022 | 0.067 | 0.193 | 0.39 | 0.704
 |  |  |  |  | 0.065 | 15 | 0.004 |  | 0.024 | 0.07 | 0.203 | 0.408 | 0.735
 |  |  |  |  | 0.032 | 15 | 0.004 |  | 0.026 | 0.073 | 0.212 | 0.428 | 0.773
 |  |  |  |  | 0.119 | 22 | 0.004 |  | 0.028 | 0.076 | 0.221 | 0.446 | 0.805
 |  |  |  |  | 0.17 | 22 | 0.004 |  | 0.03 | 0.08 | 0.23 | 0.464 | 0.838
 |  |  |  |  | 0.199 | 28 | 0.004 |  | 0.032 | 0.082 | 0.238 | 0.482 | 0.869
 |  |  |  |  | 0.265 | 28 | 0.004 |  | 0.034 | 0.085 | 0.247 | 0.5 | 0.898
 |  |  |  |  | 0.336 | 28 | 0.004 |  | 0.036 | 0.088 | 0.255 | 0.518 | 0.925
 |  |  |  |  | 0.065 | 15 | 0.005 |  | 0.038 | 0.091 | 0.263 | 0.533 | 0.952
 |  |  |  |  | 0.032 | 15 | 0.005 |  | 0.04 | 0.094 | 0.27 | 0.548 | 0.982
 |  |  |  |  | 0.119 | 22 | 0.005 |  | 0.042 | 0.096 | 0.278 | 0.564 | 1.01
 |  |  |  |  | 0.17 | 22 | 0.005 |  | 0.044 | 0.099 | 0.286 | 0.578 | 1.035
 |  |  |  |  | 0.199 | 28 | 0.005 |  | 0.046 | 0.101 | 0.293 | 0.592 | 1.048
 |  |  |  |  | 0.265 | 28 | 0.005 |  | 0.048 | 0.104 | 0.3 | 0.608 | 1.075
 |  |  |  |  | 0.336 | 28 | 0.005
 |  |  |  |  | 0.065 | 15 | 0.006
 |  |  |  |  | 0.032 | 15 | 0.006
 |  |  |  |  | 0.119 | 22 | 0.006
 |  |  |  |  | 0.17 | 22 | 0.006
 |  |  |  |  | 0.199 | 28 | 0.006
 |  |  |  |  | 0.265 | 28 | 0.006
 |  |  |  |  | 0.336 | 28 | 0.006
 |  |  |  |  | 0.065 | 15 | 0.007
 |  |  |  |  | 0.032 | 15 | 0.007
 |  |  |  |  | 0.119 | 22 | 0.007
 |  |  |  |  | 0.17 | 22 | 0.007
 |  |  |  |  | 0.199 | 28 | 0.007
 |  |  |  |  | 0.265 | 28 | 0.007
 |  |  |  |  | 0.336 | 28 | 0.007
 |  |  |  |  | 0.065 | 15 | 0.008
 |  |  |  |  | 0.032 | 15 | 0.008
 |  |  |  |  | 0.119 | 22 | 0.008
 |  |  |  |  | 0.17 | 22 | 0.008
 |  |  |  |  | 0.199 | 28 | 0.008
 |  |  |  |  | 0.265 | 28 | 0.008
 |  |  |  |  | 0.336 | 28 | 0.008
 |  |  |  |  | 0.065 | 15 | 0.009
 |  |  |  |  | 0.032 | 15 | 0.009
 |  |  |  |  | 0.119 | 22 | 0.009
 |  |  |  |  | 0.17 | 22 | 0.009
 |  |  |  |  | 0.199 | 28 | 0.009
 |  |  |  |  | 0.265 | 28 | 0.009
 |  |  |  |  | 0.336 | 28 | 0.009
 |  |  |  |  | 0.065 | 15 | 0.01
 |  |  |  |  | 0.032 | 15 | 0.01
 |  |  |  |  | 0.119 | 22 | 0.01
 |  |  |  |  | 0.17 | 22 | 0.01
 |  |  |  |  | 0.199 | 28 | 0.01
 |  |  |  |  | 0.265 | 28 | 0.01
 |  |  |  |  | 0.336 | 28 | 0.01
 |  |  |  |  | 0.065 | 15 | 0.011
 |  |  |  |  | 0.032 | 15 | 0.011
 |  |  |  |  | 0.119 | 22 | 0.011
 |  |  |  |  | 0.17 | 22 | 0.011
 |  |  |  |  | 0.199 | 28 | 0.011
 |  |  |  |  | 0.265 | 28 | 0.011
 |  |  |  |  | 0.336 | 28 | 0.011
 |  |  |  |  | 0.065 | 15 | 0.012
 |  |  |  |  | 0.032 | 15 | 0.012
 |  |  |  |  | 0.119 | 22 | 0.012
 |  |  |  |  | 0.17 | 22 | 0.012
 |  |  |  |  | 0.199 | 28 | 0.012
 |  |  |  |  | 0.265 | 28 | 0.012
 |  |  |  |  | 0.336 | 28 | 0.012
 |  |  |  |  | 0.065 | 15 | 0.013
 |  |  |  |  | 0.032 | 15 | 0.013
 |  |  |  |  | 0.119 | 22 | 0.013
 |  |  |  |  | 0.17 | 22 | 0.013
 |  |  |  |  | 0.199 | 28 | 0.013
 |  |  |  |  | 0.265 | 28 | 0.013
 |  |  |  |  | 0.336 | 28 | 0.013
 |  |  |  |  | 0.065 | 15 | 0.014
 |  |  |  |  | 0.032 | 15 | 0.014
 |  |  |  |  | 0.119 | 22 | 0.014
 |  |  |  |  | 0.17 | 22 | 0.014
 |  |  |  |  | 0.199 | 28 | 0.014
 |  |  |  |  | 0.265 | 28 | 0.014
 |  |  |  |  | 0.336 | 28 | 0.014
 |  |  |  |  | 0.065 | 15 | 0.015
 |  |  |  |  | 0.032 | 15 | 0.015
 |  |  |  |  | 0.119 | 22 | 0.015 |  |  | ... | ... | ...
 |  |  |  |  | 0.17 | 22 | 0.015
 |  |  |  |  | 0.199 | 28 | 0.015
 |  |  |  |  | 0.265 | 28 | 0.015
 |  |  |  |  | 0.336 | 28 | 0.015
 |  |  |  |  | 0.065 | 15 | 0.016
 |  |  |  |  | 0.032 | 15 | 0.016
 |  |  |  |  | 0.119 | 22 | 0.016
 |  |  |  |  | 0.17 | 22 | 0.016
 |  |  |  |  | 0.199 | 28 | 0.016
 |  |  |  |  | 0.265 | 28 | 0.016
 |  |  |  |  | 0.336 | 28 | 0.016
 |  |  |  |  | 0.065 | 15 | 0.017
 |  |  |  |  | 0.032 | 15 | 0.017
 |  |  |  |  | 0.119 | 22 | 0.017
 |  |  |  |  | 0.17 | 22 | 0.017
 |  |  |  |  | 0.199 | 28 | 0.017
 |  |  |  |  | 0.265 | 28 | 0.017
 |  |  |  |  | 0.336 | 28 | 0.017
 |  |  |  |  | 0.065 | 15 | 0.018
 |  |  |  |  | 0.032 | 15 | 0.018
 |  |  |  |  | 0.119 | 22 | 0.018
 |  |  |  |  | 0.17 | 22 | 0.018
 |  |  |  |  | 0.199 | 28 | 0.018
 |  |  |  |  | 0.265 | 28 | 0.018
 |  |  |  |  | 0.336 | 28 | 0.018
 |  |  |  |  | 0.065 | 15 | 0.019
 |  |  |  |  | 0.032 | 15 | 0.019
 |  |  |  |  | 0.119 | 22 | 0.019
 |  |  |  |  | 0.17 | 22 | 0.019
 |  |  |  |  | 0.199 | 28 | 0.019
 |  |  |  |  | 0.265 | 28 | 0.019
 |  |  |  |  | 0.336 | 28 | 0.019
 |  |  |  |  | 0.065 | 15 | 0.02
 |  |  |  |  | 0.032 | 15 | 0.02
 |  |  |  |  | 0.119 | 22 | 0.02
 |  |  |  |  | 0.17 | 22 | 0.02
 |  |  |  |  | 0.199 | 28 | 0.02
 |  |  |  |  | 0.265 | 28 | 0.02
 |  |  |  |  | 0.336 | 28 | 0.02
 |  |  |  |  | 0.065 | 15 | 0.021
 |  |  |  |  | 0.032 | 15 | 0.021
 |  |  |  |  | 0.119 | 22 | 0.021
 |  |  |  |  | 0.17 | 22 | 0.021
 |  |  |  |  | 0.199 | 28 | 0.021
 |  |  |  |  | 0.265 | 28 | 0.021
 |  |  |  |  | 0.336 | 28 | 0.021
 |  |  |  |  | 0.065 | 15 | 0.022
 |  |  |  |  | 0.032 | 15 | 0.022
 |  |  |  |  | 0.119 | 22 | 0.022
 |  |  |  |  | 0.17 | 22 | 0.022
 |  |  |  |  | 0.199 | 28 | 0.022
 |  |  |  |  | 0.265 | 28 | 0.022
 |  |  |  |  | 0.336 | 28 | 0.022
 |  |  |  |  | 0.065 | 15 | 0.024
 |  |  |  |  | 0.032 | 15 | 0.024
 |  |  |  |  | 0.119 | 22 | 0.024
 |  |  |  |  | 0.17 | 22 | 0.024
 |  |  |  |  | 0.199 | 28 | 0.024
 |  |  |  |  | 0.265 | 28 | 0.024
 |  |  |  |  | 0.336 | 28 | 0.024
 |  |  |  |  | 0.065 | 15 | 0.026
 |  |  |  |  | 0.032 | 15 | 0.026
 |  |  |  |  | 0.119 | 22 | 0.026
 |  |  |  |  | 0.17 | 22 | 0.026
 |  |  |  |  | 0.199 | 28 | 0.026
 |  |  |  |  | 0.265 | 28 | 0.026
 |  |  |  |  | 0.336 | 28 | 0.026
 |  |  |  |  | 0.065 | 15 | 0.028
 |  |  |  |  | 0.032 | 15 | 0.028
 |  |  |  |  | 0.119 | 22 | 0.028
 |  |  |  |  | 0.17 | 22 | 0.028
 |  |  |  |  | 0.199 | 28 | 0.028
 |  |  |  |  | 0.265 | 28 | 0.028
 |  |  |  |  | 0.336 | 28 | 0.028
 |  |  |  |  | 0.065 | 15 | 0.03
 |  |  |  |  | 0.032 | 15 | 0.03
 |  |  |  |  | 0.119 | 22 | 0.03
 |  |  |  |  | 0.17 | 22 | 0.03
 |  |  |  |  | 0.199 | 28 | 0.03
 |  |  |  |  | 0.265 | 28 | 0.03
 |  |  |  |  | 0.336 | 28 | 0.03
 |  |  |  |  | 0.065 | 15 | 0.032
 |  |  |  |  | 0.032 | 15 | 0.032
 |  |  |  |  | 0.119 | 22 | 0.032
 |  |  |  |  | 0.17 | 22 | 0.032
 |  |  |  |  | 0.199 | 28 | 0.032
 |  |  |  |  | 0.265 | 28 | 0.032
 |  |  |  |  | 0.336 | 28 | 0.032
 |  |  |  |  | 0.065 | 15 | 0.034
 |  |  |  |  | 0.032 | 15 | 0.034
 |  |  |  |  | 0.119 | 22 | 0.034
 |  |  |  |  | 0.17 | 22 | 0.034
 |  |  |  |  | 0.199 | 28 | 0.034
 |  |  |  |  | 0.265 | 28 | 0.034
 |  |  |  |  | 0.336 | 28 | 0.034
 |  |  |  |  | 0.065 | 15 | 0.036
 |  |  |  |  | 0.032 | 15 | 0.036
 |  |  |  |  | 0.119 | 22 | 0.036
 |  |  |  |  | 0.17 | 22 | 0.036
 |  |  |  |  | 0.199 | 28 | 0.036
 |  |  |  |  | 0.265 | 28 | 0.036
 |  |  |  |  | 0.336 | 28 | 0.036
 |  |  |  |  | 0.065 | 15 | 0.038
 |  |  |  |  | 0.032 | 15 | 0.038
 |  |  |  |  | 0.119 | 22 | 0.038
 |  |  |  |  | 0.17 | 22 | 0.038
 |  |  |  |  | 0.199 | 28 | 0.038
 |  |  |  |  | 0.265 | 28 | 0.038
 |  |  |  |  | 0.336 | 28 | 0.038
 |  |  |  |  | 0.065 | 15 | 0.04
 |  |  |  |  | 0.032 | 15 | 0.04
 |  |  |  |  | 0.119 | 22 | 0.04
 |  |  |  |  | 0.17 | 22 | 0.04
 |  |  |  |  | 0.199 | 28 | 0.04
 |  |  |  |  | 0.265 | 28 | 0.04
 |  |  |  |  | 0.336 | 28 | 0.04
 |  |  |  |  | 0.065 | 15 | 0.042
 |  |  |  |  | 0.032 | 15 | 0.042
 |  |  |  |  | 0.119 | 22 | 0.042
 |  |  |  |  | 0.17 | 22 | 0.042
 |  |  |  |  | 0.199 | 28 | 0.042
 |  |  |  |  | 0.265 | 28 | 0.042
 |  |  |  |  | 0.336 | 28 | 0.042
 |  |  |  |  | 0.065 | 15 | 0.044
 |  |  |  |  | 0.032 | 15 | 0.044
 |  |  |  |  | 0.119 | 22 | 0.044
 |  |  |  |  | 0.17 | 22 | 0.044
 |  |  |  |  | 0.199 | 28 | 0.044
 |  |  |  |  | 0.265 | 28 | 0.044
 |  |  |  |  | 0.336 | 28 | 0.044
 |  |  |  |  | 0.065 | 15 | 0.046
 |  |  |  |  | 0.032 | 15 | 0.046
 |  |  |  |  | 0.119 | 22 | 0.046
 |  |  |  |  | 0.17 | 22 | 0.046
 |  |  |  |  | 0.199 | 28 | 0.046
 |  |  |  |  | 0.265 | 28 | 0.046
 |  |  |  |  | 0.336 | 28 | 0.046
 |  |  |  |  | 0.065 | 15 | 0.048
 |  |  |  |  | 0.032 | 15 | 0.048
 |  |  |  |  | 0.119 | 22 | 0.048
 |  |  |  |  | 0.17 | 22 | 0.048
 |  |  |  |  | 0.199 | 28 | 0.048
 |  |  |  |  | 0.265 | 28 | 0.048
 |  |  |  |  | 0.336 | 28 | 0.048