Spreadsheet: 759912d1639803140-issue-using-getpivotdata-in-formula-cr-sheet-w-arrays
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] | 0.8 | 2 | 577 |  | 86 | 6.709302325581396 | 1.081395348837209 | 6.204301075268817 | 10 |  |  | 2000
Eva Gonzales | 0.78 | 3 | 430 |  | 73 | 5.890410958904109 | 1.273972602739726 | 4.623655913978495 | 7 |  |  | 2000
[NAME] | 0.71 | 6 | 188 |  | 36 | 5.222222222222222 | 2.583333333333333 | 2.021505376344086 | 2
[NAME] | 0.71 | 6 | 557 |  | 80 | 6.9625 | 1.1625 | 5.989247311827957 | 9 |  |  | 1725
[NAME] | 0.74 | 5 | 435 |  | 82 | 5.304878048780488 | 1.134146341463415 | 4.67741935483871 | 8
[NAME] | 0.82 | 1 | 258 |  | 67 | 3.850746268656716 | 1.388059701492537 | 2.774193548387097 | 4 |  |  | 2000
Sage Roles | 0.76 | 4 | 237 |  | 74 | 3.202702702702703 | 1.256756756756757 | 2.548387096774194 | 3 |  |  | 1875
[NAME] | 0.71 | 6 | 344 |  | 77 | 4.467532467532467 | 1.207792207792208 | 3.698924731182796 | 5 |  |  | 1725
[NAME] | 0.67 | 9 | 183 |  | 64 | 2.859375 | 1.453125 | 1.967741935483871 | 1 |  |  | 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