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: Oxygen 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 [NAME] at 55 psi gauge pressure and 68F |  |  |  |  |  |  |  |  |  | For [NAME] 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.003 | - | - | - | - | - | - | - | - | 0.35 | 0.005 | - | - | - | - | - | - | - | -
20 | 0.011 | 0.002 | - | - | - | - | - | - | - | 0.71 | 0.011 | 0.002 | - | - | - | - | - | - | -
30 | 0.021 | 0.004 | - | - | - | - | - | - | - | 1.06 | 0.021 | 0.004 | - | - | - | - | - | - | - |  |  | 1/2"
40 | 0.035 | 0.006 | - | - | - | - | - | - | - | 1.41 | 0.035 | 0.006 | - | - | - | - | - | - | - |  |  | 3/4"
50 | 0.051 | 0.009 | - | - | - | - | - | - | - | 1.77 | 0.051 | 0.009 | - | - | - | - | - | - | - |  |  | 1"
60 | 0.07 | 0.013 | - | - | - | - | - | - | - | 2.12 | 0.07 | 0.013 | - | - | - | - | - | - | - |  |  | 1-1/4"
70 | 0.092 | 0.016 | - | - | - | - | - | - | - | 2.47 | 0.092 | 0.016 | - | - | - | - | - | - | - |  |  | 1-1/2"
80 | 0.115 | 0.021 | - | - | - | - | - | - | - | 2.83 | 0.115 | 0.021 | - | - | - | - | - | - | - |  |  | 2"
90 | 0.142 | 0.025 | - | - | - | - | - | - | - | 3.18 | 0.142 | 0.025 | - | - | - | - | - | - | - |  |  | 2-1/2"
100 | 0.17 | 0.03 | 0.009 | - | - | - | - | - | - | 3.53 | 0.17 | 0.03 | 0.009 | - | - | - | - | - | - |  |  | 3"
120 | 0.234 | 0.041 | 0.012 | - | - | - | - | - | - | 4.24 | 0.234 | 0.041 | 0.012 | - | - | - | - | - | - |  |  | 4"
140 | 0.306 | 0.054 | 0.015 | - | - | - | - | - | - | 4.94 | 0.306 | 0.054 | 0.015 | - | - | - | - | - | -
160 | 0.387 | 0.068 | 0.019 | - | - | - | - | - | - | 5.65 | 0.387 | 0.068 | 0.019 | - | - | - | - | - | -
180 | 0.476 | 0.084 | 0.024 | - | - | - | - | - | - | 6.36 | 0.476 | 0.084 | 0.024 | - | - | - | - | - | -
200 | 0.572 | 0.101 | 0.028 | - | - | - | - | - | - | 7.06 | 0.572 | 0.101 | 0.028 | - | - | - | - | - | -
220 | 0.677 | 0.119 | 0.034 | - | - | - | - | - | - | 7.77 | 0.677 | 0.119 | 0.034 | - | - | - | - | - | -
240 | 0.79 | 0.139 | 0.039 | - | - | - | - | - | - | 8.48 | 0.79 | 0.139 | 0.039 | - | - | - | - | - | -
260 | 0.91 | 0.16 | 0.045 | - | - | - | - | - | - | 9.18 | 0.91 | 0.16 | 0.045 | - | - | - | - | - | -
280 | 1.037 | 0.182 | 0.051 | - | - | - | - | - | - | 9.89 | 1.037 | 0.182 | 0.051 | - | - | - | - | - | -
300 | 1.173 | 0.205 | 0.058 | - | - | - | - | - | - | 10.6 | 1.173 | 0.205 | 0.058 | - | - | - | - | - | -
320 | 1.315 | 0.23 | 0.065 | - | - | - | - | - | - | 11.3 | 1.315 | 0.23 | 0.065 | - | - | - | - | - | -
340 | 1.465 | 0.256 | 0.072 | - | - | - | - | - | - | 12.01 | 1.465 | 0.256 | 0.072 | - | - | - | - | - | -
360 | 1.621 | 0.283 | 0.079 | - | - | - | - | - | - | 12.71 | 1.621 | 0.283 | 0.079 | - | - | - | - | - | -
380 | 1.785 | 0.311 | 0.087 | - | - | - | - | - | - | 13.4 | 1.785 | 0.311 | 0.087 | - | - | - | - | - | -
400 | 1.956 | 0.341 | 0.095 | 0.035 | - | - | - | - | - | 14.1 | 1.956 | 0.341 | 0.095 | 0.035 | - | - | - | - | -
450 | 2.414 | 0.42 | 0.117 | 0.043 | - | - | - | - | - | 15.9 | 2.414 | 0.42 | 0.117 | 0.043 | - | - | - | - | -
500 | 2.915 | 0.506 | 0.142 | 0.052 | - | - | - | - | - | 17.7 | 2.915 | 0.506 | 0.142 | 0.052 | - | - | - | - | -
550 | 3.459 | 0.6 | 0.167 | 0.061 | - | - | - | - | - | 19.4 | 3.459 | 0.6 | 0.167 | 0.061 | - | - | - | - | -
600 | 4.044 | 0.7 | 0.195 | 0.072 | - | - | - | - | - | 21.2 | 4.044 | 0.7 | 0.195 | 0.072 | - | - | - | - | -
650 | 4.67 | 0.808 | 0.225 | 0.082 | - | - | - | - | - | 23 | 4.67 | 0.808 | 0.225 | 0.082 | - | - | - | - | -
700 | 5.337 | 0.922 | 0.257 | 0.094 | - | - | - | - | - | 24.7 | 5.337 | 0.922 | 0.257 | 0.094 | - | - | - | - | -
750 | - | 1.043 | 0.29 | 0.106 | - | - | - | - | - | 26.5 | - | 1.043 | 0.29 | 0.106 | - | - | - | - | -
800 | - | 1.171 | 0.326 | 0.119 | 0.052 | - | - | - | - | 28.3 | - | 1.171 | 0.326 | 0.119 | 0.052 | - | - | - | -
850 | - | 1.305 | 0.363 | 0.133 | 0.058 | - | - | - | - | 30 | - | 1.305 | 0.363 | 0.133 | 0.058 | - | - | - | -
900 | - | 1.446 | 0.402 | 0.147 | 0.064 | - | - | - | - | 31.8 | - | 1.446 | 0.402 | 0.147 | 0.064 | - | - | - | -
950 | - | 1.593 | 0.442 | 0.162 | 0.07 | - | - | - | - | 33.6 | - | 1.593 | 0.442 | 0.162 | 0.07 | - | - | - | -
1000 | - | 1.747 | 0.485 | 0.177 | 0.077 | - | - | - | - | 35.3 | - | 1.747 | 0.485 | 0.177 | 0.077 | - | - | - | -
1100 | - | 2.074 | 0.575 | 0.21 | 0.091 | - | - | - | - | 38.9 | - | 2.074 | 0.575 | 0.21 | 0.091 | - | - | - | -
1200 | - | 2.426 | 0.672 | 0.245 | 0.107 | - | - | - | - | 42.4 | - | 2.426 | 0.672 | 0.245 | 0.107 | - | - | - | -
1300 | - | 2.802 | 0.776 | 0.282 | 0.123 | - | - | - | - | 45.9 | - | 2.802 | 0.776 | 0.282 | 0.123 | - | - | - | -
1400 | - | 3.204 | 0.886 | 0.323 | 0.14 | - | - | - | - | 49.4 | - | 3.204 | 0.886 | 0.323 | 0.14 | - | - | - | -
1500 | - | 3.63 | 1.003 | 0.365 | 0.159 | - | - | - | - | 53 | - | 3.63 | 1.003 | 0.365 | 0.159 | - | - | - | -
1600 | - | 4.08 | 1.126 | 0.41 | 0.178 | 0.047 | - | - | - | 56.5 | - | 4.08 | 1.126 | 0.41 | 0.178 | 0.047 | - | - | -
1700 | - | 4.554 | 1.256 | 0.457 | 0.198 | 0.053 | - | - | - | 60 | - | 4.554 | 1.256 | 0.457 | 0.198 | 0.053 | - | - | -
1800 | - | 5.051 | 1.393 | 0.506 | 0.22 | 0.058 | - | - | - | 63.6 | - | 5.051 | 1.393 | 0.506 | 0.22 | 0.058 | - | - | -
1900 | - | - | 1.535 | 0.558 | 0.242 | 0.064 | - | - | - | 67 | - | - | 1.535 | 0.558 | 0.242 | 0.064 | - | - | -
2000 | - | - | 1.684 | 0.611 | 0.265 | 0.07 | 0.025 | - | - | 70.6 | - | - | 1.684 | 0.611 | 0.265 | 0.07 | 0.025 | - | -
2250 | - | - | 2.084 | 0.756 | 0.328 | 0.087 | 0.031 | - | - | 79.5 | - | - | 2.084 | 0.756 | 0.328 | 0.087 | 0.031 | - | -
2500 | - | - | 2.523 | 0.914 | 0.396 | 0.105 | 0.037 | - | - | 88.3 | - | - | 2.523 | 0.914 | 0.396 | 0.105 | 0.037 | - | -
2750 | - | - | 2.999 | 1.086 | 0.47 | 0.124 | 0.044 | - | - | 97.1 | - | - | 2.999 | 1.086 | 0.47 | 0.124 | 0.044 | - | -
3000 | - | - | 3.513 | 1.271 | 0.55 | 0.145 | 0.051 | - | - | 105.9 | - | - | 3.513 | 1.271 | 0.55 | 0.145 | 0.051 | - | -
3250 | - | - | 4.064 | 1.469 | 0.635 | 0.168 | 0.059 | - | - | 114.8 | - | - | 4.064 | 1.469 | 0.635 | 0.168 | 0.059 | - | -
3500 | - | - | 4.652 | 1.68 | 0.726 | 0.192 | 0.068 | - | - | 123.6 | - | - | 4.652 | 1.68 | 0.726 | 0.192 | 0.068 | - | -
3750 | - | - | 5.276 | 1.904 | 0.823 | 0.217 | 0.077 | - | - | 132.4 | - | - | 5.276 | 1.904 | 0.823 | 0.217 | 0.077 | - | -
4000 | - | - | - | 2.141 | 0.925 | 0.244 | 0.086 | - | - | 141.3 | - | - | - | 2.141 | 0.925 | 0.244 | 0.086 | - | -
4250 | - | - | - | 2.391 | 1.032 | 0.272 | 0.096 | - | - | 150 | - | - | - | 2.391 | 1.032 | 0.272 | 0.096 | - | -
4500 | - | - | - | 2.653 | 1.145 | 0.301 | 0.106 | - | - | 159 | - | - | - | 2.653 | 1.145 | 0.301 | 0.106 | - | -
4750 | - | - | - | 2.928 | 1.263 | 0.332 | 0.117 | - | - | 168 | - | - | - | 2.928 | 1.263 | 0.332 | 0.117 | - | -
5000 | - | - | - | 3.215 | 1.386 | 0.364 | 0.129 | - | - | 177 | - | - | - | 3.215 | 1.386 | 0.364 | 0.129 | - | -
5500 | - | - | - | 3.826 | 1.649 | 0.433 | 0.153 | - | - | 194 | - | - | - | 3.826 | 1.649 | 0.433 | 0.153 | - | -
6000 | - | - | - | 4.486 | 1.932 | 0.507 | 0.178 | 0.076 | - | 212 | - | - | - | 4.486 | 1.932 | 0.507 | 0.178 | 0.076 | -
6500 | - | - | - | 5.195 | 2.235 | 0.586 | 0.206 | 0.088 | - | 230 | - | - | - | 5.195 | 2.235 | 0.586 | 0.206 | 0.088 | -
7000 | - | - | - | - | 2.559 | 0.67 | 0.236 | 0.1 | - | 247 | - | - | - | - | 2.559 | 0.67 | 0.236 | 0.1 | -
7500 | - | - | - | - | 2.903 | 0.76 | 0.267 | 0.113 | - | 265 | - | - | - | - | 2.903 | 0.76 | 0.267 | 0.113 | -
8000 | - | - | - | - | 3.267 | 0.854 | 0.3 | 0.127 | - | 283 | - | - | - | - | 3.267 | 0.854 | 0.3 | 0.127 | -
8500 | - | - | - | - | 3.651 | 0.954 | 0.335 | 0.142 | 0.037 | 300 | - | - | - | - | 3.651 | 0.954 | 0.335 | 0.142 | 0.037
9000 | - | - | - | - | 4.055 | 1.059 | 0.372 | 0.158 | 0.041 | 318 | - | - | - | - | 4.055 | 1.059 | 0.372 | 0.158 | 0.041
9500 | - | - | - | - | 4.478 | 1.168 | 0.41 | 0.174 | 0.045 | 335 | - | - | - | - | 4.478 | 1.168 | 0.41 | 0.174 | 0.045
10000 | - | - | - | - | 4.92 | 1.283 | 0.45 | 0.191 | 0.049 | 353 | - | - | - | - | 4.92 | 1.283 | 0.45 | 0.191 | 0.049
10500 | - | - | - | - | 5.382 | 1.402 | 0.492 | 0.208 | 0.054 | 371 | - | - | - | - | 5.382 | 1.402 | 0.492 | 0.208 | 0.054
11000 | - | - | - | - | - | 1.527 | 0.535 | 0.227 | 0.058 | 388 | - | - | - | - | - | 1.527 | 0.535 | 0.227 | 0.058
11500 | - | - | - | - | - | 1.656 | 0.58 | 0.246 | 0.063 | 406 | - | - | - | - | - | 1.656 | 0.58 | 0.246 | 0.063
12000 | - | - | - | - | - | 1.79 | 0.627 | 0.265 | 0.068 | 424 | - | - | - | - | - | 1.79 | 0.627 | 0.265 | 0.068
13000 | - | - | - | - | - | 2.037 | 0.725 | 0.307 | 0.079 | 459 | - | - | - | - | - | 2.037 | 0.725 | 0.307 | 0.079