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: Nitrogen Flow Rate tab 

[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 Nitrogen at 185 psi gauge pressure and 68F |  |  |  |  |  |  |  |  |  | For Nitrogen at 185 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"
100 | 0.061 | - | - | - | - | - | - | - | - | 3.35 | 0.061 | - | - | - | - | - | - | - | -
150 | 0.123 | 0.024 | - | - | - | - | - | - | - | 5.3 | 0.123 | 0.024 | - | - | - | - | - | - | -
200 | 0.205 | 0.039 | - | - | - | - | - | - | - | 7.06 | 0.205 | 0.039 | - | - | - | - | - | - | -
250 | 0.303 | 0.058 | - | - | - | - | - | - | - | 8.83 | 0.303 | 0.058 | - | - | - | - | - | - | -
300 | 0.419 | 0.08 | - | - | - | - | - | - | - | 10.59 | 0.419 | 0.08 | - | - | - | - | - | - | -
350 | 0.552 | 0.105 | - | - | - | - | - | - | - | 12.36 | 0.552 | 0.105 | - | - | - | - | - | - | -
400 | 0.7 | 0.133 | - | - | - | - | - | - | - | 14.13 | 0.7 | 0.133 | - | - | - | - | - | - | -
450 | 0.864 | 0.164 | - | - | - | - | - | - | - | 15.89 | 0.864 | 0.164 | - | - | - | - | - | - | -
500 | 1.044 | 0.198 | - | - | - | - | - | - | - | 17.66 | 1.044 | 0.198 | - | - | - | - | - | - | -
600 | 1.448 | 0.274 | 0.069 | - | - | - | - | - | - | 21.19 | 1.448 | 0.274 | 0.069 | - | - | - | - | - | -
700 | 1.912 | 0.361 | 0.09 | - | - | - | - | - | - | 24.72 | 1.912 | 0.361 | 0.09 | - | - | - | - | - | -
800 | 2.434 | 0.458 | 0.114 | - | - | - | - | - | - | 28.25 | 2.434 | 0.458 | 0.114 | - | - | - | - | - | -
900 | 3.012 | 0.566 | 0.141 | - | - | - | - | - | - | 31.78 | 3.012 | 0.566 | 0.141 | - | - | - | - | - | -
1000 | 3.648 | 0.685 | 0.17 | - | - | - | - | - | - | 35.31 | 3.648 | 0.685 | 0.17 | - | - | - | - | - | -
1100 | 4.338 | 0.813 | 0.202 | 0.069 | - | - | - | - | - | 38.85 | 4.338 | 0.813 | 0.202 | 0.069 | - | - | - | - | -
1200 | 5.084 | 0.951 | 0.236 | 0.08 | - | - | - | - | - | 42.38 | 5.084 | 0.951 | 0.236 | 0.08 | - | - | - | - | -
1300 | 5.884 | 1.099 | 0.272 | 0.093 | - | - | - | - | - | 45.91 | 5.884 | 1.099 | 0.272 | 0.093 | - | - | - | - | -
1400 | 6.739 | 1.257 | 0.311 | 0.106 | - | - | - | - | - | 49.44 | 6.739 | 1.257 | 0.311 | 0.106 | - | - | - | - | -
1500 | 7.647 | 1.424 | 0.352 | 0.12 | 0.052 | - | - | - | - | 52.97 | 7.647 | 1.424 | 0.352 | 0.12 | 0.052 | - | - | - | -
1600 | 8.608 | 1.601 | 0.396 | 0.135 | 0.059 | - | - | - | - | 56.5 | 8.608 | 1.601 | 0.396 | 0.135 | 0.059 | - | - | - | -
1700 | 9.623 | 1.787 | 0.442 | 0.15 | 0.065 | - | - | - | - | 60.03 | 9.623 | 1.787 | 0.442 | 0.15 | 0.065 | - | - | - | -
1800 | 10.69 | 1.983 | 0.49 | 0.166 | 0.072 | - | - | - | - | 63.57 | 10.69 | 1.983 | 0.49 | 0.166 | 0.072 | - | - | - | -
1900 | 11.81 | 2.188 | 0.54 | 0.183 | 0.08 | - | - | - | - | 67.01 | 11.81 | 2.188 | 0.54 | 0.183 | 0.08 | - | - | - | -
2000 | 12.982 | 2.402 | 0.592 | 0.201 | 0.087 | 0.025 | - | - | - | 70.63 | 12.982 | 2.402 | 0.592 | 0.201 | 0.087 | 0.025 | - | - | -
2100 | 14.206 | 2.626 | 0.647 | 0.22 | 0.095 | 0.027 | - | - | - | 74.16 | 14.206 | 2.626 | 0.647 | 0.22 | 0.095 | 0.027 | - | - | -
2200 | 15.482 | 2.859 | 0.704 | 0.239 | 0.104 | 0.029 | - | - | - | 77.69 | 15.482 | 2.859 | 0.704 | 0.239 | 0.104 | 0.029 | - | - | -
2300 | 16.81 | 3.1 | 0.763 | 0.259 | 0.112 | 0.032 | - | - | - | 81.22 | 16.81 | 3.1 | 0.763 | 0.259 | 0.112 | 0.032 | - | - | -
2400 | 18.19 | 3.351 | 0.824 | 0.279 | 0.121 | 0.034 | - | - | - | 84.76 | 18.19 | 3.351 | 0.824 | 0.279 | 0.121 | 0.034 | - | - | -
2500 | 19.62 | 3.611 | 0.887 | 0.301 | 0.13 | 0.04 | - | - | - | 88.29 | 19.62 | 3.611 | 0.887 | 0.301 | 0.13 | 0.04 | - | - | -
2750 | - | 4.301 | 1.055 | 0.357 | 0.155 | 0.047 | - | - | - | 97.12 | - | 4.301 | 1.055 | 0.357 | 0.155 | 0.047 | - | - | -
3000 | - | 5.046 | 1.236 | 0.418 | 0.181 | 0.054 | - | - | - | 105.94 | - | 5.046 | 1.236 | 0.418 | 0.181 | 0.054 | - | - | -
3250 | - | 5.846 | 1.43 | 0.483 | 0.209 | 0.062 | - | - | - | 114.77 | - | 5.846 | 1.43 | 0.483 | 0.209 | 0.062 | - | - | -
3500 | - | 6.702 | 1.637 | 0.553 | 0.239 | 0.07 | 0.025 | - | - | 123.6 | - | 6.702 | 1.637 | 0.553 | 0.239 | 0.07 | 0.025 | - | -
3750 | - | 7.612 | 1.857 | 0.627 | 0.271 | 0.079 | 0.028 | - | - | 132.43 | - | 7.612 | 1.857 | 0.627 | 0.271 | 0.079 | 0.028 | - | -
4000 | - | 8.576 | 2.09 | 0.705 | 0.304 | 0.088 | 0.031 | - | - | 141.26 | - | 8.576 | 2.09 | 0.705 | 0.304 | 0.088 | 0.031 | - | -
4250 | - | 9.594 | 2.336 | 0.787 | 0.34 | 0.098 | 0.034 | - | - | 150.09 | - | 9.594 | 2.336 | 0.787 | 0.34 | 0.098 | 0.034 | - | -
4500 | - | 10.667 | 2.594 | 0.873 | 0.377 | 0.108 | 0.038 | - | - | 158.92 | - | 10.667 | 2.594 | 0.873 | 0.377 | 0.108 | 0.038 | - | -
4750 | - | 11.792 | 2.864 | 0.964 | 0.416 | 0.118 | 0.042 | - | - | 167.74 | - | 11.792 | 2.864 | 0.964 | 0.416 | 0.118 | 0.042 | - | -
5000 | - | 12.971 | 3.148 | 1.058 | 0.456 | 0.141 | 0.049 | - | - | 176.57 | - | 12.971 | 3.148 | 1.058 | 0.456 | 0.141 | 0.049 | - | -
6000 | - | 15.489 | 3.751 | 1.26 | 0.543 | 0.165 | 0.058 | - | - | 211.89 | - | 15.489 | 3.751 | 1.26 | 0.543 | 0.165 | 0.058 | - | -
6500 | - | 18.219 | 4.404 | 1.477 | 0.636 | 0.19 | 0.067 | - | - | 229.55 | - | 18.219 | 4.404 | 1.477 | 0.636 | 0.19 | 0.067 | - | -
7000 | - | - | 5.106 | 1.711 | 0.736 | 0.218 | 0.076 | - | - | 247.2 | - | - | 5.106 | 1.711 | 0.736 | 0.218 | 0.076 | - | -
7500 | - | - | 5.857 | 1.96 | 0.843 | 0.247 | 0.086 | - | - | 264.86 | - | - | 5.857 | 1.96 | 0.843 | 0.247 | 0.086 | - | -
8000 | - | - | 6.655 | 2.225 | 0.956 | 0.277 | 0.097 | - | - | 282.52 | - | - | 6.655 | 2.225 | 0.956 | 0.277 | 0.097 | - | -
8500 | - | - | 7.502 | 2.506 | 1.077 | 0.31 | 0.108 | - | - | 300.17 | - | - | 7.502 | 2.506 | 1.077 | 0.31 | 0.108 | - | -
9000 | - | - | 8.397 | 2.803 | 1.203 | 0.344 | 0.12 | - | - | 317.83 | - | - | 8.397 | 2.803 | 1.203 | 0.344 | 0.12 | - | -
9500 | - | - | 9.339 | 3.114 | 1.336 | 0.379 | 0.133 | - | - | 335.49 | - | - | 9.339 | 3.114 | 1.336 | 0.379 | 0.133 | - | -
10000 | - | - | 10.329 | 3.441 | 1.476 | 0.417 | 0.145 | - | - | 353.15 | - | - | 10.329 | 3.441 | 1.476 | 0.417 | 0.145 | - | -
10500 | - | - | 11.366 | 3.784 | 1.622 | 0.456 | 0.159 | - | - | 370.8 | - | - | 11.366 | 3.784 | 1.622 | 0.456 | 0.159 | - | -
11000 | - | - | 12.451 | 4.142 | 1.774 | 0.496 | 0.173 | 0.074 | - | 388.46 | - | - | 12.451 | 4.142 | 1.774 | 0.496 | 0.173 | 0.074 | -
11500 | - | - | 13.582 | 4.512 | 1.933 | 0.538 | 0.188 | 0.08 | - | 406.12 | - | - | 13.582 | 4.512 | 1.933 | 0.538 | 0.188 | 0.08 | -
12000 | - | - | 14.761 | 4.903 | 2.098 | 0.582 | 0.203 | 0.086 | - | 423.78 | - | - | 14.761 | 4.903 | 2.098 | 0.582 | 0.203 | 0.086 | -
13000 | - | - | 15.986 | 5.306 | 2.269 | 0.674 | 0.235 | 0.01 | - | 459.09 | - | - | 15.986 | 5.306 | 2.269 | 0.674 | 0.235 | 0.01 | -
14000 | - | - | 18.577 | 6.157 | 2.631 | 0.772 | 0.269 | 0.114 | - | 494.41 | - | - | 18.577 | 6.157 | 2.631 | 0.772 | 0.269 | 0.114 | -
15000 | - | - | 21.354 | 7.068 | 3.018 | 0.876 | 0.305 | 0.129 | - | 529.72 | - | - | 21.354 | 7.068 | 3.018 | 0.876 | 0.305 | 0.129 | -
16000 | - | - | - | 8.039 | 3.43 | 0.986 | 0.343 | 0.145 | - | 565.03 | - | - | - | 8.039 | 3.43 | 0.986 | 0.343 | 0.145 | -
17000 | - | - | - | 9.069 | 3.866 | 1.103 | 0.383 | 0.162 | - | 600.35 | - | - | - | 9.069 | 3.866 | 1.103 | 0.383 | 0.162 | -
18000 | - | - | - | 10.158 | 4.327 | 1.225 | 0.425 | 0.18 | - | 635.66 | - | - | - | 10.158 | 4.327 | 1.225 | 0.425 | 0.18 | -
19000 | - | - | - | 11.306 | 4.812 | 1.354 | 0.47 | 0.199 | - | 670.98 | - | - | - | 11.306 | 4.812 | 1.354 | 0.47 | 0.199 | -
20000 | - | - | - | 13.778 | 5.856 | 1.488 | 0.516 | 0.218 | - | 706.29 | - | - | - | 13.778 | 5.856 | 1.488 | 0.516 | 0.218 | -
21000 | - | - | - | 15.102 | 6.415 | 1.629 | 0.564 | 0.239 | - | 741.61 | - | - | - | 15.102 | 6.415 | 1.629 | 0.564 | 0.239 | -
22000 | - | - | - | 16.484 | 6.997 | 1.775 | 0.615 | 0.26 | - | 776.92 | - | - | - | 16.484 | 6.997 | 1.775 | 0.615 | 0.26 | -
23000 | - | - | - | 17.924 | 7.604 | 1.928 | 0.667 | 0.282 | - | 812.24 | - | - | - | 17.924 | 7.604 | 1.928 | 0.667 | 0.282 | -
24000 | - | - | - | 19.422 | 8.235 | 2.086 | 0.722 | 0.305 | 0.078 | 847.55 | - | - | - | 19.422 | 8.235 | 2.086 | 0.722 | 0.305 | 0.078
26000 | - | - | - | - | 9.568 | 2.42 | 0.836 | 0.353 | 0.09 | 918.18 | - | - | - | - | 9.568 | 2.42 | 0.836 | 0.353 | 0.09
28000 | - | - | - | - | 10.997 | 2.777 | 0.959 | 0.405 | 0.103 | 988.81 | - | - | - | - | 10.997 | 2.777 | 0.959 | 0.405 | 0.103
30000 | - | - | - | - | 12.521 | 3.157 | 1.089 | 0.46 | 0.117 | 1059.44 | - | - | - | - | 12.521 | 3.157 | 1.089 | 0.46 | 0.117
32000 | - | - | - | - | 14.14 | 3.561 | 1.227 | 0.518 | 0.131 | 1130.07 | - | - | - | - | 14.14 | 3.561 | 1.227 | 0.518 | 0.131
34000 | - | - | - | - | 15.853 | 3.987 | 1.373 | 0.579 | 0.147 | 1200.7 | - | - | - | - | 15.853 | 3.987 | 1.373 | 0.579 | 0.147
36000 | - | - | - | - | 17.661 | 4.436 | 1.527 | 0.643 | 0.163 | 1271.33 | - | - | - | - | 17.661 | 4.436 | 1.527 | 0.643 | 0.163
38000 | - | - | - | - | 19.563 | 4.908 | 1.688 | 0.711 | 0.18 | 1341.96 | - | - | - | - | 19.563 | 4.908 | 1.688 | 0.711 | 0.18
40000 | - | - | - | - | 21.559 | 5.403 | 1.857 | 0.781 | 0.197 | 1412.59 | - | - | - | - | 21.559 | 5.403 | 1.857 | 0.781 | 0.197
42000 | - | - | - | - | - | 5.921 | 2.033 | 0.855 | 0.216 | 1483.22 | - | - | - | - | - | 5.921 | 2.033 | 0.855 | 0.216
44000 | - | - | - | - | - | 6.461 | 2.217 | 0.932 | 0.235 | 1553.85 | - | - | - | - | - | 6.461 | 2.217 | 0.932 | 0.235