Spreadsheet: 58311d1258578159-creating-conditional-drop-down-boxes-and-then-searching-for-selections-book1
Sheet: Drop Down Menus

 | Type of Motor
 | 1000-1 CT
 | 10-1 CT
 | Wide CHP
 | Variable Torque
 | Fixed Speed
 | XP Variable Speed
 | HP
 | 1000-1 CT | 10-1 CT | Wide CHP | Variable Torque | Fixed Speed | XP Variable Speed
 | 1 | 1 | 5 | 1 | 1 | 1
 | 1.5 | 1.5 | 7.5 | 1.5 | 1.5 | 1.5
 | 2 | 2 | 10 | 2 | 2 | 2
 | 3 | 3 | 15 | 3 | 3 | 3
 | 5 | 5 | 20 | 5 | 5 | 5
 | 7.5 | 7.5 | 25 | 7.5 | 7.5 | 7.5
 | 10 | 10 | 30 | 10 | 10 | 10
 | 15 | 15 | 40 | 15 | 15 | 15
 | 20 | 20 | 50 | 20 | 20 | 20
 | 25 | 25 | 60 | 25 | 25 | 25
 | 30 | 30 | 75 | 30 | 30 | 30
 | 40 | 40 | 100 | 40 | 40 | 40
 | 50 | 50 | 125 | 50 | 50 | 50
 | 60 | 60 | 150 | 60 | 60 | 60
 | 75 | 75 | 200 | 75 | 75 | 75
 | 100 | 100 | 250 | 100 | 100 | 100
 | 125 | 125 | 300 | 125 | 125 | 125
 | 150 | 150 | 350 | 150 | 150 | 150
 | 200 | 200 |  | 200 | 200
 | 250 | 250 |  | 250 | 250
 | 300 | 300 |  | 300 | 300
 | 350 | 350 |  | 350 | 350
 | 400 | 400 |  | 400 | 400
 | 450 | 450 |  | 450 | 450
 | 500 | 500 |  | 500 | 500
 | 600 |  |  | 600 | 600
 |  |  |  | 700 | 700
 | Encl.
 | 1000-1 CT | 10-1 CT | Wide CHP | Variable Torque | Fixed Speed | XP Variable Speed
 | TENV | TEFC | TENV | TEFC | TEFC | TENV
 | TEBC | TENV | TEBC | TENV | TENV
 | NEMA Frame
 | 1000-1 CT | 10-1 CT | Wide CHP | Variable Torque | Fixed Speed | XP Variable Speed
 | 5011 | 5011 | 364T | 5011 | 5011 | 364T
 | 5013 | 5013 | 365T | 5013 | 364T | 365T
 | 143TC | 215T | 404T | 364T | 365T | 405T
 | 145TC | 284T | 405T | 365T | 404T | 444T
 | 182TC | 286T | 444T | 404T | 405T | 445T
 | 184TC | 324T | 445T | 405T | 444T | 449T
 | 213TC | 326T | 449T | 444T | 445T | 143T
 | 215T | 364T | 256T | 445T | 143T | 145T
 | 215TC | 365T | 284T | 143T | 145T | 184T
 | 254TC | 404T | 326T | 145T | 182T | 182T
 | 256TC | 405T | 367T | 182T | 184T | 213T
 | 284T | 444T | 5011L | 184T | 213T | 254T
 | 284TC | 445T | 5013L | 213T | 215T | 256T
 | 286T | 449T | N/A | 215T | 254T | 284T
 | 324T | L449T |  | 254T | 256T | 286T
 | 326T | 143T |  | 256T | 284T | 326T
 | 326TC | 145T |  | 284T | 286T
 | 364T | 184T |  | 286T | 324T
 | 365T | 213T |  | 324T | 284TS
 | 367T | 182T |  | 284TS | 326T
 | 404T | 254T |  | 326T | 286TS
 | 405T | 256T |  | 286TS | 324TS
 | 444T |  |  | 324TS | 326TS
 | 445T |  |  | 326TS | 364TS
 | 449T |  |  | 364TS | 365TS
 | L449T |  |  | 365TS | 405TS
 |  |  |  | 405TS | 444TS
 |  |  |  | 444TS | 445TS
 |  |  |  | 445TS | 447/9T
 |  |  |  | 447/9T | 447/9TS
 |  |  |  | 447/9TS | call
 |  |  |  | 449T | 5013LS
 |  |  |  | 5011S | 5011LS
 | FLA
 | 1000-1 CT | 10-1 CT | Wide CHP | Variable Torque | Fixed Speed | XP Variable Speed
 | 1.5 | 1.5 | 13.5 | 1.5 | 1.5 | 1.5
 | 1.7 | 2.2 | 19.2 | 1.7 | 1.7 | 1.7
 | 2.2 | 2.3 | 24 | 2 | 2 | 2.2
 | 2.3 | 2.5 | 28 | 2.1 | 2.1 | 2.9
 | 2.5 | 3 | 34.5 | 2.5 | 2.5 | 3.2
 | 3 | 3.6 | 37.5 | 2.7 | 2.7 | 4.1
 | 3.6 | 3.8 | 41.5 | 2.8 | 2.8 | 4.7
 | 3.8 | 4 | 43.5 | 2.9 | 2.9 | 6.5
 | 4 | 4.5 | 45.5 | 3 | 3 | 7.2
 | 4.5 | 6.7 | 47.5 | 3.7 | 3.7 | 10.2
 | 4.6 | 11 | 49.5 | 3.8 | 3.8 | 12.5
 | 6.7 | 12 | 51.5 | 4 | 4 | 13.5
 | 7 | 13 | 54 | 4.7 | 4.7 | 16
 | 7.6 | 15.5 | 58 | 5.7 | 5.7 | 18
 | 10.5 | 22 | 63 | 6.2 | 6.2 | 21.5
 | 11 | 26 | 68.5 | 6.5 | 6.5 | 26
 | 12 | 27 | 80 | 8 | 8 | 26.8
 | 13 | 31.5 | 84.5 | 8.5 | 8.5 | 32.5
 | 15.5 | 32 | 85 | 9.5 | 9.5 | 35
 | 20.2 | 35.5 | 99 | 9.8 | 9.8 | 40
 | 20.4 | 38.5 | 100 | 10 | 10 | 41.5
 | 22 | 41 | 105 | 12 | 12 | 48
 | 26 | 44 | 115 | 12.8 | 12.8 | 48.5
 | 27 | 56 | 125 | 13.1 | 13.1 | 57
 | 29.5 | 60.5 | 144 | 15.5 | 15.5 | 62.5
 | 31 | 69 | 155 | 18 | 18 | 68
 | 31.5 | 74 | 165 | 19 | 19 | 74
 | 32 | 80 | 186 | 20.2 | 20.2 | 86
 | 33 | 92 | 202 | 22.5 | 22.5 | 91
 | 35.5 | 95 | 205 | 23.5 | 23.5 | 112
 | 38.5 | 115 | 232 | 25.5 | 25.5 | 124
 | 40 | 125 | 245 | 26.3 | 26.3 | 139
 | 41 | 142 | 255 | 30 | 29 | 153
 | 42 | 143 | 285 | 31.5 | 30 | 167
 | 44 | 153 | 305 | 32 | 32
 | 48 | 170 | 330 | 33.5 | 33.5
 | 48.5 | 172 | 380 | 36 | 36
 | 50 | 240 | 405 | 37 | 37
 | 52 | 275 | 470 | 38 | 38
 | 56 | 295 | 485 | 39 | 39
 | 59.5 | 302 | 535 | 41 | 41
 | 60.5 | 327 | 540 | 47.5 | 47.5
 | 61.5 | 340 | 585 | 50 | 50
 | 62 | 362 | N/A | 51 | 51
 | 68 | 386 |  | 53.5 | 53.5
 | 69 | 415 |  | 57.5 | 57.5
 | 71 | 420 |  | 61 | 58.8
 | 73 | 485 |  | 65 | 65
 | 74 | 510 |  | 69 | 69
 | 80 | 570 |  | 70.5 | 70.5
 | 87 | 1.65 |  | 72 | 72
 | 92 | 5 |  | 74.5 | 74.5
 | 95 | 6.9 |  | 81 | 81
 | 105 | 8.5 |  | 87 | 87
 | 107 | 9.7 |  | 89 | 89
 | 110 | 13.5 |  | 92.5 | 92.5
 | 115 | 18.5 |  | 93 | 97
 | 124 | 108 |  | 110 | 110
 | 125 | 192 |  | 114 | 114
 | 142 | 202 |  | 119 | 119
 | 143 | 444 |  | 133 | 133
 | 153 | 230 |  | 137 | 137
 | 154 | 33 |  | 142 | 146
 | 158 | 50 |  | 152 | 152
 | 170 | 52 |  | 167 | 167
 | 172 | 62 |  | 169 | 169
 | 173 | 71 |  | 172 | 172
 | 186 |  |  | 182 | 182
 | 205 |  |  | 206 | 206
 | 218 |  |  | 222 | 222
 | 230 |  |  | 225 | 225
 | 240 |  |  | 243 | 243
 | 260 |  |  | 270 | 270
 | 275 |  |  | 280 | 280
 | 295 |  |  | 290 | 290
 | 302 |  |  | 300 | 300
 | 327 |  |  | 330 | 330
 | 340 |  |  | 338 | 340
 | 362 |  |  | 360 | 360
 | 386 |  |  | 385 | 380
 | 415 |  |  | 395 | 400
 | 420 |  |  | 410 | 410
 | 450 |  |  | 432 | 440
 | 458 |  |  | 448 | 460
 | 485 |  |  | 458 | 468
 | 510 |  |  | 468 | 517
 | 522 |  |  | 515 | 525
 | 570 |  |  | 525 | 555
 | 590 |  |  | 555 | 580
 | 660 |  |  | 580 | 655
 |  |  |  | 655 | 800
 |  |  |  | 800
 | Options
 | 1000-1 CT | 10-1 CT | Wide CHP | Variable Torque | Fixed Speed | XP Variable Speed
 | Motor Only | w/50% | w/ Encoder | EPAct Efficiency | EPACT Efficiency IP55 | Motor Only
 | W/ Encoder | w/100% brake | w/50% Brake and Encoder | IEEE841 Premium Efficiency | Premium Efficiency IEEE741 IP56 | W/ Encoder
 | W/ 50% Brake | w/140% Brake | w/100% Brake and Encoder | C-D Flange w/feet IM B34-B35 2101-2001 | C-D Flange w/feet IM B34-B35 2101-2001 | w/ 140% Brake
 | W/ 50% brake and Encoder |  | w/140% Brake and Encoder | C-D Flange no feet IM B14-B5 3611-3001 | C-D Flange no feet IM B14-B5 3611-3001 | [NAME] and Encoder
 | W/ 100% Brake |  |  |  | Vertical D-flange w/canopy V1
 | W/ 100% Brake and Encoder |  |  |  | NEMA 4 140% Brake
 | W/ 140% Brake
 | W/ 140% and Encoder
 | RPM (Wide CHP only)
 | Wide CHP
 | 2000
 | 2750
 | 2600
 | N/A