Spreadsheet: 130042d1322044223-use-of-vlookup-for-a-range-of-values-pipetst
Sheet: refdt

 |  | Stress Values (PSI ) at [NAME] (degree F ) |  |  |  |  |  |  |  |  | Pipe |  | Outside Diameter |  | Identification |  |  | Wall Thickness
 | Material | 100 | 200 | 300 | 400 |  |  |  |  |  | Size |  | (inches) |  | Steel |  | Stainless Steel Schedule No. | - t -
 | A 516 Gr. 70-A671 | 23300 | 23100 | 22500 | 21700 |  |  |  |  |  | (inches) |  |  |  | Iron Pipe Size | Schedule No. |  | (inches)
 | A 515 Gr. 70-A671 | 23300 | 23100 | 22500 | 21700 |  |  |  |  |  | 0.125 | 0.125 | 0.405 | 0.405 | . | . | 10S | 0.049
 | A 516 Gr. 70-A672 | 23300 | 23100 | 22500 | 22900 |  |  |  |  |  |  | 0.125 |  | 0.405 | STD | 40 | 40S | 0.068
 | A 515 Gr. 70-A672 | 23300 | 23300 | 23300 | 22900 |  |  |  |  |  |  | 0.125 |  | 0.405 | XS | 80 | 80S | 0.095
 | TP 304-A312 | 20000 | 20000 | 20000 | 20000 |  |  |  |  |  | 0.25 | 0.25 | 0.54 | 0.54 | . | . | 10S | 0.065
 | TP 316-A312 | 20000 | 20000 | 20000 | 19300 |  |  |  |  |  |  | 0.25 |  | 0.54 | STD | 40 | 40S | 0.088
 |  |  |  |  |  |  |  |  |  |  |  | 0.25 |  | 0.54 | XS | 80 | 80S | 0.119
 |  |  |  |  |  |  |  |  |  |  | 0.375 | 0.375 | 0.675 | 0.675 | . | . | 10S | 0.065
 | [NAME] | O.D |  |  |  |  |  |  |  |  |  | 0.375 |  | 0.675 | STD | 40 | 40S | 0.091
 | 0.125 | 0.405 |  |  |  |  |  |  |  |  |  | 0.375 |  | 0.675 | XS | 80 | 80S | 0.126
 | 0.25 | 0.54 |  |  |  |  |  |  |  |  | 0.5 | 0.5 | 0.84 | 0.84 | . | . | 5S | 0.065
 | 0.375 | 0.675 |  |  |  |  |  |  |  |  |  | 0.5 |  | 0.84 | . | . | 10S | 0.083
 | 0.5 | 0.84 |  |  |  |  |  |  |  |  |  | 0.5 |  | 0.84 | STD | 40 | 40S | 0.109
 | 0.75 | 1.05 |  |  |  |  |  |  |  |  |  | 0.5 |  | 0.84 | XS | 80 | 80S | 0.147
 | 1 | 1.315 |  |  |  |  |  |  |  |  |  | 0.5 |  | 0.84 | . | 160 | . | 0.187
 | 1.25 | 1.66 |  |  |  |  |  |  |  |  |  | 0.5 |  | 0.84 | [NAME] | . | . | 0.294
 | 1.5 | 1.9 |  |  |  |  |  |  |  |  | 0.75 | 0.75 | 1.05 | 1.05 | . | . | 5S | 0.065
 | 2 | 2.375 |  |  |  |  |  |  |  |  |  | 0.75 |  | 1.05 | . | . | 10S | 0.083
 | 2.5 | 2.875 |  |  |  |  |  |  |  |  |  | 0.75 |  | 1.05 | STD | 40 | 40S | 0.113
 | 3 | 3.5 |  |  |  |  |  |  |  |  |  | 0.75 |  | 1.05 | XS | 80 | 80S | 0.154
 | 3.5 | 4 |  |  |  |  |  |  |  |  |  | 0.75 |  | 1.05 | . | 160 | . | 0.219
 | 4 | 4.5 |  |  |  |  |  |  |  |  |  | 0.75 |  | 1.05 | [NAME] | . | . | 0.308
 | 5 | 5.5625 |  |  |  |  |  |  |  |  | 1 | 1 | 1.315 | 1.315 | . | . | 5S | 0.065
 | 6 | 6.625 |  |  |  |  |  |  |  |  |  | 1 |  | 1.315 | . | . | 10S | 0.109
 | 8 | 8.625 |  |  |  |  |  |  |  |  |  | 1 |  | 1.315 | STD | 40 | 40S | 0.133
 | 10 | 10.75 |  |  |  |  |  |  |  |  |  | 1 |  | 1.315 | XS | 80 | 80S | 0.179
 | 12 | 12.75 |  |  |  |  |  |  |  |  |  | 1 |  | 1.315 | . | 160 | . | 0.25
 | 14 | 14 |  |  |  |  |  |  |  |  |  | 1 |  | 1.315 | [NAME] | . | . | 0.358
 | 16 | 16 |  |  |  |  |  |  |  |  | 1.25 | 1.25 | 1.66 | 1.66 | . | . | 5S | 0.065
 | 18 | 18 |  |  |  |  |  |  |  |  |  | 1.25 |  | 1.66 | . | . | 10S | 0.109
 |  |  |  |  |  |  |  |  |  |  |  | 1.25 |  | 1.66 | STD | 40 | 40S | 0.14
 |  |  |  |  |  |  |  |  |  |  |  | 1.25 |  | 1.66 | XS | 80 | 80S | 0.191
 |  |  |  |  |  |  |  |  |  |  |  | 1.25 |  | 1.66 | . | 160 | . | 0.25
 |  |  |  |  |  |  |  |  |  |  |  | 1.25 |  | 1.66 | [NAME] | . | . | 0.382
 |  |  |  |  |  |  |  |  |  |  | 1.5 | 1.5 | 1.9 | 1.9 | . | . | 5S | 0.065
 |  |  |  |  |  |  |  |  |  |  |  | 1.5 |  | 1.9 | . | . | 10S | 0.109
 |  |  |  |  |  |  |  |  |  |  |  | 1.5 |  | 1.9 | STD | 40 | 40S | 0.145
 |  |  |  |  |  |  |  |  |  |  |  | 1.5 |  | 1.9 | XS | 80 | 80S | 0.2
 |  |  |  |  |  |  |  |  |  |  |  | 1.5 |  | 1.9 | . | 160 | . | 0.281
 |  |  |  |  |  |  |  |  |  |  |  | 1.5 |  | 1.9 | [NAME] | . | . | 0.4
 |  |  |  |  |  |  |  |  |  |  | 2 | 2 | 2.375 | 2.375 | . | . | 5S | 0.065
 |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 2.375 | . | . | 10S | 0.109
 |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 2.375 | STD | 40 | 40S | 0.154
 |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 2.375 | XS | 80 | 80S | 0.218
 |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 2.375 | . | 160 | . | 0.344
 |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 2.375 | [NAME] | . | . | 0.436
 |  |  |  |  |  |  |  |  |  |  | 2.5 | 2.5 | 2.875 | 2.875 | . | . | 5S | 0.083
 |  |  |  |  |  |  |  |  |  |  |  | 2.5 |  | 2.875 | . | . | 10S | 0.12
 |  |  |  |  |  |  |  |  |  |  |  | 2.5 |  | 2.875 | STD | 40 | 40S | 0.203
 |  |  |  |  |  |  |  |  |  |  |  | 2.5 |  | 2.875 | XS | 80 | 80S | 0.276
 |  |  |  |  |  |  |  |  |  |  |  | 2.5 |  | 2.875 | . | 160 | . | 0.375
 |  |  |  |  |  |  |  |  |  |  |  | 2.5 |  | 2.875 | [NAME] | . | . | 0.552
 |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 3.5 | 3.5 | . | . | 5S | 0.083
 |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 3.5 | . | . | 10S | 0.12
 |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 3.5 | STD | 40 | 40S | 0.216
 |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 3.5 | XS | 80 | 80S | 0.3
 |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 3.5 | . | 160 | . | 0.438
 |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 3.5 | [NAME] | . | . | 0.6
 |  |  |  |  |  |  |  |  |  |  | 3.5 | 3.5 | 4 | 4 | . | . | 5S | 0.083
 |  |  |  |  |  |  |  |  |  |  |  | 3.5 |  | 4 | . | . | 10S | 0.12
 |  |  |  |  |  |  |  |  |  |  |  | 3.5 |  | 4 | STD | 40 | 40S | 0.226
 |  |  |  |  |  |  |  |  |  |  |  | 3.5 |  | 4 | XS | 80 | 80S | 0.318
 |  |  |  |  |  |  |  |  |  |  | 4 | 4 | 4.5 | 4.5 | . | . | 5S | 0.083
 |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 4.5 | . | . | 10S | 0.12
 |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 4.5 | STD | 40 | 40S | 0.237
 |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 4.5 | XS | 80 | 80S | 0.337
 |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 4.5 | . | 120 | . | 0.438
 |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 4.5 | . | 160 | . | 0.531
 |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 4.5 | [NAME] | . | . | 0.674
 |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5.5625 | 5.5625 | . | . | 5S | 0.109
 |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 5.5625 | . | . | 10S | 0.134
 |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 5.5625 | STD | 40 | 40S | 0.258
 |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 5.5625 | XS | 80 | 80S | 0.375
 |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 5.5625 | . | 120 | . | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 5.5625 | . | 160 | . | 0.625
 |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 5.5625 | [NAME] | . | . | 0.75
 |  |  |  |  |  |  |  |  |  |  | 6 | 6 | 6.625 | 6.625 | . | . | 5S | 0.109
 |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 6.625 | . | . | 10S | 0.134
 |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 6.625 | STD | 40 | 40S | 0.28
 |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 6.625 | XS | 80 | 80S | 0.432
 |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 6.625 | . | 120 | . | 0.562
 |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 6.625 | . | 160 | . | 0.718
 |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 6.625 | [NAME] | . | . | 0.864
 |  |  |  |  |  |  |  |  |  |  | 8 | 8 | 8.625 | 8.625 | . | . | 5S | 0.109
 |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8.625 | . | . | 10S | 0.148
 |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8.625 | . | 20 | . | 0.25
 |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8.625 | . | 30 | . | 0.277
 |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8.625 | STD | 40 | 40S | 0.322
 |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8.625 | . | 60 | . | 0.406
 |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8.625 | XS | 80 | 80S | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8.625 | . | 100 | . | 0.594
 |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8.625 | . | 120 | . | 0.719
 |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8.625 | . | 140 | . | 0.812
 |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8.625 | [NAME] | . | . | 0.875
 |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 8.625 | . | 160 | . | 0.906
 |  |  |  |  |  |  |  |  |  |  | 10 | 10 | 10.75 | 10.75 | . | . | 5S | 0.134
 |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10.75 | . | . | 10S | 0.165
 |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10.75 | . | 20 | . | 0.25
 |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10.75 | . | 30 | . | 0.307
 |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10.75 | STD | 40 | 40S | 0.365
 |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10.75 | XS | 60 | 80S | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10.75 | . | 80 | . | 0.594
 |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10.75 | . | 100 | . | 0.719
 |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10.75 | . | 120 | . | 0.844
 |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10.75 | . | 140 | . | 1
 |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 10.75 | . | 160 | . | 1.125
 |  |  |  |  |  |  |  |  |  |  | 12 | 12 | 12.75 | 12.75 | . | . | 5S | 0.156
 |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 12.75 | . | . | 10S | 0.18
 |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 12.75 | . | 20 | . | 0.25
 |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 12.75 | . | 30 | . | 0.33
 |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 12.75 | STD | . | 40S | 0.375
 |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 12.75 | . | 40 | . | 0.406
 |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 12.75 | XS | . | 80S | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 12.75 | . | 60 | . | 0.562
 |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 12.75 | . | 80 | . | 0.688
 |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 12.75 | . | 100 | . | 0.844
 |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 12.75 | . | 120 | . | 1
 |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 12.75 | . | 140 | . | 1.125
 |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 12.75 | . | 160 | . | 1.312
 |  |  |  |  |  |  |  |  |  |  | 14 | 14 | 14 | 14 | . | . | 5S | 156
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 14 | . | . | 10S | 0.188
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 14 | . | 10 | . | 0.25
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 14 | . | 20 | . | 0.312
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 14 | STD | 30 | . | 0.375
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 14 | . | 40 | . | 0.438
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 14 | XS | . | . | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 14 | . | 60 | . | 0.594
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 14 | . | 80 | . | 0.75
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 14 | . | 100 | . | 0.938
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 14 | . | 120 | . | 1.094
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 14 | . | 140 | . | 1.25
 |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 14 | .. | 160 | . | 1.406
 |  |  |  |  |  |  |  |  |  |  | 16 | 16 | 16 | 16 | . | . | 5S | 0.165
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 16 | . | . | 10S | 0.188
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 16 | . | 10 | . | 0.25
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 16 | . | 20 | . | 0.312
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 16 | STD | 30 | . | 0.375
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 16 | XS | 40 | . | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 16 | . | 60 | . | 0.656
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 16 | . | 80 | . | 0.844
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 16 | . | 100 | . | 1.031
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 16 | . | 120 | . | 1.219
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 16 | . | 140 | . | 1.438
 |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 16 | . | 160 | . | 1.594
 |  |  |  |  |  |  |  |  |  |  | 18 | 18 | 18 | 18 | . | . | 5S | 0.165
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 18 | . | . | 10S | 0.188
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 18 | . | 10 | . | 0.25
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 18 | . | 20 | . | 0.312
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 18 | STD | . | . | 0.375
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 18 | . | 30 | . | 0.438
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 18 | XS | . | . | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 18 | . | 40 | . | 0.562
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 18 | . | 60 | . | 0.75
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 18 | . | 80 | . | 0.938
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 18 | . | 100 | . | 1.156
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 18 | . | 120 | . | 1.375
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 18 | . | 140 | . | 1.562
 |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 18 | . | 160 | . | 1.781