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

 |  |  |  |  |  |  |  | For with encoder, use inf:1
 |  |  |  |  |  |  |  | w/50% | w/100% | w/140%
 |  | Base |  | NEMA | FLA | Motor | with | Brake | Brake | Brake
 | HP | RPM | Encl. | Frame | 230/460 | Only | M4 | No enc | No enc | No enc
 | 1 | 1800 | TENV | 143T | 1.5 | xx | xx | xx | xx | xx
 |  | 1200 | TENV | 145T | 1.65 | xx | xx | xx | xx | xx
 |  | 900 | TENV | 184T | 2.5 | xx | xx | xx | xx | xx
 | 1.5 | 1800 | TENV | 145T | 2.3 | xx | xx | xx | xx | xx
 |  | 1200 | TENV | 184T | 2.2 | xx | xx | xx | xx | xx
 |  | 900 | TENV | 213T | 3.6 | xx | xx | xx | xx | xx
 | 2 | 1800 | TENV | 145T | 3 | xx | xx | xx | xx | xx
 |  | 1200 | TENV | 184T | 3 | xx | xx | xx | xx | xx
 |  | 900 | TENV | 213T | 3.8 | xx | xx | xx | xx | xx
 | 3 | 1800 | TENV | 182T | 4 | xx | xx | xx | xx | xx
 |  | 1200 | TENV | 213T | 4.5 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 215T | 5 | xx | xx | xx | xx | xx
 | 5 | 1800 | TENV | 184T | 6.7 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 215T | 6.9 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 254T | 8.5 | xx | xx | xx | xx | xx
 | 7.5 | 1800 | TEFC | 213T | 9.7 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 254T | 11 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 256T | 12 | xx | xx | xx | xx | xx
 | 10 | 1800 | TENV | 215T | 13 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 256T | 13.5 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 284T | 15.5 | xx | xx | xx | xx | xx
 | 15 | 1800 | TEFC | 254T | 18.5 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 284T | 22 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 286T | 22 | xx | xx | xx | xx | xx
 | 20 | 1800 | TEFC | 256T | 26 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 286T | 27 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 326T | 32 | xx | xx | xx | xx | xx
 | 25 | 1800 | TEFC | 284T | 31.5 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 324T | 33.0 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 364T | 35.5 | xx | xx | xx | xx | xx
 | 30 | 1800 | TEFC | 286T | 38.5 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 326T | 41 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 364T | 44 | xx | xx | xx | xx | xx
 | 40 | 1800 | TEFC | 324T | 50.0 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 364T | 52.0 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 365T | 56 | xx | xx | xx | xx | xx
 | 50 | 1800 | TEFC | 326T | 60.5 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 365T | 62.0 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 404T | 69 | xx | xx | xx | xx | xx
 | 60 | 1800 | TEFC | 364T | 74 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 404T | 71.0 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 405T | 80 | xx | xx | xx | xx | xx
 | 75 | 1800 | TEFC | 365T | 92 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 405T | 95 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 444T | 108 | xx | xx | xx | xx | xx
 | 100 | 1800 | TEFC | 405T | 115 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 444T | 125 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 445T | 142 | xx | xx | xx | xx | xx
 | 125 | 1800 | TEFC | 444T | 143 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 445T | 153 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 449T | 172 | xx | xx | xx | xx | xx
 | 150 | 1800 | TEFC | 445T | 170 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 445T | 192 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 449T | 202 | xx | xx | xx | xx | xx
 | 200 | 1800 | TEFC | 445T | 230 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 449T | 240 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 5011 | 275 | xx | xx | xx | xx | xx
 | 250 | 1800 | TEFC | 449T | 295 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 449T | 302 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 5011 | 340 | xx | xx | xx | xx | xx
 | 300 | 1800 | TEFC | 449T | 327 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | L449T | 362 | xx | xx | xx | xx | xx
 |  | 900 | TEFC | 5013 | 420 | xx | xx | xx | xx | xx
 | 350 | 1800 | TEFC | L449T | 386 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 5011 | 415 | xx | xx | xx | xx | xx
 | 400 | 1800 | TEFC | 5011 | 444 | xx | xx | xx | xx | xx
 |  | 1200 | TEFC | 5011 | 485 | xx | xx | xx | xx | xx
 | 450 | 1800 | TEFC | 5011 | 510 | xx | xx | xx | xx | xx
 | 500 | 1800 | TEFC | 5013 | 570 | xx | xx | xx | xx | xx