Spreadsheet: 130250d1322141644-use-of-vlookup-for-a-range-of-values-pipetst-2-
Sheet: refdt

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