Spreadsheet: 596004d1540906254-if-and-using-vlookup-from-another-tab-using-table-but-if-over-roundup-to-next-cell-med-gas-branch-pipe-sizing-test-autosaved-
Sheet: Medical Air Flow Rate Table 

[NAME] (14.7 psig and 68F) | Pressure drop in Pounds per Square Inch (psi) |  |  |  |  |  |  |  |  | [NAME] (14.7 psig and 68F) | Pressure drop in Pounds per Square Inch (psi)
 | Per 100 ft of ASTM B819 Type L copper Pipe |  |  |  |  |  |  |  |  |  | Per 100 ft of ASTM B819 Type L copper Pipe
 | For Medical Air at 55 psi gauge pressure and 68F |  |  |  |  |  |  |  |  |  | For Medical Air at 55 psi gauge pressure and 68F
 | Nominal Pipe Sizes |  |  |  |  |  |  |  |  |  | Nominal Pipe Sizes
LPM | 1/2" | 3/4" | 1" | 1 1/4" | 1 1/2" | 2" | 2 1/2" | 3" | 4" | SCFM | 1/2" | 3/4" | 1" | 1 1/4" | 1 1/2" | 2" | 2 1/2" | 3" | 4"
10 | 0.002 | - | - | - | - | - | - | - | - | 0.35 | 0.002 | - | - | - | - | - | - | - | -
20 | 0.005 | 0.002 | - | - | - | - | - | - | - | 0.71 | 0.005 | 0.002 | - | - | - | - | - | - | -
30 | 0.014 | 0.004 | - | - | - | - | - | - | - | 1.06 | 0.014 | 0.004 | - | - | - | - | - | - | - |  |  | 1/2"
40 | 0.024 | 0.006 | - | - | - | - | - | - | - | 1.41 | 0.024 | 0.006 | - | - | - | - | - | - | - |  |  | 3/4"
50 | 0.034 | 0.008 | - | - | - | - | - | - | - | 1.77 | 0.034 | 0.008 | - | - | - | - | - | - | - |  |  | 1"
60 | 0.047 | 0.011 | - | - | - | - | - | - | - | 2.12 | 0.047 | 0.011 | - | - | - | - | - | - | - |  |  | 1 1/4"
70 | 0.061 | 0.015 | - | - | - | - | - | - | - | 2.47 | 0.061 | 0.015 | - | - | - | - | - | - | - |  |  | 1 1/2"
80 | 0.077 | 0.019 | - | - | - | - | - | - | - | 2.83 | 0.077 | 0.019 | - | - | - | - | - | - | - |  |  | 2"
90 | 0.095 | 0.023 | - | - | - | - | - | - | - | 3.18 | 0.095 | 0.023 | - | - | - | - | - | - | - |  |  | 2-1/2"
100 | 0.114 | 0.028 | 0.008 | - | - | - | - | - | - | 3.53 | 0.114 | 0.028 | 0.008 | - | - | - | - | - | - |  |  | 3"
120 | 0.157 | 0.038 | 0.011 | - | - | - | - | - | - | 4.24 | 0.157 | 0.038 | 0.011 | - | - | - | - | - | - |  |  | 4"
140 | 0.205 | 0.049 | 0.014 | - | - | - | - | - | - | 4.94 | 0.205 | 0.049 | 0.014 | - | - | - | - | - | -
160 | 0.259 | 0.062 | 0.018 | - | - | - | - | - | - | 5.65 | 0.259 | 0.062 | 0.018 | - | - | - | - | - | -
180 | 0.319 | 0.076 | 0.022 | - | - | - | - | - | - | 6.36 | 0.319 | 0.076 | 0.022 | - | - | - | - | - | -
200 | 0.383 | 0.092 | 0.026 | - | - | - | - | - | - | 7.06 | 0.383 | 0.092 | 0.026 | - | - | - | - | - | -
220 | 0.454 | 0.108 | 0.031 | - | - | - | - | - | - | 7.77 | 0.454 | 0.108 | 0.031 | - | - | - | - | - | -
240 | 0.529 | 0.126 | 0.036 | - | - | - | - | - | - | 8.48 | 0.529 | 0.126 | 0.036 | - | - | - | - | - | -
260 | 0.609 | 0.145 | 0.041 | - | - | - | - | - | - | 9.18 | 0.609 | 0.145 | 0.041 | - | - | - | - | - | -
280 | 0.695 | 0.165 | 0.046 | - | - | - | - | - | - | 9.89 | 0.695 | 0.165 | 0.046 | - | - | - | - | - | -
300 | 0.785 | 0.187 | 0.052 | - | - | - | - | - | - | 10.59 | 0.785 | 0.187 | 0.052 | - | - | - | - | - | -
320 | 0.881 | 0.209 | 0.059 | - | - | - | - | - | - | 11.3 | 0.881 | 0.209 | 0.059 | - | - | - | - | - | -
340 | 0.981 | 0.233 | 0.065 | - | - | - | - | - | - | 12.01 | 0.981 | 0.233 | 0.065 | - | - | - | - | - | -
360 | 1.086 | 0.258 | 0.072 | - | - | - | - | - | - | 12.71 | 1.086 | 0.258 | 0.072 | - | - | - | - | - | -
380 | 1.195 | 0.283 | 0.079 | - | - | - | - | - | - | 13.42 | 1.195 | 0.283 | 0.079 | - | - | - | - | - | -
400 | 1.31 | 0.31 | 0.087 | 0.032 | - | - | - | - | - | 14.13 | 1.31 | 0.31 | 0.087 | 0.032 | - | - | - | - | -
450 | 1.616 | 0.382 | 0.107 | 0.039 | - | - | - | - | - | 15.89 | 1.616 | 0.382 | 0.107 | 0.039 | - | - | - | - | -
500 | 1.952 | 0.461 | 0.129 | 0.047 | - | - | - | - | - | 17.66 | 1.952 | 0.461 | 0.129 | 0.047 | - | - | - | - | -
550 | 2.315 | 0.546 | 0.152 | 0.056 | - | - | - | - | - | 19.42 | 2.315 | 0.546 | 0.152 | 0.056 | - | - | - | - | -
600 | 2.707 | 0.637 | 0.178 | 0.065 | - | - | - | - | - | 21.19 | 2.707 | 0.637 | 0.178 | 0.065 | - | - | - | - | -
650 | 3.126 | 0.735 | 0.205 | 0.075 | - | - | - | - | - | 22.95 | 3.126 | 0.735 | 0.205 | 0.075 | - | - | - | - | -
700 | 3.572 | 0.839 | 0.234 | 0.086 | - | - | - | - | - | 24.72 | 3.572 | 0.839 | 0.234 | 0.086 | - | - | - | - | -
750 | 4.045 | 0.949 | 0.264 | 0.097 | - | - | - | - | - | 26.49 | 4.045 | 0.949 | 0.264 | 0.097 | - | - | - | - | -
800 | 4.545 | 1.065 | 0.296 | 0.108 | 0.047 | - | - | - | - | 28.25 | 4.545 | 1.065 | 0.296 | 0.108 | 0.047 | - | - | - | -
850 | 5.071 | 1.187 | 0.33 | 0.121 | 0.053 | - | - | - | - | 30.02 | 5.071 | 1.187 | 0.33 | 0.121 | 0.053 | - | - | - | -
900 | 5.624 | 1.315 | 0.365 | 0.134 | 0.058 | - | - | - | - | 31.78 | 5.624 | 1.315 | 0.365 | 0.134 | 0.058 | - | - | - | -
950 | 6.202 | 1.449 | 0.402 | 0.147 | 0.064 | - | - | - | - | 33.55 | 6.202 | 1.449 | 0.402 | 0.147 | 0.064 | - | - | - | -
1000 | 6.807 | 1.589 | 0.441 | 0.161 | 0.07 | - | - | - | - | 35.31 | 6.807 | 1.589 | 0.441 | 0.161 | 0.07 | - | - | - | -
1100 | 8.093 | 1.886 | 0.523 | 0.191 | 0.083 | - | - | - | - | 38.85 | 8.093 | 1.886 | 0.523 | 0.191 | 0.083 | - | - | - | -
1200 | - | 2.206 | 0.611 | 0.223 | 0.097 | - | - | - | - | 42.38 | - | 2.206 | 0.611 | 0.223 | 0.097 | - | - | - | -
1300 | - | 2.548 | 0.705 | 0.257 | 0.112 | - | - | - | - | 45.91 | - | 2.548 | 0.705 | 0.257 | 0.112 | - | - | - | -
1400 | - | 2.913 | 0.806 | 0.293 | 0.128 | - | - | - | - | 49.44 | - | 2.913 | 0.806 | 0.293 | 0.128 | - | - | - | -
1500 | - | 3.3 | 0.912 | 0.332 | 0.144 | - | - | - | - | 52.97 | - | 3.3 | 0.912 | 0.332 | 0.144 | - | - | - | -
1600 | - | 3.709 | 1.024 | 0.373 | 0.162 | 0.043 | - | - | - | 56.5 | - | 3.709 | 1.024 | 0.373 | 0.162 | 0.043 | - | - | -
1700 | - | 4.14 | 1.142 | 0.415 | 0.18 | 0.048 | - | - | - | 60.03 | - | 4.14 | 1.142 | 0.415 | 0.18 | 0.048 | - | - | -
1800 | - | 4.592 | 1.266 | 0.46 | 0.2 | 0.053 | - | - | - | 63.57 | - | 4.592 | 1.266 | 0.46 | 0.2 | 0.053 | - | - | -
1900 | - | 5.066 | 1.396 | 0.507 | 0.22 | 0.058 | - | - | - | 67.01 | - | 5.066 | 1.396 | 0.507 | 0.22 | 0.058 | - | - | -
2000 | - | - | 1.532 | 0.556 | 0.241 | 0.064 | 0.023 | - | - | 70.63 | - | 4.093 | 1.532 | 0.556 | 0.241 | 0.064 | 0.023 | - | -
2250 | - | - | 1.895 | 0.687 | 0.298 | 0.079 | 0.028 | - | - | 79.46 | - | 5.072 | 1.895 | 0.687 | 0.298 | 0.079 | 0.028 | - | -
2500 | - | - | 2.293 | 0.831 | 0.36 | 0.095 | 0.034 | - | - | 88.29 | - | 6.147 | 2.293 | 0.831 | 0.36 | 0.095 | 0.034 | - | -
2750 | - | - | 2.726 | 0.987 | 0.428 | 0.113 | 0.04 | - | - | 97.12 | - | 7.317 | 2.726 | 0.987 | 0.428 | 0.113 | 0.04 | - | -
3000 | - | - | 3.193 | 1.155 | 0.5 | 0.132 | 0.047 | - | - | 105.9 | - | 8.581 | 3.193 | 1.155 | 0.5 | 0.132 | 0.047 | - | -
3250 | - | - | 3.694 | 1.335 | 0.578 | 0.153 | 0.054 | - | - | 114.8 | - | - | 3.694 | 1.335 | 0.578 | 0.153 | 0.054 | - | -
3500 | - | - | 4.228 | 1.527 | 0.66 | 0.174 | 0.062 | - | - | 123.6 | - | - | 4.228 | 1.527 | 0.66 | 0.174 | 0.062 | - | -
3750 | - | - | 4.796 | 1.731 | 0.748 | 0.197 | 0.07 | - | - | 132.4 | - | - | 4.796 | 1.731 | 0.748 | 0.197 | 0.07 | - | -
4000 | - | - | - | 1.946 | 0.841 | 0.222 | 0.078 | - | - | 141.3 | - | - | - | 1.946 | 0.841 | 0.222 | 0.078 | - | -
4250 | - | - | - | 2.173 | 0.938 | 0.247 | 0.087 | - | - | 150.1 | - | - | - | 2.173 | 0.938 | 0.247 | 0.087 | - | -
4500 | - | - | - | 2.411 | 1.041 | 0.274 | 0.097 | - | - | 158.9 | - | - | - | 2.411 | 1.041 | 0.274 | 0.097 | - | -
4750 | - | - | - | 2.661 | 1.148 | 0.302 | 0.107 | - | - | 167.7 | - | - | - | 2.661 | 1.148 | 0.302 | 0.107 | - | -
5000 | - | - | - | 2.922 | 1.26 | 0.331 | 0.117 | - | - | 176.6 | - | - | - | 2.922 | 1.26 | 0.331 | 0.117 | - | -
5500 | - | - | - | 3.477 | 1.499 | 0.394 | 0.139 | - | - | 194.2 | - | - | - | 3.477 | 1.499 | 0.394 | 0.139 | - | -
6000 | - | - | - | 4.077 | 1.756 | 0.461 | 0.162 | 0.069 | - | 211.9 | - | - | - | 4.077 | 1.756 | 0.461 | 0.162 | 0.069 | -
6500 | - | - | - | 4.721 | 2.032 | 0.533 | 0.188 | 0.08 | - | 229.6 | - | - | - | 4.721 | 2.032 | 0.533 | 0.188 | 0.08 | -
7000 | - | - | - | - | 2.326 | 0.609 | 0.214 | 0.091 | - | 247.2 | - | - | - | - | 2.326 | 0.609 | 0.214 | 0.091 | -
7500 | - | - | - | - | 2.638 | 0.691 | 0.243 | 0.103 | - | 264.9 | - | - | - | - | 2.638 | 0.691 | 0.243 | 0.103 | -
8000 | - | - | - | - | 2.969 | 0.777 | 0.273 | 0.116 | - | 282.5 | - | - | - | - | 2.969 | 0.777 | 0.273 | 0.116 | -
8500 | - | - | - | - | 3.318 | 0.867 | 0.305 | 0.129 | 0.033 | 300.2 | - | - | - | - | 3.318 | 0.867 | 0.305 | 0.129 | 0.033
9000 | - | - | - | - | 3.684 | 0.962 | 0.338 | 0.143 | 0.037 | 317.8 | - | - | - | - | 3.684 | 0.962 | 0.338 | 0.143 | 0.037
9500 | - | - | - | - | 4.069 | 1.062 | 0.373 | 0.158 | 0.041 | 335.5 | - | - | - | - | 4.069 | 1.062 | 0.373 | 0.158 | 0.041
10000 | - | - | - | - | 4.471 | 1.166 | 0.409 | 0.173 | 0.045 | 353.2 | - | - | - | - | 4.471 | 1.166 | 0.409 | 0.173 | 0.045
10500 | - | - | - | - | 4.89 | 1.275 | 0.447 | 0.189 | 0.049 | 370.8 | - | - | - | - | 4.89 | 1.275 | 0.447 | 0.189 | 0.049
11000 | - | - | - | - | - | 1.388 | 0.486 | 0.206 | 0.053 | 388.5 | - | - | - | - | - | 1.388 | 0.486 | 0.206 | 0.053
11500 | - | - | - | - | - | 1.505 | 0.527 | 0.223 | 0.057 | 406.1 | - | - | - | - | - | 1.505 | 0.527 | 0.223 | 0.057
12000 | - | - | - | - | - | 1.627 | 0.57 | 0.241 | 0.062 | 423.8 | - | - | - | - | - | 1.627 | 0.57 | 0.241 | 0.062
13000 | - | - | - | - | - | 1.884 | 0.659 | 0.279 | 0.072 | 459.1 | - | - | - | - | - | 1.884 | 0.659 | 0.279 | 0.072
14000 | - | - | - | - | - | 2.46 | 0.86 | 0.36 | 0.09 | 494.41 | - | - | - | - | - | 2.17 | 0.76 | 0.32 | 0.08
15000 | - | - | - | - | - | 2.17 | 0.76 | 0.32 | 0.08 | 529.72 | - | - | - | - | - | 2.46 | 0.86 | 0.36 | 0.09