Spreadsheet: 703235d1604875412-index-match-data-validation-dependent-drop-down-unique-list-material-_database
Sheet: Sheet6

MATERIAL DATABASE |  |  |  |  |  |  | NEW TABLE (WILL BE ON SEPARATE SHEET ONCE COMPLTED)
CATEGORY | DESCRIPTON | MODEL # | UNIT PRICE | QTY | TOTAL |  | CATEGORY | DESCRIPTON | MODEL # | UNIT PRICE | QTY | TOTAL
FLEX DUCT | 4 FLEX DUCT SILV R6 25 FT BAG | [NAME] | 18.07 |  |  |  | FLEX DUCT
FLEX DUCT | 5 FLEX DUCT SILV R6 25 FT BAG | R901R65 | 21.9 |  |  |  |  | INDEX/MATCH FORMULA
FLEX DUCT | 6 FLEX DUCT SILV R6 25 FT BAG | R901R66 | 23.31
FLEX DUCT | 7 FLEX DUCT SILV R6 25 FT BAG | R901R67 | 26.06
FLEX DUCT | 8 FLEX DUCT SILV R6 25 FT BAG | R901R68 | 28.22
FLEX DUCT | 9 FLEX DUCT SILV R6 25 FT BAG | R901R69 | 32.01
FLEX DUCT | 10 FLEX DUCT SILV R6 25 FT BAG | R901R610 | 35.34
FLEX DUCT | 12 FLEX DUCT SILV R6 25 FT BAG | R901R612 | 44.03
FLEX DUCT | 14 FLEX DUCT SILV R6 25 FT BAG | R901R614 | 52.38
FLEX DUCT | 16 FLEX DUCT SILV R6 25 FT BAG | R901R616 | 64.7
FLEX DUCT | 18 FLEX DUCT SILV R6 25 FT BAG | R901R618 | 70.44
FLEX DUCT | 20 FLEX DUCT SILV R6 25 FT BAG | R901R620 | 90.5
SPLICE COLLARS | 4 30GA FLEX DUCT CONN | SHMFDC30P | 0.9
SPLICE COLLARS | 5 30GA FLEX DUCT CONN | [NAME] | 0.95
SPLICE COLLARS | 6 30GA FLEX DUCT CONN | [NAME] | 0.97
SPLICE COLLARS | 7 30GA FLEX DUCT CONN | SHMFDC30W | 1.19
SPLICE COLLARS | 8 30GA FLEX DUCT CONN | [NAME] | 1.42
SPLICE COLLARS | 9 30GA FLEX DUCT CONN | SHMFDC30Y | 1.67
SPLICE COLLARS | 10 30GA FLEX DUCT CONN | SHMFDC3010 | 1.67
SPLICE COLLARS | 12 30GA FLEX DUCT CONN | SHMFDC3012 | 2.23
SPLICE COLLARS | 14 30GA FLEX DUCT CONN | SHMFDC3014 | 2.69
SPLICE COLLARS | 16 30GA FLEX DUCT CONN | SHMFDC3016 | 3.1
SPLICE COLLARS | 18 30GA FLEX DUCT CONN | SHMFDC3018 | 3.82
SPLICE COLLARS | 20 30GA FLEX DUCT CONN | SHMFDC3020 | 4.84
METAL 90'S | 4 30GA ADJ 90 ELL | SHMA930P | 1.2
METAL 90'S | 5 30GA ADJ 90 ELL | SHMA930S | 1.15
METAL 90'S | 6 30GA ADJ 90 ELL | SHMA930U | 1.2
METAL 90'S | 7 30GA ADJ 90 ELL | SHMA930W | 1.51
METAL 90'S | 8 30GA ADJ 90 ELL | SHMA930X | 1.78
METAL 90'S | 9 30GA ADJ 90 ELL | SHMA930Y | 2.62
METAL 90'S | 10 30GA ADJ 90 ELL | SHMA93010 | 2.91
METAL 90'S | 12 28GA ADJ 90 ELL | SHMA92812 | 4.22
METAL 90'S | 14 28GA ADJ 90 ELL | SHMA92814 | 5.68
METAL 90'S | 16 26GA ADJ 90 ELL | SHMA92616 | 9.52
SNAPLOCK PIP | SNAP | SHMP30PS | 4.37
SNAPLOCK PIP | 5X5 FT 30GA SNLK RND PIPE | SHMP30SS | 4.59
SNAPLOCK PIP | 6X5 FT 30GA SNLK RND PIPE | SHMP30US | 4.67
SNAPLOCK PIP | 7X5 FT 30GA SNLK RND PIPE | SHMP30WS | 4.98
SNAPLOCK PIP | 8X5 FT 30GA SNLK RND PIPE | SHMP30XS | 6.48
SNAPLOCK PIP | 9X5 FT 30GA SNLK RND PIPE | SHMP30YS | 7.84
SNAPLOCK PIP | 10X5 FT 30GA SNLK RND PIPE | SHMP3010S | 8.82
SNAPLOCK PIP | 12X5 FT 30GA SNLK RND PIPE | SHMP3012S | 11.46
SNAPLOCK PIP | 14X5 FT 28GA SNLK RND PIPE | SHMP2814S | 13.72
SNAPLOCK PIP | 16X5 FT 26GA SNLK RND PIPE | [NAME] | 17.36
RETURN AIR BOXES | 10X10X3-1/2 RTN AIR BX F/GLS TOP | SHMRABFGT1010N | 5.97
RETURN AIR BOXES | 12X12X3-1/2 RTN AIR BX F/GLS TOP | SHMRABFGT1212N | 7.17
RETURN AIR BOXES | 14X14X3-1/2 RTN AIR BX F/GLS TOP | [NAME] | 8.94
RETURN AIR BOXES | 18X18X3-1/2 RTN AIR BX F/GLS TOP | SHMRABFGT1818N | 15.71
RETURN AIR BOXES | 24X18X4-1/2 RTN AIR BX R6 | SHMRABR62418R | 25.93
METAL REDUCERS | 4X3 26GA TPRD RED NO CRMP | SHMRNC26PM | 2.5
METAL REDUCERS | 6X4 26GA TPRD RED NO CRMP | SHMRNC26UP | 2.52
METAL REDUCERS | 7X6 26GA TPRD RED NO CRMP | SHMRNC26WU | 3.38
METAL REDUCERS | 8X6 26GA TPRD RED NO CRMP | SHMRNC26XU | 2.93
METAL REDUCERS | 8X7 26GA TPRD RED NO CRMP | SHMRNC26XW | 2.93
METAL REDUCERS | 12X10 26GA TPRD RED NO CRMP | SHMRNC261210 | 3.47
METAL REDUCERS | 14X12 26GA TPRD RED NO CRMP | SHMRNC261412 | 5.2
METAL REDUCERS | 16X14 26GA TPRD RED NO CRMP | SHMRNC261614 | 6.82
COLLARS | 4 DB COLL SNAP TAB | SHMCSTDBP | 0.53
COLLARS | 5 DB COLL SNAP TAB | SHMCSTDBS | 0.62
COLLARS | 6 DB COLL SNAP TAB | SHMCSTDBU | 0.62
COLLARS | 7 DB COLL SNAP TAB | SHMCSTDBW | 0.8
COLLARS | 8 DB COLL SNAP TAB | SHMCSTDBX | 0.88
COLLARS | 9 DB COLL SNAP TAB | SHMCSTDBY | 1
COLLARS | 10 DB COLL SNAP TAB | SHMCSTDB10 | 1.08
COLLARS | 12 DB COLL SNAP TAB | SHMCSTDB12 | 1.37
COLLARS | 14 DB COLL SNAP TAB | SHMCSTDB14 | 1.6
COLLARS | 16 DB COLL SNAP TAB | SHMCSTDB16 | 1.74
COLLARS | 18 DB COLL SNAP TAB | SHMCSTDB18 | 2.12
DAMPERS | 4 DMPR W/ 1 HDWR | SHMD1HP | 1.64
DAMPERS | 5 DMPR W/ 1 HDWR | SHMD1HS | 1.64
DAMPERS | 6 DMPR W/ 1 HDWR | SHMD1HU | 1.93
DAMPERS | 7 DMPR W/ 1 HDWR | SHMD1HW | 2.05
DAMPERS | 8 DMPR W/ 1 HDWR | SHMD1HX | 2.26
DAMPERS | 10 DMPR W/ 1 HDWR | SHMD1H10 | 2.55
DAMPERS | 12 DMPR W/ 1 HDWR SPRG LOADED | SHMD1HS12 | 3.28
DAMPERS | 14 DMPR W/ 1 HDWR SPRG LOADED | SHMD1HS14 | 3.72
DAMPERS | 16 DMPR W/ 1 HDWR SPRG LOADED | SHMD1HS16 | 4.25
CANS | 6X6 FLGD INSL BX R6 W/ GSKT 3-1/2 | R526R6G66 | 4.99
CANS | 8X4 INSL BX R6 W/ FLG GSKT *X | R526R6G84 | 5.07
CANS | 8X8 FLGD INSL BX R6 W/ GSKT 3-1/2 | R526R6G88 | 7.11
CANS | 10X6 INSL BX R6 W/ FLG GSKT *X | R526R6G106 | 5.94
CANS | 10X8 INSL BX R6 W/ FLG GSKT *X | R526R6G108 | 7.96
CANS | 12X8 FLGD INSL BX R6 W/ GSKT 3-1/2 | R526R6G128 | 7.52
CANS | 12X10 INSL BX R6 W/ FLG GSKT *X | R526R6G1210 | 7.85
CANS | 14X14 FLGD INSL BX R6 W/ GSKT 3-1/2 | R526R6G1414 | 11.43
CANS | 14X8 FLGD INSL BX R6 W/ GSKT 3-1/2 | R526R6G148 | 8.96
CANS | 16X16 FLGD INSL BX R6 W/ GSKT 3-1/2 | R526R6G1616 | 12.53
CANS | 18X18 FLGD INSL BX R6 W/ GSKT 3-1/2 | R526R6G1818 | 13
AIR HANDLER STANDS | 18X22X19-30 ADJ AIR HDLR STND | SHMAAHS18221930 | 32.22
AIR HANDLER STANDS | 24X18 NAR STL HD ECON ADJ A/H BSE | MHEB24N | 33
AIR HANDLER STANDS | 36X36 NAR ULTRA HD ADJ A/H BSE | MUHB36N | 72.38
AIR HANDLER STANDS | 21X46X20 INSL CUBE STND W/ HOLE | SHMICSH214620 | 145.09
DUCTBOARD | 1X48X120 475 MICROAIRE DB BX | [NAME] | 31.5
DUCTBOARD | 1-1/2X48X120 800 MICROAIRE DB BX | J3264074 | 38
TAPE | 2-1/2X60 YD FOIL TAPE | A0800L | 11.65
MASTIC | 1G I/O DUCT SEAL WHIT CCW181 | HAR304144 | 13.57
[NAME] GRILL (1 WAY) | 6X6 ALUM ADJ CRVD BLD REG *X | [NAME] | 8.86
[NAME] GRILL (1 WAY) | 8X8 ALUM ADJ CRVD BLD REG *X | TA301HM8X8 | 10.23
[NAME] GRILL (1 WAY) | 8X4 ALUM ADJ CRVD BLD REG *X | TA301HMXP | 5.1
[NAME] GRILL (1 WAY) | 10X10 ALUM ADJ CRVD BLD REG *X | TA301HM1010 | 9.62
[NAME] GRILL (1 WAY) | 10X6 ALUM ADJ CRVD BLD REG *X | TA301HM10U | 6.36
[NAME] GRILL (1 WAY) | 10X8 ALUM ADJ CRVD BLD REG *X | TA301HM10X | 8.19
[NAME] GRILL (1 WAY) | 12X12 ALUM ADJ CRVD BLD REG *X | TA301HM1212 | 13.16
[NAME] GRILL (1 WAY) | 12X6 ALUM ADJ CRVD BLD REG *X | TA301HM12U | 7.07
[NAME] GRILL (1 WAY) | 12X8 ALUM ADJ CRVD BLD REG *X | TA301HM12X | 8.74
[NAME] GRILL (1 WAY) | 14X6 ALUM ADJ CRVD BLD REG *X | TA301HM14U | 9.24
[NAME] GRILL (1 WAY) | 14X8 ALUM ADJ CRVD BLD REG *X | TA301HM14X | 11.99
[NAME] GRILL (2 WAY) | 10X10 ALUM ADJ CRVD BLD REG *X | TA302M1010 | 9.48
[NAME] GRILL (2 WAY) | 10X6 ALUM ADJ CRVD BLD REG *X | TA302M10U | 6.94
[NAME] GRILL (2 WAY) | 12X12 ALUM ADJ CRVD BLD REG *X | [NAME] | 13.25
[NAME] GRILL (2 WAY) | 12X6 ALUM ADJ CRVD BLD REG *X | TA302M12U | 7.86
[NAME] GRILL (2 WAY) | 12X8 ALUM ADJ CRVD BLD REG *X | TA302M12X | 10.69
[NAME] GRILL (2 WAY) | 14X8 ALUM ADJ CRVD BLD REG *X | TA302M14X | 12.01
[NAME] (4 WAY) | 10X10 ALUM ADJ CRVD BLD REG *X | [NAME] | 13.53
[NAME] (4 WAY) | 12X12 ALUM ADJ CRVD BLD REG *X | TA304M1212 | 16.55
[NAME] (4 WAY) | 14X14 ALUM ADJ CRVD BLD REG *X | TA304M1414 | 18.72
FILTER BACK R/A | 10X10 STAMP RTN AIR FLTR GRL *X | T190RF1010 | 8.88
FILTER BACK R/A | 12X12 STAMP RTN AIR FLTR GRL *X | T190RF1212 | 7.97
FILTER BACK R/A | 12X24 STAMP RTN AIR FLTR GRL *X | T190RF1224 | 14.39
FILTER BACK R/A | 14X14 STAMP RTN AIR FLTR GRL *X | T190RF1414 | 11.09
FILTER BACK R/A | 16X16 STAMP RTN AIR FLTR GRL *X | T190RF1616 | 13.68
FILTER BACK R/A | 18X18 STAMP RTN AIR FLTR GRL *X | T190RF1818 | 16.61
FILTER BACK R/A | 18X24 STAMP RTN AIR FLTR GRL *X | T190RF1824 | 20.62
FILTER BACK R/A | 20X20 STAMP RTN AIR FLTR GRL *X | T190RF2020 | 15.77
FILTER BACK R/A | 20X25 STAMP RTN AIR FLTR GRL *X | T190RF2025 | 21.27
FILTER BACK R/A | 24X12 STAMP RTN AIR FLTR GRL *X | T190RF2412 | 13.58
FILTER BACK R/A | 24X18 STAMP RTN AIR FLTR GRL *X | T190RF2418 | 15.41
FILTER BACK R/A | 30X18 STAMP RTN AIR FLTR GRL *X | T190RF3018 | 22.31
FILTER BACK R/A | 08X04 STAMP RTN GRL | [NAME] | 1.76
FILTER BACK R/A | 10X6 STAMP RTN GRL | T17010X06 | 1.91
FILTER BACK R/A | 10X10 STAMP RTN GRL | T17010X10 | 3.32
FILTER BACK R/A | 12X08 STAMP RTN GRL | T17012X08 | 2.95
FILTER BACK R/A | 12X12 STAMP RTN GRL | T17012X12 | 3.89
FILTER BACK R/A | 14X14 STAMP RTN GRL | T17014X14 | 5.31
FILTER BACK R/A | 16X16 STAMP RTN GRL | T17016X16 | 7.13
FILTER BACK R/A | 18X18 STAMP RTN GRL | T17018X18 | 9.66
PADS | 30X30X CLADLITE HURRICANE PAD | DIVHT30304 | 49.24
PADS | *CVR* CLADLITE HURRICANE PAD 32X32X | DIVHT32324 | 55.87
PADS | 36X36X4 HURRICANE T-CLASS PAD | DIVHT36364 | 67.83
PADS | 40X40X4 HURRICANE T-CLASS PAD | DIVHT40404 | 84.92
INSULATION | 3/8 X1/2 WALL RBR PIPE INSUL | JI61038 | 2.7
INSULATION | 7/8 ID X 1/2 UNSLIT INSUL TUBE | JI61078 | 3.86
INSULATION | 1-1/8 ID X 1/2 UNSLIT INSUL TUBE | JI61118 | 3.11
INSULATION | 2703/4X1/2 WALL PIPE INSUL DBL SEAL | JI81034 | 6.69
INSULATION | 7/8X1/2 SPLT PIPE INSUL W/ OVRLAP | JI81078 | 7.95
INSULATION | 1-1/8X1/2 DBL SEAL RUB INSUL | JI81118 | 7.95