Spreadsheet: 101805d1299850927-extracting-specifics-from-xls-file-excel-2003-pl-replacements-1100-and-1200
Sheet: 1101A-BB 300B

Phase | Project No. | Segment ID (GIE) | Route No. | Facility Type | Pipe O.D., in. | Segment Length, ft | Proposed [NAME] | Proposed End M.P. | Proposed total length, ft. | Proposed Pipe Diameter, in. | Segment Length per Construction Classification, ft |  |  | Bored Crossings |  | HDDs |  | Potential Re-route | Move-arounds | Comments, notes, assumptions
 |  |  |  |  |  |  |  |  |  |  | Non-cong. | Semi-cong. | High-cong. | Q-ty | Length, Feet | Q-ty | Length, Feet | yes/no | Q-ty |  | [NAME] | MP1 | MP2 | JNTEFF | GIRTH_WELD | LONG_SEAM | JOINT_TYPE | [NAME] | W_THICK | TEST_DATE | TEST_PRESS | [NAME] | TEST_DUR | MAOP | SMYS_MAOP | MOP | SMYS_MOP | YR_INSTALL | CLASSESENT | HCA_ID | SCC_THREAT | MANU_HREAT | CONSTHREAT | OF_THREAT | HS_THREAT | Legend Name | PerSMYS | TestPer | Sub_J | Fab_Note | Threat | Seismic | Object_ID | Shape_Length
1 | 1101A | 14175 | 300B | BB | 34 | 753 | 160.88 | 161.02 | 766 | 34 | 766 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 192.5 | 160.88 | 161.02 | 1.000 | ARC |  | BUTT | 52000 | 0.5 | 1958-01-01 00:00:00 | 0 |  | 0 | 0 | -9 | 573 | 37.4654 | 1958-05-22 00:00:00 | 2 | I5 | No | Yes | No | Yes | No | ManuNoTestHCA | 37.47 | 0 | N |  |  |  | 13579 | 233.966082558782
1 | 1101A | 14161 | 300B | BB | 34 | 462 | 161.02 | 161.07 | 467 | 34 | 467 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 193 | 161.02 | 161.07 | 1.000 | ARC |  |  | -46000 | 0.5 | 1958-01-01 00:00:00 | 0 | G | 0 | 861 | -63.6391 | 860 | -63.5652 | 1958-05-22 00:00:00 | 1 | I5 | Yes | Yes | No | Yes | Yes | ManuNoTestHCA | -63.57 | 0 | N |  |  |  | 13444 | 143.1363684204635
1 | 1101A | 14180 | 300B | BB | 34 | 381 | 161.43 | 161.48 | 376 | 34 | 376 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 194 | 161.43 | 161.48 | 1.000 | ARC |  |  | -46000 | 0.5 | 1958-01-01 00:00:00 | 0 | G | 0 | 861 | -63.6391 | 860 | -63.5652 | 1958-05-22 00:00:00 | 1 | I5 | Yes | Yes | No | Yes | Yes | ManuNoTestHCA | -63.57 | 0 | N |  |  |  | 13447 | 115.1970656020255
1 | 1101A | 13459 | 300B | BB | 34 | 318 | 248.91 | 249.971 | 318 | 34 | 318 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 264.5 | 248.91 | 248.9711 | 1.000 | ARC | DSAW | BUTT | 52000 | 0.375 |  | 898 | G | 0 | 803 | 70.0051 | 766 | 66.7795 |  | 2 | N1 |  |  |  |  |  | FabNoTest1 | 66.78 | 1.17 | N | Sub_J No | Fab&Con |  | 16348 | 97.03031229374213
2 | 1101A | 13460 | 300B | BB | 34 | 307 | 248.9711 | 249.03 | 307 | 34 | 307 | 0 | 0 | 0 | 0 | 0 | 0 | no | 1 |  | 264.55 | 248.9711 | 249.03 | 1.000 | ARC | DSAW | BUTT | 52000 | 0.375 |  | 898 | G | 0 | 803 | 70.0051 | 766 | 66.7795 |  | 1 | N1 |  |  |  |  |  | FabNoTest2 | 66.78 | 1.17 | N | Sub_J No | Fab&Con |  | 16349 | 93.57580513208597
2 | 1101A | 14652 | 300B | BB | 34 | 90 | 249.03 | 249.05 | 90 | 34 | 90 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 264.6 | 249.03 | 249.05 | 1.000 | ARC | DSAW | BUTT | 52000 | 0.375 |  | 898 | G | 0 | 803 | 70.0051 | 766 | 66.7795 |  | 1 | N1 |  |  |  |  |  | FabNoTest2 | 66.78 | 1.17 | N | Sub_J No | Fab&Con |  | 4100 | 27.55125574453287
2 | 1101A | 14648 | 300B | BB | 34 | 83 | 249.05 | 249.07 | 83 | 34 | 83 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 264.7 | 249.05 | 249.07 | 1.000 | ARC | DSAW | BUTT | 52000 | 0.375 |  | 898 | G | 0 | 803 | 70.0051 | 766 | 66.7795 |  | 1 | N1 |  |  |  |  |  | FabNoTest2 | 66.78 | 1.17 | N | Sub_J No | Fab&Con |  | 4101 | 27.63391678879217
2 | 1101A | 14647 | 300B | BB | 34 | 110 | 249.07 | 249.09 | 110 | 34 | 110 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 264.8 | 249.07 | 249.09 | 1.000 | ARC | DSAW | BUTT | 52000 | 0.375 |  | 898 | G | 0 | 803 | 70.0051 | 766 | 66.7795 |  | 1 | N1 |  |  |  |  |  | FabNoTest2 | 66.78 | 1.17 | N | Sub_J No | Fab&Con |  | 4102 | 33.46142143986253
2 | 1101A | 14644 | 300B | BB | 34 | 3347 | 249.09 | 249.72 | 3347 | 34 | 3347 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 264.9 | 249.09 | 249.72 | 1.000 | ARC | DSAW | BUTT | 52000 | 0.375 |  | 898 | G | 0 | 803 | 70.0051 | 766 | 66.7795 |  | 1 | N1 |  |  |  |  |  | FabNoTest2 | 66.78 | 1.17 | N | Sub_J No | Fab&Con |  | 4103 | 992.6559794483668