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

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 | 16708 | 314 | LT | 12.75 | 3030 | 20.31 | 20.91 | 3020 | 12.75 | 3020 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 112 | 20.31 | 20.91 | 1.000 | ARC | ERW | BUTT | 42000 | 0.219 | 1957-01-01 00:00:00 | 980 | W | 0 | 861 | 59.6747 | 861 | 59.6747 | 1957-01-01 00:00:00 | 2 | N5 |  |  |  |  |  | ManuNoTestHCA | 59.67 | 1.14 | N |  |  |  | 6750 | 923.548977478525
2 | 1101A | 16668 | 314 | LT | 12.75 | 39 | 0 | 0 | 39 | 12.75 | 39 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 951 | 0 | 0 | 1.000 | ARC | ERW | BUTT | 42000 | -0.203 | 1957-01-01 00:00:00 | 980 | W | 0 | 861 | -64.3781 | 861 | -64.3781 | 1957-01-01 00:00:00 | 1 | N5 |  |  |  |  |  | ManuNoTest | -64.38 | 1.14 | N |  |  |  | 13544 | 11.99096113237506
2 | 1101A | 16669 | 314 | LT | 12.75 | 305 | 0 | 0 | 305 | 12.75 | 305 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 952 | 0 | 0 | 1.000 | ARC | ERW | BUTT | 42000 | -0.203 | 1957-01-01 00:00:00 | 980 | W | 0 | 861 | -64.3781 | 861 | -64.3781 | 1957-01-01 00:00:00 | 1 | N5 |  |  |  |  |  | ManuNoTest | -64.38 | 1.14 | N |  |  |  | 13543 | 95.66068706108824
2 | 1101A | 16670 | 314 | LT | 12.75 | 49 | 0 | 0 | 49 | 12.75 | 49 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 953 | 0 | 0 | 1.000 | ARC |  |  | -35000 | -0.203 |  | 980 | W | 0 | 861 | -77.2537 | 861 | -77.2537 |  | 1 | N5 |  |  |  |  |  | ManuNoTest | -77.25 | 1.14 | N |  |  |  | 13545 | 14.99139263718528
2 | 1101A | 16698 | 314 | LT | 12.75 | 21109 | 0 | 3.8841 | 21109 | 12.75 | 21109 | 0 | 0 | 0 | 0 | 0 | 0 | no | 1 |  | 101 | 0 | 3.8841 | 1.000 | ARC | ERW | BUTT | 42000 | 0.219 | 1957-01-01 00:00:00 | 980 | W | 0 | 861 | 59.6747 | 861 | 59.6747 | 1957-01-01 00:00:00 | 1 | N5 |  |  |  |  |  | ManuNoTest | 59.67 | 1.14 | N |  |  |  | 6784 | 6342.162248914332
2 | 1101A | 16683 | 314 | LT | 12.75 | 19099 | 3.8841 | 7.4708 | 19099 | 12.75 | 19099 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 102 | 3.8841 | 7.4708 | 1.000 | ARC | ERW | BUTT | 42000 | 0.219 | 1957-01-01 00:00:00 | 980 | W | 0 | 861 | 59.6747 | 861 | 59.6747 | 1957-01-01 00:00:00 | 1 | N5 |  |  |  |  |  | ManuNoTest | 59.67 | 1.14 | N |  |  |  | 6763 | 5856.52781755649
2 | 1101A | 16700 | 314 | LT | 12.75 | 5280 | 10.94 | 11.97 | 5280 | 12.75 | 5280 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 108 | 10.94 | 11.97 | 1.000 | ARC | ERW | BUTT | 42000 | 0.219 | 1957-01-01 00:00:00 | 980 | W | 0 | 861 | 59.6747 | 861 | 59.6747 | 1957-01-01 00:00:00 | 1 | N5 |  |  |  |  |  | ManuNoTest | 59.67 | 1.14 | N |  |  |  | 6746 | 1609.347706879554
2 | 1101A | 16699 | 314 | LT | 12.75 | 3827 | 11.97 | 12.73 | 3827 | 12.75 | 3827 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 109 | 11.97 | 12.73 | 1.000 | ARC | ERW | BUTT | 42000 | 0.219 | 1957-01-01 00:00:00 | 980 | W | 0 | 861 | 59.6747 | 861 | 59.6747 | 1957-01-01 00:00:00 | 1 | N5 |  |  |  |  |  | ManuNoTest | 59.67 | 1.14 | N |  |  |  | 6747 | 1172.355375127675
2 | 1101A | 16709 | 314 | LT | 12.75 | 17267 | 12.73 | 16.14 | 17267 | 12.75 | 17267 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 110 | 12.73 | 16.14 | 1.000 | ARC | ERW | BUTT | 42000 | 0.219 | 1957-01-01 00:00:00 | 980 | W | 0 | 861 | 59.6747 | 861 | 59.6747 | 1957-01-01 00:00:00 | 1 | N5 |  |  |  |  |  | ManuNoTest | 59.67 | 1.14 | N |  |  |  | 6749 | 5262.990699287598
2 | 1101A | 16743 | 314 | LT | 12.75 | 16427 | 16.14 | 19.3834 | 16427 | 12.75 | 16427 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 111 | 16.14 | 19.3834 | 1.000 | ARC | ERW | BUTT | 42000 | 0.219 | 1957-01-01 00:00:00 | 980 | W | 0 | 861 | 59.6747 | 861 | 59.6747 | 1957-01-01 00:00:00 | 1 | N5 |  |  |  |  |  | ManuNoTest | 59.67 | 1.14 | N |  |  |  | 9365 | 5007.011803269548
2 | 1101A | 16742 | 314 | LT | 12.75 | 1499 | 19.3834 | 19.6794 | 1499 | 12.75 | 1499 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 111.7 | 19.3834 | 19.6794 | 1.000 | ARC | ERW | BUTT | 42000 | 0.219 | 1957-01-01 00:00:00 | 980 | W | 0 | 861 | 59.6747 | 861 | 59.6747 | 1957-01-01 00:00:00 | 1 | Z51 |  |  |  |  |  | ManuNoTest | 59.67 | 1.14 | N |  |  |  | 9366 | 456.930734834944
2 | 1101A | 16740 | 314 | LT | 12.75 | 3194 | 19.6794 | 20.31 | 3194 | 12.75 | 3194 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 111.8 | 19.6794 | 20.31 | 1.000 | ARC | ERW | BUTT | 42000 | 0.219 | 1957-01-01 00:00:00 | 980 | W | 0 | 861 | 59.6747 | 861 | 59.6747 | 1957-01-01 00:00:00 | 1 | N5 |  |  |  |  |  | ManuNoTest | 59.67 | 1.14 | N |  |  |  | 9367 | 973.4436293043439
2 | 1101A | 16739 | 314 | LT | 12.75 | 11591 | 21.91 | 23.8117 | 11591 | 12.75 | 11591 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 114 | 21.91 | 23.8117 | 1.000 | ARC | ERW | BUTT | 42000 | 0.219 | 1957-01-01 00:00:00 | 980 | W | 0 | 861 | 59.6747 | 861 | 59.6747 | 1957-01-01 00:00:00 | 1 | N5 |  |  |  |  |  | ManuNoTest | 59.67 | 1.14 | N |  |  |  | 9368 | 3582.750258203293
2 | 1101A | 16738 | 314 | LT | 12.75 | 1026 | 23.8117 | 23.98 | 1026 | 12.75 | 1026 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 114.2 | 23.8117 | 23.98 | 1.000 | ARC | ERW | BUTT | 42000 | 0.219 | 1957-01-01 00:00:00 | 980 | W | 0 | 861 | 59.6747 | 861 | 59.6747 | 1957-01-01 00:00:00 | 1 | Z51 |  |  |  |  |  | ManuNoTest | 59.67 | 1.14 | N |  |  |  | 9369 | 317.0094373189388
2 | 1101A | 16706 | 314 | LT | 12.75 | 261 | 23.98 | 24.03 | 261 | 12.75 | 261 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 114.6 | 23.98 | 24.03 | 1.000 | ARC | ERW | BUTT | 42000 | 0.219 | 1957-01-01 00:00:00 | 980 | W | 0 | 861 | 59.6747 | 861 | 59.6747 | 1957-01-01 00:00:00 | 1 | N5 |  |  |  |  |  | ManuNoTest | 59.67 | 1.14 | N |  |  |  | 6752 | 79.5549551796093
2 | 1101A | 16711 | 314 | LT | 12.75 | 992 | 24.03 | 24.19 | 992 | 12.75 | 992 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 115 | 24.03 | 24.19 | 1.000 | ARC | ERW | BUTT | 42000 | 0.219 | 1957-01-01 00:00:00 | 980 | W | 0 | 861 | 59.6747 | 861 | 59.6747 | 1957-01-01 00:00:00 | 1 | N5 |  |  |  |  |  | ManuNoTest | 59.67 | 1.14 | N |  |  |  | 6753 | 302.3609561044846
2 | 1101A | 16701 | 314 | LT | 10.75 | 4446 | 28.1141 | 28.83 | 4446 | 10.75 | 4446 | 0 | 0 | 1 | 80 | 0 | 0 | no | 0 |  | 127 | 28.1141 | 28.83 | 1.000 | ARC | ERW | BUTT | 42000 | -0.188 | 1957-01-01 00:00:00 | 695 | G | 0 | 550 | -37.4398 | 550 | -37.4398 | 1957-01-01 00:00:00 | 1 | Z51 |  |  |  |  |  | ManuFault | -37.44 | 1.26 | Y | 1970_Slope_Yes |  |  | 6796 | 1348.927365013792
2 | 1101A | 16705 | 314 | LT | -10.75 | 22 | 28.91 | 28.91 | 22 | 10.75 | 22 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 127.6 | 28.91 | 28.91 | -1.000 |  |  |  | -35000 | 0.188 |  | 0 |  | 0 | 0 | -9 | -550 | -44.9278 | 1957-01-01 00:00:00 | 1 | Z51 |  |  |  |  |  | ManuNoTest | -44.93 | 0 | N |  |  |  | 6794 | 6.742991816761998
2 | 1101A | 16713 | 314 | LT | -10.75 | 11 | 28.91 | 28.91 | 11 | 10.75 | 11 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 127.5 | 28.91 | 28.91 | -1.000 |  |  |  | -35000 | 0.188 |  | 0 |  | 0 | 0 | -9 | -550 | -44.9278 | 1957-01-01 00:00:00 | 1 | N5 |  |  |  |  |  | ManuNoTest | -44.93 | 0 | N |  |  |  | 6793 | 3.344525341403751
2 | 1101A | 16714 | 314 | LT | -10.75 | 19 | 28.91 | 28.91 | 19 | 10.75 | 19 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 127.4 | 28.91 | 28.91 | -1.000 |  |  |  | -35000 | 0.188 |  | 0 |  | 0 | 0 | -9 | -550 | -44.9278 | 1957-01-01 00:00:00 | 1 | N5 |  |  |  |  |  | ManuNoTest | -44.93 | 0 | N |  |  |  | 6792 | 5.646820078324168
2 | 1101A | 16693 | 314 | LT | 8.625 | 14740 | 40.29 | 43.14 | 14740 | 8.625 | 14740 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 141 | 40.29 | 43.14 | 1.000 | ARC | ERW | BUTT | 42000 | 0.188 | 1965-01-01 00:00:00 | 695 | G | 2 | 550 | 30.0389 | 550 | 30.0389 | 1965-01-01 00:00:00 | 1 | N5 |  |  |  |  |  | ManuFault | 30.04 | 1.26 | Y | 1970_Fault_Yes |  |  | 6771 | 4566.291460927607
1 | 1101A | 16746 | 314A | LT | 8.625 | 447 | 0.15 | 0.24 | 454 | 8.625 | 0 | 454 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 101.3 | 0.15 | 0.24 | 1.000 | ARC | ERW | BUTT | 42000 | 0.188 | 1957-01-01 00:00:00 | 695 | G | 0 | 550 | 30.0389 | 550 | 30.0389 | 1957-01-01 00:00:00 | 3 | Z51 |  |  |  |  |  | ManuNoTestHCA | 30.04 | 1.26 | N |  |  |  | 6741 | 139.4547572161478