Spreadsheet: 873942d1720536970-tables-showing-most-recent-data-top-charts
Sheet: Aim

 | Data Set |  |  |  |  |  | Desired tables
 | Name | Date | Result |  |  |  | Top 3 People | Results (Last 5) | Results (All Time) | # runs |  | This column is showing the average result for the associated person over the most recent 5 dates for that person. So the date range for person 3 is differnet to person 1. if there are less than 5 results, then it just shows the average of what results are availible. Who appears in the table is based on these numbers - i.e. only the top 3 in this range appear.
 | Person 1 | 2023-12-18 00:00:00 | 94 |  |  |  | Person 1 | 93.4 | 93.7
 | Person 1 | 2023-12-14 00:00:00 | 94 |  |  |  | Person 3 | 93.2 | 93.6
 | Person 1 | 2023-11-19 00:00:00 | 93 |  |  |  | Person 5 | 93 | 93
 | Person 1 | 2023-11-13 00:00:00 | 93
 | Person 2 | 2024-03-01 00:00:00 | 60 |  |  |  | Bottom 3 People | Results (Last 5) | Results (All Time) | # runs
 | Person 2 | 2024-02-29 00:00:00 | 91 |  |  |  | Person 4 | 89.5 | 76.2
 | Person 2 | 2024-02-28 00:00:00 | 91 |  |  |  | Person 2 | 90.8 | 85.4
 | Person 2 | 2024-02-23 00:00:00 | 92 |  |  |  | Person 6 | 92.7 | 92.8 |  |  | This column is showing the overall average result for the person. Which results are shown is depndant on which people are selected by the data from the Last 5 result column (i.e. these might not be the maximum results across the total data set)
 | Person 2 | 2024-02-12 00:00:00 | 93
 | Person 2 | 2024-02-10 00:00:00 | 95
 | Person 2 | 2024-02-10 00:00:00 | 55
 | Person 2 | 2024-02-09 00:00:00 | 92
 | Person 2 | 2024-02-08 00:00:00 | 93
 | Person 2 | 2024-02-04 00:00:00 | 95
 | Person 2 | 2024-01-28 00:00:00 | 93
 | Person 2 | 2024-01-28 00:00:00 | 98 |  |  |  |  |  |  |  |  | This is a count of the number of entries in total for the person
 | Person 2 | 2024-01-20 00:00:00 | 95
 | Person 2 | 2024-01-17 00:00:00 | 92
 | Person 2 | 2024-01-16 00:00:00 | 93
 | Person 2 | 2024-01-11 00:00:00 | 91
 | Person 3 | 2024-02-04 00:00:00 | 91
 | Person 3 | 2024-01-16 00:00:00 | 92
 | Person 3 | 2023-12-24 00:00:00 | 94
 | Person 3 | 2023-11-26 00:00:00 | 94 |  |  |  |  |  |  |  |  | This table is the same, its just picking the lowest 3 results and sorting low to high
 | Person 3 | 2023-08-12 00:00:00 | 95
 | Person 4 | 2024-02-17 00:00:00 | 92
 | Person 4 | 2024-01-31 00:00:00 | 94
 | Person 4 | 2024-01-24 00:00:00 | 95
 | Person 4 | 2023-11-10 00:00:00 | 6
 | Person 4 | 2023-10-21 00:00:00 | 94
 | Person 6 | 2024-02-01 00:00:00 | 93
 | Person 6 | 2024-01-28 00:00:00 | 92 |  |  |  |  |  |  |  |  | Working tab is just showing how the numbers in the table are calculated - im after a means of automating this
 | Person 3 | 2023-07-24 00:00:00 | 91
 | Person 6 | 2024-01-20 00:00:00 | 95
 | Person 1 | 2023-10-09 00:00:00 | 93
 | Person 1 | 2023-08-10 00:00:00 | 95
 | Person 1 | 2023-08-09 00:00:00 | 92
 | Person 1 | 2023-08-03 00:00:00 | 94
 | Person 1 | 2023-07-23 00:00:00 | 94
 | Person 1 | 2023-07-05 00:00:00 | 95
 | Person 1 | 2023-06-23 00:00:00 | 93
 | Person 2 | 2024-01-11 00:00:00 | 95
 | Person 2 | 2024-01-02 00:00:00 | 91
 | Person 2 | 2024-01-01 00:00:00 | 92
 | Person 2 | 2023-12-31 00:00:00 | 93
 | Person 2 | 2023-12-30 00:00:00 | 94
 | Person 2 | 2023-12-24 00:00:00 | 91
 | Person 2 | 2023-12-24 00:00:00 | 95
 | Person 2 | 2023-12-24 00:00:00 | 91
 | Person 2 | 2023-12-23 00:00:00 | 95
 | Person 2 | 2023-12-22 00:00:00 | 61
 | Person 2 | 2023-12-14 00:00:00 | 94
 | Person 2 | 2023-12-12 00:00:00 | 94
 | Person 3 | 2023-06-20 00:00:00 | 94
 | Person 4 | 2023-10-10 00:00:00 | 92
 | Person 4 | 2023-10-02 00:00:00 | 94
 | Person 4 | 2023-09-24 00:00:00 | 91
 | Person 5 | 2023-12-06 00:00:00 | 92
 | Person 6 | 2023-12-29 00:00:00 | 91
 | Person 1 | 2023-06-23 00:00:00 | 92
 | Person 1 | 2023-06-06 00:00:00 | 95
 | Person 2 | 2023-12-10 00:00:00 | 95
 | Person 2 | 2023-11-30 00:00:00 | 94
 | Person 2 | 2023-11-28 00:00:00 | 94
 | Person 2 | 2023-11-23 00:00:00 | 94
 | Person 2 | 2023-11-18 00:00:00 | 92
 | Person 2 | 2023-11-12 00:00:00 | 91
 | Person 2 | 2023-11-09 00:00:00 | 93
 | Person 2 | 2023-11-02 00:00:00 | 93
 | Person 2 | 2023-10-29 00:00:00 | 91
 | Person 2 | 2023-10-26 00:00:00 | 95
 | Person 2 | 2023-10-25 00:00:00 | 92
 | Person 2 | 2023-10-23 00:00:00 | 95
 | Person 2 | 2023-10-18 00:00:00 | 93
 | Person 2 | 2023-10-15 00:00:00 | 93
 | Person 2 | 2023-10-12 00:00:00 | 92
 | Person 2 | 2023-10-11 00:00:00 | 92
 | Person 2 | 2023-10-11 00:00:00 | 93
 | Person 2 | 2023-09-30 00:00:00 | 91
 | Person 2 | 2023-09-24 00:00:00 | 94
 | Person 2 | 2023-09-20 00:00:00 | 93
 | Person 2 | 2023-09-11 00:00:00 | 91
 | Person 2 | 2023-09-06 00:00:00 | 95
 | Person 2 | 2023-09-03 00:00:00 | 95
 | Person 2 | 2023-09-01 00:00:00 | 94
 | Person 4 | 2023-09-01 00:00:00 | 95
 | Person 6 | 2023-12-18 00:00:00 | 93
 | Person 6 | 2023-11-07 00:00:00 | 95
 | Person 4 | 2023-08-26 00:00:00 | 94
 | Person 5 | 2023-05-28 00:00:00 | 94
 | Person 1 | 2023-05-27 00:00:00 | 92
 | Person 1 | 2023-05-20 00:00:00 | 95
 | Person 2 | 2023-08-27 00:00:00 | 94
 | Person 2 | 2023-08-19 00:00:00 | 91
 | Person 2 | 2023-08-17 00:00:00 | 93
 | Person 2 | 2023-08-16 00:00:00 | 30
 | Person 2 | 2023-08-14 00:00:00 | 93
 | Person 2 | 2023-08-12 00:00:00 | 95
 | Person 2 | 2023-08-08 00:00:00 | 91
 | Person 2 | 2023-08-07 00:00:00 | 92
 | Person 2 | 2023-08-06 00:00:00 | 92
 | Person 2 | 2023-08-05 00:00:00 | 92
 | Person 2 | 2023-08-02 00:00:00 | 92
 | Person 2 | 2023-08-01 00:00:00 | 93
 | Person 2 | 2023-07-30 00:00:00 | 95
 | Person 2 | 2023-07-23 00:00:00 | 93
 | Person 2 | 2023-07-21 00:00:00 | 93
 | Person 2 | 2023-07-20 00:00:00 | 92
 | Person 2 | 2023-07-16 00:00:00 | 91
 | Person 2 | 2023-07-14 00:00:00 | 91
 | Person 2 | 2023-07-13 00:00:00 | 95
 | Person 3 | 2023-06-16 00:00:00 | 95
 | Person 4 | 2023-08-19 00:00:00 | 94
 | Person 4 | 2023-08-13 00:00:00 | 91
 | Person 4 | 2023-07-25 00:00:00 | 94
 | Person 4 | 2023-06-17 00:00:00 | 94
 | Person 2 | 2023-07-08 00:00:00 | 95
 | Person 1 | 2023-05-11 00:00:00 | 91
 | Person 2 | 2023-07-06 00:00:00 | 94
 | Person 2 | 2023-07-06 00:00:00 | 93
 | Person 2 | 2023-07-05 00:00:00 | 95
 | Person 2 | 2023-07-03 00:00:00 | 91
 | Person 2 | 2023-06-30 00:00:00 | 92
 | Person 2 | 2023-06-24 00:00:00 | 95
 | Person 2 | 2023-06-15 00:00:00 | 94
 | Person 2 | 2023-06-10 00:00:00 | 93
 | Person 2 | 2023-06-09 00:00:00 | 95
 | Person 2 | 2023-06-06 00:00:00 | 93
 | Person 2 | 2023-06-03 00:00:00 | 95
 | Person 2 | 2023-06-03 00:00:00 | 91
 | Person 3 | 2023-06-09 00:00:00 | 94
 | Person 3 | 2023-04-15 00:00:00 | 95
 | Person 3 | 2023-03-03 00:00:00 | 95
 | Person 4 | 2023-06-01 00:00:00 | 94
 | Person 4 | 2023-05-17 00:00:00 | 93
 | Person 4 | 2023-04-19 00:00:00 | 93
 | Person 4 | 2023-04-08 00:00:00 | 92
 | Person 4 | 2023-04-02 00:00:00 | 95
 | Person 6 | 2023-08-17 00:00:00 | 95
 | Person 1 | 2023-05-10 00:00:00 | 95
 | Person 1 | 2023-05-06 00:00:00 | 95
 | Person 1 | 2023-03-23 00:00:00 | 95
 | Person 2 | 2023-06-03 00:00:00 | 95
 | Person 2 | 2023-05-31 00:00:00 | 91
 | Person 2 | 2023-05-26 00:00:00 | 30
 | Person 2 | 2023-05-10 00:00:00 | 93
 | Person 2 | 2023-05-08 00:00:00 | 92
 | Person 2 | 2023-05-06 00:00:00 | 91
 | Person 2 | 2023-04-30 00:00:00 | 91
 | Person 2 | 2023-04-29 00:00:00 | 95
 | Person 2 | 2023-04-28 00:00:00 | 91
 | Person 2 | 2023-04-23 00:00:00 | 93
 | Person 2 | 2023-04-12 00:00:00 | 94
 | Person 2 | 2023-04-11 00:00:00 | 93
 | Person 2 | 2023-04-09 00:00:00 | 91
 | Person 2 | 2023-04-08 00:00:00 | 92
 | Person 2 | 2023-04-05 00:00:00 | 95
 | Person 2 | 2023-03-30 00:00:00 | 95
 | Person 2 | 2023-03-30 00:00:00 | 91
 | Person 2 | 2023-03-27 00:00:00 | 91
 | Person 2 | 2023-03-17 00:00:00 | 95
 | Person 2 | 2023-03-11 00:00:00 | 93
 | Person 2 | 2023-03-06 00:00:00 | 91
 | Person 4 | 2023-03-31 00:00:00 | 94
 | Person 4 | 2023-03-20 00:00:00 | 95
 | Person 4 | 2023-03-18 00:00:00 | 93
 | Person 6 | 2023-07-01 00:00:00 | 91
 | Person 6 | 2023-05-14 00:00:00 | 92
 | Person 6 | 2023-05-11 00:00:00 | 91
 | Person 6 | 2023-05-10 00:00:00 | 92