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

 | t | nominal wall thickness |  |  |  |  |  |  |  | Pipe |  | Wall Thickness
 | P | Design Pressure |  |  |  |  |  |  |  | Size |  | - t -
 | D | outside diameter |  |  |  |  |  |  |  | (inches) | Schedule No. | (inches)
 | S | allowable tensile stress at temperature |  |  |  |  |  |  |  | 0.125 | - | 0.049
 | E | ASME code B31.3 Table A-1A ( Londitudinal efficiency) |  |  |  |  |  |  |  |  | 40 | 0.068
 | W | Weld Joint reduction factor |  |  |  |  |  |  |  |  | 80 | 0.095
 | Y | wall thickness coefficient per code B31.3, Table 304.1.1 |  |  |  |  |  |  |  | 0.25 | - | 0.065
 | d | inside dia of pipe |  |  |  |  |  |  |  |  | 40 | 0.088
 | c | corrosion allowance |  |  |  |  |  |  |  |  | 80 | 0.119
 |  |  |  |  |  |  |  |  |  | 0.375 | - | 0.065
 |  | Pipe material | TP 304-A312 |  |  |  |  |  |  |  | 40 | 0.091
 |  | Temperature | 100 |  |  |  |  |  |  |  | 80 | 0.126
 |  |  |  |  |  |  |  |  |  | 0.5 | - | 0.065
 |  |  | Parameters | Input Values |  |  |  |  |  |  | - | 0.083
 |  |  | P | 50000 | psig |  |  |  |  |  | 40 | 0.109
 |  |  | D | 0.5 | inch |  |  |  |  |  | 80 | 0.147
 |  |  | O.D. |  | inch |  |  |  |  |  | - | 0.187
 |  |  | S |  | [NAME] |  |  |  |  |  | 160 | 0.294
 |  |  | E | 2 | - |  |  |  |  | 0.75 | - | 0.065
 |  |  | W | 1 | - |  |  |  |  |  | - | 0.083
 |  |  | Y | 3 | - |  |  |  |  |  | 40 | 0.113
 |  |  | d | 0.0625 | inch |  |  |  |  |  | 80 | 0.154
 |  |  | c | 0.2 | inch |  |  |  |  |  | - | 0.219
 |  |  |  |  |  |  |  |  |  |  | 160 | 0.308
 |  | Calculated Thickness of pipe  -   using equation (3a) | tc |  | inch |  | Calculated Thickness of pipe  -   using equation (3b) |  |  | 1 | - | 0.065
 |  |  |  |  |  |  |  |  |  |  | - | 0.109
 |  | Greater of (3a) or (3b) | tc |  | inch |  |  |  |  |  | 40 | 0.133
 |  | Select pipe schedule | t | formula goes here |  |  | If "D" in 'E17' , is selected as 1/2 inch , " t" in 'E28' is calculated as 0.111. However, a pipe is not readily available in a 0.111 inch thknss. Then the formula in  'E29' should  select a correct pipe schedule from col 'L' based on values listed in 'M14' to 'M19'. Here in this case, thkness is 0.111 inch , thus schedule selected should be 80 as the thickness is in betwn 0.147 & 0.109 ( 0.111 > 0.109 > 0.147). Hope this explains... |  |  |  | 80 | 0.179
 |  |  |  |  |  |  |  |  |  |  | - | 0.25
 |  |  |  |  |  |  |  |  |  |  | 160 | 0.358
 |  |  |  |  |  |  |  |  |  | 1.25 | - | 0.065
 |  |  |  |  |  |  |  |  |  |  | - | 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