Spreadsheet: 101805d1299850927-extracting-specifics-from-xls-file-excel-2003-pl-replacements-1100-and-1200
Sheet: 1208-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 | 1208 | 23745 | STA5989 | BB | -24 | 510 | 31.22 | 31.22 | 510 | 24 |  | 510 |  |  |  |  |  |  |  |  | 161.8 | 31.22 | 31.22 | 1.000 |  |  |  | 0 | 0 |  | 0 |  | 0 | 0 | -9 | 0 | 0 |  | 3 | I9 |  |  |  |  |  | ManuNoTestHCA | -9 | 0 | N |  |  |  | 24069 | 155.9363026290267
1 | 1208 | 23777 | STA6006 | BB | 0 | 400 | 42.86 | 42.86 | 400 | 0 |  | 400 |  |  |  |  |  |  |  |  | 143 | 42.86 | 42.86 | 1.000 |  |  |  | 0 | 0 |  | 0 |  | 0 | 0 | -9 | 0 | 0 |  | 3 | I9 |  |  |  |  |  | ManuNoTestHCA | -9 | 0 | N |  |  |  | 6383 | 118.5504790988801
1 | 1208 | 19921 | BD314 | BD | 8.625 | 7 | 0 | 0 | 7 | 8.625 |  | 7 |  |  |  |  |  |  |  |  | 301 | 0 | 0 | -0.800 |  |  |  | -24000 | -0.217 |  | 0 |  | 0 | 0 | -9 | 420 | -43.4728 |  | -3 | N3 |  |  |  |  |  | ManuNoTestHCA | -43.47 | 0 | N |  |  |  | 14874 | 2.136024328564217
1 | 1208 | 19922 | BD314 | BD | 8.625 | 12 | 0 | 0 | 12 | 8.625 |  | 12 |  |  |  |  |  |  |  |  | 303 | 0 | 0 | -0.800 |  |  |  | -24000 | -0.217 |  | 0 |  | 0 | 0 | -9 | 420 | -43.4728 |  | -3 | N3 |  |  |  |  |  | ManuNoTestHCA | -43.47 | 0 | N |  |  |  | 14875 | 3.591216017025513
1 | 1208 | 19924 | [NAME] | BD | 8.625 | 21 | 0 | 0.01 | 21 | 8.625 |  | 21 |  |  |  |  |  |  |  |  | 604 | 0 | 0.01 | -0.800 |  |  |  | -42000 | -0.172 |  | 0 |  | 0 | 0 | -9 | 420 | -31.3408 |  | 3 | I8 |  |  |  |  |  | ManuNoTestHCA | -31.34 | 0 | N |  |  |  | 14894 | 5.105989129921337
1 | 1208 | 19923 | [NAME] | BD | 8.625 | 35 | 0 | 0.01 | 35 | 8.625 |  | 35 |  |  |  |  |  |  |  |  | 601 | 0 | 0.01 | -0.800 |  |  |  | -42000 | -0.172 |  | 0 |  | 0 | 0 | -9 | 420 | -31.3408 |  | 3 | I8 |  |  |  |  |  | ManuNoTestHCA | -31.34 | 0 | N |  |  |  | 14892 | 11.2151961874217
1 | 1208 | 21519 | DF3396 | DFM | 8.625 | 3 | 0 | 0 | 3 | 8.625 |  | 3 |  |  |  |  |  |  |  |  | 702 | 0 | 0 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -246 | -39.1872 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -39.19 | 0 | N |  |  |  | 15197 | 1.049135030818453
1 | 1208 | 21520 | DF3396 | DFM | 8.625 | 9 | 0 | 0 | 9 | 8.625 |  | 9 |  |  |  |  |  |  |  |  | 701 | 0 | 0 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -246 | -39.1872 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -39.19 | 0 | N |  |  |  | 15196 | 2.652656068012029
1 | 1208 | 22898 | DRIP7964 | DFM | -12.75 | 10 | 0 | 0 | 10 | 12.75 |  | 10 |  |  |  |  |  |  |  |  |  | 0 | 0 | UNK | UNK | UNK |  | 0 | 0 |  | 0 |  | 0 | 0 | 0 | -420 | 0 |  | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -9 | 0 | N |  |  |  | 14747 | 3.046575897720133
1 | 1208 | 23814 | STA8773 | DFM | 8.625 | 2 | 0 | 0 | 2 | 8.625 |  | 2 |  |  |  |  |  |  |  |  | 951 | 0 | 0 | 1.000 | ARC | DSAW | BUTT | -24000 | -0.141 |  | 0 |  | 0 | 0 | 0 | -246 | -31.3497 |  | -3 | N8 |  |  |  |  |  | FabNoTest1 | -31.35 | 0 | N | Sub_J No | Fab&Con |  | 15198 | 0.6791626773774624
1 | 1208 | 23815 | STA8773 | DFM | 8.625 | 5 | 0 | 0 | 5 | 8.625 |  | 5 |  |  |  |  |  |  |  |  | 952 | 0 | 0 | 1.000 | ARC | DSAW | BUTT | -24000 | -0.141 |  | 0 |  | 0 | 0 | 0 | -246 | -31.3497 |  | -3 | N8 |  |  |  |  |  | FabNoTest1 | -31.35 | 0 | N | Sub_J No | Fab&Con |  | 15199 | 1.368313040584326
1 | 1208 | 24385 | STUB8485 | DFM | 3.5 | 4 | 0 | 0.002 | 4 | 3.5 |  | 4 |  |  |  |  |  |  |  |  | 301 | 0 | 0.002 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 411 | -35.4241 |  | -3 | I1 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -35.42 | 0 | N |  |  |  | 11648 | 1.271258917636934
1 | 1208 | 21727 | DF8849 | LT | 8.625 | 2 | 0.0007 | 0.0011 | 2 | 8.625 |  | 2 |  |  |  |  |  |  |  |  | 402 | 0.0007 | 0.0011 | -1.000 |  |  |  | -35000 | -0.172 |  | 0 |  | 0 | 0 | -9 | -420 | -30.0872 |  | -3 | I9 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -30.09 | 0 | N |  |  |  | 18409 | 0.609315849526396
1 | 1208 | 21728 | DF8849 | LT | 8.625 | 4 | 0 | 0.0007 | 4 | 8.625 |  | 4 |  |  |  |  |  |  |  |  | 401 | 0 | 0.0007 | -1.000 |  |  |  | -35000 | -0.172 |  | 0 |  | 0 | 0 | -9 | -420 | -30.0872 |  | -3 | I9 | No | Yes | Yes | Yes | No | ManuNoTestHCA | -30.09 | 0 | N |  |  |  | 18408 | 1.05171096689114
2 | 1208 | 22899 | DRIP7965 | LT | 1.05 | 42 | 0 | 0 | 42 | 1.05 |  | 42 |  |  |  |  |  |  |  |  |  | 0 | 0 | UNK | UNK | SMLS |  | 35000 | 0.113 | 1981-10-20 00:00:00 | 800 | W | 8.25 | 0 | 0 | -250 | 0 |  | 3 | N5 |  |  |  |  |  | ManuFault | -9 | -3.2 | Y | 1970_Liq0.5g_Yes |  |  | 12935 | 3.046346683643556
1 | 1208 | 23734 | STA5985 | LT | -20 | 282 | 0 | 0 | 282 | 20 |  | 282 |  |  |  |  |  |  |  |  | 101 | 0 | 0 |  |  |  |  | 0 | 0 |  | 0 |  | 0 | 0 | -9 | 0 | 0 |  | 3 | I9 |  |  |  |  |  | ManuNoTestHCA | -9 | 0 | N |  |  |  | 14926 | 85.6243595681225
1 | 1208 | 23742 | STA5988 | LT | 12.75 | 3 | 0 | 0 | 3 | 12.75 |  | 3 |  |  |  |  |  |  |  |  | 332 | 0 | 0 |  |  | ERW |  | 42000 | 0.25 |  | 0 |  | 0 | 0 | -9 | 150 | 0 |  | 3 | I9 |  |  |  |  |  | ManuNoTestHCA | -9 | 0 | N |  |  |  | 21949 | 0.9156712110381048
1 | 1208 | 23744 | STA5988 | LT | 8.625 | 4 | 0 | 0 | 4 | 8.625 |  | 4 |  |  |  |  |  |  |  |  | 322 | 0 | 0 |  |  | SMLS |  | 0 | 0.322 |  | 0 |  | 0 | 0 | -9 | 250 | 0 |  | 3 | I9 |  |  |  |  |  | ManuNoTestHCA | -9 | 0 | N |  |  |  | 7094 | 1.221625783105629
1 | 1208 | 23795 | STA7808 | LT | -20 | 385 | 6.91 | 6.91 | 385 | 20 |  | 385 |  |  |  |  |  |  |  |  | 100 | 6.91 | 6.91 |  |  |  |  | 0 | 0 |  | 0 |  | 0 | 0 | -9 | 0 | 0 |  | 3 | I9 |  |  |  |  |  | ManuNoTestHCA | -9 | 0 | N |  |  |  | 14853 | 117.4520633379452
1 | 1208 | 24121 | [NAME] | LT | 3.5 | 6 | 0 | 0 | 6 | 3.5 |  | 6 |  |  |  |  |  |  |  |  | 329 | 0 | 0 | -0.600 |  |  |  | -25000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 420 | -34.7518 |  | 3 | Z15 |  |  |  |  |  | ManuNoTestHCA | -34.75 | 0 | N |  |  |  | 14906 | 1.827128418353222
1 | 1208 | 24588 | X6379 | LT | 20 | 9 | 10.35 | 10.35 | 9 | 20 |  | 9 |  |  |  |  |  |  |  |  | 503 | 10.35 | 10.35 | 1.000 |  |  |  | -33000 | -0.25 |  | 0 |  | 0 | 500 | -60.6061 | 250 | -30.303 | 1965-01-01 00:00:00 | 3 | A1 | No | Yes | No | Yes | No | ManuNoTestHCA | -30.3 | 0 | N |  |  |  | 14736 | 3.771149086956988
1 | 1208 | 21517 | DF3394 | SERV | 4.5 | 18 | 0 | 0 | 18 | 4.5 |  | 18 |  |  |  |  |  |  |  |  | 211 | 0 | 0 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 420 | -46.5426 |  | 3 | Z15 |  |  |  |  |  | ManuNoTestHCA | -46.54 | 0 | N |  |  |  | 14873 | 5.417115272714295
1 | 1208 | 21518 | DF3395 | SERV | 3.5 | 8 | 0 | 0 | 8 | 3.5 |  | 8 |  |  |  |  |  |  |  |  | 204 | 0 | 0 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 420 | -36.1998 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -36.2 | 0 | N |  |  |  | 14896 | 2.547286913690434
1 | 1208 | 21692 | DF8158 | SERV | 4.5 | 6 | 0 | 0.0011 | 6 | 4.5 |  | 6 |  |  |  |  |  |  |  |  | 101 | 0 | 0.0011 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | 0 | -420 | -46.5426 |  | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -46.54 | 0 | N |  |  |  | 20224 | 1.76012960727101
1 | 1208 | 21693 | DF8158 | SERV | 4.5 | 10 | 0.0011 | 0.003 | 10 | 4.5 |  | 10 |  |  |  |  |  |  |  |  | 102 | 0.0011 | 0.003 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | 0 | -420 | -46.5426 |  | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -46.54 | 0 | N |  |  |  | 20225 | 3.124988910582366
1 | 1208 | 21694 | DF8158 | SERV | 4.5 | 123 | 0.003 | 0.026 | 123 | 4.5 |  | 123 |  |  |  |  |  |  |  |  | 103 | 0.003 | 0.026 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | 0 | -420 | -46.5426 |  | 3 | N5 |  |  |  |  |  | ManuNoTestHCA | -46.54 | 0 | N |  |  |  | 20226 | 37.43002595370732
1 | 1208 | 22368 | DREG4867 | SERV | 4.5 | 122 | 0 | 0.02 | 122 | 4.5 |  | 122 |  |  |  |  |  |  |  |  | 201 | 0 | 0.02 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 420 | -46.5426 |  | 3 | Z15 |  |  |  |  |  | ManuNoTestHCA | -46.54 | 0 | N |  |  |  | 14876 | 37.25837700817304
1 | 1208 | 22375 | DREG4869 | SERV | 3.5 | 82 | 0 | 0.02 | 82 | 3.5 |  | 82 |  |  |  |  |  |  |  |  | 201 | 0 | 0.02 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 420 | -36.1998 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -36.2 | 0 | N |  |  |  | 14898 | 27.7158177921599
1 | 1208 | 22376 | DREG4870 | SERV | 4.5 | 375 | 0 | 0.071 | 375 | 4.5 |  | 375 |  | 1 | 70 |  |  |  |  |  | 201 | 0 | 0.071 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | -420 | -46.5426 |  | 3 | Z15 |  |  |  |  |  | ManuNoTestHCA | -46.54 | 0 | N |  |  |  | 14905 | 114.2702983108179
1 | 1208 | 22378 | DREG4873 | SERV | 4.5 | 145 | 0 | 0.03 | 145 | 4.5 |  | 145 |  |  |  |  |  |  |  |  | 201 | 0 | 0.03 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 420 | -46.5426 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -46.54 | 0 | N |  |  |  | 14952 | 44.18348586929238
1 | 1208 | 22380 | DREG4874 | SERV | 8.625 | 6 | 0 | 0 | 6 | 8.625 |  | 6 |  |  |  |  |  |  |  |  | 301 | 0 | 0 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | -420 | -66.9049 | 420 | -66.9049 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -66.9 | 0 | N |  |  |  | 13269 | 5.446831991802553
1 | 1208 | 22379 | DREG4874 | SERV | 4.5 | 64 | 0 | 0.02 | 64 | 4.5 |  | 64 |  |  |  |  |  |  |  |  | 303 | 0 | 0.02 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | -420 | -46.5426 | 420 | -46.5426 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -46.54 | 0 | N |  |  |  | 10588 | 15.72670578235708
1 | 1208 | 22561 | DREG5300 | SERV | 3.5 | 45 | 0 | 0.01 | 45 | 3.5 |  | 45 |  |  |  |  |  |  |  |  | 301 | 0 | 0.01 | -0.600 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 420 | -36.1998 |  | 3 | Z15 |  |  |  |  |  | ManuNoTestHCA | -36.2 | 0 | N |  |  |  | 10647 | 18.61294380333836
1 | 1208 | 22562 | DREG5300 | SERV | 6.625 | 65 | 0.1 | 0.11 | 65 | 6.625 |  | 65 |  |  |  |  |  |  |  |  | 308 | 0.1 | 0.11 | -0.800 |  |  |  | -24000 | -0.141 |  | 0 |  | 0 | 0 | -9 | 420 | -51.3907 |  | 3 | N1 |  |  |  |  |  | ManuNoTestHCA | -51.39 | 0 | N |  |  |  | 1861 | 16.76080939586018