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

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 | 1102 | 7792 | 138 | LT | 16 | 3383 | 22.7 | 23.4 | 3383 | 16 | 3383 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 116 | 22.7 | 23.4 | 1.000 | ARC | ERW | BUTT | 42000 | 0.281 | 1953-01-01 00:00:00 | 0 |  | 0 | 650 | 44.0603 | 650 | 44.0603 | 1953-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 44.06 | 0 | N |  |  |  | 8248 | 1010.978481728142
1 | 1102 | 7781 | 138 | LT | 16 | 1779 | 29.66 | 30 | 1779 | 16 | 1779 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 119 | 29.6627 | 30 | 1.000 | ARC | ERW | BUTT | 42000 | 0.281 | 1953-01-01 00:00:00 | 0 |  | 0 | 650 | 44.0603 | 650 | 44.0603 | 1953-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 44.06 | 0 | N |  |  |  | 13990 | 542.6069329307343
1 | 1102 | 7789 | 138 | LT | 16 | 1440 | 30 | 30.27 | 1440 | 16 | 1440 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 120 | 30 | 30.27 | 1.000 | ARC | ERW | BUTT | 42000 | 0.281 | 1953-01-01 00:00:00 | 0 |  | 0 | 650 | 44.0603 | 650 | 44.0603 | 1953-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 44.06 | 0 | N |  |  |  | 17615 | 439.1834849448243
1 | 1102 | 7788 | 138 | LT | 16 | 11268 | 30.27 | 32.41 | 11268 | 16 | 11268 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 121 | 30.27 | 32.41 | 1.000 | ARC | ERW | BUTT | 42000 | 0.281 | 1953-01-01 00:00:00 | 0 |  | 0 | 650 | 44.0603 | 650 | 44.0603 | 1953-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 44.06 | 0 | N |  |  |  | 17631 | 3436.659600793617
1 | 1102 | 7784 | 138 | LT | 16 | 8388 | 32.41 | 34 | 8388 | 16 | 8388 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 122 | 32.41 | 34 | 1.000 | ARC | ERW | BUTT | 42000 | 0.281 | 1953-01-01 00:00:00 | 0 |  | 0 | 650 | 44.0603 | 650 | 44.0603 | 1953-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 44.06 | 0 | N |  |  |  | 17628 | 2558.31858550798
1 | 1102 | 7783 | 138 | LT | 16 | 2264 | 34 | 34.42 | 2264 | 16 | 2264 | 0 | 0 | 1 | 68 | 0 | 0 | no | 0 |  | 123 | 34 | 34.42 | 1.000 | ARC | ERW | BUTT | 42000 | 0.281 | 1953-01-01 00:00:00 | 0 |  | 0 | 650 | 44.0603 | 650 | 44.0603 | 1953-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 44.06 | 0 | N |  |  |  | 17627 | 690.8188643461912
1 | 1102 | 7807 | 138 | LT | 16 | 520 | 34.42 | 34.52 | 540 | 16 | 540 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 124 | 34.42 | 34.52 | 1.000 | ARC | ERW | BUTT | 42000 | 0.281 | 1953-01-01 00:00:00 | 0 |  | 0 | 650 | 44.0603 | 650 | 44.0603 | 1953-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 44.06 | 0 | N |  |  |  | 2682 | 158.6004651351751
1 | 1102 | 7806 | 138 | LT | 16 | 450 | 34.52 | 34.61 | 450 | 16 | 450 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 124.3 | 34.52 | 34.61 | 1.000 | ARC | ERW | BUTT | 42000 | 0.281 | 1953-01-01 00:00:00 | 0 |  | 0 | 650 | 44.0603 | 650 | 44.0603 | 1953-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | 44.06 | 0 | N |  |  |  | 2683 | 137.2462398805201
1 | 1102 | 7787 | 138 | LT | 16 | 2840 | 34.61 | 35.17 | 2840 | 16 | 2840 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 125 | 34.61 | 35.17 | 1.000 | ARC | ERW | BUTT | 42000 | 0.281 | 1953-01-01 00:00:00 | 0 |  | 0 | 650 | 44.0603 | 650 | 44.0603 | 1953-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 44.06 | 0 | N |  |  |  | 17629 | 866.2062413046194
1 | 1102 | 7808 | 138 | LT | 16 | 40 | 35.17 | 35.18 | 40 | 16 | 40 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 125.3 | 35.17 | 35.18 | 1.000 | ARC | ERW | BUTT | 42000 | 0.281 | 1953-01-01 00:00:00 | 0 |  | 0 | 650 | 44.0603 | 650 | 44.0603 | 1953-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 44.06 | 0 | N |  |  |  | 2684 | 12.20138159057295
1 | 1102 | 7786 | 138 | LT | 16 | 3026 | 35.18 | 35.74 | 3026 | 16 | 3026 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 126 | 35.18 | 35.74 | 1.000 | ARC | ERW | BUTT | 42000 | 0.281 | 1953-01-01 00:00:00 | 0 |  | 0 | 650 | 44.0603 | 650 | 44.0603 | 1953-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 44.06 | 0 | N |  |  |  | 17894 | 916.0636289301692
1 | 1102 | 7742 | 138 | LT | 16 | 4774 | 36.09 | 37 | 4774 | 16 | 4774 | 0 | 0 | 1 | 40 | 0 | 0 | no | 0 |  | 127 | 36.09 | 37 | 1.000 | ARC | ERW | BUTT | 42000 | 0.281 | 1953-01-01 00:00:00 | 0 |  | 0 | 650 | 44.0603 | 650 | 44.0603 | 1953-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 44.06 | 0 | N |  |  |  | 23760 | 1460.491358217599
1 | 1102 | 7743 | 138 | LT | 16 | 5714 | 37 | 38.08 | 5714 | 16 | 5714 | 0 | 0 | 1 | 36 | 0 | 0 | no | 0 |  | 128 | 37 | 38.08 | 1.000 | ARC | ERW | BUTT | 42000 | 0.281 | 1953-01-01 00:00:00 | 0 |  | 0 | 650 | 44.0603 | 650 | 44.0603 | 1953-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 44.06 | 0 | N |  |  |  | 23761 | 1742.743230248174
1 | 1102 | 7744 | 138 | LT | 16 | 1840 | 38.08 | 38.426 | 1840 | 16 | 1840 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 129 | 38.08 | 38.426 | 1.000 | ARC | ERW | BUTT | 42000 | 0.281 | 1953-01-01 00:00:00 | 0 |  | 0 | 650 | 44.0603 | 650 | 44.0603 | 1953-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | 44.06 | 0 | N |  |  |  | 23762 | 563.2668033204973
1 | 1102 | 7766 | 138 | LT | 16 | 819 | 38.426 | 38.58 | 819 | 16 | 819 | 0 | 0 | 1 | 66 | 0 | 0 | no | 1 |  | 130 | 38.426 | 38.58 | 1.000 | ARC | ERW | BUTT | 42000 | 0.281 | 1953-01-01 00:00:00 | 0 |  | 0 | 650 | 44.0603 | 650 | 44.0603 | 1953-01-01 00:00:00 | 3 | I6 | No | Yes | No | No | No | ManuNoTestHCA | 44.06 | 0 | N |  |  |  | 23391 | 229.1915587968669
1 | 1102 | 7776 | 138 | LT | 16 | 3 | 38.59 | 38.59 | 3 | 16 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 130.11 | 38.59 | 38.59 | 1.000 | ARC | ERW | BUTT | 42000 | 0.281 | 1953-01-01 00:00:00 | 0 |  | 0 | 650 | 44.0603 | 650 | 44.0603 | 1953-01-01 00:00:00 | 3 | I1 | No | Yes | No | No | No | ManuNoTestHCA | 44.06 | 0 | N |  |  |  | 23393 | 0.9088931837365094
2 | 1102 | 7797 | 138 | LT | 16 | 594 | 22.58 | 22.7 | 594 | 16 | 594 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 115 | 22.54 | 22.65 | 1.000 | ARC | ERW | BUTT | 42000 | 0.281 | 1953-01-01 00:00:00 | 0 |  | 0 | 650 | 44.0603 | 650 | 44.0603 | 1953-01-01 00:00:00 | 1 | N1 |  |  |  |  |  | ManuNoTest | 44.06 | 0 | N |  |  |  | 1758 | 181.0551801478257
2 | 1102 | 7791 | 138 | LT | 16 | 13710 | 27.06 | 29.66 | 13710 | 16 | 13710 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 117 | 23.4 | 26 | 1.000 | ARC | ERW | BUTT | 42000 | 0.281 | 1953-01-01 00:00:00 | 0 |  | 0 | 650 | 44.0603 | 650 | 44.0603 | 1953-01-01 00:00:00 | 1 | N1 |  |  |  |  |  | ManuNoTest | 44.06 | 0 | N |  |  |  | 4187 | 4181.303954033459
2 | 1102 | 7785 | 138 | LT | 16 | 1893 | 35.74 | 36.09 | 1906 | 16 | 1906 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 126.3 | 35.74 | 36.09 | 1.000 | ARC | ERW | BUTT | 42000 | 0.281 | 1953-01-01 00:00:00 | 0 |  | 0 | 650 | 44.0603 | 650 | 44.0603 | 1953-01-01 00:00:00 | 1 | N1 |  |  |  |  |  | ManuNoTest | 44.06 | 0 | N |  |  |  | 17893 | 581.3342139420218