Spreadsheet: 101805d1299850927-extracting-specifics-from-xls-file-excel-2003-pl-replacements-1100-and-1200
Sheet: 1202-BO

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 | 1202 | 19856 | BD27 | BD | 4.5 | 10 | 10.84 | 10.84 | 10 | 4.5 |  | 10 |  |  |  |  |  |  |  |  | 201 | 10.84 | 10.84 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | -450 | -49.867 | -450 | -49.867 |  | -3 | I6 |  |  |  |  |  | ManuNoTestHCA | -49.87 | 0 | N |  |  |  | 24447 | 2.923872806734972
1 | 1202 | 19855 | BD27 | BD | 4.5 | 30 | 10.84 | 10.84 | 30 | 4.5 |  | 30 |  |  |  |  |  |  |  |  | 200 | 10.84 | 10.84 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | -450 | -49.867 | -450 | -49.867 |  | -3 | I6 |  |  |  |  |  | ManuNoTestHCA | -49.87 | 0 | N |  |  |  | 24423 | 9.036262324835938
2 | 1202 | 19854 | BD27 | BD | 8.625 | 5 | 6.43 | 6.43 | 5 | 8.625 |  | 8.625 |  |  |  |  |  |  |  |  | 102 | 6.43 | 6.43 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | -450 | -71.6838 | -450 | -71.6838 |  | 1 | [NAME] |  |  |  |  |  | ManuNoTest | -71.68 | 0 | N |  |  |  | 22272 | 1.522467106948761
1 | 1202 | 20709 | BD8544 | BD | 4.5 | 4 | 0 | 0.001 | 4 | 4.5 |  | 4 |  |  |  |  |  |  |  |  | 101 | 0 | 0.001 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | -450 | -49.867 | -450 | -49.867 |  | -3 | [NAME] |  |  |  |  |  | ManuNoTestHCA | -49.87 | 0 | N |  |  |  | 22261 | 1.185646072545333
1 | 1202 | 20708 | BD8544 | BD | 4.5 | 15 | 0 | 0.002 | 15 | 4.5 |  | 15 |  |  |  |  |  |  |  |  | 100 | 0 | 0.002 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | -450 | -49.867 | -450 | -49.867 |  | -3 | [NAME] |  |  |  |  |  | ManuNoTestHCA | -49.87 | 0 | N |  |  |  | 22260 | 5.448314199119118
2 | 1202 | 20710 | BD8545 | BD | 4.5 | 5 | 0 | 0.001 | 5 | 4.5 |  | 5 |  |  |  |  |  |  |  |  | 100 | 0 | 0.001 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | -450 | -49.867 | -450 | -49.867 |  | 1 | [NAME] |  |  |  |  |  | ManuNoTest | -49.87 | 0 | N |  |  |  | 22270 | 1.522467103738135
1 | 1202 | 20712 | BD8547 | BD | 6.625 | 13 | 16.66 | 16.66 | 13 | 6.625 |  | 13 |  |  |  |  |  |  |  |  | 100 | 16.66 | 16.66 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | -450 | -55.0615 | -450 | -55.0615 |  | -3 | I6 |  |  |  |  |  | ManuNoTestHCA | -55.06 | 0 | N |  |  |  | 22265 | 3.993217053245607
1 | 1202 | 20713 | BD8547 | BD | 6.625 | 18 | 16.66 | 16.66 | 18 | 6.625 |  | 18 |  |  |  |  |  |  |  |  | 101 | 16.66 | 16.66 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | -450 | -55.0615 | -450 | -55.0615 |  | -3 | I6 |  |  |  |  |  | ManuNoTestHCA | -55.06 | 0 | N |  |  |  | 22264 | 3.782388187070093
2 | 1202 | 20718 | BD8550 | BD | 4.5 | 5 | 0 | 0.001 | 5 | 4.5 |  | 5 |  |  |  |  |  |  |  |  | 101 | 0 | 0.001 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | -450 | -49.867 | -450 | -49.867 |  | 1 | [NAME] |  |  |  |  |  | ManuNoTest | -49.87 | 0 | N |  |  |  | 22271 | 1.525633401321221
2 | 1202 | 20721 | BD8553 | BD | 6.625 | 5 | 0 | 0.001 | 5 | 6.625 |  | 5 |  |  |  |  |  |  |  |  | 101 | 0 | 0.001 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | -450 | -55.0615 | -450 | -55.0615 |  | 1 | [NAME] |  |  |  |  |  | ManuNoTest | -55.06 | 0 | N |  |  |  | 22269 | 1.522467105180014
2 | 1202 | 20720 | BD8553 | BD | 6.625 | 25 | 0 | 0.004 | 25 | 6.625 |  | 25 |  |  |  |  |  |  |  |  | 100 | 0 | 0.004 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | -450 | -55.0615 | -450 | -55.0615 |  | 1 | [NAME] |  |  |  |  |  | ManuNoTest | -55.06 | 0 | N |  |  |  | 22268 | 9.14043537895931
1 | 1202 | 24272 | STUB7941 | LT | 4.5 | 1 | 0.0008 | 0.0015 | 1 | 4.5 |  | 1 |  |  |  |  |  |  |  |  | 552 | 0.0008 | 0.0015 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -450 | -49.867 | 1941-01-01 00:00:00 | 3 | A1 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -49.87 | 0 | N |  |  |  | 19325 | 0.3055644480858853
1 | 1202 | 24273 | STUB7941 | LT | 4.5 | 1 | 0 | 0.0008 | 1 | 4.5 |  | 1 |  |  |  |  |  |  |  |  | 551 | 0 | 0.0008 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -450 | -49.867 | 1941-01-01 00:00:00 | 3 | A1 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -49.87 | 0 | N |  |  |  | 19324 | 0.3055644433370533
1 | 1202 | 24274 | STUB7942 | LT | 4.5 | 1 | 0 | 0.0008 | 1 | 4.5 |  | 1 |  |  |  |  |  |  |  |  | 551 | 0 | 0.0008 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -450 | -49.867 | 1941-01-01 00:00:00 | 3 | A1 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -49.87 | 0 | N |  |  |  | 19326 | 0.3104628592421183
1 | 1202 | 24275 | STUB7942 | LT | 4.5 | 1 | 0.0008 | 0.0015 | 1 | 4.5 |  | 1 |  |  |  |  |  |  |  |  | 552 | 0.0008 | 0.0015 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -450 | -49.867 | 1941-01-01 00:00:00 | 3 | A1 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -49.87 | 0 | N |  |  |  | 19327 | 0.3006691765563376
1 | 1202 | 24569 | X6338 | LT | 6.625 | 2 | 16.66 | 16.66 | 2 | 6.625 |  | 2 |  |  |  |  |  |  |  |  | 99 | 16.66 | 16.66 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -450 | -55.0615 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -55.06 | 0 | N |  |  |  | 11032 | 0.7012750004142201
1 | 1202 | 24568 | X6338 | LT | 12.75 | 10 | 16.66 | 16.66 | 10 | 12.75 |  | 10 |  |  |  |  |  |  |  |  | 101 | 16.66 | 16.66 | -0.800 |  |  |  | -24000 | -0.203 |  | 0 |  | 0 | 0 | -9 | -450 | -73.603 |  | 3 | I1 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -73.6 | 0 | N |  |  |  | 11038 | 2.810014267502672
2 | 1202 | 24570 | X6339 | LT | 12.75 | 15 | 6.42 | 6.42 | 15 | 12.75 | 15 |  |  |  |  |  |  |  |  |  | 101 | 6.42 | 6.42 | -0.800 |  |  |  | -24000 | -0.203 |  | 0 |  | 0 | 0 | -9 | -450 | -73.603 |  | 1 | N1 |  |  |  |  |  | ManuNoTest | -73.6 | 0 | N |  |  |  | 228 | 4.459893419787607
2 | 1202 | 24571 | X6339 | LT | 12.75 | 15 | 6.42 | 6.42 | 15 | 12.75 | 15 |  |  |  |  |  |  |  |  |  | 100 | 6.42 | 6.42 | -0.800 |  |  |  | -24000 | -0.203 |  | 0 |  | 0 | 0 | -9 | -450 | -73.603 |  | 1 | N1 |  |  |  |  |  | ManuNoTest | -73.6 | 0 | N |  |  |  | 229 | 4.471478392116237
1 | 1202 | 24574 | X6340 | LT | 8.625 | 4 | 13.72 | 13.72 | 4 | 8.625 |  | 4 |  |  |  |  |  |  |  |  | 101 | 13.72 | 13.72 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -450 | -71.6838 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -71.68 | 0 | N |  |  |  | 14208 | 1.240615793884156
1 | 1202 | 24572 | X6340 | LT | 12.75 | 11 | 13.72 | 13.72 | 11 | 12.75 |  | 11 |  |  |  |  |  |  |  |  | 100 | 13.72 | 13.72 | -0.800 |  |  |  | -24000 | -0.203 |  | 0 |  | 0 | 0 | -9 | -450 | -73.603 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -73.6 | 0 | N |  |  |  | 14206 | 3.296314816037186
1 | 1202 | 24573 | X6340 | LT | 8.625 | 15 | 13.72 | 13.72 | 15 | 8.625 |  | 15 |  |  |  |  |  |  |  |  | 102 | 13.72 | 13.72 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -450 | -71.6838 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -71.68 | 0 | N |  |  |  | 14207 | 4.566997256048845
1 | 1202 | 24575 | X6341 | LT | 6.625 | 2 | 16.09 | 16.09 | 2 | 6.625 |  | 2 |  |  |  |  |  |  |  |  | 99 | 16.09 | 16.09 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -450 | -55.0615 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -55.06 | 0 | N |  |  |  | 11031 | 0.595462141928752
1 | 1202 | 24576 | [NAME] | LT | 12.75 | 10 | 16.66 | 16.66 | 10 | 12.75 |  | 10 |  |  |  |  |  |  |  |  | 100 | 16.66 | 16.66 | -0.800 |  |  |  | -24000 | -0.203 |  | 0 |  | 0 | 0 | -9 | -450 | -73.603 |  | 3 | I1 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -73.6 | 0 | N |  |  |  | 11037 | 2.8264823007987
1 | 1202 | 25029 | X8552 | LT | 6.625 | 7 | 13.72 | 13.72 | 7 | 6.625 |  | 7 |  |  |  |  |  |  |  |  | 100 | 13.72 | 13.72 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | -450 | -55.0615 | -450 | -55.0615 |  | -3 | [NAME] |  |  |  |  |  | ManuNoTestHCA | -55.06 | 0 | N |  |  |  | 22259 | 2.024823304341835
1 | 1202 | 21404 | DF3222 | SERV | 3.5 | 3 | 0 | 0 | 3 | 3.5 |  | 3 |  |  |  |  |  |  |  |  | 100 | 0 | 0 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -450 | -38.7855 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -38.79 | 0 | N |  |  |  | 11033 | 0.7816601029836346
1 | 1202 | 21774 | DFDS3544 | SERV | 4.5 | 123 | 0 | 0 | 123 | 4.5 |  | 123 |  |  |  |  |  |  |  |  | 100 | 0 | 0 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -450 | -49.867 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -49.87 | 0 | N |  |  |  | 211 | 37.74540152324744
1 | 1202 | 21775 | DFDS3545 | SERV | -4.5 | 30 | 0 | 0.0056 | 30 | 4.5 |  | 30 |  |  |  |  |  |  |  |  | 101 | 0 | 0.0056 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -450 | -49.867 |  | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -49.87 | 0 | N |  |  |  | 8129 | 9.141645087267818
1 | 1202 | 22050 | DREG3862 | SERV | 4.5 | 1 | 0 | 0 | 1 | 4.5 |  | 1 |  |  |  |  |  |  |  |  | 100.5 | 0 | 0 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -450 | -49.867 |  | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -49.87 | 0 | N |  |  |  | 20079 | 0.2908886874566347
1 | 1202 | 22051 | DREG3862 | SERV | 4.5 | 53 | 0 | 0.01 | 53 | 4.5 |  | 53 |  |  |  |  |  |  |  |  | 100 | 0 | 0.01 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -450 | -49.867 |  | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -49.87 | 0 | N |  |  |  | 24847 | 21.34866811777939
1 | 1202 | 22053 | DREG3867 | SERV | 4.5 | 161 | 0 | 0.03 | 161 | 4.5 |  | 161 |  | 1 | 95 |  |  |  |  |  | 100.3 | 0 | 0.03 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -450 | -49.867 |  | 3 | [NAME] |  |  |  |  |  | ManuNoTestHCA | -49.87 | 0 | N |  |  |  | 14730 | 44.26952630054751
1 | 1202 | 22054 | DREG3870 | SERV | 4.5 | 70 | 0 | 0.0133 | 70 | 4.5 |  | 70 |  |  |  |  |  |  |  |  | 100 | 0 | 0.0133 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -450 | -49.867 |  | 3 | I1 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -49.87 | 0 | N |  |  |  | 14231 | 21.36456902846052
1 | 1202 | 22059 | DREG3877 | SERV | 3.5 | 75 | 0 | 0 | 75 | 3.5 |  | 75 |  |  |  |  |  |  |  |  | 100 | 0 | 0 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -450 | -38.7855 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -38.79 | 0 | N |  |  |  | 5415 | 22.8611013183076