Spreadsheet: 101805d1299850927-extracting-specifics-from-xls-file-excel-2003-pl-replacements-1100-and-1200
Sheet: 1103-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 | 1103 | 19766 | BD2 | BD | 6.625 | 79 | 0 | 0.01 | 79 | 6.625 | 0 | 79 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 601 | 0 | 0.01 | 1.000 | ARC | SMLS | BUTT | 35000 | 0.188 |  | 0 |  | 0 | 650 | 32.7223 | 650 | 32.7223 |  | -3 | [NAME] |  |  |  |  |  | FabNoTest1 | 32.72 | 0 | N | Sub_J No | Fab&Con |  | 23667 | 25.45523616884302
1 | 1103 | 22851 | DRIP5664 | LT | -8.625 | 5 | 0 | 0.0009 | 5 | 8.625 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 651 | 0 | 0.0009 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -400 | -63.719 |  | 3 | I1 | No | Yes | Yes | No | No | ManuNoTestHCA | -63.72 | 0 | N |  |  |  | 13055 | 1.912746255484992
1 | 1103 | 22853 | DRIP5666 | LT | -8.625 | 5 | 0 | 0 | 5 | 8.625 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 111 | 0 | 0 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -400 | -63.719 |  | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | -63.72 | 0 | N |  |  |  | 12899 | 1.523744231991659
1 | 1103 | 24081 | STUB6107 | LT | -12.75 | 5 | 0 | 0 | 5 | 12.75 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 121 | 0 | 0 | -1.000 |  |  |  | -35000 | -0.203 | 1990-01-01 00:00:00 | 0 |  | 0 | 0 | -9 | -400 | -35.8902 |  | -3 | I1 | No | Yes | Yes | No | No | ManuNoTestHCA | -35.89 | 0 | N |  |  |  | 2617 | 1.524505091680151
1 | 1103 | 24082 | STUB6108 | LT | 6.625 | 5 | 0 | 0 | 5 | 6.625 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 200 | 0 | 0 |  |  |  |  | 0 | 0 | 1990-01-01 00:00:00 | 0 |  | 0 | 0 | -9 | -400 | 0 |  | -3 | Z15 |  |  |  |  |  | ManuNoTestHCA | -9 | 0 | N |  |  |  | 13035 | 1.525535319443295
1 | 1103 | 24083 | STUB6108 | LT | 6.625 | 5 | 0 | 0 | 5 | 6.625 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 201 | 0 | 0 |  |  |  |  | 0 | 0 | 1990-01-01 00:00:00 | 0 |  | 0 | 0 | -9 | -400 | 0 |  | -3 | Z15 |  |  |  |  |  | ManuNoTestHCA | -9 | 0 | N |  |  |  | 13036 | 1.521975616480037
1 | 1103 | 24211 | STUB7093 | LT | 8.625 | 5 | 0 | 0.09 | 5 | 8.625 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 140.1 | 0 | 0.0009 | 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 | I9 | No | Yes | Yes | No | No | ManuNoTestHCA | 30.35 | 0 | N |  |  |  | 24320 | 1.524963056219779
1 | 1103 | 24213 | STUB7094 | LT | 8.625 | 113 | 0 | 0.0214 | 113 | 8.625 | 0 | 113 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 140 | 0 | 0.0214 | 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 |  |  |  | 24318 | 34.44430614055408
1 | 1103 | 24262 | STUB7812 | LT | 4.5 | 5 | 0 | 0 | 5 | 4.5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 601 | 0 | 0 | -0.600 |  |  |  | 24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -400 | -44.3262 |  | 2 | N5 |  |  |  |  |  | ManuNoTestHCA | -44.33 | 0 | N |  |  |  | 1454 | 1.524300596924636
1 | 1103 | 24263 | STUB7813 | LT | 4.5 | 5 | 0 | 0 | 5 | 4.5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 602 | 0 | 0 | -0.600 |  |  |  | 24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -400 | -44.3262 |  | 2 | N5 |  |  |  |  |  | ManuNoTestHCA | -44.33 | 0 | N |  |  |  | 1455 | 1.524112437514653
1 | 1103 | 24630 | X6397 | LT | -8.625 | 139 | 0 | 0.0263 | 139 | 8.625 | 139 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 501 | 0 | 0.0263 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -400 | -63.719 |  | 3 | I5 | No | Yes | Yes | No | No | ManuNoTestHCA | -63.72 | 0 | N |  |  |  | 13978 | 42.14226668298136
1 | 1103 | 24632 | X6397 | LT | -8.625 | 7 | 0.0271 | 0.0284 | 7 | 8.625 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 503 | 0.0271 | 0.0284 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -400 | -63.719 |  | 3 | I5 | No | Yes | Yes | No | No | ManuNoTestHCA | -63.72 | 0 | N |  |  |  | 13979 | 2.263803372678165
1 | 1103 | 24633 | [NAME] | LT | 6.625 | 12 | 0 | 0 | 12 | 4.5 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 112 | 0 | 0 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -400 | -48.9436 |  | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | -48.94 | 0 | N |  |  |  | 6731 | 3.703371626154732
1 | 1103 | 21952 | DREG10155 | SERV | -4.5 | 71 | 0 | 0 | 71 | 4.5 | 0 | 71 | 0 | 1 | 60 | 0 | 0 | no | 0 |  | 100 | 0 | 0 | -0.800 | ARC | DSAW | BUTT | -24000 | -0.141 |  | 0 |  | 0 | 0 | 0 | -400 | -33.2447 |  | -3 | [NAME] |  |  |  |  |  | ManuNoTestHCA | -33.24 | 0 | N |  |  |  | 21272 | 24.38073156403305
1 | 1103 | 22237 | DREG4436 | SERV | 3.5 | 468 | 0 | 0.09 | 468 | 3.5 | 468 | 0 | 0 | 1 | 24 | 0 | 0 | no | 0 |  | 129 | 0 | 0.09 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -400 | -34.476 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -34.48 | 0 | N |  |  |  | 12979 | 140.9062906528802
1 | 1103 | 23286 | GCUST5944 | SERV | 4.5 | 2317 | 1.43 | 1.87 | 2317 | 4.5 | 2317 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 104 | 1.43 | 1.87 | -0.600 |  |  |  | -24000 | -0.141 | 1990-01-01 00:00:00 | 0 |  | 0 | 0 | -9 | -400 | -44.3262 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -44.33 | 0 | N |  |  |  | 2600 | 706.408450795612