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: Nitrous Oxide 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 Nitrous Oxide at 55 psi gauge pressure and 68F |  |  |  |  |  |  |  |  |  | For Nitrous Oxide 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 | - | - | - | - | - | - | - | 0.35 | 0.003 | 0 | - | - | - | - | - | - | -
20 | 0.013 | 0.002 | - | - | - | - | - | - | - | 0.71 | 0.013 | 0.002 | - | - | - | - | - | - | -
30 | 0.026 | 0.005 | - | - | - | - | - | - | - | 1.06 | 0.026 | 0.005 | - | - | - | - | - | - | -
40 | 0.043 | 0.008 | - | - | - | - | - | - | - | 1.41 | 0.043 | 0.008 | - | - | - | - | - | - | -
50 | 0.063 | 0.011 | - | - | - | - | - | - | - | 1.77 | 0.063 | 0.011 | - | - | - | - | - | - | -
60 | 0.087 | 0.015 | - | - | - | - | - | - | - | 2.12 | 0.087 | 0.015 | - | - | - | - | - | - | -
70 | 0.114 | 0.02 | - | - | - | - | - | - | - | 2.47 | 0.114 | 0.02 | - | - | - | - | - | - | -
80 | 0.144 | 0.025 | - | - | - | - | - | - | - | 2.83 | 0.144 | 0.025 | - | - | - | - | - | - | -
90 | 0.176 | 0.031 | - | - | - | - | - | - | - | 3.18 | 0.176 | 0.031 | - | - | - | - | - | - | -
100 | 0.212 | 0.037 | 0.011 | - | - | - | - | - | - | 3.53 | 0.212 | 0.037 | 0.011 | - | - | - | - | - | -
120 | 0.292 | 0.051 | 0.015 | - | - | - | - | - | - | 4.24 | 0.292 | 0.051 | 0.015 | - | - | - | - | - | -
140 | 0.383 | 0.067 | 0.019 | - | - | - | - | - | - | 4.94 | 0.383 | 0.067 | 0.019 | - | - | - | - | - | -
160 | 0.485 | 0.085 | 0.024 | - | - | - | - | - | - | 5.65 | 0.485 | 0.085 | 0.024 | - | - | - | - | - | -
180 | 0.597 | 0.105 | 0.029 | - | - | - | - | - | - | 6.36 | 0.597 | 0.105 | 0.029 | - | - | - | - | - | -
200 | 0.72 | 0.126 | 0.035 | - | - | - | - | - | - | 7.06 | 0.72 | 0.126 | 0.035 | - | - | - | - | - | -
220 | 0.853 | 0.149 | 0.042 | - | - | - | - | - | - | 7.77 | 0.853 | 0.149 | 0.042 | - | - | - | - | - | -
240 | 0.996 | 0.174 | 0.049 | - | - | - | - | - | - | 8.48 | 0.996 | 0.174 | 0.049 | - | - | - | - | - | -
260 | 1.148 | 0.2 | 0.056 | - | - | - | - | - | - | 9.18 | 1.148 | 0.2 | 0.056 | - | - | - | - | - | -
280 | 1.31 | 0.228 | 0.064 | - | - | - | - | - | - | 9.89 | 1.31 | 0.228 | 0.064 | - | - | - | - | - | -
300 | 1.482 | 0.258 | 0.072 | - | - | - | - | - | - | 10.6 | 1.482 | 0.258 | 0.072 | - | - | - | - | - | -
320 | 1.664 | 0.289 | 0.081 | - | - | - | - | - | - | 11.3 | 1.664 | 0.289 | 0.081 | - | - | - | - | - | -
340 | 1.854 | 0.322 | 0.09 | - | - | - | - | - | - | 12.01 | 1.854 | 0.322 | 0.09 | - | - | - | - | - | -
360 | 2.054 | 0.357 | 0.01 | - | - | - | - | - | - | 12.71 | 2.054 | 0.357 | 0.01 | - | - | - | - | - | -
380 | 2.264 | 0.393 | 0.11 | - | - | - | - | - | - | 13.4 | 2.264 | 0.393 | 0.11 | - | - | - | - | - | -
400 | 2.482 | 0.43 | 0.12 | 0.044 | - | - | - | - | - | 14.1 | 2.482 | 0.43 | 0.12 | 0.044 | - | - | - | - | -
450 | 3.068 | 0.531 | 0.148 | 0.054 | - | - | - | - | - | 15.9 | 3.068 | 0.531 | 0.148 | 0.054 | - | - | - | - | -
500 | 3.709 | 0.64 | 0.178 | 0.065 | - | - | - | - | - | 17.7 | 3.709 | 0.64 | 0.178 | 0.065 | - | - | - | - | -
550 | 4.406 | 0.759 | 0.211 | 0.077 | - | - | - | - | - | 19.4 | 4.406 | 0.759 | 0.211 | 0.077 | - | - | - | - | -
600 | 5.157 | 0.888 | 0.247 | 0.09 | - | - | - | - | - | 21.2 | 5.157 | 0.888 | 0.247 | 0.09 | - | - | - | - | -
650 | - | 1.025 | 0.285 | 0.104 | - | - | - | - | - | 23 | - | 1.025 | 0.285 | 0.104 | - | - | - | - | -
700 | - | 1.171 | 0.325 | 0.119 | - | - | - | - | - | 24.7 | - | 1.171 | 0.325 | 0.119 | - | - | - | - | -
750 | - | 1.325 | 0.367 | 0.134 | - | - | - | - | - | 26.5 | - | 1.325 | 0.367 | 0.134 | - | - | - | - | -
800 | - | 1.489 | 0.412 | 0.15 | 0.065 | - | - | - | - | 28.3 | - | 1.489 | 0.412 | 0.15 | 0.065 | - | - | - | -
850 | - | 1.661 | 0.46 | 0.168 | 0.073 | - | - | - | - | 30 | - | 1.661 | 0.46 | 0.168 | 0.073 | - | - | - | -
900 | - | 1.841 | 0.509 | 0.186 | 0.081 | - | - | - | - | 31.8 | - | 1.841 | 0.509 | 0.186 | 0.081 | - | - | - | -
950 | - | 2.03 | 0.561 | 0.204 | 0.089 | - | - | - | - | 33.6 | - | 2.03 | 0.561 | 0.204 | 0.089 | - | - | - | -
1000 | - | 2.227 | 0.616 | 0.224 | 0.097 | - | - | - | - | 35.3 | - | 2.227 | 0.616 | 0.224 | 0.097 | - | - | - | -
1100 | - | 2.647 | 0.731 | 0.266 | 0.115 | - | - | - | - | 38.9 | - | 2.647 | 0.731 | 0.266 | 0.115 | - | - | - | -
1200 | - | 3.099 | 0.855 | 0.311 | 0.135 | - | - | - | - | 42.4 | - | 3.099 | 0.855 | 0.311 | 0.135 | - | - | - | -
1300 | - | 3.585 | 0.988 | 0.359 | 0.156 | - | - | - | - | 45.9 | - | 3.585 | 0.988 | 0.359 | 0.156 | - | - | - | -
1400 | - | 4.102 | 1.129 | 0.41 | 0.178 | - | - | - | - | 49.4 | - | 4.102 | 1.129 | 0.41 | 0.178 | - | - | - | -
1500 | - | 4.651 | 1.279 | 0.464 | 0.201 | - | - | - | - | 53 | - | 4.651 | 1.279 | 0.464 | 0.201 | - | - | - | -
1600 | - | 5.232 | 1.438 | 0.521 | 0.226 | 0.06 | - | - | - | 56.5 | - | 5.232 | 1.438 | 0.521 | 0.226 | 0.06 | - | - | -
1700 | - | - | 1.605 | 0.581 | 0.252 | 0.067 | - | - | - | 60 | - | - | 1.605 | 0.581 | 0.252 | 0.067 | - | - | -
1800 | - | - | 1.78 | 0.644 | 0.279 | 0.074 | - | - | - | 63.6 | - | - | 1.78 | 0.644 | 0.279 | 0.074 | - | - | -
1900 | - | - | 1.963 | 0.711 | 0.308 | 0.081 | - | - | - | 67 | - | - | 1.963 | 0.711 | 0.308 | 0.081 | - | - | -
2000 | - | - | 2.155 | 0.78 | 0.337 | 0.089 | 0.032 | - | - | 70.6 | - | - | 2.155 | 0.78 | 0.337 | 0.089 | 0.032 | - | -
2250 | - | - | 2.671 | 0.965 | 0.417 | 0.11 | 0.039 | - | - | 79.5 | - | - | 2.671 | 0.965 | 0.417 | 0.11 | 0.039 | - | -
2500 | - | - | 3.237 | 1.168 | 0.505 | 0.133 | 0.047 | - | - | 88.3 | - | - | 3.237 | 1.168 | 0.505 | 0.133 | 0.047 | - | -
2750 | - | - | 3.853 | 1.389 | 0.6 | 0.158 | 0.056 | - | - | 97.1 | - | - | 3.853 | 1.389 | 0.6 | 0.158 | 0.056 | - | -
3000 | - | - | 4.518 | 1.628 | 0.702 | 0.185 | 0.065 | - | - | 105.9 | - | - | 4.518 | 1.628 | 0.702 | 0.185 | 0.065 | - | -
3250 | - | - | 5.232 | 1.883 | 0.812 | 0.214 | 0.075 | - | - | 114.8 | - | - | 5.232 | 1.883 | 0.812 | 0.214 | 0.075 | - | -
3500 | - | - | - | 2.156 | 0.929 | 0.244 | 0.086 | - | - | 123.6 | - | - | - | 2.156 | 0.929 | 0.244 | 0.086 | - | -
3750 | - | - | - | 2.445 | 1.054 | 0.277 | 0.098 | - | - | 132.4 | - | - | - | 2.445 | 1.054 | 0.277 | 0.098 | - | -
4000 | - | - | - | 2.752 | 1.185 | 0.311 | 0.11 | - | - | 141.3 | - | - | - | 2.752 | 1.185 | 0.311 | 0.11 | - | -
4250 | - | - | - | 3.075 | 1.323 | 0.347 | 0.122 | - | - | 150 | - | - | - | 3.075 | 1.323 | 0.347 | 0.122 | - | -
4500 | - | - | - | 3.415 | 1.469 | 0.385 | 0.135 | - | - | 159 | - | - | - | 3.415 | 1.469 | 0.385 | 0.135 | - | -
4750 | - | - | - | 3.771 | 1.621 | 0.425 | 0.149 | - | - | 168 | - | - | - | 3.771 | 1.621 | 0.425 | 0.149 | - | -
5000 | - | - | - | 4.144 | 1.781 | 0.466 | 0.164 | - | - | 177 | - | - | - | 4.144 | 1.781 | 0.466 | 0.164 | - | -
5500 | - | - | - | 4.938 | 2.12 | 0.554 | 0.195 | - | - | 194 | - | - | - | 4.938 | 2.12 | 0.554 | 0.195 | - | -
6000 | - | - | - | 5.796 | 2.487 | 0.649 | 0.228 | 0.097 | - | 212 | - | - | - | 5.796 | 2.487 | 0.649 | 0.228 | 0.097 | -
6500 | - | - | - | - | 2.88 | 0.751 | 0.264 | 0.112 | - | 230 | - | - | - | - | 2.88 | 0.751 | 0.264 | 0.112 | -
7000 | - | - | - | - | 3.301 | 0.86 | 0.302 | 0.128 | - | 247 | - | - | - | - | 3.301 | 0.86 | 0.302 | 0.128 | -
7500 | - | - | - | - | 3.748 | 0.976 | 0.342 | 0.145 | - | 265 | - | - | - | - | 3.748 | 0.976 | 0.342 | 0.145 | -
8000 | - | - | - | - | 4.221 | 1.098 | 0.385 | 0.163 | - | 283 | - | - | - | - | 4.221 | 1.098 | 0.385 | 0.163 | -
8500 | - | - | - | - | 4.721 | 1.227 | 0.43 | 0.182 | 0.047 | 300 | - | - | - | - | 4.721 | 1.227 | 0.43 | 0.182 | 0.047
9000 | - | - | - | - | 5.247 | 1.363 | 0.477 | 0.202 | 0.052 | 318 | - | - | - | - | 5.247 | 1.363 | 0.477 | 0.202 | 0.052
9500 | - | - | - | - | - | 1.505 | 0.526 | 0.223 | 0.057 | 335 | - | - | - | - | - | 1.505 | 0.526 | 0.223 | 0.057
10000 | - | - | - | - | - | 1.653 | 0.578 | 0.244 | 0.063 | 353 | - | - | - | - | - | 1.653 | 0.578 | 0.244 | 0.063
10500 | - | - | - | - | - | 1.808 | 0.632 | 0.267 | 0.068 | 371 | - | - | - | - | - | 1.808 | 0.632 | 0.267 | 0.068
11000 | - | - | - | - | - | 1.97 | 0.688 | 0.291 | 0.074 | 388 | - | - | - | - | - | 1.97 | 0.688 | 0.291 | 0.074
11500 | - | - | - | - | - | 2.138 | 0.746 | 0.315 | 0.081 | 406 | - | - | - | - | - | 2.138 | 0.746 | 0.315 | 0.081
12000 | - | - | - | - | - | 2.312 | 0.807 | 0.341 | 0.087 | 424 | - | - | - | - | - | 2.312 | 0.807 | 0.341 | 0.087
13000 | - | - | - | - | - | 2.679 | 0.934 | 0.394 | 0.101 | 459 | - | - | - | - | - | 2.679 | 0.934 | 0.394 | 0.101