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

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 | 1103 | 5725 | 118A | LT | 8.625 | 1320 | 5.62 | 5.86 | 1320 | 16 | 1320 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 110 | 5.62 | 5.86 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 100 | W | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 30.35 | 0.25 | N |  |  |  | 8219 | 393.412407232944
1 | 1103 | 5697 | 118A | LT | 12.75 | 56 | 6.07 | 6.08 | 56 | 16 | 56 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 111.3 | 6.07 | 6.08 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 5441 | 17.08115215460624
1 | 1103 | 5695 | 118A | LT | 12.75 | 1340 | 6.08 | 6.33 | 1340 | 16 | 1340 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 112 | 6.08 | 6.33 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 5443 | 408.6831491005011
1 | 1103 | 5521 | 118A | LT | 12.75 | 4714 | 6.33 | 7.1469 | 4714 | 16 | 4714 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 112.5 | 6.33 | 7.1469 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 13059 | 1437.631408013639
1 | 1103 | 5534 | 118A | LT | 12.75 | 887 | 7.1469 | 7.3006 | 887 | 16 | 887 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 113 | 7.1469 | 7.3006 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 3 | N9 |  |  |  |  |  | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 12630 | 270.7709836675604
1 | 1103 | 5323 | 118A | LT | 12.75 | 5017 | 7.3006 | 8.17 | 5017 | 16 | 5017 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 113.5 | 7.3006 | 8.17 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 3 | Z15 |  |  |  |  |  | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 21273 | 1529.781613940854
1 | 1103 | 5520 | 118A | LT | 12.75 | 1420 | 8.17 | 8.4268 | 1420 | 16 | 1420 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 114 | 8.17 | 8.4268 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 13060 | 433.5536654869773
1 | 1103 | 5325 | 118A | LT | 12.75 | 737 | 8.4268 | 8.56 | 737 | 16 | 737 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 114.5 | 8.4268 | 8.56 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 3 | I1 | No | Yes | Yes | No | No | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 22967 | 224.555774619466
1 | 1103 | 5522 | 118A | LT | 12.75 | 469 | 8.56 | 8.6391 | 469 | 16 | 469 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 115 | 8.56 | 8.6391 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 3 | I1 | No | Yes | Yes | No | No | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 13058 | 143.0713253345631
1 | 1103 | 5500 | 118A | LT | 12.75 | 361 | 8.6391 | 8.7 | 361 | 16 | 361 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 115.5 | 8.6391 | 8.7 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 13057 | 110.4266071161288
1 | 1103 | 5614 | 118A | LT | 12.75 | 714 | 8.7 | 8.8317 | 714 | 16 | 714 | 0 | 0 | 1 | 122 | 0 | 0 | no | 1 |  | 116 | 8.7 | 8.8317 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 17832 | 227.1498690583405
1 | 1103 | 5615 | 118A | LT | 12.75 | 912 | 8.8317 | 9 | 912 | 16 | 0 | 912 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 116.5 | 8.8317 | 9 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 2 | I2 | No | Yes | Yes | No | No | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 17833 | 290.1160448276675
1 | 1103 | 5613 | 118A | LT | 12.75 | 1390 | 9 | 9.2654 | 1390 | 16 | 0 | 1390 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 117 | 9 | 9.2654 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 2 | I2 | No | Yes | Yes | No | No | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 17831 | 426.5094348706924
1 | 1103 | 5315 | 118A | LT | 12.75 | 859 | 9.2654 | 9.4294 | 859 | 16 | 859 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 117.05 | 9.2654 | 9.4294 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 2 | I9 | No | Yes | Yes | No | No | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 19759 | 263.61085085371
1 | 1103 | 5313 | 118A | LT | 12.75 | 1888 | 9.4294 | 9.7898 | 1888 | 16 | 1888 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 117.07 | 9.4294 | 9.7898 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 19760 | 579.0961379820137
1 | 1103 | 5558 | 118A | LT | 12.75 | 420 | 9.7898 | 9.87 | 420 | 16 | 420 | 0 | 0 | 1 | 70 | 0 | 0 | no | 0 |  | 117.1 | 9.7898 | 9.87 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 16352 | 128.9522770628985
1 | 1103 | 5693 | 118A | LT | 12.75 | 600 | 9.87 | 9.98 | 600 | 16 | 600 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 118 | 9.87 | 9.98 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 5445 | 182.9937336587438
1 | 1103 | 5739 | 118A | LT | 12.75 | 4298 | 10 | 10.78 | 4298 | 16 | 4298 | 0 | 0 | 3 | 80 | 0 | 0 | no | 0 |  | 119 | 10 | 10.78 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 9842 | 1312.605153702093
1 | 1103 | 5317 | 118A | LT | 12.75 | 988 | 10.78 | 10.9658 | 988 | 16 | 0 | 988 | 0 | 1 | 100 | 0 | 0 | no | 0 |  | 119.5 | 10.78 | 10.9658 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 19753 | 325.0133825600317
1 | 1103 | 5305 | 118A | LT | 12.75 | 165 | 10.9658 | 10.9969 | 165 | 16 | 0 | 165 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 119.7 | 10.9658 | 10.9969 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 3 | I9 | No | Yes | Yes | No | No | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 19754 | 54.44018443277835
1 | 1103 | 5385 | 118A | LT | 12.75 | 73 | 10.9969 | 11.0107 | 73 | 16 | 0 | 73 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 120 | 10.9969 | 11.0107 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 3 | I1 | No | Yes | Yes | No | No | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 12650 | 22.2487288260032
1 | 1103 | 5383 | 118A | LT | 12.75 | 460 | 11.1548 | 11.2326 | 460 | 16 | 460 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 120.4 | 11.1548 | 11.2326 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 3 | I1 | No | Yes | Yes | No | No | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 12652 | 139.8679357530984
1 | 1103 | 5382 | 118A | LT | 12.75 | 616 | 11.2326 | 11.3493 | 616 | 16 | 616 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 120.5 | 11.2326 | 11.3493 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 3 | I5 | No | Yes | Yes | No | No | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 12653 | 179.8520888766145
1 | 1103 | 5635 | 118A | LT | 12.75 | 206 | 11.3752 | 11.4142 | 206 | 16 | 206 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 120.9 | 11.3752 | 11.4142 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 3 | I5 | No | Yes | Yes | No | No | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 11984 | 67.7344547931182
1 | 1103 | 5732 | 118A | LT | 12.75 | 968 | 11.59 | 11.77 | 968 | 16 | 968 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 122 | 11.59 | 11.77 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 3 | I9 | No | Yes | Yes | No | No | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 9843 | 299.9143330376581
1 | 1103 | 5328 | 118A | LT | 12.75 | 2971 | 12 | 12.55 | 2971 | 16 | 2971 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 124 | 12 | 12.55 | 0.800 | GAS | LAP | BBCR | 35000 | 0.25 | 1931-01-01 00:00:00 | 0 | L | 0 | 400 | 36.4286 | 400 | 36.4286 | 1931-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | 36.43 | 0 | N |  |  |  | 22851 | 856.6109074669448