Spreadsheet: 101805d1299850927-extracting-specifics-from-xls-file-excel-2003-pl-replacements-1100-and-1200
Sheet: 1101A -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 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 | 20077 | BD464 | BD | 12.75 | 450 | 0 | 0.85 | 476 | 12.75 | 476 | 0 | 0 | 1 | 70 | 0 | 0 | no | 0 |  | 221.2 | 0 | 0.085 | 1.000 | ARC |  |  | -35000 | -0.203 |  | 0 |  | 0 | 817 | -73.3058 | 766 | -68.7298 | 1953-01-01 00:00:00 | 2 | I3 |  |  |  |  |  | ManuNoTestHCA | -68.73 | 0 | N |  |  |  | 13715 | 145.2029915633622
1 | 1101A | 20102 | BD464 | BD | 12.75 | 163 | 237.5 | 237.5 | 161 | 12.75 | 161 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 210.4 | 237.5 | 237.5 | 1.000 | ARC |  |  | -35000 | -0.203 |  | 0 |  | 0 | 0 | -9 | 766 | -68.7298 | 1953-01-01 00:00:00 | 2 | N3 |  |  |  |  |  | ManuNoTestHCA | -68.73 | 0 | N |  |  |  | 4131 | 49.54536170597674
1 | 1101A | 20106 | BD465 | BD | 12.75 | 440 | 0 | 0.08 | 257 | 12.75 | 257 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 602 | 0 | 0.08 | -0.800 |  |  |  | -24000 | -0.25 |  | 0 |  | 0 | 0 | -9 | -660 | -87.6563 |  | -1 | I3 |  |  |  |  |  | ManuNoTestHCA | -87.66 | 0 | N |  |  |  | 13382 | 78.71165426223611
1 | 1101A | 20107 | [NAME] | BD | 12.75 | 440 | 0 | 0.8 | 440 | 12.75 | 440 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 602 | 0 | 0.08 | -0.800 |  |  |  | -42000 | -0.25 |  | 0 |  | 0 | 0 | -9 | -660 | -50.0893 |  | -1 | I3 |  |  |  |  |  | ManuNoTestHCA | -50.09 | 0 | N |  |  |  | 13384 | 135.3002617746597
1 | 1101A | 20165 | [NAME] | BD | 6.625 | 110 | 0 | 0 | 110 | 6.625 | 110 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 605 | 0 | 0 | -0.800 |  |  |  | -42000 | -0.1875 |  | 0 |  | 0 | 0 | -9 | -573 | -30.128 |  | 2 | N3 |  |  |  |  |  | ManuNoTestHCA | -30.13 | 0 | N |  |  |  | 6805 | 33.4790366709244
2 | 1101A | 20169 | BD503 | BD | 12.75 | 302 | 0 | 0 | 302 | 12.75 | 302 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 601 | 0 | 0 | -0.800 |  |  |  | -42000 | -0.25 |  | 0 |  | 0 | 0 | -9 | -860 | -65.2679 |  | -1 | N3 |  |  |  |  |  | ManuNoTest | -65.27 | 0 | N |  |  |  | 13541 | 92.22904683904287
2 | 1101A | 20170 | BD503 | BD | 12.75 | 900 | 0 | 0 | 900 | 12.75 | 900 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 602 | 0 | 0 | -0.800 |  |  |  | -42000 | -0.25 |  | 0 |  | 0 | 0 | -9 | -860 | -65.2679 |  | -1 | N3 |  |  |  |  |  | ManuNoTest | -65.27 | 0 | N |  |  |  | 13542 | 123.7421547009813
1 | 1101A | 20250 | BD549 | BD | 12.75 | 100 | 237.5 | 237.5 | 107 | 12.75 | 107 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 251.4 | 237.5 | 237.5 | 1.000 | ARC |  |  | -35000 | -0.203 |  | 0 |  | 0 | 0 | -9 | 766 | -68.7298 | 1950-01-01 00:00:00 | 2 | N3 |  |  |  |  |  | ManuNoTestHCA | -68.73 | 0 | N |  |  |  | 4133 | 32.83969241072067
1 | 1101A | 20263 | BD549 | BD | 12.75 | 110 | 241.4 | 241.4 | 110 | 12.75 | 110 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 255.8 | 241.4 | 241.4 | 1.000 |  |  |  | -35000 | -0.203 | 1975-01-01 00:00:00 | 0 | W | 0 | 816 | -73.216 | 766 | -68.7298 | 1950-01-01 00:00:00 | 2 | N3 |  |  |  |  |  | ManuNoTestHCA | -68.73 | 0 | N |  |  |  | 4079 | 33.54767035173754
1 | 1101A | 20323 | [NAME] | BD | 12.75 | 115 | 0 | 0.2 | 110 | 12.75 | 110 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 601 | 0 | 0.02 | 1.000 | ARC |  | BUTT | -42000 | -0.25 |  | 0 |  | 0 | 0 | -9 | 573 | -34.7893 | 1952-01-01 00:00:00 | 2 | N3 |  |  |  |  |  | ManuNoTestHCA | -34.79 | 0 | N |  |  |  | 6855 | 33.02188545374433
2 | 1101A | 20327 | BD580 | BD | 12.75 | 335 | 0 | 0 | 335 | 12.75 | 335 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 601 | 0 | 0 | -0.800 |  |  |  | -42000 | -0.25 |  | 0 |  | 0 | 0 | -9 | -860 | -65.2679 |  | -1 | N3 |  |  |  |  |  | ManuNoTest | -65.27 | 0 | N |  |  |  | 13580 | 101.7705343035414
2 | 1101A | 20328 | BD580 | BD | 12.75 | 17 | 0 | 0 | 17 | 12.75 | 17 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 602 | 0 | 0 | -0.800 |  |  |  | -42000 | -0.25 |  | 0 |  | 0 | 0 | -9 | -860 | -65.2679 |  | -1 | N3 |  |  |  |  |  | ManuNoTest | -65.27 | 0 | N |  |  |  | 13581 | 4.842926590378374
2 | 1101A | 20462 | BD670 | BD | 8.625 | 10 | 0 | 0 | 10 | 8.625 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 601 | 0 | 0 | -0.800 |  |  |  | -42000 | -0.25 |  | 0 |  | 0 | 0 | -9 | -860 | -44.1518 |  | -1 | N3 |  |  |  |  |  | ManuNoTest | -44.15 | 0 | N |  |  |  | 8042 | 3.02104400948311
2 | 1101A | 20463 | BD671 | BD | 6.625 | 113 | 0 | 0 | 113 | 6.625 | 113 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 601 | 0 | 0 | -0.800 |  |  |  | -42000 | -0.1875 |  | 0 |  | 0 | 0 | -9 | -861 | -45.2708 |  | -1 | N3 |  |  |  |  |  | ManuNoTest | -45.27 | 0 | N |  |  |  | 6801 | 34.43403207179045
1 | 1101A | 21871 | DFDS3672 | DFM | 6.625 | 1754 | 0 | 0.33 | 1750 | 6.625 | 1750 | 0 | 0 | 1 | 90 | 0 | 0 | no | 1 |  | 703 | 0 | 0.33 | 1.000 |  |  |  | -35000 | -0.188 |  | 0 |  | 0 | 0 | -9 | -860 | -43.2941 | 1957-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -43.29 | 0 | N |  |  |  | 8182 | 524.9543322728358
1 | 1101A | 24184 | STUB6261 | LT | 4.5 | 4 | 0 | 0 | 7 | 4.5 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 551 | 0 | 0 | -0.600 |  |  |  | -35000 | -0.148 |  | 0 |  | 0 | 0 | -9 | -550 | -39.8166 |  | 2 | N5 |  |  |  |  |  | ManuNoTestHCA | -39.82 | 0 | N |  |  |  | 6536 | 2.131499576142081
1 | 1101A | 21167 | DCUST2438 | SERV | 4.5 | 127 | 0 | 0 | 129 | 4.5 | 129 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 902 | 0 | 0 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -573 | -63.4973 |  | -3 | N5 |  |  |  |  |  | ManuNoTestHCA | -63.5 | 0 | N |  |  |  | 13414 | 38.49264169725183
2 | 1101A | 21247 | DCUST2570 | SERV | 2.375 | 80 | 0 | 0 | 80 | 2.375 | 80 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 901 | 0 | 0 | -0.600 |  |  |  | -25000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -861 | -48.3422 | 1957-01-01 00:00:00 | 1 | N5 |  |  |  |  |  | ManuNoTest | -48.34 | 0 | N |  |  |  | 6786 | 24.42989368288439
1 | 1101A | 21248 | [NAME] | SERV | 2.375 | 80 | 0 | 0.0152 | 80 | 2.375 | 80 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 901 | 0 | 0.0152 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -550 | -32.1673 |  | 2 | N5 |  |  |  |  |  | ManuNoTestHCA | -32.17 | 0 | N |  |  |  | 8176 | 24.42003111307831