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

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 | 4900 | 111A | LT | 12.75 | 340 | 19.3 | 19.36 | 340 | 12.75 | 340 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 128.3 | 19.3 | 19.36 | 1.000 | ARC | ERW | BBCR | 42000 | -0.203 | 1960-01-01 00:00:00 | 860 | W | 1 | 650 | -48.6013 | 650 | -48.6013 | 1942-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -48.6 | 1.32 | N |  |  |  | 13934 | 103.697568756878
1 | 1103 | 4947 | 111A | LT | 8.625 | 1740 | 21.67 | 22 | 1740 | 8.625 | 1740 | 0 | 0 | 1 | 40 | 0 | 0 | no | 1 |  | 132 | 21.67 | 22 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 8153 | 575.5127054004098
1 | 1103 | 4970 | 111A | LT | 8.625 | 1304 | 22 | 22.29 | 1304 | 8.625 | 1304 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 133 | 22 | 22.29 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 1413 | 397.7075297042203
1 | 1103 | 4965 | 111A | LT | 8.625 | 305 | 22.29 | 22.35 | 305 | 8.625 | 305 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 133.6 | 22.29 | 22.35 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 1415 | 93.02225622957427
1 | 1103 | 4956 | 111A | LT | 8.625 | 4113 | 22.35 | 23.08 | 4113 | 8.625 | 4113 | 0 | 0 | 2 | 40 | 0 | 0 | no | 0 |  | 135 | 22.35 | 23.08 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 1417 | 1254.434324424376
1 | 1103 | 4967 | 111A | LT | 8.625 | 228 | 23.23 | 23.27 | 228 | 8.625 | 228 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 135.9 | 23.23 | 23.27 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 1420 | 69.53820419408089
1 | 1103 | 4949 | 111A | LT | 8.625 | 4385 | 23.27 | 24.09 | 4385 | 8.625 | 4385 | 0 | 0 | 1 | 40 | 0 | 0 | no | 0 |  | 137 | 23.27 | 24.09 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 8382 | 1349.064680671852
1 | 1103 | 4950 | 111A | LT | 8.625 | 2392 | 24.09 | 24.55 | 2392 | 8.625 | 2392 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 138 | 24.09 | 24.55 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 8195 | 729.552892236927
1 | 1103 | 4958 | 111A | LT | 8.625 | 2362 | 24.55 | 25 | 2362 | 8.625 | 2362 | 0 | 0 | 1 | 40 | 0 | 0 | no | 0 |  | 139 | 24.55 | 25 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 1406 | 716.4192526161897
1 | 1103 | 4901 | 111A | LT | 8.625 | 3136 | 25 | 25.5964 | 3136 | 8.625 | 3136 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 139.5 | 25 | 25.5964 | 0.800 | ARC | SPIRAL | BUTT | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-12-21 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 13973 | 954.7976333611407
1 | 1103 | 4895 | 111A | LT | 8.625 | 560 | 25.5964 | 25.7028 | 560 | 8.625 | 0 | 560 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 140 | 25.5964 | 25.7028 | 0.800 | ARC | SPIRAL | BUTT | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-12-21 00:00:00 | 3 | I1 | No | Yes | Yes | No | No | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 24323 | 163.0103261670702
1 | 1103 | 4896 | 111A | LT | 8.625 | 782 | 25.8215 | 25.97 | 782 | 8.625 | 0 | 782 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 141 | 25.8215 | 25.97 | 0.800 | ARC | SPIRAL | BUTT | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-12-21 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 24319 | 238.3526830782125
1 | 1103 | 4899 | 111A | LT | 8.625 | 361 | 25.97 | 26.04 | 361 | 8.625 | 0 | 361 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 141.1 | 25.97 | 26.04 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 24521 | 116.2644754259321
1 | 1103 | 4898 | 111A | LT | 8.625 | 993 | 26.04 | 26.23 | 993 | 8.625 | 0 | 993 | 0 | 1 | 100 | 0 | 0 | no | 0 |  | 141.2 | 26.04 | 26.23 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 24522 | 303.970805826033
1 | 1103 | 4964 | 111A | LT | 8.625 | 2418 | 26.23 | 26.68 | 2418 | 8.625 | 0 | 2418 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 141.3 | 26.23 | 26.68 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 3 | Z15 |  |  |  |  |  | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 1408 | 742.8042658448207
1 | 1103 | 4912 | 111A | LT | 8.625 | 382 | 26.68 | 26.7524 | 382 | 8.625 | 0 | 382 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 141.4 | 26.68 | 26.7524 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 16342 | 116.5714777529153
1 | 1103 | 4941 | 111A | LT | 8.625 | 174 | 26.7524 | 26.7853 | 174 | 8.625 | 0 | 174 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 141.7 | 26.7524 | 26.7853 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 17839 | 53.03021800178571
1 | 1103 | 4943 | 111A | LT | 8.625 | 151 | 26.7853 | 26.8138 | 151 | 8.625 | 0 | 151 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 141.8 | 26.7853 | 26.8138 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 2 | I2 | No | Yes | Yes | No | No | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 17840 | 45.8979154611084
1 | 1103 | 4911 | 111A | LT | 8.625 | 244 | 26.8138 | 26.86 | 244 | 8.625 | 0 | 244 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 141.9 | 26.8138 | 26.86 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 3 | I2 | No | Yes | Yes | No | No | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 16343 | 74.39100502506383
1 | 1103 | 4933 | 111A | LT | 8.625 | 4 | 26.86 | 26.8608 | 4 | 8.625 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 142 | 26.86 | 26.8608 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 3 | I1 | No | Yes | Yes | No | No | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 17841 | 1.284592760905966
1 | 1103 | 4916 | 111A | LT | 8.625 | 1462 | 26.8608 | 27.14 | 1462 | 8.625 | 0 | 1462 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 142.2 | 26.8608 | 27.14 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 3 | I1 | No | Yes | Yes | No | No | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 17842 | 424.9654058937919
1 | 1103 | 4903 | 111A | LT | 8.625 | 460 | 27.14 | 27.23 | 460 | 8.625 | 0 | 460 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 142.3 | 27.14 | 27.23 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 13974 | 132.900637975462
1 | 1103 | 4909 | 111A | LT | 8.625 | 445 | 27.23 | 27.3133 | 445 | 8.625 | 0 | 445 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 143 | 27.23 | 27.3133 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 13983 | 135.6584217581101
1 | 1103 | 4906 | 111A | LT | 8.625 | 784 | 27.3133 | 27.46 | 784 | 8.625 | 0 | 784 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 144 | 27.3133 | 27.46 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 3 | I1 | No | Yes | Yes | No | No | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 13984 | 225.0480549248679
1 | 1103 | 4910 | 111A | LT | 8.625 | 395 | 27.46 | 27.53 | 395 | 8.625 | 0 | 395 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 145 | 27.46 | 27.53 | 0.800 | ARC | SPIRAL | BLSP | 35000 | 0.203 | 1945-01-01 00:00:00 | 0 | L | 0 | 400 | 30.3483 | 400 | 30.3483 | 1945-01-01 00:00:00 | 3 | I1 | No | Yes | Yes | No | No | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 13980 | 160.7351376929226
1 | 1103 | 4907 | 111A | LT | 8.625 | 32 | 27.53 | 27.5361 | 32 | 8.625 | 0 | 32 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 147 | 27.53 | 27.5361 | 1.000 | ARC | DSAW | BUTT | -24000 | -0.141 |  | 0 |  | 0 | 0 | 0 | -400 | -50.9752 |  | 2 | I8 | No | Yes | Yes | No | No | FabNoTest1 | -50.98 | 0 | N | Sub_J No | Fab&Con |  | 13982 | 9.930948813548431