Spreadsheet: 27093d1219940697-lookup-index-and-or-match-excel-forum-macro-example
Sheet: BOM Component Detail

No. | No. | BOM No. | Customer No.-BOM No. | BOM Component No. | Nominal Thickness | [NAME] | Cut Length | RoundUp Length | RAW length | Quantity Per | Make from Material Type | TCR CODE | AGILITY CODE | BOM Component Type | Assembly Time | Cost Center Code | Record Modified | Invoicing Thickness | Invoicing Width | Invoicing Cut Length | Nav Item | Desc | Agility Code | Price | Price UOM | Unit of Measure | Labor Only | Panel Product
PHMI01-0001 | PHMI01-0001 | 1 | 421009-1 | 10 | 8 | 8 | 108 | 108 | 120 | 20 | 07800-00 |  |  | MISC. | 0 | AS | Yes | 8 | 8 | 108 |  |  |  |  |  | EACH | No | No
PHMI01-0002 | PHMI01-0002 | 2 | 421009-2 | 10 | 10 | 12 | 120 | 120 | 120 | 9 | 08100-00 |  |  | MISC. | 0 | AS | Yes | 10 | 12 | 120 |  |  |  |  |  | EACH | No | No
PHMI01-0003 | PHMI01-0003 | 3 | 421009-3 | 10 | 3 | 3 | 25 | 25 | 30 | 1 | 06000-00 |  |  | MISC. | 0 | AS | No | 3 | 3 | 25 |  |  |  |  |  | EACH | No | No
PHMI01-0004 | PHMI01-0004 | 4 | 421009-4 | 10 | 3 | 3 | 30 | 30 | 30 | 1 | 06000-00 |  |  | MISC. | 0 | AS | No | 3 | 3 | 30 |  |  |  |  |  | EACH | No | No
PHMI01-0005 | PHMI01-0005 | 5 | 421009-5 | 10 | 1 | 6 | 25 | 25 | 30 | 1 | 00200HT-00 |  |  | MISC. | 0 | AS | No | 1 | 6 | 25 |  |  |  |  |  | EACH | No | No
PHMI01-0006 | PHMI01-0006 | 6 | 421009-6 | 10 | 4 | 6 | 42 | 42 | 48 | 1 | 06300-00 |  |  | MISC. | 0 | AS | No | 4 | 6 | 42 |  |  |  |  |  | EACH | No | No
PHMI01-0007 | PHMI01-0007 | 7 | 421009-7 | 10 | 0.25 | 32 | 59 | 59 | 60 | 1 | 15400-00 |  |  | MISC. | 0 | AS | No | 0.25 | 32 | 59 |  |  |  |  |  | EACH | No | Yes
PHMI01-0008 | PHMI01-0008 | 8 | 421009-8 | 10 | 0.25 | 32 | 32 | 32 | 32 | 1 | 15400-00 |  |  | MISC. | 0 | AS | No | 0.25 | 32 | 32 |  |  |  |  |  | EACH | No | Yes
PHMI01-0009 | PHMI01-0009 | 9 | 421009-9 | 10 | 0.25 | 33 | 46 | 46 | 48 | 1 | 15400-00 |  |  | MISC. | 0 | AS | No | 0.25 | 33 | 46 |  |  |  |  |  | EACH | No | Yes
PHMI01-0010 | PHMI01-0010 | 10 | 421009-10 | 10 | 2 | 8 | 120 | 120 | 120 | 75 | 07402-00 |  |  | MISC. | 0 | AS | Yes | 2 | 8 | 120 |  |  |  |  |  | EACH | No | No
PHMI01-0011 | PHMI01-0011 | 11 | 421009-11 | 10 | 2 | 10 | 36 | 36 | 40 | 8 | 01700HT-00 | S2103 | S210-3HT | END | 0 | AS | No | 2 | 10 | 36 |  |  |  |  |  | EACH | No | No
 | PHMI01-0011 | 11 | 421009-11 | 20 | 2 | 4 | 37 | 37 | 40 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 37 |  |  |  |  |  | EACH | No | No
 | PHMI01-0011 | 11 | 421009-11 | 30 | 2 | 4 | 28.875 | 29 | 30 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 28.875 |  |  |  |  |  | EACH | No | No
 | PHMI01-0011 | 11 | 421009-11 | 40 | 2 | 10 | 82 | 82 | 84 | 8 | 01700HT-00 | S2103 | S210-3HT | SIDE | 0 | AS | No | 2 | 10 | 82 |  |  |  |  |  | EACH | No | No
 | PHMI01-0011 | 11 | 421009-11 | 50 | 2 | 10 | 82 | 82 | 84 | 6 | 01700HT-00 | S2103 | S210-3HT | BASE | 0 | AS | No | 2 | 10 | 82 |  |  |  |  |  | EACH | No | No
 | PHMI01-0011 | 11 | 421009-11 | 60 | 2 | 12 | 82 | 82 | 84 | 2 | 01600HT-00 | S2123 | S212-3HT | BASE | 0 | AS | No | 2 | 12 | 82 |  |  |  |  |  | EACH | No | No
 | PHMI01-0011 | 11 | 421009-11 | 70 | 2 | 4 | 42 | 42 | 48 | 9 | 01100HT-00 | S243 | S24-3HT | BASE | 0 | AS | No | 2 | 4 | 39 |  |  |  |  |  | EACH | No | No
 | PHMI01-0011 | 11 | 421009-11 | 80 | 2 | 4 | 40 | 40 | 40 | 6 | 01100HT-00 | S243 | S24-3HT | SIDE | 0 | AS | No | 2 | 4 | 40 |  |  |  |  |  | EACH | No | No
 | PHMI01-0011 | 11 | 421009-11 | 90 | 0 | 0 | 0 | 0 |  | 744 | FASTENERS |  |  | MISC. | 0 |  | No | 0 | 0 | 0 | 99900-00 | 2" & UNDER NAIL | F0043 |  |  | EACH | No | No
PHMI01-0012 | PHMI01-0012 | 12 | 421009-12 | 10 | 2 | 6 | 24.75 | 25 | 30 | 2 | 02800HT-00 | S263 | S26-3HT | END | 0 | AS | No | 2 | 6 | 24.75 |  |  |  |  |  | EACH | No | No
 | PHMI01-0012 | 12 | 421009-12 | 20 | 2 | 10 | 24.75 | 25 | 30 | 4 | 01700HT-00 | S2103 | S210-3HT | END | 0 | AS | No | 2 | 10 | 24.75 |  |  |  |  |  | EACH | No | No
 | PHMI01-0012 | 12 | 421009-12 | 30 | 2 | 4 | 24 | 24 | 24 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 24 |  |  |  |  |  | EACH | No | No
 | PHMI01-0012 | 12 | 421009-12 | 40 | 2 | 4 | 17.625 | 18 | 20 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 17.625 |  |  |  |  |  | EACH | No | No
 | PHMI01-0012 | 12 | 421009-12 | 50 | 2 | 6 | 78 | 78 | 84 | 2 | 02800HT-00 | S263 | S26-3HT | SIDE | 0 | AS | No | 2 | 3 | 78 |  |  |  |  |  | EACH | No | No
 | PHMI01-0012 | 12 | 421009-12 | 60 | 2 | 10 | 78 | 78 | 84 | 4 | 01700HT-00 | S2103 | S210-3HT | SIDE | 0 | AS | No | 2 | 10 | 78 |  |  |  |  |  | EACH | No | No
 | PHMI01-0012 | 12 | 421009-12 | 70 | 2 | 10 | 78 | 78 | 84 | 6 | 01700HT-00 | S2103 | S210-3HT | TOP | 0 | AS | No | 2 | 10 | 78 |  |  |  |  |  | EACH | No | No
 | PHMI01-0012 | 12 | 421009-12 | 80 | 2 | 4 | 27.75 | 28 | 30 | 9 | 01100HT-00 | S243 | S24-3HT | TOP | 0 | AS | No | 2 | 4 | 27.75 |  |  |  |  |  | EACH | No | No
 | PHMI01-0012 | 12 | 421009-12 | 90 | 0 | 0 | 0 | 0 |  | 422 | FASTENERS |  |  | MISC. | 0 |  | No | 0 | 0 | 0 | 99900-00 | 2" & UNDER NAIL | F0043 |  |  | EACH | No | No
PHMI01-0013 | PHMI01-0013 | 13 | 421009-13 | 10 | 2 | 10 | 64 | 64 | 72 | 8 | 01700HT-00 | S2103 | S210-3HT | END | 0 | AS | No | 2 | 10 | 64 |  |  |  |  |  | EACH | No | No
 | PHMI01-0013 | 13 | 421009-13 | 20 | 2 | 4 | 64 | 64 | 72 | 2 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 64 |  |  |  |  |  | EACH | No | No
 | PHMI01-0013 | 13 | 421009-13 | 30 | 2 | 4 | 40.5 | 41 | 48 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 40.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0013 | 13 | 421009-13 | 40 | 2 | 4 | 56.875 | 57 | 60 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 56.875 |  |  |  |  |  | EACH | No | No
 | PHMI01-0013 | 13 | 421009-13 | 50 | 2 | 10 | 70 | 70 | 72 | 8 | 01700HT-00 | S2103 | S210-3HT | SIDE | 0 | AS | No | 2 | 10 | 70 |  |  |  |  |  | EACH | No | No
 | PHMI01-0013 | 13 | 421009-13 | 60 | 2 | 4 | 70 | 70 | 72 | 2 | 01100HT-00 | S243 | S24-3HT | SIDE | 0 | AS | No | 2 | 4 | 70 |  |  |  |  |  | EACH | No | No
 | PHMI01-0013 | 13 | 421009-13 | 70 | 2 | 4 | 43.5 | 44 | 48 | 6 | 01100HT-00 | S243 | S24-3HT | SIDE | 0 | AS | No | 2 | 4 | 43.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0013 | 13 | 421009-13 | 80 | 2 | 10 | 70 | 70 | 72 | 12 | 01700HT-00 | S2103 | S210-3HT | TOP | 0 | AS | No | 2 | 10 | 70 |  |  |  |  |  | EACH | No | No
 | PHMI01-0013 | 13 | 421009-13 | 90 | 2 | 12 | 70 | 70 | 72 | 2 | 01600HT-00 | S2123 | S212-3HT | TOP | 0 | AS | No | 2 | 12 | 70 |  |  |  |  |  | EACH | No | No
 | PHMI01-0013 | 13 | 421009-13 | 100 | 2 | 4 | 70 | 70 | 72 | 9 | 01100HT-00 | S243 | S24-3HT | TOP | 0 | AS | No | 2 | 4 | 70 |  |  |  |  |  | EACH | No | No
 | PHMI01-0013 | 13 | 421009-13 | 110 | 0 | 0 | 0 | 0 |  | 575 | FASTENERS |  |  | MISC. | 0 |  | No | 0 | 0 | 0 | 99900-00 | 2" & UNDER NAIL | F0043 |  |  | EACH | No | No
PHMI01-0014 | PHMI01-0014 | 14 | 421009-14 | 10 | 2 | 10 | 19.5 | 20 | 20 | 2 | 01700HT-00 | S2103 | S210-3HT | END | 0 | AS | No | 1 | 10 | 19.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0014 | 14 | 421009-14 | 20 | 2 | 12 | 19.5 | 20 | 20 | 2 | 01600HT-00 | S2123 | S212-3HT | END | 0 | AS | No | 2 | 12 | 19.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0014 | 14 | 421009-14 | 30 | 2 | 4 | 20.5 | 21 | 24 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 20.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0014 | 14 | 421009-14 | 40 | 2 | 4 | 12.375 | 13 | 16 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 12.375 |  |  |  |  |  | EACH | No | No
 | PHMI01-0014 | 14 | 421009-14 | 50 | 2 | 10 | 168 | 168 | 168 | 2 | 01700HT-00 | S2103 | S210-3HT | SIDE | 0 | AS | No | 1 | 10 | 168 |  |  |  |  |  | EACH | No | No
 | PHMI01-0014 | 14 | 421009-14 | 60 | 2 | 12 | 168 | 168 | 168 | 2 | 01600HT-00 | S2123 | S212-3HT | SIDE | 0 | AS | No | 2 | 12 | 168 |  |  |  |  |  | EACH | No | No
 | PHMI01-0014 | 14 | 421009-14 | 70 | 2 | 12 | 168 | 168 | 168 | 4 | 01600HT-00 | S2123 | S212-3HT | TOP | 0 | AS | No | 2 | 12 | 168 |  |  |  |  |  | EACH | No | No
 | PHMI01-0014 | 14 | 421009-14 | 80 | 2 | 4 | 24 | 24 | 24 | 8 | 01100HT-00 | S243 | S24-3HT | TOP | 0 | AS | No | 2 | 4 | 22.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0014 | 14 | 421009-14 | 90 | 1 | 4 | 24 | 24 | 24 | 4 | 00100HT-00 |  |  | BASE | 0 | AS | No | 2 | 4 | 22.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0014 | 14 | 421009-14 | 100 | 1 | 4 | 23.5 | 24 | 24 | 8 | 00100HT-00 |  |  | SIDE | 0 | AS | No | 1 | 4 | 23.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0014 | 14 | 421009-14 | 110 | 0 | 0 | 0 | 0 |  | 345 | FASTENERS |  |  | MISC. | 0 |  | No | 0 | 0 | 0 | 99900-00 | 2" & UNDER NAIL | F0043 |  |  | EACH | No | No
PHMI01-0015 | PHMI01-0015 | 15 | 421009-15 | 10 | 2 | 10 | 81 | 81 | 84 | 6 | 01700HT-00 | S2103 | S210-3HT | END | 0 | AS | No | 2 | 10 | 81 |  |  |  |  |  | EACH | No | No
 | PHMI01-0015 | 15 | 421009-15 | 20 | 2 | 4 | 38 | 38 | 40 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 38 |  |  |  |  |  | EACH | No | No
 | PHMI01-0015 | 15 | 421009-15 | 30 | 2 | 4 | 73.875 | 74 | 84 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 73.875 |  |  |  |  |  | EACH | No | No
 | PHMI01-0015 | 15 | 421009-15 | 40 | 2 | 4 | 30.875 | 31 | 32 | 2 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 30.875 |  |  |  |  |  | EACH | No | No
 | PHMI01-0015 | 15 | 421009-15 | 50 | 2 | 10 | 87 | 87 | 96 | 6 | 01700HT-00 | S2103 | S210-3HT | SIDE | 0 | AS | No | 10 | 10 | 87 |  |  |  |  |  | EACH | No | No
 | PHMI01-0015 | 15 | 421009-15 | 60 | 2 | 4 | 41 | 41 | 48 | 6 | 01100HT-00 | S243 | S24-3HT | SIDE | 0 | AS | No | 2 | 4 | 41 |  |  |  |  |  | EACH | No | No
 | PHMI01-0015 | 15 | 421009-15 | 70 | 2 | 10 | 87 | 87 | 96 | 16 | 01700HT-00 | S2103 | S210-3HT | TOP | 0 | AS | No | 2 | 10 | 87 |  |  |  |  |  | EACH | No | No
 | PHMI01-0015 | 15 | 421009-15 | 80 | 2 | 12 | 87 | 87 | 96 | 2 | 01600HT-00 | S2123 | S212-3HT | TOP | 0 | AS | No | 2 | 12 | 87 |  |  |  |  |  | EACH | No | No
 | PHMI01-0015 | 15 | 421009-15 | 90 | 2 | 4 | 87 | 87 | 96 | 6 | 01100HT-00 | S243 | S24-3HT | TOP | 0 | AS | No | 2 | 4 | 87 |  |  |  |  |  | EACH | No | No
 | PHMI01-0015 | 15 | 421009-15 | 100 | 2 | 4 | 87 | 87 | 96 | 3 | 01100HT-00 | S243 | S24-3HT | TOP | 0 | AS | No | 2 | 4 | 87 |  |  |  |  |  | EACH | No | No
 | PHMI01-0015 | 15 | 421009-15 | 110 | 2 | 10.25 | 81 | 81 | 84 | 2 | 01600HT-00 | S2123 | S212-3HT | END | 0 | AS | No | 2 | 12 | 81 |  |  |  |  |  | EACH | No | No
 | PHMI01-0015 | 15 | 421009-15 | 120 | 2 | 10.25 | 87 | 87 | 96 | 2 | 01600HT-00 | S2123 | S212-3HT | SIDE | 0 | AS | No | 2 | 12 | 87 |  |  |  |  |  | EACH | No | No
 | PHMI01-0015 | 15 | 421009-15 | 130 | 0 | 0 | 0 | 0 |  | 810 | FASTENERS |  |  | MISC. | 0 |  | No | 0 | 0 | 0 | 99900-00 | 2" & UNDER NAIL | F0043 |  |  | EACH | No | No
PHMI01-0016 | PHMI01-0016 | 16 | 421009-16 | 10 | 2 | 10 | 95 | 95 | 96 | 4 | 01700HT-00 | S2103 | S210-3HT | END | 0 | AS | No | 2 | 10 | 95 |  |  |  |  |  | EACH | No | No
 | PHMI01-0016 | 16 | 421009-16 | 20 | 2 | 4 | 18.5 | 19 | 20 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 18.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0016 | 16 | 421009-16 | 30 | 2 | 4 | 11.375 | 12 | 12 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 11.375 |  |  |  |  |  | EACH | No | No
 | PHMI01-0016 | 16 | 421009-16 | 40 | 2 | 10 | 101 | 101 | 120 | 4 | 01700HT-00 | S2103 | S210-3HT | SIDE | 0 | AS | No | 2 | 10 | 101 |  |  |  |  |  | EACH | No | No
 | PHMI01-0016 | 16 | 421009-16 | 50 | 2 | 4 | 21.5 | 22 | 24 | 6 | 01100HT-00 | S243 | S24-3HT | SIDE | 0 | AS | No | 2 | 4 | 21.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0016 | 16 | 421009-16 | 60 | 2 | 10 | 101 | 101 | 120 | 20 | 01700HT-00 | S2103 | S210-3HT | TOP | 0 | AS | No | 2 | 10 | 101 |  |  |  |  |  | EACH | No | No
 | PHMI01-0016 | 16 | 421009-16 | 70 | 2 | 6 | 101 | 101 | 120 | 2 | 04203HT-00 | S263 | S26-3HT | TOP | 0 | AS | No | 2 | 6 | 101 |  |  |  |  |  | EACH | No | No
 | PHMI01-0016 | 16 | 421009-16 | 80 | 2 | 4 | 101 | 101 | 120 | 9 | 01100HT-00 | S243 | S24-3HT | TOP | 0 | AS | No | 2 | 4 | 101 |  |  |  |  |  | EACH | No | No
 | PHMI01-0016 | 16 | 421009-16 | 90 | 2 | 4 | 88 | 88 | 96 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 88 |  |  |  |  |  | EACH | No | No
 | PHMI01-0016 | 16 | 421009-16 | 100 | 0 | 0 | 0 | 0 |  | 1210 | FASTENERS |  |  | MISC. | 0 |  | No | 0 | 0 | 0 | 99900-00 | 2" & UNDER NAIL | F0043 |  |  | EACH | No | No
PHMI01-0017 | PHMI01-0017 | 17 | 421009-17 | 10 | 2 | 8 | 40.5 | 41 | 48 | 6 | 02700HT-00 | S283 | S28-3HT | END | 0 | AS | No | 2 | 8 | 40.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0017 | 17 | 421009-17 | 20 | 2 | 10 | 40.5 | 41 | 48 | 2 | 01700HT-00 | S2103 | S210-3HT | END | 0 | AS | No | 2 | 10 | 40.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0017 | 17 | 421009-17 | 30 | 2 | 4 | 31 | 31 | 32 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 31 |  |  |  |  |  | EACH | No | No
 | PHMI01-0017 | 17 | 421009-17 | 40 | 2 | 4 | 33.375 | 34 | 40 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 33.375 |  |  |  |  |  | EACH | No | No
 | PHMI01-0017 | 17 | 421009-17 | 50 | 2 | 8 | 46 | 46 | 48 | 6 | 02700HT-00 | S283 | S28-3HT | SIDE | 0 | AS | No | 2 | 8 | 46 |  |  |  |  |  | EACH | No | No
 | PHMI01-0017 | 17 | 421009-17 | 60 | 2 | 10 | 46 | 46 | 48 | 2 | 01700HT-00 | S2103 | S210-3HT | SIDE | 0 | AS | No | 2 | 10 | 46 |  |  |  |  |  | EACH | No | No
 | PHMI01-0017 | 17 | 421009-17 | 70 | 2 | 8 | 46 | 46 | 48 | 12 | 02700HT-00 | S283 | S28-3HT | TOP | 0 | AS | No | 2 | 8 | 46 |  |  |  |  |  | EACH | No | No
 | PHMI01-0017 | 17 | 421009-17 | 80 | 2 | 4 | 43.5 | 44 | 48 | 6 | 01100HT-00 | S243 | S24-3HT | TOP | 0 | AS | No | 2 | 4 | 43.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0017 | 17 | 421009-17 | 90 | 1 | 4 | 43.5 | 44 | 48 | 3 | 00100HT-00 |  |  | TOP | 0 | AS | No | 1 | 4 | 43.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0017 | 17 | 421009-17 | 100 | 0 | 0 | 0 | 0 |  | 450 | FASTENERS |  |  | MISC. | 0 |  | No | 0 | 0 | 0 | 99901-00 | 2-1/2" & OVER NAIL | [NAME] |  |  | EACH | No | No
PHMI01-0018 | PHMI01-0018 | 18 | 421009-18 | 10 | 2 | 4 | 45 | 45 | 48 | 2 | 02200HT-00 | S243 | S24-3HT | END | 0 | AS | Yes | 2 | 8 | 45.25 |  |  |  |  |  | EACH | No | No
 | PHMI01-0018 | 18 | 421009-18 | 20 | 2 | 10 | 45 | 45 | 48 | 6 | 01700HT-00 | S2103 | S210-3HT | END | 0 | AS | Yes | 2 | 10 | 45.25 |  |  |  |  |  | EACH | No | No
 | PHMI01-0018 | 18 | 421009-18 | 30 | 2 | 4 | 31.25 | 32 | 32 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | Yes | 2 | 4 | 31 |  |  |  |  |  | EACH | No | No
 | PHMI01-0018 | 18 | 421009-18 | 40 | 2 | 4 | 37.875 | 38 | 40 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 38.125 |  |  |  |  |  | EACH | No | No
 | PHMI01-0018 | 18 | 421009-18 | 50 | 2 | 4 | 51 | 51 | 60 | 2 | 02200HT-00 | S243 | S24-3HT | SIDE | 0 | AS | Yes | 2 | 8 | 51 |  |  |  |  |  | EACH | No | No
 | PHMI01-0018 | 18 | 421009-18 | 60 | 2 | 10 | 51 | 51 | 60 | 6 | 01700HT-00 | S2103 | S210-3HT | SIDE | 0 | AS | Yes | 2 | 10 | 51 |  |  |  |  |  | EACH | No | No
 | PHMI01-0018 | 18 | 421009-18 | 70 | 2 | 10 | 51 | 51 | 60 | 8 | 01700HT-00 | S2103 | S210-3HT | TOP | 0 | AS | No | 2 | 10 | 51 |  |  |  |  |  | EACH | No | No
 | PHMI01-0018 | 18 | 421009-18 | 80 | 2 | 6 | 51 | 51 | 60 | 4 | 02800HT-00 | S263 | S26-3HT | TOP | 0 | AS | No | 2 | 6 | 51 |  |  |  |  |  | EACH | No | No
 | PHMI01-0018 | 18 | 421009-18 | 90 | 2 | 4 | 51 | 51 | 60 | 6 | 02200HT-00 | S243 | S24-3HT | BASE | 0 | AS | Yes | 4 | 4 | 48 |  |  |  |  |  | EACH | No | No
 | PHMI01-0018 | 18 | 421009-18 | 100 | 2 | 4 | 51 | 51 | 60 | 3 | 02200HT-00 | S243 | S24-3HT | TOP | 0 | AS | Yes | 1 | 4 | 48 |  |  |  |  |  | EACH | No | No
 | PHMI01-0018 | 18 | 421009-18 | 110 | 0 | 0 | 0 | 0 |  | 434 | FASTENERS |  |  | MISC. | 0 |  | No | 0 | 0 | 0 | 99901-00 | 2-1/2" & OVER NAIL | [NAME] |  |  | EACH | No | No
 | PHMI01-0018 | 18 | 421009-18 | 120 | 2 | 4 | 34.25 | 35 | 40 | 6 | 02200HT-00 | S243 | S24-3HT | SIDE | 0 |  | Yes | 2 | 4 | 34.25 |  |  |  |  |  | EACH | No | No
PHMI01-0019 | PHMI01-0019 | 19 | 421009-19 | 10 | 2 | 10 | 19.5 | 20 | 20 | 2 | 01700HT-00 | S2103 | S210-3HT | END | 60 | AS | No | 2 | 10 | 19.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0019 | 19 | 421009-19 | 20 | 2 | 12 | 19.5 | 20 | 20 | 2 | 01600HT-00 | S2123 | S212-3HT | END | 0 | AS | No | 2 | 12 | 19.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0019 | 19 | 421009-19 | 30 | 2 | 4 | 20.5 | 21 | 24 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 20.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0019 | 19 | 421009-19 | 40 | 2 | 4 | 12.375 | 13 | 16 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 12.375 |  |  |  |  |  | EACH | No | No
 | PHMI01-0019 | 19 | 421009-19 | 50 | 2 | 10 | 212 | 212 | 216 | 2 | 01500HT-00 | S2103 | S210-3HT | SIDE | 0 | AS | No | 2 | 10 | 212 |  |  |  |  |  | EACH | No | No
 | PHMI01-0019 | 19 | 421009-19 | 60 | 2 | 12 | 212 | 212 | 216 | 2 | 01600HT-00 | S2123 | S212-3HT | SIDE | 0 | AS | No | 2 | 12 | 212 |  |  |  |  |  | EACH | No | No
 | PHMI01-0019 | 19 | 421009-19 | 70 | 2 | 4 | 23.5 | 24 | 24 | 10 | 02200HT-00 | S243 | S24-3HT | SIDE | 0 | AS | No | 2 | 4 | 23.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0019 | 19 | 421009-19 | 80 | 2 | 12 | 212 | 212 | 216 | 4 | 01600HT-00 | S2123 | S212-3HT | TOP | 0 | AS | No | 2 | 12 | 212 |  |  |  |  |  | EACH | No | No
 | PHMI01-0019 | 19 | 421009-19 | 90 | 2 | 4 | 25.5 | 26 | 30 | 5 | 02200HT-00 | S243 | S24-3HT | TOP | 0 | AS | No | 2 | 4 | 25.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0019 | 19 | 421009-19 | 100 | 2 | 6 | 25.5 | 26 | 30 | 10 | 02800HT-00 | S263 | S26-3HT | BASE | 0 | AS | No | 2 | 6 | 25.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0019 | 19 | 421009-19 | 110 | 0 | 0 | 0 | 0 |  | 522 | FASTENERS |  |  | MISC. | 0 |  | No | 0 | 0 | 0 | 99901-00 | 2-1/2" & OVER NAIL | [NAME] |  |  | EACH | No | No
PHMI01-0020 | PHMI01-0020 | 20 | 421009-20 | 10 | 2 | 10 | 19.5 | 20 | 20 | 2 | 01700HT-00 | S2103 | S210-3HT | END | 0 | AS | No | 2 | 10 | 19.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0020 | 20 | 421009-20 | 20 | 2 | 12 | 19.5 | 20 | 20 | 2 | 01600HT-00 | S2123 | S212-3HT | END | 0 | AS | No | 2 | 12 | 19.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0020 | 20 | 421009-20 | 30 | 2 | 4 | 20.5 | 21 | 24 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 20.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0020 | 20 | 421009-20 | 40 | 2 | 4 | 12.375 | 13 | 16 | 4 | 01100HT-00 | S243 | S24-3HT | END | 0 | AS | No | 2 | 4 | 12.375 |  |  |  |  |  | EACH | No | No
 | PHMI01-0020 | 20 | 421009-20 | 50 | 2 | 10 | 136 | 136 | 144 | 2 | 01700HT-00 | S2103 | S210-3HT | SIDE | 0 | AS | No | 2 | 10 | 136 |  |  |  |  |  | EACH | No | No
 | PHMI01-0020 | 20 | 421009-20 | 60 | 2 | 12 | 136 | 136 | 144 | 2 | 01600HT-00 | S2123 | S212-3HT | SIDE | 0 | AS | No | 2 | 12 | 136 |  |  |  |  |  | EACH | No | No
 | PHMI01-0020 | 20 | 421009-20 | 70 | 1 | 4 | 23.5 | 24 | 24 | 6 | 00600HT-00 |  |  | SIDE | 0 | AS | No | 2 | 4 | 23.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0020 | 20 | 421009-20 | 80 | 2 | 12 | 136 | 136 | 144 | 4 | 01600HT-00 | S2123 | S212-3HT | TOP | 0 | AS | No | 2 | 12 | 136 |  |  |  |  |  | EACH | No | No
 | PHMI01-0020 | 20 | 421009-20 | 90 | 2 | 4 | 24 | 24 | 24 | 6 | 01100HT-00 | S243 | S24-3HT | BASE | 0 | AS | No | 2 | 4 | 25.5 |  |  |  |  |  | EACH | No | No
 | PHMI01-0020 | 20 | 421009-20 | 100 | 1 | 4 | 24 | 24 | 24 | 3 | 00600HT-00 |  |  | TOP | 0 | AS | No | 1 | 4 | 24 |  |  |  |  |  | EACH | No | No
 | PHMI01-0020 | 20 | 421009-20 | 110 | 0 | 0 | 0 | 0 |  | 478 | FASTENERS |  |  | MISC. | 0 |  | No | 0 | 0 | 0 | 99901-00 | 2-1/2" & OVER NAIL | [NAME] |  |  | EACH | No | No