Spreadsheet: 101805d1299850927-extracting-specifics-from-xls-file-excel-2003-pl-replacements-1100-and-1200
Sheet: 1209-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 | 1209 | 20552 | [NAME] | BD | 2.375 | 10 | 0 | 0 | 10 | 2.375 |  | 10 |  |  |  |  |  |  |  |  | 1 | 0 | 0 | -0.600 |  |  |  | -25000 | -0.154 |  | 0 |  | 0 | 0 | -9 | -600 | -30.8442 |  | -3 | N5 |  |  |  |  |  | ManuNoTestHCA | -30.84 | 0 | N |  |  |  | 22315 | 3.047046535461665
1 | 1209 | 20628 | BD745 | BD | 2.375 | 2 | 0 | 0 | 2 | 2.375 |  | 2 |  |  |  |  |  |  |  |  | 104 | 0 | 0 | -0.600 |  |  |  | -25000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -600 | -33.6879 |  | -3 | N5 |  |  |  |  |  | ManuNoTestHCA | -33.69 | 0 | N |  |  |  | 22346 | 0.6088393997297448
1 | 1209 | 20629 | BD745 | BD | 2.375 | 2 | 0 | 0 | 2 | 2.375 |  | 2 |  |  |  |  |  |  |  |  | 105 | 0 | 0 | -0.600 |  |  |  | -25000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -600 | -33.6879 |  | -3 | N5 |  |  |  |  |  | ManuNoTestHCA | -33.69 | 0 | N |  |  |  | 22347 | 0.612616550155304
1 | 1209 | 20633 | [NAME] | BD | 6.625 | 1 | 0 | 0 | 1 | 6.625 |  | 1 |  |  |  |  |  |  |  |  | 103 | 0 | 0 | -1.000 |  |  |  | -35000 | -0.156 |  | 0 |  | 0 | 0 | -9 | -600 | -36.4011 |  | -3 | [NAME] |  |  |  |  |  | ManuNoTestHCA | -36.4 | 0 | N |  |  |  | 22342 | 0.3047881254468768
1 | 1209 | 20634 | [NAME] | BD | 6.625 | 4 | 0 | 0 | 4 | 6.625 |  | 4 |  |  |  |  |  |  |  |  | 104 | 0 | 0 | -1.000 | ARC | DSAW | BUTT | -35000 | -0.156 |  | 0 |  | 0 | 0 | -9 | -600 | -36.4011 |  | -3 | [NAME] |  |  |  |  |  | ManuNoTestHCA | -36.4 | 0 | N |  |  |  | 22343 | 1.355411925346066
1 | 1209 | 20632 | [NAME] | BD | 8.625 | 6 | 0 | 0 | 6 | 8.625 |  | 6 |  |  |  |  |  |  |  |  | 107 | 0 | 0 | -1.000 |  |  |  | -35000 | -0.172 |  | 0 |  | 0 | 0 | -9 | -600 | -42.9817 |  | -3 | [NAME] |  |  |  |  |  | ManuNoTestHCA | -42.98 | 0 | N |  |  |  | 22282 | 1.829642199956325
1 | 1209 | 20636 | [NAME] | BD | 8.625 | 61 | 0 | 0 | 61 | 8.625 |  | 61 |  |  |  |  |  |  |  |  | 106 | 0 | 0 | -1.000 |  |  |  | -35000 | -0.172 |  | 0 |  | 0 | 0 | -9 | -600 | -42.9817 |  | -3 | [NAME] |  |  |  |  |  | ManuNoTestHCA | -42.98 | 0 | N |  |  |  | 22348 | 23.57484405287893
1 | 1209 | 20637 | [NAME] | BD | 8.625 | 51 | 0 | 0 | 51 | 8.625 |  | 51 |  |  |  |  |  |  |  |  | 101 | 0 | 0 | -1.000 |  |  |  | -35000 | -0.172 |  | 0 |  | 0 | 0 | -9 | -600 | -42.9817 |  | -3 | [NAME] |  |  |  |  |  | ManuNoTestHCA | -42.98 | 0 | N |  |  |  | 22345 | 18.21568968777252
1 | 1209 | 20638 | [NAME] | BD | 8.625 | 106 | 0 | 0 | 106 | 8.625 |  | 106 |  |  |  |  |  |  |  |  | 105 | 0 | 0 | -1.000 |  |  |  | -35000 | -0.172 |  | 0 |  | 0 | 0 | -9 | -600 | -42.9817 |  | -3 | [NAME] |  |  |  |  |  | ManuNoTestHCA | -42.98 | 0 | N |  |  |  | 22322 | 31.24950500168761
1 | 1209 | 20635 | [NAME] | BD | 8.625 | 4 | 0 | 0 | 4 | 8.625 |  | 4 |  |  |  |  |  |  |  |  | 100 | 0 | 0 | -1.000 |  |  |  | -35000 | -0.172 |  | 0 |  | 0 | 0 | -9 | -600 | -42.9817 |  | -3 | [NAME] |  |  |  |  |  | ManuNoTestHCA | -42.98 | 0 | N |  |  |  | 22344 | 1.188030993866422
1 | 1209 | 24400 | STUB8608 | DFM | 10.75 | 2 | 0.0222 | 0.0225 | 2 | 10.75 |  | 2 |  |  |  |  |  |  |  |  | 551 | 0.0222 | 0.0225 | 1.000 |  |  |  | -35000 | -0.188 |  | 0 |  | 0 | 473 | -38.6379 | 405 | -33.0832 | 1966-01-01 00:00:00 | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -33.08 | 0 | N |  |  |  | 15007 | 0.610843173005211
1 | 1209 | 22903 | DRIP7975 | LT | -20 | 10 | 0 | 0 | 10 | 20 |  | 10 |  |  |  |  |  |  |  |  |  | 0 | 0 | -1.000 | UNK |  |  | -35000 | -0.25 |  | 0 |  | 0 | 0 | 0 | -338 | -38.6286 |  | -3 | I8 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -38.63 | 0 | N |  |  |  | 12931 | 3.043627600249008
1 | 1209 | 22910 | DRIP7994 | LT | -34 | 5 | 0 | 0 | 5 | 34 |  | 5 |  |  |  |  |  |  |  |  | 651 | 0 | 0 | -1.000 | UNK | UNK |  | -42000 | -0.312 |  | 0 |  | 0 | 0 | 0 | -600 | -77.8388 |  | -3 | B8 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -77.84 | 0 | N |  |  |  | 10056 | 1.522458920201509
1 | 1209 | 23866 | STA9897 | LT | 8.625 | 1 | 0 | 0 | 1 | 8.625 |  | 1 |  |  |  |  |  |  |  |  | 952 | 0 | 0 | 1.000 | ARC | UNK | BUTT | -35000 | -0.172 |  | 0 |  | 0 | 720 | -51.5781 | 650 | -46.5635 | 1968-01-01 00:00:00 | 2 | N3 |  |  |  |  |  | ManuNoTestHCA | -46.56 | 0 | N |  |  |  | 18362 | 0.3265530502703419
1 | 1209 | 23867 | STA9897 | LT | 12.75 | 2 | 0 | 0 | 2 | 12.75 |  | 2 |  |  |  |  |  |  |  |  | 951 | 0 | 0 | 1.000 | ARC | UNK | BUTT | -35000 | -0.203 |  | 0 |  | 0 | 720 | -64.6024 | 650 | -58.3216 | 1968-01-01 00:00:00 | 2 | N3 |  |  |  |  |  | ManuNoTestHCA | -58.32 | 0 | N |  |  |  | 18361 | 0.5639285161672066
1 | 1209 | 21907 | DFDS3719 | SERV | 4.5 | 36 | 0 | 0.0068 | 36 | 4.5 |  | 36 |  |  |  |  |  |  |  |  | 101 | 0 | 0.0068 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -600 | -66.4894 |  | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -66.49 | 0 | N |  |  |  | 15292 | 9.778472985179423
1 | 1209 | 21908 | DFDS3719 | SERV | 4.5 | 2 | 0.0068 | 0.0072 | 2 | 4.5 |  | 2 |  |  |  |  |  |  |  |  | 102 | 0.0068 | 0.0072 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -600 | -66.4894 |  | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -66.49 | 0 | N |  |  |  | 15293 | 0.511448541963768
1 | 1209 | 22517 | DREG5201 | SERV | 6.625 | 24 | 0 | 0 | 24 | 6.625 |  | 24 |  |  |  |  |  |  |  |  | 100 | 0 | 0 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -338 | -41.3573 |  | 3 | I5 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -41.36 | 0 | N |  |  |  | 11288 | 7.335964745168436
1 | 1209 | 22761 | DREG5637 | SERV | 4.5 | 3 | 0 | 0.0005 | 3 | 4.5 |  | 3 |  |  |  |  |  |  |  |  | 100 | 0 | 0.0005 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -600 | -66.4894 |  | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -66.49 | 0 | N |  |  |  | 15290 | 0.8150833299246608
1 | 1209 | 22762 | DREG5637 | SERV | 4.5 | 38 | 0.0005 | 0.0078 | 38 | 4.5 |  | 38 |  |  |  |  |  |  |  |  | 101 | 0.0005 | 0.0078 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -600 | -66.4894 |  | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -66.49 | 0 | N |  |  |  | 15291 | 11.76736399082657
1 | 1209 | 22763 | DREG5638 | SERV | 2.375 | 70 | 0 | 0 | 70 | 2.375 |  | 70 |  |  |  |  |  |  |  |  | 801 | 0 | 0 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 600 | -35.0916 |  | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -35.09 | 0 | N |  |  |  | 15045 | 21.33011279276205
1 | 1209 | 22764 | DREG5640 | SERV | -6.625 | 10 | 0 | 0 | 10 | 6.63 |  | 10 |  |  |  |  |  |  |  |  | 801 | 0 | 0 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -600 | -73.4153 |  | 3 | I5 |  |  |  |  |  | ManuNoTestHCA | -73.42 | 0 | N |  |  |  | 15046 | 3.045066278466436
1 | 1209 | 22765 | DREG5641 | SERV | -3.5 | 80 | 0 | 0 | 80 | 3.5 |  | 80 |  |  |  |  |  |  |  |  | 101 | 0 | 0 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -600 | -51.7139 |  | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -51.71 | 0 | N |  |  |  | 16120 | 21.69383493603951
1 | 1209 | 22786 | DREG6910 | SERV | 2.375 | 80 | 0 | 0 | 80 | 2.375 | 80 |  |  |  |  |  |  |  |  |  | 100 | 0 | 0 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -650 | -38.0159 |  | 2 | N1 |  |  |  |  |  | ManuNoTestHCA | -38.02 | 0 | N |  |  |  | 12401 | 24.53187441832393
1 | 1209 | 22808 | DREG8616 | SERV | 10.75 | 125 | 0 | 0.0237 | 125 | 10.75 |  | 125 |  | 1 | 125 |  |  |  |  |  | 100.3 | 0 | 0.0237 | 1.000 |  |  |  | -35000 | -0.188 |  | 0 |  | 0 | 473 | -38.6379 | 405 | -33.0832 | 1966-01-01 00:00:00 | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -33.08 | 0 | N |  |  |  | 15006 | 38.15060123987855