Spreadsheet: 85593d1285683365-help-with-dependant-drop-downs-test
Sheet: Part Listing

Description | ItemNum | Category
1 STACK Sequencer | SEQ--1ST | Ignitors / Sequencers
1/2 LONG DP SCREWS" | BT8121000 | DRILL POINT SCREWS
1/2 WOOD SCREWS" | 2427531067 | Nails, Screws, Etc..
1/4 COPPER PIPING ([NAME])" | 55 | COPPER PIPING
1/4 COUPLINGS" | 61 | COPPER PIPING
10 MFD -  440 VAC | CAP10MFD | Capacitors
115 VAC BLOWER MOTOR | 5460 | Rescue Motors
12 x 12" FILTER GRILLE" | 2427531015 | MISC. OTHER EQUIPMENT
12.5 MFD | CAP12.5MFD | Capacitors
135 MFD - 330 V START CAPACITOR W/RESISTOR | SCAP135 | [NAME]
14 R-8 Foil Flex" | 2427531095 | Foil Flex
1-Pole 24 VAC - 30 Amp | 2427531000 | Contactors
1-Pole 24 VAC - 40 Amp | 2425837700 | Contactors
2 STACK Sequencer | SEQ--2ST | Ignitors / Sequencers
20 +4 MFD - 440 V W/RESISTOR | SCAP20MFD | [NAME]
20 AMP DBL POLE/THROW | 2427531071 | [NAME]
20 AMP SING MURRAY | 2427531058 | [NAME]
20 MFD - 440 VAC | CAP20MFD | Capacitors
230 VAC BLOWER MOTOR | 5451 | Rescue Motors
230 VOLT COIL (specialty) | RLY-230V | Relays
24 THERMOCOUPLE" | 34 | Thermocouples
24 VOLT COIL (BLACK) | RLY-BLK | Relays
24 VOLT COIL (BROWN) | RLY-BRN | Relays
25 +5 MFD CAP | DLCAP25+5 | Capacitors
25 MFD - 440 VAC | CAP25MFD | Capacitors
2-POLE- 24 V | 8910DP42V14 | Contactors
2-STAGE OEM VALVE | 30 | Gas Valves
3 AMP FUSES (5 COUNT) | 2427531003 | MISC. OTHER EQUIPMENT
3 pump ups (4)" | 2427531068 | Pump Ups/Legs
3 WOOD SCREWS" | 2427531066 | MISC. OTHER EQUIPMENT
3/4 & 7/8"  (ID) INSULATION TUBING" | 2427531011 | INSULATION TUBING
3/4 COPPER COUPLINGS" | 3P105 | COPPER PIPING
3/4 COPPER ELBOWS" | 3P205 | COPPER PIPING
3/4 COPPER PIPING ([NAME].)" | 59 | COPPER PIPING
3/4 LONG RADIUS" | 70 | COPPER PIPING
3/4 LONG" | 73 | 1/4 HEAD SIZE DRILL POINT SCREWS"
3/4 LONG" | 75 | 5/16 HEAD SIZE DRILL POINT SCREWS"
3/4 TO 7/8"" | 68 | COPPER PIPING
3/8 COPPER COUPLINGS" | 3P102 | COPPER PIPING
3/8 COPPER PIPING ([NAME].)" | 57 | COPPER PIPING
30 +5 MFD - 440 VAC DUAL | DLCAP30+5 | Capacitors
30 AMP DBL POLE/THROW | 2427531072 | [NAME]
30 AMP DOUBLE POLE MURRAY | 2427531052 | [NAME]
30 AMP DOUBLE POLE SIEMANS | 2427531054 | [NAME]
30 MFD - 440 VAC | CAP30MFD | Capacitors
30 THERMOCOUPLE" | 2427531022 | Thermocouples
35 +5 MFD - 440 VAC DUAL | 4JR0535 | Capacitors
35 +7.5 MFD - 370 V (CARRIER) | SCAP3575MFD | [NAME]
35 MFD - 370 VAC | SCAP35MFD | [NAME]
35 MFD - 440 VAC | CAP35MFD | Capacitors
35 MFD - 440 VAC (WITH RESISTOR) | SCAP35WR | [NAME]
35 VA TRANSFORMER | 2427531020 | Transformers
36 THERMOCOUPLE" | 35 | Thermocouples
36 TIES" | L36-175-9L | PLASTIC TIES
4 MFD - 370 VAC | CAP4MFD | Capacitors
40 +5 MFD - 440 VAC DUAL | 4JR0540 | Capacitors
40 AMP Double Pole Siemens | 2427531089 | [NAME]
40 MFD - 440 VAC | CAP40MFD | Capacitors
40 mfd 370 v | cap40mfd370 | Capacitors
40 VA TRANSFORMER Multi Tap | 2427531019 | Transformers
45 +5 MFD - 440 VAC DUAL | 4JR0545 | Capacitors
45 +7.5 MFD CAP | DLCAP4575 | Capacitors
45 MFD - 440 VAC | CAP45MFD | Capacitors
45+6 MFD | 2427531085 | Capacitors
48 PLASTIC STRAPS" | 2427531088 | Misc. Consumables
5 1/2 LEGS | 2427531073 | Pump Ups/Legs
5 COMBINATION FAN & LIMIT CONTROL SWITCH" | 2427531013 | Limits
5 KW RESTRING KIT | 2427531029 | MISC. OTHER EQUIPMENT
5 MFD - 440 VAC | CAP5MFD | Capacitors
5/16 COPPER COUPLINGS" | 3P101 | COPPER PIPING
5/16 COPPER PIPING ([NAME].)" | 56 | COPPER PIPING
5/16 TO 3/8"" | 3P121 | COPPER PIPING
5/8 COPPER COUPLINGS" | 3P104 | COPPER PIPING
5/8 COPPER ELBOWS" | 3P204 | COPPER PIPING
5/8 COPPER PIPING" | 58 | COPPER PIPING
50 AMP DOUBLE POLE CUT HAM | 2427531053 | [NAME]
50 AMP DOUBLE POLE GE | 2427531050 | [NAME]
50 AMP DOUBLE POLE SIEMENS | 2427531056 | [NAME]
55 +5 MFD - 440 VAC | 4JR0555 | Capacitors
55 MFD - 440 VAC | CAP55MFD | Capacitors
6 FT. 1/2 WHIP" | 39 | Electrical Whip
6 FT. 3/4 WHIP" | 40 | Electrical Whip
60 + 12.5 MFD - 440 V | SCAP60MFD | [NAME]
60 AMP DOUBLE POLE SIEMENS | 2427531051 | [NAME]
60 AMP SQUARE D DBL | 2427531057 | [NAME]
7.5 MFD - 370 VAC | 2427531093 | Capacitors
7.5 MFD - 440 VAC | CAP7.5MFD | Capacitors
7/8 COPPER COUPLINGS" | 3P106 | COPPER PIPING
7/8 Copper Elbow" | 3P206 | COPPER PIPING
7/8 COPPER PIPING ([NAME].)" | 60 | COPPER PIPING
7/8 LONG RADIUS" | 71 | COPPER PIPING
75 VA 230 V Transformer | 2427531090 | Transformers
75 VA TRANSFORMER | 2427531032 | Transformers
8 COMBINATION FAN & LIMIT CONTROL SWITCH" | 2427531014 | Limits
90 amp double pole | 2427531092 | [NAME]
A/C-3/8 SWEAT | 127 | LIQUID LINE DRIER
Acid Away | 2427531008 | SOLVENTS
Acid Test | 2427531009 | SOLVENTS
ANOMETER-AIR FLOW | 124 | COMPANY EQUIPMENT
BACK SUPPORT | 108 | SAFETY EQUIPMENT
BELLY BAND | MTR-BB | Rescue Motors
BIG BLUE (WIRE NUTS) | 81 | WIRE NUTS
BIG GRAY (WIRE NUTS) | 82 | WIRE NUTS
Black spray paint | 2427531036 | Misc. Consumables
Blk Pip Union 1/2",0.00" | 2427531096 | Black Iron
BLUE ANCHORS | 97 | ANCHORS
BOOTIES-Orange | SB-O-01B | SAFETY EQUIPMENT
BUBBLE SOLUTION/GAS | 800-002 | SOLVENTS
CARRIER CIRCUIT BOARD | HH84AA020 | Circuit Boards
CARRIER DEFROST BOARD | HK32FA006 | Circuit Boards
CARRIER FURNACE CONTROL BOARD | 695-100 | Circuit Boards
CO DETECTOR | 2427531069 | COMPANY EQUIPMENT
Coil Cleaner | 2427531038 | SOLVENTS
COMPRESSOR WIRES (KIT) | THRM-LOK | MISC. OTHER EQUIPMENT
Concrete Caulking | 2427531040 | Misc. Consumables
cONDENSATE DEVICE EZ TRAP 110 | ezt-110
CONDENSER MOTOR | MTR-CNDSR | Rescue Motors
[NAME] | 2427531042 | Misc. Consumables
COPPER ELBOWS | 69 | COPPER PIPING
CORK TAPE | 96 | TAPE
Defrost Relay | RLY-DEF | Relays
DEFROST T-STAT | 2427531006 | Thermostats
DELAY ON BREAK TIMER | 2427531017 | MISC. OTHER EQUIPMENT
DELAY ON MAKE TIMER | 2427531018 | MISC. OTHER EQUIPMENT
[NAME] by Technician | 117 TO | COMPANY EQUIPMENT
DUAL 2 STACK SEQUENCER | SEQ--DL2ST | Ignitors / Sequencers
DYE SCANNER | 122 | COMPANY EQUIPMENT
DYE TUBES | 123 | Misc. Consumables
ELECTRICAL TAPE | 95 | TAPE
ELECTRONIC SCALE | ADS-100 | COMPANY EQUIPMENT
EXPAND-A-FOAM | 1714 | SOLVENTS
EZ TRAP 210 | EZT-210 | CONDENSATE SAFETY
EZ TRAP 626 | EZT-626 | CONDENSATE SAFETY
FAN MOTOR OIL | 87 | SOLVENTS
FINISHING NAILS | 2427531064 | Nails, Screws, Etc..
FIRE EXTINGUISHER | 102 | SAFETY EQUIPMENT
FIRST AID KIT | 103 | SAFETY EQUIPMENT
FIVE CONDUCTOR WIRE | 100 | THERMOSTAT WIRE
FLAME SENSOR | 2427531030 | Sensors
FLEX GAS CONNECTOR (NAT) | 2427531028 | MISC. OTHER EQUIPMENT
FLOAT SWITCH | 2427531086 | CONDENSATE SAFETY
Furnace Circuit Board w/Harness | 2427531100 | Circuit Boards
Fuse: Link Assembly | 2427531084 | MISC. OTHER EQUIPMENT
Gas Valve, 2 stage, 24 Volt | VAL08237 | Gas Valves
GENERIC (LIMIT) | 33 | Limits
GENERIC BOARD | WW28X0329 | Circuit Boards
GENERIC DEFROST CIRCUIT BOARD | 25 | Circuit Boards
GLOVES | 104 | SAFETY EQUIPMENT
[NAME] | 2427531033 | Ignitors / Sequencers
HAMMER DRILLS | 116 | COMPANY EQUIPMENT
[NAME] - Owned By Technician | 116 TO | COMPANY EQUIPMENT
HAND WIPES BUCKET | 2427531063 | Misc. Consumables
HARD START [NAME] | KIT-HS #6 | Capacitors
HARD START KIT SSP#8 | KIT-HS #8 | Capacitors
Heat Element Replacement | 2427531034 | MISC. OTHER EQUIPMENT
HEAT SINK COMPOUND | 2427531061 | Misc. Consumables
HIGH (LIMIT) | 31 | Limits
HOLE DRILL BITS-2.5",0.00" | 117 | COMPANY EQUIPMENT
HONEYWELL FOCUSPRO 5000 NON-PROGRAMMABLE (UNIVERSAL) | TH5220D1003 | Thermostats
HONEYWELL HSI | 2427531065 | HSI
HONEYWELL INTERMITTENT PILOT | VR8204A2076 | Gas Valves
HONEYWELL PROGRAMMABLE 6000 | TH6000HW | Thermostats
HONEYWELL SMART VALVE | HNYSV | Gas Valves
HONEYWELL VISIONPRO 8000 PROGRAMMABLE (UNIVERSAL) | TH832001008 | Thermostats
Hot Surface Ignitor | 2427531070 | HSI
HP BIFLOW-3/8 SWEAT | 126 | LIQUID LINE DRIER
HSI GAS VALVE | 2427531021 | Gas Valves
HSI MODULE (UNIVERSAL) | S8910U1000 | Ignition Modules
HSI VALVE (HONEYWELL) | VR8305M-3506 | Gas Valves
ICM FAN CONTROL BOARD FOR V/S | CNT01866 | Circuit Boards
ICP Run Capacitor - Lennox OEM 7.5+50 370V | 2427531097 | [NAME]
INDOOR/OUTDOOR - 60 AMP DISCONNECT BOX | 755-60NF | Disconnect Boxes
INTERMITTENT PILOT GAS VALVE | 2427531047 | Gas Valves
ISOLATOR PADS | 128 | MISC. OTHER EQUIPMENT
JANITROL (F) BOARD | GMP075-3 | Circuit Boards
JANITROL HSI | 2427531060 | HSI
KICK START POTENTIAL RELAY & START CAPACITORS | 2427531101 | CAPACITOR
KIT TO INSTALL VAL08237 | [NAME] | MISC
KNEE PADS | 107 | SAFETY EQUIPMENT
[NAME] | 118 | COMPANY EQUIPMENT
LENNOX BOARD FOR HP 19/22/24 | 85H75 | Circuit Boards
LIQUID WRENCH | 86 | SOLVENTS
[NAME] by Technician | 125 TO | COMPANY EQUIPMENT
MAGNEHELIC GUAGE-AIR FLOW | 125 | COMPANY EQUIPMENT
MARS HSI | 2427531059 | HSI
MASTIC | 2427531031 | MISC. OTHER EQUIPMENT
MASTIC BRUSH | 2427531062 | Misc. Consumables
MASTIC TAPE (3)" | SF-686 | TAPE
METAL SERVICE DISCONNECT | 2427531078 | Disconnect Boxes
METAL TAPE | 488S | TAPE
[NAME]. [NAME] | 2427531035 | Thermostats
MOTO7968 1/3 HP, 208-230V/60/1, 1075 RPM 2.7 FLA, 3 SPD | 2427531094 | Rescue Motors
NCI CO MONITOR | 2427531005 | SAFETY EQUIPMENT
NYLON SUPPORT STRAP | 2427531010 | MISC. OTHER EQUIPMENT
ORANGE (WIRE NUTS) | 623-003 | WIRE NUTS
PAN SWITCH--AQUA GUARD | 2427531001 | CONDENSATE SAFETY
PAN SWITCH--LITTLE GIANT | 2427531002 | CONDENSATE SAFETY
PIPE DOPE | 31231 | SOLVENTS
PLUMBERS TAPE/METAL STRAP | 2427531048 | TAPE
PVC - 3/4 COUPLINGS" | 2427531076 | PVC Fittings
PVC - 3/4 TEES" | 2427531075 | PVC Fittings
PVC  THREADED PLUG | 2427531083 | PVC Fittings
PVC-45s | 1P387 | PVC Fittings
PVC-90 Elbow | 2427531074 | PVC Fittings
PVC-CAP | 2427531023 | PVC Fittings
PVC-COUPLINGS | 1P340 | PVC Fittings
PVC-ELBOWS | 1P344 | PVC Fittings
PVC-GLUE | 47 | PVC Fittings
PVC-PRIMER | 48 | PVC Fittings
PVC-P-TRAP | 1P408 | PVC Fittings
PVC-RUNNING TRAP | 2427531024 | PVC Fittings
PVC-STICKS (10') | 1P003 | PVC Fittings
PVC-STREET EL | 2427531025 | PVC Fittings
PVC-TEES | 1P349 | PVC Fittings
PVC-THREAD CAP | 2427531027 | PVC Fittings
PVC-THREAD STREET EL (DISCONTINUING THIS ITEM) | 2427531026 | PVC Fittings
PVC-THREADED FEMALE ADAPTERS | 1P341 | PVC Fittings
PVC-THREADED MALE ADAPTERS | 1P342 | PVC Fittings
R-22 | 109 | REFRIGERANT
R-410A | 110 | REFRIGERANT
RECOVERY MACHINE | 112 | COMPANY EQUIPMENT
RECOVERY MACHINE DRIER | DHY00816 | MISC. OTHER EQUIPMENT
Recovery Tank - 410A | 2427531091 | COMPANY EQUIPMENT
RECOVERY TANK - R22 | 113 | COMPANY EQUIPMENT
RED (WIRE NUTS) | 80 | WIRE NUTS
RED ANCHORS | 98 | ANCHORS
Regulator | 2427531098 | MISC
RENTAL PROPERTY TSTAT (USED) | STAT-RENT | Thermostats
REP. INTERMITTENT PILOT MODULE | S8610U1003 | Ignition Modules
ROBERT SHAW 1HEAT/1COOL | 9701 | Thermostats
ROBERT SHAW BLOWER CONTROL / DEFROST CONTROL BOARD (TRANE ?) | 0231-0712 | Circuit Boards
[NAME] GAS/ELEC | 9515 | Thermostats
[NAME] | 9520 | Thermostats
ROBERT SHAW PROG./DIG. (use w/9020-I) | 9720 | Thermostats
[NAME] REMOTE ROOM SENSOR (use w/9720) | 9020-I | Thermostats
ROLL-OUT (LIMIT) | 32 | Limits
RX11 Flush | 2427531041 | SOLVENTS
SAFETY BOOKLET | 106 | SAFETY EQUIPMENT
SAFETY GOGGLES | 101 | SAFETY EQUIPMENT
SAWSALL | 115 | COMPANY EQUIPMENT
Sawsall - owned by technician | 115 TO | COMPANY EQUIPMENT
SILFOS 15 BRAZING ROD | 2427531016 | MISC. OTHER EQUIPMENT
SILICON CAULKING/HIGH TEMP. | PT301ER | Misc. Consumables
SILICONE CAULKING/CLEAR | PT301C | Misc. Consumables
SILICONE CAULKING/WHITE | PT301W | SOLVENTS
SIMPLE COMFORT 2300 (NOT HP) 2HEAT/2COOL | SC2300STAT | Thermostats
SMALL BLUE/GRAY (WIRE NUTS) | 623-002 | WIRE NUTS
SMART VALVE (HONEYWELL) | HNYWL SV | Gas Valves
SOS | 2427531087 | CONDENSATE SAFETY
Splice Box | 2427531043 | MISC. OTHER EQUIPMENT
SPLICE BOX COVER | 2427531045 | MISC. OTHER EQUIPMENT
[NAME] CONNECTOR | 2427531044 | MISC. OTHER EQUIPMENT
[NAME] | 2427531039 | Misc. Consumables
SQUARE D BREAKER SWITCH | 2427531055 | [NAME]
STANDING PILOT VALVE | 27 | Gas Valves
TEN CONDUCTOR WIRE | 99 | THERMOSTAT WIRE
TORCHES | 121 | COMPANY EQUIPMENT
TOTAL LINE PROG. TOUCH SCREEN 2HEAT / 1COOL | TLSTAT2H1C | Thermostats
TRANE DEFROST BOARD | [NAME] | Circuit Boards
TRANE H/C MERCURY STAT | STAT-MERC | Thermostats
Trane Relay w/Circuit Brd. | RLY02257 | Relays
TRANE START KIT | BAYKSKT250 | 1/4 HEAD SIZE DRILL POINT SCREWS"
UNIVERSAL IGNITION MODULE | 36 | Ignition Modules
VACUUM GUAGE | 114 | COMPANY EQUIPMENT
[NAME] by Technician | 114TO | COMPANY EQUIPMENT
VACUUM PUMP | 111 | COMPANY EQUIPMENT
VACUUM PUMP OIL | 2427531046 | SOLVENTS
VARIETY (SHORT: 6-10)" | 84 | PLASTIC TIES
Vent Protector for Regulator | 2427531099 | MISC
WAGNER (OPEN AT 170)  Limit - Furnace | 2427531007 | Limits
WASP SPRAY | 89 | Misc. Consumables
Wax | 2427531037 | Misc. Consumables
WD-40 | 85 | SOLVENTS
WHITE RODGERS CIRCUIT BOARD | 50T35-730 | Circuit Boards
YELLOW (WIRE NUTS) | 79 | WIRE NUTS
YELLOW ANCHORS | 7101CX | ANCHORS