Spreadsheet: 101805d1299850927-extracting-specifics-from-xls-file-excel-2003-pl-replacements-1100-and-1200
Sheet: 1209-LT 191

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 [NAME], 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 | 1209 | 11123 | 191 | LT | 24 | 3038 | 3.88 | 4.45 | 3038 | 24 |  | 3038 |  | 3 | 196 |  |  |  |  |  | 110 | 3.88 | 4.45 | 1.000 | ARC | ERW | BUTT | 42000 | 0.3125 |  | 0 |  | 0 | 390 | 35.6571 | 338 | 30.9029 | 1954-01-01 00:00:00 | 3 | B5 | No | Yes | No | Yes | No | ManuNoTestHCA | 30.9 | 0 | N |  |  |  | 22132 | 924.7503616945785
1 | 1209 | 11153 | 191 | LT | 24 | 348 | 4.47 | 4.54 | 348 | 24 |  | 348 |  |  |  |  |  |  |  |  | 111 | 4.47 | 4.54 | 1.000 | ARC | ERW | BUTT | 42000 | 0.3125 |  | 0 |  | 0 | 390 | 35.6571 | 338 | 30.9029 | 1954-01-01 00:00:00 | 3 | A5 | No | Yes | No | Yes | No | ManuNoTestHCA | 30.9 | 0 | N |  |  |  | 11282 | 109.2425833103014
1 | 1209 | 11156 | 191 | LT | 24 | 805 | 4.54 | 4.69 | 805 | 24 |  | 805 |  | 1 | 150 |  |  |  |  |  | 111.5 | 4.54 | 4.69 | 1.000 | ARC | ERW | BUTT | 42000 | 0.3125 |  | 0 |  | 0 | 390 | 35.6571 | 338 | 30.9029 | 1954-01-01 00:00:00 | 3 | B5 | No | Yes | No | Yes | No | ManuNoTestHCA | 30.9 | 0 | N |  |  |  | 11235 | 240.6425445609485
1 | 1209 | 11147 | 191 | LT | 24 | 2467 | 4.69 | 5.14 | 2467 | 24 |  | 2467 |  |  |  |  |  |  |  |  | 111.7 | 4.69 | 5.14 | 1.000 | ARC | ERW | BUTT | 42000 | 0.3125 |  | 0 |  | 0 | 390 | 35.6571 | 338 | 30.9029 | 1954-01-01 00:00:00 | 3 | B5 | No | Yes | No | Yes | No | ManuNoTestHCA | 30.9 | 0 | N |  |  |  | 11234 | 751.5806461966752
1 | 1209 | 11151 | 191 | LT | 24 | 46 | 5.42 | 5.43 | 46 | 24 |  | 46 |  |  |  |  |  |  |  |  | 112.3 | 5.42 | 5.43 | 1.000 | ARC | ERW | BUTT | 42000 | 0.3125 |  | 0 |  | 0 | 390 | 35.6571 | 338 | 30.9029 | 1954-01-01 00:00:00 | 3 | I5 | No | Yes | No | Yes | No | ManuNoTestHCA | 30.9 | 0 | N |  |  |  | 11232 | 12.55409375643705
1 | 1209 | 11116 | 191 | LT | 24 | 1652 | 5.5984 | 5.9125 | 1652 | 24 |  | 1652 |  | 3 | 205 |  |  |  |  |  | 113.3 | 5.5984 | 5.9125 | 1.000 | ARC | ERW | BUTT | 42000 | 0.3125 |  | 0 | L | 0 | 390 | 35.6571 | 338 | 30.9029 | 1954-01-01 00:00:00 | 3 | I5 |  |  |  |  |  | ManuNoTestHCA | 30.9 | 0 | N |  |  |  | 20189 | 494.2538438142687
1 | 1209 | 11158 | 191 | LT | 24 | 2959 | 5.9125 | 6.4753 | 2959 | 24 |  | 2959 |  |  |  |  |  |  |  |  | 113.4 | 5.9125 | 6.4753 | 1.000 | ARC | ERW | BUTT | 42000 | 0.3125 |  | 0 | L | 0 | 390 | 35.6571 | 338 | 30.9029 | 1954-01-01 00:00:00 | 3 | I5 | No | Yes | No | Yes | No | ManuNoTestHCA | 30.9 | 0 | N |  |  |  | 11231 | 894.8433873672893
1 | 1209 | 11160 | 191 | LT | 24 | 20 | 10.32 | 10.32 | 20 | 24 | 20 |  |  |  |  |  |  |  |  |  | 114.2 | 10.32 | 10.32 | 1.000 | ARC |  |  | -33000 | -0.281 |  | 0 |  | 0 | 390 | -50.4691 | 338 | -43.7399 | 1963-01-01 00:00:00 | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -43.74 | 0 | N |  |  |  | 4318 | 6.096621552896932
1 | 1209 | 11140 | 191 | LT | 34 | 100 | 2.74 | 2.76 | 100 | 34 |  | 100 |  | 1 | 75 |  |  |  |  |  | 104.5 | 2.74 | 2.76 | 1.000 | ARC |  | BUTT | 0 | 0 |  | 0 |  | 0 | 0 | 0 | 600 | 0 |  | -3 | B9 | No | No | No | Yes | No | ManuNoTestHCA | -9 | 0 | N |  |  |  | 15117 | 30.48404244839249