Spreadsheet: 101805d1299850927-extracting-specifics-from-xls-file-excel-2003-pl-replacements-1100-and-1200
Sheet: 1205-LT 131

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
2 | 1205 | 7162 | 131 | BB | 24 | 298 | 27.0226 | 27.05 | 298 | 24 | 298 |  |  |  |  |  |  |  |  |  | 134.2 | 27.0226 | 27.05 | 0.800 | ARC | SSAW | BBCR | 40000 | 0.281 |  | 0 |  | 0 | 525 | 70.0623 | 500 | 66.726 | 1946-01-01 00:00:00 | 1 | N1 |  |  |  |  |  | ManuNoTest | 66.73 | 0 | N |  |  |  | 9943 | 90.05024970883049
2 | 1205 | 6834 | 131 | BB | 24 | 4799 | 27.05 | 28 | 4799 | 24 | 4799 |  |  |  |  |  |  |  |  |  | 135 | 27.05 | 28 | 1.000 | ARC | SMLS | BBCR | 40000 | 0.281 |  | 0 |  | 0 | 525 | 56.0498 | 500 | 53.3808 | 1944-01-01 00:00:00 | 1 | N1 |  |  |  |  |  | FabNoTest2 | 53.38 | 0 | N | Sub_J No | Fab&Con |  | 4535 | 1144.052162124972
2 | 1205 | 7156 | 131 | BB | 24 | 15840 | 28 | 31 | 15840 | 24 | 15840 |  |  | 3 | 230 |  |  |  |  |  | 136 | 28 | 31 | 0.800 | ARC | SMLS | BBCR | 40000 | 0.281 | 1969-10-31 00:00:00 | 688 | W | 0 | 525 | 70.0623 | 500 | 66.726 | 1944-01-01 00:00:00 | 1 | N1 |  |  |  |  |  | ManuFault | 66.73 | 1.38 | Y | 1970_Liq0.5g_Yes |  |  | 9775 | 4879.358607776197
2 | 1205 | 7017 | 131 | BB | 24 | 4740 | 31 | 31.8977 | 4740 | 24 | 4740 |  |  |  |  |  |  |  |  |  | 136.6 | 31 | 31.8977 | 1.000 | ARC | SMLS | BBCR | 40000 | -0.281 | 1969-01-01 00:00:00 | 860 | W | 0 | 525 | -56.0498 | 500 | -53.3808 | 1944-01-01 00:00:00 | 1 | N1 |  |  |  |  |  | FabGM2 | -53.38 | 1.72 | Y | 50_Within | Fab&Con | Seismic Step | 22481 | 1782.398508205951
2 | 1205 | 7016 | 131 | BB | 24 | 2200 | 31.9366 | 32.29 | 2200 | 24 | 2200 |  |  |  |  |  |  |  |  |  | 137 | 31.9366 | 32.29 | 1.000 | ARC | SMLS | BBCR | 40000 | -0.281 | 1969-01-01 00:00:00 | 860 | W | 0 | 525 | -56.0498 | 500 | -53.3808 | 1944-01-01 00:00:00 | 1 | N1 |  |  |  |  |  | FabGM2 | -53.38 | 1.72 | Y | 50_Within | Fab&Con | Seismic Step | 22482 | 413.6563185257554
2 | 1205 | 7107 | 131 | BB | 24 | 528 | 35.34 | 35.44 | 528 | 24 | 528 |  |  |  |  |  |  |  |  |  | 145 | 35.34 | 35.44 | 1.000 | ARC | SMLS | BBCR | 40000 | -0.281 | 1974-01-01 00:00:00 | 900 | W | 0 | 525 | -56.0498 | 500 | -53.3808 | 1944-01-01 00:00:00 | 1 | I9 | No | Yes | Yes | Yes | No | FabGM2 | -53.38 | 1.8 | Y | 50_Within | Fab&Con | Seismic Step | 17934 | 166.2264313008238
2 | 1205 | 7103 | 131 | BB | 24 | 894 | 35.44 | 35.6094 | 894 | 24 | 894 |  |  |  |  |  |  |  |  |  | 145.1 | 35.44 | 35.6094 | 1.000 | ARC | SMLS | BBCR | 40000 | -0.281 | 1974-01-01 00:00:00 | 900 | W | 0 | 525 | -56.0498 | 500 | -53.3808 | 1944-01-01 00:00:00 | 1 | N1 |  |  |  |  |  | FabGM2 | -53.38 | 1.8 | Y | 50_Within | Fab&Con | Seismic Step | 17935 | 281.3884067250998
2 | 1205 | 7088 | 131 | BB | 24 | 426 | 35.6094 | 35.69 | 426 | 24 | 426 |  |  |  |  |  |  |  |  |  | 145.2 | 35.6094 | 35.69 | 1.000 | ARC | SMLS | BBCR | 40000 | -0.281 | 1974-01-01 00:00:00 | 900 | W | 0 | 525 | -56.0498 | 500 | -53.3808 | 1944-01-01 00:00:00 | 1 | N1 |  |  |  |  |  | FabGM2 | -53.38 | 1.8 | Y | 50_Within | Fab&Con | Seismic Step | 15596 | 133.9322783168471
1 | 1205 | 7117 | 131 | BB | 24 | 826 | 35.73 | 35.87 | 826 | 24 |  |  |  | 1 | 120 |  |  |  |  |  | 147 | 35.73 | 35.87 | 1.000 | ARC | SMLS | BBCR | 40000 | -0.281 |  | 0 |  | 0 | 525 | -56.0498 | 500 | -53.3808 | 1944-01-01 00:00:00 | 1 | I5 | No | Yes | Yes | Yes | No | FabNoTest1 | -53.38 | 0 | N | Sub_J No | Fab&Con |  | 5112 | 168.2620833091713
2 | 1205 | 6831 | 131 | BB | 24 | 1569 | 37.52 | 37.81 | 1569 | 24 | 1569 |  |  |  |  |  |  |  |  |  | 149 | 37.52 | 37.81 | 1.000 | ARC | SMLS | BBCR | 40000 | -0.281 |  | 0 |  | 0 | 525 | -56.0498 | 500 | -53.3808 | 1944-01-01 00:00:00 | 1 | N1 |  |  |  |  |  | FabNoTest2 | -53.38 | 0 | N | Sub_J No | Fab&Con |  | 5107 | 466.131316181742
2 | 1205 | 7159 | 131 | BB | 24 | 3421 | 37.89 | 38.49 | 3421 | 24 | 3421 |  |  |  |  |  |  |  |  |  | 151 | 37.89 | 38.49 | 1.000 | ARC | SMLS | BBCR | 40000 | -0.281 |  | 0 |  | 0 | 525 | -56.0498 | 500 | -53.3808 | 1944-01-01 00:00:00 | 1 | N1 |  |  |  |  |  | FabNoTest2 | -53.38 | 0 | N | Sub_J No | Fab&Con |  | 10497 | 1073.342945895347
2 | 1205 | 7098 | 131 | BB | 24 | 55 | 38.55 | 38.5604 | 55 | 24 | 55 |  |  |  |  |  |  |  |  |  | 152 | 38.55 | 38.5604 | 1.000 | ARC | SMLS | BBCR | 40000 | 0.281 |  | 0 |  | 0 | 525 | 56.0498 | 500 | 53.3808 | 1944-01-01 00:00:00 | 1 | N1 |  |  |  |  |  | FabNoTest2 | 53.38 | 0 | N | Sub_J No | Fab&Con |  | 15917 | 14.50588391975301
2 | 1205 | 7093 | 131 | BB | 24 | 63 | 38.7032 | 38.7169 | 63 | 24 | 63 |  |  |  |  |  |  |  |  |  | 153 | 38.7032 | 38.7169 | 1.000 | ARC | SMLS | BBCR | 40000 | 0.281 |  | 0 |  | 0 | 525 | 56.0498 | 500 | 53.3808 | 1944-01-01 00:00:00 | 1 | N1 |  |  |  |  |  | FabNoTest2 | 53.38 | 0 | N | Sub_J No | Fab&Con |  | 15918 | 19.07185267661087
2 | 1205 | 7181 | 131 | BB | 24 | 6900 | 38.7232 | 40.03 | 6900 | 24 | 6900 |  |  |  |  |  |  |  |  |  | 153.2 | 38.7232 | 40.03 | 1.000 | ARC | SMLS | BBCR | 40000 | 0.281 |  | 0 |  | 0 | 525 | 56.0498 | 500 | 53.3808 | 1944-01-01 00:00:00 | 1 | N1 |  |  |  |  |  | FabNoTest2 | 53.38 | 0 | N | Sub_J No | Fab&Con |  | 10395 | 2071.4632684513
2 | 1205 | 7031 | 131 | BB | 24 | 1056 | 40.17 | 40.37 | 1056 | 24 | 1056 |  |  |  |  |  |  |  |  |  | 155 | 40.17 | 40.37 | 1.000 | ARC | SMLS | BBCR | 40000 | 0.281 | 1983-01-01 00:00:00 | 868 | W | 0 | 525 | 56.0498 | 500 | 53.3808 | 1944-01-01 00:00:00 | 1 | N9 |  |  |  |  |  | FabGM2 | 53.38 | 1.74 | Y | 50_Within | Fab&Con | Seismic Step | 22996 | 321.8675435204236
1 | 1205 | 7112 | 131 | BB | 24 | 172 | 43.46 | 43.4928 | 172 | 24 | 172 |  |  |  |  |  |  |  |  |  | 161 | 43.46 | 43.4928 | 1.000 | ARC | SMLS | BBCR | 40000 | -0.281 |  | 0 |  | 0 | 525 | -56.0498 | 500 | -53.3808 | 1944-01-01 00:00:00 | 1 | I1 | No | Yes | Yes | Yes | No | FabNoTest1 | -53.38 | 0 | N | Sub_J No | Fab&Con |  | 12275 | 54.68799828899998