Spreadsheet: 101805d1299850927-extracting-specifics-from-xls-file-excel-2003-pl-replacements-1100-and-1200
Sheet: 1207-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 | 1207 | 22911 | DRIP7995 | BB | 36 | 10 | 0 | 0.0019 | 10 | 36 |  | 10 |  |  |  |  |  |  |  |  | 651 | 0 | 0.0019 | -1.000 | UNK | UNK |  | -46000 | -0.875 |  | 0 |  | 0 | 0 | 0 | -965 | -43.1553 |  | -3 | I8 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -43.16 | 0 | N |  |  |  | 24306 | 3.161102751269937
1 | 1207 | 22912 | DRIP7995 | BB | 36 | 41 | 0.0019 | 0.0097 | 41 | 36 |  | 41 |  |  |  |  |  |  |  |  | 652 | 0.0019 | 0.0097 | -1.000 | UNK | UNK |  | -52000 | -0.688 |  | 0 |  | 0 | 0 | 0 | -965 | -48.5521 |  | -3 | I8 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -48.55 | 0 | N |  |  |  | 24489 | 15.17841303436674
1 | 1207 | 22914 | DRIP7996 | BB | 36 | 10 | 0 | 0.0019 | 10 | 36 |  | 10 |  |  |  |  |  |  |  |  | 651 | 0 | 0.0019 | -1.000 | UNK | UNK |  | -46000 | -0.875 |  | 0 |  | 0 | 0 | 0 | -965 | -43.1553 |  | -3 | I8 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -43.16 | 0 | N |  |  |  | 24307 | 3.196059648878872
1 | 1207 | 22915 | DRIP7996 | BB | 36 | 41 | 0.0019 | 0.0097 | 41 | 36 |  | 41 |  |  |  |  |  |  |  |  | 652 | 0.0019 | 0.0097 | -1.000 | UNK | UNK |  | -52000 | -0.688 |  | 0 |  | 0 | 0 | 0 | -965 | -48.5521 |  | -3 | I8 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -48.55 | 0 | N |  |  |  | 24126 | 15.17841303365128
1 | 1207 | 22917 | DRIP7999 | BB | 12.75 | 3 | 0 | 0 | 3 | 12.75 |  | 3 |  |  |  |  |  |  |  |  | 651 | 0 | 0 | -1.000 | UNK |  | UNK | -42000 | -0.203 |  | 0 |  | 0 | 0 | 0 | -720 | -53.8353 |  | -3 | N5 |  |  |  |  |  | ManuNoTestHCA | -53.84 | 0 | N |  |  |  | 11544 | 0.9139278814398966
1 | 1207 | 22918 | DRIP8000 | BB | 16 | 3 | 0 | 0 | 3 | 16 |  | 3 |  |  |  |  |  |  |  |  | 651 | 0 | 0 | -1.000 | UNK | UNK |  | -42000 | -0.219 |  | 0 |  | 0 | 0 | 0 | -510 | -44.3575 |  | -3 | N5 |  |  |  |  |  | ManuNoTestHCA | -44.36 | 0 | N |  |  |  | 11545 | 0.9139278870274983
1 | 1207 | 19838 | BD260 | BD | 8.625 | 40 | 0 | 0.01 | 40 | 8.625 |  | 40 |  |  |  |  |  |  |  |  | 235 | 0 | 0.01 | -0.800 |  |  |  | -35000 | -0.219 |  | 0 |  | 0 | 0 | -9 | 500 | -35.1639 |  | 3 | N8 |  |  |  |  |  | ManuNoTestHCA | -35.16 | 0 | N |  |  |  | 18000 | 12.1901313882306
1 | 1207 | 19839 | BD260 | BD | 8.625 | 90 | 0 | 0.02 | 90 | 8.625 |  | 90 |  |  |  |  |  |  |  |  | 237 | 0 | 0.02 | -0.800 |  |  |  | -35000 | -0.219 |  | 0 |  | 0 | 0 | -9 | 500 | -35.1639 |  | 3 | N8 |  |  |  |  |  | ManuNoTestHCA | -35.16 | 0 | N |  |  |  | 18001 | 33.36395361624627
1 | 1207 | 20468 | BD676 | BD | 6.625 | 7 | 0 | 0 | 7 | 6.625 |  | 7 |  |  |  |  |  |  |  |  | 601 | 0 | 0 | -1.000 |  |  |  | -35000 | -0.156 |  | 0 |  | 0 | 0 | -9 | -965 | -58.5451 |  | -3 | [NAME] |  |  |  |  |  | ManuNoTestHCA | -58.55 | 0 | N |  |  |  | 24302 | 1.982612358957739
1 | 1207 | 20469 | BD676 | BD | 10.75 | 7 | 0 | 0 | 7 | 10.75 |  | 7 |  |  |  |  |  |  |  |  | 602 | 0 | 0 | -1.000 |  |  |  | -35000 | -0.188 |  | 0 |  | 0 | 0 | -9 | -965 | -78.8279 |  | -3 | [NAME] |  |  |  |  |  | ManuNoTestHCA | -78.83 | 0 | N |  |  |  | 24304 | 1.9775619097054
1 | 1207 | 20470 | BD676 | BD | 10.75 | 92 | 0 | 0 | 92 | 10.75 |  | 92 |  |  |  |  |  |  |  |  | 603 | 0 | 0 | -1.000 |  |  |  | -35000 | -0.188 |  | 0 |  | 0 | 0 | -9 | -965 | -78.8279 |  | -3 | [NAME] |  |  |  |  |  | ManuNoTestHCA | -78.83 | 0 | N |  |  |  | 24305 | 27.28103431242375
2 | 1207 | 20481 | BD679 | BD | 10.75 | 28 | 0 | 0 | 28 | 10.75 |  | 28 |  |  |  |  |  |  |  |  | 102 | 0 | 0 | -0.800 |  |  |  | -42000 | -0.188 |  | 0 |  | 0 | 0 | -9 | -965 | -82.1124 |  | 1 | N3 |  |  |  |  |  | ManuNoTest | -82.11 | 0 | N |  |  |  | 4302 | 8.657097625674178
2 | 1207 | 20486 | [NAME] | BD | 10.75 | 13 | 0 | 0 | 13 | 10.75 |  | 13 |  |  |  |  |  |  |  |  | 101 | 0 | 0 | -1.000 |  |  |  | -35000 | -0.188 |  | 0 |  | 0 | 0 | -9 | -965 | -78.8279 |  | 1 | [NAME] |  |  |  |  |  | ManuNoTest | -78.83 | 0 | N |  |  |  | 4301 | 3.870241369021669
2 | 1207 | 20485 | [NAME] | BD | 16 | 110 | 0 | 0 | 110 | 16 |  | 110 |  |  |  |  |  |  |  |  | 100 | 0 | 0 | -0.800 |  |  |  | -42000 | -0.25 |  | 0 |  | 0 | 0 | -9 | -965 | -91.9048 |  | 1 | N3 |  |  |  |  |  | ManuNoTest | -91.9 | 0 | N |  |  |  | 4300 | 33.68544062535194
1 | 1207 | 20881 | BD9375 | BD | 2.375 | 7 | 8.47 | 8.47 | 7 | 2.375 |  | 7 |  |  |  |  |  |  |  |  | 601 | 8.47 | 8.47 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -720 | -42.1099 |  | -3 | N5 |  |  |  |  |  | ManuNoTestHCA | -42.11 | 0 | N |  |  |  | 23948 | 2.148118935305517
1 | 1207 | 20882 | BD9376 | BD | 2.375 | 7 | 8.47 | 8.47 | 7 | 2.375 |  | 7 |  |  |  |  |  |  |  |  | 601 | 8.47 | 8.47 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -720 | -42.1099 |  | -3 | N5 |  |  |  |  |  | ManuNoTestHCA | -42.11 | 0 | N |  |  |  | 23949 | 2.134001899992302
2 | 1207 | 20885 | BD9379 | BD | 4.5 | 6 | 7.76 | 7.76 | 6 | 4.5 | 6 |  |  |  |  |  |  |  |  |  | 601 | 7.76 | 7.76 | -0.600 |  |  |  | -24000 | -0.148 |  | 0 |  | 0 | 0 | -9 | 720 | -76.0135 |  | 1 | N9 |  |  |  |  |  | ManuNoTest | -76.01 | 0 | N |  |  |  | 18091 | 2.057487643758285
1 | 1207 | 24001 | STUB10412 | LT | 8.625 | 5 | 0 | 0 | 5 | 8.625 | 5 |  |  |  |  |  |  |  |  |  | 552 | 0 | 0 | -0.800 | ARC | SMLS |  | 35000 | -0.22 |  | 0 |  | 0 | 0 | -9 | 800 | -56.0065 |  | 3 | Z15 |  |  |  |  |  | ManuNoTestHCA | -56.01 | 0 | N |  |  |  | 22803 | 1.523534071221914
1 | 1207 | 21347 | DCUST9075 | SERV | -1.05 | 65 | 0 | 0 | 65 | 1.05 |  | 65 |  | 1 | 30 |  |  |  |  |  | 103 | 0 | 0 | 1.000 | ARC | DSAW | BUTT | 0 | 0 |  | 0 |  | 0 | 0 | 0 | -2160 | 0 |  | -3 | [NAME] |  |  |  |  |  | FabNoTest1 | -9 | 0 | N | Sub_J No | Fab&Con |  | 20522 | 19.65956579444567
1 | 1207 | 21897 | DFDS3700 | SERV | -3.5 | 3 | 0 | 0.0012 | 3 | 3.5 |  | 3 |  |  |  |  |  |  |  |  | 401 | 0 | 0.0012 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 720 | -62.0567 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -62.06 | 0 | N |  |  |  | 18870 | 1.122226687016508
1 | 1207 | 21898 | DFDS3700 | SERV | -3.5 | 10 | 0.01 | 0.01 | 10 | 3.5 |  | 10 |  |  |  |  |  |  |  |  | 402 | 0.01 | 0.01 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 720 | -62.0567 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -62.06 | 0 | N |  |  |  | 18982 | 2.567680529877271
1 | 1207 | 21896 | DFDS3700 | SERV | 3.5 | 25 | 0.0012 | 0.01 | 25 | 3.5 |  | 25 |  |  |  |  |  |  |  |  | 401.5 | 0.0012 | 0.01 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 720 | -62.0567 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -62.06 | 0 | N |  |  |  | 18871 | 8.467952994872162
1 | 1207 | 21899 | DFDS3701 | SERV | 3.5 | 8 | 0 | 0 | 8 | 3.5 |  | 8 |  |  |  |  |  |  |  |  | 121 | 0 | 0 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -720 | -62.0567 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -62.06 | 0 | N |  |  |  | 21842 | 1.3883243349851
1 | 1207 | 22211 | DREG4379 | SERV | 3.5 | 3 | 0 | 0.0004 | 3 | 3.5 |  | 3 |  |  |  |  |  |  |  |  | 301 | 0 | 0.0004 | -0.600 |  |  |  | -25000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -720 | -59.5745 | 1967-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -59.57 | 0 | N |  |  |  | 21847 | 0.9167477518139641
1 | 1207 | 22213 | DREG4379 | SERV | 3.5 | 20 | 0.01 | 0.02 | 20 | 3.5 |  | 20 |  |  |  |  |  |  |  |  | 305 | 0.01 | 0.02 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -720 | -62.0567 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -62.06 | 0 | N |  |  |  | 18983 | 6.094109446344558
1 | 1207 | 22214 | DREG4379 | SERV | 4.5 | 45 | 0.02 | 0.03 | 45 | 4.5 |  | 45 |  |  |  |  |  |  |  |  | 309 | 0.02 | 0.03 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -720 | -79.7872 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -79.79 | 0 | N |  |  |  | 18869 | 13.7151428356232
1 | 1207 | 22212 | DREG4379 | SERV | 3.5 | 72 | 0.0004 | 0.01 | 72 | 3.5 |  | 72 |  |  |  |  |  |  |  |  | 302 | 0.0004 | 0.01 | -0.600 |  |  |  | -25000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -720 | -59.5745 | 1967-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -59.57 | 0 | N |  |  |  | 21848 | 21.75780550911203
1 | 1207 | 22215 | DREG4380 | SERV | 3.5 | 50 | 0.03 | 0.04 | 50 | 3.5 |  | 50 |  |  |  |  |  |  |  |  | 123 | 0.03 | 0.04 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -720 | -62.0567 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -62.06 | 0 | N |  |  |  | 21840 | 15.23759127653988
1 | 1207 | 22217 | DREG4380 | SERV | 6.625 | 50 | 0.04 | 0.05 | 50 | 6.625 |  | 50 |  |  |  |  |  |  |  |  | 126 | 0.04 | 0.05 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -720 | -88.0984 |  | 3 | Z15 |  |  |  |  |  | ManuNoTestHCA | -88.1 | 0 | N |  |  |  | 21841 | 15.23765919795172
1 | 1207 | 22216 | DREG4380 | SERV | 3.5 | 156 | 0 | 0.03 | 156 | 3.5 |  | 156 |  |  |  |  |  |  |  |  | 120 | 0 | 0.03 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 720 | -62.0567 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -62.06 | 0 | N |  |  |  | 21843 | 44.58533200615834
1 | 1207 | 22293 | DREG4712 | SERV | 3.5 | 99 | 0.01 | 0.03 | 99 | 3.5 |  | 99 |  |  |  |  |  |  |  |  | 304 | 0.01 | 0.03 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 500 | -43.095 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -43.1 | 0 | N |  |  |  | 5131 | 29.77329616365104
1 | 1207 | 22295 | DREG4713 | SERV | 3.5 | 40 | 0.02 | 0.03 | 40 | 3.5 |  | 40 |  |  |  |  |  |  |  |  | 304 | 0.02 | 0.03 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 500 | -43.095 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -43.1 | 0 | N |  |  |  | 5148 | 12.1899712625891
2 | 1207 | 22296 | DREG4714 | SERV | 4.5 | 42 | 0.01 | 0.02 | 42 | 4.5 |  | 42 |  |  |  |  |  |  |  |  | 119 | 0.01 | 0.02 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -500 | -55.4078 |  | 1 | N1 |  |  |  |  |  | ManuNoTest | -55.41 | 0 | N |  |  |  | 5129 | 12.7998348509933
1 | 1207 | 22575 | DREG5321 | SERV | 6.625 | 27 | 0.01 | 0.02 | 27 | 6.625 |  | 27 |  |  |  |  |  |  |  |  | 207 | 0.01 | 0.02 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 500 | -61.1794 |  | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -61.18 | 0 | N |  |  |  | 24170 | 8.460826801644986
1 | 1207 | 22573 | DREG5321 | SERV | 4.5 | 43 | 0 | 0.01 | 43 | 4.5 |  | 43 |  |  |  |  |  |  |  |  | 204 | 0 | 0.01 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 500 | -55.4078 |  | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -55.41 | 0 | N |  |  |  | 24169 | 12.92041471121554
1 | 1207 | 22578 | DREG5322 | SERV | 6.625 | 15 | 0.01 | 0.02 | 15 | 6.625 |  | 15 |  |  |  |  |  |  |  |  | 304 | 0.01 | 0.02 | 1.000 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 500 | -48.9436 |  | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -48.94 | 0 | N |  |  |  | 5166 | 4.582868163003669
1 | 1207 | 22577 | DREG5322 | SERV | 4.5 | 60 | 0 | 0.01 | 60 | 4.5 |  | 60 |  |  |  |  |  |  |  |  | 302 | 0 | 0.01 | 1.000 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 500 | -33.2447 |  | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -33.24 | 0 | N |  |  |  | 5165 | 18.17959561094666
1 | 1207 | 24496 | STUB9046 | UGS | 2.375 | 24 | 0 | 0 | 24 | 2.375 |  | 24 |  |  |  |  |  |  |  |  | 100 | 0 | 0 | -1.000 |  |  |  | -35000 | -0.154 |  | 0 |  | 0 | 0 | -9 | 2160 | -47.5881 |  | -3 | N9 |  |  |  |  |  | ManuNoTestHCA | -47.59 | 0 | N |  |  |  | 20507 | 1.802805498778854
1 | 1207 | 21491 | DF3369 | DFM | 8.625 | 41 | 0 | 0.01 | 41 | 8.625 |  | 41 |  |  |  |  |  |  |  |  | 309 | 0 | 0.01 | -1.000 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 500 | -63.719 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -63.72 | 0 | N |  |  |  | 17999 | 10.44715492018281