Spreadsheet: 842074d1694147781-vlookup-index-match-spill-error-for_excelforum_
Sheet: Data

2023-2024 |  |  |  |  |  |  |  |  | 2022-2023 |  |  |  |  |  |  |  |  | 2021-2022 |  |  |  |  |  |  |  |  | 2020-2021 |  |  |  |  |  |  |  |  | 2019-2020
Week Number | Week Beginning | KPI 1 (100% High) | [NAME] (100 % Moderate) | KPI3a (50% Grape) | KPI3b (50% Tomato) | [NAME] (100% Produce Treatment) | KPI 5 (Freshmax) | KPI 5 (Robinsons) | Week Number | Week Beginning | KPI 1 (100% High) | [NAME] (100 % Moderate) | KPI3a (50% Grape) | KPI3b (50% Tomato) | [NAME] (100% Produce Treatment) | KPI 5 (Freshmax) | KPI 5 (Robinsons) | Week Number | Week Beginning | KPI 1 (100% High) | [NAME] (100 % Moderate) | KPI3a (50% Grape) | KPI3b (50% Tomato) | [NAME] (100% Produce Treatment) | KPI 5 (Freshmax) | KPI 5 (Robinsons) | Week Number | Week Beginning | KPI 1 (100% High) | [NAME] (100 % Moderate) | KPI3a (50% Grape) | KPI3b (50% Tomato) | [NAME] (100% Produce Treatment) | KPI 5 (Freshmax) | KPI 5 (Robinsons) | Week Number | Week Beginning | KPI 1 (100% High) | [NAME] (100 % Moderate) | KPI3a (50% Grape) | KPI3b (50% Tomato) | [NAME] (100% Produce Treatment) | KPI 5 (Freshmax) | KPI 5 (Robinsons)
Week 01 | 2023-10-02 00:00:00 | 0.1 | 0.11 | 0.21 | 0.22 | 0.23 | 0.24 | 0.25 | Week 01 | 3/10/2022 | 1 | 0.95 | 0.64 | 0.95 | 0.83 | 0.78 | 0.89 | Week 01 | 4/10/2021 | 1 | 0.94 | 0.75 | 0.94 | 1 | 0.67 | 1 | Week 01 | 28/09/2020 | 0.75 | 0.53 | 0.4 | 0.75 | 0.67 | 1 | 0.75 | Week 01 | 2019-09-30 00:00:00 | 0.64 | 0.48 | 1 | 0.6 | 0.67
Week 02 | 2023-10-09 00:00:00 | 0.2 | 0.21 | 0.22 | 0.23 | 0.24 | 0.25 | 0.26 | Week 02 | 10/10/2022 | 1 | 0.94 | 0.5 | 0.93 | 1 | 1 | 1 | Week 02 | 11/10/2021 | 1 | 0.94 | 0.75 | 0.75 | 1 | 1 | 1 | Week 02 | 5/10/2020 | 0.71 | 0.73 | 0.7 | 0.79 | 0.67 | 0.67 | 1 | Week 02 | 2019-10-07 00:00:00 | 0.83 | 0.51 | 1 | 0.65 | 0.67
Week 03 | 2023-10-16 00:00:00 | 0.3 | 0.31 | 0.32 | 0.33 | 0.34 | 0.35 | 0.36 | Week 03 | 17/10/2022 | 1 | 0.96 | 0.69 | 0.94 | 1 | 0.93 | 1 | Week 03 | 18/10/2021 | 1 | 0.98 | 1 | 0.95 | 1 | 1 | 1 | Week 03 | 12/10/2020 | 0.92 | 0.89 | 0.75 | 0.82 | 0.67 | 0.67 | 1 | Week 03 | 2019-10-14 00:00:00 | 0.8 | 0.47 | 1 | 0.52 | 0.67
Week 04 | 2023-10-23 00:00:00 | 0.4 | 0.41 | 0.42 | 0.43 | 0.44 | 0.45 | 0.46 | Week 04 | 24/10/2022 | 0.9 | 0.89 | 0.5 | 0.89 | 0.93 | 1 | 0.86 | Week 04 | 25/10/2021 | 1 | 0.98 | 0.64 | 0.95 | 1 | 1 | 1 | Week 04 | 19/10/2020 | 0.98 | 0.86 | 0.56 | 0.74 | 1 | 1 | 1 | Week 04 | 2019-10-21 00:00:00 | 0.8 | 0.53 | 0.5 | 0.63 | 0.67
Week 05 | 2023-10-30 00:00:00 | 0.5 | 0.51 | 0.52 | 0.53 | 0.54 | 0.55 | 0.56 | Week 05 | 31/10/2022 | 1 | 0.91 | 0.64 | 0.86 | 1 | 1 | 1 | Week 05 | 1/11/2021 | 0.93 | 0.89 | 0.45 | 0.86 | 1 | 1 | 1 | Week 05 | 26/10/2020 | 0.88 | 0.81 | 0.73 | 0.77 | 0.75 | 0.75 | 1 | Week 05 | 2019-10-28 00:00:00 | 0.85 | 0.39 | 0 | 0.53 | 0.67
Week 06 | 2023-11-06 00:00:00 | 0.6 | 0.61 | 0.62 | 0.63 | 0.64 | 0.65 | 0.66 | Week 06 | 7/11/2022 | 0.96 | 0.97 | 0.56 | 0.93 | 1 | 1 | 1 | Week 06 | 8/11/2021 | 0.97 | 0.88 | 0.67 | 0.91 | 1 | 0.67 | 1 | Week 06 | 2/11/2020 | 0.89 | 0.81 | 0.3 | 0.73 | 1 | 0.75 | 1 | Week 06 | 2019-11-04 00:00:00 | 0.76 | 0.61 | 0 | 0.79 | 1
Week 07 | 2023-11-13 00:00:00 | 0.7 | 0.71 | 0.72 | 0.73 | 0.74 | 0.75 | 0.76 | Week 07 | 14/11/2022 | 1 | 0.89 | 0.5 | 0.85 | 0.93 | 0.86 | 1 | Week 07 | 15/11/2021 | 1 | 0.9 | 0.6 | 0.6 | 1 | 1 | 1 | Week 07 | 9/11/2020 | 0.91 | 0.72 | 0.7 | 0.75 | 1 | 0.75 | 1 | Week 07 | 2019-11-11 00:00:00 | 0.74 | 0.66 | 0.33 | 0.79 | 1
Week 08 | 2023-11-20 00:00:00 | 0.8 | 0.81 | 0.82 | 0.83 | 0.84 | 0.85 | 0.86 | Week 08 | 21/11/2022 | 1 | 0.9 | 0.7 | 0.93 | 1 | 0.94 | 0.93 | Week 08 | 22/11/2021 | 0.99 | 0.98 | 0.7 | 0.7 | 1 | 1 | 1 | Week 08 | 16/11/2020 | 0.82 | 0.72 | 0.56 | 0.7 | 1 | 0.75 | 1 | Week 08 | 2019-11-18 00:00:00 | 0.8 | 0.63 | 0.86 | 0.68 | 1
Week 09 | 2023-11-27 00:00:00 | 0.9 | 0.91 | 0.92 | 0.93 | 0.94 | 0.95 | 0.96 | Week 09 | 28/11/2022 | 0.99 | 0.81 | 0.63 | 0.78 | 1 | 1 | 1 | Week 09 | 29/11/2021 | 1 | 0.86 | 0.7 | 0.88 | 1 | 0.67 | 1 | Week 09 | 23/11/2020 | 0.83 | 0.7 | 0.75 | 0.71 | 1 | 0.75 | 0.75 | Week 09 | 2019-11-25 00:00:00 | 0.8 | 0.61 | 0.67 | 0.77 | 0.9
Week 10 | 2023-12-04 00:00:00 |  |  |  |  |  |  |  | Week 10 | 5/12/2022 | 1 | 0.9 | 0.64 | 0.86 | 1 | 1 | 1 | Week 10 | 6/12/2021 | 0.97 | 0.92 | 0.83 | 0.93 | 1 | 1 | 1 | Week 10 | 30/11/2020 | 0.61 | 0.38 | 0.44 | 0.31 | 0.75 | 0.75 | 1 | Week 10 | 2019-12-02 00:00:00 | 0.87 | 0.69 | 0.71 | 0.76 | 1
Week 11 | 2023-12-11 00:00:00 |  |  |  |  |  |  |  | Week 11 | 12/12/2022 | 0.99 | 0.86 | 0.46 | 0.92 | 0.93 | 1 | 0.86 | Week 11 | 13/12/2021 | 0.99 | 0.94 | 0.67 | 0.86 | 1 | 1 | 1 | Week 11 | 7/12/2020 | 0.66 | 0.44 | 0.14 | 0.43 | 1 | 0.75 | 0.75 | Week 11 | 2019-12-09 00:00:00 | 0.9 | 0.76 | 0.88 | 0.72 | 1
Week 12 | 2023-12-18 00:00:00 |  |  |  |  |  |  |  | Week 12 | 19/12/2022 | 0.89 | 0.81 | 0.75 | 0.8 | 1 | 1 | 1 | Week 12 | 20/12/2021 | 0.95 | 0.85 | 0.58 | 0.85 | 1 | 1 | 1 | Week 12 | 14/12/2020 | 0.37 | 0.24 | 0 | 0.2 | 0.75 | 0.75 | 0.75 | Week 12 | 2019-12-16 00:00:00 | 0.87 | 0.72 | 0.38 | 0.65 | 1
Week 13 | 2023-12-25 00:00:00 |  |  |  |  |  |  |  | Week 13 | 26/12/2022 | 0.99 | 0.78 | 0.67 | 0.85 | 0.88 | 0.81 | 0.88 | Week 13 | 27/12/2021 | 0.96 | 0.85 | 0.67 | 0.86 | 1 | 0.67 | 0.75 | Week 13 | 21/12/2020 | 0.35 | 0.14 | 0.33 | 0.12 | 0.75 | 0.75 | 1 | Week 13 | 2019-12-23 00:00:00 | 0.86 | 0.57 | 0.25 | 0.49 | 1
Week 14 | 2024-01-01 00:00:00 |  |  |  |  |  |  |  | Week 14 | 2/01/2023 | 1 | 0.87 | 0.33 | 0.86 | 1 | 1 | 1 | Week 14 | 3/01/2022 | 0.98 | 0.85 | 0.61 | 0.82 | 1 | 0.67 | 1 | Week 14 | 28/12/2020 | 0.33 | 0.17 | 0.33 | 0.11 | 0.75 | 0.33 | 0.25 | Week 14 | 2019-12-30 00:00:00 | 0.87 | 0.6 | 0.58 | 0.67 | 1
Week 15 | 2024-01-08 00:00:00 |  |  |  |  |  |  |  | Week 15 | 9/01/2023 | 0.99 | 0.81 | 0.54 | 0.77 | 0.93 | 1 | 0.86 | Week 15 | 10/01/2022 | 0.98 | 0.85 | 0.52 | 0.81 | 1 | 1 | 1 | Week 15 | 4/01/2021 | 0.43 | 0.37 | 0.38 | 0.35 | 0.75 | 0.33 | 0.75 | Week 15 | 2020-01-06 00:00:00 | 0.99 | 0.74 | 0.75 | 0.77 | 1
Week 16 | 2024-01-15 00:00:00 |  |  |  |  |  |  |  | Week 16 | 16/01/2023 | 0.85 | 0.86 | 0.62 | 0.86 | 0.93 | 1 | 0.86 | Week 16 | 17/01/2022 | 0.97 | 0.92 | 0.46 | 0.84 | 1 | 1 | 0.67 | Week 16 | 11/01/2021 | 0.63 | 0.61 | 0.56 | 0.59 | 1 | 0.66 | 1 | Week 16 | 2020-01-13 00:00:00 | 1 | 0.72 | 0.57 | 0.73 | 1
Week 17 | 2024-01-22 00:00:00 |  |  |  |  |  |  |  | Week 17 | 23/01/2023 | 0.91 | 0.77 | 0.59 | 0.82 | 0.93 | 0.86 | 0.86 | Week 17 | 24/01/2022 | 0.94 | 0.77 | 0.56 | 0.86 | 1 | 1 | 1 | Week 17 | 18/01/2021 | 0.65 | 0.43 | 0.43 | 0.41 | 0.75 | 0.33 | 1 | Week 17 | 2020-01-20 00:00:00 | 0.98 | 0.79 | 0.71 | 0.98 | 1
Week 18 | 2024-01-29 00:00:00 |  |  |  |  |  |  |  | Week 18 | 30/01/2023 | 1 | 0.85 | 0.48 | 0.9 | 0.93 | 0.93 | 0.86 | Week 18 | 31/01/2022 | 0.97 | 0.83 | 0.68 | 0.85 | 1 | 0.67 | 1 | Week 18 | 25/01/2021 | 0.82 | 0.62 | 0.55 | 0.71 | 1 | 1 | 1 | Week 18 | 2020-01-27 00:00:00 | 0.94 | 0.75 | 0.88 | 0.82 | 1
Week 19 | 2024-02-05 00:00:00 |  |  |  |  |  |  |  | Week 19 | 6/02/2023 | 0.97 | 0.88 | 0.68 | 0.9 | 0.93 | 0.95 | 0.86 | Week 19 | 7/02/2022 | 0.98 | 0.91 | 0.69 | 0.88 | 1 | 1 | 1 | Week 19 | 1/02/2021 | 0.77 | 0.57 | 0.58 | 0.65 | 1 | 0.75 | 0.75 | Week 19 | 2020-02-03 00:00:00 | 1 | 0.9 | 0.74 | 0.78 | 1
Week 20 | 2024-02-12 00:00:00 |  |  |  |  |  |  |  | Week 20 | 13/02/2023 | 0.96 | 0.93 | 0.58 | 0.93 | 1 | 1 | 1 | Week 20 | 2022-02-14 00:00:00 | 0.98 | 0.92 | 0.56 | 0.91 | 1 | 1 | 1 | Week 20 | 8/02/2021 | 0.84 | 0.53 | 0.61 | 0.45 | 0.75 | 0.75 | 0.75 | Week 20 | 2020-02-10 00:00:00 | 1 | 0.79 | 0.85 | 0.71 | 1
Week 21 | 2024-02-19 00:00:00 |  |  |  |  |  |  |  | Week 21 | 20/02/2023 | 0.98 | 0.9 | 0.59 | 0.88 | 0.93 | 0.86 | 0.93 | Week 21 | 21/02/2022 | 1 | 0.89 | 0.59 | 0.91 | 1 | 1 | 1 | Week 21 | 15/02/2021 | 0.83 | 0.53 | 0.46 | 0.54 | 1 | 1 | 1 | Week 21 | 2020-02-17 00:00:00 | 0.95 | 0.71 | 0.8 | 0.73 | 1
Week 22 | 2024-02-26 00:00:00 |  |  |  |  |  |  |  | Week 22 | 27/02/2023 | 0.98 | 1 | 0.57 | 0.93 | 0.94 | 0.88 | 1 | Week 22 | 28/02/2022 | 0.99 | 0.81 | 0.5 | 0.78 | 1 | 1 | 1 | Week 22 | 22/02/2021 | 0.96 | 0.86 | 0.86 | 0.86 | 1 | 1 | 0.75 | Week 22 | 2020-02-24 00:00:00 | 1 | 0.86 | 0.88 | 0.82 | 1
Week 23 | 2024-03-04 00:00:00 |  |  |  |  |  |  |  | Week 23 | 6/03/2023 | 1 | 0.94 | 0.53 | 0.9 | 0.93 | 1 | 0.86 | Week 23 | 7/03/2022 | 0.99 | 0.91 | 0.72 | 0.81 | 1 | 1 | 1 | Week 23 | 1/03/2021 | 0.87 | 0.74 | 0.73 | 0.69 | 1 | 1 | 1 | Week 23 | 2020-03-02 00:00:00 | 0.96 | 0.88 | 0.86 | 0.89 | 1
Week 24 | 2024-03-11 00:00:00 |  |  |  |  |  |  |  | Week 24 | 13/03/2023 | 1 | 0.95 | 0.64 | 0.91 | 1 | 1 | 1 | Week 24 | 14/03/2022 | 1 | 0.87 | 0.63 | 0.91 | 1 | 1 | 0.75 | Week 24 | 8/03/2021 | 0.93 | 0.74 | 0.86 | 0.9 | 1 | 1 | 1 | Week 24 | 2020-03-09 00:00:00 | 1 | 0.95 | 1 | 0.98 | 1
Week 25 | 2024-03-18 00:00:00 |  |  |  |  |  |  |  | Week 25 | 20/03/2023 | 0.93 | 0.92 | 0.59 | 0.85 | 0.93 | 0.86 | 0.86 | Week 25 | 21/03/2022 | 1 | 0.87 | 0.58 | 0.79 | 1 | 1 | 1 | Week 25 | 15/03/2021 | 0.94 | 0.93 | 0.96 | 0.92 | 1 | 1 | 1 | Week 25 | 2020-03-16 00:00:00 | 0.95 | 0.93 | 0.86 | 0.91 | 1
Week 26 | 2024-03-25 00:00:00 |  |  |  |  |  |  |  | Week 26 | 27/03/2023 | 1 | 0.98 | 0.67 | 1 | 1 | 1 | 1 | Week 26 | 28/03/2022 | 1 | 0.91 | 0.43 | 0.82 | 1 | 1 | 1 | Week 26 | 22/03/2021 | 0.92 | 0.83 | 0.92 | 0.86 | 1 | 1 | 0.75 | Week 26 | 2020-03-23 00:00:00 | 1 | 0.93 | 0.96 | 0.89 | 1
Total |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  | Total |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | Checked |  |  |  |  |  |  |  |  | Checked |  |  |  |  |  |  |  |  | Checked |  |  |  |  |  |  |  |  | Checked |  |  |  |  |  |  | Not broken down into providers