Spreadsheet: 483670d1475769752-unable-to-produce-league-table-chart-based-on-data-delivery-calculator1
Sheet: Points

 |  |  |  |  |  |  |  | This sheet uses Named Ranges. View names in '[NAME], 'Name Manager.
 |  | Employee Points Log |  |  |  |  |  | The same INDEX MATCH formula can also be used to determine Values from Store #, Location, Recovery Value, & Merchandise types.
Job # | Date | Store # | Location | Mechandise | Recovery           Y/N | Value of Recovery | Points | Employees Rewarded | Employees Required | Driver | Points Awarded | Assist 1 | Points Awarded | Assist 2 | Points Awarded |  | Employee ID | Employee Name | Points Awarded Driver 1 | Points Awarded Assist 1 | Points Awarded Assist 2 | Total Points | Unsorted Rank |  | Sorted Rank | Employee Name | Points
1 | 2016-10-06 00:00:00 | 36054 | Basildon | Beans | Yes | 162 |  | Yes | 1 | Ima Dunce |  | - |  | - |  |  |  |  |  |  |  |  |  |  | 1
2 | 2016-10-07 00:00:00 | 36505 | Romford | Peanuts | Yes | 101 |  | Yes | 2 | [NAME] |  | Ima Belle |  | - |  |  |  |  |  |  |  |  |  |  | 2
3 | 2016-10-07 00:00:00 | 36956 | Dulwich | Blackpudding | Yes | 119 |  | Yes | 1 | [NAME] |  | - |  | - |  |  |  |  |  |  |  |  |  |  | 3
4 | 2016-10-08 00:00:00 | 37407 | Basildon | Meat Pies | Yes | 121 |  | Yes | 1 | Ima Belle |  | - |  | - |  |  |  |  |  |  |  |  |  |  | 4
5 | 2016-10-08 00:00:00 | 37858 | Pinner | Beans | On Hold | 111 |  | Yes | 2 | [NAME] |  | [NAME] |  | - |  |  |  |  |  |  |  |  |  |  | 5
6 | 2016-10-08 00:00:00 | 38309 | [NAME] | Peanuts | Yes | 108 |  | Yes | 1 | Justin Time |  | - |  | - |  |  |  |  |  |  |  |  |  |  | 6
7 | 2016-10-08 00:00:00 | 38760 | Basildon | Coffee | Yes | 162.25 |  | Yes | 3 | Anne Other |  | [NAME] |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 7
8 | 2016-10-09 00:00:00 | 39211 | Romford | Meat Pies | Yes | 156 |  | Yes | 1 | [NAME] |  | - |  | - |  |  |  |  |  |  |  |  |  |  | 8
9 | 2016-10-09 00:00:00 | 39662 | Pinner | Beans | No | 129 |  | Yes | 1 | [NAME] |  | - |  | - |  |  |  |  |  |  |  |  |  |  | 9
10 | 2016-10-09 00:00:00 | 40113 | [NAME] | Peanuts | Yes | 145 |  | Yes | 1 | Ima Dunce |  | - |  | - |  |  |  |  |  |  |  |  |  |  | 10
11 | 2016-10-09 00:00:00 | 40564 | Dulwich | Blackpudding | Scheduled | 153 |  | Scheduled | 2 | [NAME] |  | [NAME] |  | - |  |  |  |  |  |  |  |  |  |  | 11
12 | 2016-10-09 00:00:00 | 41015 | Basildon | Coffee | Yes | 138 |  | Yes | 1 | [NAME] |  | - |  | - |  |  |  |  |  |  |  |  |  |  | 12
13 | 2016-10-10 00:00:00 | 41466 | Basildon | Meat Pies | Yes | 107 |  | Yes | 3 | [NAME] |  | [NAME] |  | Ima Belle |  |  |  |  |  |  |  |  |  |  | 13
14 | 2016-10-10 00:00:00 | 41917 | Pinner | Beans | Yes | 142 |  | Yes | 1 | [NAME] |  | - |  | - |  |  |  |  |  |  |  |  |  |  | 14
15 | 2016-10-10 00:00:00 | 42368 | [NAME] | Peanuts | Yes | 156 |  | Yes | 1 | [NAME] |  | - |  | - |  |  |  |  |  |  |  |  |  |  | 15
16 | 2016-10-10 00:00:00 | 42819 | Romford | Blackpudding | Yes | 139 |  | Yes | 1 | [NAME] |  | - |  | - |  |  |  |  |  |  |  |  |  |  | 16
17 | 2016-10-10 00:00:00 | 43270 | Dulwich | Coffee | Yes | 92 |  | Yes | 1 | [NAME] |  | - |  | - |  |  |  |  |  |  |  |  |  |  | 17
18 | 2016-10-11 00:00:00 | 43721 | Basildon | Meat Pies | Yes | 114 |  | Yes | 1 | P, [NAME] |  | - |  | - |  |  |  |  |  |  |  |  |  |  | 18
19 | 2016-10-11 00:00:00 | 44172 | Pinner | Beans | Yes | 96 |  | Yes | 1 | Shawn Deelear |  | - |  | - |  |  |  |  |  |  |  |  |  |  | 19
20 | 2016-10-12 00:00:00 | 44623 | [NAME] | Peanuts | Yes | 113 |  | Yes | 1 | [NAME] |  | - |  | - |  |  |  |  |  |  |  |  |  |  | 20
21 | 2016-10-13 00:00:00 | 45074 | Romford | Blackpudding | Yes | 148 |  | Yes | 3 | [NAME] |  | [NAME] |  | P, [NAME] |  |  |  |  |  |  |  |  |  |  | 21
22 | 2016-10-14 00:00:00 | 45075 | Dulwich | Coffee | Yes | 98 |  | Yes | 1 | [NAME] |  | - |  | -
23 | 2016-10-15 00:00:00 | 45076 | [NAME] | Blackpudding | Scheduled | 100 |  | Yes | 3 | [NAME] |  | [NAME] |  | Justin Time
24 | 2016-10-16 00:00:00 | 45077 | [NAME] | Coffee | No | 138 |  | No | 1 | [NAME] |  | - |  | -
25 | 2016-10-17 00:00:00 | 45078 | Dulwich | Meat Pies | Yes | 144 |  | Yes | 1 | [NAME] |  | - |  | -
 |  |  | [NAME] 1 |  | Drop Down 2
 |  |  | Employee ID | Name | Recovery Y/N
 |  |  | - | - | -
 |  |  |  | Anne Other | Yes
 |  |  |  | [NAME] | No
 |  |  |  | [NAME] | Scheduled
 |  |  |  | [NAME] | On Hold
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Ima Belle
 |  |  |  | Ima Dunce
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Justin Time
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | P, [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Shawn Deelear
 |  |  |  | [NAME]
 |  |  |  | [NAME]