Spreadsheet: 101805d1299850927-extracting-specifics-from-xls-file-excel-2003-pl-replacements-1100-and-1200
Sheet: 1202-LT 21F

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 | 1202 | 1067 | 021F | LT | 12.75 | 48 | 1.7369 | 1.7456 | 48 | 12.75 |  | 48 |  |  |  |  |  |  |  |  | 106.5 | 1.7369 | 1.7456 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.25 | 1940-01-01 00:00:00 | 0 | L | 0 | 500 | 36.4286 | 450 | 32.7857 | 1940-01-01 00:00:00 | 3 | Z51 |  |  |  |  |  | FabNoTest1 | 32.79 | 0 | N | Sub_J No | Fab&Con |  | 24849 | 17.1755249522408
1 | 1202 | 1066 | 021F | LT | 12.75 | 191 | 1.7456 | 1.78 | 191 | 12.75 |  | 191 |  |  |  |  |  |  |  |  | 106.7 | 1.7456 | 1.78 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.25 | 1940-01-01 00:00:00 | 0 | L | 0 | 500 | 36.4286 | 450 | 32.7857 | 1940-01-01 00:00:00 | 3 | I5 |  |  |  |  |  | FabNoTest1 | 32.79 | 0 | N | Sub_J No | Fab&Con |  | 24850 | 67.36557234151634
1 | 1202 | 1078 | 021F | LT | 12.75 | 254 | 0.2625 | 0.31 | 254 | 12.75 | 0 | 254 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 102.1 | 0.2625 | 0.31 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.25 | 1940-01-01 00:00:00 | 0 | L | 0 | 500 | 36.4286 | 450 | 32.7857 | 1940-01-01 00:00:00 | 3 | N5 |  |  |  |  |  | FabNoTest1 | 32.79 | 0 | N | Sub_J No | Fab&Con |  | 24841 | 77.5237904372522
1 | 1202 | 1060 | 021F | LT | 12.75 | 370 | 0.33 | 0.4005 | 370 | 12.75 | 0 | 370 | 0 | 0 | 0 | 0 | 0 | n | 0 |  | 103 | 0.33 | 0.4005 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.25 | 1940-01-01 00:00:00 | 0 | L | 0 | 500 | 36.4286 | 450 | 32.7857 | 1940-01-01 00:00:00 | 3 | N5 |  |  |  |  |  | FabNoTest1 | 32.79 | 0 | N | Sub_J No | Fab&Con |  | 24839 | 113.0249051509044
1 | 1202 | 1052 | 021F | LT | 12.75 | 575 | 2.02 | 2.13 | 575 | 12.75 |  | 575 |  |  |  |  |  |  |  |  | 108 | 2.02 | 2.13 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.25 | 1940-01-01 00:00:00 | 0 | L | 0 | 500 | 36.4286 | 450 | 32.7857 | 1940-01-01 00:00:00 | 3 | I5 | No | Yes | Yes | Yes | No | FabNoTest1 | 32.79 | 0 | N | Sub_J No | Fab&Con |  | 22761 | 175.3038769789891
1 | 1202 | 1075 | 021F | LT | 12.75 | 658 | 1 | 1.1249 | 658 | 12.75 |  | 658 |  |  |  |  |  |  |  |  | 104 | 1 | 1.1249 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.25 | 1940-01-01 00:00:00 | 0 | L | 0 | 500 | 36.4286 | 450 | 32.7857 | 1940-01-01 00:00:00 | 3 | N5 |  |  |  |  |  | FabNoTest1 | 32.79 | 0 | N | Sub_J No | Fab&Con |  | 24844 | 199.9385017671661
1 | 1202 | 1068 | 021F | LT | 12.75 | 816 | 1.59 | 1.7369 | 816 | 12.75 |  | 816 |  | 1 | 250 |  |  |  |  |  | 106 | 1.59 | 1.7369 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.25 | 1940-01-01 00:00:00 | 0 | L | 0 | 500 | 36.4286 | 450 | 32.7857 | 1940-01-01 00:00:00 | 3 | Z51 |  |  |  |  |  | FabNoTest1 | 32.79 | 0 | N | Sub_J No | Fab&Con |  | 24848 | 288.5217244784378
1 | 1202 | 1051 | 021F | LT | 12.75 | 1243 | 1.78 | 2.02 | 1243 | 12.75 |  | 1243 |  | 2 | 270 |  |  |  |  |  | 107 | 1.78 | 2.02 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.25 | 1940-01-01 00:00:00 | 0 | L | 0 | 500 | 36.4286 | 450 | 32.7857 | 1940-01-01 00:00:00 | 3 | I5 | No | Yes | Yes | Yes | No | FabNoTest1 | 32.79 | 0 | N | Sub_J No | Fab&Con |  | 22781 | 378.8897402564784
1 | 1202 | 1079 | 021F | LT | 12.75 | 1818 | 1.1249 | 1.47 | 1818 | 12.75 |  | 1818 |  | 3 | 320 |  |  |  |  |  | 104.1 | 1.1249 | 1.47 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.25 | 1940-01-01 00:00:00 | 0 | L | 0 | 500 | 36.4286 | 450 | 32.7857 | 1940-01-01 00:00:00 | 3 | A5 | No | Yes | Yes | Yes | No | FabNoTest1 | 32.79 | 0 | N | Sub_J No | Fab&Con |  | 24845 | 555.2147237284524
1 | 1202 | 1062 | 021F | LT | 12.75 | 3142 | 0.4005 | 1 | 3142 | 12.75 |  | 3142 |  | 2 | 160 |  |  |  |  |  | 103.1 | 0.4005 | 1 | 1.000 | ARC | SMLS | BBCR | 35000 | 0.25 | 1940-01-01 00:00:00 | 0 | L | 0 | 500 | 36.4286 | 450 | 32.7857 | 1940-01-01 00:00:00 | 3 | N5 |  |  |  |  |  | FabNoTest1 | 32.79 | 0 | N | Sub_J No | Fab&Con |  | 24838 | 956.6996370767039
2 | 1202 | 1070 | 021F | LT | 12.75 | 312 | 0.15 | 0.21 | 312 | 12.75 | 312 | 0 | 0 | 1 | 100 | 0 | 0 | n | 0 |  | 101.3 | 0.15 | 0.21 | 1.000 | ARC | ERW | BUTT | 42000 | 0.219 | 1969-01-01 00:00:00 | 1105 | W | 0 | 500 | 34.6543 | 450 | 31.1888 | 1969-01-01 00:00:00 | 1 | N5 |  |  |  |  |  | ManuFault | 31.19 | 2.46 | Y | 1970_Liq0.5_Yes |  |  | 24842 | 97.40963889234735
 | 1202 |  | 021F | LT | 12.75 | 10454 |  |  | 10454 | 12.75 |  | 10454 | 0 |  |  |  |  |  |  | Added per PG&E Direction | 101.3 | 0.15 | 0.21 | 1.000 | ARC | ERW | BUTT | 42000 | 0.219 | 1969-01-01 00:00:00 | 1105 | W | 0 | 500 | 34.6543 | 450 | 31.1888 | 1969-01-01 00:00:00 | 1 | N5 |  |  |  |  |  | ManuFault | 31.19 | 2.46 | Y | 1970_Liq0.5_Yes |  |  | 24842 | 97.40963889234735
2 | 1202 | 1071 | 021F | LT | 12.75 | 4595 | 10.85 | 11.72 | 4595 | 12.75 |  | 4595 |  | 7 | 550 |  |  |  |  |  | 125 | 10.85 | 11.72 | 1.000 | ARC | SMLS | BUTT | 35000 | 0.25 | 1983-01-01 00:00:00 | 809 | W | 8 | 500 | 36.4286 | 450 | 32.7857 |  | 3 | I1 | No | Yes | Yes | Yes | No | FabGM2 | 32.79 | 1.8 | Y | Fab3 1-25-11 | Fab&Con | Seismic Step | 24451 | 1403.202894544262