Spreadsheet: 467232d1466622829-range-formula-help-needed-pivot-vs-countifs-and-averageifs
Sheet: VSM

Order# | SO-Item# | Frame Size | Frame Family | Speed | Pole | HP | Motor Type | Criteria Change (Characteristics) | Median of  Total Hours (based on spec.) | HP Bucket | New Unique Key
9109494766 | [PHONE]-20 | 500 | 500 | 1200-Speed | 6-Pole | 350 | Vented Core |  | 3.85
9108609900 | [PHONE]-30 | 500 | 500 | 1200-Speed | 6-Pole | 450 | Vented Core |  | 2.678
9109668751 | [PHONE]-10 | 500 | 500 | 1800-Speed | 4-Pole | 250 | Vented Core |  | 1.3755
9109827154 | [PHONE]-30 | 508 | 500 | 1800-Speed | 4-Pole | 250 | Vented Core |  | 1.3755
9109766609 | [PHONE]-10 | 509 | 500 | 1800-Speed | 4-Pole | 400 | Vented Core |  | 5.116
9109730769 | [PHONE]-600 | 508 | 500 | 1800-Speed | 4-Pole | 500 | Vented Core |  | 0.603
9109730789 | [PHONE]-700 | 508 | 500 | 1800-Speed | 4-Pole | 500 | Vented Core |  | 0.603
9109346660 | [PHONE]-60 | 509 | 500 | 1800-Speed | 4-Pole | 600 | Vented Core |  | 3.598
9109542470 | [PHONE]-30 | 509 | 500 | 1800-Speed | 4-Pole | 600 | Vented Core |  | 3.598
9109766574 | [PHONE]-20 | 5010 | 500 | 1800-Speed | 4-Pole | 600 | Vented Core |  | 3.598
9108802260 | [PHONE]-30 | 5010 | 500 | 3600-Speed | 2-Pole | 1000 | Vented Core |  | 6.093
9109943771 | [PHONE]-30 | 5010 | 500 | 3600-Speed | 2-Pole | 1000 | Vented Core |  | 6.093
9109943963 | [PHONE]-40 | 5010 | 500 | 3600-Speed | 2-Pole | 1000 | Vented Core |  | 6.093
9109111581 | [PHONE]-10 | 5010 | 500 | 3600-Speed | 2-Pole | 1250 | Vented Core |  | 2.471
9109405807 | [PHONE]-20 | 509 | 500 | 3600-Speed | 2-Pole | 300 | [NAME] |  | 2.708
9109937392 | [PHONE]-40 | 508 | 500 | 3600-Speed | 2-Pole | 300 | Vented Core |  | 1.1765
9109937389 | [PHONE]-30 | 508 | 500 | 3600-Speed | 2-Pole | 300 | Vented Core |  | 1.1765
9109735974 | [PHONE]-10 | 509 | 500 | 3600-Speed | 2-Pole | 350 | [NAME] |  | 1.7945
9109736386 | [PHONE]-20 | 509 | 500 | 3600-Speed | 2-Pole | 350 | [NAME] |  | 1.7945
9109444827 | [PHONE]-10 | 5011 | 500 | 3600-Speed | 2-Pole | 400 | [NAME] |  | 2.127
9109773140 | [PHONE]-10 | 507 | 500 | 3600-Speed | 2-Pole | 400 | Vented Core |  | 1.641
9109722833 | [PHONE]-10 | 508 | 500 | 3600-Speed | 2-Pole | 400 | Vented Core |  | 1.641
9109643671 | [PHONE]-30 | 508 | 500 | 3600-Speed | 2-Pole | 400 | Vented Core |  | 1.641
9108788994 | [PHONE]-20 | 5011 | 500 | 3600-Speed | 2-Pole | 500 | [NAME] |  | 1.307
9109183424 | [PHONE]-40 | 508 | 500 | 3600-Speed | 2-Pole | 500 | Vented Core |  | 1.744
9109730271 | [PHONE]-200 | 508 | 500 | 3600-Speed | 2-Pole | 500 | Vented Core |  | 1.744
9109511252 | [PHONE]-10 | 508 | 500 | 3600-Speed | 2-Pole | 600 | Vented Core |  | 2.668
9109302312 | [PHONE]-10 | 508 | 500 | 3600-Speed | 2-Pole | 600 | Vented Core |  | 2.668
9109097646 | [PHONE]-10 | 508 | 500 | 3600-Speed | 2-Pole | 600 | Vented Core |  | 2.668
9109766483 | [PHONE]-10 | 508 | 500 | 3600-Speed | 2-Pole | 600 | Vented Core |  | 2.668
9109098791 | [PHONE]-10 | 508 | 500 | 3600-Speed | 2-Pole | 600 | Vented Core |  | 2.668
9109097355 | [PHONE]-10 | 508 | 500 | 3600-Speed | 2-Pole | 600 | Vented Core |  | 2.668
9109287365 | [PHONE]-10 | 508 | 500 | 3600-Speed | 2-Pole | 700 | Vented Core |  | 6.559
9109406052 | [PHONE]-10 | 508 | 500 | 3600-Speed | 2-Pole | 700 | Vented Core |  | 6.559
9109650075 | [PHONE]-70 | 508 | 500 | 3600-Speed | 2-Pole | 700 | Vented Core |  | 6.559
9109717580 | [PHONE]-40 | 5010 | 500 | 3600-Speed | 2-Pole | 800 | Vented Core |  | 2.616
9109323655 | [PHONE]-10 | 5010 | 500 | 3600-Speed | 2-Pole | 800 | Vented Core |  | 2.616
9109667877 | [PHONE]-30 | 5010 | 500 | 3600-Speed | 2-Pole | 800 | Vented Core |  | 2.616
9108983879 | [PHONE]-10 | 5010 | 500 | 3600-Speed | 2-Pole | 800 | Vented Core |  | 2.616
9109140093 | [PHONE]-40 | 508 | 500 | 3600-Speed | 2-Pole | 800 | Vented Core |  | 2.616
9109722588 | [PHONE]-10 | 508 | 500 | 3600-Speed | 2-Pole | 800 | Vented Core |  | 2.616
9109308304 | [PHONE]-10 | 5010 | 500 | 3600-Speed | 2-Pole | 900 | Vented Core |  | 2.297
9109914924 | [PHONE]-10 | 5010 | 500 | 3600-Speed | 2-Pole | 900 | Vented Core |  | 2.297
9109602414 | [PHONE]-10 | 508 | 500 | 900-Speed | 8-Pole | 150 | Vented Core |  | 1.551
9108644988 | [PHONE]-10 | 588 | 580 | 1000-Speed | 6-Pole | 700 | Vented Core |  | 2.3305
9108644898 | [PHONE]-10 | 588 | 580 | 1000-Speed | 6-Pole | 700 | Vented Core |  | 2.3305
9109796927 | [PHONE]-10 | 5812 | 580 | 1200-Speed | 6-Pole | 1500 | Vented Core |  | 2.445
9109815592 | [PHONE]-20 | 5810 | 580 | 1200-Speed | 6-Pole | 750 | Vented Core |  | 2.407
9109815580 | [PHONE]-10 | 5810 | 580 | 1200-Speed | 6-Pole | 750 | Vented Core |  | 2.407
9108754119 | [PHONE]-1900 | 5810 | 580 | 1200-Speed | 6-Pole | 860 | Vented Core |  | 1.234
9109567641 | [PHONE]-10 | 5810 | 580 | 1200-Speed | 6-Pole | 900 | Vented Core |  | 2.205
9109184780 | [PHONE]-10 | 588 | 580 | 1500-Speed | 4-Pole | 700 | Vented Core |  | 1.324
9109351735 | [PHONE]-50 | 5810 | 580 | 1800-Speed | 4-Pole | 1250 | Vented Core |  | 2.629
9108961807 | [PHONE]-30 | 5812 | 580 | 1800-Speed | 4-Pole | 1400 | Vented Core |  | 2.141
9109444425 | [PHONE]-10 | 5812 | 580 | 1800-Speed | 4-Pole | 1500 | Vented Core |  | 2.467
9109848903 | [PHONE]-70 | 5810 | 580 | 1800-Speed | 4-Pole | 900 | Vented Core |  | 4.409000000000001
9109743361 | [PHONE]-10 | 588 | 580 | 3000-Speed | 2-Pole | 700 | Vented Core |  | 1.605
9109684442 | [PHONE]-10 | 5812 | 580 | 3600-Speed | 2-Pole | 1000 | [NAME] |  | 0.923
9109648706 | [PHONE]-10 | 588 | 580 | 3600-Speed | 2-Pole | 1000 | Vented Core |  | 6.2645
9109417152 | [PHONE]-10 | 5810 | 580 | 3600-Speed | 2-Pole | 1000 | Vented Core |  | 6.2645
9109351770 | [PHONE]-60 | 5810 | 580 | 3600-Speed | 2-Pole | 1250 | Vented Core |  | 0.772
9109182862 | [PHONE]-10 | 5810 | 580 | 3600-Speed | 2-Pole | 1250 | Vented Core |  | 0.772
9108812823 | [PHONE]-10 | 5810 | 580 | 3600-Speed | 2-Pole | 1250 | Vented Core |  | 0.772
9109693897 | [PHONE]-10 | 5810 | 580 | 3600-Speed | 2-Pole | 1500 | Vented Core |  | 1.551
9109287775 | [PHONE]-10 | 5810 | 580 | 3600-Speed | 2-Pole | 1500 | Vented Core |  | 1.551
9109601834 | [PHONE]-30 | 5810 | 580 | 3600-Speed | 2-Pole | 1500 | Vented Core |  | 1.551
9109943485 | [PHONE]-10 | 5812 | 580 | 3600-Speed | 2-Pole | 1500 | Vented Core |  | 1.551
9109850365 | [PHONE]-60 | 5810 | 580 | 3600-Speed | 2-Pole | 1500 | Vented Core |  | 1.551
9109601913 | [PHONE]-10 | 5810 | 580 | 3600-Speed | 2-Pole | 1500 | Vented Core |  | 1.551
9109601867 | [PHONE]-50 | 5810 | 580 | 3600-Speed | 2-Pole | 1500 | Vented Core |  | 1.551
9109850330 | [PHONE]-50 | 5810 | 580 | 3600-Speed | 2-Pole | 1500 | Vented Core |  | 1.551
9109850472 | [PHONE]-90 | 5810 | 580 | 3600-Speed | 2-Pole | 1500 | Vented Core |  | 1.551
9109601851 | [PHONE]-40 | 5810 | 580 | 3600-Speed | 2-Pole | 1500 | Vented Core |  | 1.551
9109518034 | [PHONE]-500 | 5810 | 580 | 3600-Speed | 2-Pole | 1500 | Vented Core |  | 1.551
9109931095 | [PHONE]-20 | 5810 | 580 | 3600-Speed | 2-Pole | 1500 | Vented Core |  | 1.551
9109601949 | [PHONE]-20 | 5810 | 580 | 3600-Speed | 2-Pole | 1500 | Vented Core |  | 1.551
9109140041 | [PHONE]-20 | 5812 | 580 | 3600-Speed | 2-Pole | 1500 | Vented Core |  | 1.551
9109601886 | [PHONE]-60 | 5810 | 580 | 3600-Speed | 2-Pole | 1500 | Vented Core |  | 1.551
9108788796 | [PHONE]-10 | 5810 | 580 | 3600-Speed | 2-Pole | 1600 | Vented Core |  | 1.074
9108780483 | [PHONE]-10 | 5810 | 580 | 3600-Speed | 2-Pole | 1600 | Vented Core |  | 1.074
9108899988 | [PHONE]-10 | 5810 | 580 | 3600-Speed | 2-Pole | 1600 | Vented Core |  | 1.074
9108900043 | [PHONE]-20 | 5810 | 580 | 3600-Speed | 2-Pole | 1600 | Vented Core |  | 1.074
9109053254 | [PHONE]-100 | 5810 | 580 | 3600-Speed | 2-Pole | 1750 | Vented Core |  | 2.537
9109190892 | [PHONE]-10 | 5810 | 580 | 3600-Speed | 2-Pole | 1750 | Vented Core |  | 2.537
9109937379 | [PHONE]-10 | 5810 | 580 | 3600-Speed | 2-Pole | 1750 | Vented Core |  | 2.537
9109625499 | [PHONE]-10 | 5810 | 580 | 3600-Speed | 2-Pole | 1750 | Vented Core |  | 2.537
9109214317 | [PHONE]-20 | 5812 | 580 | 3600-Speed | 2-Pole | 1750 | Vented Core |  | 2.537
9109661674 | [PHONE]-10 | 5812 | 580 | 3600-Speed | 2-Pole | 1750 | Vented Core |  | 2.537
9108780863 | [PHONE]-30 | 5812 | 580 | 3600-Speed | 2-Pole | 2000 | Vented Core |  | 2.101
9109821033 | [PHONE]-10 | 5812 | 580 | 3600-Speed | 2-Pole | 2000 | Vented Core |  | 2.101
9109761168 | [PHONE]-30 | 5812 | 580 | 3600-Speed | 2-Pole | 2000 | Vented Core |  | 2.101
9109761153 | [PHONE]-20 | 5812 | 580 | 3600-Speed | 2-Pole | 2000 | Vented Core |  | 2.101
9109827475 | [PHONE]-30 | 5812 | 580 | 3600-Speed | 2-Pole | 2000 | Vented Core |  | 2.101
9109827209 | [PHONE]-10 | 5812 | 580 | 3600-Speed | 2-Pole | 2000 | Vented Core |  | 2.101
9109867622 | [PHONE]-10 | 5812 | 580 | 3600-Speed | 2-Pole | 2000 | Vented Core |  | 2.101
9109821018 | [PHONE]-30 | 5812 | 580 | 3600-Speed | 2-Pole | 2000 | Vented Core |  | 2.101
9109867150 | [PHONE]-120 | 5812 | 580 | 3600-Speed | 2-Pole | 2000 | Vented Core |  | 2.101
9109821048 | [PHONE]-20 | 5812 | 580 | 3600-Speed | 2-Pole | 2000 | Vented Core |  | 2.101
9108934224 | [PHONE]-20 | 5812 | 580 | 3600-Speed | 2-Pole | 2000 | Vented Core |  | 2.101
9109731560 | [PHONE]-1000 | 5812 | 580 | 3600-Speed | 2-Pole | 2250 | Vented Core |  | 2.341
9109417195 | [PHONE]-10 | 5812 | 580 | 3600-Speed | 2-Pole | 2250 | Vented Core |  | 2.341
9109731465 | [PHONE]-900 | 5812 | 580 | 3600-Speed | 2-Pole | 2250 | Vented Core |  | 2.341
9109489939 | [PHONE]-10 | 5812 | 580 | 3600-Speed | 2-Pole | 2500 | Vented Core |  | 1.453
9109634817 | [PHONE]-10 | 5812 | 580 | 3600-Speed | 2-Pole | 2500 | Vented Core |  | 1.453
9109489992 | [PHONE]-20 | 5812 | 580 | 3600-Speed | 2-Pole | 2500 | Vented Core |  | 1.453
9109689250 | [PHONE]-10 | 5810 | 580 | 3600-Speed | 2-Pole | 550 | [NAME] |  | 1.83
9109948515 | [PHONE]-20 | 5810 | 580 | 3600-Speed | 2-Pole | 600 | [NAME] |  | 0.585
9108684714 | [PHONE]-10 | 588 | 580 | 3600-Speed | 2-Pole | 600 | Vented Core |  | 0.939
9109344825 | [PHONE]-30 | 5810 | 580 | 3600-Speed | 2-Pole | 660 | [NAME] |  | 1.7855
9109344772 | [PHONE]-10 | 5810 | 580 | 3600-Speed | 2-Pole | 660 | [NAME] |  | 1.7855
9109503138 | [PHONE]-10 | 5810 | 580 | 3600-Speed | 2-Pole | 700 | [NAME] |  | 2.251
9109620820 | [PHONE]-10 | 5810 | 580 | 3600-Speed | 2-Pole | 850 | Vented Core |  | 0.579
9109804436 | [PHONE]-20 | 588 | 580 | 3600-Speed | 2-Pole | 900 | Vented Core |  | 3.059
9109115966 | [PHONE]-20 | 588 | 580 | 5030-Speed | 2-Pole | 493 | [NAME] |  | 1.49
9109896518 | [PHONE]-10 | 588 | 580 | 720-Speed | 10-Pole | 300 | Vented Core |  | 2.77
9109784466 | [PHONE]-10 | 5812 | 580 | 900-Speed | 8-Pole | 1000 | Vented Core |  | 3.637
9109722879 | [PHONE]-20 | 588 | 580 | 900-Speed | 8-Pole | 450 | Vented Core |  | 6.596
9109060386 | [PHONE]-100 | 636 | 630 | 1500-Speed | 4-Pole | 4559 | Vented Core |  | 3.873
9108736617 | [PHONE]-100 | 636 | 630 | 1800-Speed | 4-Pole | 6750 | Vented Core |  | 3.034
9109721249 | [PHONE]-500 | 680 | 680 | 1200-Speed | 6-Pole | 1500 | Vented Core |  | 3.6485
9109721219 | [PHONE]-300 | 680 | 680 | 1200-Speed | 6-Pole | 1500 | Vented Core |  | 3.6485
9109729709 | [PHONE]-10 | 6811 | 680 | 1200-Speed | 6-Pole | 1500 | Vented Core |  | 3.6485
9109729786 | [PHONE]-20 | 6811 | 680 | 1200-Speed | 6-Pole | 1500 | Vented Core |  | 3.6485
9108842899 | [PHONE]-10 | 6811 | 680 | 3000-Speed | 2-Pole | 500 | Vented Core |  | 1.117
9108718784 | [PHONE]-20 | 6811 | 680 | 3600-Speed | 2-Pole | 2000 | Vented Core |  | 0.969
9109684679 | [PHONE]-200 | 6811 | 680 | 3600-Speed | 2-Pole | 2250 | Vented Core |  | 2.694
9109190973 | [PHONE]-10 | 6811 | 680 | 3600-Speed | 2-Pole | 2500 | Vented Core |  | 2.999
9108929754 | [PHONE]-400 | 6811 | 680 | 3600-Speed | 2-Pole | 2750 | Vented Core |  | 1.566
9108928196 | [PHONE]-200 | 6811 | 680 | 3600-Speed | 2-Pole | 2750 | Vented Core |  | 1.566
9109089847 | [PHONE]-30 | 6811 | 680 | 3600-Speed | 2-Pole | 3000 | Vented Core |  | 1.396
9108938540 | [PHONE]-10 | 6813 | 680 | 3600-Speed | 2-Pole | 4000 | Vented Core |  | 2.364
9109773101 | [PHONE]-100 | 6813 | 680 | 3600-Speed | 2-Pole | 4425 | Vented Core |  | 4.645
9109542386 | [PHONE]-10 | 6813 | 680 | 900-Speed | 8-Pole | 1850 | Vented Core |  | 6.182
9108118848 | [PHONE]-100 | 716 | 710 | 600-Speed | 12-Pole | 4400 | Vented Core |  | 0.663
9108717872 | [PHONE]-10 | 8012 | 800 | 1800-Speed | 4-Pole | 4000 | Vented Core |  | 3.821
9108865108 | [PHONE]-10 | 8010 | 800 | 1800-Speed | 4-Pole | 4694 | Vented Core |  | 3.039
9109042324 | [PHONE]-600 | 8010 | 800 | 3600-Speed | 2-Pole | 3000 | Vented Core |  | 2.227
9109042286 | [PHONE]-500 | 8010 | 800 | 3600-Speed | 2-Pole | 3000 | Vented Core |  | 2.227
9108750072 | [PHONE]-300 | 8012 | 800 | 3600-Speed | 2-Pole | 3000 | Vented Core |  | 2.227
9108887436 | [PHONE]-20 | 8010 | 800 | 3600-Speed | 2-Pole | 4800 | Vented Core |  | 3.197
9108321683 | [PHONE]-110 | 8010 | 800 | 3600-Speed | 2-Pole | 5000 | Vented Core |  | 3.44
9109516942 | [PHONE]-10 | 8010 | 800 | 3600-Speed | 2-Pole | 6705 | Vented Core |  | 3.179
9109960487 | [PHONE]-10 | 8010 | 800 | 900-Speed | 8-Pole | 2500 | Vented Core |  | 11.804
9108652251 | [PHONE]-1802 | 8010 | 800 | 900-Speed | 8-Pole | 2600 | Vented Core |  | 2.564
9108877567 | [PHONE]-10 | 8010 | 800 | 900-Speed | 8-Pole | 2600 | Vented Core |  | 2.564