Spreadsheet: 858788d1707336678-summing-only-if-a-cell-is-greater-than-test
Sheet: Dashboard

Feb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PFP Per ObJ | 11.429
Account Manager PFP $ |  |  |  |  |  | ASM & Director PFP $ |  |  |  |  |  | Execution Only (Goal of 80%)
Route # | AM | $ [NAME] | Unearned $ | Total Targets |  | ASM/Dir | $ [NAME] | % | Total Pontential | Earned $ |  | Route # | AM | # EO OBJ | Executed OBJ | %
60 |  |  |  |  |  |  |  |  | 2400 |  |  | 60 |  | 8 | 8
61 |  |  |  |  |  |  |  |  | 2400 |  |  | 61 |  | 4 | 3
62 |  |  |  |  |  |  |  |  | 1600 |  |  | 62 |  | 5 | 3
63 |  |  |  |  |  |  |  |  | 1600 |  |  | 63 |  | 11 | 10
64 |  |  |  |  |  |  |  |  |  |  |  | 64 |  | 12 | 12
80 |  |  |  |  |  |  |  |  |  |  |  | 80 |  | 20 | 16
81 |  |  |  |  |  |  |  |  |  |  |  | 81 |  | 14 | 5
82 |  |  |  |  |  |  |  |  |  |  |  | 82 |  | 2 | 1
83 |  |  |  |  |  |  |  |  |  |  |  | 83 |  | 8 | 5
84 |  |  |  |  |  |  |  |  |  |  |  | 84 |  | 4 | 1
Ultra Displays |  |  |  |  |  | Light Beer Super Bowl/UFC Displays |  |  |  |  |  | Bud LT/Busch LT Displays
Route # | Earned $ | Target | Achieved | Needed |  | Route # | Earned $ | Target | Achieved | Needed |  | Route # | Earned $ | Target | Achieved | Needed
60 |  | 10 | 10 |  |  | 60 |  | 8 |  |  |  | 60 |  | 8
61 |  | 12 | 8 |  |  | 61 |  | 8 |  |  |  | 61 |  | 8
62 |  | 12 | 7 |  |  | 62 |  | 9 |  |  |  | 62 |  | 10
63 |  | 12 | 6 |  |  | 63 |  | 10 |  |  |  | 63 |  | 8
64 |  | 8 | 5 |  |  | 64 |  | 8 |  |  |  | 64 |  | 8
80 |  | 18 | 1 |  |  | 80 |  | 8 |  |  |  | 80 |  | 8
81 |  | 18 | 2 |  |  | 81 |  | 10 |  |  |  | 81 |  | 10
82 |  | 8 | 4 |  |  | 82 |  | 8 |  |  |  | 82 |  | 8
83 |  | 16 | 3 |  |  | 83 |  | 8 |  |  |  | 83 |  | 8
84 |  | 16 | 8 |  |  | 84 |  | 8 |  |  |  | 84 |  | 8
Natural LT 30 PK C |  |  |  |  |  | Coastal RTD 8 PK |  |  |  |  |  | Devils RTD 8 PK
Route # | Earned $ | Target | Achieved | Needed |  | Route # | Earned $ | Target | Achieved | Needed |  | Route # | Earned $ | Target | Achieved | Needed
60 |  | 2 |  |  |  | 60 |  | 4 | 8 |  |  | 60 |  | 8
61 |  | 2 |  |  |  | 61 |  | 4 |  |  |  | 61 |  | 10
62 |  | 0 |  |  |  | 62 |  | 8 |  |  |  | 62 |  | 10
63 |  | 2 |  |  |  | 63 |  | 6 |  |  |  | 63 |  | 14
64 |  | 2 |  |  |  | 64 |  | 2 |  |  |  | 64 |  | 10
80 |  | 4 |  |  |  | 80 |  | 2 |  |  |  | 80 |  | 5
81 |  | 2 |  |  |  | 81 |  | 2 |  |  |  | 81 |  | 6
82 |  | 2 |  |  |  | 82 |  | 4 |  |  |  | 82 |  | 14
83 |  | 12 |  |  |  | 83 |  | 0 |  |  |  | 83 |  | 0
84 |  | 12 |  |  |  | 84 |  | 0 |  |  |  | 84 |  | 0
[NAME] (Any SKU) |  |  |  |  |  | Jarriotos Mandarin & Strawberry |  |  |  |  |  | [NAME] [NAME] 6 PK B
Route # | Earned $ | Target | Achieved | Needed |  | Route # | Earned $ | Target | Achieved | Needed |  | Route # | Earned $ | Target | Achieved | Needed
60 |  | 9 |  |  |  | 60 |  | 10 |  |  |  | 60 |  | 3
61 |  | 5 |  |  |  | 61 |  | 10 |  |  |  | 61 |  | 3
62 |  | 0 |  |  |  | 62 |  | 8 |  |  |  | 62 |  | 5
63 |  | 4 |  |  |  | 63 |  | 7 |  |  |  | 63 |  | 3
64 |  | 6 |  |  |  | 64 |  | 6 |  |  |  | 64 |  | 6
80 |  | 7 |  |  |  | 80 |  | 2 |  |  |  | 80 |  | 6
81 |  | 8 |  |  |  | 81 |  | 7 |  |  |  | 81 |  | 3
82 |  | 5 |  |  |  | 82 |  | 10 |  |  |  | 82 |  | 3
83 |  | 10 |  |  |  | 83 |  | 0 |  |  |  | 83 |  | 8
84 |  | 10 |  |  |  | 84 |  | 0 |  |  |  | 84 |  | 8
[NAME] 6 PK |  |  |  |  |  | [NAME] 16.9 |  |  |  |  |  | [NAME]
Route # | Earned $ | Target | Achieved | Needed |  | Route # | Earned $ | Target | Achieved | Needed |  | Route # | Earned $ | Target | Achieved | Needed
60 |  | 4 |  |  |  | 60 |  | 4 |  |  |  | 60
61 |  | 4 |  |  |  | 61 |  | 4 |  |  |  | 61
62 |  | 4 |  |  |  | 62 |  | 4 |  |  |  | 62
63 |  | 2 |  |  |  | 63 |  | 2 |  |  |  | 63
64 |  | 6 |  |  |  | 64 |  | 8 |  |  |  | 64
80 |  | 4 |  |  |  | 80 |  | 6 |  |  |  | 80
81 |  | 2 |  |  |  | 81 |  | 2 |  |  |  | 81
82 |  | 4 |  |  |  | 82 |  | 4 |  |  |  | 82
83 |  | 4 |  |  |  | 83 |  | 4 |  |  |  | 83
84 |  | 4 |  |  |  | 84 |  | 4 |  |  |  | 84