Spreadsheet: 101805d1299850927-extracting-specifics-from-xls-file-excel-2003-pl-replacements-1100-and-1200
Sheet: 1102-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 | 1102 | 19899 | [NAME] | BD | 6.625 | 55 | 0 | 0 | 55 | 6.625 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 601 | 0 | 0 | -0.800 |  |  |  | -42000 | -0.188 |  | 0 |  | 0 | 0 | -9 | -650 | -34.0857 |  | 3 | [NAME] |  |  |  |  |  | ManuNoTestHCA | -34.09 | 0 | N |  |  |  | 23776 | 16.76988858582137
1 | 1102 | 24612 | [NAME] | LT | 12.75 | 4 | 2.63 | 2.63 | 4 | 12.75 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 503 | 2.63 | 2.63 | -1.000 |  | ERW |  | -30000 | -0.203 |  | 0 |  | 0 | 0 | -9 | -650 | -68.0419 |  | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | -68.04 | 0 | N |  |  |  | 18538 | 1.182739870276212
1 | 1102 | 24613 | [NAME] | LT | 12.75 | 4 | 2.63 | 2.63 | 4 | 12.75 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 502 | 2.63 | 2.63 | -1.000 |  | ERW |  | -30000 | -0.203 |  | 0 |  | 0 | 0 | -9 | -650 | -68.0419 |  | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | -68.04 | 0 | N |  |  |  | 18537 | 1.169039387548309
1 | 1102 | 21359 | DCUST9225 | SERV | -16 | 80 | 0 | 0.0152 | 80 | 16 | 80 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 101 | 0 | 0.0152 | 1.000 | ARC | DSAW | BUTT | -35000 | -0.219 |  | 0 |  | 0 | 0 | 0 | -650 | -67.8408 |  | -2 | N2 |  |  |  |  |  | FabNoTest1 | -67.84 | 0 | N | Sub_J No | Fab&Con |  | 17617 | 24.38015236175899
1 | 1102 | 22207 | DREG4373 | SERV | 2.375 | 69 | 0 | 0.01 | 70 | 4.5 | 0 | 70 | 0 | 1 | 40 | 0 | 0 | no | 1 |  | 801 | 0 | 0.01 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -650 | -38.0159 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -38.02 | 0 | N |  |  |  | 1809 | 21.03290623273564
1 | 1102 | 22258 | DREG4505 | SERV | 4.5 | 43 | 0 | 0.01 | 43 | 4.5 | 43 | 0 | 0 | 1 | 24 | 0 | 0 | no | 0 |  | 101 | 0 | 0.01 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | -254 | -28.1472 | -650 | -72.0301 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -72.03 | 0 | N |  |  |  | 24462 | 12.85553549549764
1 | 1102 | 22272 | DREG4556 | SERV | 2.375 | 51 | 0 | 0.01 | 51 | 2.375 | 51 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 402 | 0 | 0.01 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 800 | -46.7888 | 650 | -38.0159 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -38.02 | 0 | N |  |  |  | 1815 | 15.55450693381247
1 | 1102 | 22330 | DREG4781 | SERV | 2.375 | 100 | 0 | 0.02 | 100 | 2.375 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 801 | 0 | 0.02 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -650 | -38.0159 |  | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | -38.02 | 0 | N |  |  |  | 2681 | 30.4952926527173
1 | 1102 | 24090 | STUB6118 | DFM | -4.5 | 30 | 0 | 0 | 30 | 4.5 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | no | 0 |  | 551 | 0 | 0 |  |  |  |  | 0 | 0 |  | 0 |  | 0 | 0 | -9 | -300 | 0 |  | -3 | N1 |  |  |  |  |  | ManuNoTestHCA | -9 | 0 | N |  |  |  | 1833 | 9.145040048048017