Spreadsheet: 860023d1708254165-using-tags-to-filter-bom_sample_excel_forum
Sheet: SAMPLE

#[NAME]!
 |  |  |  |  |  |  |  |  | 20m [NAME] DECK | 20m [NAME] | STAGE SHEDS | FOH | AVP
 | WEIGHT | OLD CODE | MISC HIDDEN | INTEGRITY | STOCK (2024) | PRODUCT CODE | COMPONENT DESCRIPTION | PRODUCT TAGS | COUNT | COUNT | COUNT | COUNT | COUNT | PM [NAME] | SITE [NAME] | TOTAL | PREPPED | [NAME] | TOTAL WEIGHT (KG)
 |  |  |  |  |  |  | STARLOCK
 | 0.4 | [NAME] | 12 | AA1080 | 1653 | AA1080 | Cuplok - Vertical - 0.5m (1 cup spigot) | ;[NAME]; | 20 |  | 20
 | 7 | 270100 | 13 | AA1090 | 2142 | AA1090 | Cuplok - Vertical - 1m | ;[NAME]; |  |  |  | 8 | 8
 | 11.3 | 270200 | 14 | AA1100 | 1532 | AA1100 | Cuplok - Vertical - 2m | ;[NAME]; |  | 4
 | 16.6 | 270300 | 15 | AA2530 | 11 | AA2530 | Cuplok - Vertical - 3m | ;[NAME]; | 14
 | 11 | 270133 | 16 | AA1120 | 872 | AA1120 | Cuplok - Vertical - 1.3m NO SPIGOT | ;[NAME]; | 13
 | 10 | 270183 | 17 | AA1130 | 1103 | AA1130 | Cuplok - Vertical - 1.8m NO SPIGOT | ;[NAME]; | 16
 | 11.6 | 270233 | 18 | AA1140 | 761 | AA1140 | Cuplok - Vertical - 2.3m NO SPIGOT | ;[NAME]; | 17
 |  |  |  |  |  |  | HANDRAILS
 | 35 | SSH2500 | 664 | DA1170 | 275 | DA1170 | [NAME] | ;[NAME]; | 25 |  |  | 10 | 40
 | 38 | SSH1800 | 665 | DA1180 | 91 | DA1180 | [NAME] | ;[NAME]; | 1 |  |  | 1 | 1
 | 20 | SSH1300 | 666 | DA1190 | 36 | DA1190 | [NAME] | ;[NAME]; |  | 4
 | 19 | SSH1250 | 667 | DA1200 | 35 | DA1200 | [NAME] | ;[NAME]; | 4 |  |  | 1 | 1
 | 18 | SSH1200 | 668 | DA1210 | 1 | DA1210 | [NAME] - Black | ;[NAME]; |  | 4
 | 15 | SSH900 | 669 | DA2380 | 1 | DA2380 | [NAME] | ;[NAME]; |  | 4
 | 15 | SSH600 | 670 | DA1530 | 45 | DA1530 | [NAME] | ;[NAME]; | 4 |  |  | 4
 |  |  | 642 |  |  |  | SEATING
 | 37 | SSR2505 | 650 | DA1030 | 652 | DA1030 | Seating - Raker - 2500 x 500 - Blue | ;SEATING; | 4 |  |  | 4 | 4
 | 29 | SSR1805 | 651 | DA1040 | 112 | DA1040 | Seating - Raker - 1800 x 500 - Green | ;SEATING; |  | 4
 | 43 | SSR2510 | 652 | DA1050 | 0 | DA1050 | Seating - Raker - 2500 x 1000 - Red | ;SEATING; |  |  | 4
 | 29 | STG2505 | 653 | DA1060 | 150 | DA1060 | Seating - Raker to Ground - 2500 x 500 - Yellow | ;SEATING; |  |  |  | 4
 |  |  | 839 |  |  |  | ACCESS
 | 360 | [NAME] | 849 | GC1600 | 7 | GC1600 | Steps - 2.0m - Steel HD - Fire escape | ;ORBIT;;SEATING;;VERTECH;;ULTRA; | 1 |  |  | 2
 | 130 | SFV3000 | 852 |  |  | GC1430 | Steps - 1.2m - Aluminium | ;ORBIT;;SEATING;;VERTECH;;ULTRA; |  | 2
 | 80 | HYA0600 | 855 | GC1110 | 2 | GC1110 | Steps - HOYS - 0.6m - c/w Handrails | ;ORBIT;;SEATING;;VERTECH;;ULTRA; |  |  |  | 2
 | 100 | HYA0800 | 858 | GC1130 | 3 | GC1130 | Steps - HOYS - 0.8m - c/w Handrails | ;ORBIT;;SEATING;;VERTECH;;ULTRA; |  |  |  |  | 6
 | 105 | HYA0900 | 861 | GC1150 | 6 | GC1150 | Steps - HOYS - 0.9m - c/w Handrails | ;ORBIT;;SEATING;;VERTECH;;ULTRA; |  |  | 2
 | 125 | HYA1000 | 866 | GC1190 | 4 | GC1190 | Steps - HOYS - 1.0m - c/w Handrails | ;ORBIT;;SEATING;;VERTECH;;ULTRA; |  |  |  |  | 6
 | 185 | HYA1200 | 869 | GC1210 | 4 | GC1210 | Steps - HOYS - 1.2m - c/w Handrails | ;ORBIT;;SEATING;;VERTECH;;ULTRA; |  |  | 2
 | 100 | HYA2000 | 872 | GC1230 | 2 | GC1230 | Steps - HOYS - 2.0m - c/w Handrails | ;ORBIT;;SEATING;;VERTECH;;ULTRA; |  |  |  | 6
 | 7.5 | 303244 | 880 | GC1280 | 26 | GC1280 | Ladder - 3.0m | ;ORBIT;;SEATING;;VERTECH;;ULTRA; |  | 2
 | 13.3 | 304244 | 881 | [NAME] | 6 | [NAME] | Ladder - 4.0m | ;ORBIT;;SEATING;;VERTECH;;ULTRA; |  |  | 2
 | 19.2 | 305244 | 882 | GC1300 | 8 | GC1300 | Ladder - 5.0m | ;ORBIT;;SEATING;;VERTECH;;ULTRA; | 2
 | 22.6 | 306244 | 883 | GC1310 | 3 | GC1310 | Ladder - 6.0m | ;ORBIT;;SEATING;;VERTECH;;ULTRA; | 2
 |  |  | 896 |  |  |  | KENTLEDGE
 | 250 | KUS0250 | 897 | AH1000 | 24 | AH1000 | Kentledge - 250kg - Steel square - 500x500x100 | ;ORBIT;;SEATING;;VERTECH;;ULTRA; | 1
 | 254 | KRS0254 | 901 | AH1040 | 8 | AH1040 | Kentledge - 254kg - Roller - 430 dia. | ;ORBIT;;SEATING;;VERTECH;;ULTRA; | 1
 | 500 | KUC0500 | 903 | AH1060 | 4 | AH1060 | Kentledge - 500kg - Concrete - 970x570x580 | ;ORBIT;;SEATING;;VERTECH;;ULTRA; | 1
 | 1000 |  | 907 | AH1110 | 2 | AH1110 | Kentledge - 1000kg - Steel block - 550x550x610 | ;ORBIT;;SEATING;;VERTECH;;ULTRA; | 1
 | 1000 | KFS1000 | 900 | AH1030 | 8 | AH1030 | Kentledge - 1000kg - Steel slab - 2000x1000x65 | ;ORBIT;;SEATING;;VERTECH;;ULTRA; | 1
 | 1100 | KUC1100 | 899 | AH1020 | 121 | AH1020 | Kentledge - 1100kg - Concrete - 1100x1100x620 | ;ORBIT;;SEATING;;VERTECH;;ULTRA; | 6
 |  |  | 910 | AH1160 | 36 | AH1160 | Kentledge - 1250kg - Steel slab - 2500x1000x65 | ;ORBIT;;SEATING;;VERTECH;;ULTRA; | 6
 | 2000 |  |  | AH1170 | 8 | AH1170 | Kentledge - 2000kg - Concrete - 1225x990x750 | ;ORBIT;;SEATING;;VERTECH;;ULTRA; | 8
 | 2000 |  | 906 | AH1100 | 2 | AH1100 | Kentledge - 2000kg - Steel block - 670x670x670 | ;ORBIT;;SEATING;;VERTECH;;ULTRA; | 7
 |  |  | 918 |  |  |  | [NAME]
 | 13 |  | 937 | CE1010 | 10 | CE1010 | [NAME] | ;ORBIT;;RIGGING;;SEATING;;VERTECH;;ULTRA; |  | 2
 | 13 |  | 937 | CE1000 | 7 | CE1000 | [NAME] | ;ORBIT;;RIGGING;;SEATING;;VERTECH;;ULTRA; |  | 3
 | 16 |  | 937 | CE1020 | 3 | CE1020 | [NAME] | ;ORBIT;;RIGGING;;SEATING;;VERTECH;;ULTRA; |  | 6
 | 22 |  | 937 | CE1030 | 42 | CE1030 | [NAME] | ;ORBIT;;RIGGING;;SEATING;;VERTECH;;ULTRA; |  | 7
 | 22 |  | 937 | CE1040 | 40 | CE1040 | [NAME] | ;ORBIT;;RIGGING;;SEATING;;VERTECH;;ULTRA; |  | 8
 | 27 |  | 937 | CE1050 | 3 | CE1050 | [NAME] | ;ORBIT;;RIGGING;;SEATING;;VERTECH;;ULTRA; |  | 9
 | 27 |  | 937 | CE1060 | 6 | CE1060 | [NAME] - 2.95m - Black | ;ORBIT;;RIGGING;;SEATING;;VERTECH;;ULTRA; |  | 10
 |  |  | 1672 |  |  |  | ULTRA
 | 3000 |  |  | AV1000 | 28 | AV1000 | Ultra - Base Mat - 3000kg | ;ULTRA;
 | 2700 |  |  | AV1010 | 4 | AV1010 | Ultra - Base Mat - 2700kg - Cut corner | ;ULTRA;
 | 2200 |  |  | AV1020 | 8 | AV1020 | Ultra - Tower - Adj. Base | ;ULTRA;
 | 75 |  |  | AV1030 | 32 | AV1030 | Ultra - Tower - Adj. Base - Jack | ;ULTRA;
 | 1200 |  |  | AV1040 | 8 | AV1040 | Ultra - Tower - Lower access | ;ULTRA;
 | 1200 |  |  | AV1050 | 25 | AV1050 | Ultra - Tower - 15' | ;ULTRA;
 | 1200 |  |  | AV1060 | 8 | AV1060 | Ultra - Tower - Upper access | ;ULTRA;
 | 880 |  |  | AV3030 | 8 | AV3030 | Ultra - Tower - Sleeve block | ;ULTRA;
 |  |  | 1672 |  |  |  | VERTECH
 | 14 | PDR1 | 1764 | AR1540 | 21 | AR1540 | VT Roof - Shed Rafter - PDR1 (4.5m) 2 plate -WHITE | ;VERTECH; |  | 3
 | 7 | PDR2 | 1765 | AR1550 | 33 | AR1550 | VT Roof - Shed Rafter - PDR2 (1.5m) | ;VERTECH; |  | 4
 | 11 | PDL | 1766 | AR1560 | 32 | AR1560 | VT Roof - Shed Leg - PDL (2.4m) | ;VERTECH; |  | 6
 | 10 | [NAME] | 1768 | AR1590 | 24 | AR1590 | VT Roof - Shed - Purlin - PDP1 (4.3m) HD Top BLACK | ;VERTECH; |  | 5
 | 5 | PDP2 | 1769 | AR1600 | 46 | AR1600 | VT Roof - Shed - Purlin - PDP2 (4.3m) Inter -GREEN | ;VERTECH; |  | 6
 | 11 | PDP3 | 1770 | AR1610 | 24 | AR1610 | VT Roof - Shed - Purlin - PDP3 (4.3m) Eaves -WHITE | ;VERTECH; |  | 7
 |  |  | 2452 |  |  |  | FOH
 | 13 | FSU0001 | 2453 | GF1000 | 72 | GF1000 | FoH Roof - Connection Post - 1100mm - 2x spigot | ;ORBIT;;SEATING;;VERTECH;;ULTRA; |  |  |  | 4
 | 10 | FSU0002 | 2454 | GF1010 | 72 | GF1010 | FoH Roof - Eaves Post - 1430mm | ;ORBIT;;SEATING;;VERTECH;;ULTRA; |  |  |  | 4
 | 6 |  | 2455 |  | 18 | GX0069 | FoH Roof - Eaves Post - 2400mm | ;ORBIT;;SEATING;;VERTECH;;ULTRA; |  |  |  | 4
 | 19 | FHU0004 | 2479 | GG1030 | 72 | GG1030 | FoH Roof - Rafter  - 4000mm - (7.5m system) | ;ORBIT;;SEATING;;VERTECH;;ULTRA; |  |  |  | 4
 | 7 | FHU0003 | 2478 | GG1020 | 44 | GG1020 | FoH Roof - Rafter  - 2440mm - (5.0m system) | ;ORBIT;;SEATING;;VERTECH;;ULTRA; |  |  |  | 4
 | 8 | FSU0003 | 2456 | GF1020 | 25 | GF1020 | FoH Roof - Rafter  - 2440mm - (2.5m system) | ;ORBIT;;SEATING;;VERTECH;;ULTRA; |  |  |  | 4
 | 2 | FSU0005 | 2458 | GF1040 | 27 | GF1040 | FoH Roof - Rafter  - 600mm - (2.5m system) | ;ORBIT;;SEATING;;VERTECH;;ULTRA; |  |  |  | 4
 | 6 | FSU0004 | 2457 | GG1330 | 44 | GG1330 | FoH Roof - Apex - Bracket - (2.5 / 5m system) | ;ORBIT;;SEATING;;VERTECH;;ULTRA; |  |  |  | 4
 | 9 | FHU0007 | 2483 | GG1060 | 29 | GG1060 | FoH Roof - Apex - Support Bar - (7.5m system) | ;ORBIT;;SEATING;;VERTECH;;ULTRA; |  |  |  | 4
 | 2 | FSU0008 | 2461 | GF1070 | 21 | GF1070 | FoH Roof - Spigot - (2.5m system) - Orange | ;ORBIT;;SEATING;;VERTECH;;ULTRA; |  |  |  | 4
 |  |  |  | BA1100
 |  |  |  | BA1120
 |  |  |  | BA1130
 |  |  |  | BB1270
 |  |  |  | BB1280
 |  |  |  | BB1290
 |  |  |  | BB1300
 |  |  |  | BB1320
 |  |  |  | BB1610
 |  |  |  | BC2200
 |  |  |  | BC2480
 |  |  |  | BC2490
 |  |  |  | DC1020
 |  |  |  | GR1200
 |  |  |  | CP1010
 |  |  |  | CP1020
 |  |  |  | CP1030
 |  |  |  | CP1040
 |  |  |  | CP1050
 |  |  |  | CP1060
 |  |  |  | CP1070
 |  |  |  | CP1080
 |  |  |  | CP1090
 |  |  |  | CP1100
 |  |  |  | DA1720
 |  |  |  | DA1880
 |  |  |  | DA1920
 |  |  |  | DA1990
 |  |  |  | DA2040
 |  |  |  | DA2080
 |  |  |  | DA2090
 |  |  |  | DA2100
 |  |  |  | DA2110
 |  |  |  | DA2120
 |  |  |  | DA2130
 |  |  |  | DA2140
 |  |  |  | DA2150
 |  |  |  | DA2160
 |  |  |  | [NAME]
 |  |  |  | DA2180
 |  |  |  | DA2190
 |  |  |  | DA2200
 |  |  |  | DA2210
 |  |  |  | DA2220
 |  |  |  | DA2230
 |  |  |  | DA2240
 |  |  |  | DA2260
 |  |  |  | DA2270
 |  |  |  | DA2280
 |  |  |  | DA2290
 |  |  |  | DA2300
 |  |  |  | DA2310
 |  |  |  | DA2360
 |  |  |  | DA2370
 |  |  |  | DB1230
 |  |  |  | DB1260
 |  |  |  | DB1270
 |  |  |  | DB1280
 |  |  |  | DB1300
 |  |  |  | DB1320
 |  |  |  | DC1000
 |  |  |  | DB1310
 |  |  |  | GC1500
 |  |  |  | DC1010
 |  |  |  | BC2380
 |  |  |  | DD1000
 |  |  |  | EB1070
 |  |  |  | EB1090
 |  |  |  | EB1110
 |  |  |  | GC1440
 |  |  |  | GC1470
 |  |  |  | GR1230
 |  |  |  | GG1310
 |  |  |  | GL1680
 |  |  |  | GL1960
 |  |  |  | GN1070
 |  |  |  | GN1150
 |  |  |  | GP1000
 |  |  |  | GR1230
 |  |  |  | GR1240
 |  |  |  | GR1280