Spreadsheet: 759892d1639783758-issue-using-getpivotdata-in-formula-cr-sheet
Sheet: Bonus Calc

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WED
Agent Name | WR | WR Rank | Contacts | PAs | ADP Hours | CPH | PAPH | CE | CE RANK | Rank Average | Rank | Bonus |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
[NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 2000
Eva Gonzales |  |  |  |  |  |  |  |  |  |  |  | 2000
Hailey Smith2
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 1725
[NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 2000
Sage Roles |  |  |  |  |  |  |  |  |  |  |  | 1875
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 1725
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  | 1875
Positive Actions
1 Redraft = 1 PA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.6
1 Legal Entry = 4 PA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shift | 4x10 | Break | Lunch | Break | Break
1 Cleared Save = 1 PA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | off [NAME] | [NAME] | 9:30-11:15a | 02:30:00 | 4-5p | 6-6:15p
$5,000 Cleared Saved Fee = 1 PA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | off Thurs | [NAME] | 9:30-11:15a | 01:30:00 | 4-5p | 6-6:15p
2 OFC Count = 1 PA
$100 OFC EOM = 1 PA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shift | Agent | Break | Lunch | Break
CRT & Overflow |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8-5p | Rudi | 9:30a | 12n | 3:30p
1 Escl Resolution = 1 PA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8-5p | [NAME] | 9:45a | 12n | 3:45p
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:30-5:30 | Terrano | 10a | 1:30p | 4p
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8:30-5:30 | Tre | 10:15a | 12:30p | 4:15p
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9-6p | [NAME] | 10:30a | 1p | 4:30p
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9-6p | Candice | 10:45a | 1p | 4:45p
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9:30-6:30 | [NAME] | 11a | 2p | 5p
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9:30-6:30 | [NAME] | 11:15a | 2p | 5:15p
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9:30-6:30 | Jazmine | 11:30a | 2p | 5:15p
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10-7p | Sage | 11:45a | 3p | 5:30p
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10-7p | Hailey | 11:30a | 3p | 5:30p
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10-7p | Eva | 11:45a | 3p | 5:30p