Spreadsheet: 770677d1646223172-add-values-in-range-of-cells-if-values-in-other-cells-match-staff-bonuses-2019-working-v2-help-file
Sheet: Stylists

Bonus Calculator
RM enter data in blue areas.  First space (dark blue) is for manager.
HR Pay amounts in purple
 | Regional Manager
[NAME] | Product Sales Director
 |  | Review Grade: |  |  |  |  | Impact on Bonus:
Stylist | Product Class | Hours | New Returns | Repeat Returns | Productivity | Product Sales (%) | Product Sales ($) | Product Sales Bonus | Employee Bonus
[NAME] | No
[NAME] | No
[NAME] | Yes
[NAME] | No
[NAME] | Yes
Mariah Grigoriadis | No
[NAME] | Yes
Desiree Cavazos | No
Danielle Finch | No
[NAME] | No
HP11 | No
HP12 | No
 |  | Review Grade: |  |  |  |  | Impact on Bonus:
Stylist | Product Class | Hours | New Returns | Repeat Returns | Productivity | Product Sales (%) | Product Sales ($) | Product Sales Bonus | Employee Bonus
[NAME] | No
[NAME] | Yes
 | No
[NAME] | Yes
[NAME] | Yes
[NAME] | No
Amanda Scarder | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | No
[NAME] | No
Cle12 | No
 |  | Review Grade: |  |  |  |  | Impact on Bonus:
Stylist | Product Class | Hours | New Returns | Repeat Returns | Productivity | Product Sales (%) | Product Sales ($) | Product Sales Bonus | Employee Bonus
[NAME] | No
[NAME] | No
Aubre Chancellor | No
[NAME] | No
Chrissy Ogden | No
[NAME] | No
 | No
Cor8 | No
Cor9 | No
Cor10 | No
Cor11 | No
Cor12 | No
 |  | Review Grade: |  |  |  |  | Impact on Bonus:
Stylist | Product Class | Hours | New Returns | Repeat Returns | Productivity | Product Sales (%) | Product Sales ($) | Product Sales Bonus | Employee Bonus
Crystal Carranza | No
[NAME] | No
[NAME] | No
Esmeralda Martinez | No
[NAME] | No
[NAME] | No
Gar7 | No
Gar8 | No
Gar9 | No
Gar10 | No
Gar11 | No
Gar12 | No
 |  | Review Grade: |  |  |  |  | Impact on Bonus:
Stylist | Product Class | Hours | New Returns | Repeat Returns | Productivity | Product Sales (%) | Product Sales ($) | Product Sales Bonus | Employee Bonus
[NAME] | No
[NAME] | No
Amber Burns | No
Brandie Fletcher | No
[NAME] | No
[NAME] | No
[NAME] | No
 | No
 | No
Gun10 | No
Gun11 | No
Gun12 | No
 |  | Review Grade: |  |  |  |  | Impact on Bonus:
Stylist | Product Class | Hours | New Returns | Repeat Returns | Productivity | Product Sales (%) | Product Sales ($) | Product Sales Bonus | Employee Bonus
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
Porsche [NAME] | Yes
[NAME] | Yes
[NAME] | Yes
 | Yes
Har9 | No
Har10 | No
Har11 | No
Har12 | No
 |  | Review Grade: |  |  |  |  | Impact on Bonus:
Stylist | Product Class | Hours | New Returns | Repeat Returns | Productivity | Product Sales (%) | Product Sales ($) | Product Sales Bonus | Employee Bonus
 | No
Sandra Agueros | Yes
Liliann Champion | Yes
[NAME] | Yes
[NAME] | Yes
Michell Nunnally | Yes
[NAME] | Yes
[NAME] | No
Rid9 | No
Rid10 | No
[NAME] | No
Rid12 | No
 |  | Review Grade: |  |  |  |  | Impact on Bonus:
Stylist | Product Class | Hours | New Returns | Repeat Returns | Productivity | Product Sales (%) | Product Sales ($) | Product Sales Bonus | Employee Bonus
[NAME] | No
Sandra Agueros | Yes
Doralenn cuellar | No
[NAME] | No
[NAME] | No
Cassy Moreland | No
Trista Towles | No
[NAME] | No
Riv9 | No
Riv10 | No
Riv11 | No
B | No
 |  | Review Grade: |  |  |  |  | Impact on Bonus:
Stylist | Product Class | Hours | New Returns | Repeat Returns | Productivity | Product Sales (%) | Product Sales ($) | Product Sales Bonus | Employee Bonus
 | No
[NAME] | Yes
Crystal [NAME] | No
[NAME] | Yes
[NAME] | No
Jade Hearn | No
[NAME] | Yes
Amanda Scarber | No
[NAME] | Yes
Rid10 | No
[NAME] | No
Rid12 | No
 |  | Review Grade: |  |  |  |  | Impact on Bonus:
Stylist | Product Class | Hours | New Returns | Repeat Returns | Productivity | Product Sales (%) | Product Sales ($) | Product Sales Bonus | Employee Bonus
 | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
Amber Murrell | Yes
[NAME] Paday | No
[NAME] | Yes
Iliana Smith | Yes
Riv9 | Yes
Riv10 | No
Riv11 | No
Riv12 | No
 |  | Review Grade: |  |  |  |  | Impact on Bonus:
Stylist | Product Class | Hours | New Returns | Repeat Returns | Productivity | Product Sales (%) | Product Sales ($) | Product Sales Bonus | Employee Bonus
 | Yes
 | Yes
 | Yes
 | Yes
 | Yes
 | Yes
 | Yes
 | Yes
 | Yes
 | No
 | No
 | No
 |  | Review Grade: |  |  |  |  | Impact on Bonus:
Stylist | Product Class | Hours | New Returns | Repeat Returns | Productivity | Product Sales (%) | Product Sales ($) | Product Sales Bonus | Employee Bonus
Destiny [NAME] | No
[NAME] | Yes |  |  | 0.795 | 28.7
Christina Diaz | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] Villarreal | No
 | No
 | No
 | No
Stan11 | No
Stan12 | No
 |  | Review Grade: |  |  |  |  | Impact on Bonus:
Stylist | Product Class | Hours | New Returns | Repeat Returns | Productivity | Product Sales (%) | Product Sales ($) | Product Sales Bonus | Employee Bonus
[NAME] | Yes
[NAME] | No
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
Seheyla Rodriguez | Yes
[NAME] | Yes
Lindsey  Wood | Yes
Sub10 | No
Sub11 | No
Sub12 | No
 |  | Review Grade: |  |  |  |  | Impact on Bonus:
Stylist | Product Class | Hours | New Returns | Repeat Returns | Productivity | Product Sales (%) | Product Sales ($) | Product Sales Bonus | Employee Bonus
[NAME] | Yes
Helena Adair | Yes
Priscilla Amons | Yes
Ashley Banks | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
Tr10 | No
26 | No
Tr12 | No
 |  | Review Grade: |  |  |  |  | Impact on Bonus:
Stylist | Product Class | Hours | New Returns | Repeat Returns | Productivity | Product Sales (%) | Product Sales ($) | Product Sales Bonus | Employee Bonus
EmptyB1 | No
EmptyB2 | No
EmptyB3 | No
EmptyB4 | No
EmptyB5 | No
EmptyB6 | No
EmptyB7 | No
EmptyB8 | No
EmptyB9 | No
EmptyB10 | No
EmptyB11 | No
EmptyB12 | No
 |  | Review Grade: |  |  |  |  | Impact on Bonus:
Stylist | Product Class | Hours | New Returns | Repeat Returns | Productivity | Product Sales (%) | Product Sales ($) | Product Sales Bonus | Employee Bonus
EmptyB1 | No
EmptyB2 | No
EmptyB3 | No
EmptyB4 | No
EmptyB5 | No
EmptyB6 | No
EmptyB7 | No
EmptyB8 | No
EmptyB9 | No
EmptyB10 | No
EmptyB11 | No
EmptyB12 | No
 |  | Review Grade: |  |  |  |  | Impact on Bonus:
Stylist | Product Class | Hours | New Returns | Repeat Returns | Productivity | Product Sales (%) | Product Sales ($) | Product Sales Bonus | Employee Bonus
EmptyB1 | No
EmptyB2 | No
EmptyB3 | No
EmptyB4 | No
EmptyB5 | No
EmptyB6 | No
EmptyB7 | No
EmptyB8 | No
EmptyB9 | No
EmptyB10 | No
EmptyB11 | No
EmptyB12 | No
 |  | Review Grade: |  |  |  |  | Impact on Bonus:
Stylist | Product Class | Hours | New Returns | Repeat Returns | Productivity | Product Sales (%) | Product Sales ($) | Product Sales Bonus | Employee Bonus
EmptyB1 | No
EmptyB2 | No
EmptyB3 | No
EmptyB4 | No
EmptyB5 | No
EmptyB6 | No
EmptyB7 | No
EmptyB8 | No
EmptyB9 | No
EmptyB10 | No
EmptyB11 | No
EmptyB12 | No