Spreadsheet: 128940d1321369083-conditional-vlookup-index-with-if-formula-rev1-pipe-for-big-resource_jpr73
Sheet: PipeOD

Diameter Nominal Bore | O.D. | Pipe Thicknesses |  |  |  |  |  |  |  |  |  |  |  |  | Calculation Purposes
D.N.B.(inches) | O.D.(mm) | SHD Code | SHD | SHD S | WT (Inch) | WT (mm) |  |  |  |  |  |  |  |  | Computational Purposes
1/8" | 10.3 |  |  | 10S | 0.049 | 1.24
1/8" | 10.3 | STD | 40 | 40S | 0.068 | 1.73
1/8" | 10.3 | XS | 80 | 80S | 0.095 | 2.41
1/4" | 13.7 |  |  | 10S | 0.065 | 1.65
1/4" | 13.7 | STD | 40 | 40S | 0.088 | 2.24
1/4" | 13.7 | XS | 80 | 80S | 0.119 | 3.02
3/8" | 17.1 |  |  | 10S | 0.065 | 1.65
3/8" | 17.1 | STD | 40 | 40S | 0.091 | 2.31
3/8" | 17.1 | XS | 80 | 80S | 0.126 | 3.2
1/2" | 21.3 |  |  | 5S | 0.065 | 1.65
1/2" | 21.3 |  |  | 10S | 0.083 | 2.11
1/2" | 21.3 | STD | 40 | 40S | 0.109 | 2.77
1/2" | 21.3 | XS | 80 | 80S | 0.147 | 3.73
1/2" | 21.3 |  | 160 |  | 0.188 | 4.78
1/2" | 21.3 | [NAME] |  |  | 0.294 | 7.47
3/4" | 26.7 |  |  | 5S | 0.065 | 1.65
3/4" | 26.7 |  |  | 10S | 0.083 | 2.11
3/4" | 26.7 | STD | 40 | 40S | 0.113 | 2.87
3/4" | 26.7 | XS | 80 | 80S | 0.154 | 3.91
3/4" | 26.7 |  | 160 |  | 0.219 | 5.56
3/4" | 26.7 | [NAME] |  |  | 0.308 | 7.82
1" | 33.4 |  |  | 5S | 0.065 | 1.65
1" | 33.4 |  |  | 10S | 0.109 | 2.77
1" | 33.4 | STD | 40 | 40S | 0.133 | 3.38
1" | 33.4 | XS | 80 | 80S | 0.179 | 4.55
1" | 33.4 |  | 160 |  | 0.25 | 6.35
1" | 33.4 | [NAME] |  |  | 0.358 | 9.09
1 1/4" | 42.2 |  |  | 5S | 0.065 | 1.65
1 1/4" | 42.2 |  |  | 10S | 0.109 | 2.77
1 1/4" | 42.2 | STD | 40 | 40S | 0.14 | 3.56
1 1/4" | 42.2 | XS | 80 | 80S | 0.191 | 4.85
1 1/4" | 42.2 |  | 160 |  | 0.25 | 6.35
1 1/4" | 42.2 | [NAME] |  |  | 0.382 | 9.7
1 1/2" | 48.3 |  |  | 5S | 0.065 | 1.65
1 1/2" | 48.3 |  |  | 10S | 0.109 | 2.77
1 1/2" | 48.3 | STD | 40 | 40S | 0.145 | 3.68
1 1/2" | 48.3 | XS | 80 | 80S | 0.2 | 5.08
1 1/2" | 48.3 |  | 160 |  | 0.281 | 7.14
1 1/2" | 48.3 | [NAME] |  |  | 0.4 | 10.15
2" | 60.3 |  |  | 5S | 0.065 | 1.65
2" | 60.3 |  |  |  | 0.083 | 2.11
2" | 60.3 |  |  | 10S | 0.109 | 2.77
2" | 60.3 |  |  |  | 0.125 | 3.18
2" | 60.3 |  |  |  | 0.141 | 3.58
2" | 60.3 | STD | 40 | 40S | 0.154 | 3.91
2" | 60.3 |  |  |  | 0.172 | 4.37
2" | 60.3 |  |  |  | 0.188 | 4.78
2" | 60.3 | XS | 80 | 80S | 0.218 | 5.54
2" | 60.3 |  |  |  | 0.25 | 6.35
2" | 60.3 |  |  |  | 0.281 | 7.14
2" | 60.3 |  | 160 |  | 0.344 | 8.74
2" | 60.3 | [NAME] |  |  | 0.436 | 11.07
2 1/2" | 73 |  |  | 5S | 0.083 | 2.11
2 1/2" | 73 |  |  |  | 0.109 | 2.77
2 1/2" | 73 |  |  | 10S | 0.12 | 3.05
2 1/2" | 73 |  |  |  | 0.125 | 3.18
2 1/2" | 73 |  |  |  | 0.141 | 3.58
2 1/2" | 73 |  |  |  | 0.156 | 3.96
2 1/2" | 73 |  |  |  | 0.172 | 4.37
2 1/2" | 73 |  |  |  | 0.188 | 4.78
2 1/2" | 73 | STD | 40 | 40S | 0.203 | 5.16
2 1/2" | 73 |  |  |  | 0.216 | 5.49
2 1/2" | 73 |  |  |  | 0.25 | 6.35
2 1/2" | 73 | XS | 80 | 80S | 0.276 | 7.01
2 1/2" | 73 |  | 160 |  | 0.375 | 9.53
2 1/2" | 73 | [NAME] |  |  | 0.552 | 14.02
3" | 88.9 |  |  | 5S | 0.083 | 2.11
3" | 88.9 |  |  |  | 0.109 | 2.77
3" | 88.9 |  |  | 10S | 0.12 | 3.05
3" | 88.9 |  |  |  | 0.125 | 3.18
3" | 88.9 |  |  |  | 0.141 | 3.58
3" | 88.9 |  |  |  | 0.156 | 3.96
3" | 88.9 |  |  |  | 0.172 | 4.37
3" | 88.9 |  |  |  | 0.188 | 4.78
3" | 88.9 | STD | 40 | 40S | 0.216 | 5.49
3" | 88.9 |  |  |  | 0.25 | 6.35
3" | 88.9 |  |  |  | 0.281 | 7.14
3" | 88.9 | XS | 80 | 80S | 0.3 | 7.62
3" | 88.9 |  | 160 |  | 0.438 | 11.13
3" | 88.9 | [NAME] |  |  | 0.6 | 15.24
3 1/2" | 101.6 |  |  | 5S | 0.083 | 2.11
3 1/2" | 101.6 |  |  |  | 0.109 | 2.77
3 1/2" | 101.6 |  |  | 10S | 0.12 | 3.05
3 1/2" | 101.6 |  |  |  | 0.125 | 3.18
3 1/2" | 101.6 |  |  |  | 0.141 | 3.58
3 1/2" | 101.6 |  |  |  | 0.156 | 3.96
3 1/2" | 101.6 |  |  |  | 0.172 | 4.37
3 1/2" | 101.6 |  |  |  | 0.188 | 4.78
3 1/2" | 101.6 | STD | 40 | 40S | 0.226 | 5.74
3 1/2" | 101.6 |  |  |  | 0.25 | 6.35
3 1/2" | 101.6 |  |  |  | 0.281 | 7.14
3 1/2" | 101.6 | XS | 80 | 80S | 0.318 | 8.08
3 1/2" | 101.6 | [NAME] |  |  | 0.636 | 16.15
4" | 114.3 |  |  | 5S | 0.083 | 2.11
4" | 114.3 |  |  |  | 0.109 | 2.77
4" | 114.3 |  |  | 10S | 0.12 | 3.05
4" | 114.3 |  |  |  | 0.125 | 3.18
4" | 114.3 |  |  |  | 0.141 | 3.58
4" | 114.3 |  |  |  | 0.156 | 3.96
4" | 114.3 |  |  |  | 0.172 | 4.37
4" | 114.3 |  |  |  | 0.188 | 4.78
4" | 114.3 |  |  |  | 0.203 | 5.16
4" | 114.3 |  |  |  | 0.219 | 5.56
4" | 114.3 | STD | 40 | 40S | 0.237 | 6.02
4" | 114.3 |  |  |  | 0.25 | 6.35
4" | 114.3 |  |  |  | 0.281 | 7.14
4" | 114.3 |  |  |  | 0.312 | 7.92
4" | 114.3 | XS | 80 | 80S | 0.337 | 8.56
4" | 114.3 |  | 120 |  | 0.438 | 11.13
4" | 114.3 |  | 160 |  | 0.531 | 13.49
4" | 114.3 | [NAME] |  |  | 0.674 | 17.12
5" | 141.3 |  |  |  | 0.083 | 2.11
5" | 141.3 |  |  | 5S | 0.109 | 2.77
5" | 141.3 |  |  |  | 0.125 | 3.18
5" | 141.3 |  |  | 10S | 0.134 | 3.4
5" | 141.3 |  |  |  | 0.156 | 3.96
5" | 141.3 |  |  |  | 0.188 | 4.78
5" | 141.3 |  |  |  | 0.219 | 5.56
5" | 141.3 | STD | 40 | 40S | 0.258 | 6.55
5" | 141.3 |  |  |  | 0.281 | 7.14
5" | 141.3 |  |  |  | 0.312 | 7.92
5" | 141.3 |  |  |  | 0.344 | 8.74
5" | 141.3 | XS | 80 | 80S | 0.375 | 9.53
5" | 141.3 |  | 120 |  | 0.5 | 12.7
5" | 141.3 |  | 160 |  | 0.625 | 15.88
5" | 141.3 | [NAME] |  |  | 0.75 | 19.05
6" | 168.3 |  |  |  | 0.083 | 2.11
6" | 168.3 |  |  | 5S | 0.109 | 2.77
6" | 168.3 |  |  |  | 0.125 | 3.18
6" | 168.3 |  |  | 10S | 0.134 | 3.4
6" | 168.3 |  |  |  | 0.141 | 3.58
6" | 168.3 |  |  |  | 0.156 | 3.96
6" | 168.3 |  |  |  | 0.172 | 4.37
6" | 168.3 |  |  |  | 0.188 | 4.78
6" | 168.3 |  |  |  | 0.203 | 5.16
6" | 168.3 |  |  |  | 0.219 | 5.56
6" | 168.3 |  |  |  | 0.25 | 6.35
6" | 168.3 | STD | 40 | 40S | 0.28 | 7.11
6" | 168.3 |  |  |  | 0.312 | 7.92
6" | 168.3 |  |  |  | 0.344 | 8.74
6" | 168.3 |  |  |  | 0.375 | 9.53
6" | 168.3 | XS | 80 | 80S | 0.432 | 10.97
6" | 168.3 |  |  |  | 0.5 | 12.7
6" | 168.3 |  | 120 |  | 0.562 | 14.27
6" | 168.3 |  |  |  | 0.625 | 15.88
6" | 168.3 |  | 160 |  | 0.719 | 18.26
6" | 168.3 |  |  |  | 0.75 | 19.05
6" | 168.3 | [NAME] |  |  | 0.864 | 21.95
6" | 168.3 |  |  |  | 0.875 | 22.23
8" | 219.1 |  |  | 5S | 0.1409 | 2.77
8" | 219.1 |  |  |  | 0.125 | 3.18
8" | 219.1 |  |  | 10S | 0.148 | 3.76
8" | 219.1 |  |  |  | 0.156 | 3.96
8" | 219.1 |  |  |  | 0.188 | 4.78
8" | 219.1 |  |  |  | 0.203 | 5.16
8" | 219.1 |  |  |  | 2.19 | 5.56
8" | 219.1 |  | 20 |  | 0.25 | 6.35
8" | 219.1 |  | 30 |  | 0.277 | 7.04
8" | 219.1 |  |  |  | 0.312 | 7.92
8" | 219.1 | STD | 40 | 40S | 0.322 | 8.18
8" | 219.1 |  |  |  | 0.344 | 8.74
8" | 219.1 |  |  |  | 0.375 | 9.53
8" | 219.1 |  | 60 |  | 0.406 | 10.31
8" | 219.1 |  |  |  | 0.438 | 11.13
8" | 219.1 | XS | 80 | 80S | 0.5 | 12.7
8" | 219.1 |  |  |  | 0.562 | 14.27
8" | 219.1 |  | 100 |  | 0.594 | 15.09
8" | 219.1 |  |  |  | 0.625 | 15.88
8" | 219.1 |  | 120 |  | 0.719 | 18.26
8" | 219.1 |  |  |  | 0.75 | 19.05
8" | 219.1 |  | 140 |  | 0.812 | 20.62
8" | 219.1 | [NAME] |  |  | 0.875 | 22.23
8" | 219.1 |  | 160 |  | 0.906 | 23.01
8" | 219.1 |  |  |  | 1 | 25.4