Spreadsheet: 57334d1257438454-creating-conditional-drop-down-boxes-and-then-searching-for-selections-example
Sheet: 1000-1 CT

1
9 |  | Base |  | NEMA | FLA | Motor | with | with 50% | with 50% brake | with 100% | with 100% brake | with 140% | with 140% brake
10 | HP | RPM | Encl. | Frame | 460 | Only | encoder | brake | and encoder | brake | and encoder | brake | and encoder
11 | 1 | 1800 | TENV | 143TC | 1.5 | xx | xx | xx | xx | xx | xx | xx | xx
12 |  | 1200 | TENV | 145TC | 1.7 | xx | xx | xx | xx | xx | xx | xx | xx
13 |  | 900 | TENV | 184TC | 2.5 | xx | xx | xx | xx | xx | xx | xx | xx
14 | 1.5 | 1800 | TENV | 145TC | 2.3 | xx | xx | xx | xx | xx | xx | xx | xx
15 |  | 1200 | TENV | 184TC | 2.2 | xx | xx | xx | xx | xx | xx | xx | xx
16 |  | 900 | TENV | 213TC | 3.6 | xx | xx | xx | xx | xx | xx | xx | xx
17 | 2 | 1800 | TENV | 145TC | 3 | xx | xx | xx | xx | xx | xx | xx | xx
18 |  | 1200 | TENV | 184TC | 3 | xx | xx | xx | xx | xx | xx | xx | xx
19 |  | 900 | TENV | 213TC | 3.8 | xx | xx | xx | xx | xx | xx | xx | xx
20 | 3 | 1800 | TENV | 182TC | 4 | xx | xx | xx | xx | xx | xx | xx | xx
21 |  | 1200 | TENV | 213TC | 4.5 | xx | xx | xx | xx | xx | xx | xx | xx
22 |  | 900 | TENV | 254TC | 4.6 | xx | xx | xx | xx | xx | xx | xx | xx
23 | 5 | 1800 | TENV | 184TC | 6.7 | xx | xx | xx | xx | xx | xx | xx | xx
24 |  | 1200 | TENV | 215TC | 7 | xx | xx | xx | xx | xx | xx | xx | xx
25 |  | 900 | TENV | 256TC | 7.6 | xx | xx | xx | xx | xx | xx | xx | xx
26 | 7.5 | 1800 | TENV | 213TC | 10.5 | xx | xx | xx | xx | xx | xx | xx | xx
27 |  | 1200 | TENV | 254TC | 12 | xx | xx | xx | xx | xx | xx | xx | xx
28 |  | 900 | TENV | 284T | 11 | xx | xx | xx | xx | xx | xx | xx | xx
29 | 10 | 1800 | TENV | 215T | 13 | xx | xx | xx | xx | xx | xx | xx | xx
30 |  | 1200 | TENV | 256TC | 15.5 | xx | xx | xx | xx | xx | xx | xx | xx
31 |  | 900 | TEBC | 284T | 15.5 | xx | xx | xx | xx | xx | xx | xx | xx
32 | 15 | 1800 | TENV | 254TC | 20.2 | xx | xx | xx | xx | xx | xx | xx | xx
33 |  | 1200 | TENV | 284TC | 20.4 | xx | xx | xx | xx | xx | xx | xx | xx
34 |  | 900 | TEBC | 286T | 22 | xx | xx | xx | xx | xx | xx | xx | xx
35 | 20 | 1800 | TENV | 256TC | 26 | xx | xx | xx | xx | xx | xx | xx | xx
36 |  | 1200 | TEBC | 286T | 27 | xx | xx | xx | xx | xx | xx | xx | xx
37 |  | 1200 | TENV | 326T | 29.5 | xx | xx | xx | xx | xx | xx | xx | xx
38 |  | 900 | TEBC | 324T | 32 | xx | xx | xx | xx | xx | xx | xx | xx
39 | 25 | 1800 | TEBC | 284T | 31.5 | xx | xx | xx | xx | xx | xx | xx | xx
40 |  | 1800 | TENV | 284TC | 31 | xx | xx | xx | xx | xx | xx | xx | xx
41 |  | 1200 | TEBC | 324T | 33 | xx | xx | xx | xx | xx | xx | xx | xx
42 |  | 1200 | TENV | 364T | 31 | xx | xx | xx | xx | xx | xx | xx | xx
43 |  | 900 | TEBC | 326T | 35.5 | xx | xx | xx | xx | xx | xx | xx | xx
44 | 30 | 1800 | TEBC | 286T | 38.5 | xx | xx | xx | xx | xx | xx | xx | xx
45 |  | 1800 | TENV | 326TC | 40 | xx | xx | xx | xx | xx | xx | xx | xx
46 |  | 1200 | TEBC | 326T | 41 | xx | xx | xx | xx | xx | xx | xx | xx
47 |  | 1200 | TENV | 365T | 42 | xx | xx | xx | xx | xx | xx | xx | xx
48 |  | 900 | TEBC | 364T | 44 | xx | xx | xx | xx | xx | xx | xx | xx
49 | 40 | 1800 | TEBC | 324T | 50 | xx | xx | xx | xx | xx | xx | xx | xx
50 |  | 1800 | TENV | 364T | 48 | xx | xx | xx | xx | xx | xx | xx | xx
51 |  | 1200 | TEBC | 364T | 52 | xx | xx | xx | xx | xx | xx | xx | xx
52 |  | 1200 | TENV | 405T | 48.5 | xx | xx | xx | xx | xx | xx | xx | xx
53 |  | 900 | TEBC | 365T | 56 | xx | xx | xx | xx | xx | xx | xx | xx
54 | 50 | 1800 | TEBC | 326T | 60.5 | xx | xx | xx | xx | xx | xx | xx | xx
55 |  | 1800 | TENV | 367T | 59.5 | xx | xx | xx | xx | xx | xx | xx | xx
56 |  | 1200 | TEBC | 365T | 62 | xx | xx | xx | xx | xx | xx | xx | xx
57 |  | 1200 | TENV | 444T | 61.5 | xx | xx | xx | xx | xx | xx | xx | xx
58 |  | 900 | TEBC | 404T | 69 | xx | xx | xx | xx | xx | xx | xx | xx
59 | 60 | 1800 | TEBC | 364T | 74 | xx | xx | xx | xx | xx | xx | xx | xx
60 |  | 1800 | TENV | 405T | 68 | xx | xx | xx | xx | xx | xx | xx | xx
61 |  | 1200 | TEBC | 404T | 71 | xx | xx | xx | xx | xx | xx | xx | xx
62 |  | 1200 | TENV | 445T | 73 | xx | xx | xx | xx | xx | xx | xx | xx
63 |  | 900 | TEBC | 405T | 80 | xx | xx | xx | xx | xx | xx | xx | xx
64 | 75 | 1800 | TEBC | 365T | 92 | xx | xx | xx | xx | xx | xx | xx | xx
65 |  | 1800 | TENV | 444T | 87 | xx | xx | xx | xx | xx | xx | xx | xx
66 |  | 1200 | TEBC | 405T | 95 | xx | xx | xx | xx | xx | xx | xx | xx
67 |  | 1200 | TENV | 445T | 105 | xx | xx | xx | xx | xx | xx | xx | xx
68 |  | 900 | TEBC | 444T | 107 | xx | xx | xx | xx | xx | xx | xx | xx
69 | 100 | 1800 | TEBC | 405T | 115 | xx | xx | xx | xx | xx | xx | xx | xx
70 |  | 1800 | TENV | 445T | 110 | xx | xx | xx | xx | xx | xx | xx | xx
71 |  | 1200 | TEBC | 444T | 125 | xx | xx | xx | xx | xx | xx | xx | xx
72 |  | 1200 | TENV | 449T | 124 | xx | xx | xx | xx | xx | xx | xx | xx
73 |  | 900 | TEBC | 445T | 142 | xx | xx | xx | xx | xx | xx | xx | xx
74 | 125 | 1800 | TEBC | 444T | 143 | xx | xx | xx | xx | xx | xx | xx | xx
75 |  | 1800 | TENV | 445T | 158 | xx | xx | xx | xx | xx | xx | xx | xx
76 |  | 1200 | TEBC | 445T | 153 | xx | xx | xx | xx | xx | xx | xx | xx
77 |  | 1200 | TENV | 449T | 154 | xx | xx | xx | xx | xx | xx | xx | xx
78 |  | 900 | TEBC | 445T | 172 | xx | xx | xx | xx | xx | xx | xx | xx
79 | 150 | 1800 | TEBC | 445T | 170 | xx | xx | xx | xx | xx | xx | xx | xx
80 |  | 1800 | TENV | 449T | 173 | xx | xx | xx | xx | xx | xx | xx | xx
81 |  | 1200 | TEBC | 445T | 186 | xx | xx | xx | xx | xx | xx | xx | xx
82 |  | 1200 | TENV | 449T | 205 | xx | xx | xx | xx | xx | xx | xx | xx
83 |  | 900 | TEBC | 449T | 218 | xx | xx | xx | xx | xx | xx | xx | xx
84 | 200 | 1800 | TEBC | 445T | 230 | xx | xx | xx | xx | xx | xx | xx | xx
85 |  | 1800 | TENV | L449T | 260 | xx | xx | xx | xx | xx | xx | xx | xx
86 |  | 1200 | TEBC | 449T | 240 | xx | xx | xx | xx | xx | xx | xx | xx
87 |  | 900 | TEBC | 449T | 275 | xx | xx | xx | xx | xx | xx | xx | xx
88 | 250 | 1800 | TEBC | 449T | 295 | xx | xx | xx | xx | xx | xx | xx | xx
89 |  | 1200 | TEBC | 449T | 302 | xx | xx | xx | xx | xx | xx | xx | xx
90 |  | 900 | TEBC | 5011 | 340 | xx | xx | xx | xx | xx | xx | xx | xx
91 | 300 | 1800 | TEBC | 449T | 327 | xx | xx | xx | xx | xx | xx | xx | xx
92 |  | 1200 | TEBC | 449T | 362 | xx | xx | xx | xx | xx | xx | xx | xx
93 |  | 900 | TEBC | 5013 | 420 | xx | xx | xx | xx | xx | xx | xx | xx
94 | 350 | 1800 | TEBC | 449T | 386 | xx | xx | xx | xx | xx | xx | xx | xx
95 |  | 1200 | TEBC | 5011 | 415 | xx | xx | xx | xx | xx | xx | xx | xx
96 |  | 900 | TEBC | 5013 | 458 | xx | xx | xx | xx | xx | xx | xx | xx
97 | 400 | 1800 | TEBC | 449T | 450 | xx | xx | xx | xx | xx | xx | xx | xx
98 |  | 1200 | TEBC | 5011 | 485 | xx | xx | xx | xx | xx | xx | xx | xx
99 |  | 900 | TEBC | 5013 | 522 | xx | xx | xx | xx | xx | xx | xx | xx
100 | 450 | 1800 | TEBC | 5011 | 510 | xx | xx | xx | xx | xx | xx | xx | xx
101 |  | 1200 | TEBC | 5011 | 522 | xx | xx | xx | xx | xx | xx | xx | xx
102 | 500 | 1800 | TEBC | 5011 | 570 | xx | xx | xx | xx | xx | xx | xx | xx
103 |  | 1200 | TEBC | 5013 | 590 | xx | xx | xx | xx | xx | xx | xx | xx
104 | 600 | 1800 | TEBC | 5013 | 660 | xx | xx | xx | xx | xx | xx | xx | xx
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198