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

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 | 1101B | 20260 | BD549 | BD | 12.75 | 98 | 287.7 | 287.7 | 98 | 12.75 | 98 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 299.5 | 287.7 | 287.7 | 1.000 |  |  |  | -35000 | -0.203 | 1958-01-01 00:00:00 | 0 | W | 0 | 0 | -9 | 754 | -67.6531 | 1950-01-01 00:00:00 | 2 | N3 |  |  |  |  |  | ManuNoTestHCA | -67.65 | 0 | N |  |  |  | 3976 | 29.87579833446019
1 | 1101B | 20424 | [NAME] | BD | 10.75 | 88 | 43.3 | 43.3 | 88 | 10.75 | 88 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 122.66 | 43.3 | 43.3 | 1.000 |  |  |  | -35000 | -0.188 | 1962-01-01 00:00:00 | 0 |  | 0 | 0 | -9 | 636 | -51.9529 | 1962-01-01 00:00:00 | 3 | N3 |  |  |  |  |  | ManuNoTestHCA | -51.95 | 0 | N |  |  |  | 67 | 26.77186219201391
1 | 1101B | 22346 | DREG4807 | SERV | 3.5 | 154 | 0.0023 | 0.0314 | 76 | 3.5 | 0 | 76 | 0 | 1 | 70 | 0 | 0 | no | 0 |  | 101.3 | 0.0023 | 0.0314 | -0.600 |  |  |  | -25000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 478 | -39.5508 | 1968-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -39.55 | 0 | N |  |  |  | 20324 | 46.77466382797653
1 | 1101B | 21641 | DF6856 | LT | 12.75 | 69 | 0 | 0.0131 | 56 | 12.75 | 56 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 701 | 0 | 0.0131 | 1.000 |  |  |  | -24000 | 0.25 |  | 0 |  | 0 | 0 | -9 | 839 | -89.1437 |  | 1 | I1 | Yes | Yes | Yes | Yes | No | ManuNoTestHCA | -89.14 | 0 | N |  |  |  | 13970 | 16.87248802823091
1 | 1101B | 23811 | STA8462 | LT | 8.625 | 41 | 0.0025 | 0.0102 | 41 | 8.625 | 0 | 41 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 953 | 0.0025 | 0.0102 | 1.000 | GAS | SMLS | BUTT | 35000 | 0.188 | 1947-01-01 00:00:00 | 0 |  | 0 | 600 | 39.3237 | 478 | 31.3279 | 1947-01-01 00:00:00 | 3 | Z68 |  |  |  |  |  | FabNoTest1 | 31.33 | 0 | N | Sub_J No | Fab&Con |  | 20086 | 12.49479251699143
1 | 1101B | 24905 | X6542 | LT | 8.625 | 17 | 69.8 | 69.8 | 16 | 8.625 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 144.9 | 69.8 | 69.8 | 1.000 |  |  |  | -24000 | 0.344 |  | 0 |  | 0 | 650 | -33.9526 | 636 | -33.2213 |  | 3 | Z51 |  |  |  |  |  | ManuNoTestHCA | -33.22 | 0 | N |  |  |  | 50 | 5.124471570338842
1 | 1101B | 24906 | X6542 | LT | 10.75 | 20 | 69.8 | 69.8 | 20 | 10.75 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 144.7 | 69.8 | 69.8 | 1.000 |  |  |  | -24000 | 0.344 |  | 0 |  | 0 | 650 | -42.3177 | 636 | -41.4063 |  | 3 | Z51 |  |  |  |  |  | ManuNoTestHCA | -41.41 | 0 | N |  |  |  | 49 | 6.093479211251848
1 | 1101B | 24907 | X6542 | LT | 16 | 34 | 69.8 | 69.8 | 34 | 16 | 34 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 144.5 | 69.8 | 69.8 | 1.000 |  |  |  | -24000 | 0.344 |  | 0 |  | 0 | 650 | -62.9845 | 636 | -61.6279 |  | 3 | Z51 |  |  |  |  |  | ManuNoTestHCA | -61.63 | 0 | N |  |  |  | 48 | 10.38892715947114
1 | 1101B | 24908 | X6542 | LT | 8.625 | 15 | 69.8 | 69.8 | 15 | 8.625 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | no |  |  | 144.3 | 69.8 | 69.8 | 1.000 |  |  |  | -24000 | 0.25 |  | 0 |  | 0 | 650 | -46.7188 | 636 | -45.7125 |  | 3 | Z51 |  |  |  |  |  | ManuNoTestHCA | -45.71 | 0 | N |  |  |  | 47 | 4.430451431405957