Spreadsheet: 101805d1299850927-extracting-specifics-from-xls-file-excel-2003-pl-replacements-1100-and-1200
Sheet: 1201-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 | 1201 | 20052 | BD448 | BD | 12.75 | 5 | 0 | 0 | 5 | 12.75 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 604 | 0 | 0 | -0.800 |  |  |  | -42000 | -0.203 |  | 0 |  | 0 | 0 | -9 | -650 | -60.7517 |  | -3 | N3 |  |  |  |  |  | ManuNoTestHCA | -60.75 | 0 | N |  |  |  | 4695 | 1.663069755343019
1 | 1201 | 20053 | BD448 | BD | 12.75 | 5 | 0 | 0 | 5 | 12.75 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 606 | 0 | 0 | -0.800 |  |  |  | -42000 | -0.203 |  | 0 |  | 0 | 0 | -9 | -650 | -60.7517 |  | -3 | N3 |  |  |  |  |  | ManuNoTestHCA | -60.75 | 0 | N |  |  |  | 4694 | 1.523195856272172
1 | 1201 | 20044 | BD445 | BD | 12.75 | 25 | 0 | 0 | 25 | 12.75 | 0 | 25 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 601 | 0 | 0 | -0.800 |  |  |  | -42000 | -0.203 |  | 0 |  | 0 | 0 | -9 | -650 | -60.7517 |  | -3 | N3 |  |  |  |  |  | ManuNoTestHCA | -60.75 | 0 | N |  |  |  | 4687 | 7.621023600338742
1 | 1201 | 20045 | BD445 | BD | 12.75 | 25 | 0 | 0 | 25 | 12.75 | 0 | 25 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 600 | 0 | 0 | -0.800 |  |  |  | -42000 | -0.203 |  | 0 |  | 0 | 0 | -9 | -650 | -60.7517 |  | -3 | N3 |  |  |  |  |  | ManuNoTestHCA | -60.75 | 0 | N |  |  |  | 4686 | 7.621077595358203
2 | 1201 | 20039 | BD443 | BD | 10.75 | 98 | 18.56 | 18.56 | 98 | 10.75 | 98 | 0 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 606 | 18.56 | 18.56 | -1.000 |  |  |  | -35000 | -0.188 |  | 0 |  | 0 | 0 | -9 | 650 | -53.0965 | 1965-01-01 00:00:00 | 1 | N3 |  |  |  |  |  | ManuNoTest | -53.1 | 0 | N |  |  |  | 4672 | 29.70394567250767
1 | 1201 | 20050 | BD448 | BD | 16 | 5 | 0 | 0 | 5 | 16 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 605 | 0 | 0 | -0.800 |  |  |  | -42000 | -0.219 |  | 0 |  | 0 | 0 | -9 | -650 | -70.6675 |  | -3 | N3 |  |  |  |  |  | ManuNoTestHCA | -70.67 | 0 | N |  |  |  | 4688 | 1.523195852537902
1 | 1201 | 20051 | BD448 | BD | 16 | 5 | 0 | 0 | 5 | 16 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 603 | 0 | 0 | -0.800 |  |  |  | -42000 | -0.219 |  | 0 |  | 0 | 0 | -9 | -650 | -70.6675 |  | -3 | N3 |  |  |  |  |  | ManuNoTestHCA | -70.67 | 0 | N |  |  |  | 4689 | 1.523253160669487
1 | 1201 | 24157 | STUB6220 | LT | 4.5 | 5 | 0 | 0 | 5 | 4.5 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 401 | 0 | 0 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -650 | -72.0301 |  | -3 | N1 |  |  |  |  |  | ManuNoTestHCA | -72.03 | 0 | N |  |  |  | 4690 | 1.523195854437097
1 | 1201 | 24158 | STUB6220 | LT | 4.5 | 5 | 0 | 0 | 5 | 4.5 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 402 | 0 | 0 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -650 | -54.0226 |  | -3 | N1 |  |  |  |  |  | ManuNoTestHCA | -54.02 | 0 | N |  |  |  | 4692 | 1.523195858143887
1 | 1201 | 22927 | DRIP8710 | LT | 12.75 | 6 | 0 | 0.0011 | 6 | 12.75 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 100 | 0 | 0.0011 | 1.000 | ARC | SMLS | BUTT | -35000 | 0.375 |  | 0 |  | 0 | 0 | 0 | -650 | -31.5714 |  | -3 | I9 | No | Yes | Yes | Yes | No | FabNoTest1 | -31.57 | 0 | N | Sub_J No | Fab&Con |  | 14863 | 1.829497700206149
2 | 1201 | 24783 | X6492 | LT | 8.625 | 8 | 18.56 | 18.56 | 8 | 8.625 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 605 | 18.56 | 18.56 | -1.000 |  |  |  | -35000 | -0.172 |  | 0 |  | 0 | 0 | -9 | 650 | -46.5635 | 1965-01-01 00:00:00 | 1 | N1 |  |  |  |  |  | ManuNoTest | -46.56 | 0 | N |  |  |  | 4670 | 2.134223608922637
2 | 1201 | 24785 | X6492 | LT | 8.625 | 8 | 18.56 | 18.56 | 8 | 8.625 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 603 | 18.56 | 18.56 | -1.000 |  |  |  | -35000 | -0.172 |  | 0 |  | 0 | 0 | -9 | 650 | -46.5635 | 1965-01-01 00:00:00 | 1 | N1 |  |  |  |  |  | ManuNoTest | -46.56 | 0 | N |  |  |  | 4574 | 2.134223608911522
2 | 1201 | 24784 | X6492 | LT | 10.75 | 12 | 18.56 | 18.56 | 12 | 10.75 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 604 | 18.56 | 18.56 | -1.000 |  |  |  | -35000 | -0.188 |  | 0 |  | 0 | 0 | -9 | 650 | -53.0965 | 1965-01-01 00:00:00 | 1 | N1 |  |  |  |  |  | ManuNoTest | -53.1 | 0 | N |  |  |  | 4669 | 3.961857494171063
2 | 1201 | 24782 | X6492 | LT | 10.75 | 32 | 18.56 | 18.56 | 32 | 10.75 | 32 | 0 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 602 | 18.56 | 18.56 | -1.000 |  |  |  | -35000 | -0.188 |  | 0 |  | 0 | 0 | -9 | 650 | -53.0965 | 1965-01-01 00:00:00 | 1 | N1 |  |  |  |  |  | ManuNoTest | -53.1 | 0 | N |  |  |  | 4671 | 10.05513579272317
1 | 1201 | 24035 | STUB6029 | LT | -16 | 20 | 0 | 0 | 20 | 16 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 100 | 0 | 0 | -1.000 |  |  |  | -35000 | -0.219 |  | 0 |  | 0 | 0 | -9 | -450 | -46.9667 |  | -3 | N5 |  |  |  |  |  | ManuNoTestHCA | -46.97 | 0 | N |  |  |  | 4205 | 6.092488707974553
1 | 1201 | 22924 | DRIP8709 | LT | 20 | 108 | 0.0011 | 0.0216 | 108 | 20 | 0 | 108 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 101 | 0.0011 | 0.0216 | 1.000 | ARC | SMLS | BUTT | -35000 | 0.375 |  | 0 |  | 0 | 0 | 0 | -650 | -49.5238 |  | -3 | I5 | No | Yes | Yes | Yes | No | FabNoTest1 | -49.52 | 0 | N | Sub_J No | Fab&Con |  | 14990 | 32.92252168172411
1 | 1201 | 23923 | STUB7018 | SERV | -2.375 | 5 | 0 | 0.0009 | 5 | 2.38 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 101 | 0 | 0.0009 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -650 | -38.0159 |  | -3 | N1 |  |  |  |  |  | ManuNoTestHCA | -38.02 | 0 | N |  |  |  | 12337 | 1.527144689139417
1 | 1201 | 24154 | STUB6218 | SERV | -2.375 | 5 | 0 | 0 | 5 | 2.38 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 102 | 0 | 0 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -650 | -38.0159 |  | -3 | N1 |  |  |  |  |  | ManuNoTestHCA | -38.02 | 0 | N |  |  |  | 12331 | 1.523744237381968
1 | 1201 | 22528 | DREG5260 | SERV | 2.375 | 21 | 0 | 0.004 | 21 | 2.375 | 0 | 21 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 102 | 0 | 0.004 | -0.600 |  |  |  | -25000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -650 | -36.4953 | 1967-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -36.5 | 0 | N |  |  |  | 12387 | 6.72879870360693
1 | 1201 | 21912 | DFDS6881 | SERV | 2.375 | 31 | 0 | 0.0059 | 31 | 2.375 | 0 | 31 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 101 | 0 | 0.0059 | -0.600 |  |  |  | -25000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -650 | -36.4953 | 1967-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -36.5 | 0 | N |  |  |  | 12386 | 9.161421101666223
1 | 1201 | 23164 | GCUST5885 | SERV | 2.375 | 571 | 0.46 | 0.5682 | 571 | 2.375 | 0 | 571 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 104 | 0.46 | 0.5682 | -0.600 |  |  |  | -25000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -650 | -36.4953 | 1964-01-01 00:00:00 | 3 | I1 | No | Yes | No | Yes | No | ManuNoTestHCA | -36.5 | 0 | N |  |  |  | 12405 | 175.356831242161