Spreadsheet: 101805d1299850927-extracting-specifics-from-xls-file-excel-2003-pl-replacements-1100-and-1200
Sheet: 1210-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 | 1210 | 24267 | STUB7837 | BB | 2.375 | 12 | 0 | 0.003 | 12 | 2.375 |  | 12 |  |  |  |  |  |  |  |  | 339 | 0 | 0.003 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 590 | -34.5067 |  | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -34.51 | 0 | N |  |  |  | 9773 | 3.658985257494453
1 | 1210 | 21881 | DFDS3678 | SERV | 3.5 | 69 | 0 | 0.01 | 69 | 3.5 |  | 69 |  |  |  |  |  |  |  |  | 301 | 0 | 0.01 | -0.600 |  |  |  | -25000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -555 | -45.922 | 1964-01-01 00:00:00 | 3 | Z51 |  |  |  |  |  | ManuNoTestHCA | -45.92 | 0 | N |  |  |  | 20986 | 30.0637988114457
1 | 1210 | 22298 | DREG4718 | SERV | 3.5 | 68 | 0 | 0.01 | 68 | 3.5 |  | 68 |  |  |  |  |  |  |  |  | 201 | 0 | 0.01 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 500 | -43.095 |  | 3 | I9 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -43.1 | 0 | N |  |  |  | 24189 | 15.18620720937907
1 | 1210 | 12370 | 2410-01 | DFM | 4.5 | 21 | 0 | 0.01 | 21 | 4.5 |  | 21 |  |  |  |  |  |  |  |  | 201 | 0 | 0.01 | -0.600 |  |  |  | 35000 | 0.156 |  | 0 |  | 0 | 0 | -9 | 590 | -40.522 | 1962-01-01 00:00:00 | 3 | Z15 |  |  |  |  |  | ManuNoTestHCA | -40.52 | 0 | N |  |  |  | 24229 | 7.457586675909615
1 | 1210 | 22299 | DREG4718 | SERV | 6.625 | 175 | 0.01 | 0.04 | 175 | 6.625 |  | 175 |  |  |  |  |  |  |  |  | 203 | 0.01 | 0.04 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 500 | -61.1794 |  | 3 | I9 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -61.18 | 0 | N |  |  |  | 24190 | 62.09325796323435
1 | 1210 | 22301 | DREG4719 | SERV | 6.625 | 100 | 0.04 | 0.06 | 100 | 6.625 |  | 100 |  |  |  |  |  |  |  |  | 204 | 0.04 | 0.06 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -500 | -61.1794 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -61.18 | 0 | N |  |  |  | 6505 | 30.47391003918584
1 | 1210 | 24050 | STUB6061 | DFM | -8.625 | 12 | 0 | 0.0023 | 12 | 8.63 |  | 12 |  |  |  |  |  |  |  |  | 100 | 0 | 0.0023 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -200 | -31.8595 |  | -3 | I5 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -31.86 | 0 | N |  |  |  | 15027 | 3.606661293675474
1 | 1210 | 19841 | BD266 | BD | 12.75 | 9 | 57.45 | 57.45 | 9 | 12.75 |  | 9 |  |  |  |  |  |  |  |  | 604 | 57.45 | 57.45 | -0.800 |  |  |  | -35000 | 0.325 |  | 0 | W | 0 | 0 | -9 | -590 | -41.3324 |  | 3 | I3 |  |  |  |  |  | ManuNoTestHCA | -41.33 | 0 | N |  |  |  | 23962 | 2.983202097541491
1 | 1210 | 19843 | BD267 | BD | 12.75 | 32 | 0 | 0.01 | 32 | 12.75 |  | 32 |  |  |  |  |  |  |  |  | 603 | 0 | 0.01 | -0.800 |  |  |  | -35000 | 0.325 |  | 0 |  | 0 | 0 | -9 | -590 | -41.3324 |  | 3 | I3 |  |  |  |  |  | ManuNoTestHCA | -41.33 | 0 | N |  |  |  | 6572 | 9.685922433770054
1 | 1210 | 20381 | BD616 | BD | 12.75 | 7 | 0 | 0 | 7 | 12.75 |  | 7 |  |  |  |  |  |  |  |  | 422.5 | 0 | 0 | -0.800 |  |  |  | -42000 | -0.25 |  | 0 |  | 0 | 0 | -9 | 597 | -45.308 |  | 3 | I3 |  |  |  |  |  | ManuNoTestHCA | -45.31 | 0 | N |  |  |  | 11113 | 2.416957758380041
1 | 1210 | 20483 | BD68 | BD | 12.75 | 4 | 0 | 0 | 4 | 12.75 |  | 4 |  |  |  |  |  |  |  |  | 101 | 0 | 0 | -0.800 |  |  |  | -24000 | -0.25 |  | 0 |  | 0 | 0 | -9 | -375 | -49.8047 |  | -3 | N3 |  |  |  |  |  | ManuNoTestHCA | -49.8 | 0 | N |  |  |  | 6564 | 1.360169250310809
1 | 1210 | 20484 | BD68 | BD | 12.75 | 142 | 0 | 0 | 142 | 12.75 |  | 142 |  |  |  |  |  |  |  |  | 100 | 0 | 0 | -0.800 |  |  |  | -24000 | -0.25 |  | 0 |  | 0 | 0 | -9 | -375 | -49.8047 |  | -3 | N3 |  |  |  |  |  | ManuNoTestHCA | -49.8 | 0 | N |  |  |  | 6563 | 44.23754982001695
1 | 1210 | 22902 | DRIP7969 | LT | -20 | 10 | 0 | 0 | 10 | 20 |  | 10 |  |  |  |  |  |  |  |  |  | 0 | 0 | -1.000 | UNK | UNK |  | -42000 | -0.25 |  | 0 |  | 0 | 0 | 0 | 375 | -35.7143 |  | 3 | A8 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -35.71 | 0 | N |  |  |  | 12936 | 3.047410727753284
1 | 1210 | 24691 | X6429 | LT | 20 | 44 | 0 | 0.0083 | 44 | 20 |  | 44 |  |  |  |  |  |  |  |  | 501 | 0 | 0.0083 | 1.000 |  |  |  | -33000 | 0.281 |  | 0 |  | 0 | 0 | -9 | -555 | -59.8512 |  | 3 | I5 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -59.85 | 0 | N |  |  |  | 19534 | 13.51012365911444
1 | 1210 | 24684 | X6428 | BB | 24 | 15 | 0 | 0.0028 | 15 | 24 |  | 15 |  |  |  |  |  |  |  |  | 600 | 0 | 0.0028 | 1.000 |  | SMLS |  | 35000 | 0.5 |  | 0 | W | 0 | 0 | -9 | 590 | 40.4571 | 1955-01-01 00:00:00 | 3 | I5 | No | Yes | No | Yes | No | FabNoTest1 | 40.46 | 0 | N | Sub_J No | Fab&Con |  | 23961 | 4.553442353626495
1 | 1210 | 24683 | X6428 | BB | 24 | 7 | 0.1771 | 0.1784 | 7 | 24 |  | 7 |  |  |  |  |  |  |  |  | 635 | 0.1771 | 0.1784 | 1.000 |  | SMLS |  | 42000 | 0.375 |  | 0 |  | 0 | 0 | -9 | 590 | 44.9524 | 1955-01-01 00:00:00 | 3 | I5 | No | Yes | No | Yes | No | FabNoTest1 | 44.95 | 0 | N | Sub_J No | Fab&Con |  | 21121 | 2.203029501726196
1 | 1210 | 24827 | X6511 | BB | 24 | 2 | 0.001 | 0.0013 | 2 | 24 |  | 2 |  |  |  |  |  |  |  |  | 700.5 | 0.001 | 0.0013 | 1.000 |  | SMLS |  | 42000 | 0.375 |  | 0 |  | 0 | 0 | -9 | 555 | 42.2857 | 1958-01-01 00:00:00 | 3 | I5 | No | Yes | No | Yes | No | FabNoTest1 | 42.29 | 0 | N | Sub_J No | Fab&Con |  | 21122 | 0.6945751927746924
1 | 1210 | 24831 | X6511 | BB | 24 | 215 | 0.0873 | 0.128 | 215 | 24 |  | 215 |  |  |  |  |  |  |  |  | 701.5 | 0.0873 | 0.128 | 1.000 |  |  |  | -33000 | 0.38 |  | 0 |  | 0 | 0 | -9 | 555 | -53.11 | 1958-01-01 00:00:00 | 3 | I5 | No | Yes | No | Yes | Yes | ManuNoTestHCA | -53.11 | 0 | N |  |  |  | 13994 | 62.21616751510371
1 | 1210 | 24689 | X6428 | BB | 30 | 12 | 0.0028 | 0.0051 | 12 | 30 |  | 12 |  |  |  |  |  |  |  |  | 605 | 0.0028 | 0.0051 | 1.000 |  | DSAW |  | 52000 | 0.375 |  | 0 |  | 0 | 0 | -9 | 590 | 45.3846 | 1955-01-01 00:00:00 | 3 | I5 | No | Yes | No | Yes | No | FabNoTest1 | 45.38 | 0 | N | Sub_J No | Fab&Con |  | 23959 | 2.571805005167191
1 | 1210 | 24686 | X6428 | BB | 30 | 51 | 0.0343 | 0.0439 | 51 | 30 |  | 51 |  | 0 | 51 |  |  |  |  | Seg's 24685,24686,24687,24690 all contiquous with 2 bores | 615 | 0.0343 | 0.0439 | 1.000 |  | DSAW |  | 52000 | 0.375 |  | 0 |  | 0 | 0 | -9 | 590 | 45.3846 | 1955-01-01 00:00:00 | 3 | I5 | No | Yes | No | Yes | No | FabNoTest1 | 45.38 | 0 | N | Sub_J No | Fab&Con |  | 23956 | 15.48493748218704
1 | 1210 | 24687 | X6428 | BB | 30 | 30 | 0.0439 | 0.0496 | 30 | 30 |  | 30 |  | 0 | 30 |  |  |  |  | Seg's 24685,24686,24687,24690 all contiquous with 2 bores | 620 | 0.0439 | 0.0496 | 1.000 |  | DSAW |  | 52000 | 0.375 |  | 0 |  | 0 | 0 | -9 | 590 | 45.3846 | 1955-01-01 00:00:00 | 3 | I5 | No | Yes | No | Yes | No | FabNoTest1 | 45.38 | 0 | N | Sub_J No | Fab&Con |  | 23957 | 9.13625081488083
1 | 1210 | 24690 | X6428 | BB | 30 | 53 | 0.0496 | 0.0597 | 53 | 30 |  | 53 |  | 0 | 53 |  |  |  |  | Seg's 24685,24686,24687,24690 all contiquous with 2 bores | 625 | 0.0496 | 0.0597 | 1.000 |  | DSAW |  | 52000 | 0.375 |  | 0 |  | 0 | 0 | -9 | 590 | 45.3846 | 1955-01-01 00:00:00 | 3 | I5 | No | Yes | No | Yes | No | FabNoTest1 | 45.38 | 0 | N | Sub_J No | Fab&Con |  | 24199 | 16.24808186065307
1 | 1210 | 24685 | X6428 | BB | 30 | 620 | 0.0597 | 0.1771 | 620 | 30 |  | 620 |  | 2 | 230 |  |  |  |  | Seg's 24685,24686,24687,24690 all contiquous with 2 bores | 630 | 0.0597 | 0.1771 | 1.000 |  | DSAW |  | 52000 | 0.375 |  | 0 |  | 0 | 0 | -9 | 590 | 45.3846 | 1955-01-01 00:00:00 | 3 | I5 | No | Yes | No | Yes | No | FabNoTest1 | 45.38 | 0 | N | Sub_J No | Fab&Con |  | 23955 | 192.8634930997943
1 | 1210 | 24828 | X6511 | BB | 30 | 452 | 0.0013 | 0.0873 | 452 | 30 |  | 452 |  |  |  |  |  |  |  |  | 701 | 0.0013 | 0.0873 | 1.000 |  | SMLS |  | 52000 | 0.375 |  | 0 |  | 0 | 0 | -9 | 555 | 42.6923 | 1958-01-01 00:00:00 | 3 | I5 | No | Yes | No | Yes | No | FabNoTest1 | 42.69 | 0 | N | Sub_J No | Fab&Con |  | 21123 | 136.6208568393662
1 | 1210 | 22901 | DRIP7968 | LT | -34 | 10 | 0 | 0 | 10 | 34 |  | 10 |  |  |  |  |  |  |  |  | 101 | 0 | 0 | -1.000 | UNK | UNK |  | -52000 | -0.4375 |  | 0 |  | 0 | 0 | 0 | 597 | -44.611 |  | 3 | I8 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -44.61 | 0 | N |  |  |  | 9941 | 3.050482081311778