Spreadsheet: 101805d1299850927-extracting-specifics-from-xls-file-excel-2003-pl-replacements-1100-and-1200
Sheet: 1201-LT 210A

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 | 1201 | 12013 | 210A | LT | 10.75 | 29 | 19.6443 | 19.65 | 29 | 24 | 0 | 29 | 0 | 1 | 29 | 0 | 0 | n | 0 |  | 119.7 | 19.6443 | 19.65 | 1.000 | ARC | ERW | BUTT | 42000 | -0.188 |  | 0 |  | 0 | 650 | -44.2471 | 650 | -44.2471 | 1960-01-01 00:00:00 | 3 | I6 | No | Yes | No | Yes | No | ManuNoTestHCA | -44.25 | 0 | N |  |  |  | 14841 | 8.560571812240712
1 | 1201 | 11999 | 210A | LT | 10.75 | 59 | 19.65 | 19.66 | 59 | 24 | 0 | 59 | 0 | 1 | 59 | 0 | 0 | n | 0 |  | 119.8 | 19.65 | 19.66 | 1.000 | ARC | ERW | BUTT | 42000 | -0.188 |  | 0 |  | 0 | 650 | -44.2471 | 650 | -44.2471 | 1950-01-01 00:00:00 | 3 | I6 | No | Yes | No | Yes | No | ManuNoTestHCA | -44.25 | 0 | N |  |  |  | 12329 | 17.98057916677555
1 | 1201 | 11998 | 210A | LT | 10.75 | 93 | 19.66 | 19.68 | 93 | 24 | 0 | 93 | 0 | 1 | 93 | 0 | 0 | n | 0 |  | 120.1 | 19.66 | 19.68 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.259 |  | 0 |  | 0 | 650 | 38.5411 | 650 | 38.5411 | 1937-01-01 00:00:00 | 3 | I6 | No | Yes | Yes | Yes | No | FabNoTest1 | 38.54 | 0 | N | Sub_J No | Fab&Con |  | 12330 | 28.33572511121566
1 | 1201 | 12016 | 210A | LT | 10.75 | 104 | 24.7542 | 24.7736 | 104 | 24 | 104 | 0 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 124.77 | 24.7542 | 24.7736 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.259 |  | 0 |  | 0 | 650 | 38.5411 | 650 | 38.5411 | 1937-01-01 00:00:00 | 1 | I5 | No | Yes | Yes | Yes | No | FabNoTest1 | 38.54 | 0 | N | Sub_J No | Fab&Con |  | 16514 | 31.51798653705304
1 | 1201 | 12015 | 210A | LT | 10.75 | 106 | 24.546 | 24.5658 | 106 | 24 | 106 | 0 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 124.7 | 24.546 | 24.5658 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.259 |  | 0 |  | 0 | 650 | 38.5411 | 650 | 38.5411 | 1937-01-01 00:00:00 | 1 | I5 | No | Yes | Yes | Yes | No | FabNoTest1 | 38.54 | 0 | N | Sub_J No | Fab&Con |  | 16512 | 32.30992185047802
1 | 1201 | 12004 | 210A | LT | 10.75 | 141 | 19.68 | 19.69 | 141 | 24 | 0 | 141 | 0 | 1 | 141 | 0 | 0 | n | 0 |  | 120.4 | 19.68 | 19.69 | 1.000 | ARC | ERW | BUTT | 42000 | -0.188 |  | 0 |  | 0 | 650 | -44.2471 | 650 | -44.2471 | 1960-01-01 00:00:00 | 3 | I6 | No | Yes | No | Yes | No | ManuNoTestHCA | -44.25 | 0 | N |  |  |  | 12338 | 47.36154115945478
1 | 1201 | 12012 | 210A | LT | 10.75 | 278 | 19.59 | 19.6443 | 278 | 24 | 278 | 0 | 0 | 1 | 35 | 0 | 0 | n | 0 |  | 119.5 | 19.59 | 19.6443 | 1.000 | ARC | ERW | BUTT | 42000 | -0.188 |  | 0 |  | 0 | 650 | -44.2471 | 650 | -44.2471 | 1960-01-01 00:00:00 | 3 | [NAME] |  |  |  |  |  | ManuNoTestHCA | -44.25 | 0 | N |  |  |  | 14840 | 82.11516750180586
2 | 1201 | 12011 | 210A | LT | 12.75 | 298 | 25.36 | 25.4173 | 298 | 24 | 298 | 0 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 125 | 25.36 | 25.4173 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.281 |  | 0 |  | 0 | 650 | 42.1327 | 650 | 42.1327 | 1937-01-01 00:00:00 | 1 | N5 |  |  |  |  |  | FabNoTest2 | 42.13 | 0 | N | Sub_J No | Fab&Con |  | 15041 | 90.343381262899
1 | 1201 | 12001 | 210A | LT | 10.75 | 377 | 19.51 | 19.59 | 377 | 24 | 377 | 0 | 0 | 1 | 75 | 0 | 0 | n | 0 |  | 119.2 | 19.51 | 19.59 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.259 |  | 0 |  | 0 | 650 | 38.5411 | 650 | 38.5411 | 1937-01-01 00:00:00 | 3 | N1 |  |  |  |  |  | FabNoTest1 | 38.54 | 0 | N | Sub_J No | Fab&Con |  | 12391 | 109.7753232463942
1 | 1201 | 12002 | 210A | LT | 10.75 | 471 | 20 | 20.0894 | 471 | 24 | 0 | 471 | 0 | 0 | 0 | 1 | 471 | 0 | 0 | Combine with seg 12003 in single HDD | 121.5 | 20 | 20.0894 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.259 |  | 0 |  | 0 | 650 | 38.5411 | 650 | 38.5411 | 1937-01-01 00:00:00 | 3 | I1 | No | Yes | Yes | Yes | No | FabNoTest1 | 38.54 | 0 | N | Sub_J No | Fab&Con |  | 12335 | 137.5729582758343
1 | 1201 | 11997 | 210A | LT | 10.75 | 662 | 20.0894 | 20.2151 | 662 | 24 | 662 | 0 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 121.7 | 20.0894 | 20.2151 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.259 |  | 0 |  | 0 | 650 | 38.5411 | 650 | 38.5411 | 1937-01-01 00:00:00 | 2 | N1 |  |  |  |  |  | FabNoTest1 | 38.54 | 0 | N | Sub_J No | Fab&Con |  | 12334 | 192.9500323016557
1 | 1201 | 12017 | 210A | LT | 10.75 | 1010 | 24.5658 | 24.7542 | 1010 | 24 | 1010 | 0 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 124.75 | 24.5658 | 24.7542 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.259 |  | 0 |  | 0 | 650 | 38.5411 | 650 | 38.5411 | 1937-01-01 00:00:00 | 3 | I5 | No | Yes | Yes | Yes | No | FabNoTest1 | 38.54 | 0 | N | Sub_J No | Fab&Con |  | 16513 | 306.4791456626679
1 | 1201 | 12009 | 210A | LT | 12.75 | 1054 | 25.4173 | 25.62 | 1054 | 24 | 1054 | 0 | 0 | 0 | 0 | 0 | 0 | n | 0 | Golf course | 126 | 25.4173 | 25.62 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.281 |  | 0 |  | 0 | 650 | 42.1327 | 650 | 42.1327 | 1937-01-01 00:00:00 | 1 | I5 | No | Yes | Yes | Yes | No | FabNoTest1 | 42.13 | 0 | N | Sub_J No | Fab&Con |  | 15042 | 319.7803937805263
1 | 1201 | 12003 | 210A | LT | 10.75 | 2021 | 19.69 | 20 | 2021 | 24 | 0 | 2021 | 0 | 0 | 0 | 0 | 2021 | 0 | 0 | Combine with 12002 | 121.2 | 19.69 | 20 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.259 |  | 0 |  | 0 | 650 | 38.5411 | 650 | 38.5411 | 1937-01-01 00:00:00 | 3 | I1 | No | Yes | Yes | Yes | No | FabNoTest1 | 38.54 | 0 | N | Sub_J No | Fab&Con |  | 12336 | 567.318949252045
1 | 1201 |  | 210A | LT | 10.75 | 25135 |  |  | 25135 | 24 | 15081 | 10054 | 0 | 0 | 0 | 0 | 2021 | 0 | 0 | Added per PG&E Direction | 121.2 | 19.69 | 20 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.259 |  | 0 |  | 0 | 650 | 38.5411 | 650 | 38.5411 | 1937-01-01 00:00:00 | 3 | I1 | No | Yes | Yes | Yes | No | FabNoTest1 | 38.54 | 0 | N | Sub_J No | Fab&Con |  | 12336 | 567.318949252045